Jingxuan (Bill) Wang

Master's

Economics

Hyundai GLOVIS

Senior Analyst, Process Improvement

• Proposed new KPIs through operational data analysis by SQL, utilized Power BI to highlight the Key measurements to the Managements, and maintained Monthly Corporate KPI Report to ensure 100% on-time delivery • Certified SmartWay EPA project successfully to reduce emission by automatically collecting Shipment data with Map API and Excel VBA Macro, conducted comprehensive data analysis by validating, transforming raw data and calculating logistics metrics to measure emissions for overall logistics operations by Excel and SQL Server • Utilized MS Visio to create comprehensive billing process flowcharts for a Trailer Logistic office through interviews, summarized billing processes to identify pain points for new system improvement, and developed a frequent billing issue checklist that eliminated the recurrence of billing errors and improve billing efficiency by 30% • Integrated Apache Spark with SSMS to handle and analyze the large-scale Vehicle Movement dataset for Port Operation, conducted Optimization Scenario Analysis, and utilized CVRP optimization methodology to build customized shuttle scheduling tool by Python and Google OR-Tools to improve the Port Shuttle efficiency by 20% • Developed a mathematical Port Vehicle Parking Optimization Model by Python to analyze cost-benefit scenarios between 5-deep and 2-deep parking configurations considering space constraints, labor efficiency, and peak demand patterns, resulting in optimized parking space cost efficiency by 30% across multiple ports