I built Apna Bhagalpur, a healthcare appointment platform with patient, clinic, and super-admin workflows. I reduced SQL queries on super-admin analytics endpoints from 172 to 3 using SQLAlchemy aggregation and composite indexes.
For Apna Bhagalpur, I also implemented clinic-scoped WebSocket updates for appointment status and queue synchronization. I secured API endpoints with JWT authentication and role-based authorization, and added rate limiting, audit logging, backups, and monitoring.
I built and deployed Bhagalpur Stays, a hotel-booking MVP with role-based dashboards and booking workflows. I also built Yatra Planner, a travel-planning website with interactive budget calculators, live weather data, and personalized PDF exports.
