Summary
Overview
Work History
Education
Skills
Projects
Employmenthistorydetails
Timeline
Generic
Fouad Akhtar

Fouad Akhtar

Senior Data Analyst
Roswell,GA

Summary

Detail-oriented Sr. Data Analyst with expertise in designing comprehensive reports, automating data workflows, and extracting actionable insights from complex datasets. Proficient in leveraging advanced Excel, SQL, and R to create meaningful metrics, validate data, and detect trends. Skilled in building automated reporting systems and developing interactive dashboards for clear and impactful data communication. Adept at exploring and integrating multiple data sources to inform strategic business decisions. Experienced in managing CRM systems, optimizing loyalty programs, and presenting insights through PowerPoint and oral presentations to drive business outcomes.

Overview

20
20
years of professional experience

Work History

Senior Data Analyst

Unique Wholesale ATL
1 2024
  • Data-Driven Reporting: Designed and implemented comprehensive reports using data derived from multiple sources, leveraging advanced Excel functions, SQL, and R to create meaningful metrics and validate findings
  • Automated reporting processes, eliminating manual cut-and-paste steps to streamline workflows
  • Exploratory Data Analysis: Conducted independent data exploration to identify trends, detect irregularities, and provide actionable insights
  • Built custom dashboards for KPI tracking and trend visualization using Tableau, ensuring data-driven decision-making across various departments
  • Automation & Tools: Developed automated browser scripts to analyze over 36,000 product records, improving inventory prediction accuracy
  • Created a barcode scanner using R for verifying product image uploads
  • Worked with data collection tools like Microsoft Forms and integrated systems for data consolidation
  • Reporting & Communication: Effectively communicated insights through flat reports, interactive dashboards, and presentations
  • Used PowerPoint and oral presentations to share findings with stakeholders, providing them with actionable business intelligence
  • Marketing & CRM Insights: Analyzed multi-million-dollar loyalty and customer marketing efforts, providing detailed reports and insights that influenced strategic marketing decisions
  • Managed CRM systems, improving the performance of loyalty programs through advanced analytics and targeting capabilities
  • Data Analysis & Web Development: Led data collection and reporting efforts by combining web scraping, statistical analysis, and predictive modeling
  • Developed and integrated Shopify web portals, including payment gateways and logistics services, enhancing business operations and e-commerce functionality
  • Data Analysis: Mastered data manipulation using R (dplyr, tidyverse), SQL to query and analyze large datasets to produce actionable reports
  • Strategic Analysis: Conducted ad hoc analyses with SQL and R (dplyr, data.table), providing strategic insights for management, guiding critical decisions
  • Data Visualization: Developed interactive dashboards using Tableau, Power BI, Shiny app, and ggplot2 in R to present complex data, supporting stakeholder decision-making
  • Business Intelligence: Proficient in using DAX to craft calculated columns and measures in Power BI, performing advanced calculations and aggregations
  • Also experienced in leveraging Tableau, SQL, and R for creating custom calculations, visualizations, and reports to drive business decisions.

Senior Data Analyst

Petsmarket
08.2017 - 11.2023
  • Data Analysis & Reporting: Data-Driven Reporting: Designed and implemented comprehensive reports using data derived from multiple sources, leveraging advanced Excel functions, SQL, and R to create meaningful metrics and validate findings
  • Automated reporting processes, eliminating manual cut-and-paste steps to streamline workflows
  • Exploratory Data Analysis: Conducted independent data exploration to identify trends, detect irregularities, and provide actionable insights
  • Built custom dashboards for KPI tracking and trend visualization using Tableau, ensuring data-driven decision-making across various departments
  • Automation & Tools: Developed automated browser scripts to analyze over 36,000 product records, improving inventory prediction accuracy
  • Created a barcode scanner using R for verifying product image uploads
  • Worked with data collection tools like Microsoft Forms and integrated systems for data consolidation
  • Reporting & Communication: Effectively communicated insights through flat reports, interactive dashboards, and presentations
  • Used PowerPoint and oral presentations to share findings with stakeholders, providing them with actionable business intelligence
  • Marketing & CRM Insights: Analyzed multi-million-dollar loyalty and customer marketing efforts, providing detailed reports and insights that influenced strategic marketing decisions
  • Managed CRM systems, improving the performance of loyalty programs through advanced analytics and targeting capabilities
  • Data Analysis & Web Development: Led data collection and reporting efforts by combining web scraping, statistical analysis, and predictive modeling
  • Developed and integrated Shopify web portals, including payment gateways and logistics services, enhancing business operations and e-commerce functionality
  • Data Analysis: Mastered data manipulation using R (dplyr, tidyverse), SQL to query and analyze large datasets to produce actionable reports
  • Strategic Analysis: Conducted ad hoc analyses with SQL and R (dplyr, data.table), providing strategic insights for management, guiding critical decisions
  • Data Visualization: Developed interactive dashboards using Tableau, Power BI, Shiny app, and ggplot2 in R to present complex data, supporting stakeholder decision-making
  • Business Intelligence: Proficient in using DAX to craft calculated columns and measures in Power BI, performing advanced calculations and aggregations
  • Also experienced in leveraging Tableau, SQL, and R for creating custom calculations, visualizations, and reports to drive business decisions.

Product Development Manager

ECOM Planners
09.2014 - 07.2018
  • Predictive Sales Model: Developed a multiple linear regression model using machine learning techniques in R to forecast revenue based on spending across Google Ads, Facebook Ads, and Instagram Ads
  • This model provided actionable insights for optimizing digital marketing budgets, enhancing strategy, and improving return on investment (ROI)
  • Customer Retention Analysis: Implemented statistical models using R (caret, randomForest) to reduce customer churn by 10%, enhancing retention rates
  • Sentiment Analysis on Social Media: Used the rtweet package to collect data from Twitter and performed sentiment analysis with sentimentr
  • Analyzed feedback as positive or negative, utilizing machine learning techniques to derive actionable insights
  • Developed and fine-tuned ad-hoc queries using R and Excel to meet unique business requirements, generating key insights that supported strategic decision-making and improved data-driven planning
  • Applied logistic regression techniques to analyze customer purchase patterns, enhancing marketing strategies and boosting conversion rates through improved customer targeting
  • Stock vs
  • Orders Analysis: Led a comprehensive analysis of monthly sales and stock updates for over 100 shops
  • Used R for data processing, generated personalized PDF reports using R Markdown, and communicated insights via email and WhatsApp to shop managers
  • Inventory Management Optimization: Leveraged predictive modeling techniques, including linear regression & time series forecasting (using R packages forecast and prophet), to accurately forecast demand
  • This approach led to a 20% reduction in inventory costs and significantly enhanced operational efficiency
  • Competitor Price Analysis & Scraping: Developed and deployed automated scraping tools using Python (BeautifulSoup, Selenium) and R (rvest, rselenium) to perform competitor price analysis
  • Extracted product pricing and related data from competitor websites, which was used to adjust pricing strategies, optimize product offerings, and enhance competitive positioning
  • This approach aimed to boost traffic and revenue by aligning internal pricing with market trends and improving overall business performance
  • Developed a Comprehensive Data Entry Automation System: Engineered an automation solution using R (rselenium) to optimize data entry workflows
  • The system launched a browser, performed automated logins to the backend admin portal, and navigated to the data entry interface
  • It systematically extracted product information-including product names, descriptions, pricing details, discounts, category and brand tags from Excel sheets and populated these fields in the admin system
  • The automation ran in a continuous loop, handling each record efficiently and reducing manual input significantly, thereby enhancing operational efficiency and accuracy
  • Platform & Application Development: Managed the development of e-commerce platforms and mobile applications, leading teams through the entire product lifecycle, from planning to deployment
  • Cross-Functional Collaboration: Worked closely with developers, designers, and marketing teams to deliver products on time, utilizing .NET, Angular, and React for backend and frontend development
  • Quality Assurance: Implemented automated testing and quality control strategies, ensuring high performance and meeting the needs of high-profile clients.

Regional Operation Manager

Talabat
04.2004 - 08.2014
  • Expansion & Operations Setup: Successfully expanded Talabat operations across KSA, Bahrain, UAE, Oman, and Qatar, leading operational setup and onboarding 1000+ restaurants
  • Sales Strategy & Client Relations: Developed sales and operational strategies that increased sales by 75% in the GCC region and improved client relationships
  • Team Leadership & Training: Led cross-functional teams, focusing on recruitment, training, and improving customer service efficiency, resulting in significant operational enhancements.

Education

BACHELOR OF COMPUTER SCIENCE -

Institute of Computer Sciences Lahore
03.1997 - 2 1999

GOOGLE DATA ANALYTICS PROFESSIONAL CERTIFICATE - undefined

01.2023 - 8 2023

MACHINE LEARNING ALGORITHMS WITH R IN BUSINESS ANALYTICS - undefined

06.2023 - 7 2023

HARNESSING THE POWER OF DATA WITH POWER BI - undefined

09.2023 - 10 2023

Skills

Data Visualization

Projects

PRODUCT DEVELOPMENT MANAGER, 09/01/14, 07/01/18, ECOM Planners, Kuwait City, Kuwait, Predictive Sales Model: Developed a multiple linear regression model using machine learning techniques in R to forecast revenue based on spending across Google Ads, Facebook Ads, and Instagram Ads. This model provided actionable insights for optimizing digital marketing budgets, enhancing strategy, and improving return on investment (ROI)., Customer Retention Analysis: Implemented statistical models using R (caret, randomForest) to reduce customer churn by 10%, enhancing retention rates., Sentiment Analysis on Social Media: Used the rtweet package to collect data from Twitter and performed sentiment analysis with sentimentr. Analyzed feedback as positive or negative, utilizing machine learning techniques to derive actionable insights., Developed and fine-tuned ad-hoc queries using R and Excel to meet unique business requirements, generating key insights that supported strategic decision-making and improved data-driven planning., Applied logistic regression techniques to analyze customer purchase patterns, enhancing marketing strategies and boosting conversion rates through improved customer targeting., Stock vs. Orders Analysis: Led a comprehensive analysis of monthly sales and stock updates for over 100 shops. Used R for data processing, generated personalized PDF reports using R Markdown, and communicated insights via email and WhatsApp to shop managers., Inventory Management Optimization: Leveraged predictive modeling techniques, including linear regression & time series forecasting (using R packages forecast and prophet), to accurately forecast demand. This approach led to a 20% reduction in inventory costs and significantly enhanced operational efficiency., Competitor Price Analysis & Scraping: Developed and deployed automated scraping tools using Python (BeautifulSoup, Selenium) and R (rvest, rselenium) to perform competitor price analysis. Extracted product pricing and related data from competitor websites, which was used to adjust pricing strategies, optimize product offerings, and enhance competitive positioning. This approach aimed to boost traffic and revenue by aligning internal pricing with market trends and improving overall business performance., Developed a Comprehensive Data Entry Automation System: Engineered an automation solution using R (rselenium) to optimize data entry workflows. The system launched a browser, performed automated logins to the backend admin portal, and navigated to the data entry interface. It systematically extracted product information-including product names, descriptions, pricing details, discounts, category and brand tags from Excel sheets and populated these fields in the admin system. The automation ran in a continuous loop, handling each record efficiently and reducing manual input significantly, thereby enhancing operational efficiency and accuracy., Platform & Application Development: Managed the development of e-commerce platforms and mobile applications, leading teams through the entire product lifecycle, from planning to deployment., Cross-Functional Collaboration: Worked closely with developers, designers, and marketing teams to deliver products on time, utilizing .NET, Angular, and React for backend and frontend development., Quality Assurance: Implemented automated testing and quality control strategies, ensuring high performance and meeting the needs of high-profile clients.

Employmenthistorydetails

REGIONAL OPERATION MANAGER, Talabat, 04/01/04, 08/01/14, Kuwait City, Kuwait, Expansion & Operations Setup: Successfully expanded Talabat operations across KSA, Bahrain, UAE, Oman, and Qatar, leading operational setup and onboarding 1000+ restaurants., Sales Strategy & Client Relations: Developed sales and operational strategies that increased sales by 75% in the GCC region and improved client relationships., Team Leadership & Training: Led cross-functional teams, focusing on recruitment, training, and improving customer service efficiency, resulting in significant operational enhancements.

Timeline

HARNESSING THE POWER OF DATA WITH POWER BI - undefined

09.2023 - 10 2023

MACHINE LEARNING ALGORITHMS WITH R IN BUSINESS ANALYTICS - undefined

06.2023 - 7 2023

GOOGLE DATA ANALYTICS PROFESSIONAL CERTIFICATE - undefined

01.2023 - 8 2023

Senior Data Analyst

Petsmarket
08.2017 - 11.2023

Product Development Manager

ECOM Planners
09.2014 - 07.2018

Regional Operation Manager

Talabat
04.2004 - 08.2014

BACHELOR OF COMPUTER SCIENCE -

Institute of Computer Sciences Lahore
03.1997 - 2 1999

Senior Data Analyst

Unique Wholesale ATL
1 2024

Similar Profiles

CREATE PROFILE
Fouad AkhtarSenior Data Analyst