Data Analyst Portfolio
Turning raw data into decisions
Data analyst with an MBA and a background in upstream energy, now focused on commercial, procurement, financial operations, and operational analytics. I build dashboards, financial models, and clear written reports that turn raw data into decisions, helping businesses understand what is driving performance and where the next opportunity lies.
View my workBackground
I'm a data analyst with an MBA and twelve years of upstream energy experience at TotalEnergies, where I built a strong foundation in operational data governance, project coordination, and cross-functional stakeholder coordination.
Through the 10Alytics Data Analytics Program and a growing self-directed portfolio, I've built hands-on expertise in Excel, Power BI, Tableau, and SQL, applying those skills to real datasets, including public regulatory and open government data from the AER, EIA, and the Government of Canada, to model the kind of settlement, forecasting, and performance problems energy and commercial analysts solve every day.
My work is grounded in one principle: clear, honest insight that leads to better decisions, not just polished charts.
Based in Calgary, Alberta. Open to analyst roles across Canada and internationally.
Toolkit
Work
Microsoft Excel
Fictional Data, Practice Project2026
Accounts payable register of 28 fictional supplier invoices with expense coding, billable and non-billable tagging, tax recalculation, and approval and payment tracking. Six control checks (duplicates, probable duplicates, tax variance, missing documents, paid without approval, date errors) caught all 8 seeded errors. An aging report ranks follow-up on $60.6K overdue (70.6% of $85.9K outstanding), and a 12-claim expense review flags 5 for hold or rejection.
Microsoft Excel
Fictional Data, Practice Project2026
Validates 328 time-entry rows and 315 billing lines for 30 fictional employees over 10 working days using data validation, SUMIFS, COUNTIFS, and INDEX/MATCH. Flags missing entries, duplicates, off-contract rates, and billing mismatches; logs 33 discrepancies with expected versus found values, dollar impact, action, and owner. A 300 employee-day coverage grid separates 7 missing entries from 3 approved leave days.
Microsoft Excel
Fictional Data, Learning Project2026
Tracker for 5 fictional time-and-materials and fixed-price contracts showing billable and non-billable hours, billing rates, and amounts invoiced. Calculates un-invoiced work ($41.5K), amounts billed in excess ($8.4K), and outstanding receivables ($101.4K), with three self-checks reconciling every figure back to the source sheets.
Power BI
Real Open Government Data2026
Procurement-style analysis of 23,850 federal contracts over $10,000 awarded to Alberta-based vendors since April 2022, built on Government of Canada open data. Covers contract value by vendor and commodity, vendor concentration (top 10 suppliers hold 32.2%, overall HHI of 146, with several large categories above 2,500), and the $913M of contract value ending within 12 months, 72% of it in March 2027.
Microsoft Excel
Simulated Data, Fictional Suppliers2026
A simulated sourcing evaluation built in Excel with live formulas: RFP criteria and weights, a standard pricing template, a 5-year total cost of ownership model (NPV at 7%), weighted scoring, and sensitivity testing across three fictional suppliers. The lowest unit-price bid carries the highest 5-year cost, $427K (15.2%) above the best bid, and the same supplier wins under all four weighting scenarios. Every supplier and figure is invented and labeled as such.
Microsoft Excel
Real WTI Price + Synthetic Data2026
A fully formula-driven Excel model simulating a monthly producer settlement at a shared oil and gas facility — equalizing metered volumes for meter calibration variance, applying facility shrinkage, and allocating operating cost pro-rata to calculate a net settlement per producer. Sales price is real, publicly sourced EIA WTI Cushing spot data; producer names, volumes, and meter factors are hypothetical and clearly labeled as such.
Excel
Real AER Data + Synthetic Facility Sim.2026
An analysis of Alberta crude oil production composition, combining real Alberta Energy Regulator (AER) production and crude-type mix data with a transparently labeled synthetic facility-level blend simulation. Tracks blend variance against target ratios, automatically flags off-spec months, and separates real provincial data from illustrative facility data on distinct, color-coded tabs.
Tableau
Course Dataset, Fictional Retailer2026
Two-page interactive Tableau dashboard (Overview and Deep-Dive) for a fictional US superstore chain, built on a 4-table relational model of 4,413 order lines from 2022 to 2025. Uses calculated fields, LOD expressions, parameters, and filter actions to answer 12 business questions. Found that line discounts above 30% lose $402.9K, equal to 84% of total profit, and that Copiers earn 85% of profit while Tables and Machines lose $125.2K.
PostgreSQL / Excel
2026
SQL capstone for a consumer electronics retailer, analyzing 5 years of sales, inventory, and macroeconomic data across 4 themes and 9 queries. Built inflation bands from actual data percentiles (not arbitrary cuts), measured true promotional ROI against a naive lift assumption, and quantified deadstock capital by category, month, and year to identify where cash was frozen in unsold warehouse stock.
Microsoft Excel
October – December 2025
Evaluated whether a Board-mandated turnaround strategy reversed three consecutive quarters of 20% revenue decline. Covered sales trends, regional performance, product profitability, and customer segmentation across 2,000 orders and $114.7M in revenue.
Microsoft Excel
July – September 2025
End-to-end sales analysis for a U.S. e-commerce retailer covering monthly MoM trends, category performance, state-level revenue, customer age segmentation, time-of-day purchasing behaviour, and payment method analysis across 2,000 orders.
Power BI
May 2025
Built an interactive Power BI dashboard for a high-end fashion boutique operating across three store locations. Identified top-selling categories and products, visualised sales trends over time, and broke down revenue by gender and payment type for 31 customers across 771 transactions.
Python
2026
End-to-end Python analysis of 15+ years of real Canada Energy Regulator pipeline data. Cleaned and aggregated multi-product regulatory filings, calculated rolling averages and utilization variance, and identified and corrected a data-aggregation bug that was inflating utilization figures before finalizing results.
Power BI
2026
Interactive three-visual Power BI dashboard built on the same cleaned pipeline dataset — a trend line comparing throughput to capacity, a utilization KPI card, and a year-over-year comparison. Cross-validated calculated metrics against an independent Python analysis to confirm consistency across tools.
Python
2026
Short-horizon throughput forecast using a transparent moving-average model, chosen deliberately over a more complex method for full explainability. Documents method, assumptions, and known limitations explicitly — including where the model would fail to anticipate real historical disruption patterns.
Power BI
January – December 2022
End-to-end sales analysis for a beverage brand across four national retail partners, evaluating FY2022 performance against target, seasonal trends, retailer and regional concentration, and product portfolio mix across 288 transactions and $1.21M in revenue.
Power BI
January 2022 – September 2023
Sales, profitability, and inventory analysis for a 50-store toy retail chain in Mexico. Identified category profit drivers by store location, seasonal sales patterns, stockout-driven revenue loss, and inventory carrying cost across 829,262 transactions.
Power BI
January 2020 – June 2022
Multi-page Power BI dashboard and business report analyzing global bike and accessories sales across 7 countries. Covered category profitability, revenue trends, geographic performance, returns, and customer segmentation across 56,046 order lines.
Writing
Independent analysis on energy M&A, infrastructure, and market pricing — written to build and demonstrate analytical judgment, not just describe events.
Market Note
July 2026
A look at Cygnet Energy's C$1.4B acquisition of Kiwetinohk Energy, closed December 2025. Argues the modest 10.4% premium reflects a market still pricing Duvernay/Montney names on production and drilling inventory, while underpricing the real value driver in the basin: committed pipeline egress and infrastructure control.
Market Note
July 2026
Argues the market's Montney re-rating thesis, built on LNG Canada demand and a narrowing AECO-Henry Hub basis, is underweighting the roughly 200 drilled-but- uncompleted Montney wells sitting on the sidelines — a reversible capital-allocation decision, not a fixed supply constraint, that could cap the pace of any price recovery.