Kevin Wong
Execution Planner · Estee Lauder Company
Acheng, Hong Kong SARIn My Own Words
With 16 years working experiences in the field of supply chain, working in LVMH Group over 8 years included 3 years in Sephora Hong Kong. Supported Sephora Hong Kong to open the first flagship store in Hong Kong in 2019, then extended the business with 3 stores within two years. Also work in a well-known cosmetic brand Estee Lauder as an Execution Planner, mainly handle the inventory planning and inventory management for two brands which Tom Ford and Bobbi Brown in the company Knowing the knowledge of the whole procedures of supply chain started from demand planning, shipping, and warehousing until the products to stores and end-customers. Sales projection/forecast according to the past records to calculate the replenishment plan for some promotions/events like Black Friday, Valentine's Day, Mother's Day, Sogo Thankful week or Private Sales etc. Excellent to use SAP by different type of T-codes and MS Excel like formula xlookup, sumifs, pivot table, Power BI etc.
Work Experience
Execution Planner
Estee Lauder Company2023 – 2023
Execute the inventory planning and inventory management for the company which, * Monitor and review the S&OE (Sales & Operation Execute) report weekly to ensure the inventory level is in a good condition, and calculate the fulfilment rate to spot out if any out-of-stocks situation. Requesting Air shipment to hubs in Singapore if urgent * Work closely with brand team and commercial team on stocks issues like additional stocks request in specific period such as Sogo Thankful week, the Holiday or new product launch or stocks for super VIP etc. * Presenting the supply outlook and excess accountability to brand teams in monthly Consensus Meeting like the fulfilment rate in coming three months and any excess stocks to be planned * Stocks excess management to avoid the over-stocks situation and communicate with brand team on action plan to clear the excess quantity like adjusting the forecast base on a new plan, looking for stocks redeployment to other markets * Communicate and work with Regional team on stocks excess accountability to meet the KPI requirement, the execution plan like communicate with other markets and offer the excess qty * Cross check some reports from Regional or from Global, and will negotiate with Regional team if found any anormal figures and clarify the definition behind the figures in reports * Handling the CRM items to be packed according to monthly forecast, then give an order and instruction to warehouse for packing like order creation in SAP or BOM changes etc. * Monthly review the inventory if any stocks to be expired, then give a recommendation to brand team or commercial team to use the stocks avoid any stocks disposal * Procedures enhancement for the teammates like minimize the work flow, running data automatically in excel, data consolidation in one etc.
Supply Chain Executive
Sephora Hong Kong2019 – 2023
Supporting the whole processing of supply chain for the company which, Demand Planning * Preparing the sales projection to estimate the sales performance during some campaigns like Black Friday, Mother's Day, Animation etc. aim to top-up the replenishment order for driving more extra sales * Communicate with local Merchandising team, France team and Regional Merchandising team on new launch planning in each month, then send out the purchase order to brands * Calculate on demand forecast for the replenishment plan based on historical data in past 3 months which corresponds with the Open-to-Buy budget * Keep review the Day of Inventory (DOI) as an index from Domo to avoid/minimize any over-stocks situation and take a proactive action/plan to clear the slow-moving items * Reviewing the stock level of supply materials like shopping bags, uniforms, gift boxes, theme papers, gift card etc. monthly, and send out the replenishment order to suppliers for reordering if lower than the safety stocks * Monthly review the replenishment level in system for three retail stores and ecommerce business to avoid/minimize any out-of-stock situations * Work with Marketing team/Ecommerce team on GWPs/Samples/CRM redeem arrangement and delivery such as GWPs bundling, ordering GWPs from brands, ensure to support the GWP stocks for the virtual bundling online etc. aimed to drive more sales during the promotion period * Suggest all available materials on-hand like gift boxes or paper bags to Marketing team for repacking the GWPs/Samples for coming events * Evaluate the consumption/redemption rate which data are coming from system after the events and purpose the solution for the rest of GWP stocks like for next events or to dispose or office gift or donation etc. * Schedule return planning for the products/to be expired products/discontinued products to vendors according to the contract with brands * Preparing the replenishment plan for Cross-Border E-commerce in China Logistic and warehousing * Communicating with vendors and forwarders on the shipping arrangement, to ensure the shipping documents like commercial invoice and picking list are submitted to meet the requirement of Customs * Arrange the shipments for furniture like grids or planogram to the design company in Hong Kong * Daily monitoring the picking and packing status of B2C and B2B orders can be fulfilled and make sure all B2C orders can pass to courier successfully * Batch control for products, then move to non-active location in system and warehouse to avoid the expired/to be expired products deliver to customers and stores, for those products, will schedule a private sale to clear the balance to minimize the dead stocks * Optimize the SOP in warehouse to maximize their productivity to support the company business * Arrange the shipment to Bonded warehouse in China
System maintenance and reporting * Cross-check if any interface failure for the transactions, then raise a ticket to IT for the solution * Monthly generate the movement report from system for checking any abnormal transactions * Monitoring and maintaining the summary report of inbound shipment to minimize any outstanding shipments/products Invoice and budget control * Take in charge to plan and execute the whole procedure of stocktake in all channels in the company yearly * Work with Finance to accrual the budget of warehouse expenses due to year-end cut-off * Cost consideration on GWPs bundling like the type of packaging, additional charges from 3PL etc. * Reporting the expense of bundling to Finance monthly and reclass the amounts to Marketing budget
Inventory Control Supervisor
DFS2014 – 2019
Performing and monitoring the procedure of stocktake for all channels in Hong Kong market where have 3 retail stores in downtown, Hong Kong International Airport and Global Distribution Centre * Schedule the stocktake planning to stores and warehouse based on the past adjustment records * Inventory reconciliation of stocktake results against the cut-off timeline of inventory, then prepare the count result report to management for approval before any adjustments in system * Reviewing the SOP of stocktake for store teams and optimize the procedures to minimize the products lost * Providing and scheduling a stocktake training for store teams * Execute the count schedule for high value products monthly to avoid the lost
Senior Clerk
Sporthouse2008 – 2014
Retail and buying support to the company
Education
BSc
University of Plymouth2015
secondary
Wai Kiu College2003
HKCEE
Wai Kiu College2001