High-Concurrency Ticketing API
● Designed an enterprise-grade Web API utilizing cloud architectures and distributed computing principles using Clean Architecture (N-Tier) to handle extreme traffic and prevent data corruption during race conditions. ● Implemented Optimistic Concurrency Control with SQL Server RowVersion tracking to eliminate double booking, returning 409 Conflict HTTP responses. Applied a security-first mindset alongside Optimistic Concurrency Control to eliminate double-booking. ● Applied Repository Pattern and Dependency Injection to fully decouple business logic from the infrastructure layer.
Weather & Air Quality MCP Server
● Developed a production-ready Model Context Protocol (MCP) server enabling AI assistants to access real time weather, air quality, forecasts, and health advisories. ● Integrated Open-Meteo REST APIs using asynchronous HTTP requests with geocoding, error handling, and structured JSON responses. ● Designed reusable MCP tools for weather, air quality, 5-day forecasts, and personalized health recommendations. ● Built a modular backend with local testing and seamless Claude Desktop integration, following scalable and maintainable coding practices.
Alumni Connect — Feedback System for ICEM
● Built and deployed a live web application (shivamsagar04.pythonanywhere.com) enabling alumni to submit structured feedback with user authentication and role-based access. ● Implemented search, filtering, and an admin dashboard for real-time monitoring; designed a clean MVT interface ensuring both transparency and submitter confidentiality.