Investigative data journalism: quantifying fixable waste in US healthcare, one issue at a time. Open-source analysis of CMS, OECD, and federal datasets. $428.6B in savings identified so far across 8 published issues.

SQL + Tableau dashboard analyzing U.S. hospital quality performance using CMS data. Includes data cleaning pipeline, KPI development, geographic benchmarking, and interactive measure filtering.

Model Context Protocol (MCP) server exposing structured tools for CMS claims/quality data workflows. Currently runs in demo mode against sample data with a real, unpopulated PostgreSQL schema. 84/84 automated tests passing.

XGBoost pipeline predicting hospital Excess Readmission Ratios on FY2024 CMS HRRP data. SHAP explainability, 5-fold CV (R² 0.938), and a live Streamlit dashboard for per-hospital risk assessment.

SQL + Power BI + Excel analytics system built on public CMS hospital data. Tracks 30-day readmission rates, HCAHPS patient satisfaction, and clinical quality indicators across 4,800+ U.S. hospitals — with benchmarking, trend analysis, and operational efficiency reporting across three dashboard pages.

SQL analytics + AI natural language query interface built on 9M+ real CMS Medicare billing records

Deterministic CMS POS/QIES ingestion pipeline with schema validation, raw loading, data‑quality profiling, structured reporting, diagnostics, logging, tests, and reproducible Makefile execution. Branch 1 delivers a clean ingestion → validation → quality → reporting foundation for large healthcare datasets.

Python analytics project using CMS hospital quality data to clean, summarize, and visualize hospital ratings, reporting patterns, and facility characteristics.

Anomaly detection and overcharge prediction in Medicare Part-B claims using unsupervised outlier detection and supervised ML (XGBoost, Random Forest, logit regression). Analyzes 800K+ Illinois claims from CMS 2015 data.

Exploratory analysis and predictive modeling of patient satisfaction across 4,789 U.S. hospitals using CMS HCAHPS public data — Python, Scikit-learn, Matplotlib

SQL analytics case study on 169,635 real CMS Medicare records — 20 queries across window functions, CTEs, and multi-table JOINs analyzing cost and readmission data across 3,000+ US hospitals.

Ranks 1.67M Medicare providers by how unusually they bill for their own specialty, with a plain-English reason behind every flag.

Pediatric Growth & Development Database - An R Markdown Project

SQL + Python analysis of 64K CMS hospital record. Identifies readmission risk drivers across conditions, states, and hospitals, with an Excel dashboard and executive summary.

Pharma commercial analytics on CMS Open Payments + Medicare Part D. dbt + Postgres + Streamlit + Groq LLM. Live demo linked.

How to request a computing account for a new student.

Healthcare KPI reporting project using Databricks SQL, notebook workflows, and Power BI reporting dashboards.

Predictive modeling + dashboard on federal CMS data - Random Forest models hospital excess readmissions.

Pending Medicare provider enrollment data: twice-weekly behavioral-health applicants enriched from NPPES for credentialing, medical billing, EHR, and provider-network research. Free sample; $12 full edition.

Medicaid drug spending analysis (2019–2023) using MySQL, Power BI, and Python — built as a healthcare data analyst portfolio project.