Senior Planning Analyst at ADA Asia Vietnam (2024-07 – Present)
- Bi-weekly lead demand and inventory review (S&OP review) meeting with national/regional clients (Unilever, Opella, Nutifood, Castrol) to align monthly/weekly replenishment plan considering suitable stock level, capacity constraints, suppliers' available stock and updated forecast, and point out supply and inventory risks in order to manage ATP, supply flow, DOI target by client by SKU level and SLOB rate.
- Monthly/Weekly/Daily control FCA of outbound plans for e-Commerce orders (control number of customer orders per day per platform) by evaluating and analyzing AOV, campaign periods, sell-out target and promotions to ensure enough human resources and warehouse capacity.
- Manage inbound plans for multiple types of FGs (single, hard bundles, virtual bundles) by following up and capturing sales trend per FG's type, upcoming production plan, stock status at suppliers to maintain workforce and infrastructure availability, resulting in increasing supply accuracy and reasonable stock level, and reducing stock issues.
- Yearly/Quarterly/Monthly/Weekly estimate and keep track of capacity planning for various warehouses including storage sites, storage capacities, full-time/part-time workforces to reduce overtime cost and utilize warehouse spaces up to 90%.
- Monitor and take actions for quarantine stock quantities (expiring and expired stock) by switching stock between different sales channels and reallocating stock between product's types (main, gift) to decrease SLOB value under 0.05% of total inventory value.
- Contribute to company's projects of building new WMS system, standard templates for required reports, launching NPI products.
- Make monthly/weekly inventory reports and required reports to highlight inventory status and update action plans.
Key achievements
- Increased Available-To-Purchase (ATP) rate for finished goods (FGs) from 90% to 99%.
- Increased Forecast Accuracy (FCA) for outbound orders from 60% to 85%.
- Decreased 25% of average storage fee during the first two quarters in 2025 compared to 2024 by building new Way-of-Working (WOW) and Re-order point (ROP) logic.
- Reducing 80% of manual execution time by conducting automatic reports leveraging Power Query and proposing formula for categorizing inventory's types.
Supply Planning Executive at CJ Foods Vietnam (2023-02 – 2024-03)
Supply Planning Intern - Young Talents Program 2022 at CJ Foods Vietnam (2022-07 – 2023-02)
- Daily captured historical sales and analyzed, updated forecasts/promotions for MTS/MTO products of Chilled, Ambient, Frozen categories considering products' building blocks to prioritize production plan, highlight supply risks and forecast changes on time.
- Controlled supply accuracy, supply flow, ITR, products' shelf life by analyzing and evaluating yearly/monthly/weekly/daily MPS/production plans for domestic/export FGs to manage DOI, acceptable safety stock, sales opportunities.
- Yearly/Monthly/Weekly/Daily kept track of OTIF, inventory, ROP, order quantity of seasonal fresh products, materials based on MRP, inventory policy to build call off plan, place purchasing requests, point up obsolete materials.
- Validated BOM accuracy, checked new BOM to prevent shortages/overstock due to seasonality, loss rate and ordered materials for new products on time.
- Monitored and followed up on materials transfer and stock among different factory sites.
- Contributed and supported related teams (Marketing, R&D, Production, Procurement) to ensure the target launch timeline for NPI products.
- Decided actions for SLOB products to minimize disposal/write-off value.
- Made monthly and weekly reports for sales and production to highlight supply and inventory risks.
Key achievements
- Successfully decreased OOS rate of FGs to under 5%/week and SLOB rate to under 0.05%/year.
- Controlled supply accuracy for DCs and OTIF rate to more than 99%.
- Participated in launching Less Spicy Kimchi in 2023 by working with related teams from trial gate to mass production gate.
- Completed CJ Foods Young Talents Program with 89 marks and be promoted to Supply Planning Executive.
