Hao Li
Logistics Strategist at Mascon, Inc.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
-
Chinese (Simplified) -
Topline Score
Bio
Credentials
-
CTL.CFx: Supply Chain Comprehensive Exam
edXDec, 2021- Oct, 2024 -
CTL.SC4x: Supply Chain Technology and Systems
edXOct, 2021- Oct, 2024 -
CTL.SC3x: Supply Chain Dynamics
edXJul, 2021- Oct, 2024 -
Complete Python Bootcamp From Zero to Hero in Python
UdemyJul, 2021- Oct, 2024 -
Unlock Excel VBA and Excel Macros
UdemyJul, 2021- Oct, 2024 -
CTL.SC2x: Supply Chain Design
edXApr, 2021- Oct, 2024 -
SQL Bootcamp
UdemyMar, 2021- Oct, 2024 -
Certified in Production and Inventory Management (CPIM)
APICSJan, 2021- Oct, 2024 -
CTL.SC1x: Supply Chain Fundamentals
edXJun, 2020- Oct, 2024 -
CTL.SC0x: Supply Chain Analytics
edXDec, 2019- Oct, 2024 -
Excel Skills for Business Specialization
CourseraApr, 2019- Oct, 2024 -
Mastering Data Analysis in Excel
CourseraMar, 2019- Oct, 2024 -
Data Visualization and Communication with Tableau
CourseraFeb, 2019- Oct, 2024 -
DATA ANALYST IN PYTHON
Dataquest.ioMar, 2018- Oct, 2024 -
Lean Green Belt Certificate
Institute of Industrial and Systems EngineersOct, 2017- Oct, 2024
Experience
-
Mascon, Inc.
-
United States
-
Transportation, Logistics, Supply Chain and Storage
-
1 - 100 Employee
-
Logistics Strategist
-
Nov 2019 - Present
• 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. Show less
-
-
Supply Chain Analyst
-
Jun 2018 - Nov 2019
• 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. Show less
-
-
-
Northeastern University
-
United States
-
Higher Education
-
700 & Above Employee
-
Teaching Assistant
-
Sep 2017 - Dec 2017
• 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 • 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 Urban Construction Investment& Development Co., Ltd.
-
China
-
Leasing Non-residential Real Estate
-
1 - 100 Employee
-
Designing Engineer
-
Aug 2014 - May 2016
• 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. • 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.
-
-
-
China Railway Group Limited
-
China
-
Civil Engineering
-
100 - 200 Employee
-
Commodity Planner/Scheduler
-
Aug 2013 - Jul 2014
• 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. • 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.
-
-
Education
-
Northeastern University
Master's degree, Industrial Engineering -
Southwest Jiaotong University
Bachelor's degree, Railroad and Railway Transportation -
MITx on edX
MITx MicroMasters Program Certificate, MITx MicroMasters program in Supply Chain Management – Massachusetts Institute of Technology on edX