Personal Finance Analytics Pipeline
Engineered a Python ETL pipeline to deduplicate and categorize 1,390+ synthetic bank and credit card transactions; developed detection logic that identifies recurring subscriptions using only billing cadence and amount patterns; wrote PostgreSQL window-function queries to compute savings rate and rolling averages and flag spending anomalies; excluded transfers from spending metrics, built Tableau visualizations, and validated the pipeline with 38 tests
