Case Study
How do you give a regulator's technology office one clear view of its budget and spend?
Put the budget and execution data in one report, build dashboards on that report, and connect it to the agency's own data warehouse. Northramp did this for FDIC's technology organization as prime contractor on its IT financial management task order, known as FMPS.
The problem. In 2022, FDIC asked Northramp to strengthen financial management for its technology organization. Analysts pulled budget and spend figures from several reports and matched them by hand. Accruals followed different practices from one analyst to the next. Executives worked from a spreadsheet with too many tabs to answer simple questions.
What we did.
One report. We gathered the reporting needs of three technology offices and built a single report. Budget and execution data now sit in one file, drawn from the same sources and fields.
An accrual dashboard in Power BI. We met with each analyst and built a tool that shows which oversight managers have submitted accruals, and for which contracts. It also flags any accrual that has no budget behind it.
An executive dashboard in Power BI. Leaders see budget and execution for the whole organization. They can drill down by division, branch, project, activity or budget type.
A data warehouse environment. We set up dedicated resources in FDIC's Enterprise Data Warehouse. Analysts now work from the authoritative source and can combine data from many FDIC systems.
A forecasting app. We built and launched a Power Apps canvas app, connected to the warehouse, to track projections against actuals at the lowest level of the budget.
What changed. Analysts see budget and execution together and spend less time matching reports by hand. They find missing and incorrect accruals faster. Executives get a high-level view and can drill into the cause of an issue themselves.
Where and when. Prime contractor on the FMPS task order under the FDIC SBSS BOA (CORHQ-21-G-0346), Workstream 4, IT Financial Management. July 2022 to December 2023.
Next step: Need better financial data at a federal regulator or finance agency? Email info@northramp.com.