JEET SHAH / ANALYTICS

Tempe, Arizona · open to relocation

Jeet Shah

I build the pipeline, the model, and the dashboard that sits on top of them — and I bring the baseline that proves the model was worth building.

  • Data Analyst
  • Business Analyst
  • BI Analyst
  • Data Scientist
Jeet Shah

Data Analyst
Community Dreams Foundation

4 yrsAnalytics experience
1M+SAP records in production ETL
300+Students supported at ASU
MS ITArizona State University
Summary

An analyst who ships the whole chain

Four years turning messy source systems into reporting people actually run their week on — SAP extracts, healthcare referral data, student cohorts, warehouse telemetry.

Most of my work starts where the data is still wrong. I write the SQL and the Python that cleans and validates it, model it into something a BI tool can query without a fight, and then build the Power BI or Tableau layer stakeholders open every morning. At Vaibhav Laxmi that meant an ETL pipeline over a million SAP records with a data-quality framework in front of it; at Community Dreams Foundation it means Microsoft Fabric and OneLake feeding referral and rehabilitation dashboards for a care-coordination platform.

I care about the part most dashboards skip: whether the number is defensible. Every model I ship gets a baseline above it in the table — if a forecast can't beat "same weekday last week", it hasn't earned its place in a planning meeting. That habit is the through-line between the analyst work and the machine-learning work, and it's what the two projects below are built to demonstrate.

What I bring

Four roles, one skill set

These titles overlap more than job postings admit. Here is the concrete evidence behind each one.

Data Analyst

Writing and optimizing the queries, cleaning what comes back, and answering the ad hoc question before the dashboard exists. Built validation and anomaly-detection frameworks that raised data reliability to 93% and cut 8+ hours of weekly manual QA.

  • SQL
  • Python/Pandas
  • Excel
  • EDA
  • Data validation
  • Ad hoc analysis

Business Analyst

Sitting with stakeholders to turn "we need better visibility" into a defined metric, an owner and a refresh cadence. Gathered requirements across operations, finance and faculty teams and translated them into reporting specs and process changes.

  • Requirements gathering
  • Stakeholder management
  • Process analysis
  • Gap & root-cause analysis
  • KPI definition

BI Analyst

Dimensional models, DAX measures that survive contact with a filter, and dashboards that load fast enough to be used. Power BI and Tableau in production across healthcare, manufacturing and education contexts.

  • Power BI
  • DAX
  • Power Query
  • Tableau
  • Star schema
  • Reporting automation

Data Scientist

Forecasting, clustering, recommendation and NLP — always benchmarked against the naive rule the business already uses, with the split designed so the model can't see the future it's predicting.

  • Scikit-learn
  • Forecasting
  • Clustering
  • Recommenders
  • NLP
  • Model evaluation
Languages
Python, SQL, MySQL, PostgreSQL, C++, JavaScript, R, Shell scripting, HTML
BI & Visualization
Power BI, Tableau, Looker, Excel, DAX, Power Query, dashboard development, KPI reporting, executive reporting
Data & warehousing
SQL Server, SAP, dimensional modeling, star and snowflake schemas, data migration, data quality and validation
Data engineering
Microsoft Fabric, OneLake, ETL, Apache Spark, Hadoop, Airflow, Kafka, dbt
Analytics & ML
Statistical analysis, regression, classification, clustering, ARIMA, NLP, feature engineering, predictive and supply-chain analytics, forecasting
Cloud & tools
AWS (S3, Redshift, Lambda), Azure, GCP (BigQuery, Cloud Run), Git, Docker, Azure Data Studio, Jupyter, VS Code, HubSpot, REST APIs
Experience

Where the work happened

Data Analyst · Community Dreams Foundation

Current

Feb 2026 – Present · Tempe, AZ (remote) · Power BI, Microsoft Fabric, OneLake, MySQL, Azure, Python

  • Design Power BI dashboards and healthcare analytics reports that track patient referrals, rehabilitation performance and operational KPIs, so stakeholders can act on the data rather than request it.
  • Write and tune the MySQL behind them in Azure Data Studio — extracting, cleaning, validating and transforming healthcare data for scheduled reporting and ad hoc analysis.
  • Automate the ETL through Microsoft Fabric, OneLake and Python, integrating sources that previously arrived as separate manual extracts.

Grader · Arizona State University (Learning Enterprise)

SUN Award

Aug 2024 – Dec 2025 · Tempe, AZ · SQL, Tableau, HubSpot, cloud & big-data curricula

  • Evaluated coursework and supported 300+ students across Cloud Computing, Google IT and Advanced Big Data Analytics, resolving queries through HubSpot and running teaching sessions.
  • Worked with faculty on instructional content covering SQL, cloud analytics, data visualization, statistical modeling and BI concepts — and reviewed analytical assignments for accuracy and consistency.
  • Received ASU's SUN Award for the quality and reliability of the work, and supported fellow graders through the heaviest marking periods.

Data Analyst · Vaibhav Laxmi Spinning Mills Pvt. Ltd.

Sep 2022 – Dec 2023 · Ahmedabad, India · Python, SQL, SAP, Power BI, ETL

  • Built and optimized ETL pipelines in Python and SQL over 1M+ SAP records supporting supply-chain analytics and enterprise reporting.
  • Implemented data validation, anomaly detection and data-quality frameworks that lifted reliability to 93% and removed 8+ hours of manual QA per week.
  • Delivered interactive Power BI dashboards and KPI scorecards for financial analytics, inventory planning and executive decision-making, cutting reporting turnaround time.
  • Partnered with cross-functional stakeholders to gather requirements and integrate SAP, databases and BI platforms into one reporting workflow.

Project Intern · Brainy Beam Technology Pvt. Ltd.

Jan 2022 – Aug 2022 · Ahmedabad, India · Python, Google TTS APIs, text preprocessing

  • Engineered preprocessing pipelines for 10K+ unstructured text records, improving data quality, feature extraction and downstream model accuracy by 25%.
  • Integrated Google Text-to-Speech APIs and automated processing of 1.2K+ documents; built ingestion pipelines for CSV, SQL, TXT and PDF sources.
Projects

Two builds you can run yourself

Both are complete repositories — clone, run one command, and every figure in the README regenerates. The dashboards below are the live output.

Warehouse Operations Monitoring System

Data engineering · Forecasting · NLP

Python · SQL · Star Schema · Scikit-learn · Tableau-Ready Extracts

A four-node fulfilment network end to end: a relational WMS extract and a document store of device telemetry and free-text shift notes, consolidated into one star schema behind an 11-rule data-quality gate. On top sit a workload forecast, an NLP layer over supervisor notes, and a single-file dashboard.

19.6%Lower forecast MAE than the planner's rule of thumb
5,964Rows quarantined by the DQ gate, none dropped silently
98.4%Accuracy routing shift notes to the right issue type

The result worth arguing about: unsupervised clustering of the notes was weak (ARI 0.15) while a supervised classifier hit 98.4%. The repo says so plainly and recommends bootstrapping a taxonomy with clustering, then shipping the classifier — reporting the honest number was more useful than burying it.

Book Recommendation & Reader Segmentation

Machine learning · Segmentation

Python · NumPy/SciPy · Scikit-learn · Collaborative Filtering · K-Means

Nine recommenders benchmarked on one split under one protocol — popularity and bias baselines, item-item and user-user neighbourhood CF, truncated SVD, regularized matrix factorization, a content model and a tuned hybrid — all implemented on NumPy and SciPy rather than called from a library. Plus five behavioral reader segments and a model predicting next-quarter reading volume.

0.613Best RMSE, 22% under the bias baseline
26.3%Hit rate at 10, against 10% for random
46.9%Lower engagement-model MAE than carry-forward

Two findings the README leads with rather than hides: truncated SVD — the version most people reach for first — loses to a neighbourhood model, while properly regularized matrix factorization wins outright; and the tuned hybrid improves NDCG by 0.0007, which is a component that did not earn its place.

Dashboards

Reporting built for people who don't like reports

Three production dashboards from healthcare, manufacturing finance and education. These run on internal data, so what follows is what each one measures and why — not a screenshot.

Patient Referral & Rehabilitation Performance

Healthcare

Community Dreams Foundation · Power BI, Microsoft Fabric, OneLake, MySQL, Azure Data Studio, Python

The reporting layer for a care-coordination platform. Referrals arrive from multiple partner systems and have to be tracked from intake through placement and rehabilitation outcome — a funnel where a stall at any stage is a patient waiting. The dashboard replaced a set of manually assembled extracts with a Fabric-fed model that refreshes on schedule.

  • Referral funnelVolume and status by stage, with ageing on anything stuck — the view that turns a backlog into a work queue.
  • Rehab performanceOutcome and progress measures by program and provider, so variation between sites is visible rather than anecdotal.
  • Operational KPIsThe scorecard stakeholders open first: throughput, turnaround and the handful of measures leadership actually steers on.
  • Data qualityValidation results surfaced in the report itself, so a number nobody should trust is flagged rather than quietly wrong.

Financial & Supply-Chain Performance Scorecard

Finance · Manufacturing

Vaibhav Laxmi Spinning Mills · Power BI, SAP, Python, SQL, ETL

Built on an ETL pipeline over 1M+ SAP records, with the data-quality framework that raised reliability to 93% sitting between the extract and the model. The dashboard served two audiences at once — an executive view for the monthly review, and a working view the inventory and finance teams used daily — which cut reporting turnaround sharply and removed 8+ hours of manual QA a week.

  • Financial KPIsCost, margin and spend trends against plan, with drill-through from the summary tile to the SAP line items behind it.
  • Inventory positionStock cover and movement by item class, framed for the replenishment decision rather than as a static stock count.
  • Executive scorecardOne page, period-over-period, with variance flagged so the monthly meeting starts from the exceptions.
  • Data reliabilityValidation and anomaly checks reported alongside the numbers — the reason anyone believed the 93%.

Course & Cohort Performance Tracker

Education

ASU Learning Enterprise · SQL, Tableau, Excel, HubSpot

Supporting 300+ students across three technical courses meant the grading queue and the support queue both needed to be visible. This tracker pulled assignment outcomes and HubSpot query volume into one place so faculty could see where a cohort was struggling while there was still term left to do something about it.

  • Score distributionMarks by assignment and cohort, with the spread shown rather than just the average — a mean of 78 hides two very different classes.
  • At-risk cohortsStudents trending below threshold across consecutive assignments, surfaced early rather than at final grades.
  • Grading throughputTurnaround time on the marking queue, so backlogs were managed instead of discovered.
  • Support demandHubSpot query volume by topic, which is the cleanest signal of which course material needs rewriting.

These dashboards contain proprietary and, in the healthcare case, protected data. They are described here rather than shown. I'm happy to walk through the structure, the modeling decisions and the DAX in a conversation.

Education

Education

Arizona State University

Master of Science, Information Technology — GPA 3.87

Coursework that maps directly onto the work: Analyzing Big Data · Advanced Big Data Analytics & AI · Advanced Database Management Systems · Data Visualization & Reporting for IT · Natural Language Processing for IT · Data in the Cloud · Advanced Information Systems Security

Jan 2024 – Dec 2025 · Tempe, AZ

Indus University

Bachelor of Technology, Computer Science & Engineering

May 2018 – Jul 2022 · Ahmedabad, India

Credentials

Documents and references

Everything a hiring process asks for, one click away. Each button writes the email for you — add your name, hit send, and it comes back the same day.

Résumé

One page: experience, projects and the full technical stack. The same content as this page, formatted for an applicant tracking system.

Sent the same day
Letter of recommendation

From Joey Choi, CIS Online Course Manager at ASU Learning Enterprise, who supervised my grading work across the cloud and big-data courses.

Sent the same day
Academic transcript

MS in Information Technology, Arizona State University — 30 credits, cumulative GPA 3.87.

Sent the same day
Professional references

Managers and faculty who supervised my work at Community Dreams Foundation, Vaibhav Laxmi Spinning Mills and ASU Learning Enterprise. Names and contact details go out on request, and I let each referee know to expect you.

Sent the same day

Requests go to jshah96@asu.edu with the subject line already filled in, so I know exactly what you need. Documents are sent directly rather than posted publicly — transcripts and references carry personal details that belong in an inbox, not on a web page.

Contact

Let's talk

Open to Data Analyst, Business Analyst, BI Analyst and Data Scientist roles — in Tempe, remote, or wherever the team is. Fastest way to reach me is email.