Joshua Biondo · Selected work · Earlier role · BI & models
Treasury Automation Framework
Idle cash traced through the contracts and modeled into a ten-year revenue case.
Outcome: $1.5M+ new annual revenue
What I built
- Reserve, deposit and investment terms pulled from loan, management and operating agreements with Python and Power Query.
- Matched to a year of bank statements, showing balances spread across many banks and earning almost nothing.
- A scenario model for the Director of Treasury over a $2.8B portfolio that put a number on the missed revenue.
- Reporting automated with Power Query, cutting reporting time 60%.
Stack: Excel, Power Query, Python