Profilbild von Charlotte Yao Supply Chain/Logistics/Inventory/Demand Planning/Data Analysis aus Bangkok

Charlotte Yao

verfügbar

Letztes Update: 06.09.2022

Supply Chain/Logistics/Inventory/Demand Planning/Data Analysis

Abschluss: Master in Supply Chain Management in The University of Texas at Dallas
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: chinesisch (Muttersprache) | englisch (verhandlungssicher)

Skills

CERTIFICATION
Certified in Production and Inventory Management (CPIM), APICS                                                                   Nov 2018
Lean Six Sigma Green Belt                                                                                                                                 Apr 2018
EXPERIENCE
 4-year + Supply Chain experience in Sales & Operation Analysis, Demand Planning, Inventory Management, Logistic analysis in both E-commerce retail and Automotive manufacturing industry
SKILL
 Advanced excel (Modeling, VBA, Pivot table), R, SQL, Power BI, SAP

Projekthistorie

08/2018 - 03/2020
Master Planner
Transtar Industry (Automobil und Fahrzeugbau, 1000-5000 Mitarbeiter)

* Improved the 30% efficiency in demand planning process by restructuring demand planning model based on the statistical
methodology and building supported datafiles
* Conducted capacity planning and provided monthly production goal, labor plan for each cell based on firm orders,
planned orders, forecast and financial plan
* Reviewed weekly forecast of 80% of manufacturing SKU and scheduled the pacemaker in mixed-model production with
3k+ different part numbers and 100+ setups per week
* Conduced performance report and analyzed key metrices of production performance in daily base, proactively driving
contingency plan based on supply and capacity constraints
* Worked under continuous improvement team to identify the opportunity of reducing operation cost and sale growth by
analyzing the value stream process, product design, supply constraints and manufacturing capacity
* Collaborated with sales and business unit to launching new products and troubleshooting manufacturing issue
* Assisted international procurement process by liaising with Chinese suppliers to mitigate material supply risks

01/2018 - 08/2018
Business Analyst
Zuri Furniture (Konsumgüter und Handel, 50-250 Mitarbeiter)

Zuri Furniture is a fast-growth Ecommerce furniture company. It is expert at integrating Brick-and-Mortar and Ecommerce channel and using data analytic tools to operate business
* Saved at least 15% TX freight cost by running scenario analysis and delivering result in assembler contract negotiation
* Performed statistical analysis to interpret the optimal location for new warehouse by using VBA and Power Map
* Improved the inventory flexibility of critical items by designing dynamic Excel model to monitor interchangeable parts
* Assisted senior operation manager to track sales activities in various online channel and report on the periodic basis
* Trained foreign data entry team to update established operation reports in daily bases and build 500+ SKUs in ERP
* Collaborated with marketing team in marketing campaign project by data reporting, analysis, launching promotion plan,
and managing HTML website template

Reisebereitschaft

Verfügbar in den Ländern Thailand
Profilbild von Charlotte Yao Supply Chain/Logistics/Inventory/Demand Planning/Data Analysis aus Bangkok Supply Chain/Logistics/Inventory/Demand Planning/Data Analysis
Registrieren