▪ Led the development of predictive models to forecast budget and detect anomalies in KPIs, identifying business lines with higher than average overruns and no. of delayed projects, enhancing data governance and audit compliance bank-wide ▪ Utilized time series analysis to predict budget and resource forecasts, enabling more accurate financial planning and allocation ▪ Developed a robust Python-based framework to aggregate and analyze portfolio performance, improving the accuracy and efficiency of financial reporting by 30% ▪ Conducted feature engineering on critical project attributes (e.g., portfolio actuals, authorized value, and forecast), leading to improved predictive analytics and strategic insights. ▪ Implemented dynamic scoring systems and data quality tests that resulted in a 20% reduction in discrepancies across high-value portfolios ▪ Automated data extraction from multiple sources (e.g., Clarity PPM) using Python to streamline the tracking and reporting of key portfolio attributes, leading to faster and more reliable executive insights. ▪ Designed and maintained data engineering pipelines that integrate Python and Power BI, enabling seamless metric calculation of projects’ attributes ie. portfolio actuals, authorized value, forecast, line of business, and etc. and real-time portfolio performance monitoring

Scotiabank | Nov 2021 - Nov 2023

Senior Data Analyst

▪ Built and oversee the entire ETL and reporting pipeline for the team. Creates how-to documentation on monitoring the data quality, data exploration steps and etc for training the team members. ▪ Created repeatable process to parse data from Sailpoint Identity and Global Employee Directory to create interactive real-time dashboard for the entire bank for access reviews (using SQL, PowerBI). This saves over 35 hours of manual data cleaning and data manipulation. It also increases compliance rate by 40% as internal audit is able to review the data seamlessly. ▪ Developed an end-to-end automated reporting process of Active Directory (AD) access across the bank using python (data cleaning and transformation) and Power BI (data visualization). This involves building connections between the employee directory and various consoles to track employee’s access on a daily basis. ▪ Created multiple workflows using a combination of SQL, Python Pandas and VBA to transform data and automate all stages of reporting and email generation. This automation allows the team to run multiple processes a day, saving over 50 hours of manual work. ▪ Developed a self-serve PowerBI dashboard displaying the live status of applications across the bank, this enables management to identify which application needs to be retired/onboarded based on their confidentiality, integrity and availability (CIA) rating ▪ Created an automated user form (VBA) for internal application teams to onboard their applications. The form automatically fills out the application’s attributes and score, validates user’s ID and decreases user data entry errors by 95%

RBC | Nov 2018 - Nov 2021

Senior Data Analyst

▪ Built repeatable process to import data from Privileged Access Management database to Tableau to create interactive real-time metrics dashboard. This saves over 30 hours of manual data cleaning, manipulation and importing each week. ▪ Automated large volume (over 1000 emails/day) of data collection on Outlook by implementing a hyperlink in the emails to gather responses from users. Created a script to read keywords to process all emails collected. This saves over 30 hours per week for the team. ▪ Created a python script to automate excel reports processing with over 2M rows, saving 3 man hours a day and eliminated human errors ▪ Developed multiple automated forms to better collect user’s data and improve user’s experience across RBC ▪ Used SQL queries and VBA script to loop through privileged account’s transactions to search and flag accounts that do not have their passwords reset in 24 hours. This increased the scope of control in the privileged accounts domain ▪ Designed and built end-to-end ETL workflow using data warehouse and Tableau for the team that involves cleaning and organizing data from multiple sources

My Education

Take a look at my formal education

Bachelors of Arts in Economics and BusinessTrent University | 2013

Create Your Data Portfolio for Free