DW

Data Analyst · Columbia, SC

Dean
Willis

Selected Work

All projects →

SEC EDGAR Financial Data Pipeline

ETL pipeline ingesting 1.82GB of quarterly SEC data across 40 ZIP files, transformed in pandas and loaded into MySQL.

Python · MySQL · pandas · SQLAlchemy

R&D Spikes Predict Short-Term Price Declines

Original quantitative thesis tested across 1,404 companies. tracking fluctuations in price behavior when R&D is increased.

Python · yfinance · MySQL · SEC EDGAR

Personal Finance Tracker

Mobile expense and subscription tracker with a FastAPI backend, full CRUD, and automatic recurring expense detection.

Python · FastAPI · SQLite · SQLAlchemy

S&P 500 Anomaly Detection

Real-time anomaly detection across all 500 S&P constituents using Z-Score and Isolation Forest, with AI-generated summaries explaining each signal.

Python · scikit-learn · FastAPI · React · Claude AI