National Demand Planning - Broadband
- Created and maintained 7-year National demand forecast for Broadband Customer Premise Equipment (CPE) products ($1B), Gateways and Extenders, within +/- 10% 90-day forecast accuracy by working with Sales, Product, Field and other various organizations on regular basis for strategy inputs
- Track actual demand consumption trends by various categories (Fiber, Copper, New, Maintenance, Migrations, Customer Self Install (CSI), Full Tech Install (FTI), etc.) to maintain or improve 30, 90, 275, 365-day forecast demand accuracy
- Created 7-year model to forecast supply (New and Refurbished) and incorporate demand forecast to ensure Days Stock on Hand (DSOH) targets are being met with ability to create various sensitivities quickly for Senior Management in Supply Chain, Product and Finance to support strategic planning and decision making
- Ability to take massive amounts of complicated data and transform into meaningful and actionable insights
- Lead and prepare content for monthly Broadband Operational Sales & Operations Planning (S&OP) with various organizations as well as creating content for Executive S&OP
- Track actuals for returned CPE equipment by device in JDA/Blue Yonder and create monthly Reverse Logistics (RL) receipt forecast within +/- 10% 90-day forecast accuracy
- Created dashboards in Power BI (PBI) to provide selected users data details on Broadband Gateways monthly activations