Anfernee Simpson
Sales Analytics And Reporting Manager
Peachtree City,Georgia
Summary
Results-driven Analytics Leader with progressive experience driving data-centric initiatives across multiple enterprise organizations. Expertise in developing end-to-end data pipelines, financial modeling, and transforming complex datasets into actionable business intelligence. Proven track record of delivering data-driven solutions that enhance operational efficiency, support strategic decision-making, and drive revenue growth. Combines strong technical acumen with business insight to bridge the gap between analytics and organizational goals.
Overview
7
7
years of professional experience
8
8
years of post-secondary education
2
2
Certifications
Work History
Sales Analytics and Reporting Manager
HITACHI CONSTRUCTION MACHINERY
02.2023 - Current
- Architected enterprise-wide data infrastructure using SQL relational databases, improving data accessibility by 35% and reducing report generation time by 40%
- Spearheaded the development of automated data processing solutions with complex SQL queries, stored procedures, and triggers, eliminating 25+ hours of manual work weekly
- Engineered ETL pipelines using Power Query and Python that improved data quality by 60%, enabling more accurate forecasting and business planning
- Delivered executive-level dashboards that highlighted key market insights, driving a 15% increase in sales team productivity and supporting a 12% YoY revenue growth
- Led and developed a team of 4 direct reports, achieving 80% project completion rate through effective team leadership, implementing agile methodologies, and fostering a culture of continuous improvement
- Designed and implemented a sophisticated variance analysis system that reduced planning deviations by 22% and improved forecast accuracy by 30%
- Conceived and delivered a dealer business plan proof of concept that secured departmental funding for a dedicated development team, resulting in an enterprise online solution that drove a 31% increase in unit sales
- Developed a comprehensive market data pipeline, transforming raw subscription data into strategic insights for C-suite decision-making, directly influencing market expansion strategy
Senior Data Analyst
Mueller Water Products
04.2021 - 01.2023
- Company Overview: Contracted to Sysco and Mueller
- Managed the full lifecycle of commission calculations and incentive plans for a 120+ person sales organization, with 100% accuracy and zero payment disputes
- Streamlined the monthly commission reporting process, reducing turnaround time by 35% while increasing data accuracy by 25%
- Collaborated with sales leadership and HR to implement plan changes that increased sales rep performance by 18% and improved talent retention by 15%
- Executed rigorous data quality tests across multiple platforms (JDE, SQL reporting services, OLAP cubes), ensuring 99.8% data integrity in all stakeholder reporting
- Created an automated deviation calculation system that identified $1.2M in potential revenue opportunities in the first quarter of implementation
Financial Analyst
Sysco
03.2021 - 12.2021
- Led the Annual Operating Plan (AOP) process, training 50+ business stakeholders and creating standardized planning templates that reduced planning cycle time by 20%
- Developed executive management dashboards that distilled complex financial data into strategic insights, directly supporting $5M in cost optimization initiatives
- Engineered a dynamic pro-forma template using VBA and Power Excel that reduced financial modeling time by 75% and standardized analysis across 200+ business units
- Conducted in-depth financial analysis that identified $3.2M in potential cost savings and $2.1M in revenue opportunities
- Supported monthly and quarterly business reviews with comprehensive financial analyses that enabled data-driven strategic decisions
FP&A Analyst
CUMMINS
03.2019 - 08.2020
- Developed analytical tools that improved forecast accuracy by 40% and reduced variance between actuals and budget by 25%
- Orchestrated the Annual Operating Plan (AOP) process for a $100M business unit, consolidating inputs from 8 departments to ensure alignment with corporate strategic goals
- Identified $2.5M in cost-saving opportunities through detailed analysis of operational data and procurement patterns
- Presented strategic recommendations to senior leadership that guided resource allocation decisions and supported a 10% YoY profitability improvement
Finance Rotational Analyst
SOUTHWIRE
01.2018 - 03.2019
- Led a capital expenditure automation project that reduced approval cycle time by 65% and improved documentation compliance by 75%
- Partnered with third-party developers to create an online capital approval system used by 200+ managers and executives across the organization
- Managed the capital expenditure process for projects totaling $15M, ensuring accurate tracking from approval to completion
- Analyzed operational and expense reports to identify $1.2M in potential cost savings opportunities
Education
Master of Science - Analytics (Data Science Path)
01.2024 - 01.2027
Bachelor of Science - Dual Major in Accounting & Statistics, Minor in Finance
01.2012 - 01.2017
Skills
Advanced Financial Modeling
Advanced SQL Query Development
Proficient in Python
R Language Proficiency
Statistical Data Interpretation
Data Extraction and Transformation
Data Visualization Expertise
Power BI Data Visualization
Advanced Excel (VBA, Power Query)
Azure Data Management
Interdepartmental Cooperation
Project Execution
Process Optimization
Strategic Development
Strategic Team Guidance
Effective Stakeholder Communication
Analytical Problem-Solving
Certification
Azure Data Management Certified
Accomplishments
Market Intelligence Pipeline (Hitachi)
Developed an end-to-end data pipeline extracting, transforming, and integrating market data from subscription providers into the enterprise data warehouse. Created role-based access controls and built an executive dashboard that enabled leadership to identify $8M in untapped market opportunities.
Capital Approval Automation (Southwire)
Led the development of a company-wide capital approval platform that digitized the entire process. Reduced approval time from 14 days to 5 days and enabled mobile approvals, increasing executive productivity and accelerating project implementation timelines.
Dynamic Pro-forma System (Sysco)
Created an advanced pro-forma template using VBA and Power Excel that automated 90% of the financial modeling process. System allowed users to generate comprehensive financial projections with minimal inputs and export in multiple formats, saving approximately 200 hours per quarter across the finance organization.
Timeline
GEORGIA TECH - Master of Science, Analytics (Data Science Path)
01.2024 - 01.2027
Sales Analytics and Reporting Manager - HITACHI CONSTRUCTION MACHINERY
02.2023 - Current
Senior Data Analyst - Mueller Water Products
04.2021 - 01.2023
Financial Analyst - Sysco
03.2021 - 12.2021
FP&A Analyst - CUMMINS
03.2019 - 08.2020
Finance Rotational Analyst - SOUTHWIRE
01.2018 - 03.2019
UNIVERSITY OF ALABAMA - Bachelor of Science, Dual Major in Accounting & Statistics, Minor in Finance
01.2012 - 01.2017