Hao Li Email & Phone Number

Boston, Ma, Us

- Perform analysis across large data sets to develop performance insights and highlight operational opportunities. - Develop key metrics and reporting to measure how initiatives are improving Wayfair’s performance and enabling our team to easily identify trends, root causes and develop targeted action plans. - Leverage a deep understanding of Supply Chain principles to design new initiatives aimed at improving the speed and/or capabilities of Wayfair’s delivery network. - Leverage critical thinking and data handling to examine and challenge existing practices, identify opportunities for improvement, and gain buy-in from stakeholders on proposals.- Collaborate with cross-functional partners in Operations and Tech to support the rollout of new operational initiatives and/or tech capabilities.

United States, Us

Woburn, Massachusetts, Us

• Using Power BI and SQL server, fetched real time data from ERP system, and created a Supply Chain / Finance Dashboard (Shipment, SG&A, Gross Margin, Net Margin, Inventory status, Year-over-year comparison, etc.) for upper-level management’s daily review.• During the pandemic outbreak, cooperating with Mass General Brigham Hospital, led the data visualization part of the “Test Boston” project (https://testboston.org/results-dashboard), which analyzed daily test kits distribution status for over 10,000 participants and their demographics info, within greater Boston area.• Using Excel VBA, developed macro-enabled spreadsheets such as digital catalog with different scenarios and several tiers of price, PO / SO imbalance tracker, etc. to improve quoting process and meeting material preparation efficiency by at least 30%.• Cooperating with account manager, led PDCA & root cause analysis project for 1 key customer, provided key metrics for weekly meetings and QBR with them from Supply Chain side.• Led supply chain coordination between offshore suppliers and domestic customers, organized and tracked $2.6M goods in 2019 and 2020, upgraded new daily report to make sure everything is transparent and up to date to customer.

Woburn, Massachusetts, Us

• Visualized logistics data in customers’ flexible request reports using Excel and Tableau to make them more intuitive and provide help in decision making, improved the compiling efficiency by 50%, reduced weekly discussion time by 20%.• Analyzed and interpreted supply chain relevant data for more than 300 active aerospace / machinery industry parts from MRP report• Monitored shipping status for international / domestic freight to meet customer’s demand of on-time delivery accuracy.• Forecasted customer’s usage using methods such as moving average, linear regression, using ERP/MRP System and past usage.

Boston, Ma, Us

• Helped instructor grade students' homework of ENCP 6000. Give feedback of students' career goals, draft resumes, elevator pitch and resumes etc.• Held 2 workshops to give students opportunities practicing their interview skills and gaining confidence• Collected and concluded common interview questions for class, completed 2 market researches with professor

Beijing, Bej, Cn

• Provided engineering designing solutions as a consultant for cities’ transportation departments of local government.• Produced a 40-page feasibility study report for the city of Nanning as part of a 40-person cross-functional team, resulting in an approval of final version by government officials.• Presented results to transit department government officials, resulting in approvals of three subway projects in two cities.

Beijing, Cn

• Negotiated with six suppliers of consumables such as bottled water, fruit, carpet, sanitizer, vacuum cleaner, and bed linings to meet every transportation task’s service level.• Completed information flows by noticing railway depot, station, and relevant bureaus whenever a transportation task is issued.

Master'S Degree, Industrial Engineering

Bachelor'S Degree, Railroad And Railway Transportation

Mitx Micromasters Program Certificate, Mitx Micromasters Program In Supply Chain Management – Massachusetts Institute Of Technology On Edx