Sophie ChuYu Huang
Bloomfield,NJ
Summary
Results-driven Demand Planner with a proven track record at Weee! Inc., enhancing product availability by 25% and boosting revenue significantly. Proficient in SQL and data interpretation, I excel in demand forecasting and project management, leveraging analytical skills to implement strategies that optimize inventory and improve accuracy.
Overview
4
4
years of professional experience
Work History
Demand Planner
Weee! Inc.
, NJ
04.2023 - Current
- Spearheaded demand planning strategies for over 3,200 products, contributing to a year-over-year revenue growth that doubled regional sales
- Monitored product performance and implemented replenishment strategies that improved overall site forecast accuracy by 20%, reduced stockouts by 18%, and elevated a fast-growing site's accuracy by 12%, outperforming machine learning models
- Calculated weekly revenue index for seven sites, delivering key performance metrics to enhance demand forecasts, enabling data-driven decisions for long-term revenue stimulation
- Improved over 10% demand accuracy for company's direct import products, achieving 96% product availability at all times
- Designed and executed demand plans that ensured optimal inventory levels by incorporating supply chain metrics, such as fulfillment rates, product seasonality, marketing exposure, and cannibalization risks of new products
- Reduced weekly spoilage of short shelf-life products from 3% to less than 1% by redefining order-up-to levels based on lead time, shelf life, and vendor performance
- Increased availability of 150+ core produce products by 25% through precise seasonality forecasting and benchmarking against other sites' sales data
- Maintained an 80%-plus weighted in-stock rate across all fulfillment centers by resolving defects in ordering tools and stabilizing inventory transfers within the East Coast DC-to-FC network
- Led the East Coast demand planning team, mentoring two team members on forecasting methodologies and providing actionable insights to enhance team performance
- Collaborated with cross-functional teams, including supply chain, marketing, and operations, to ensure seamless execution of demand planning strategies in a high-growth, fast-paced environment
- Developed a Tableau dashboard to streamline promotion-demand planning processes, enabling real-time tracking of price changes, ethnic storefront updates, and product additions or deletions. Enhanced workflow efficiency and accuracy in promotional planning
- Collaborated with engineers to develop an in-house automation system for demand forecasting across seven sites. Provided key logic inputs, including price elasticity of demand, storefront index, seasonality, and moving average sales, to enhance forecasting accuracy. Improved the demand planning team's efficiency and effectiveness.
Procurement Planner
Weee! Inc.
, NJ
05.2022 - 04.2023
- Increased product availability by 25% for over 500 items, resulting in an average revenue boost of 160% increase
- Developed and executed promotion strategies, enhancing gross margin by 2% in two regions
- Optimized product pricing to maximize revenue while balancing margin and availability
Education
M.S. - Supply Chain Management
Rensselaer Polytechnic Institute
NYB.A - Economics, Arabic language
National ChengChi University
TaiwanSkills
- Advanced Excel
- Python
- SQL
- Tableau
- Detail-oriented
- Problem solving
- Demand forecasting
- Project management
- Promotion planning
- Data interpretation
Timeline
Demand Planner
Weee! Inc.
04.2023 - Current
Procurement Planner
Weee! Inc.
05.2022 - 04.2023
M.S. - Supply Chain Management
Rensselaer Polytechnic Institute
B.A - Economics, Arabic language
National ChengChi University