SAURABH SOLANKI

I’m an aspiring data analyst with hands-on experience turning large, messy datasets into clear, decision-ready insights. As a Student Counseling Intern (Sub-Mentor) at STBG Academy, I advised 100+ students by analyzing JEE/VITEEE percentiles against historical cutoffs and guiding them through JoSAA/CSAB/JAC processes to improve decision clarity in high-stakes situations.

In my analytics work, I built an end-to-end airline loyalty segmentation pipeline (10,000+ records) using Python, SQL, and Scikit-learn, and shipped an interactive Streamlit dashboard that reduced reporting latency by 80% while projecting a 15% uplift in customer retention. I also query-optimized PostgreSQL datasets (5,000+ transactions), computed RFM-based Ideal Customer Profiles capturing 80% of revenue from the top 20% of buyers, and used CLV decay modeling to recommend sun-setting 3 low-ROI campaigns with a projected 15% budget optimization. Alongside this, my market research and GTM strategy project involved primary research with 60+ micro-entrepreneurs, estimating a bottom-up TAM of 12,000 Cr and designing a D2C cost model that reduced intermediary markups by 50% while sustaining a 10% target operating margin.