Yuzhen Lang

Analyzed more than 500,000 package, route, driver, delivery-partner, and station records using Excel, Python, SQL, Power BI, and Streamlit to identify performance trends, service risks, and operational improvement opportunities across the Western United States. Built automated dashboards and recurring reports to monitor delivery KPIs, failed deliveries, package volume, driver pickup activity, route performance, labor hours, and station capacity, improving reporting accuracy and leadership visibility. Developed a pickup-time analytics dashboard using driver check-in and check-out times, package quantities, and station data to identify peak operating periods, delays, workload patterns, and capacity constraints.

Regional Support Specialist / Management Trainee at GOFO, Inc. (2025-09 – Present)

• Analyzed more than 500,000 package, route, driver, delivery-partner, and station records using Excel, Python, SQL, Power BI, and Streamlit to identify performance trends, service risks, and operational improvement opportunities across the Western United States.
• Built automated dashboards and recurring reports to monitor delivery KPIs, failed deliveries, package volume, driver pickup activity, route performance, labor hours, and station capacity, improving reporting accuracy and leadership visibility.
• Developed a pickup-time analytics dashboard using driver check-in and check-out times, package quantities, and station data to identify peak operating periods, delays, workload patterns, and capacity constraints.
• Evaluated performance by driver, delivery-service partner, route, station, ZIP code, and reporting period; translated findings into recommendations that contributed to a 20% reduction in failed deliveries.
• Supported new ZIP-code launches, workforce planning, and process-improvement initiatives by analyzing package demand, route coverage, partner capacity, labor requirements, sorting throughput, and station readiness and presenting findings to regional leadership.

Product Analyst at Orbit Industries, Inc. (2024-08 – 2025-08)

• Extracted, cleaned, and analyzed internal ERP data using SQL, Python, Excel, and Power BI to evaluate product sales, purchasing activity, inventory availability, shipment status, costs, and product performance.
• Reviewed sales history, demand trends, warehouse inventory, supplier quotations, open purchase orders, lead times, and incoming shipments to calculate purchasing requirements and recommend purchase-order quantities.
• Monitored purchase orders from supplier production through warehouse receipt by tracking ETD, ETA, international freight from Asia, domestic trucking, warehouse transfers, and product availability.
• Developed a Power BI dashboard that tracked product sales performance, purchasing and delivery costs, landed costs, warehouse inventory, stock risks, and product-management KPIs for leadership and cross-functional teams.
• Conducted market, competitor, pricing, and product-specification research to support new product introduction and helped launch more than 20 electrical-fitting products by coordinating item setup, pricing, purchasing, inventory planning, quality review, and sales materials.

Analyst Intern at Orbit Industries, Inc. (2024-05 – 2024-08)

• Used internal ERP records, Excel, SQL, Python, and Power BI to analyze product sales, inventory, purchasing, shipment, and warehouse data and prepare reports for the product-management team.
• Supported purchase-order planning, ETD and ETA tracking, warehouse-transfer decisions, and new product research by reviewing historical sales, demand, inventory availability, supplier lead times, incoming shipments, competitor pricing, and product specifications.

Data Analyst Intern at China Mobile Communications (2020-06 – 2020-09)

• Collected, cleaned, validated, and analyzed customer-service and satisfaction data using Python, SQL, and Excel to identify service trends, performance issues, and improvement opportunities.
• Prepared dashboards, analytical summaries, and presentation materials to communicate customer-service findings and recommendations to business stakeholders.

M.S. in Analytics, Operations Research Engineering – University of Southern California (2023-08 – 2025-05)

B.S. in Mathematics, Data Science Specialization – University of California, Irvine (2019-09 – 2022-12)