Hanzhou Shao Email & Phone Number

Mississauga, Ontario, Canada

Toronto, Ontario, Canada

• Designed an automated ETL pipeline that extracts and standardizes data from 5+ job listing websites; streamlined the data transformation and loading procedures, resulting in a 30% increase in pipeline efficiency• Improved system reliability by establishing a monitoring module to retry and notify users upon ETL process errors• Developed a UI using Streamlit to enhance user experience; utilized OpenAI API to reformat job description and user’s resume; deployed a notification module that delivers the most relevant jobs from a pool of 1000+ job postings based on keyword matching of parsed tags (e.g., skills, education, experience, industry)

Toronto, Ontario, Canada

• Established a local database utilizing PostgreSQL and pgAdmin to efficiently store 100K+ hotel booking and food order transactions, and extracted 20+ performance metrics (e.g., revenue, length of stay) from the transactions• Built Power BI dashboards featuring numeric and trend visualizations, and delivered findings along with critical KPI identification, data collection strategies, and marketing recommendations to the hotel management stakeholders

Concord

• Conducted environmental and vibration testing on automobile parts by following ISO/IEC 17025 requirements. • Collaborated with cross-functional teams to perform standard-compliant mechanical tests for 30+ clients; managed concurrent projects and ensured timely delivery of products following project requirements and budget constraints.• Utilized Data Acquisition System Laboratory (DASYLab) to design and build a pipe burst test machine, establishing the company as a pioneer in North America for conducting burst tests on water main and sewer pipe samples. • Validated the precision of an existing pipe burst pressure prediction formula by developing regularized regression models with hyperparameter tuning; confirmed the formula’s reliability through result comparisons. • Reviewed RFQs (request for quote) sent by clients and prepared quotes accordingly.• Developed test apparatus to implement new testing as per ISO/IEC standards. • Designed parts and assemblies for vibration fixtures and prepared drawings for manufacturing using SolidWorks. • Designed and built automatic PLC controlled pneumatic durability testing fixtures.

Toronto

• Developed and conducted testing for product improvement and composed 25+ design test reports. • Performed system validation & verification and prepared 10+ domestic and international regulation submission documents. • Developed, updated, and managed CAD 3D models and 2D drawings in SolidWorks PDM Vault. • Designed and validated phantoms and jigs for R&D and production purposes. • Trained new employees regarding device operation and test procedures.

Microcellular Plastics Manufacturing Laboratory (Mpml)

Master Of Engineering - Meng, Data Science, Gpa 3.97/4.0

Bachelor Of Applied Science - Basc, Mechanical Engineering, Gpa 3.80/4.0

Robotics and Mechatronics Minor