Dan Mack Email & Phone Number

Kalamazoo, Michigan, United States

Lead Accelerate Business Analytics Minor Release process and team of developers to enable data from SAP front-end environments in SAP BW and create/enhance Business Objects (BOBJ) reports.Manage contractor responsible for documenting Power BI reports/dataflows.Provide Power BI data enablement to Stryker divisions & COE’s on SAP.Created report building.

Portage, Michigan, United States

Managed 24-month supply plans for 38 Instruments suppliers ($325 million annual sales) for Finished Goods Operations which manages OEM / Contract Manufacturing supply for multiple Stryker divisions.Continuously developed tools to streamline complex planning requirements. Became go-to training resource for team following development of robust training.

Portage, MI

Minimized backorder and excess inventory following significant fluctuations in demand per COVID-19 - 2020 YE Backorder <$1,000 for my items: 37 Instruments suppliers, >$65 million annual spend. Created Issue Tracker and Priority Receipt Report to consolidate list of SKU’s at risk and streamline prioritization of critical deliveries.

Paw Paw, MI

Planned production of Drink Box, Pouch, Variety Pack, and Pouch Forming categories for Paw Paw production facility (11 Lines, 52 SKU’s, $100 million per year in production of Hi-C, Minute Maid, and Honest Kids products including McDonald’s juice boxes for 50% of locations nationwide). Leveraged SAP and Microsoft Excel to continuously improve production.

Paw Paw, MI

Managed >$70 million per year of ingredients and packaging materials to prevent material shortages and minimize storage costs. Scheduled production for Drink Box, Variety Pack, Powerade, Pouch, and Pouch Forming categories when primary planner was unavailable. Created various tools to significantly reduce process time and room for error in managing.

Battle Creek, MI

Improved Sales & Operations Planning through SAP BEx Query Designer and advanced Microsoft Excel reporting. Maximized effectiveness of forecast trending software to realize 3% improvement in forecast accuracy, resulting in an estimated $5.4 million in annual cost avoidance through improved service and inventory levels.

Battle Creek, MI

Held four unique roles which developed skills in analytics, project management, logistics, and SAP master data management.