High-throughput URL redirection engine using Node.js and PostgreSQL with a write-through Redis caching layer resolving link lookups with <1ms sub-millisecond latency across 10K+ simulated requests/sec. Features active/pause link state control with instantaneous Redis cache invalidation, timezone-aware visitor analytics with AT TIME ZONE, zero-dependency regex User-Agent parser, raw inline SVG charts, and dynamic Blob QR code downloader.

Context-aware agricultural advisory pipeline using LangChain (LCEL) and Groq Cloud LPUs (Llama 3 70B), streaming agronomic responses in under 800ms by injecting 7 soil telemetry metrics and weather API telemetry. Trained an ensemble Random Forest model on 2,200+ soil-climate records achieving 94.6% accuracy with <20ms inference latency and factor-by-factor Explainable AI (XAI) feature attribution. Built 5 async FastAPI REST endpoints with dual PostgreSQL/SQLite ORM caching and Docker containerization.

End-to-end data pipeline synthesizing 102K+ multi-table transactions across 100 vendors into an indexed SQLite database, calculating complex aggregations in under 1 second. Engineered multi-stage SQL Common Table Expressions (CTEs) computing estimated COGS, gross margins, and inventory ratios. Built a 22-rule automated data quality test suite and a 9-point analytical verification engine. Implemented a 4-quadrant rule-based vendor classification engine using dynamic median thresholds and deployed an interactive Streamlit dashboard.

High-performance pathfinding core in C++17 implementing optimized A*, Dijkstra, BFS, and DFS on 10,000-node grid graphs, achieving 1.6 μs average calculation latency. Reduced memory footprint by 40% utilizing flat 1D vectors and bitsets; architected a hybrid backend combining Node.js Express sub-processes with Redis caching to resolve repeat routes in <0.5ms. Interactive HTML5 Canvas visualizer rendering smooth 60 FPS path expansions.

Full-stack portfolio analytics journal offloading heavy computations (equity curves, max drawdowns, streak analysis) to PostgreSQL via SQL window functions and recursive CTEs. Programmed automated PL/pgSQL database triggers to calculate trade P&L on insertion and utilized EXPLAIN ANALYZE profiling with composite indexing on (user_id, exit_time) to eliminate sequential scans. Responsive light-themed SPA dashboard using React and Recharts.

Full-stack e-commerce system featuring an AI Voice-Assisted Navigator powered by the Web Speech API, enabling hands-free page navigation and auditory confirmation cues. Built a secure REST API in Node.js/Express with MongoDB, implementing JWT authentication, role-based admin routing gates, Cloudinary multi-image uploads, and Razorpay payment integration.

Full-stack MERN application that generates production-ready resumes with AI-assisted content optimization. Integrated Google Gemini API to parse job descriptions and generate ATS-optimized summaries, tailored bullet enhancements, and keyword alignment. Features modular drag-and-drop section editors, autosave, public sharing links, and print-ready PDF export.

Backend service for a video hosting platform built with Node.js, Express, and MongoDB. Enables secure user authentication with JWT and HTTP-only cookies, scalable profile and watch history management, avatar/cover uploads via Cloudinary, and modular video upload infrastructure.