Ishan Bhattacharya

IPL Cricket Analytics Chatbot

greSQL statements using LangChain and LLM orchestration. • Processed 1,200+ Cricsheet JSON files to construct a relational database schema capturing ball-by-ball events, player statistics, extras, and season-specific metadata. • Implemented custom SQL generation prompts, schema linking, and error-handling chains within LangChain to prevent query hallucinations and handle complex aggregate logic.