Jul 2021 – Present · 4 yrs 11 mos · Mumbai, Maharashtra, India

• Optimized MySQL query performance, reducing API response time from 15s to under 2s on queries running across 5M+ transaction records by adding indexing, restructuring joins, and using summary tables.
• Developed a secure payment processing system using Node.js, Express, MySQL, and JWT, handling ₹20+ lakhs per month with penny-drop verification, idempotency, retry logic, and trigger-based audit logs.
• Implemented a robust payout retry mechanism where each attempt generates a new request_id while maintaining the same transaction_id and idempotency_key, ensuring zero duplicate payments and complete attempt history.
• Built an automated Visitor Management System for Mahindra, handling 300+ daily visitors and reducing check-in time from 10 minutes to 1 minute using barcode-based Entry/Exit APIs with automated SMS and email notifications.
• Designed and optimized REST APIs for field operations (attendance, dealer visits, orders, dispatch logs), processing 10,000+ daily operational records, and improved performance by 40–60% using indexing, pagination, and efficient SQL queries.
• Implemented a secure RBAC (Role-Based Access Control) system with JWT authentication, permissions tables, and middleware-level authorization for Salesperson, Manager, Dealer, Distributor, and Admin roles.
• Developed cross-platform Flutter mobile features with optimized UI, state management, and integrations including Google Maps, GPS tracking, FCM notifications, and real-time syncing for 100+ field agents.
• Took end-to-end ownership of backend architecture, including cron jobs, database design, performance tuning, deployment pipelines, and full audit logging for production systems.