Healthcare Analytics • BI & Reporting

Building SQL-driven decision support solutions that transform data into executive-ready insights.

📍 Oakland, CA

📧 vantjohnn@gmail.com

🔗 LinkedIn
📊 Tableau Public
🐙 GitHub

Decision Support Analyst with 5 years of experience delivering healthcare, insurance, and operational analytics that enable data-driven business and clinical decision-making. Experienced in transforming complex operational, patient, claims, and business data into decision-ready executive insights using SQL, Tableau, Power BI, Python, and Power Query. Specializes in SQL-based decision support, KPI framework development, executive reporting, healthcare operational analytics, business intelligence, and performance measurement that help organizations improve operational efficiency, patient outcomes, and strategic decision-making.

I design analytics solutions that help organizations answer questions such as:

• Where are operational bottlenecks?
• Which KPIs require executive attention?
• How can healthcare resources be allocated more effectively?
• What trends should leaders act on?
• Which operational risks require immediate intervention?
• How can reporting become more reliable and actionable?

My work combines SQL, business intelligence, statistics, and dashboard development to produce decision-ready insights for healthcare and business leaders.

Every project in this portfolio follows the same evidence-driven framework to transform raw data into business decisions.

Business Problem
        ↓
SQL Analysis & Data Preparation
        ↓
KPI Development & Statistical Analysis
        ↓
Interactive Dashboard & Reporting
        ↓
Executive Insights
        ↓
Decision Support
        ↓
Business Impact

This portfolio demonstrates how analytics supports better operational and strategic decisions by helping organizations:

• Monitor hospital performance
• Improve patient flow
• Reduce operational bottlenecks
• Optimize healthcare resources
• Understand claims cost drivers
• Improve patient engagement
• Analyze clinical care pathways
• Validate business decisions through statistical experimentation

The following projects demonstrate how SQL, business intelligence, statistical analysis, and interactive dashboards are applied to solve real healthcare, insurance, and customer analytics problems through decision support.

Each project builds on the previous one to demonstrate increasingly advanced decision support capabilities.

Hospital Operations Analytics
        ↓
Patient CareFlow Analytics
        ↓
Claims Cost Risk Analytics
        ↓
Patient Engagement Dashboard
        ↓
CarePath Analytics
        ↓
A/B Testing & Experimentation Framework

Together these projects showcase SQL analytics, KPI development, statistical analysis, executive reporting, healthcare operations, and evidence-based decision support.

Executive decision support solution designed to help healthcare leaders monitor patient flow, capacity utilization, readmissions, treatment outcomes, and operational performance through KPI reporting, interactive dashboards, and data-driven insights.

How can healthcare leaders monitor operational performance and identify improvement opportunities?

• Hospital Operations Analytics
• Capacity Planning
• Readmission Monitoring
• Length of Stay (LOS) Analysis
• Decision Support Reporting
• Executive KPI Monitoring

Tableau SQL Healthcare Analytics Business Intelligence

🔗 Repo: Healthcare Operations Analytics

Live App: Streamlit App

Decision support solution that analyzes patient progression, engagement, operational KPIs, and treatment outcomes to help healthcare leaders improve care delivery, monitor performance, and support operational decision-making.

How can healthcare organizations improve patient flow, reduce delays, and optimize treatment progression?

• Patient Flow Analytics
• Treatment Progression
• Healthcare KPI Reporting
• Operational Analytics
• Dashboard Storytelling

Tableau SQL Python

🔗 Repo: Patient CareFlow Analytics

Live App: Streamlit App

Decision support solution that analyzes insurance claims performance, risk exposure, cost drivers, and operational KPIs to support business planning, risk monitoring, and executive decision-making.

How can insurers identify cost drivers and operational risks using analytics?

• Claims Analytics
• Cost Analysis
• Risk Reporting
• KPI Monitoring
• Executive Reporting

Tableau SQL Python

🔗Repo: Claims Cost Risk Analytics

Live App: Streamlit App

Decision support dashboard designed to evaluate patient engagement, operational efficiency, and treatment trends, enabling healthcare leaders to monitor KPIs and improve patient outcomes.

How can healthcare leaders monitor operational performance and identify improvement opportunities?

• Patient Engagement Analytics
• Cohort Analysis
• Healthcare Reporting
• Performance Monitoring
• Operational KPIs

Tableau SQL Power BI

🔗 Repo: Patient Engagement Dashboard

Live App: Streamlit App

Decision support solution that analyzes clinical care pathways, treatment progression, patient outcomes, and operational bottlenecks to help healthcare organizations optimize care delivery, improve clinical performance, and support evidence-based decision-making.

How can healthcare organizations optimize clinical care pathways, identify treatment bottlenecks, and improve patient outcomes through data-driven analytics?

• Clinical Care Pathway Analytics
• Treatment Progression Analysis
• Patient Outcome Monitoring
• Care Path Optimization
• Operational Bottleneck Analysis

SQL Tableau Python

🔗 Repo: CarePath Analytics

Live App: Streamlit App

--

Decision support solution that leverages A/B testing, statistical experimentation, and hypothesis testing to evaluate business initiatives, measure the impact of product and operational changes, and support confident, evidence-based decision-making.

How can organizations use controlled experiments and statistical analysis to validate business decisions, measure change impact, and optimize performance?

• A/B Testing
• Experimental Design
• Hypothesis Testing
• Statistical Analysis
• Performance Measurement
• Decision Support

Python SQL Statistics

🔗 Repo: A/B Testing & Experimentation Framework

Live App: Render App

• 🏥 Hospital Operations Analytics
• 🚑 Patient Flow & Care Delivery
• 💰 Insurance Claims Analytics
• ❤️ Patient Engagement Analytics
• 🩺 Clinical CarePath Analytics
• 🧪 A/B Testing & Experimentation
• 📈 Executive KPI Reporting
• 📊 Statistical Decision Support

• Data Modeling
• Relational Data Structures
• Fact & Dimension Tables
• Power Query Data Transformation
• Data Cleaning & Validation

• CTEs
• Window Functions
• Joins
• Aggregations
• CASE WHEN Logic
• Date Functions
• KPI Engineering

• KPI Framework Development
• Performance Measurement
• Root Cause Analysis
• Trend Analysis
• Operational Analytics
• Executive Reporting

• KPI Analysis
• Cohort Analysis
• Retention Analysis
• Customer Segmentation
• Funnel Analysis
• Trend Analysis
• Operational Analytics
• Healthcare KPI Analysis

• Descriptive Statistics
• Inferential Statistics
• Hypothesis Testing
• Confidence Intervals
• A/B Testing
• Statistical Comparison

• Tableau Desktop Specialist
• Generative AI
• Data Science — Digicrome

I specialize in designing SQL-driven decision support solutions that enable healthcare organizations to improve operational performance, optimize patient care, monitor executive KPIs, and support evidence-based decision-making.

My portfolio combines healthcare operations analytics, insurance analytics, business intelligence, statistical analysis, dashboard development, and experimentation to demonstrate how data can be transformed into actionable insights for executives and operational leaders.

Additional interests include customer analytics, retention analysis, and user journey analytics.

• 🏥 Decision Support Analytics
• 📊 Healthcare Analytics
• 📈 Business Intelligence
• 📋 Executive KPI Reporting
• 📉 Operational Analytics
• 🩺 Clinical Analytics
• 🧪 Statistical Experimentation
• 🧾 SQL Analytics
• 📊 Dashboard Development

This portfolio showcases how SQL, business intelligence, healthcare analytics, statistical methods, and executive reporting can be combined to transform complex operational, clinical, and business data into decision-ready insights.

I'm passionate about helping healthcare organizations make faster, smarter, and more evidence-based decisions through analytics, KPI reporting, and decision support.

If you're interested in healthcare analytics, decision support, or business intelligence, I'd be happy to connect.