Alex Chen
Supply Chain Analyst | Demand Planning · Inventory Optimisation · Data Analytics
Professional Summary
Supply chain analyst with 6 years of experience in high-volume manufacturing, now focused on e-commerce fulfilment. Combines strong SQL and Excel modelling with hands-on planning experience across 3,400 SKUs and four distribution centres. Cut excess inventory by $2.3M while improving fill rate to 98.4%. Ready to bring forecasting rigour and cost discipline to a fast-growing online retail operation.
Key Achievements
Inventory reduction: Reduced excess and obsolete inventory by $2.3M (19%) in 12 months by introducing ABC/XYZ segmentation and dynamic safety stock.
Forecast accuracy: Improved forecast accuracy (MAPE) from 68% to 84% by building a statistical forecasting model in Python and SQL.
Service level: Raised order fill rate from 94.1% to 98.4% across four distribution centres while holding inventory flat.
Cost savings: Identified $410K a year in freight savings by analysing lane-level shipping data and consolidating LTL shipments.
Professional Experience
Senior Supply Chain Analyst
- Lead monthly S&OP analysis for a $310M product portfolio, presenting demand and supply scenarios to the VP of Operations.
- Built a Power BI control tower tracking inventory, fill rate and supplier OTIF for 4 DCs, used daily by 40 planners and buyers.
- Partnered with procurement to renegotiate lead times with 12 key suppliers, cutting average lead time from 46 to 34 days.
- Automated weekly replenishment reports with SQL and Power Query, saving 12 analyst hours a week.
- Mentor two junior analysts on forecasting methods and SQL.
Supply Chain Analyst
- Maintained forecasts for 3,400 SKUs and managed safety stock settings in SAP.
- Ran the analysis behind a warehouse network study that consolidated two sites, saving $640K a year.
- Reduced stockouts on A-class items by 37% by redesigning reorder points around actual demand variability.
Inventory Control Specialist
- Led cycle counting for a 180,000 sq ft warehouse, raising inventory record accuracy from 91% to 99.2%.
- Investigated and resolved $280K of variances, documenting root causes and corrective actions.