HM Harish Maganti

Analytics Engineer · Healthcare Data

I build data models
teams can trust.

I turn claims, EMR, and CMS data into decisions for actuarial, clinical, and executive teams — with pipelines that are tested, documented, and built to hold up. Currently at Humana.

source Raw systems 25+ feeds
staging Clean & cast type-safe
marts Star schemas facts · dims
decisions Trusted output dashboards
Get in touch GitHub LinkedIn Résumé ↗
0Medicare Advantage members modeled
0dbt models in production
0fewer downstream defect tickets
0annual compute cost removed

-- selected work

Things I've built end to end.

Analytics engineering, full-stack products, and the pipelines that ship them. Each links to source or a live site.

Analytics engineering

13 tests · passing code ↗

CMS Hospital Readmissions Analytics

The public CMS HRRP dataset modeled into a tested star schema — null-safe casting for suppressed values, surrogate keys at facility × measure grain, and a state-level excess-readmission-ratio mart.

  • dbt
  • SQL
  • DuckDB
  • Star schema
20 tests · passing code ↗

Synthea Health Analytics

An end-to-end pipeline — staging → intermediate → marts — over synthetic patient data. Star schema and a chronic-disease prevalence mart segmented by age band and gender. No PHI; reproducible from raw CSVs.

  • dbt
  • SQL
  • DuckDB
  • Python

Full-stack products

Live visit ↗

Mainaka — Student Visa Prep

A live platform I solo-built and operate, guiding students through U.S. F-1 study-visa prep. React dashboard, Node/Express API, PostgreSQL on DigitalOcean behind nginx — profiles, guided roadmap, role-based permissions, outcome tracking.

  • Node.js
  • Express
  • PostgreSQL
  • React
Live visit ↗

GlobalGoGateway — Visa Platform

Production platform for US / Canada / UK visa applications: a schema-driven form engine replicating government forms field-for-field, LLM-powered (Claude) document extraction, OTP / two-factor auth, and an approval queue with a full audit log.

  • Node.js
  • Express
  • PostgreSQL
  • LLM

DevOps & delivery

3-stage · automated code ↗

CI/CD Pipeline — Java Web App

A three-stage Jenkins pipeline — build → publish a versioned WAR to Nexus → deploy to Tomcat — running across a three-server AWS EC2 setup. Automates release from git push to live deployment.

  • Jenkins
  • Maven
  • Nexus
  • Tomcat
  • AWS EC2

-- how i build

Layered, tested, and fast.

The same shape every time: raw sources refined through tested layers into star schemas teams can query with confidence.

Dimensional model · star schema
Pipeline runtime · re-engineered
Before 3.0 h
After 1.8 h

Incremental models + partition pruning across 40+ models — 40% faster, ~$75K/yr saved.

Data quality · every layer
  • ✓ unique
  • ✓ not_null
  • ✓ accepted_values
  • ✓ relationships
  • ✓ freshness
  • ✓ range

Generic + custom tests on 50+ fields — defects caught before they reach a dashboard.

-- experience

Where I've done the work.

  1. Mar 2024 — Present Charlotte, NC

    Data Analyst / Analytics Engineer

    Humana

    • Lead the enterprise dbt + Snowflake transformation layer processing claims, eligibility, and clinical data for 5M+ Medicare Advantage members.
    • Architected 40+ dbt models with incremental strategies and partition pruning — cutting daily runtime from 3h to 1.8h and ~$75K/yr in compute.
    • Standardized CMS-HCC risk-adjustment with Actuarial, improving risk-score accuracy 8%; built Tableau dashboards for 25+ network managers.
    • Shipped CI/CD (GitHub Actions + AWS CodeDeploy) for zero-downtime dbt releases; tests on 50+ fields cut defect tickets 55%.
  2. Sep 2020 — Nov 2022 Hyderabad, India

    Data Analyst

    Apollo Hospitals

    • Built ETL pipelines ingesting EMR, demographics, and operational data from 25+ systems into Azure SQL and Snowflake with Python and Airflow.
    • Modeled patient-journey analytics across 70+ hospitals; risk-stratification reduced average length of stay 6%.
    • Shipped Power BI dashboards used daily by 15+ administrators; data-quality tests on 20+ entities cut anomalies 40%.
    • Contributed to Apollo's Connected Care Command Centre — real-time patient-flow analytics.

-- stack

What I work with.

Modeling & data

  • dbt (Core)
  • SQL
  • Snowflake
  • Azure SQL
  • PostgreSQL
  • DuckDB
  • Star schema

Pipelines & cloud

  • Apache Airflow
  • AWS (EC2, IAM, VPC)
  • AWS CodeDeploy
  • Azure
  • Python

Delivery & BI

  • GitHub Actions
  • Jenkins
  • Maven · Nexus · Tomcat
  • Tableau
  • Power BI

Domain & full-stack

  • CMS-HCC · HRRP
  • HIPAA · value-based care
  • Node.js · Express
  • React · JavaScript
  • LLM integration

Education

M.S., Business Analytics

Grand Canyon University, Phoenix, AZ

B.Tech, Electronics & Communication Engineering

VRSEC, Vijayawada, India

Certifications

  • ✓ dbt Analytics Engineering — dbt Labs, 2024
  • ✓ AWS Certified DevOps Engineer – Professional, 2024
  • ✓ AWS Certified Solutions Architect – Associate, 2024

-- get in touch

Have a data problem worth
building for? Let's talk.

harishmaganti.dev@gmail.com Download résumé ↗