Miguel K. Vanderburg
Supply Chain Analyst, Demand Planning
Charlotte, NC · (704) 555 0120 · name@example.com · linkedin.com/in/miguelkvanderburg
Key Qualifications
EXPERIENCE
Six years in demand planning and inventory analysis
INDUSTRIES
Apparel, footwear and specialty retail
SPECIALTIES
Statistical forecasting, forecast accuracy, seasonal buys, inventory targets
SYSTEMS
SAP, Power BI and advanced Microsoft Excel
CREDENTIALS
Certified in Planning and Inventory Management, Association for Supply Chain Management
EDUCATION
Bachelor of science in business analytics, University of North Carolina at Charlotte
Executive Summary
Demand planning analyst with six years in apparel and footwear. Owns the statistical forecast for a nine hundred item assortment, runs the monthly consensus meeting with merchandising, and reports forecast accuracy that leaders actually use to set buys. Comfortable defending a number in front of a room.
Signature Achievements
- Lifted forecast accuracy at the item and month level from sixty two percent to seventy eight percent over two seasons.
- Freed one point four million dollars of working capital by resetting safety stock using measured demand variability.
- Cut end of season markdown exposure by nineteen percent through earlier reforecasting of slow selling styles.
- Built a Power BI dashboard for weekly sell through that replaced four manually built spreadsheets.
- Reduced stockouts on the top fifty items from eleven percent of store weeks to four percent.
Professional Experience
Supply Chain Analyst, Demand Planning
Piedmont Threadworks, Charlotte, NC 2022 to present
Owns forecasting and inventory targets for nine hundred items sold through one hundred and forty stores and a website.
- Maintains statistical models, adjusts for promotions and seasonality and publishes the monthly consensus forecast.
- Sets days of supply and safety stock targets by item class and reviews them against service outcomes.
- Reports forecast accuracy and bias by category and works with merchants on the largest misses.
- Models the inventory effect of proposed buys before merchandising commits to purchase orders.
Inventory Analyst
Catawba Outfitters Company, Gastonia, NC 2020 to 2022
Analyst supporting allocation and replenishment for a regional outdoor retailer with thirty stores.
- Built replenishment rules by store cluster and monitored weeks of supply against sales rates.
- Analyzed aged inventory and recommended transfers that moved stock to stores where it sold.
- Prepared weekly reporting on in stock rate, turns and open purchase order coverage.
Licensure and Certification
Certified in Planning and Inventory Management, Association for Supply Chain Management
Member, Association for Supply Chain Management
Education
Bachelor of science in business analytics, University of North Carolina at Charlotte, 2020
Core Skills
Statistical forecasting · Forecast accuracy reporting · Safety stock modeling · Days of supply targets · Allocation and replenishment · Consensus planning · Power BI · SAP · Advanced Excel modeling