Experience

Fuyao Glass Corporation of America

• United States
• Glass Product Manufacturing
• 1 - 100 Employee

• EDI Specialist

  • Aug 2023 - Present

  Moraine, Ohio, United States • Checked, verified, monitored, and reported the real-time orders, shipment, inventory, and maintenance data regularly in PLEX system for 9 leading automakers to arrange demands to shipments and ensure timely completion of customer orders • Analyzed planning and inventory data, and monitored execute status for each department to provide proper suggestions to support fixing abnormal situation using PLEX system, and refined the using process for customers to improve efficiency • Conducted… Show more • Checked, verified, monitored, and reported the real-time orders, shipment, inventory, and maintenance data regularly in PLEX system for 9 leading automakers to arrange demands to shipments and ensure timely completion of customer orders • Analyzed planning and inventory data, and monitored execute status for each department to provide proper suggestions to support fixing abnormal situation using PLEX system, and refined the using process for customers to improve efficiency • Conducted monthly sales forecast for 8 top automakers including 500+ parts with accuracy over 90% via Excel using EDI order data in PLEX system and helped increase the accuracy of production planning process concerning MRP and PRP • Evaluated, summarized, and reported to internal departments about the feasibility of SOP plans based on PLEX data to confirm new material planning attribute and updated production reduction plan to consume inventory for EOP plans Show less



JD Group

• Mexico
• Transportation, Logistics, Supply Chain and Storage
• 1 - 100 Employee

• Marketing Operating

  • May 2021 - Jul 2021

  Nanchang, Jiangxi, China • Managed the online operating system of community group grocery purchases to compare sales, prices and prioritize daily top products from 10K+ product items covering 300+ communities in 7 cities, including Tier 2 to Tier 5 cities • Built dynamic dashboards to monitor daily operating data extracted from the database via MySQL and generated daily and weekly reports about the performance of product selection and promotion strategies to optimize marketing operation • Provided proposals based… Show more • Managed the online operating system of community group grocery purchases to compare sales, prices and prioritize daily top products from 10K+ product items covering 300+ communities in 7 cities, including Tier 2 to Tier 5 cities • Built dynamic dashboards to monitor daily operating data extracted from the database via MySQL and generated daily and weekly reports about the performance of product selection and promotion strategies to optimize marketing operation • Provided proposals based on daily competitive analysis of 7 competitors in 5 categories and increased sales by 22.3% Show less



HiRain Technologies

• China
• Motor Vehicle Manufacturing
• 1 - 100 Employee

• Market Research Intern

  • Mar 2019 - Apr 2019

  Beijing, China • Conducted text analysis on RStudio of the testing reports from 4 leading automakers and 3 consulting companies to evaluate the strengths and weaknesses of the 3 latest driverless technologies used in the field of self-driving vehicle • Created a Power BI report to analyze and present the sales, comments, and ratings of the major driverless vehicle models, and summarized the key customer buying factors and preferences based on the regional distribution in China



PwC mainland chin

• China
• Accounting
• 700 & Above Employee

• Audit Intern

  • Dec 2018 - Feb 2019

  Beijing, China • Applied Vlookup and PivotTable on Excel in year-end auditing to automatically reviewed and checked for data accuracy from 18 financial statements of 31 subsidiaries of a major telecommunication corporation including 4K+ data rows • Composed and updated 68 contracts for subsidiaries of the client company under the latest compliance requirements