Profile
Business Intelligence Analyst who turns raw operational and financial data into decisions that move the business — building enterprise data models, Power BI reporting, and automation across energy operations, from front-line teams up to executive level.
Experience
Business Intelligence AnalystDec 2024 – Present
Secure · Calgary, Alberta
- Built the enterprise operations data model in Power BI (sourced from Databricks) for the entire operations team, adopted from front-line ops up to VP, GM, and Director level to support daily decision-making across ~$1B in annual revenue.
- Designed a Volume Analysis module surfacing insights the business previously lacked — wait time, average flow rate, and revenue per GL account — exposing throughput bottlenecks and margin drivers in real time.
- Delivered company-wide sales inflation and cost-of-service-per-cube (per m³) analysis, benchmarking Canadian cost indexes (chemical and natural gas — up nearly 20% year-over-year) against pricing to inform a price increase that protected margins from erosion.
- Developed a comprehensive cost-of-service data model with Power BI reporting, giving sales and operations first-time visibility into cost and process-waste analysis.
- Engineered energy-infrastructure financial reporting leveraging Dynamics 365 and Power BI, collaborating directly with customers to gather requirements and deliver tailored solutions.
- Implemented free-cash-flow and expense-tracking reports while revamping core KPIs, designing the underlying data models operations use to identify value.
- Built a Python web-scraping automation extracting electricity-rate data for the hedging team, deployed into a Prefect pipeline on AWS with credentials in Secrets Manager, automating rate ingestion for ESG and hedging analysis.
Business Intelligence DeveloperMay 2022 – Apr 2024
Precision Drilling · Calgary, Alberta & Houston, Texas
- Developed a high-impact Drill Pipe Excess Wear web application using Power BI with a Snowflake backend, contributing to $7.3 million in revenue and demonstrating scalable, analytical data solutions.
- Designed and implemented a linear regression model in DAX to forecast Drill Pipe wear, reducing maintenance-related downtime by 15%.
- Engineered a Fleet-Wide Specification Dashboard for 205 drilling rigs using Power BI and Snowflake, supporting sales and marketing and driving company-wide rig sales.
- Developed a Fleet-Wide Evergreen Emission Reporting dashboard tracking emissions saved by Evergreen Batteries, using Snowflake for complex aggregation of high-frequency sensor data.
- Developed a Fleet-Wide Compliance Dashboard comparing engineering recommendations with actual rig data, ensuring compliance and optimizing performance in real time.
- Implemented advanced ETL processes in Snowflake DB (SQL) to integrate and transform data for BI applications, ensuring accuracy and reliability.
- Developed multiple APIs in Python integrated within PowerApps, published through Azure Functions and tested with Postman; led an automated approval workflow in SharePoint using Power Automate.
Systems Engineer / BI DeveloperJan 2020 – Jan 2021
TC Energy (formerly TransCanada Pipelines) · Calgary, Alberta
- Gathered requirements and developed a Power BI dashboard with an AWS Redshift backend showing live incident, demand, and time-allocation metrics for upper-management visibility.
- Resolved over 300 business-unit issues related to SAP projects and ServiceNow, improving operational efficiency.
- Identified and fixed a company-wide SAP PPM issue, saving an estimated $200,000.
- Provided live application support (Power BI, Java, VBA, SAP Project Systems); designed SQL tables, views, triggers, and advanced queries.
Data AnalystMay 2019 – Sep 2019
Petrotranz · Calgary, Alberta
- Developed a mobile application using PowerApps to track customer feature requests and a Power BI dashboard for internal metrics, bug fixes, and development status.
- Defined business requirements and created wireframes aligned with HCI principles and UX best practices, engaging stakeholders to iteratively refine requirements.
Skills
BI & Data
Power BI (DAX + Power Query)DatabricksSnowflake
Dynamics 365PrefectETL
Data ModelingMachine LearningData Visualization
Languages
SQLDAXPythonJava
JavaScriptNode.jsBashHTML / CSS
Platforms & Tools
Power AppsPower AutomateAzure Functions
AWS (Redshift · S3 · Secrets Manager)SharePoint / MS Lists
PostmanSAP PPMVisio
Education
BSc Computer Information Systems
Mount Royal University · Calgary, AB
Minor in Business · 2017 – 2021
- Dean's List — 2019 & 2021
- Jason Lang Scholarship — 2021
- Graduation GPA: 3.5 / 4
Ways of Working
Agile / ScrumWaterfallProject Management
Requirements GatheringStakeholder Comms
Problem-SolvingMentorship