Case Study
Accelerating Federal Procurement Reporting with Robotic Process Automation
Introduction
Federal agencies must regularly report on progress towards achieving mandated acquisition targets. For one agency, the process for obtaining this data, preparing it for analysis, and producing reports from it was human-driven and entirely manual.
The agency engaged Improvix to automate the process and increase reporting frequency for timely distribution of up-to-date information used to inform procurement-related decision-making for contracts across the entire organization.
Mission Objectives
Design an automation flow to ingest the latest contract data from USASpending.gov every morning.
Perform in-flight transformations of the data to split total spend across different procurement categories.
Load new data into the custom report and archive contract data exports for trend or historical analysis.
Minimize costs by utilizing existing toolsets and investments within the agency’s technology portfolio.
Improvix’s Solution
Improvix developed a robotic process automation (RPA) flow to make scheduled API calls to USASpending.gov, retrieving all required data sources and performing a series of preparation, organization, and archival tasks to ensure the latest data is loaded for decision-oriented analysis and reporting—without any human intervention.
Tools & Technologies
Measureable Mission Value
Benefits & Outcomes
reduction in time spent manually obtaining and formatting data for target reporting.
efficiency increase for producing the weekly report, from 1.5 hours to 15 minutes.
increase in software licensing and tooling cost based on our complete solution.
Let’s Get Started!
Achieve your mission objectives faster with our customer-centric approach.
