Like many states, Arkansas IT department has come to rely on mainframe-based systems to store, process and report data from different agencies and departments. The hodge-podge of separate structures that evolved, however, was never designed to share information.

Every year since 1995, Arkansas annual audit has called for an overhaul of IT infrastructure. Why? Most information exists in isolated silos, accessible only by a few IT professionals within individual sections or departments. The human resources system, for example, couldnt talk to payroll or property management applications. When reports were needed, requests had to be made to IT with a wait of 24 hours or more before the reports appeared. Since information wasnt integrated, however, if the requested report revealed a potential deficiency in a related area, yet another request had to go to IT, creating a further delay while the new document was generated.

"The data is so stovepiped that you cant find it," said Ron Hopper, assistant administrator of the Arkansas Department of Finance and Administrations Office of Accounting. "Worse, not everyone elected to use parts of the old systems, so they didnt even contain complete data. Our systems simply didnt produce the information that many departments needed to perform their duties," said Hopper.

As a result, the 82nd Legislature of Arkansas authorized $30 million to fund the Arkansas Administration Statewide Information System (AASIS), an ambitious enterprise resource planning (ERP) project. Designed to unify the states fragmented information systems, AASIS will make it easy for users to access databases throughout government. Executives will be able to drill down to the data they need, crossing departmental boundaries as necessary, from their desktops.

Overhauling Infrastructure

To accomplish its vision, Arkansas selected SAPs R/3 ERP system, a decision supported by Gartner Group consultants. Making the decision was the easy part. Successfully carrying it off proved to be a different matter entirely.

The state appointed Hopper as AASIS project manager. Next came the establishment of a team to carry out the task. Hopper first pulled 21 employees from the Department of Finance and Administration to work on AASIS. After that, a further 66 personnel were squeezed from the ranks of various state agencies, most of them on a full-time basis. To cope with the scope of the implementation, Arkansas established an organizational structure consisting of a steering committee, a coordinating council, a project management office and separate sections to deal with financials, human resources and payroll, change management, training and technical functions.

Due to a lack of experience with ERP, Arkansas supplemented its ranks with 44 consultants from SAP, Deloitte & Touche and BrightStar. They contributed expertise in implementation, software configuration, training, change management and troubleshooting.

The fast-paced staffing of the project created an immediate and unforeseen problem. Exactly where do you put so many people? "We had no place big enough to put all these people and we hadnt planned for it," said Hopper. "We also didnt plan for the need to back fill the empty positions you vacate by filling the project."

Subsequent personnel strain contributed to the decision to take a "big bang" approach to implementation rather than the gradual migration many experts recommend. The city of Watsonville, Calif., chose the latter path when it upgraded its financials and moved to Windows NT. "We opted for a cautious approach," said Jeff Merrill, IT manager for Watsonville. "We ran both systems in parallel for a while before finally abandoning the old system."

Hoppers view is that two huge systems running at the same time makes for double work. Therefore, instead of organizing a series of pilots and a gradual phase-in of ERP module by module, Arkansas plans to go directly from testing to implementation. "In April of 2001, we are going to start running various business processes, like payroll, in parallel," he said. "We will compare both

Drew Robb  |  Contributing Writer