Vriti Bhardwaj

Business Intelligence Analyst

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.

PythonLang ChainGoogle Gemini APIGCPSQLProphetARIMAA B TestingCausal Inference

Senior Data Analyst

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.

SQLETLAWS RedShiftLookerPythonK MeansTime SeriesCohort Analysis

Business Intelligence Analyst

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.

MySQLETLPythonData WarehouseEDAWeb ScrapingAPI Integration

Business Intelligence Analyst Intern

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.

AppsflyerGoogle AnalyticsFacebook APIInstagram APIsData ExtractionAutomation

Research Analyst Intern

Harvard University

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%.

PythonPyMOLAutoDock VinaMolecular ModelingData Analysis