An R package, plumber API, database, and Shiny App for Actuarial Loss Development and Reserving Workflows.

Python toolkit for Medicaid claims data analysis — preprocessing, cleaning, risk adjustment (Elixhauser, CDPS-Rx), quality measures (PQI, BETOS, low-value care), and patient-level analytic file construction for MAX and TAF CMS data. Built on Dask for scalable processing of large-scale healthcare claims datasets.

Detection of abnormal delivery patterns and potential obstetric claim anomalies using JKN administrative claims data.

End-to-end SQL analytics sample for healthcare claims and quality monitoring — data quality, KPI rollups, readmission analysis, provider benchmarking, and a weighted quality-review priority score. SQLite-compatible, self-contained.

Using Power BI to analyze outpatient claims data to find out the high utilizers and the economic impact

Healthcare machine learning research portfolio focused on predictive modeling, Medicare claims analytics, and healthcare cost prediction using CMS data.

HL7 FHIR R4 → OMOP CDM → Snowflake → dbt → Dagster. RCM: classifies 257K denied claims by root cause — systematic vs. documentation failures. RWE: T2D+CKD metformin utilization cohort. 12 dbt models, 83 tests, CI green.

Impact Analysis of the Policy for Access of Administrative Data in France : A Beforefter Study. Vincent LOOTEN and Marie SIMON Digital Personalized Health and Medicine L.B. Pape-Haugaard et al. (Eds.) © 2020 European Federation for Medical Informatics (EFMI) and IOS Press. This article is published online with Open Access by IOS Press and distri…

Python toolkit for cleaning and feature engineering Japanese health insurance claims data.

SQL-first healthcare claims analytics project that maps ICD/CPT/NPI to provider cost variation and generates client-ready utilization insights.

CMS Price Transparency Rule compliance delivered via HealthSparq integration. Personalized cost estimates powered by real-time claims data across web and mobile.

Reconciling fragmented EHR, Claims, Registry, and Clinical Trial data in Excel and SQL - a healthcare analytics portfolio project

R toolkit for HCUP National Inpatient Sample (NIS) research: era-aware data loading, ICD/CCSR/PQI condition flagging, Elixhauser comorbidities, survey-correct estimation, and DUA-compliant outputs

SQL-based analytic warehouse that converts administrative health insurance claims into patient episodes, referral patterns, and utilization indicators.

A reference Python notebook demonstrating an orchestration pattern for running multiple SQL queries against multiple Oracle databases, combining results in different ways per query, and distributing the outputs by email — all wrapped in resilient error handling so a single database outage doesn't break the run.

Excel healthcare spend & utilization dashboard (Power Query + Power Pivot) using synthetic claims data (2019–2024).

SQL analysis of synthetic healthcare claims data (Synthea): payer mix, cost & utilization, high-cost cohorts, and claim-line charges.

Claims experience record for a Group Health Insurance policy for 3 underwriting years was used to extract the amounts related to each claim and summarized with regards to the Inception Date of the policy.