Heer Patel

Heer Patel

click anywhere to enter  →

Open to data analyst, business analyst & FP&A roles - starting immediately

Hi, I'm Heer.

I started doing "data work" before I knew it had a name - building Excel models for my family's business in India when I was 16, watching numbers turn into decisions in real time.

Six years later, I just graduated from UIC (Magna Cum Laude, IDS + Finance), and the through line is still the same: turn messy business data into decisions people can act on. The tools just keep getting better. These days I build dashboards, forecasting models, A/B testing frameworks, and AI agents.

Most at home at the intersection of finance, analytics, and AI. Always looking for the next problem to solve with a better tool.

Off-screen: I love to cook, I am a Bollywood movie nerd, and a constant explorer of new restaurants.

F-1 STEM OPT authorized
$2.7M
Projected ROI
13.5%
MAPE achieved
+63.4%
A/B test CVR lift
Hours→Sec
AI agent time-to-insight
PythonSQLClaude APIPower BITableauStreamlitBigQueryXGBoostScikit-learnPandasLLM WorkflowsETL PipelinesA/B TestingForecastingData ModelingFinancial Modeling PythonSQLClaude APIPower BITableauStreamlitBigQueryXGBoostScikit-learnPandasLLM WorkflowsETL PipelinesA/B TestingForecastingData ModelingFinancial Modeling
01 /

Where I've made an impact

Ramani Global (Family Business)

Data Analyst

2020 – Present · Gujarat, India

-6 hrs/week reporting -20% stockouts 30+ SKUs tracked -30% month-end close
  • Reduced manual reporting time by 6 hours per week by building SQL queries and Excel data models that automated cleaning and consolidation of sales, inventory, and procurement records across 5+ product lines.
  • Cut stockout incidents by 20% over two quarters by developing time-series forecasting models in Python (pandas, scikit-learn) on 5 years of historical sales data to support inventory reorder planning.
  • Enabled faster weekly pricing decisions across 30+ SKUs by designing interactive Power BI dashboards tracking pricing trends, margin performance, and competitor benchmarks.
  • Reduced month-end close effort by 30% by automating financial reporting and ledger reconciliation in Python, performing variance analysis to surface cost discrepancies.
PythonSQLPower BIForecastingFinancial Analysis

UIC College of Business Administration

Teaching Assistant

2023 – 2026 · Chicago, IL

200+ students+15% exam scores500+ assignments/sem
  • Improved average exam performance by 15% across 200+ undergraduates by leading weekly review sessions in Business Statistics, MIS, and Supply Chain Analytics, translating hypothesis testing, regression, and data interpretation concepts into actionable insights.
  • Evaluated 500+ student assignments per semester using Excel, SQL, and statistical analysis while collaborating with faculty to refine course materials and rubrics.
StatisticsSQLExcelCommunication

UIC Ed Tech Lab

Technical Support Analyst

2023 – 2026 · Chicago, IL

150 tickets/month-40% downtime-30% resolution time
  • Reduced average ticket resolution time by 30% and system downtime by 40% by analyzing 150 monthly incidents across 200+ endpoints, documenting recurring failure patterns to inform preventative maintenance.
  • Produced weekly incident reports tracking 5+ performance metrics by maintaining structured ticket data and applying root-cause analysis to identify trends across hardware, software, and network issues.
ReportingRoot-Cause AnalysisDocumentation
02 /

Things I've built

02

Finance · Valuation

Quarry — Chipotle Mexican Grill Financial Model

$19.40

Implied Price

-41%

vs. Market

3-statement financial model & DCF valuation for Chipotle Mexican Grill (NYSE: CMG), built in Python and Google Sheets. Bull/Base/Bear scenario analysis with WACC-driven terminal value. Interactive Streamlit dashboard with modular pandas architecture (~900 lines, 7 modules) and 6-test pytest suite.

PythonpandasStreamlitGoogle Sheetspytest
Live Demo GitHub
03

Experimentation

A/B Test Evaluation

+63.4%

CVR Lift

Production-style A/B testing framework with SRM validation, contamination audits, and pre-registered ship criteria. Measured +0.25pp lift (0.40% → 0.65%, +63.4% relative) across ~50K users with 95% CI [+0.12pp, +0.38pp]. Delivered SHIP recommendation in a one-page executive summary.

PythonSQLStatistics
View project
04

KPI Framework

KPI Metric Ownership

206K

Customers

North Star metric decomposition with VPAC driver attribution. Automated weekly business reviews and KPI monitoring.

PythonDuckDBSQL
View project
05

Machine Learning · Forecasting

M5 Demand Forecasting

13.51%

MAPE

$2.7M

Projected ROI

Retail demand forecasting that beats industry benchmarks (15-25% MAPE). Compared ARIMA, XGBoost, and Seasonal Naive with rolling validation.

PythonXGBoostARIMAPandas
View project
06

Product Analytics

Product Funnel & Retention

5.95%

Conversion

User-level funnel analysis (view → purchase) and cohort retention using GA4 event data. Identified 83% drop-off at activation stage.

PythonSQLJupyter
View project
07

Business Intelligence

Retail KPI Dashboard

100K+

Orders

Built a full data pipeline: raw → staging → star schema in BigQuery. Created Tableau dashboards surfacing 10+ KPIs.

SQLBigQueryTableau
View project
08

Healthcare Analytics

FitBit Wellness Analysis

100K+

Records

Analyzed wearable data to find correlations between activity, sleep, and calories. Built reproducible reports in R Markdown.

Rggplot2SQL
View project
09

Classification

Telecom Churn Prediction

90%

AUC

Predicted customer churn with 90% AUC. Feature engineering on tenure, usage patterns, and billing data.

PythonScikit-learnXGBoost
View project
03 /

What I work with

Languages & Databases

Python
SQL
R
NoSQL
Shell Scripting

Analytics & Statistical Modeling

Pandas
Scikit-learn
Hypothesis Testing
A/B Testing
Time Series Forecasting
Cohort & Funnel Analysis
TensorFlow
PyTorch

Cloud & Data Engineering

BigQuery
ETL Pipelines
Data Modeling
AWS
Azure
GCP

BI & Visualization

Power BI
Tableau
Advanced Excel
Looker
Dashboard Design
KPI Frameworks
Data Storytelling

AI & Modern Tooling

Claude API
Agentic LLM Workflows
Streamlit
Prompt Engineering
GenAI

Finance & Business

Financial Modeling
Variance Analysis
Ledger Reconciliation
Stakeholder Communication
04 /

Where I studied

UIC

University of Illinois Chicago

Bachelor of Science · Information & Decision Sciences + Finance · Minor · Marketing · May 2026

3.72 GPA
Magna Cum Laude
Co-Director PR @ BAO

Let's connect.

Open to full-time data analyst, business analyst, and FP&A roles - starting immediately.
F-1 STEM OPT authorized to work in the US.
Always happy to talk about analytics, AI tooling, or how data can change how a business operates.