Haolin Yang Email & Phone Number

Pittsburgh, Pennsylvania, United States

• Strategically planned and purchased over 10,000 components per month using Material Requirements Planning (MRP) systems, ensuring 100% alignment with the production schedule and maintaining optimal inventory levels for finished goods.• Collaborated with production planners to proactively identify stock-out risks for critical BOM components, successfully expediting orders with suppliers and identifying alternative sources to reduce stock-out incidents by 35%, thereby minimizing production delays and ensuring on-time delivery.

United States

• Customized Power BI models to dynamically showcase department-specific data, enhancing data visibility and decision-making. • Preparing reports to the managers.• Managed and updated inventory values and lead time through SAP, ensuring real-time accuracy and reliability.• Developed SQL scripts to conduct in-depth analyses of inventory value, lead times, safety inventory, and customer order statuses, driving operational efficiencies and strategic insights.

• Design and testing one supply chain warehouse operating system and successfully launching• Develop logistics analytics to make operational performance and trend visible• Develop reporting capability for supply chain Key Performance Indicators• Cooperate with warehouse, accounting, project planning, logistics, and purchasing department• Performance other work support such as data sorting, contract sealing, recruitment interview, package management

• Organize student quality training activities and mental health publicity and education• Develop activity planning, write program PPT, and promote the implementation

• Created slides show for the teacher to use during lecture• Negotiated with other teachers to coordinate the time and uses of the classroom• Graded students’ homework and connected with student’s parents about any concerns• Brought the “Student + Teacher” model to the school