Summary
Overview
Work History
Education
Skills
Timeline
Generic

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, NY
12.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
AJ Klemczak