Ellen Li

Private Label Management:

• Managed the inventory and sales of Sephora’s private label products, overseeing ¥200M in annual sales and ¥60M in inventory.
• Coordinated purchasing with domestic OEMs and overseas private label factories, overseeing import/export processes and order management.
• Collaborated with product managers to provide 18-month sales forecasts to overseas factories, improving order fulfillment rates and production planning accuracy.
• Authored supply chain SOPs document to define responsibilities and workflows, facilitating cross-departmental collaboration (Finance, Branding, Product Development) and efficient execution of supply chain operations.

Distributed Brands Management:

• Oversaw inventory and sales operations for distributed brands, including makeup, skincare, and fragrance lines, meeting KPIs such as OSA and DOI, Managed the inventory ¥160M
• Developed and maintained demand planning reports, providing accurate data insights to support business decision-making.
• Designed and implemented automated tools and reports, enhancing demand planning efficiency and reducing manual errors.
• Conducted regular demand forecast reviews and adjustments, continuously optimizing plans based on market feedback to improve forecast accuracy.
• Implemented supply chain collaboration strategies, strengthening supplier communication and improving response times across the chain.
• Executed stringent inventory control measures, reducing expired and unsalable items, and cutting costs for the company.

Inventory Management for Elmer's (APAC Region):

• Inventory Oversight: Managed inventory for over 50 SKUs, maintaining $800K(Dollar) in stock to support annual sales of $16M. Oversaw inventory operations across China, Thailand, and Japan, including inter-warehouse stock rebalancing.
• Cross-Functional Collaboration: Worked with Marketing, Sales, and Warehousing teams to address excess and obsolete stock, ensuring alignment with business goals.
• System Utilization: Leveraged SAP (ECC and APO models) to ensure accurate inventory records and effective stock control. Utilized Power BI for inventory tracking and turnover efficiency, identifying and correcting discrepancies.
• Supply Planning: Maintained stock levels based on forecasts and demand trends, ensuring timely order fulfillment. Monitored open purchase orders, keeping records accurate and up-to-date to prevent processing errors.
• Vendor Management: Built and maintained strong relationships with domestic OEM suppliers (Zhejiang, Jiangsu) and international suppliers (US, Malaysia). Managed delivery schedules, shipment processes, and order exceptions.
• Performance Optimization: Ensured on-time, in-full (OTIF) delivery by negotiating with suppliers and resolving performance issues proactively. Handled stock-outs due to overselling or demand changes, securing expedited deliveries or inter-warehouse transfers.
• Product Lifecycle Management: Monitored temporary and scrap inventory, providing timely feedback to the Commercial Department to address unsalable items. Collaborated with teams to ensure smooth new product launches, managing forecasts and arrivals.
• Data Analysis: Conducted daily analyses, including inventory health, order performance, sales trends, and oversold/undersold monitoring to inform strategic decisions and optimize inventory operations.

Customer and Inventory Management:

• Sell-In Goal Achievement: Managed customer needs and tracked progress toward sell-in targets, ensuring alignment with business objectives.
• Out-of-Stock Mitigation: Assessed stock-out risks, addressed critical issues with dealers, and managed the replenishment process to maintain supply chain stability.
• Inventory Analysis and Optimization: Conducted inventory turnover and quality analyses, providing dealers with actionable suggestions to enhance inventory efficiency.
• Action Planning for Stock Issues: Investigated root causes of stock-outs, developed corrective action plans, and collaborated with distributors to replenish inventory before the MAD date, achieving a 98% on-shelf availability rate.
• Order Fulfillment and Delivery: Monitored inventory across main and sub-warehouses to ensure timely order fulfillment, meeting a 100% order delivery rate target.

Walmart China Inventory & Demand Planning Management:

• Store and Inventory Oversight: Managed operations for over 380 Walmart stores in China, overseeing annual sales of $150M and a $12M inventory. Handled 400+ SKUs, including new product launches, promotions, and seasonal sales forecasts.
• Demand Planning: Developed demand plans for FMCG categories, aligning with category and sales strategies. Achieved forecast accuracy of over 80% by managing sales trends, peak sales periods, and system adjustments for unreasonable predictions.
• Forecast and Event Planning: Manually reviewed and adjusted forecasts for promotions and seasonal events to ensure accurate stock availability, achieving "right quantity at the right time" goals.
• Open-to-Buy (OTB) Planning: Collaborated effectively with the procurement team to develop and execute Open-to-Buy plans, ensuring alignment with budget targets and inventory strategies.
• Order Fulfillment: Monitored order fulfillment and worked with the Buyer and Store Operations teams to implement product displays, promotions, and listing execution. Maintained a 98% in-stock rate and a 98% order fill rate.
• Supplier Coordination: Tracked supplier delivery progress, resolved order exceptions, and ensured on-time product availability at stores.
• Inventory Management: Controlled purchase budgets, managed sluggish inventory and EOL (end-of-life) products, and improved product efficiency and shelf-life management. Reduced inventory by 41% and decreased DOH (Days on Hand) by 20 days, achieving a 30-day inventory turnover target.
• Peak Season Planning: Prepared advance inventory purchase plans for peak periods like CNY, ensuring smooth DC inventory flow and avoiding shipping disruptions caused by fluctuations.
• Data-Driven Allocation: Analyzed historical sales data to identify replenishment opportunities. Formulated and implemented quarterly/monthly allocation plans, ensuring timely and accurate product distribution, delivery, and restocking.
• Performance Tracking: Coordinated weekly and monthly reports to monitor KPIs, including in-stock rates, availability, return rates, wastage, and turnover. Issued daily KPI reports for fresh food to upper management to support decision-making and progress tracking.
• ROI Optimization: Established stable inventory lists(Forward Buy), managed DC inventory, and controlled product shelf life to meet ROI targets for stable inventory management.

Operations and Replenishment Management for Perishable Milk Commodities:

• Strategic Planning: Combined sales indicators, historical data, promotion strategies, and market trends to formulate product selection plans. Monitored sales to manage product structure, brand mix, purchase quantities, and promotional planning for key products.
• Product Launch and Optimization: Ensured successful product launches and smooth operations. Adjusted display positions and quantities of essential goods based on store-specific needs, product attributes, wastage analysis, and shelf sell-out rates to optimize placement and reduce waste.
• Performance Achievements: Increased in-stock rates to over 95% and boosted daily sales by 2% through strategic inventory and display management.
• Inventory and Sales Management: Conducted inventory turnover analysis to develop and implement operational strategies. Optimized inventory and sales structures, improved efficiency, and aligned inventory ordering rhythms with sales trends. Ensured perishable products were sold within their shelf life, reduced stock-outs, and maintained a gross profit margin of 20-35%.
• Business Analysis and Category Optimization: Analyzed business reports to track income, profit, and other KPIs. Enhanced product variety, promoted category sales, and optimized category structures and scenarios (e.g., breakfast and overtime meals) based on business priorities.
• Promotional Impact: Designed and executed targeted promotions that increased sales by 10% during specific periods, aligning with company goals.

Sales Operations and System Implementation for Perishable Goods:

• E-Commerce Sales Management: Oversaw store sales operations on T-mall and JD platforms, driving growth and aligning with platform-specific strategies.