Meyerhoffer-Kubalik

About Meyerhoffer-Kubalik

Professional Summary Business Intelligence and Internal Audit Analytics manager…

Experience

1. Business Intelligence Manager

   5-hour ENERGY®

   Oct 2022 — Present

   Developed interactive Power BI and Tableau dashboard to visualize key performance metrics, enabling data-driven decision-making and improving business insights across various departments Identified, analyzed, and presented to the CEO & Owner the three key reasons for 5-Hour Energy\'s sales decline since 2016:* Decreased consumer velocity vs. diminished point-of-distribution * Negative impact of price increases on price-sensitive consumers * Reduction to marketing spend to offset negative publicity from a 2012 article (conversely, competitors increased marketing spend) Identified increases in competitors, low entry barriers, a high relative price point, and failure to pay slotting fees have increased declines Designed and presented retailer specific pricing models leveraging historical sales, retailer product elasticities, and forecasted the impact of all pricing changes. Price recommendations were made to set prices and optimize sales at Walmart, 7-11, Casey’s, and Dollar General, Wawa, Quick Trip, Dollar Tree, Publix, and Meijer Led Dollar General ghost inventory project, identified 82% of 19,482 stores had high levels of ghost inventory, resulting in over $2.8M in lost sales. Developed Power BI processes with push notifications to notify when the status of ghost inventory Developed XGBoost ML forecasts and dashboards for 5-hour Energy shot consumption and shipments. Achieved 98.7% ML forecast accuracy in FY23 weekly actuals vs. weekly forecasted