Projects using Azure SQL Database in Delhi

Projects using Azure SQL Database in DelhiProjects using Azure SQL Database in Delhi

Cover image for An AI-driven trading engine that

An AI-driven trading engine that analyzes 200-DMA breakouts and real-time market sentiment to generate long/short recommendations. It scans 1,500+ NSE stocks in under 2 seconds and uses generative AI to build option strategies, delivering event-driven trade signals end-to-end. I built the full Django backend, async APIs, and the signal-generation logic. Accomplishments and responsibilities: Built an AI-driven trading engine analyzing 200-DMA breakouts and market sentiment, generating long/short signals with ~70% directional accuracy — outperforming baseline strategies by 35%; Integrated generative-AI insights for automated option-strategy creation (spreads, straddles, condors), improving Sharpe ratio by 1.6× and cutting manual analysis time by 60%; Developed a Django backend with async APIs scanning 1,500+ NSE stocks in under 2 seconds, achieving 40% lower latency with event-driven alerts.

0

74

Cover image for Spent an afternoon this week

Spent an afternoon this week chasing down why a client's order dashboard took around 2.5s to load. Turned out the page was firing 300+ database queries. Classic N+1 problem. Every order in the loop was making its own separate trip to the DB just to grab the customer and product. One line fixed it. select_related() tells Django to pull the related rows in a single JOIN instead of querying them one at a time. 312 queries down to 3. Page load went from 2.4s to 0.08s. The annoying part is this never shows up on small datasets in dev. It only bites you in production once the table grows. So now I always check the query count in Django Debug Toolbar before shipping any list view. What's the worst N+1 you've run into?

0

86