by clicking on the page. A slider will appear, allowing you to adjust your zoom level. Return to the original size by clicking on the page again.
the page around when zoomed in by dragging it.
the zoom using the slider on the top right.
by clicking on the zoomed-in page.
by entering text in the search field and click on "In This Issue" or "All Issues" to search the current issue or the archive of back issues respectively.
by clicking on thumbnails to select pages, and then press the print button.
this publication and page.
displays a table of sections with thumbnails and descriptions.
displays thumbnails of every page in the issue. Click on a page to jump.
allows you to browse through every available issue.
GCN : October 2015
36 GCN OCTOBER 2015 • GCN.COM AT A GLANCE PROJECT: Pennsylvania Treasury Transformation Project ORGANIZATION: Treasury Department, Pennsylvania The consolidation of core financial functions and adaptable algorithms have given financial managers greater insight and control. Pennsylvania officials have re- leased a set of applications that helped them catch up on nearly a decade’s worth of financial service improvements in the aftermath of a mainframe failure. The upgrades have given the state greater control in meeting its financial requirements. Features include soft- ware that gives managers the ability to audit the 21 million payments the state’s Treasury Department makes an- nually and tools that standardize data access at 60 Pennsylvania agencies. “Technologically speaking, we migrated from the 19th to the 21st century,” said PN Narayanan, CIO of Pennsylvania’s Treasury Department. “We were in a place where we didn’t have any way to predict or to provide reliable systems, and now we have a technology and infrastructure that [are] much more integrated, reliable and much more secure.” When the state’s aging mainframe failed in 2008, it exposed to risk some $10 million worth of payments the commonwealth made on a daily basis and triggered a massive disaster recovery effort. It also touched off the financial service transformation. “It couldn’t have happened at a more convenient time — the day before Thanksgiving, [which gave us] four days to recover,” Narayanan said. Even so, it became clear that the vintage system, which was supported by a dwindling workforce of Cobol program- mers, needed to be replaced. In the aftermath of the mainframe failure, Treasury officials formulated a plan to automate payments from all branches of the state government and its three major pension systems. The plan called for Treasury to replace the mainframe and 25 internal systems, es- tablish a common general ledger code structure across the state, build stan- dard XML and web service interfaces for all agencies, and audit all payment records. The plan gained momentum when officials realized the human cost of what was at stake. “The legislature real- ized very quickly that if payments could not be made, vulnerable citizens would be in trouble because they could not get payments at the right time, including health care benefits or unemployment checks,” Narayanan said. Central to the project’s success was finding software tools that could give auditors and financial managers a greater degree of control over and ac- cess to data on individual payments and audits. In particular, officials needed to meet a requirement that every pay- ment that left the state was lawful and accurate. That meant developing the ability to conduct prepayment audits of transactions with a limited number of financial analysts on the payroll, Narayanan said. To maintain an accurate payment stream and defend against fraud, offi- cials had to improve financial manag- ers’ ability to target different datasets and set up audits on the fly, he added. It was a capability that would have been almost impossible under the old mainframe. That system’s constraints forced the department to make best-case approxi- mations of the payment data stream. Auditors could only sample payments beyond a particular, often preset, threshold and had to infer whether all the other payments would be accurate or not. For the new system, the department issued a request for proposals for tools that could produce audit algorithms for scrutinizing each tax dollar the state spent. “The idea was to replace the entire payment system, revamp all the investments and consolidate the core financial functions into an [enterprise resource planning] system,” Narayanan said. Treasury uses Oracle’s PeopleSoft Financials to handle cost-payable processes and Oracle Governance, Risk and Compliance for audit analytics and forensic analysis on payment processes. The GRC module also helps manag- ers see who made critical changes to system setups and what users have done with the authority they’ve been assigned. Officials worked with the product developers to adapt it for prepayment audits, a twist that helped Treasury cre- ate rules without the IT department’s involvement. “With this set of technologies, ana- lysts and auditors can alter their own algorithms,” said Sid Sinha, Oracle’s senior director of application develop- PENNSYLVANIA SPINS UP 21st-CENTURY FINANCIAL SYSTEM After a mainframe failure, state officials took advantage of the opportunity to build a system that would automate payments and standardize data collection 1015gcn_020-038.indd 36 10/5/15 10:41 AM
January and February 2016