Amey Ranaware

Graph Intelligence for SAP

NL→Cypher agent over Neo4j with 85 hardcoded query functions, deterministic semantic routing, and a live Schema Discovery Agent.

• 85 hardcoded functions where the LLM selects which to call, never generates raw data. Zero hallucination, zero injection
• 4 level escalating retries: chain of thought → model switch → sub-query decomposition → nearest function fallback
• Schema Discovery Agent auto-introspects Neo4j on startup (labels, rels, types, samples). Zero hardcoded schema
• GraphRAG + Semantic Routing with domain-tuned TF-IDF that locks queries to functions before the LLM sees them. 74 routing plans
• Multi-layer conversation memory with Redis entity memory for pronoun resolution and semantic cache (cosine > 0.85) that skips the full pipeline
• 92% useful answer rate, 40% exact match on benchmark queries

Connect and Stay Consistent

Peer learning platform where groups watch YouTube playlists together, track progress, and compete on leaderboards.

• 3-shard MongoDB architecture with hash-based distribution and custom shard-aware resolution (replaced Mongoose .populate() entirely)
• YouTube progress tracking with localStorage-first writes, milestone-based backend sync, and rewind-safe progress via maxPositionRef
• Optimistic real-time chat via Socket.io with client-side ID assignment for instant rendering and 10 msg/s rate limiting
• Redis-cached leaderboards with cross-shard aggregation, weighted scoring, and 5-min TTL
• Zero N+1 queries across all playlist endpoints using flat batch fetches and O(1) Map merges
• Nightly cron sync auto-refreshes playlists from YouTube while preserving per-video watch progress

AI Dev Team Autonomous Software Pipeline

A 28 node LangGraph pipeline orchestrating 6 specialized AI agents through conditional routing, retry loops, and human in the loop checkpoints.

• 4 execution phases with conditional routing and retry loops
• 6 AI agents (PM, Architect, Coder, Reviewer, Executor, Debugger)
• Role specific prompts with 3 tier error escalation
• Mission Control dashboard (React + Zustand + WebSocket)
• Real time event streaming and live pipeline visualization
• Token budget tracking and human in the loop checkpoints
• Redis backed checkpointing with multi LLM failover (Gemini & DeepSeek)

DSA Problem Solving Platform

A full featured DSA platform optimized with pagination, indexing, and caching. Supports code execution, AI assistance, contests, payments, analytics, and moderation tools.

• Real time contest ranking system
• Judge0 code execution integration
• Google Gemini AI assistance