Skip to content
CASE STUDIES & BLOG

How the decisions got made

Long reads on real systems, with demos you can run inside the article.

IN BRIEF
CGI / OWNER OF REPORT GENERATION

When the AI draft is never final

Report preparation took hours of manual work at a major Canadian bank. I built a pipeline that renders upstream data into a Word template and drafts the content with the OpenAI API, in the background, so auditors keep working. An auditor reviews every report before approval.

Hours down to minutes1,000+ auditors
ONE REPORT THROUGH THE PIPELINE
  1. Job added to the task tabledone
  2. Worker picks up the jobdone
  3. Upstream data rendered into the Word templatedone
  4. OpenAI API drafts the report and summarydone
  5. Auditor reviews before approvalready
CWG / LED DEVELOPMENT

Smart Metrify, 4.2s to 1.6s

I led the platform estates use to sell and manage electricity units, on one consistent interface over several meter vendors’ APIs. As it grew, pages got slow, so I profiled it and worked in order of measured cost: route-level code splitting, TanStack Query, and optimized images and fonts.

5,000+ users22 active estatesLighthouse low 60s to 90+
PAGE LOAD, BEFORE AND AFTER, AT REAL SPEED
Before4.2s
After1.6s