HandymanHub
Service Marketplace Platform
Developed a full-stack service marketplace connecting customers with workers through skill and location-based discovery.
Reduced DB calls 19 → 1
High code coverage
App Router & Axios Interceptors
Marketplace Infrastructure
HandymanHub requires real-time booking lifecycle management. I designed a RESTful API backend using Spring Boot and MySQL to handle user authentication (JWT), complex worker availability scheduling, and geographical filtering.
Database Optimization
During load testing, booking retrieval endpoints were severely bottlenecked by N+1 query issues caused by lazy loading of worker relationships. By refactoring the JPA queries to use explicitly defined FETCH JOINs, I optimized the retrieval process, reducing database calls from 19 separate queries down to a single optimized query.
Production Readiness
Ensured the application was production-ready by implementing Flyway database migrations, comprehensive Swagger OpenAPI documentation, and containerizing the entire stack using Docker for seamless deployments.