QI ZHAO
Toronto,Canada
Summary
Results-driven Senior Data Analyst at FedEx Express Hong Kong, skilled in Python and AWS, with a proven track record of enhancing operational efficiency through advanced data mining and predictive modeling. Adept at delivering actionable insights and fostering collaboration, leading to improved capacity planning and profit margins.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
FEDEX EXPRESS HONG KONG
12.2023 - Current
- Built time series models leveraging forecasting and demand data on Azure Databricks using PySpark, improving capacity planning and profit margins.
- Conducted advanced data mining on large-scale logistics datasets (shipment scan records) to identify trends, anomalies, and opportunities for operational optimization. Resulted in actionable insights that were presented to stakeholders.
- Created reusable Python package with standardized functions for data preprocessing that reduced development time.
- Designed PowerBI dashboards to visualize shipment density, flight utilization, and cost/service trade-offs, facilitating data-driven decision-making.
Cloud Architect (Part Time)
BETA SOFTWARE TECHNOLOGIES
07.2023 - 11.2023
- Managed AWS policies, permissions, and server configurations in IAM to ensure secure and efficient cloud operation.
- Deployed user applications using AWS Elastic Beanstalk, focusing on scalability and performance optimization.
- Created and managed ETL jobs in AWS Glue and automated tasks using AWS Lambda, enhancing data integration and processing efficiency.
Senior Data Engineer
ICON PLC
Philadelphia, USA
08.2018 - 06.2023
- Redesigned and streamlined the ETL process using Python and PySpark, enabling efficient processing of large datasets (100M+ records) from Hadoop and Oracle, improving data pipeline efficiency by 20%.
- Developed a comprehensive dashboard using Python Django and React JS to provide real-time updates on failed and running jobs, and display metadata, enabling faster issue resolution.
- Created error-handling scripts to improve operational efficiency and streamline task execution, leading to significant time savings and improved productivity.
- Designed data flow for client deliverable files (healthcare physician and organization data), resulting in a seamless data storage process in JSON format.
- Created custom Javascript functions in Snowflake to implement complex business rules, enhancing data quality and data integration.
- Collaborated with the data steward team to validate and enrich existing data, ensuring accuracy and completeness.
- Led the design, testing, and deployment of a master data management product (MDM) using Python and MongoDB on AWS to clean, standardize, centralize, and enrich health organization data.
- Created fuzzy matching module with string and phonetic matching algorithm to identify duplicate data, improving data quality and minimizing errors.
- Developed CRM management tools to manage, update, and synchronize clients’ Salesforce environment through API, resulting in seamless collaboration and improved customer satisfaction.
Education
Master of Computer & Information Technology -
UNIVERSITY OF PENNSYLVANIA
12.2022
Master of Science - Statistics
LEHIGH UNIVERSITY
06.2018
Bachelor of Science - Statistics
SUN YAT-SEN UNIVERSITY
06.2016
Skills
- Python
- SQL
- Java
- C
- R
- SAS
- Javascript
- Shell (Linux)
- AWS (S3, Elastic Beanstalk, ECS, Redshift, EC2, DocumentDB, Backup, Glue, Lambda, etc)
- Azure Databricks
- PySpark
- Docker
- Django (REST API)
- Flask
- React
- Tableau
- Autosys
- Github
- Azure DevOps
- PowerBI
- Oracle
- Snowflake
- MongoDB
- MySQL
- Neo4J
- Hive
- Impala
- Teradata
Websites
Certification
AWS Certified Cloud Practitioner, United States, 04/01/22
Timeline
Senior Data Analyst
FEDEX EXPRESS HONG KONG
12.2023 - Current
Cloud Architect (Part Time)
BETA SOFTWARE TECHNOLOGIES
07.2023 - 11.2023
Senior Data Engineer
ICON PLC
08.2018 - 06.2023
Master of Computer & Information Technology -
UNIVERSITY OF PENNSYLVANIA
Master of Science - Statistics
LEHIGH UNIVERSITY
Bachelor of Science - Statistics
SUN YAT-SEN UNIVERSITY
Similar Profiles
Nelson Fu Ming WongNelson Fu Ming Wong
Ground Fleet Supervisor at DHL EXPRESS (HONG KONG) LTDGround Fleet Supervisor at DHL EXPRESS (HONG KONG) LTD
CHRISTINE LICHRISTINE LI
General Manager at Hong Kong ExpressGeneral Manager at Hong Kong Express
Lam Hiu Ching, HeilyanLam Hiu Ching, Heilyan
Senior Sales Executive at S.F. Express (Hong Kong) LimitedSenior Sales Executive at S.F. Express (Hong Kong) Limited
Madelaine SalvadorMadelaine Salvador
ESG Research Analyst at RepRiskESG Research Analyst at RepRisk
Andrea Lira SanmiguelAndrea Lira Sanmiguel
AUDIO MIXER & BOOM OPERATOR at Toronto Film SchoolAUDIO MIXER & BOOM OPERATOR at Toronto Film School