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

Charlotte Yao

available

Last update: 06.09.2022

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)

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

Project history

08/2018 - 03/2020
Master Planner
Transtar Industry (Automotive and vehicle construction, 1000-5000 employees)

* 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 (Consumer goods and retail, 50-250 employees)

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

Local Availability

Only available in these countries: Thailand
Profileimage by Charlotte Yao Supply Chain/Logistics/Inventory/Demand Planning/Data Analysis from Bangkok Supply Chain/Logistics/Inventory/Demand Planning/Data Analysis
Register