Client work
Multi-tenant Geo-routing Platform
A multi-tenant platform that routes incoming leads to the nearest location, syncs with partner systems, and lets people search on a map. I'm its main backend engineer. I've written about 88% of its commits, 80+ database migrations and 95+ integration test files.
Results
- 25ms
- to load the main list, down from 3.3 s
- <50ms
- page loads with a slow partner, down from 6 s
- 0.27s
- for a deep page of the map list, down from 10.8 s
What I built
- Rewrote the main list query so it only builds the rows you actually see. It went from 3.3 s to 25 ms on a full-size copy of the data.
- Built the integrations with partner systems: webhooks, data mapping and two-way sync. When a slow partner made pages wait 6 s, I moved those calls into the background, so pages load in under 50 ms.
- Changed how the map list pages through results, so deep pages load in 0.27 s instead of 10.8 s.
- Added a fast search that forgives typos, across 55K locations.
- Built map search and admin dashboards in React and Next.js.