Subhrajit Kalita

At IQVIA, I build and clean large-scale patient-level cohorts from real-world claims data, using PySpark and SQL across Databricks, Redshift, and AWS.

I deliver patient journey, HCP characterization and profiling, and Site/KOL identification analyses that support pre- and post-launch commercial strategy across disease areas. I also own data preparation, feature creation, QC, and pipeline automation for AI-driven analytics solutions.

Previously, at Indian Oil Corporation Ltd, I built a secure internal stationery-ordering system that reduced manual request handling by approximately 60% and added real-time request tracking and automated workflows for 150+ employees.

I also build practical GenAI products, including a YouTube Transcript RAG Chatbot using LangChain, FAISS, and OpenAI embeddings, plus a Flask-based collaborative-filtering book recommendation system.