Vriti Bhardwaj

Engineered scalable LLM-powered analytics pipelines using Python, LangChain, and Google Gemini API to mechanize ad-hoc data discovery, reducing inquiry volume by 30%. Designed self-serve menu analysis frameworks and automated time-series forecasting pipelines to project monthly EBITDA across 1,000+ franchises.

Built production SQL/ETL pipelines in AWS Redshift for real-time anomaly detection and root-cause analysis. Developed K-Means clustering and predictive time-series models to forecast deal performance, driving 15% revenue growth on promotional items.

Overhauled core Data Warehouse architecture on MySQL and engineered secure ETL pipeline configurations. Migrated marketing CRM data and performed exploratory analysis to estimate ROI in marketing campaigns.

Automated data extraction and conversion using Appsflyer, Google Analytics, Facebook, and Instagram APIs on a daily basis to identify valuable touch points for analysis of 3 million+ users.

Modeled macromolecule-ligand binding kinetics using Python, PyMOL, and AutoDock Vina, achieving a 30% reduction in binding free energy calculations and reducing simulated drug candidate rejection rates by 40%.

Bachelor in Engineering degree from Netaji Subhas Institute of Technology (University of Delhi) from 2016 to 2020.