Skip to content
View Denis0242's full-sized avatar

Block or report Denis0242

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Denis0242/README.md

Hi, Denis 👋

Data Analyst | Healthcare Analytics & Decision Support

• SQL • Tableau • KPI Reporting • Executive Dashboards

📍 Oakland, CA

📧 vantjohnn@gmail.com

🔗 LinkedIn
📊 Tableau Public
🐙 GitHub


About Me

Data Analyst with 4+ years of experience across healthcare, insurance, and operational analytics environments, specializing in SQL analysis, KPI reporting, dashboard development, healthcare operations analytics, and decision support reporting.

Experienced in transforming patient, operational, and business data into actionable insights through Tableau, SQL, Power BI, Python, and Alteryx. Skilled in executive reporting, performance monitoring, operational analytics, healthcare KPI measurement, and business intelligence solutions that support data-driven decision-making.

Experience also includes customer analytics, retention analysis, customer journey analytics, and performance reporting across healthcare, insurance, and operational environments.


📌 Impact Snapshot

| Portfolio Highlights | |

| 📊 Analytics Projects | 6 End-to-End Portfolio Projects | | 🚀 Streamlit Apps | 6 Interactive Applications | | 🏥 Analytics Domains | Healthcare, Insurance & Customer Analytics | | 📈 Reporting Focus | Executive KPI Dashboards & Decision Support | | 🛠️ Core Tools | SQL • Tableau • Python • Power BI • Excel |


🏥 Healthcare & Decision Support Analytics

My primary focus is building reporting and analytics solutions that help organizations:

  • Monitor operational performance
  • Track KPI trends
  • Support executive decision-making
  • Improve patient and customer outcomes
  • Identify operational bottlenecks
  • Optimize reporting processes
  • Deliver business intelligence insights

🎯 Decision Support Use Cases

This portfolio demonstrates how analytics can support:

  • Executive KPI Monitoring
  • Hospital Operations Management
  • Capacity Planning
  • Performance Reporting
  • Operational Risk Identification
  • Resource Allocation Decisions
  • Patient Outcome Monitoring
  • Business Intelligence Reporting

🚀 Featured Analytics Projects

🏥 Healthcare Operations Analytics

Executive healthcare analytics dashboard designed to monitor patient flow, capacity utilization, readmissions, treatment outcomes, and operational bottlenecks across hospital departments.

Key Focus

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

Tools

Tableau SQL Healthcare Analytics Business Intelligence

🔗 Repo: Healthcare Operations Analytics

Live App: Streamlit App


🏥 Patient CareFlow Analytics

Healthcare journey analytics platform tracking patient progression, engagement, operational KPIs, and treatment outcomes.

Key Focus

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

Tools

Tableau SQL Python

🔗 Repo: Patient CareFlow Analytics

Live App: Streamlit App


💙 Patient Engagement Dashboard

Healthcare engagement analytics dashboard evaluating patient activity, operational efficiency, and treatment engagement trends.

Key Focus

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

Tools

Tableau SQL Power BI

🔗 Repo: Patient Engagement Dashboard

Live App: Streamlit App


📋 Claims Cost Risk Analytics

Insurance analytics dashboard analyzing claims performance, risk exposure, cost drivers, and operational reporting metrics.

Key Focus

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

Tools

Tableau SQL Python

🔗Repo: Claims Cost Risk Analytics

Live App: Streamlit App


📈 Customer Journey Analytics

Analytics dashboard analyzing user behavior, customer journeys, conversion trends, and engagement patterns.

Key Focus

  • Customer Journey Analytics
  • Funnel Analysis
  • User Behavior Analytics
  • Conversion Monitoring
  • Journey Mapping

Tools

SQL Tableau Python

🔗Repo: Customer Journey Analytics

Live App: Streamlit App


🔄 Churn & Retention Analytics

Retention analytics platform identifying churn drivers, engagement risks, and customer retention opportunities.

Key Focus

  • Churn Analysis
  • Retention Analysis
  • Cohort Analytics
  • Customer Segmentation
  • Performance Monitoring

Tools

Python SQL Tableau

🔗Repo:Churn & Retention Analytics

Live App:Streamlit App


🛠️ Technical Skills

Analytics & BI

SQL Tableau Power BI Excel Power Query

Programming & Data

Python Pandas NumPy Matplotlib

Data Platforms & Workflow

AWS Snowflake Redshift Alteryx

Apps & Deployment

Streamlit GitHub

🗄️ Data Modeling

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

📈 Analytics & Statistical Methods

SQL

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

Analytics

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

Statistical Methods

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

🏆 Certifications

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

🎯 Career Focus

Focused on delivering healthcare analytics, operational reporting, KPI monitoring, and decision-support solutions that enable data-driven decision-making.

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


Core Areas of Interest

  • 🏥 Healthcare Data Analytics
  • 📊 Decision Support Analytics
  • 📈 Business Intelligence
  • 📋 Reporting & KPI Monitoring
  • 🧾 SQL Analytics
  • 📉 Operational Analytics
  • 📊 Dashboard Development
  • 🎯 Executive Reporting

This portfolio demonstrates how healthcare, insurance, customer, and operational data can be transformed into actionable insights through reporting, dashboard development, KPI monitoring, and decision support analytics.

Pinned Loading

  1. Hospital-Operations-Analytics Hospital-Operations-Analytics Public

    Healthcare Operations Analytics Dashboard built with Tableau to monitor patient flow, capacity utilization, readmissions, LOS, treatment outcomes, and operational bottlenecks for executive decision…

    Python

  2. Patient-Careflow Patient-Careflow Public

    Healthcare product analytics dashboard for patient journey, retention, operational KPIs, and careflow optimization using Tableau, SQL, and Python.

    Python

  3. Patient-Engagement Patient-Engagement Public

    Healthcare product analytics system analyzing patient engagement, retention, care pathways, and behavioral trends using SQL, Python, Tableau, and predictive analytics to support data-driven healthc…

    Python

  4. Claims-Cost-Analysis Claims-Cost-Analysis Public

    Insurance claims analytics platform analyzing claim costs, risk patterns, fraud indicators, and operational KPIs using SQL, Python, Tableau, and Streamlit to support data-driven insurance decisions.

    Python

  5. Customer-User-Journey Customer-User-Journey Public

    End-to-end product analytics project analyzing customer journeys, conversion funnels, retention, and engagement metrics (DAU/MAU) to drive product optimization and data-driven decisions.

    Python

  6. Churn-Retention Churn-Retention Public

    Customer churn and retention analytics project focused on user behavior, retention trends, cohort analysis, KPI tracking, and business decision-making using SQL, Tableau, Python, and Streamlit.

    Python