somya gupta

I’m a data professional with a strong foundation in statistics, SQL, and Python, focused on solving real-world business problems with analytical and machine learning skills. I enjoy turning raw, messy data into dependable insights that teams can act on quickly.

In my trainee role at KPIT Technologies, I built Power BI dashboards that improved visibility of revenue trends and customer mix, enabling managers to generate data-driven decisions 30% faster. I also developed scalable, data-driven workflows using SQL and Python to automate data validation and improve confidence in KPI reporting.

My projects reflect how I work end-to-end: in Logistics Analysis, I managed operational inefficiencies by analyzing delivery delays and vehicle breakdowns across a 28K+ order network, maintaining ~80% on-delivery performance while reducing unmaintained aging fleet vehicles by 30%. In Customer Churn Analysis, I prepared features by resolving data quality and schema misalignment, then built a Random Forest classifier that achieved 78% accuracy.

I bring a rigorous, experimentation-minded approach—grounded in hypothesis testing, A/B testing, multivariate testing, and power analysis—along with practical visualization and experimentation techniques like funnel and cohort analysis. I’m energized by roles where I can combine clean engineering with measurable business impact using SQL, Python, and modern BI tools.