Resume

Work Experience

Senior Application Specialist 11/2021 - Present

The Hospital for Sick Children

• Spearheading data integrity and accuracy across the Finance system, ensuring seamless integration with other systems and submodules, and maintaining reliable data flow for financial reporting.
• Leveraging PeopleSoft and SQL to develop queries for data extraction, transformation, and financial analyses, as well as supporting investigations and discrepancy resolution; created automated processes that replaced manual tasks, including streamlining AP accrual processes.
• Acting as the system-related subject matter expert and a key point of contact for various stakeholders, including vendors, banks, and auditors; providing general support of PeopleSoft, QlikView, Adaptive.
• Leading month-end financial consolidation and reporting activities, coordinating with 3 Finance groups to ensure timely delivery of financial statements and operational metrics.
• Utilizing data-driven approaches to budgeting, forecasting, and reporting for Kids Health Alliance, an external SickKids entity, ensuring strategic financial planning.
• Developing and documenting inter-departmental processes for finance improvements, including data reconciliation procedures and automated employee chargeback processing between Payroll and AR.

Operations Officer 05/2021 - 10/2021

Royal Bank of Canada

• Processed the collections, payouts, and maintenance of all financial products within the department, while ensuring effective and timely communications with clients.

Audit Intern 01/2018 - 02/2018

Ernst & Young

• Led the audit process for six accounts during the annual audit, ensuring accuracy and compliance by reviewing large datasets, identifying discrepancies, and liaising with clients to resolve issues.
• Developed and implemented a VBA tool for consolidating data from hundreds of Excel files, later transitioning the process to a Python-based application, reducing manual work from hours to a streamlined 10-minute automated process.

Education

Master of Management Analytics 01/2024 - Present

Queen's University

Master of Management 09/2019 - 12/2020

University of Windsor

Bachelor of Economics 09/2015 - 07/2019

Shanghai University

Skills

• Microsoft Excel
• VBA
• Machine Learning
• Deep Learning
• Python
• R
• JavaScript
• Git
• SQL
• MongoDB
• Power BI
• QlikView

Publications

Mendelian randomization analysis identified genes potentially pleiotropically associated with periodontitis

Saudi Journal of Biological Sciences. April 16, 2021.

Mendelian randomization analysis identified genes pleiotropically associated with the risk and prognosis of COVID-19

Journal of Infection. December 7, 2020.