Senior Data Analyst — Pune, India
I turn raw operational data into SQL and Python pipelines and Power BI and Tableau dashboards that leadership runs the business on — 8+ years across US healthcare, B2B manufacturing and wholesale distribution.
Pune, India · open to relocation
−12%
patient complaints
Weekly KPI view
SQL
Power BI
Tableau
Python
Snowflake
PostgreSQL
Looker
AWS
LangChain RAG
Excel & VBA
A/B Testing
Cohort Analysis
Pandas
Polars
01
Impact
Results, not just reports.
A few numbers I’m proud of — each one came from a dashboard, model or pipeline that people actually used.
NY Bone & Joint
−12%
patient complaints
A Python NLP pipeline classified 10K+ reviews by sentiment and department.
NY Bone & Joint
−15 min
average patient wait
Tableau dashboards on visits, staffing and satisfaction drove weekly scheduling changes.
NY Bone & Joint
50K+
patient records migrated
Owned cleanup, validation and reconciliation for the ModMed EHR cutover — on schedule.
Northwell Health
−50%
ad-hoc report requests
A central Power BI suite moved leadership to self-service KPIs.
Northwell Health
−20%
monthly reporting cycle
15+ Excel and VBA routines rebuilt as tested, scheduled Python pipelines.
Anucool Industrial Aids
+20%
marketing ROI
RFM segmentation redirected campaign spend to high-value cohorts.
02
Experience
Where I’ve done the work.
Aug 2026 – Present
Remote
Independent Consultant
Data & Automation Consultant · US fragrance wholesale agency
Replaced a manual Excel purchase-order process for 6 US retail accounts (TJ Maxx, Burlington, Macy’s, Ross, Target, HomeGoods) with a Python app that maps each retailer’s template and exports validated orders.
Put the factory’s full cost history one click from every order line by integrating the vendor’s ERP pricing API.
Cut product-photo lookup across a 47,000-image library to ~10 requests per order — under 30 seconds.
Aug 2025 – Sep 2026
New York, NY
New York Bone & Joint Specialists
Data Analyst
Cut patient complaint volume 12% with a Python text-mining pipeline over 10K+ reviews.
Reduced average patient wait time by 15 minutes with Tableau dashboards that drove weekly scheduling changes.
Migrated 50K+ patient records to ModMed EHR on schedule and trained 50+ staff on the new system.
Jun 2024 – Aug 2025
New Hyde Park, NY
Northwell Health
Data Analyst
Halved ad-hoc reporting requests by building the central Power BI suite for patient load and departmental KPIs.
Shortened the monthly reporting cycle 20% by moving 15+ Excel and VBA routines to Python pipelines with PyTest checks in GitHub Actions.
Saved onboarding staff 15+ hours a week with a LangChain RAG assistant over nursing-education documentation.
May 2022 – Feb 2025
Garden City, NY
Adelphi University
Data Analyst & ML Fellow · part-time, alongside graduate study
Predicted semiconductor material properties with 88% accuracy using Graph Neural Networks in PyTorch Geometric.
Cut data-preparation runtime 60% by rebuilding a 500K+ record pipeline in Polars with GPU batch processing.
Feb 2017 – Jul 2021
Pune, India
Anucool Industrial Aids
Marketing Data Analyst
Improved marketing ROI 20% with RFM customer segmentation in Python.
Cut monthly reporting time 60% by replacing hand-compiled sales reports with connected SQL and Excel MIS dashboards.
03
Selected projects
Things I’ve built on my own time.
Recent case studies on India-focused data across SQL, BI, experimentation, forecasting and machine learning.
Power BI
SQL
DAX
Hospital Operations Analytics
Turns messy hospital system extracts into data-quality gates, a Power BI star schema with 38 DAX measures and KPI SQL for OPD waits, beds and insurance claims.
View on GitHub
SQL
PostgreSQL
Cohorts
Quick-Commerce SQL Analytics
25 business questions answered in portable SQL on 451K orders across 8 Indian cities: cohorts, RFM, basket analysis, delivery SLAs and unit economics.
View on GitHub
A/B Testing
Statistics
UPI Cashback A/B Test
A full experiment readout: power analysis, sample-ratio checks, CUPED variance reduction, Holm-corrected segments, guardrails and an ROI-based rollout decision.
View on GitHub
Python
RFM
CLV
D2C Customer Segmentation
RFM playbook, cohort retention, COD and RTO economics, LTV:CAC and a predictive customer lifetime value model for an Indian D2C brand.
View on GitHub
Forecasting
LightGBM
FMCG Demand Forecasting
Weekly demand forecasts comparing statistical models with a global LightGBM, backtested with festival effects and turned into safety stock and inventory simulations.
View on GitHub
Machine Learning
SHAP
Credit Risk ML Toolkit
Credit default modelling with Optuna tuning, calibration, SHAP reason codes and a fairness audit, mapped to a 300–900 score with Gini and KS reporting.
View on GitHub
More on GitHub
04
Toolkit
The tools I reach for.
SQL & data modeling
SQL (CTEs, window functions)
PostgreSQL
Snowflake
Star-schema modeling
Data warehousing
ETL
BI & visualization
Power BI (DAX, Power Query)
Tableau
Looker
AWS QuickSight
Excel (Power Pivot, VBA)
KPI design
Python & automation
Pandas
Polars
Scikit-learn
PyTest
REST APIs
Git & GitHub Actions
AI & analytics
LangChain RAG
NLP
A/B testing
RFM & cohort analysis
AWS Lambda & RDS
Delivery
Requirement gathering
Stakeholder management
Data migration & reconciliation
UAT
User training
Domains
US healthcare
Retail & wholesale
B2B manufacturing
Supply chain
05
Writing
Notes from the data trenches.
I write on Medium about data engineering, analytics and the tools in between.
Jul 2025
Building a Lightweight Data Validation Framework with PyTest and GitHub Actions
May 2025
Amazon Product Tracker with AWS: From Web Scraper to QuickSight Dashboard
Feb 2025
Excel Macros in Healthcare: Automate, Analyze, and Optimize Data
Jan 2025
Streamlining Healthcare Interoperability Using FHIR Mapping
Nov 2024
Optimizing Data Warehouses with Slowly Changing Dimensions
All articles on Medium
06
Education
Where I learned the craft.
2023 – 2024
MS, Business Analytics
Adelphi University, New York
GPA 3.97 / 4.0 · Dean’s Award
2021 – 2023
MS, Sports Management
Adelphi University, New York · Analytics minor
2017
B.Com, Marketing & Accounting
Savitribai Phule Pune University