Hayden (Sung Him) Chiu

Led full-cycle analytics project analyzing thousands of under-classified 911 calls to identify operational patterns and inform resource allocation. Translated ambiguous business questions from law enforcement stakeholders into structured hypotheses, analytical plans, and measurable metrics. Built embedding-based models to cluster incident narratives, revealing high-impact themes affecting patrol demand and response times.

Owned end-to-end ETL workflows for APAC supply chain reporting, using SQL and Python to centralize data ingestion, transformation, and validation across multiple operational systems. Redesigned daily ETL pipelines that transformed multi-source purchase order data into SAP-ready formats, reducing manual preparation time from 2 hours to 5 minutes and ensuring consistent KPI outputs. Built automated data quality checks (schema validation, outlier detection, reconciliation logs) that improved the reliability of weekly logistics and shipment dashboards. Developed production-grade reporting pipelines and dashboards (Qlik Sense) that automated recurring insights on demand, delays, freight cost, and container utilization for regional managers. Partnered with logistics, finance, and IT to standardize metric definitions, consolidate business logic across ETL jobs, and resolve upstream data integrity issues.