Profileimage by Charlotte Yao Supply Chain/Logistics/Inventory/Demand Planning/Data Analysis from Bangkok

Charlotte Yao


Last update: 06.12.2020

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

Graduation: Master in Supply Chain Management in The University of Texas at Dallas
Hourly-/Daily rates: show
Languages: Chinese (Native or Bilingual) | English (Full Professional)


Data Entry Data Analysis Supply Chain Demand Planning inventory control USA Thailand China


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

Project history

08/2018 - 03/2020
Master Planner
Transtar Industry (1000-5000 employees)
Automotive and vehicle construction
* 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 (50-250 employees)
Consumer goods and retail
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

Contact form

Contact details