Data Portfolio

9 projects across a variety of fields.

Healthcare

Synthetic Hospital Database

17-table, research-grounded synthetic hospital database with a generate-validate-repair data quality pipeline — no PHI, built from peer-reviewed clinical/operational schemas.

MySQLSQLAlchemyTableau
Finance

Twitter Sentiment, Bots & Abnormal Returns

Bot accounts wrote 36% of 2.7M stock tweets and their sentiment shows no link to price moves; organic sentiment correlates at +0.24 to +0.39 with abnormal returns — a revisit of my grad-school study, adding the bot detection it lacked.

VADERDuckDBPlotly Dash
Supply Chain

Rossmann Demand Forecasting

ARIMA vs. LightGBM on retail demand — documenting where ARIMA's stationarity assumptions break on promotion- and holiday-driven sales data.

ARIMALightGBMTableau
Database / NLP

SQL Analytics Engine with NLP Query Interface

Text-to-SQL interface over a normalized analytical schema — plain-English questions translated to validated SQL via an LLM query layer.

SQLLangChainClaude API
Real Estate

Miami Home Sales Explorer

A price model on these 990 Miami-Dade and Broward sales reached R² 0.82 but missed by about 28% per home and couldn't price by location reliably (about 7 sales per ZIP), so the dashboard now shows what the sales say: medians by ZIP and property type, with the sample size behind every number.

pandasStreamlitPlotlyFolium
Tourism

Hotel Review Sentiment & Reputation Dashboard

Multilingual (English + Spanish) sentiment and topic modeling across Miami/Orlando hotel reviews — reputation scoring and competitor benchmarking.

BERTopicXLM-RoBERTa
Agriculture

Florida Crop Yield Forecasting

Weather-driven yield forecasting for Florida citrus or strawberry — frost days and rainfall expected to dominate feature importance.

USDA NASSNOAALightGBM
Insurance

Florida Flood Claim Severity Predictor

Per-property Annual Expected Loss scoring from FEMA NFIP claims and NOAA storm tracks — Florida accounts for 79% of US homeowner insurance lawsuits.

FastAPISHAPGeoPandas
Labor Economics

Occupation Employment & Real Wage Tracker

11 years of BLS OEWS data with CPI-adjusted wages and JOLTS job openings — the standout finding: for the same job, Florida pays about 8% less than the national figure, not the premium the project assumed going in, and in 2021–22 more than 80% of US occupations saw their pay fall behind inflation.

Plotly DashBLS OEWSJOLTS