EXPLAIN-first schema and query work that kept enterprise dashboards and workflows fast as data grew.
Enterprise customers put real orgs — hundreds of thousands of rows — through reviews, surveys, and dashboards. A query that is fine at a thousand rows is slow at a million.
Slow reports and page loads showed up as p95 spikes. The fix wasn't more servers — it was reading the query plan and aligning the schema with the access patterns.
Read EXPLAIN before touching code — the database is the source of truth for what is slow.
Designed composite indexes and schema changes around the actual query shapes.
Rewrote ActiveRecord scopes and joins to match the schema instead of fighting it.
Measured before and after against production data, not the happy path.
The query plan is the truth. Optimising SQL starts with reading what the database actually does — not guessing in the code.
p95response time
flattened on million-row tables by index-backed, EXPLAIN-first query plans
RAG-grounded LLM workflows that answer enterprise questions from real company knowledge — not a demo corpus.
100% grounded — every answer traced to a retrieved source — never generated from memory
The REST APIs and workflows behind Peoplebox's core HR modules — one service layer powering six product areas.
6 product areas — Goals, Reviews, Surveys, HRIS, IDPs, and reporting on one service layer
The reliability layer that keeps employee and identity data in sync across customers' HRIS and identity systems.
24/7 in sync — employee and identity data flowing reliably across customer systems