DW
Data Engineer · Analyst · Columbia, SC

Dean
Willis

A finance graduate with a passion for data and technical problem solving. I build production-grade pipelines with market intuition — because knowing what the numbers mean is just as important as moving them.

Selected Work
All projects →
01
SEC EDGAR Financial Data Pipeline
ETL pipeline ingesting 1.82GB of quarterly SEC data across 40 ZIP files, normalized and loaded into MySQL.
Python · MySQL · pandas · SQLAlchemy
02
R&D Spikes Predict Short-Term Price Declines
Original quantitative thesis tested across 1,404 companies — tracking post-spike short-term price behavior.
Python · yfinance · MySQL · SEC EDGAR
03
Personal Finance Tracker
Mobile expense and subscription tracker with a FastAPI backend, full CRUD, and automatic recurring expense detection.
Python · FastAPI · SQLite · SQLAlchemy
04
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