Erin Wang

Mississauga,Canada

Summary

Background in statistical analysis and machine learning with expertise in banking products and digital platforms, leveraging analytical skills to optimize operational efficiency. Proficient in data analysis, SQL, and SAP, enhancing decision-making and inventory control. Passionate about utilizing advanced programming languages and visualization tools to drive innovation and streamline processes.

Overview

year of professional experience

Certification

Work History

Client Advisor

RBC Royal Bank

Mississauga, ON

04.2024 - Current

• In-depth knowledge of RBC's personal and business banking products and services, along with proficiency in most digital platforms for both external and internal use, including online/mobile banking, Client360, Service Platform, Sales Platform, etc.

• Leveraged data analysis tools to optimize ATM forecasting and cash loading, enhancing operational efficiency and customer satisfaction.

Merchandising Administrator

Btrust International Trading

Oakville, ON

09.2023 - 04.2024

• Streamlined data entry processes for retail products, enhancing merchandise decision-making through comprehensive Excel analysis like VLOOKUP and pivot tables.

• Executed queries across multiple databases in Microsoft SQL Server across 300+ tables and 100+ attributes, retrieving crucial information from extensive table structures to support business operations.

• Generated and analyzed various reports, including logs, and weekly, monthly, and quarterly reports, contributing to data-driven decision-making.

• Optimized SAP inventory control procedures, ensuring accuracy and contributing to data-driven decision-making through meticulous report generation.

Education

University of Toronto St George Campus - Statistics Specialist, Computer Science Minor

Honors Bachelor of Science

06-2023

Skills

Technical: Data Analysis, Database Management, Data Visualization, Machine Learning & AI
Programming: Python, R, C, SQL (MYSQL & SQL Server), JavaScript

Tools: Microsoft (Excel, Word, Outlook), Power BI, Tableau

COLLABORATIVE PROJECTS

Fitness Tracker Company Consulting Report, University of Toronto

Performed deep dive analysis and provided business strategy recommendations using regression models to explore the financial metrics insights across the fitness tracker markets.
Accessed an API to retrieve a large volume of data, scrapped a table from a website into a usable dataset and used a licensed postal code conversion file for data linkage.

Federal Election Prediction Modelling, University of Toronto

Accurately predicted the most recent federal election with the predictive model developed.
Implemented data pre-processing (duplicates, missing values, outlines) based on large datasets, performed exploratory data analysis with visualizations.

Certification

IBM Data Analysis with Python

IFIC

ERP & SAP

Timeline