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

Joshua Biondo, Principal Analytics Architect