Department of Information Technology

Streamlined Banking

Planning Phase

Project Abstract

10/27/2009

o  Outcome: The ability to reconcile the general ledger, to the journals, the journals, to the financial registers, and the registers to the fiscal agent bank statements.
o  Outcome: The ability to accurately report financial data.
o  Outcome: An audit trail from the bank statements, to the financial registers, to the journals, to the general ledger, to the financial statements.
·  Verify reconciliation data from June 30, 2006 through date the project team completes the project.
o  Outcome: The ability to provide accurate outstanding information to the stale-dated-warrant process and the reconciliation process.

Funding Per Phase

Phases / Certification Date / Amount Requested /

Major Deliverable(s) / Performance Measure(s)

Initiation:
/
N/A
/ $ 0 / Define Business Requirements for bank statement files, registers, journals, General Ledger, subsidiary systems, consolidated bank statements, and Bank to Book reconciliation. Determine Project Goals and Deliverables, Begin development of Project Management Plan, Draft IV & V contract and plan. Perform software functionality assessment. Develop list of procedural and configuration changes needed to ensure the success of the Daily Automated Reconciliation Process. Document reconciliation process. Identify scope and methodology to accomplish data cleanup. Construct Proof of Concept.
Planning:
/
Oct 28, 2009
/ $ 410,000 / Development of Risk Assessment & Mitigation Plan, completion of Project Management Plan, Project Schedule, Scope definition and cost estimates for configuration changes and data cleanup, resource planning. Finalize IV&V contract and hire IV&V consultant. Prepare for TARC review. Draft Scope of Work and contract for design of procedural and system changes. Hire contractor to develop the Project Requests related to the Software Functionality Assessment (application development requests). Draft Scope of Work and contract for data cleanup. Select data cleanup contractors. Develop data cleanup design and work plan.
Implementation: / Nov 18, 2009 / $830,000 / Identified configuration design implemented in Cash Management module software in development region, UAT and Integration testing completed, configuration changes implemented in production. Implement the daily book to bank reconciliation processes. Data cleanup completed.
Closeout: / August, 2010 / $0 / Develop DoIT Closure Report, Project Closure Archive, IV &V Close out report, Post Mortem


Streamlined Banking Governance / Steering Committee

3