Hao Shi
New York
Summary
Data science and analytics consultant specializing in delivering data-driven solutions for location-based commercial, transportation, and urban systems projects across multiple clients at a global engineering consulting company.
Seeking to contribute consulting and analytical experience in Japan.
Overview
3
3
years of professional experience
Work History
Data Scientist
AECOM
New York
01.2023 - Current
- Worked closely with clients to approach non-technical business questions by regularly presenting progress and findings through client meetings and delivering clear and well-structured outputs (reports, visuals, summaries) to support informed decision-making.
- Analyzed and processed 500M+ bikeshare records using Snowflake, building automated analytics pipelines to evaluate system performance, equity, and operational efficiency; conducted trend and spatial analyses to deliver insights that informed program evaluation and planning.
- Built a Random Forest model predicting Annual Average Daily Traffic using real-time sensor records, NYC street attributes, and landuse data, achieving an MSE under 500 with MAPE < 10%, which prioritized construction and maintenance on high-traffic roads, supporting decisions that led to reducing costs by $20M+.
- Managed a citywide data platform integrating various urban datasets to support project managers, and developed scheduled ETL pipelines using SQL and Python to ensure data consistency and reliability while designing new analytical modules to enhance decision-making capabilities.
- Developed data pipelines using Geotab APIs to extract and integrate citywide speed data, matched speed data to the road network using advanced GIS algorithms, and analyzed the correlation between accidents and vehicle speed, leading to speed camera installations that reduced speed-related accidents by 30% in Q1 2023.
Education
Master of Science - Urban Data Science
New York University
New York, United States09-2022
Bachelor of Science - Geography Information Science
East China Normal University
Shanghai, China07-2021
Skills
Programming: Python (Pandas, Numpy, Matplotlib, TensorFlow, PyTorch), SQL (MySQL, PostgreSQL), Matlab
Tools: Tableau, Power BI, dbt, Snowflake, GCP BigQuery, Azure Data Lake, GitHub, JIRA, ESRI, ArcGIS, Microsoft Excel
Methodologies: ETL, A/B Testing, Database Management, Machine Learning & Predictive Modeling (Regression, Random Forest, Neural Network, XGBoost, Association Rule), Statistics
Language: Chinese (Native), English (Full professional), Japanese (Conversation level)
Timeline
Data Scientist
AECOM
01.2023 - Current
Master of Science - Urban Data Science
New York University
Bachelor of Science - Geography Information Science
East China Normal University