I built a customer churn analysis for Blinkit, modelling eight relational tables and using PostgreSQL to define churn, measure cohort retention, and analyze customer lifetime value. I connected delivery delays, ratings, support resolution time, and discounting to churn across four Power BI dashboards.
For an Indian financial fraud analysis project, I wrote SQL queries to examine velocity checks, impossible travel, repeat fraud, merchant risk, and Benford's Law anomalies. I created Executive and Merchant dashboards with DAX measures and live SQL-based refresh.
I analyzed more than 55,000 campaigns for Nykaa, calculating CTR, CPA, ROAS, ROI, and profit margin in Excel and Power BI. I identified the highest-ROAS channel and recommended shifting spend away from low-return campaign types for specific customer segments.
My other projects include a live weather dashboard using REST API data and an analysis of overnight versus intraday returns in Indian equities. I also served as President, after earlier serving as Marketing Head, of AURORA - Human Enhancement Club, University of Delhi, and worked as a Social Media Marketing Intern at SkillingYou.
