About

I'm Daniel Gan, a software engineer working on a financial planning and analytics product. I spend most of my time somewhere between the API, the cube engine, and the database, usually chasing the question "why is this slow?" or "why did this number change?"

I started writing these notes because I kept re-learning the same lessons. A performance fix I'd found a year earlier would resurface as a fresh mystery. A design decision would come back for review and nobody, including me, could remember why we made it. Writing it down once, with the numbers, turned out to be cheaper than rediscovering it.

What I work with

Backend
.NET and C#, long-running services, a lot of SQL
Frontend
Angular and TypeScript
Data
OLAP cubes, multidimensional models, and the queries that make them cry
Habit
Measure first, then change one thing, then measure again

How I write

Every note follows the same shape: the problem, what I tried, the numbers, and what I would do differently. I'd rather publish a short, honest post about a dead end than a long one that makes it look like I knew the answer from the start.

If something here helped, or you think I got it wrong, I'd like to hear about it. You can find me on GitHub, or start with the notes.