Skip to content
View MohansaiSundarasetty's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report MohansaiSundarasetty

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Mohansai Sundarasetty, healthcare data analyst: a heartbeat line that becomes a rising metric line profile views



4+ years in healthcare data, 12 end-to-end repos, 12 of 12 with tests CI and benchmarks, MSc Data Science

🩺 current focus

Building healthcare analytics that prove their own numbers. Right now that means:

  • Claims anomaly detection with reason codes: hybrid rules + isolation forest, recall 1.00 on 4,643 seeded anomalies, 21 ms scoring
  • Data quality as a CI gate, not a dashboard: YAML contracts + learned baselines at 390k rows/s; caught a 24% mean shift that PSI scored a harmless 0.047
  • Forecasts that must beat seasonal naive to ship: when naive won on 13 of 40 SKUs, naive kept the crown
  • Causal inference calibrated on null panels first: naive math showed 16.5% false positives; the shipped rule holds 11.5% at a nominal 10%

🔀 pivot point

My career has one hinge in the middle. I started at McKesson in India, close to pharmacy and claims operations, where I learned that a number nobody trusts is a number nobody uses. That question (how do you make analytics trustworthy?) pulled me to the UK for an MSc in Data Science at Teesside University, and then into Optum UK, where the datasets got bigger and the stakes got clinical. The through-line never changed: healthcare data, and the engineering discipline to make it hold up under audit. Every repo below is that discipline in miniature: seeded ground truth, reconciliation invariants, calibration before claims.

⚡ stack status

Experience levels: Python, SQL, pandas and scikit-learn, Power BI and Tableau, Git and CI advanced; PySpark, Snowflake, Azure and AWS solid

🧱 building blocks

languages + analysis

Python SQL Pandas NumPy scikit-learn

data platforms

PySpark Databricks Snowflake PostgreSQL

BI + storytelling

Power BI Tableau Streamlit

cloud + delivery

Azure AWS GitHub Actions pytest

🔬 featured work

Repo What it proves
claims-anomaly-radar Hybrid rules + isolation forest flags claim anomalies with reason codes; recall 1.00 on seeded ground truth
claims-lakehouse-pipeline PySpark medallion where every layer reconciles to the previous; $308M conserved to the penny, 2M rows under 2 minutes
warehouse-cost-attributor SQL credit attribution that reconciles to the bill within 0.0006%; found 25.4% idle spend
pharmacy-demand-forecaster Rolling-origin backtests where models must beat naive; +1.8pt service level where they did
intervention-impact-analyzer Counterfactual + placebo inference, self-calibrated on null panels before reporting anything
sql-regression-radar CI gate on EXPLAIN plan fingerprints; catches a dropped index with a plan diff, not a hunch
six more where those came from
Repo One-liner
healthcare-data-quality-gate YAML contracts + learned baselines gate pipelines in CI; 390k rows/s
scd2-sentinel Nine SQL checks for SCD2 dimensions; 1.5M-row dim validated in 13.6s
kpi-drift-rootcauser Rate/mix decomposition of KPI moves; contributions reconcile to 1e-9
patient-feedback-miner NMF topics + budgeted sentiment; 0.982 F1 from 1,000 labels
fhir-ingest-gateway Validating, idempotent FHIR ingestion with DLQ; ~600 resources/s
provider-record-linker Record linkage with measured blocking; 0.978 precision, 0/20 trap merges

🤝 quick connect

LinkedIn Gmail GitHub


"All models are wrong, but some are useful." - George E. P. Box

Pinned Loading

  1. claims-anomaly-radar claims-anomaly-radar Public

    Explainable anomaly detection for healthcare claims: hybrid rule engine + isolation forest caught 100% of 4,643 seeded anomalies in 252,750 claims with a plain-English reason on every flag. 21ms on…

    Python

  2. claims-lakehouse-pipeline claims-lakehouse-pipeline Public

    PySpark medallion pipeline where every layer proves it matches the previous one: 2M multi-source claim rows through bronze/silver/gold in <2 min with five conservation checks (rows + money reconcil…

    Python

  3. intervention-impact-analyzer intervention-impact-analyzer Public

    Did the change actually work? Control-based counterfactual + placebo-test inference, calibrated on 200 null panels: naive interval math cried "impact" 16.5% of the time at claimed 95% confidence; t…

    Python

  4. pharmacy-demand-forecaster pharmacy-demand-forecaster Public

    Pharmacy demand forecasting that admits when naive wins: rolling-origin backtest across 5 model families with a beat-naive promotion gate (naive kept 13/40 SKUs), pooled-WAPE evaluation, Croston fo…

    Python

  5. sql-regression-radar sql-regression-radar Public

    CI gate for SQL performance: EXPLAIN plan fingerprints + noise-aware timings vs a committed baseline. Fails the PR whose migration flips an index scan into a 1M-row seq scan, with a readable plan d…

    Python

  6. warehouse-cost-attributor warehouse-cost-attributor Public

    Concurrency-aware warehouse cost attribution in SQL: splits Snowflake-style credit spend across teams and dashboards, reconciles to the metered bill within 0.0006%, and surfaced 25.4% idle spend pl…

    Python