Overview

At Lava Labs, I redesigned the route search system for a multitenant workforce management platform, achieving a 15x performance improvement.

Problem

The existing route search took ~30 seconds per query, making the workforce management tool unusable for dispatchers who needed real-time route assignments.

Solution

Profiled and identified bottlenecks in the query layer, redesigned the data access patterns, optimized SQL queries, and introduced caching strategies — reducing response time from 30s to 2s.

Tech Stack

• Java / Spring Boot — Backend
• MySQL — Database with query optimization
• Microservices — Service architecture
• REST APIs — Web and mobile clients

My Role

• Led performance profiling and bottleneck analysis
• Redesigned database queries and indexing strategy
• Implemented caching layer for frequently accessed routes
• Designed REST APIs for web and mobile clients

Impact

15x performance improvement (30s → 2s), significantly improving UX for dispatchers and enabling real-time route management.