~40s~400ms
Dashboard queries, rebuilt around a deferred join

Hi, I'm Sarvagya, a developer based in India with passion to learn and code.
~40s~400ms
Dashboard queries, rebuilt around a deferred join
2K/day400K/day
Calendar invite ceiling, once sending was decoupled from event creation
6 subqueries1 join
Listing query, pre-aggregated instead of correlated
~8s~2s
Page load on a production site, with the SEO work that went with it
About
I'm a software engineer in Delhi NCR working across backend and full-stack — Node.js, TypeScript, Express, React/Redux and SQL, with Redis and RabbitMQ where the work needs them. I graduate from MAIT (GGSIPU) in May 2026 with a 9.2 CGPA, though most of what I know came from shipping: 331 commits across two live codebases.
At Kraftshala I owned features end to end on the platform a team used daily — dashboard queries from ~40s to ~400ms, a self-service alerting platform where teams write their own SQL rules, bulk Excel ingestion at 1,000+ records an upload, Google OAuth SSO, and calendar invites re-architected through AWS SES from around 2,000 a day to 400,000. The alerting platform is the one I would walk you through: months later another engineer shipped two of their own features on top of it, without needing me.
Before that I built a MERN AI chatbot and a Zoho CRM lead sync at BWS, and mentored 100+ students in Java and DSA at Coding Blocks. On my own time: a six-service delivery platform on RabbitMQ, a real-time chat system with offline delivery, and an AI SaaS on two LLM providers. I also broke production once — an SSO change locked some admins out of password sign-in, and I caught it and rolled it back inside 48 hours.
Three are public repositories you can clone. One shipped inside a company, to a team that used it daily.
01 / 04Six months owning features on the internal platform a real team used daily.
Kraftshala production work — proprietary code. More in Experience.
Self-service alerting on user-defined SQL rules. Another engineer later shipped two features on it unaided.
Dashboard queries rebuilt around a deferred join — ~40s to ~400ms, and the inflated pagination counts with it.
Bulk Excel ingestion: 1,000+ rows an upload, validated before any write, through a Bull queue.
02 / 04Six independent services coordinating one order, built so any of them can fail without taking the order with it.
Six services communicating over asynchronous RabbitMQ events, with live order and rider tracking on Socket.IO.
Redis caching cut database reads by roughly 60% and latency by roughly 35%.
Retries, a dead-letter queue and health checks so a downed service degrades instead of losing orders.
03 / 04A messaging platform where a message survives the recipient being offline — passwordless sign-in, delivery state you can trust.
RabbitMQ sits behind the WebSocket layer rather than the socket writing straight to the database — which is what makes acknowledgements and offline delivery work.
Redis caching and query optimization cut response times by roughly 35%.
JWT authentication with per-message delivery state, so the UI can show sent, delivered and read honestly.
04 / 04Content and image generation across two LLM providers behind a single adapter.
Two providers behind one interface, so swapping or adding a model is a config change rather than a rewrite.
Token-based authentication and REST APIs, shipped with CI/CD.
Released open-source with documentation — counting this site's Gemini integration, that is three providers on the same abstraction.

331 commits across two live codebases in six months. Features owned end-to-end, from migration to admin UI.

Rewrote a dashboard query from ~40s to ~400ms with a deferred-join pattern, and fixed the pagination counts it had been inflating.

Broke admin password sign-in with an SSO restriction, caught it, and rolled it back inside 48 hours.
💼 My Career Overview
Kraftshala
Owned features end-to-end across a Node/TypeScript/MySQL backend and a React/Redux internal ops platform. 331 commits across both repositories.
🗓️ March 2026 - September 2026
Responsibilities
BWS
Built and deployed the company's website chatbot and lead-capture flow on the MERN stack, then optimized the site's performance and on-page SEO.
🗓️ July 2025 - December 2025
Responsibilities
Coding Blocks
Mentored 100+ students through Java, data structures and algorithms via doubt sessions and one-on-one code review.
🗓️ May 2024 - August 2024
Responsibilities
The Skills I Bring to the Table
TypeScript
React & Redux
Node.js
Express
MongoDB
PostgreSQL
Redis
RabbitMQ

☎️ Contact Information
This is the second chatbot I’ve shipped. The first ran in production at BWS.
It answers only from my documented work — no vector store, the whole corpus fits in context.