Engineered the bank's data, then turned it into strategy.
I sat between the engineers who moved the data and the teams who ran on it. Some weeks that meant pipelines, quality checks, and query tuning. Other weeks it meant turning what the data showed into strategy for marketing and digital banking: which customers to reach, in what order, and what to say to them.
Engineering side
- Kept the pipeline that moves raw banking data into the warehouse running: loading, checking, and the late-night detective work when something upstream changed shape.
- Built the data-quality framework: 144 automatic checks watching 36 financial tables, all controlled from one big rules table. Adding a new table means adding rows, not writing code. 85% less code, 60% fewer incidents.
- Made the slow queries 40% faster by tuning how the warehouse stores and serves data.
- Built the warehouse cost intelligence platform: 12.7 million queries analyzed, idle spend measured, and the consolidation plan the bank adopted.
People side
- Built four production Sigma dashboards from scratch for digital banking, eStatements, onboarding, and small business. They refresh daily, and people actually open them.
- Studied 18,597 new accounts, found 1,452 small businesses nobody had ever reached out to, and handed the list to the people who'd make the calls.
- Forecast paperless-statement sign-ups with a model that tracked the history almost perfectly. Marketing adopted it as their roadmap.
- Wrote the business case for shrinking 21 cloud warehouses down to 7: $74k to $96k a year saved.
Highlight · Warehouse cost intelligence
An assignment to monitor costs became the bank's consolidation strategy.
I was asked to build cost monitoring. I expanded it into a full platform: six months of query history, warehouse cycle patterns, contract burn forecasts, and a scoring model for which warehouses to merge. It showed only 21 cents of every dollar doing real work, one always-on warehouse costing $5,918 a month, and 78% of spend sitting idle. The data architect cited it in the formal strategy: 21 warehouses down to 7, $74k to $96k a year.
18,597accounts cohort-analyzed for adoption strategy
144automatic checks watching 36 financial tables
60%fewer production data incidents after the framework shipped
$74–96kprojected annual savings in the case I presented
SQLSnowflakeAWSSigmaPythonPresenting to humans