"When you're doing something for the first time, you deal with systems issues, people issues, deadline issues, and you come across something new every day," he says. Tracking and reporting how many jobs are created with ARRA funds is a prime example. Meeting the first federal reporting deadline of Oct. 10 required some on-the-fly tactics.
"For the first round of reporting, what we have done is develop some manual templates, which we issued out to state agencies. Each agency must use the same template and also pass it on to subrecipients and vendors. That data will then be gathered and uploaded into a recently launched central database, then uploaded through XML to the federal system," he explains.
But this is only for the first round of reporting, Advani emphasizes. For the long term, the state is developing an automated data-gathering and -analysis system that includes Oracle Corp. business intelligence tools, data marts and data warehousing.
"We're trying not to make this a short-term solution, because ultimately we want to upgrade how we do grants management and our budgets across the board. We want to make sure we can use the same tools and reporting database beyond ARRA," Advani says.
ARRA timeline: 2009
* Feb. 17: The American Recovery and Reinvestment Act is signed into law. The federal government's Recovery.gov Web site goes live.
* Feb. 19: Federal agencies begin announcing block grant awards.
* May 17: Agency and program plans are posted on Recovery.gov.
* May - October: ARRA stimulus money is distributed to states and other recipients.
* May - August: Reporting requirements and updates are developed and distributed.
* Sept. 28: Recovery.gov is relaunched with geographic mapping.
* Oct. 10: The first quarterly deadline for recipient reporting is reached.
* Oct. 30: Recipient grant and loan data is posted.
-- Julia King
ARRA's tight timeline and strict reporting deadlines have already driven some key process improvements in the state. For example, funding for ARRA transportation and highway projects had a 120-day "use it or lose it" deadline. But it typically took the state between 100 and 300 days to advertise projects and solicit bids from contractors. "We ended up drilling down into the system to get it down to a 40-day process, which is something we're proud about," Advani says.
Another long-term improvement is the creation of the program office itself. Going forward, the office will oversee all activities involving grants reporting, monitoring and compliance. The goal is to increase overall information transparency "beyond what's expected for federal reporting," says Advani.