Dan Mack

Experience

• 

  Kellogg Company

  Dec 2010 - Jun 2014

  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. Held four unique roles which were instrumental to the development of skills in analytics, project management, logistics, and SAP master data management.

  • Sr. Analyst, Supply Chain / Demand Planning

    Sept 2012 - Jun 2014

  • Customer & Logistics Services Rotational Intern

    Dec 2010 - Sept 2012
• 

  The Coca-Cola Company

  Jan 2015 - Sept 2019

  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 planning processes. 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 materials.

  • Supply Planner III

    Jun 2017 - Sept 2019

  • Supply Planner II

    Jan 2015 - May 2017
• 

  Stryker

  Sept 2019 - now

  Lead Accelerate Business Analytics Minor Release process and team of three developers to enable data from SAP front-end environments in SAP BW and create/enhance Business Objects (BOBJ) reports.Provide Power BI data enablement to Stryker divisions & COE’s on SAP.Collaborate with teams from various functions to translate business needs into technical requirements. 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 strategy. 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.

  • Associate Manager, Reporting Process Implementation Lead, Sustain

    Oct 2022 - now

  • Senior Supply Planner

    Jul 2021 - Sept 2022

  • Supply Planner

    Sept 2019 - Jun 2021