Aleksandr Vasiliev-Hartmann
Demand Planning · $1.4B CPG · MAPE 14.8% · DOH 84→62 · $84M WC Freed
Summary
Senior demand planning analyst at a $1.4B CPG company (8 brands, 38k SKUs); FY24 forecast accuracy MAPE 14.8% (network 22%); reduced DOH from 84 to 62 days while holding service level 98.4% — freed $84M working capital. Led S&OP analytics for the largest brand ($380M). SAP IBP + SQL + Python + Tableau stack. APICS CSCP.
Experience
Senior Demand Planning Analyst
Riverline Brands ($1.4B CPG, 8 brands, 38k SKUs) · Cincinnati, OH
Sep 2021—Present
- Forecast accuracy: lifted MAPE from 22% to 14.8% over 14 months via 3 changes — moved 38 top SKUs from monthly to weekly granularity, integrated promotional-lift modeling (XGBoost in Python on 4 years of sales + promo + price data), reconciled with Sales on top-14 customer-account assumptions.
- Inventory: DOH 84 → 62 days while holding service level 98.4%; freed $84M working capital; tightened safety-stock parameters on 14k slow-movers using statistical safety-stock + 1,400 top SKUs with seasonality models; rebalanced FCS across 4 DCs.
- S&OP: led demand-review meeting for the $380M brand (monthly + executive S&OP quarterly); presented forecast + supply-vs-demand gap + scenario analyses on 4 stress scenarios; influenced 3 quarterly capacity plans.
- Network: led MILP-based network-design study (Python with PuLP + Gurobi); evaluated consolidation from 6 DCs to 4 DCs; identified $14M annual savings + 2-day service degradation; informed 2-year network roadmap.
- Recognition: Supply Chain Excellence Award (annual, 1 of 14 across 380-person SC org) 2024 for the MAPE + DOH initiative; presented at company-wide town hall.
Supply Chain Analyst
Riverline Brands · Cincinnati, OH
Jul 2019—Aug 2021
- Mid-brand analyst (4 brands, 14k SKUs); built first XGBoost forecasting prototype that landed in production for promo-lift modeling.
- Promoted to Senior after 24 months on MAPE + S&OP + cross-functional reputation.
Supply Chain Coordinator
Heartland Logistics (3PL) · Cincinnati, OH
Jun 2018—Jun 2019
- First role out of college; supplier coordination + inbound scheduling + receiving variance reconciliation.
Stack + Tools
Planning + ERP:SAP IBP (Demand + Supply, 3 yrs)·SAP ECC + S/4HANA·Anaplan (S&OP + scenario)·Kinaxis (prior team familiarity)
Analytical Stack:SQL (Snowflake, 14k lines)·Python (XGBoost + Pandas + scikit-learn + PuLP)·Tableau (8 published dashboards)·Excel + Power Query
Certifications
APICS CSCP — Certified Supply Chain Professional
ASCM (APICS)
Jun 2022—
Anaplan Certified Model Builder
Anaplan
Sep 2023—
Education
BSBAinOperations Management + Logistics
Ohio State University — Fisher College of Business·Columbus, OH
Aug 2014—May 2018
Senior Demand Planning Analyst (CPG)
Demand Planning · $1.4B CPG · MAPE 14.8% · DOH 84→62 · $84M WC freed
Use this template