Summary
Overview
Work History
Education
Skills
Certification
Projects
References
Timeline
Generic

Abdul Rehman

New York,NY

Summary

Results-driven data analyst with expertise in Python, SQL, and advanced Excel. Skilled in predictive modeling, data visualization, and leveraging insights to drive business growth. Proven track record in enhancing data accuracy, improving forecasting models, and extracting actionable insights from complex datasets. Adept at transforming data into strategic recommendations and collaborating with teams to boost efficiency and decision-making.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Technology Consultant

OneAdvanced
2022.06 - 2024.03
  • Managed and supported suite of legal software, engaging with clients to understand their needs and advising on how to stay current with technology and market trends.
  • Conducted customer churn analysis to identify key reasons and characteristics of clients leaving, leading to 20% reduction in churn through targeted retention strategies.
  • Performed exploratory data analysis (EDA) using Python's Pandas to determine the most effective marketing campaign mediums, optimizing resource allocation and increasing lead generation by 25%.
  • Analyzed various prospecting methods to identify the most effective strategies for the business development team, resulting in a 30% improvement in lead conversion rates.
  • Utilized Python for web scraping to gather information from publicly available sources, generating 15% increase in qualified leads.
  • Provided actionable insights and data-driven recommendations to enhance client engagement and improve overall software adoption.
  • Collaborated closely with the marketing and business development teams to align strategies with data-driven findings, improving campaign effectiveness and lead quality.
  • Developed and implemented custom data visualization solutions to present complex data insights in an accessible manner, aiding strategic decision-making.
  • Integrated advanced analytics solutions with existing systems, ensuring seamless data flow and improved reporting capabilities.
  • Monitored and evaluated key performance indicators (KPIs) to assess the impact of data-driven initiatives and adjusted strategies as needed for optimal results.
  • Spearheaded a project to automate data collection and reporting processes, reducing manual effort and increasing data accuracy and timeliness.

Data Analyst

Sam Carpets
2022.02 - 2022.07
  • Ensured the accuracy and integrity of data across various systems, including sales, inventory, and customer databases, for products such as carpets, floorings, and bathroom items.
  • Conducted regular data audits and validations to identify and correct discrepancies, maintaining high standards of data quality.
  • Implemented data cleaning processes to standardize and correct records, reducing data entry errors and improving system reliability.
  • Created comprehensive data reports and summaries to assist management in understanding sales trends and inventory levels.
  • Provided training and support to team members on data entry best practices, enhancing overall data accuracy and system efficiency.

Supply Chain Analyst

Fauji Foods Limited
2019.08 - 2020.12
  • Used SQL queries to extract and analyze data from MySQL databases, optimizing stock levels and reducing waste for dairy and juice products.
  • Improved inventory turnover by 20% through data-driven analysis, identifying and addressing inefficiencies in the supply chain.
  • Created Excel reports and dashboards to track KPIs such as Supplier Lead Time and Production Yield, enhancing real-time monitoring and decision-making.
  • Enhanced demand forecasting accuracy by 25% with a time series regression model.
  • Achieved a 15% decrease in procurement expenses through improved demand planning and supplier negotiations.
  • Reduced waste and scrap rates by analyzing production data, using Excel to identify and resolve production bottlenecks.
  • Provided actionable recommendations to senior management, leveraging insights from SQL and Excel to support strategic decisions and improve performance.

Education

Master of Science - Business Management And Analytics

University of Aberdeen
Aberdeen, United Kingdom
02.2022

Bachelor of Science - Management Science

Lahore University of Management Sciences
Lahore, Pakistan
05.2019

Skills

  • Data Analysis
  • Machine Learnin
  • Predictive Modeling
  • Python(Pandas,NumPy,Scikit-learn)
  • Web Scraping(BeautifulSoup,Requests)
  • SQL (MS SQL Server, Oracle, MySQL)
  • R Programming
  • Advanced Microsoft Excel
  • Data Preprocessing
  • Feature Engineering
  • Data Visualization
  • Data Wrangling
  • Statistical Analysis
  • PowerBi/Tableau

Certification

  • Microsoft Excel - ADVANCED Certificate | Reed.co.uk
  • Google Data Analytics Certificate | Google
  • SQL for Data Science | University of California, Davis
  • Python for Data Science, AI, and Development | IBM
  • Python Programming | University of Helsinki
  • Google Advanced Data Analytics | Google
  • Supervised Machine Learning: Regression and Classification | Stanford University
  • Python programming CS50P | Harvard University
  • Advanced Learning Algorithms | Stanford University
  • Introduction to Computer Science CS50X | Harvard University

Projects

  • Customer Churn Analysis - EDA and Logistics Regression.

Conducted a comprehensive churn analysis for a telecommunications company using Python (Pandas, NumPy, Matplotlib), employing univariate and bivariate analysis to identify key customer characteristics, and developed a high-accuracy predictive neural network model (Tensorflow, Keras) to provide strategic recommendations based on findings.

  • Bitcoin Price Movement - Sentiment Analysis & Xgboost.

Extracted Bitcoin data using Python (Mwclient, Yfinance) and conducted predictive analysis with XBoost, achieving 70% accuracy in forecasting price movements through feature engineering.

  • E-Commerce Marketplace Analysis - Using Web Scraping to Identify Profitable Product Opportunities.

Scraped and analyzed product trends on Daraz(Pakistan's largest e-commerce platform) using Python (BeautifulSoup, Requests) to provide actionable insights for product selection, aiding in strategic decision-making.

  • Traffic Sign Recognition System - using Convoluted Neural Networks.

Developed a traffic sign recognition system using CNNs in Python (Keras, TensorFlow), achieving 96% accuracy and surpassing standard neural network performance.

  • Customer Segmentation Using K-Means.

Performed K-means clustering on customer data using Python (Pandas, Scikit-learn, Matplotlib) to identify distinct segments, analyze behavior patterns, and develop targeted marketing strategies, enhancing customer retention and acquisition efforts.

  • Used Car Price Prediction - Polynomial Regression.

Developed a polynomial regression model to predict used car prices with over 92% accuracy using Python (Pandas, NumPy, Scikit-learn) for data pre-processing and model training, implemented feature engineering techniques, and provided actionable insights for pricing strategies and market analysis.

  • Steel Plate Defect Detection - Random Forest Classifier.

Used a Random Forest Classifier with Python (Pandas, Scikit-learn) for data preprocessing, model training, and evaluation to detect defective steel plates with 88% accuracy, enhancing model accuracy through feature selection and engineering, and delivering insights to improve quality control processes in manufacturing.

References

References available on request.

Timeline

Technology Consultant

OneAdvanced
2022.06 - 2024.03

Data Analyst

Sam Carpets
2022.02 - 2022.07

Supply Chain Analyst

Fauji Foods Limited
2019.08 - 2020.12

Master of Science - Business Management And Analytics

University of Aberdeen

Bachelor of Science - Management Science

Lahore University of Management Sciences
  • Microsoft Excel - ADVANCED Certificate | Reed.co.uk
  • Google Data Analytics Certificate | Google
  • SQL for Data Science | University of California, Davis
  • Python for Data Science, AI, and Development | IBM
  • Python Programming | University of Helsinki
  • Google Advanced Data Analytics | Google
  • Supervised Machine Learning: Regression and Classification | Stanford University
  • Python programming CS50P | Harvard University
  • Advanced Learning Algorithms | Stanford University
  • Introduction to Computer Science CS50X | Harvard University
Abdul Rehman