Ethan Park
Supply Chain Analyst
Columbus, OH · ethan@email.com · linkedin.com/in/ethanpark
Professional summary
Supply chain analyst with 5 years of experience in demand planning, inventory optimisation, supplier performance, and operational reporting. Advanced in Excel, SQL, Power BI, and SAP, with a record of improving availability while reducing excess stock.
Experience
Supply Chain Analyst
Hartwell Consumer Products · Columbus, OH
- Built a weekly SKU-level demand model for 1,800 products, improving forecast accuracy by nine percentage points across the highest-volume category.
- Segmented safety-stock rules by demand variability and lead time, releasing $1.2 million in excess inventory while maintaining a 96% case-fill rate.
- Created a Power BI supplier scorecard covering on-time delivery, defects, lead-time variance, and corrective-action ageing for 34 vendors.
Inventory Analyst
Blue River Home Goods · Cincinnati, OH
- Reconciled ERP inventory against warehouse cycle counts and traced recurring discrepancies to three receiving and unit-of-measure errors.
- Automated the monthly slow-moving-stock report with SQL and Excel Power Query, reducing preparation from two days to under three hours.
- Modelled promotion scenarios with sales and procurement teams to identify capacity and stock risks before seasonal launch approval.
Skills
Demand forecasting · Inventory optimisation · Supply planning · Supplier performance · SAP · SQL · Power BI · Advanced Excel · Safety stock · S&OP · Scenario modelling · Root-cause analysis
Education & credentials
Build yours with the same structure in minutes, free to start.