Theo Ngo
United Kingdom
Summary
A highly motivated and result-orientated professional with a strong background in management and a keen eye for detail, I drive operational excellence and deliver exceptional results, with a proven track record of optimizing internal workøow with my ability to analyse complex data, identify trends, and develop innovative solutions. I am also an effective communicator and team player, preferring to build positive relationships with my colleagues and stake holders alike at all levels. With a proactive mindset, I am ready to hit the ground running, and create signiöcant impact wherever my next challenge may take me.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Supply Planner
L'Oreal UKI
09.2024 - Current
- Manage a portfolio of 280 sellable SKUs.
- Improved monthly service level from an average of 82% to 92%, and reduced SLOBs from 10% to 3%.
- Successfully navigated a warehouse system transformation project by achieving a 100% service rate during the stock-building period, while maintaining slow-moving inventory at 3%.
- Collaborate effectively with a third-party vendor, successfully negotiating to deliver all ad hoc sets across the year.
- Report on inventory shortages, conducted root cause analysis, and assessed forecasting needs to enhance team and management decision-making, driving KPI improvements across demand and supply functions.
Demand and Supply Planner
L'Oreal Hong Kong
08.2023 - 05.2024
- Leading the monthly S&OP process, including developing data-driven forecasts, collaborating with cross-functional teams for plan reconciliation, and executing supply plans using SAP.
- Maintained 75% forecast accuracy across two brands under my supervision, with bias variance within 20%, while keeping SLOBs below 5% of the total portfolio.
- Analyzed historical sell-in and sell-out data (500k+ records) to evaluate promotion effectiveness, developing an actionable plan to improve forecast accuracy.
- Coordinated promotional and new product launch activities, ensuring sufficient product availability during peak periods.
- Collaborate with the Logistics & Warehouse team to ensure timely order processing.
Management Trainee (Operation)
L'Oreal Hong Kong
07.2022 - 07.2023
- Rotated through Commercial, Marketing, Retail, and Warehouse departments, gaining end-to-end supply chain exposure.
- Developed automated dashboards and Excel reports, optimizing workflows and reducing warehouse rework lead time.
- Led the pilot implementation of a Power BI dashboard with a 3PL partner, improving lead time transparency and stakeholder coordination.
- Gained IBM Data Analyst Certification
Education
BBA (Hons) - Global Supply Chain Management
The Hong Kong Polytechinc University
01.2022
DSE Public Examamination -
Raimondi College
03.2017
Skills
- VBA
- SQL
- Python
- MS Excel
- Power BI
- SAP System experience
- Data management
- Project management
- Strategic planning
- Effective communication
- Team work
- Fast learning
Certification
IBM Data Analyst Certification
Timeline
Supply Planner
L'Oreal UKI
09.2024 - Current
Demand and Supply Planner
L'Oreal Hong Kong
08.2023 - 05.2024
Management Trainee (Operation)
L'Oreal Hong Kong
07.2022 - 07.2023
IBM Data Analyst Certification
BBA (Hons) - Global Supply Chain Management
The Hong Kong Polytechinc University
DSE Public Examamination -
Raimondi College
Similar Profiles
Nicole O'GormanNicole O'Gorman
L'Oreal Professionel & Kerastase Business Partner at L'Oreal IrelandL'Oreal Professionel & Kerastase Business Partner at L'Oreal Ireland
Debora DominguesDebora Domingues
Senior Makeup Artist at L'Oreal Luxe UKI, Armani BeautySenior Makeup Artist at L'Oreal Luxe UKI, Armani Beauty
Simran SandhuSimran Sandhu
Strategic Advisor-Integrations and Validations at The UKI- Department of DefenseStrategic Advisor-Integrations and Validations at The UKI- Department of Defense