Killing a $70,000/month tool with a lean replacement
A retail bank’s “Image Viewer” let teams retrieve check images. It was being sunset and the replacement was usage-priced—forecasted at $70k USD/month for Plains. Treasury needed speed, accuracy, and zero vendor lock-in.
What I built
- End-to-end system: multithreaded extraction of terabytes from thousands of zips;
- Parsed millions of XML entries into a queryable database with incremental refresh;
- A fast Flask web app deployed as Databricks App—search, preview, export, audit trails;
- Automated the manual steps the legacy tool couldn’t.
Outcome
- $70,000 USD/month saved vs. the bank’s new pricing (~$1.15M CAD/year).
- Used by finance leadership; faster retrieval, fewer steps, better visibility.