Yiping Zou

Yiping is a data professional with extensive experience in Canadian Niagara Hotels, Royal Victoria Hospitals, and Citizen Information Group Transportation Service Improvement projects. She has strong roots in data management, and ETL, currently working as a data engineer in hotels to build the enterprise data warehouse as part of the revenue management team for two 4-Star hotels - Marriott Fallsview & Spa and Marriott on the Falls. She holds an Honors Certificate in Big Data Analytics from Georgian College and an MS in Computer Science from the University of Illinois, USA

Data Engineer Canadian Niagara Hotels, Niagara, ON January 2023 to June 2023 ● Design and develop ETL based on business requirements to deliver high-quality, reliable data products and continuous business value for a portfolio of 4 major brand hotels, independent hotel, and waterpark ● Work with SQL Server Agent Jobs to update reports every morning and fix any possible errors ● Write R Scripts to pre-processed messy data ● Make documentation for every built data pipeline on Azure DevOps Data Management Analyst June 2021 to February 2022 Royal Victoria Health Center, Barrie, ON ● Work with Report Server: Fold structure, security, subscriptions. ● Write SSRS on DBMS to monitor the data quality between the data warehouse and data marts ● Daily updates of new SQL tables to different servers using SSIS in Visual Studio. ● Effectively design and develop data models, mapping source systems, and use ETL principles in a medium to large enterprise production environment. ● WriteSQL queries to find specific data in the database according to requests ● Communicate with Meditech on data storage information and resolve data quality issues ● Regular maintenance of SharePoint: add content, maintain security, align with Active Director

Master of Science: Computer Science