work
RBC Data Analyst
May 2023 - Aug 2023Complete
Data Analyst role at Royal Bank of Canada, focusing on automation and forecasting.
My 2023 internship at RBC as a Data Analyst focused on automation, time series forecasting, and knowledge sharing across the team.
Key Achievements
Executive Dashboard Automation
Automated the weekly visualization of key business metrics for executives using Python. This automation:
- Saved 8 hours weekly of manual report generation
- Ensured consistent, error-free reporting
- Freed up team capacity for higher-value analysis work
Call Centre Volume Forecasting
Conducted time series analysis to forecast call centre volume using SARIMA (Seasonal AutoRegressive Integrated Moving Average) models:
- Achieved less than 5% error on yearly forecasting model
- Enabled better staffing decisions and resource allocation
- Provided reliable predictions for capacity planning
Internal Training Program
Designed and taught a Python course with applications to forecasting for a team of twelve colleagues:
- Covered Python fundamentals and data manipulation
- Focused on practical forecasting applications
- Enabled team members to contribute to technical projects
Skills Developed
This role strengthened my abilities in:
- Building automated data pipelines
- Statistical modeling and forecasting
- Technical communication and teaching
- Delivering business value through data analysis
PythonSARIMAPandas