AJ Klemczak
Atlanta,GA
Summary
Accomplished Business Analyst with a proven track record enhancing project efficiency through innovative dashboards. Expert in SQL and strategic planning, I excel in transforming complex data into actionable insights. Recognized for leadership at various levels through personal determination and relationship development.
Overview
7
7
years of professional experience
Work History
Business Analyst Sr
Starbucks
09.2023 - Current
- Developed data integrity dashboard resulting in a 15% reduction in projects with schedule related flags for FY24
- Automated Environmental Social Governance (ESG) data audit of electric, water, and natural gas utility usage for FY23
- Developed SD Initiatives Hub dashboard to overview KPIs for executive level reporting
Performance & Analytics Specialist
Mercedes-Benz USA
08.2022 - 08.2023
- Delivered parts logistics tableau reporting ecosystem and leveraged Data Warehouse and custom SQL for core KPIs
- Developed SSOT SQL views used in PowerBI Dataflows to design dashboards and reports for business partners
- Cross functional support of ETL process & validation of parts logistics data into Azure data warehouse (50+ tables)
- Overhauled monthly forecast of accessory parts using real time data to improve planning and ordering
- Managed relationships with several business units while setting clear timelines and expectations for requests
Business Intelligence Analyst
Mercedes-Benz USA
03.2021 - 08.2022
- Developed wholesale opportunity dashboard facilitating dealer discussions to enhance parts trading business
- Forecasted dealer revenue for overall parts trading business as well as our subsidiary program 'StarParts' using historical data and current market trends
- Developed and managed 20+ custom automated reports for business partners increasing team bandwidth and flexibility
- Mentored new team members on key datasets and best practices at MBUSA
Program Manager
Mercedes-Benz USA
08.2019 - 03.2021
- Initiated and managed 100+ development program relationships between educational institutions and Mercedes-Benz dealerships (exceeded pilot goal of 50 engagements)
- Developed benchmark KPI's determining success of technician recruiting programs
- Directed weekly team meetings to set strategy and manage program responsibilities/deliverables
Energy Analyst / Project Executive
Cost Control Associates
02.2017 - 08.2019
- Awarded company top earner for CRR (Cost Recovery & Reduction) services in 2017 & 2018, recording over $1M in cost savings
- Developed budget forecasts utilizing market research to ensure confidence of future utility account spend for JC Penney
- Identified key data trends to diagnose anomalies and advise clients of beneficial rate changes
Education
Bachelor of Arts - Economics & Political Science
St. John Fisher College
Rochester, NY12.2016
Skills
- Alteryx Designer
- Azure / Databricks / SQL
- Data Visualization (Tableau/Power BI)
- Microsoft Office (Excel/Word/PPT)
- Strategic Planning
- Program Management
- Business Development
- Leadership
- Customer Service
- Complex Problem Solving
- Budget Analysis and Forecasting
Timeline
Business Analyst Sr
Starbucks
09.2023 - Current
Performance & Analytics Specialist
Mercedes-Benz USA
08.2022 - 08.2023
Business Intelligence Analyst
Mercedes-Benz USA
03.2021 - 08.2022
Program Manager
Mercedes-Benz USA
08.2019 - 03.2021
Energy Analyst / Project Executive
Cost Control Associates
02.2017 - 08.2019
Bachelor of Arts - Economics & Political Science
St. John Fisher College