Siyu Wang
Los Angeles,CA
Summary
Business Analyst with experience in Excel-driven KPI reporting, logistics node tracking, and customs brokerage support. Skilled in building automated dashboards, performing variance and root-cause analysis, and monitoring SLA and operational performance across end-to-end supply chain workflows.
Overview
2
2
years of professional experience
Work History
Operations Manager
ALLIED CHB INC
10.2025 - Current
- Built, maintained, and automated Excel-based KPI dashboards using PivotTables, Power Query/Power Pivot, XLOOKUP/INDEX-MATCH, and advanced formulas to track on-time performance, dwell time, cycle time, SLA attainment, and exceptions.
- Performed variance, trend, and root-cause analysis to identify late milestones, anomalies, and data integrity issues; recommended corrective actions.
- Managed end-to-end logistics node tracking across origin, linehaul, gateway, customs clearance, release, and final delivery; monitored cut-offs and recovery plans.
- Reconciled shipment records with ISC and related charges, resolving discrepancies and ensuring timely approval and payment.
- Coordinated with customs brokerage teams to track CBP entry status, release timelines, and compliance documentation; escalated SLA-impacting exceptions.
- Translated operational requirements into data solutions by collaborating with internal developers and external partners; standardized SOPs for data intake, exception handling, and KPI reporting.
Business Analyst
LOGIS EQUIPAR INC
02.2025 - 10.2025
- Introduction and establishment of a data collection system with the airlines to obtain significant operational data accurately and efficiently.
- With growing business, methodically improve the shipping related data collection system, Amazon warehousing and one-piece delivery.
- Configuration to meet differing business segments' data analysis demands (aviation, shipping, Amazon warehouse, etc.) to establish operational transparency.
- Ongoing analyzing and dealing with complex sets of data of flights and shipment to ensure integrity and consistency in data.
- Identify operation inefficiencies and provide optimization recommendations with data analysis to maximize overall operation efficiency.
Business Analyst
King Speed INC
09.2024 - 02.2025
- Establishing and maintaining data collection processes with our airline partners to gather essential operational data accurately.
- Monitoring and documenting daily operational progress using advanced data visualization tools to update tracking systems and create comprehensive reports
- Regularly analyzing and managing detailed data sets related to daily flight and cargo information, ensuring high data integrity.
- Conducting thorough data analyses to identify inefficiencies and recommending strategic improvements to optimize operational processes.
- Handling data projects and providing analytic support to various teams to enhance data-driven decision-making across the organization.
Business Analyst
USTOSHOP.COM, Inc
05.2024 - 09.2024
- Led data analysis across end-to-end logistics operations, including warehouse processing, T86 customs clearance, and long-haul trucking (LAX–DFW).
- Analyzed clearance timelines and exception patterns to streamline T86 workflows, significantly reducing average clearance time.
- Built operational tracking systems to monitor shipment status, carrier performance, and delivery timeliness across multiple logistics nodes.
- Conducted cost and service-level analysis to support warehouse and trucking partner selection, contract negotiation, and pricing decisions.
Education
Master of Science - Business Analysis
Trine University
Phoenix, AZ05-2025
Bachelor of Arts - Visual Studies
Ringling College of Art And Design
Sarasota, FL05-2023
Skills
- KPI design
- SLA monitoring
- cycle time & dwell time analysis
- exception analysis
- Logistics analytics
- customs clearance processes
- bonded warehouse operations
- data visualization
- data analysis
Languages
English
Professional Working
Chinese (Mandarin)
Native or Bilingual
Timeline
Operations Manager
ALLIED CHB INC
10.2025 - Current
Business Analyst
LOGIS EQUIPAR INC
02.2025 - 10.2025
Business Analyst
King Speed INC
09.2024 - 02.2025
Business Analyst
USTOSHOP.COM, Inc
05.2024 - 09.2024
Master of Science - Business Analysis
Trine University
Bachelor of Arts - Visual Studies
Ringling College of Art And Design