Olivia Hall

• Phone: +1 416 555 0123
• Email: olivia.hall@email.com
• Location: Toronto, Canada
• LinkedIn: olivia-hall-bi

Summary

Four years of experience transforming complex datasets into actionable business insights, driving strategic decision-making and operational efficiencies for Canadian enterprises. Successfully designed and implemented interactive dashboards and reporting solutions using Power BI and Tableau, improving data accessibility for key stakeholders.

Adept at collaborating with cross-functional teams to define KPI metrics, conduct root cause analysis, and develop predictive models that forecast market trends and optimize resource allocation.

Experience

Senior Business Intelligence Analyst, Maple Leaf Analytics -- Toronto, Canada

Mar 2022 – present

• Led the development and deployment of a new sales performance dashboard in Power BI, reducing report generation time by 30% and providing real-time insights into regional sales trends.

• Architected and maintained complex SQL queries and stored procedures for data extraction, transformation, and loading (ETL) from diverse sources, ensuring data integrity and availability for reporting.

• Collaborated with product management to define and track key product usage metrics, contributing to a 15% improvement in feature adoption through data-driven recommendations.

• Mentored junior analysts on best practices for data visualization, dashboard design, and stakeholder communication.

Business Intelligence Analyst, North Star Data Solutions -- Toronto, Canada

June 2020 – Feb 2022

• Developed and maintained over 50 automated reports and dashboards using Tableau, improving data-driven decision-making across marketing and operations departments.

• Performed in-depth data analysis to identify trends, patterns, and anomalies, presenting findings to senior management with clear, concise, and actionable recommendations.

• Optimized existing SQL queries, resulting in a 20% reduction in data processing time for critical financial reports.

• Assisted in gathering business requirements from various departments and translating them into technical specifications for BI solutions.

Education

University of Toronto, MMA in Master of Management Analytics -- Toronto, Canada

Sept 2019 – May 2020

Ryerson University (now Toronto Metropolitan University), B.Comm in Business Technology Management -- Toronto, Canada

Sept 2015 – Apr 2019

Skills

Technical Skills: SQL, Python (Pandas, NumPy), R, Power BI, Tableau, Excel, SSIS, SSRS, Azure Data Factory, Google Analytics, Salesforce CRM

Data Analysis & Modeling: Predictive Analytics, Statistical Analysis, Data Mining, Regression Analysis, A/B Testing, KPI Definition, ETL Processes

Business Intelligence Tools: Dashboard Design, Report Development, Data Visualization, Data Storytelling, Requirements Gathering, Ad-hoc Reporting

Methodologies: Agile, Waterfall, SCRUM, Lean Six Sigma (Green Belt)