Shourya
Upadhyaya.

Architected 30+ REST APIs and 10 Prisma ORM models backed by PostgreSQL. Built a stateful WebSocket hub for sub-second cross-device Pomodoro timer synchronization, added Redis caching that reduced analytics database load by 80%, integrated AI daily habit reviews, and deployed a multi-container Docker Compose stack on a Linux VPS behind Nginx with Prometheus and Grafana observability.

300+ Users

10,000+ total platform visits

-80% DB Load

via Redis write-through cache

30+ APIs

10 Prisma models & WS sync

• Next.js
• React
• TypeScript
• Tailwind CSS
• Zustand
• Node.js
• Express.js
• REST APIs
• WebSockets
• PostgreSQL
• SQL
• Prisma
• Redis
• Docker
• Nginx
• Prometheus
• Grafana
• Linux

Engineered a Node.js and TypeScript WebSocket media gateway ingesting live 48 kHz mono PCM16 call streams, reassembling arbitrary network frames into ordered 3-second sliding windows while enforcing a strict byte-conservation invariant. Routed chunks over a persistent WebSocket to a FastAPI ML engine running RawNet2, WavLM, and SpeechBrain acoustic deepfake models alongside OpenAI Whisper STT, achieving ~1.1s median CPU latency while queuing PostgreSQL writes off the hot audio path.

~1.1s CPU

median inference per 3s window

48 kHz PCM16

100% byte-conserving ring buffer

SIH Finalist

off-path async PostgreSQL queue

• Node.js
• TypeScript
• Python
• FastAPI
• PyTorch
• OpenAI Whisper
• ONNX Runtime
• SpeechBrain
• WebSockets
• PostgreSQL
• Prisma
• Next.js
• Tailwind CSS

Built the full-stack e-commerce platform for 100+ registered users using React, Express.js, and MongoDB aggregation pipelines for sales analytics and product recommendations. Cached the catalog API in Redis to slash latency by 90% (1.5s to 150ms) and keep homepage load below 50ms. Integrated Razorpay with HMAC webhook signature verification and idempotency keys, processing 20+ live orders with zero duplicate charges.

1.5s → 150ms

catalog API latency (-90%)

<50ms Load

serving 100+ registered users

0 Duplicates

HMAC idempotent Razorpay webhooks

• JavaScript
• Node.js
• Express.js
• REST APIs
• MongoDB
• Redis
• React
• Zustand
• Tailwind CSS
• Docker

Designed a 14-table 3NF/BCNF PostgreSQL 16 control plane where multi-tenant isolation is enforced at the database engine via Row-Level Security (app.current_org_id) and btree_gist temporal exclusion constraints. Eliminated check-then-act VM quota race conditions using SELECT FOR UPDATE row locks inside transactional stored procedures, and partitioned a 1,000,000+ row telemetry table with BRIN & GIN indexes to cut time-range query latency from 42ms to 0.2ms.

42ms → 0.2ms

on 1M+ BRIN-partitioned rows

PG16 RLS

& SELECT FOR UPDATE quota locks

Live SSE

pg_notify Docker telemetry stream

• PostgreSQL
• SQL
• PL/pgSQL & RLS
• TypeScript
• Node.js
• Express.js
• REST APIs
• React
• Tailwind CSS
• Docker
• Nginx

Built an Express 5 + Next.js 16 platform that ingests roles from Greenhouse, Lever, Ashby, and Workday, scores each posting against multiple LaTeX/PDF resumes using a deterministic 0–100 weighted rubric (+35 skills, +20 role, +15 domain) before optional LLM refinement, classifies recruiter emails via a 12-class Gmail OAuth state machine with forward-only pipeline transitions, and executes dry-run-first Playwright application workflows.

0–100 Rubric

deterministic multi-resume scorer

12-Class NLP

forward-only Gmail state machine

8+ ATS Feeds

with dry-run Playwright runner

• Next.js
• React
• TypeScript
• Tailwind CSS
• Node.js
• Express.js
• REST APIs
• PostgreSQL
• Prisma
• Playwright

Engineered a dependency-inverted Go CLI and library that walks nested data lakes, computes streaming SHA-256 hashes to classify files as new, modified, or unchanged, and dispatches pending files through a generic bounded worker pool (pool.Run[In, Out]) with 30-second per-file context.WithTimeout isolation and signal-aware graceful shutdown (SIGINT / SIGTERM).

pool.Run[T]

generic bounded goroutine pool

SHA-256 Diff

64 KB streaming incremental skip

30s Timeout

per-file isolation & pgx/v5 catalog

• Go
• PostgreSQL
• SQL
• Linux

Engineered the real-time competitive coding portal for CodeChef-VIT's flagship contest with 1,000+ active participants. Built a multi-language CodeMirror 6 IDE (supporting C++, Python, Java, and JavaScript) backed by triple-layer state persistence (Zustand in-memory store, LocalStorage write-through cache, and debounced MongoDB sync) and Axios auth/retry interceptors to guarantee zero lost submissions under 40% peak concurrent load.

1,000+ Coders

active contest participants

3-Layer Sync

Zustand · LocalStorage · MongoDB

40% Peak Load

sustained with 0 dropped submits

• Next.js
• React
• TypeScript
• JavaScript
• C++
• Tailwind CSS
• Zustand
• CodeMirror 6
• MongoDB