Energy meets
data.
I'm a Mechanical and Aerospace Engineer who spent two years in automotive manufacturing at Tata Motors, then several years as a Registered Energy Advisor auditing homes across Canada. That field experience gave me a rare lens: I understand the measurements before I model them.
Currently building projects at the intersection of energy efficiency and data analytics — Python, SQL, and a lot of curiosity.
Energy Advisor
3 yrs field experience
Data Analyst
Python · SQL
Visualisation
Plotly · Power BI
Notes from the transition
The Problem of Streaks and Sessions
Islands-and-gaps problems keep resurfacing on LeetCode, StrataScratch, and DataLemur under different names — login streaks, active sessions, consecutive runs. This post works through the solutions to these problems in three levels.
The Window Function Trick That Saved Me a CTE
I was reaching for another CTE just to compute a group total, then realised you can nest an aggregate inside a window function and skip it entirely.
Let's talk energy
and data.
I am actively looking for Data Analyst and Energy Data Analyst opportunities. If you are working on energy efficiency, sustainability analytics, or building science data problems — I would love to hear from you.