Skip to content
View DhruvShah-Dev's full-sized avatar
🎯
Focusing
🎯
Focusing

Highlights

  • Pro

Block or report DhruvShah-Dev

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.

Content in all repositories owned by your account will be closed.
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
DhruvShah-Dev/README.md

Dhruv Shah · Data Analyst

I clean and connect messy data, test what the numbers mean, and build reporting that helps people make decisions.

SQL · Python · Excel · Power BI · PostgreSQL · Streamlit

Data Analyst resume  ·  Business Intelligence resume  ·  LinkedIn  ·  Email

What I work on

  • Analysis: SQL queries, Python and Pandas, data cleaning, validation, statistical analysis, and investigation of trends and outliers.
  • Reporting: Excel KPI reports, executive workbooks, dashboards, metric definitions, and clear explanations of findings.
  • Data foundations: ETL, reconciliation, dimensional modeling, and reproducible analytical datasets.

My experience spans operational reporting at R&P Consultants, WHO data analysis at Global Health Impact, and research data workflows at Binghamton University. The projects below show the methods and deliverables in more detail.

Selected data analysis projects

01 · CMS Hospital Readmissions

Question: Where are the strongest opportunities to reduce 30-day hospital readmissions?

Analyzed 11,720 hospital-condition records from CMS data. Built a cleaned dataset, reusable SQL views, statistical comparisons, and an opportunity score that combines excess readmission performance with patient volume. Deliverables include a Streamlit dashboard and an Excel executive workbook.

Methods: SQL · Python · Pandas · SciPy · Excel · Streamlit

Explore the analysis and dashboard code

Bar chart of positive readmission opportunity score by condition, led by pneumonia and heart failure

02 · U.S. Banking Risk

Question: How do credit, funding, capital, profitability, and interest-rate trends shape bank risk?

Built a reproducible FDIC and FRED analysis pipeline and a peer-relative risk framework. Used SQL and Python to compare institutions, identify watchlist candidates, and explain risk and performance trends. Deliverables include a Streamlit dashboard and an Excel analysis workbook. The score is a research triage measure, not a regulatory rating.

Methods: SQL · Python · DuckDB · FDIC · FRED · Excel · Streamlit

Explore the risk framework and reports

Scatterplot of bank risk score against performance score with four peer comparison groups

03 · F1 InsightX

Question: How can race, lap, stint, and telemetry data become useful race-week analysis?

An interactive Formula 1 product with race reports, driver comparisons, strategy views, and championship analysis. Its data pipeline validates source inputs and builds product views from race results, session context, timing, and telemetry.

Methods: Python data pipeline · TypeScript · React · Supabase · Data visualization

Open the live app · Explore the source

F1 InsightX Azerbaijan Grand Prix report with race result and circuit visualization

More analysis projects

  • Municipal payroll comparison — compares 2024–2025 overtime and reported pay in NYC, Chicago, and San Francisco using official city data, with source-specific comparability notes.
  • Measles immunization atlas — explores WHO immunization and measles data through interactive maps, country screening, and data-quality checks.
  • Historical trading strategy research — tests stock and ETF rules on a shared holdout window and reports model calibration, costs, and research limits.

Open-source data tooling

  • Tabularis — SQL workspace and database interface contributions.
  • DuckDB Web — documentation fixes for SQL behavior and configuration.
  • BeliefState — a DuckDB store backend for durable local state.

Connect

I am open to Data Analyst, Reporting Analyst, and Business Intelligence Analyst roles. I am based in Binghamton, NY and open to relocating.

Download my Data Analyst resume · BI resume · LinkedIn · Email

Pinned Loading

  1. f1-insightx f1-insightx Public

    Formula 1 race analytics app with predictions, telemetry, driver comparisons, race reports, championship insights, and fan picks.

    TypeScript 1

  2. cms-hospital-readmissions-analysis cms-hospital-readmissions-analysis Public

    Healthcare analytics case study using CMS HRRP data, SQL, statistical analysis, and a professional Streamlit dashboard to identify 30-day readmission reduction opportunities.

    Python

  3. us-banking-risk-analysis us-banking-risk-analysis Public

    Streamlit dashboard and analytics pipeline for U.S. bank risk, profitability, funding pressure, and macro-rate analysis using FDIC and FRED data.

    Python