Analytics engineering projects across healthcare, SaaS, and e-commerce. Every project is live, documented, and built end-to-end.
End-to-end revenue cycle analytics for a synthetic home infusion company.
Covers AR aging, denial root-cause analysis, and daily cash collections
across 2,600+ claims and 14 payers spanning Jan 2023 to Mar 2026.
Built a full dbt pipeline from raw Postgres tables through staging and
intermediate layers to five BI-ready mart tables. All 11 models pass
testing. Visualized in Hex with interactive KPI cards and trend charts.
MRR movement waterfall, churn cohort analysis, and LTV by acquisition channel. Built on a synthetic B2B SaaS dataset with 800 accounts and $2.4M ARR. dbt on Supabase, visualized in Hex and Looker Studio.
Upload any claims CSV and get instant AR aging analysis, payer mix breakdown, and denial rate benchmarks. Built in Streamlit, free to use, no login required. Designed for billing managers and RCM directors.
Looker Studio report connected live to Supabase mart tables. Executive-level view of AR, denials, and cash collections. Embeds publicly with no login required.
Two published Tableau Public dashboards. AR aging heatmap by payer and bucket. Denial trend analysis with overturn rate tracking by denial category and payer type.
Customer cohort retention, repeat purchase rate, and inventory turnover analytics for a synthetic Shopify-style store. dbt on Supabase, visualized in Hex.