Hi, I'm a graduate candidate in the Master of Management Analytics program at the Rotman School of Management, University of Toronto. I have hands-on experience as a Data Analyst at the Royal Bank of Canada, where I optimized automation tools and applied machine learning techniques to improve data accuracy and workflows. With a strong passion for music, I have over 8 years of experience as a music producer, releasing 20 singles and 2 albums that have collectively garnered over 2 million streams. In addition to data analytics and music production, I am proficient in Python and various digital audio workstations like Logic Pro and FL Studio. I enjoy blending creativity and technology to drive impactful results and continue to grow my skills in both analytics and music production.…

Hanwen Long

Hi, I'm a graduate candidate in the Master of Management Analytics program at the Rotman School of Management, University of Toronto. I have hands-on experience as a Data Analyst at the Royal Bank of Canada, where I optimized automation tools and applied machine learning techniques to improve data accuracy and workflows. With a strong passion for music, I have over 8 years of experience as a music producer, releasing 20 singles and 2 albums that have collectively garnered over 2 million streams. In addition to data analytics and music production, I am proficient in Python and various digital audio workstations like Logic Pro and FL Studio. I enjoy blending creativity and technology to drive impactful results and continue to grow my skills in both analytics and music production.…

Available to hire

Hi, I’m a graduate candidate in the Master of Management Analytics program at the Rotman School of Management, University of Toronto. I have hands-on experience as a Data Analyst at the Royal Bank of Canada, where I optimized automation tools and applied machine learning techniques to improve data accuracy and workflows. With a strong passion for music, I have over 8 years of experience as a music producer, releasing 20 singles and 2 albums that have collectively garnered over 2 million streams.

In addition to data analytics and music production, I am proficient in Python and various digital audio workstations like Logic Pro and FL Studio. I enjoy blending creativity and technology to drive impactful results and continue to grow my skills in both analytics and music production.

See more

Experience Level

Expert
Expert
Expert
Expert
Intermediate

Work Experience

Data Analyst – Group Risk Management at Royal Bank of Canada
May 31, 2024 - July 22, 2025
Optimized a Python-based automation tool (1,000+ lines of code) to classify and restructure 5,000+ roll-up numbers, ensuring 100% mutual exclusivity and eliminating path conflicts in a complex 18-level hierarchy. Integrated NLP techniques and matching (Fuzzymatch, word frequency analysis) to increase data classification accuracy to 99.4%, improving system reliability for risk and compliance reporting. Implemented an automated validation framework, reducing manual classification effort by 90% and allowing for real-time conflict detection in under 2 minutes per run. Generated impact assessment reports comparing old vs. new hierarchy models via AB testing and hypothesis testing, ensuring seamless adoption with minimal disruptions across 5+ business units. Interviewed various senior managers regarding business functions, prepared due diligence questions, documented meeting minutes, and prepared presentations.
Business Analyst – Bolton Warehouse at Canadian Tire Corporation
August 31, 2023 - July 22, 2025
Led a data-driven process optimization project by collecting 6,000+ real-time warehouse performance data points, identifying inefficiencies and improving operational workflows. Established a warehouse routing optimization model, reducing transport time by 3.2% through improved storage allocation and streamlined order fulfillment. Designed and implemented 5 Standard Operating Procedures (SOPs) to standardize processes, ensuring operational consistency and increasing warehouse productivity. Built Business Intelligence Dashboards to visualize KPI reports such as order fulfillment speed, transport efficiency, and storage utilization, enabling real-time data-driven decision-making for logistics managers. Partnered with warehouse operations and IT teams to integrate analytics solutions, improving warehouse data collection methods and reducing reporting inconsistencies by 20%.

Education

Bachelor of Arts at York University
May 1, 2020 - October 31, 2024

Qualifications

Certification in Data Analytics & Visualization
August 1, 2022 - February 28, 2023

Industry Experience

Financial Services, Transportation & Logistics, Retail, Media & Entertainment, Professional Services