Coco Huang Email & Phone Number

Bellevue, Washington, United States

Bellevue, Washington, United States

• Context: Relay is a platform where trucking companies, or carriers, book contracts with Amazon to haul loads.
• Data Modeling & Warehousing: Constructed seven families of business review metric slides on carrier onboarding experiences and compliance practices using ETL processes, AWS S3 and QuickSight to inform business decisions.
• Data Processing: Manipulated complex datasets using Python scripts (numpy, pandas) to meet evolving reporting needs across stakeholders on carrier compliance that facilitates operational enhancements to prevent loss in.
• Data Management: Proposed business logic and data structure to transform legacy datasets to user-friendly tables forreporting and deep-diving; coordinated delivery of proposed tables by data engineers and software.

Bellevue, Washington, United States

• Context: Market Fulfillment Centers (MFCs), attached to Walmart stores, fulfill online orders for delivery and in-store pickups.
• Data Visualization: Delivered ad-hoc reports and dashboards using Google BigQuery and PowerBI to monitor inventory turnover and capacity, preventing an estimated annual revenue loss of $56 million due to stockouts.
• Python Automation: Automated assortment auditing processes, eliminating 500+ hours of manual work annually and ensured timely delivery of weekly assortment reviews, expected to avoid $10 million in incorrect shipments.
• Data Warehousing: Consolidated, processed and scaled data from sources including demand prediction, sales store layout and item dimensions, to monitor capacity changes, reducing costs of $4 million in seasonal.
• Machine Learning: Manipulated, bootstrapped data and initiated regression-based machine learning framework to identify major drivers for throughput (no. of items fulfilled in MFC as a percentage of total no. of item.

Sunnyvale

• Simulation, Process Improvements: Proved the business case to reduce 1% labor costs in market fulfillment centers using a Python-based simulation model by improving the routing algorithm that guides in-store pick walks.
• Proposed 15+ systematic changes to be integrated in product roadmap for hybrid MFCs.

Greater Los Angeles Area

Published 150+ individual bylines to cover companies across Los Angeles with a focus on tech. Analyzed earnings reports, investigated business models and conveyed complex concepts to non-technical audience.

Greater Los Angeles Area

• Managed and analyzed large datasets, including spatial data, using SQL and QGIS, collaborated with data engineers and UX designers to publish six multimedia stories of public interests.
• Designed and conducted market research survey as to optimize monetization strategy for the start up.

Master'S Degree, Business Analytics

Capstone | Blue Nile Clickstream Analysis: Feature engineered history and clickstream data and developed a regression-based attribution.

Master Of Science - Ms, Journalism

Activities and Societies: Photography and Visual Editor at Annenberg Media (managed a team of ten to maintain photo library and provide.

Bachelor Of Arts - Ba, Business English, • Gpa: 3.88

Activities and Societies: Founder and President of BJFU Debate Association; Leader of Communication & Media Department of BJFU Student.