Shubham Ralli

Data analyst who cleans the chaos so clinicians and operators get calm dashboards.

Keeps ops teams unblocked · MSBA '26 · SQL | Python | Tableau

Turns claims chaos into clean metrics Ships dashboards people keep open SQL at 2am when jobs break Comfortable saying "I don't know—yet"

I chase down messy healthcare data, stress-test metrics before they ship, and build dashboards people like to use, with reliable pipelines and clear stories.

Analytics
SQL
Python
ML/AI
Tableau
Healthcare

Current Focus

Less text, more signals: what I am learning, testing, and fixing right now.

Learning Now

Causal inference Uplift modeling Reimbursement rules Propensity scores

Applying these to patient outreach and payment integrity cases.

Recent Experiment

Temporal CV Feature caps Calibration curves

Stabilized a churn model that was spiking on seasonal campaigns.

Failure & Fix

Seasonality Calendar effects Drift alerts

Missed demand swings once; now ship alerts and holiday-aware baselines with every forecast.

About

I care about healthcare because families make decisions with incomplete, messy data. A project with my parents' provider made me see how a clean dashboard can change a visit. I like problems where data friction hides real answers.

Machine Learning

Built classification and forecasting models on 1M+ row healthcare ops data; validated with stratified CV (F1/AUC > 0.82); productionized simple ensembles to keep inference under 200ms.

SQL & Data Engineering

Cut a claims pipeline from 14 min to 2 min by rewriting joins, indexing 3 tables, and batching extracts; own ELT in PostgreSQL/BigQuery feeding Tableau dashboards.

Python Analytics

Built feature pipelines with pandas/sklearn; automated weekly reporting saving 40+ hours/month; packaged shared utils for data quality checks and drift alerts.

Data Visualization

Built decision-focused dashboards (Tableau, Power BI) with row-level security and clear KPI definitions; replaced static reports with weekly self-serve views for ops and leadership.

Business Intelligence

Built stakeholder dashboards (Tableau/Looker) with row-level security; improved decision latency by shipping weekly refresh instead of monthly PDF decks.

Team & Delivery

Led 6–8 person pods; set QA checklists for data pipelines; ran post-mortems when a churn model underperformed and iterated to lift AUC by 6 points.

Technical Skills & Expertise

What I use to build reliable analytics: SQL-first pipelines, production-safe Python, and dashboards that are easy to maintain.

Analytics & Modeling

Risk scoring, cohorting, and time-series forecasting with validation that matches the business cadence.

CTEs & window functions Feature stores light Cross-validation A/B & uplift Forecasting

Data Engineering

Own ELT from source to dashboard; keep refreshes observable and recoverable.

PostgreSQL BigQuery dbt-style ELT Airflow/cron Quality checks

Visualization & Stories

Dashboards tuned for decisions: filters that map to workflows, annotations over animation.

Tableau Power BI Looker Studio Figma mocks Write-ups

Ops & Controls

Versioned notebooks, alerting on drift/outliers, and runbooks to keep stakeholders unblocked.

Git SLA monitoring Data contracts (light) Secrets hygiene Service docs
SQL Python Pandas Sklearn Tableau Power BI dbt patterns Airflow PostgreSQL BigQuery Fivetran LookML basics GitHub Actions APIs/JSON Excel Healthcare claims HL7/FHIR (reading) Causal diagrams

Core stack: SQL, Python, Tableau/Looker. Comfortable with Git-based ELT, observability, and keeping dashboards trustworthy.

Professional Experience

Highlights include healthcare ops analytics and product-facing dashboards; numbers below are contextual, not hype.

Sept 2024 - Present

Business Data Analyst

Eyes Now

Built demand-forecasting dashboards for clinic scheduling (Tableau + SQL); cut overstaffing hours by ~9% after 3 months. Partnered with ops to redesign metrics and sunset unused KPIs.

~9% Overstaffing Reduction
3 mo Time to Impact
12 KPIs Rationalized
May 2024 - Aug 2024

Data Automation Analyst Intern

Springer Capital Investments

Built purchase-propensity model (AUC 0.84 on 250K rows, 5-fold CV) and automated weekly client reports; reduced manual prep by ~8 hours/week for the team.

AUC 0.84 Purchase Model
8 hrs Weekly Ops Saved
5-fold Validation Used
Oct 2022 - Jan 2024

Academic Data Analyst

The University of Texas at Dallas

Built advising and enrollment reports; mapped student support touchpoints and cut manual list prep for advisors. Measured improved follow-ups and reduced report turnaround time.

~3 hrs Prep Saved/Week
12 Advisor Dashboards
7 Data Sources Unified

Key Projects & Achievements

Selected projects with architecture, validation, and decision impact.

AI-Powered Customer Prediction System

Pipeline: PostgreSQL → dbt-style ELT → sklearn ensemble → Tableau. AUC 0.84 on hold-out; reduced manual targeting time by replacing 4 spreadsheets with one dashboard.

Python SSAS SSIS PostgreSQL

Real-Time Analytics Dashboard

Built an operational safety dashboard on 15 years of FAA incident data with incremental refresh and row-level filters. Cut weekly prep by ~6 hours and surfaced incident patterns a week earlier for the safety lead.

Tableau Power BI SQL Server Python

Automated Reporting System

Automated daily call transcript pulls into MySQL with Selenium + Python QC checks, then pushed to a live Tableau view. Replaced copy/paste reports, saved ~25 hours/month, and reduced missed call reviews.

Python Pandas Selenium MySQL

Revenue Optimization Engine

Built a pricing optimization model that lifted revenue by $3M annually. Tuned algorithms to surface confident price points instead of chasing noisy lifts.

R Python Statistics AWS

Certifications & Credentials

Key credentials that back my core stack; depth over tool lists.

Google Data Analytics Professional

Google Career Certificates

2023

Verified
IBM

IBM Data Analyst

IBM Professional Certificate

2023

Professional

Google Cybersecurity Specialist

Google Career Certificates

2022

Expert

Career Essentials in Business Analytics

Microsoft

2022

Associate

Data Analytics Consulting Virtual Internship

KPMG

2023

Professional

Agile Requirements Foundations

Project Management Institute

2022

Advanced

Contact Information

If you're working on healthcare analytics, operational forecasting, or decision support, I'd be glad to connect.

Location

Dallas Fort Worth, TX (Remote Available)