Demand Planner

Demand Planner — Lumina Consumer Products

Chicago, IL | October 2023 – Present

• Formulated statistical demand models in SAP IBP using double exponential smoothing algorithms, reducing forecast error (MAPE) by 9.5% across 180 high-volume SKUs over a 12-month period.
• Collaborated with Sales and Marketing teams to integrate promotional calendars into the demand forecast, which boosted product availability and achieved a 98.4% OTIF service level during the Q4 peak demand season.
• Managed weekly S&OP reconciliation meetings with Supply Planning and Logistics to align supply plans with forecasts, resolving 42 inventory bottlenecks and saving $75,000 in expedited shipping costs.
• Utilized Power Query and SQL to automate demand dashboard reporting, reducing the team's weekly forecast preparation and analysis time from 15 hours to 3 hours.

Supply Chain Analyst — Summit Food Brands

Milwaukee, WI | June 2021 – September 2023

• Analyzed historical shipment data in Oracle Demantra to identify seasonal trends, which improved baseline forecast accuracy by 12% across a $4M beverage portfolio.
• Calculated safety stock targets and reorder points for 320 active SKUs using statistical inventory models, decreasing excess warehouse carrying costs by $110,000 annually.
• Engineered automated inventory tracking alerts in Tableau, which decreased regional warehouse stockouts by 18% and reduced replenishment lead times by 1.5 days.
• Partnered with 8 key raw material suppliers to streamline replenishment schedules, raising vendor on-time delivery rates from 81% to 93% over a 6-month period.

Statistical forecasting, Sales and Operations Planning (S&OP), Inventory optimization, Safety stock calculation, CPFR, MAPE/WAPE reduction, SKU rationalization, SAP IBP, Oracle Demantra, Microsoft Excel (VBA & Power Query), Tableau, SQL, Supply chain risk management, Capacity planning

SKU Rationalization & Optimization Initiative

Role: Lead Demand Planner

Tools: Oracle Demantra, Advanced Excel, SQL, Tableau

Led the analysis of 600+ active SKUs based on volume and margin, resulting in the decommissioning of 85 underperforming products and a 14% reduction in warehouse holding costs.

S&OP Process Digitalization Project

Role: Supply Chain Representative

Tools: SAP IBP, Microsoft Power BI, Microsoft Teams

Coordinated the transition of S&OP meetings from manual spreadsheets to SAP IBP, reducing forecast cycle time by 4 days and improving forecast alignment across sales and operations by 18%.

• Certified in Planning and Inventory Management (CPIM) – ASCM (2022)
• Certified Supply Chain Professional (CSCP) – ASCM (2023)
• Certified Professional Forecaster (CPF) – Institute of Business Forecasting (2024)

• Languages: English (Native), Polish (Professional Working Proficiency)
• Volunteer Work: Mentoring youth through Supply Chain Association outreach programs (2023-present)
• Availability: 2 weeks notice