Yuan Zhao
Demand Planner | Supply Chain Analyst
Rotterdam
Summary
Results-oriented supply chain professional with over four years of experience in demand planning, inventory management, and global logistics. Proficient in Excel, Python, SAP, SQL, and Power BI. Recognized for strong stakeholder communication, effective collaboration, and a proven track record in driving process improvements and enhancing operational efficiency.
Overview
5
5
years of professional experience
5
5
years of post-secondary education
Work History
Supply Chain Analyst | Demand Planner
Braskem
Rotterdam, South Holland
6 2023 - Current
- Managed Global Supply Balance: Demand Planner for import Polymer business, addressed raw material shortages, vessel delays, and production constraints to ensure material availability.
- Optimized Inventory: Reduced total inventory by 30% , and achieved 0% aging stock for responsible grades.
- Enhanced Forecast Accuracy: Improved forecast accuracy to over 90% and developed KPIs for material loss and aging inventory, cutting EU warehouse aging stock by 50%.
- Process and Control Analyst: Led team efforts to resolve operational issues, implemented automation to reduce manual tasks, and streamlined communication with third-party warehouses for smooth control.
- Improved Transfer Pricing: Achieved a 15% reduction in transfer costs through effective inventory and quality control.
- SOX Audit Control: Led SOX audit control for all EU warehouses, ensuring stock accuracy over 99.5%. Successfully passed stringent monthly, quarterly, and annual SOX audits.
- ISO 9001 Compliance: Ensured compliance with ISO 9001 standards, contributing to consistent quality management and process improvements.
- Key Achievements: Ongoing conversion of $1 million in inventory to cash through strategic reductions.
Supply Chain Planner
Braskem
Rotterdam, South Holland
01.2023 - Current
- Coordinated Procurement and Sales: Managed immediate purchases and material allocations to ensure optimal demand-supply balance and support market share in a competitive industry.
- Enhanced Reporting and Insights: Developed and published Order Intake reports to provide actionable sales insights and drive informed decision-making.
- Forecast Accuracy and Sustainability: Updated Forecast Accuracy and Carbon Credit reports, contributing to a 10% reduction in carbon footprint and strengthening ESG strategy.
- Global Allocation Support: Supported global allocation processes, focusing on efficient supply chain coordination and material availability for key regions, including Asia.
- Stakeholder Collaboration: Served as a key liaison between global supply chain and sales teams, resolving allocation issues and consistently meeting monthly billed volume targets.
- Inventory Management: Conducted stock adjustments across EU warehouses, improving stock accuracy and inventory control through close collaboration with logistics teams.
Logistic Procurement Intern
The Kraft Heinz Company
Amsterdam, North Holland
07.2022 - 01.2023
- Cost Savings Initiatives: Initiated master data management for repack activities in EMEA, targeting over $1M in potential annual cost savings through efficient process optimization.
- Procurement Optimization: Drafted and negotiated procurement contracts to enhance terms and drive cost efficiencies.
- Financial Operations: Resolved overdue invoices exceeding $2M, ensuring uninterrupted financial operations and maintaining strong supplier relationships.
- Competitive Analysis: Analyzed competitors such as Unilever and Nestlé in electric and LNG truck markets, and conducted sourcing and benchmarking for electric truck pricing.
- Packaging Solutions Evaluation: Assessed the use of paper packaging and recycled plastic bottles, and performed competitor analysis to identify innovative packaging solutions.
- Supplier Evaluation: Assisted in evaluating suppliers' service levels, financial stability, and pricing to ensure reliable and cost-effective procurement.
Demand Planning Intern
JD.COM
Rotterdam, South Holland
01.2022 - 06.2022
- Inventory Reduction: Reduced inventory by 12% across 200+ beverage SKUs, optimizing stock levels and improving material availability.
- KPI Reporting: Delivered weekly KPI reports to buyers and logistics teams, providing actionable insights for demand and supply management.
- Process Improvement: Streamlined new product line processes using data analysis and feedback, enhancing efficiency and operational effectiveness.
- Order and Promotion Management: Efficiently managed orders, promotions, and pricing, ensuring accurate allocation and timely fulfillment.
Supply Chain Planner
China Railway
07.2020 - 12.2020
- Reduced Aging Inventory: Decreased aging spare parts inventory by 15% through enhanced demand forecasting and implementing a FIFO stock rotation system, improving material availability.
- Increased Inventory Turnover: Boosted inventory turnover rate by 10% by streamlining inventory management processes and minimizing excess stock, leading to more efficient resource utilization.
- Optimized Scheduling: Analyzed demand data to refine train schedules, achieving a 10% improvement in on-time delivery rates and better resource allocation.
- Operational Efficiency: Contributed to smoother operations and enhanced customer service through improved inventory management and resource planning.
Data Analyst
China Railway
01.2020 - 06.2020
- Passenger Flow Optimization: Analyzed passenger flow during peak periods such as the Spring Festival and public holidays to provide recommendations for train deployment, minimizing capacity shortages and ensuring effective passenger travel.
- Freight Demand Analysis: Conducted in-depth analysis of freight transportation demand using multivariate regression models, incorporating variables like shipping costs, PMI indices, and railway prices to identify key demand influencers.
- Insight Generation: Delivered critical insights on the most significant positive and negative factors affecting freight demand, supporting strategic decisions for the business analysis department.
Education
Master's Degree - Maritime Economics and Logistics
Erasmus University Rotterdam
10.2021 - 01.2023
Bachelor - Statistics
Henan University
09.2017 - 06.2021
Skills
Problem Solving
Excel
Team Collaboration
Power BI
Python
SQL
Effective Communication
Personal Information
Driving License: Driving license category B
Timeline
Supply Chain Planner
Braskem
01.2023 - Current
Logistic Procurement Intern
The Kraft Heinz Company
07.2022 - 01.2023
Demand Planning Intern
JD.COM
01.2022 - 06.2022
Master's Degree - Maritime Economics and Logistics
Erasmus University Rotterdam
10.2021 - 01.2023
Supply Chain Planner
China Railway
07.2020 - 12.2020
Data Analyst
China Railway
01.2020 - 06.2020
Bachelor - Statistics
Henan University
09.2017 - 06.2021
Supply Chain Analyst | Demand Planner
Braskem
6 2023 - Current
Similar Profiles
Melissa HuvarMelissa Huvar
Process Operator at BraskemProcess Operator at Braskem
Cristiano Favero NettoCristiano Favero Netto
Líder de equipe at BraskemLíder de equipe at Braskem
Dustin JohnsonDustin Johnson
Senior I/E Tech at Braskem PolymersSenior I/E Tech at Braskem Polymers