Experience

  • Business Analyst

    at Scotiabank

    January 2019 - March 2019

    Ontario

    • Created an automated (VBA based) reporting tool to analyze zero-based budget data which provided a centralized view of each business units’ budgeting information and highlighted strategic savings opportunities • Developed an automated (VBA based) template used to extract, cleanse and transform accounts payable data into spend analytics reports. The automation ultimately led to the time savings approximating to 16 hours per monthly report • Improved the reporting performance of Scotiabank’s enterprise-wide contract management platform (Ivalua) by optimizing SQL queries and applying performance tuning principles to reduce the run time of reports by 50% • Led an initiative to streamline the analysis of purchasing and invoicing data from Scotiabank’s enterprise-wide procurement platform (Coupa) that saved 6 hours per week

  • Manulife Financial

    at Data Analyst

    May 2018 - December 2018

    Ontario

    • Automated the process of creating effort analysis report using VBA to improve data integrity that increased accuracy in forecasting for the overall program • Identified process and system improvement opportunities by monitoring existing metrics, analyzed data and partnered with internal teams • Researched ideas and designed a high-fidelity prototype and presented to the senior executives as part of the Co-op group-retirement innovation challenge

  • Project Coordinator

    at Allianz Global Assistance

    September 2017 - December 2017

    Ontario

    • Analyzed the expenditures associated with projects in the Canadian portfolio keeping the estimates in line with the annual budget using Pivot Tables • Performed functional, regression and integration testing and collaborated with developers to resolve bugs which resulted in the launch of new Allianz website ahead of schedule • Resolved a resource crunch issue by taking initiative to create business requirements for repricing an insurance product

  • Consultant

    at CGI

    August 2016 - April 2017

    Ontario

    • Created an interactive dashboard report showing key performance indicators (KPI) for the senior management to make important business decisions • Improved “Actual vs Forecast” resource allocation report to efficiently track spending against the budget • Increased efficiency by automating weekly reports, eliminating duplicate reports using VBA, resulting in time savings of 70%

Education

  • Statistics and Economics

    at University of Waterloo

    2014 - 2019 (5 years) Ontario

Languages

  • English Native

Hives