Adult-Clientele Cohort Tracking (STO)
→
Summary
Built monthly tracking of unique adult riders measuring retention by fare type, migration between fare types, and new-customer acquisition.
About
Bilingual Business Intelligence (BI) analyst with over 7 years of experience across federal government, public transit, and financial services, specializing in designing comprehensive BI solutions. Expertise includes OLAP cubes, reports, decision-support tools, and advanced analysis using Power BI, Tableau, and SAS, backed by SQL, ETL/ELT, and Google BigQuery. Proven ability to build cloud data pipelines and deliver strategic insights, complemented by an MBA in Business Analytics.
Work
Société de transport de l'Outaouais (STO)
|Business Analyst — Marketing & Business Performance
Gatineau, QC, Canada
→
Summary
Leads end-to-end analytics for customer experience and fare revenue, delivering strategic recommendations to management and the Board of Directors for a public transit organization.
Highlights
Led end-to-end analytics for customer experience and fare revenue, delivering strategic recommendations to management and the Board of Directors.
Optimized telephony dashboard and defined business rules for two new dashboards (comments, customer satisfaction) via an OLAP cube, co-designing the customer-journey dashboard and its priority KPIs.
Directed the migration of reporting from Tableau to Power BI, integrating Google Analytics 4 via BigQuery for enhanced data capabilities.
Designed and managed InputKit voice-of-customer surveys (continuous and ad-hoc), analyzing revenue/cost of two partnerships (CCN, REDBLACKS) exceeding $50K+ in value.
Canada Revenue Agency
|Business Analyst
Ottawa, ON, Canada
→
Summary
Built interactive Power BI dashboards tracking KPIs for multiple teams and analyzed operational data to identify trends and produce forecasts, supporting decision-making in an Agile/Scrum environment.
Highlights
Developed 3-5 interactive Power BI dashboards tracking KPIs for 3 teams, reducing manual reporting effort by approximately 5 hours/week.
Analyzed operational data to identify key trends and generate accurate forecasts, directly supporting strategic decision-making processes.
Provided expert support to Excel, Power BI, and SAS users, while documenting reporting best practices within an Agile/Scrum framework.
LifeWorks
|Analyst
Montréal, QC, Canada
→
Summary
Designed and automated ETL pipelines using Python and SQL, strengthening data governance and reducing manual data-preparation time for actuarial reporting.
Highlights
Designed and automated robust ETL pipelines using Python and SQL, significantly strengthening data governance and reducing manual data-prep time.
Profiled, ingested, and cleaned large multi-source datasets, establishing a foundational stage for data pipelines.
Prepared and validated annual plan data and trend/experience analyses, feeding critical actuarial reports.
Canada Revenue Agency
|Tax Services Analyst
Montréal, QC, Canada
→
Summary
Resolved complex tax inquiries and computed taxes, benefits, and exemptions by applying fiscal and actuarial formulas, ensuring accuracy and regulatory compliance.
Highlights
Resolved complex tax inquiries and accurately computed taxes, benefits, and exemptions by applying fiscal and actuarial formulas.
Verified and validated tax data to ensure high accuracy and strict regulatory compliance.
Wedacy
|Junior Business Analyst
Ottawa, ON, Canada
→
Summary
Gathered analytics requirements and designed statistical models for financial analyses, building Power BI and Tableau visualizations and validating solutions through UAT.
Highlights
Gathered comprehensive analytics requirements and designed statistical models and impact studies for critical financial analyses.
Developed Power BI and Tableau visualizations, conducting user acceptance testing (UAT) to validate and ensure the quality of delivered solutions.
Education
Université Laval
Quebec City, QC, Canada
→
M.B.A.
Business Analytics
Université du Québec en Outaouais (UQO)
Gatineau, QC, Canada
→
B.Sc. Administrative Sciences
Finance
Languages
English
French
Certificates
Anaconda Python for Data Science - Professional Certificate
Issued By
Anaconda
CFI Corporate Finance Foundations - Professional Certificate
Issued By
CFI
Skills
BI & Modeling
OLAP cube / multidimensional modeling, Relational data modeling, Decision-support tools, Data profiling.
Analysis Tools
Power BI, Tableau, SAS, Excel (advanced).
Data & ETL
SQL, Python, ETL / ELT, Google BigQuery (GA4).
Methods & Domain
Agile / Scrum, Federal tax data, Actuarial / pension data, Transit KPIs.
Projects
InputKit Survey Redesign (STO)
→
Summary
Rebuilt the survey program into a continuous 'funnel' prioritizing the 3 mandatory KPIs (CSAT, NPS, CES).
Return-to-Office Revenue Impact (STO)
→
Summary
Cross-referenced Finance and OLAP-cube data to measure the federal 3-day return-to-office effect.