Swapnil Gaikwad

Swapnil Gaikwad

Business Analyst | Data Analyst
India
Marathi, English, Hindi
Full-time Hybrid

About Me

Business Analyst with 5.5+ years of experience translating business requirements into data-driven solutions across fintech (PhonePe) and healthcare (HealthLedger). Skilled in requirements gathering, BRD/FRD documentation…

Experience

Business Analyst (EDC SSRKAM & Mass Offline Rural)

PhonePe Pvt. Ltd. · Pune & Indore
Dec 2022 - Present · 3 years 11 months

<p>Partnered with senior leadership and cross-functional teams (HR, Finance, Technology) to gather requirements and define KPIs for national service operations covering 400+ service agents.</p><p> Performed root cause analysis (RCA) and process mapping to automate 18+ daily MIS reports, reducing report turnaround time by 35%.</p><p> Authored business requirement documentation for incentive and allowance structures; tracked monthly performance against defined KPIs.</p><p> Analyzed regional performance data to identify gaps and recommend process improvements; presented findings to national leadership.</p><p> Facilitated stakeholder workshops across cross-functional teams to align on operational goals and reporting standards.</p><p> Gathered and documented reporting requirements for 6,000+ field staff (on-roll & off-roll) across MP & Gujarat, defining and tracking 10 KPIs.</p><p> Designed real-time dashboards (Excel, SQL, Looker Studio), translating business needs into functional reporting tools.</p><p> Conducted trend and gap analysis to support strategic decisions; standardized data flow and reporting across regional and national teams.</p>

Business Analyst

SmartQR Technologies (HealthLedger Pvt. Ltd.) · Pune
Aug 2022 - Dec 2023 · 1 year 3 months

<p>Gathered business requirements and contributed to BRDs/FRDs for 18+ live corporate health analytics reports, directly supporting client meetings and renewal decisions.</p><p> Improved predictive model accuracy from 54% to 96% by applying hypothesis testing (Chi-square, Bland-Altman plots) to validate clinical data requirements.</p><p> Coordinated UAT and supported change management for new product development initiatives using Python and ML-driven insights.</p><p> Built dashboards (Tableau, Looker Studio, Excel) translating stakeholder requirements into actionable health-metric tracking for 18+ corporate clients.</p><p> Documented process workflows that contributed to a 150% improvement in healthcare delivery operations efficiency.</p>

Store Executive

Yash Tyres & Car Services · Nashik
Feb 2020 - Aug 2021 · 1 year 6 months

<p>Supported inventory data accuracy and process documentation for store operations.</p><p> Assisted in identifying operational gaps and streamlining customer-facing workflows.</p>

PROJECTS

A/B Testing & Regression Analysis – Marketing ROI Optimization

PhonePe · github.com/Swapnil251997
Duration : 07-Mar-2024 - 25-Jul-2024

<ul><li>Gathered business objectives and performed EDA, hypothesis testing (T-test, p-value: 9.35e-134), and regression modelling (R²: 76.35%) on 365-day campaign data.</li><li>Delivered a data-backed recommendation identifying Facebook as the most cost-effective platform vs. Google Ads, supporting budget reallocation decisions.</li></ul><p></p>

Certifications

PGCP in Business Analytics & Applications

Indian Institute of Information Technology, Pune, India · Tiruchirappalli , Tamil Nadu , India · 2024

Skills

Requirements Gathering BRD/FRD Documentation GAP Analysis UAT Coordination Process Mapping Stakeholder Management SQL Python Pandas NumPy Matplotlib Hypothesis Testing Regression Analysis EDA Power BI Tableau Looker Studio Advanced Excel Google Sheets Dashboard Automation JIRA ZOHO CRM Root Cause Analysis Cross-functional Coordination Agile Documentation
Report this Profile?