Back to Developers
sparsh soni

sparsh soni

Data Analyst

Bengaluru, India
80
Profile Score

About

Data Analyst with experience in SQL, Python, Excel and BI tools, driving retention, funnel, cohort and growth analytics. Proven impact in improving customer retention and conversion through data-driven insights.

Skills & Expertise (27)

SQL Advanced
8.0/10
1
Years Exp
Python Intermediate
7.6/10
1
Years Exp
Excel Advanced
7.4/10
1
Years Exp
Bi tools Intermediate
7.2/10
1
Years Exp
Data Visualization Intermediate
7.0/10
1
Years Exp
scikit-learn Pandas MS SQL Server Data Automation BigQuery Looker Studio Data Analysis Tableau Data Manipulation Hypothesis Testing Data Cleansing Data Extraction ETL Data Transformation EDA Power BI Data Modeling Statistics Google Sheets Data Pipeline AB Testing Data Governance

Work Experience

Data Analyst

Supertails

Nov 2025 - Present

Developed and automated comprehensive pharmacy retention, cohort, and funnel dashboards using SQL (joins, CTEs, window functions, subqueries), Python, BigQuery, Excel (Pivot Tables, XLOOKUP, VLOOKUP), and Looker Studio. Analyzed repeat purchase patterns, churn trends, and customer journeys segmented by city, OTC/Non-OTC categories, customer types, and veterinarian segments. Executed data cleaning, transformation, and exploratory data analysis (EDA) to identify key retention drivers and funnel leakages. Delivered actionable insights that reduced customer drop-offs by 11%, increased retention rates by 9%, and contributed to a 12% revenue growth through targeted regional and operational strategies.

Data Science Intern

Learnvista Pvt ltd

May 2025 - Oct 2025

Designed and implemented a robust MS SQL Server relational database integrating customer journeys, engagement metrics, reviews, and product data to streamline data management. Performed comprehensive data cleaning, transformation, and advanced data modeling using SQL techniques (joins, CTEs, subqueries, window functions) ensuring accurate, consistent datasets across multiple sources. Developed interactive business intelligence dashboards with Power BI (DAX) and Excel (Pivot Tables, Power Query) to analyze job market trends, customer demographics, and campaign performance from 10,000+ job postings. Enhanced click-through rate (CTR) by 11% and conversion rates by 8% through actionable data-driven insights derived from BI dashboards. Built a predictive analytics model using Python (Pandas, Scikit-learn) to identify key customer churn drivers, supporting retention strategies. Conducted exploratory data analysis, data preprocessing, imbalance treatment, encoding, feature scaling, and hyperparameter tuning to optimize a Random Forest model achieving 98% accuracy and 0.93 recall.

Education

B.Tech/B.E. - Bachelor of Technology / Engineering - Ramaiah Institute of Technology

- 2023 · Afghanistan

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceMar 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation

Skills (27)

SQL Python Excel Bi tools Data Visualization scikit-learn Pandas MS SQL Server Data Automation BigQuery +17 more