Jeffrey Mroczko
Atlanta,Georgia
Summary
Results-driven pricing professional with strong analytical skills and a focus on data-driven decision-making. Known for effective team collaboration, adaptability to changing market conditions, and commitment to achieving business goals. Highly skilled in financial modeling, data analysis, and process improvement.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Pricing Analyst
Republic National Distributing Company
Atlanta
11.2024 - Current
- Engineered Python and VBA scripts utilizing AI to automate data validation processes, enhancing data quality for pricing analysis and decision-making.
- Built and maintained interactive dashboards for leadership to track key metrics and evaluate financial performance across regions.
- Analyzed pricing data to identify trends and anomalies, providing insights into market dynamics incorporated into business review presentations for executive leadership.
- Developed and automated monthly freight and cost analysis reports using Power Query and Python, improving reporting efficiency by 50%.
- Executed over 4,500 monthly pricing adjustments across multiple markets, ensuring accuracy and timeliness to support business objectives.
Billing Analyst
Guild
Atlanta
06.2022 - 05.2024
- Designed and implemented QA rubrics to assess billing data accuracy and completeness, ensuring adherence to regulatory requirements and minimizing compliance risks.
- Partnered with leadership to define and implement KPIs and performance dashboards, improving operational and financial outcomes.
- Managed financial datasets and budgets using SQL and Excel, ensuring accurate forecasting, billing, and reconciliation processes, contributing to improved financial visibility.
- Proactively identified billing discrepancies using advanced spreadsheet functions, decreasing time spent on manual data validation by 25%.
- Automated reporting workflows, reducing invoicing time by 25% and enhancing accuracy through advanced Excel formula design.
- Investigated and rectified billing inaccuracies stemming from credit misapplication and incentive miscalculations, directly addressing customer concerns and preventing churn.
- Supported audit compliance by elucidating complex billing processes and controls, minimizing the risk of financial penalties related to non-compliance.
Senior Advisory Analyst, Consulting
KPMG
Orlando
01.2021 - 06.2022
- Delivered detailed variance and performance reporting, enhancing accuracy in financial planning and audits.
- Developed custom Excel-based financial tools, reducing manual errors by 25%, to improve workflow efficiency.
- Collaborated with cross-functional teams to resolve financial discrepancies exceeding $300M through process creation and analysis.
- Developed comprehensive reports for clients, enhancing project visibility and stakeholder engagement.
Space Planning Analyst
The Home Depot
Atlanta
10.2015 - 12.2020
- Designed and maintained reporting tools to track inventory turnover and sales performance, enhancing financial visibility and decision-making.
- Applied data analytics to manage operational budgets, optimize layouts, and improve product profitability across national retail locations, increasing revenue by 15% in the first year.
- Supported financial planning and forecasting by analyzing category performance and recommending data-driven adjustments, improving accuracy and efficiency.
- Collaborated with cross-functional teams to streamline supply chain processes and improve operational efficiency.
Education
Associate of Science -
Tennessee State University
Nashville, Tennessee05-2016
Skills
- SQL
- Excel
- Tableau
- Power BI
- Python
- Data Modeling
- Forecasting
- Process Automation
- Financial Analysis
- Ad Hoc Reporting
- Data analysis
- Data cleaning
Certification
- Data Science with SQL and Tableau | eCornell
- Data Analytics | Google
- Corporate Finance Foundations | CPI
- Google Data Analytics (SQL, Data Structures, Best Practices)
- Power BI Data Analyst
- ECornell Data Science with SQL and Tableau
- CFI - Corporate Finance Foundations
Timeline
Pricing Analyst
Republic National Distributing Company
11.2024 - Current
Billing Analyst
Guild
06.2022 - 05.2024
Senior Advisory Analyst, Consulting
KPMG
01.2021 - 06.2022
Space Planning Analyst
The Home Depot
10.2015 - 12.2020
Associate of Science -
Tennessee State University