Subscribe to the Free Print Edition!
Celebrating 25 Years

GCN Home > 11/18/02 issue

DOJ analysis tool adds up

By Kevin McCaney, GCN Staff

The Justice Department has enhanced management of its work force with a new analysis and reporting tool that lets program managers bring payroll and personnel data quickly to the surface.

“The tool has really opened up people’s eyes to the validity and the integrity of the data,” said Melinda Morgan, acting deputy director of the department’s finance staff.

About 18 months ago, Morgan’s staff began a project to adapt WebFocus from Information Builders Inc. of New York for their use. The goal was to develop a suite of reports that could integrate payroll and personnel information and quickly provide reports and analyses. They wanted to get around the slow, painstaking process of searching the National Finance Center’s mainframe for the information.

“They had a plan for a Web-based system” that would serve Justice’s roughly 186 offices, said Larry Reagan, director of Information Builders’ Federal Systems Group. “The existing system was too slow.”

“We had been using Information Builders’ Focus product for the last 10 years or so, the mainframe version,” Morgan said. “When they came out with the Web product, we thought this was a good way to marry some of our HR and mission data.”

Her team spent about nine months planning their approach and then began testing. Morgan said three or four department employees worked on the system while doing their other jobs. The system has been running for more than six months now, “and the important thing is that we were able to do it for $25,000,” she said.

Doing what-ifs

The system keeps track of pay and benefits, Morgan said, and it has the capacity to do some what-ifs, such as identifying employees eligible to retire and projecting the effects if they do leave.

“This is an opportunity to reach out to some of the more mission-oriented organizations, on the law enforcement side, and say: What different information do you need? Do you need to know when your people were last promoted? Do you need to know, more importantly, where people are and whether there is a duplication of resources?” Morgan said.

Part of the application’s appeal was that it was a reusable investment, she said. It took data from legacy systems, tied it to mission data and put it into a place where it would get multiple uses.

Reagan said the project took WebFocus’ templates “and modified them in a way that makes sense for [the Office of Management and Budget’s transformation] objectives.”

The results help managers determine the best approach to managing the work force. For example, Morgan said, “If we give people more money, do they stay? That kind of information.” She said the finance staff has passed a lot of information to Justice’s personnel staff director, Debra Tomchek.

More news on related topics: Knowledge Management, Executive Center, COOP / Telework