Business Application Services (CORE) Publications - Executive Board Meeting July 21, 2010

The following is a text transcript of the presentation made at the BAS (CORE) Oklahoma Executive Board meeting in July 2010.

Slide 1

BAS Executive Board July 21, 2010
Next CEB Scheduled - August 18, 2010

Slide 2

Agenda

• SQL Requests/Problem Management Summary
• Completed Projects
• Portfolio
  • Priority
  • Execution Delivery Schedule
• Projects in Movement
• Program Status
  • HCM
  • Financials
• Application Development Service Request Summary
• Scorecard
• Executive Issues

Slide 3

Problem Management

SQL Requests in Total April 2009 to March 2010

	July 2009	August 2009	Sept 2009	Oct 2009	Nov 2009	Dec 2009	Jan 2010	Feb 2010	March 2010	April 2010	May 2010	June 2010
ARBI	0	0	0	0	1	0	0	1	0	0	0	0
CRM	0	0	0	0	1	0	0	1	0	0	0	0
DBA/System	0	0	0	0	0	0	0	4	0	2	0	0
Procurement	4	1	5	2	0	0	0	0	0	0	0	0
HRMS	7	24	13	10	3	6	10	12	14	15	11	11
Financial	15	14	10	4	14	8	8	6	1	2	7	8
EPM	1	0	1	0	0	0	1	0	0	0	0	0
ELM	0	1	0	0	0	0	0	0	0	0	0	0
Purchasing	0	0	0	0	0	4	8	0	0	2	0	0

Legend

• ARBI - Accounts Receivable/Business Intelligence
• CRM - Customer Relationship Management
• HRMS - Human Resources Management Systems
• EPM - Enterprise Performance Management
• ELM - Enterprise Learning Management
• DBA/System - Database

Slide 4

Problem Management Summary

Summary	Total Problems	Resolved or Resolution in Process	Investigating	Resolved by Future Functionality	DR to be Created	Monitor
Financial	14	8	2	4	0	0
PO	2	1	1	0	0	0
HCM	18	12	1	0	4	1
DBA/System	3	0	2	0	0	1
Total	37	21	6	4	4	2

Slide 5

Completed Project, since last BAS Executive Board

• Commitment Accounting Rollout, Schedule (Green); Budget (Green)
• Backfill Developers, Schedule (Green); Budget (Green)
• Employee Self Service Rollout, Schedule (Green); Budget (Green)
• EFT Remit Advices, Schedule (Green); Budget (Green)
• AP Workflow, Schedule (Green); Budget (Green)

Slide 6

BAS Completed Projects 2010 First and Second Quarters - Total 10

Schedule

• *World Class - 80% on time
• *Median - 70% on time
• 2009 Actual - 75% on time
• 2010 First Quarter - 75% on time
• 2010 Second Quarter - 100% on time

Pie chart showing 10% of Projects are over 20% and 90% are within 10% of Schedule

Budget

• *World Class - 94% on time
• *Median - 85% on time
• 2009 Actual - 92% on time
• 2010 First Quarter - 100% on time
• 2010 Second Quarter - 100% on time

Pie Chart showing 100% of Projects are within 10% of Budget.

Slide 7

Completed Projects 2010 - First and Second Quarters

• Asset Management Pilot, Schedule green, Budget Green
• Commitment Accounting Rollout, Schedule green, Budget Green
• HCM Functionality Enhancements, Schedule green, Budget Green
• EFT Remit Advices, Schedule green, Budget Green
• Backfill Developers, Schedule green, Budget Green
• Time & Labor Self Service - OSF, Schedule red, Budget Green
• ARRA Transparency, Schedule green, Budget Green
• Deposits, Schedule green, Budget Green
• Integrated Item Maintenance, Schedule green, Budget Green
• GPC Pilot OESC, Schedule green, Budget Green

Slide 8

Multi-Agency Business Services Opportunity Map

Images of a flow chart showing opportunities, phase and status for three-year period.

Assets

• 2010
  • Asset Management Pilot, close, changed phase.
• 2011
  • Asset Management Rollout, execution
  • Asset Management, ODOT, execution
  • Scanning and bar coding, planning

Supply Chain Management

• 2010
  • Integrated Item Maintenance, close
  • Inventory Mental Health, execution, close
• 2011
  • Inventory Oklahoma Department of Transportation (ODOT), execution 
  • Inventory Implementation, concept
• 2012
  • Inventory Rollout, concept

Financial Management

• 2010
  • Deposits, close
  • Office of State Finance (OSF)/ODOT Accounts Receivable (AR) Billing, close
  • Backfill Developers, close
  • Accounts Payable (AP) Workflow, close
  • EFT Remittance, execution, close
  • Treasury General Ledger, execution,
  • Backfill Developers, execution
• 2011
  • Apply Bundles 2011, concept
  • eBill Pay, initiation
  • Expense Module, planning
  • Voucher Build, concept
  • PCard BOA transition, concept
  • 3% Backup Withholdings, concept
  • Treasury Module, concept
• 2012
  • Financials Upgrade, concept
  • P-card Module, concept

Enterprise Service Automation

• 2010
  • Grants, Projects, Contracts (GPC) OESC, close
  • GPC Pilot, ODOT, execution
  • GPC Pilot Oklahoma Department of Corrections (ODOC) and Department of Environmental Quality (DEQ), execution
• 2011
  • GPC Rollout, initiation
• 2012
  • GPC Roldout, concept

Human Capital Management

• 2010
  • Time and Labor (T&L) Pilot, execution
  • T&L Manager Self Service Pilot, close
  • Enterprise Learning Rollout, planning
  • Commitment Accounting Rollout, close
  • HCM Functionality Enhance, close
  • Employee Self Service Rollout, close
  • T&L for Non Bi-Weekly, execution
  • ODOT T&L MSS, execution
  • Higher Education Interface, execution
• 2011
  • T&L Manager Self Service Rollout, concept
  • Apply Bundles 2011, concept
  • T&L Rollout, initiation
  • Leave Request Approval, concept
  • Organization Publisher, initiation
• 2012
  • Apply Bundles, concept
  • E-Performance, concept

Other

• 2010
  • Licensing, planning
  • ARRA Transparency, close
  • Grants Provisioning, planning
  • Data Staging Area, close
  • OpenBooks Phase 3, planning
  • PeopleTools 8.49, execution
• 2011
  • Business Inteligence Financial Analytics, planning
  • Archiving Phase 2, concept
  • FFATA Transparency, concept
  • Governmental Risk and Compliance, concept
• 2012
  • Training Web Delivery, concept
  • Address Scrubbing Software, concept
  • Budget, concept
  • Portal - PeopleSoft Sign on, concept

Supplier Relationship

• 2010
  • Vendor Registration, execution
  • Strategic Sourcing - e-Supplier Rollout, concept
• 2011
  • e-Procurement, concept

Slide 9

Portfolio Priority 1-15

Project Name	Project Manager	Dept	Function	Current Project Phase	Priority within Function
Backfill Developers for Production Support and Enhancements	Fred Cantrell	BAS	Financial Mgmt + Human Capital Mgmt	Planning, Execution	1
Time and Labor Pilot/ ODOT	Alex / Kim	BAS	Human Capital Mgmt	Execution	2
Inventory Pilot Department of Mental Health	Alex / Kim	BAS	Supply Chain Management	Execution	3
Department of Central Services Vendor Registration	Lisa McKeithan	BAS	Supply Chain Management	Execution	4
P-Card - BOA Transition	Lisa McKeithan	BAS	Financial Management	Initiation	5
GPC, A/R, Billing, T&L Extended Departments of Commerce (Commerce) and Environmental Quality (DEQ)	Alex / Kim	BAS	Enterprise Service Automation	Execution	6
Higher Education Interface	Lisa McKeithan	BAS	Human Capital Management	Execution	7
PeopleTools 8.49	Mike Jorski	AppDev	BAS FIN, CRM, EPM	Execution	8
Inventory -  ODOT	Alex / Kim	BAS	Supply chain management	Execution	9
Assets - ODOT	Alex	BAS	Financial management	Planning, Execution	10
GPC - ODOT	Alex / Kim	BAS	Enterprise Service Automation	Execution	11
T&L  Manager Self Service ODOT Pilot	Alex / Kim	BAS	Enterprise Service Automation	Execution	12
Treasury General Ledger Implementation	Alex	BAS	Financial management	Execution	13
PeopleSoft Extract Staging Environment	Lisa McKeithan	BAS	Other	Planning	14
Business Intelligence Financial Analytics	Lisa McKeithan	BAS	Other	Planning	15

Slide 10

Portfolio Priority 14-26

Project Name	Project Manager	Dept	Function	Current Project Phase	Priority within Function
OpenBooks - Phase III	Lisa McKeithan	BAS	Other	Planning, Execution	16
Asset Management - Rollout	Michael Grisser	BAS	Assets	Execution	17
Travel & Expense EFT	Steve Wilson	DCAR	Financial Management	Execution	18
Grants - Provisioning	Lisa McKeithan	BAS	Other	Planning	19
Licensing	Lisa McKeithan	BAS	Other	Planning	20
Enterprise Learning Management - Rollout	Michael Grisser	BAS	Human Capital management	Planning, Execution	21
Scanning and Bar-coding for Phase II modules	Alex	BAS	Assets	Concept	22
Expense Module	Alex/Kim	BAS	Financial management	Planning	23
Budget	Lisa McKeithan	BAS	Other	Concept, Initiation	24
eBill Payment	Lisa McKeithan	BAS	Financial Mgmt	Concept
Federal Funding Accountability and Transparency Act (FFATA)	Lisa McKeithan	BAS	Accounts Payable	Concept
3% Federal Withholding	Lisa McKeithan	BAS	Accounts Payable	Concept

Slide 11

Projects in Execution Delivery Schedule

• PeopleSoft Extract Staging Environment - January-June 2010
• Time and Labor Pilot / ODOT - June 2009-July 2010
• GPC, A/R, Billiing / ODOT - July 2009-July 2010
• Inventory ODOT - August 2009-July 2010
• T&L Manager Self Service ODOT - March-August 2010
• Inventory Pilot Department of Mental Health - April-July 2010
• DCS Vendor Registration - December 2009-August 2010
• PeopleTools 8.49 - September 2010
• Assets ODOT - September-November 2010
• GPC, A/R, Billing, T&L Extended / Commerce/DEQ - March-December 2010
• Treasury GL Implementation - April-December 2010
• OpenBooks - Phase III - May-December 2010
• FY11 Technical Backfill - July 2010-June 2011
• ELM Rollout - May 2010-July 2011
• Asset Management Rollout - August 2010-July 2011
• Higher education interface - April 2010-October 2011

Slide 12

Detailed Milestone Plan, BAS - 2676 OpenBooks Phase III

Design and build the OpenBooks data warehouse and website. New design must include improved search functionality including detailed vendor payments, dashboard look and feel and download capabilities.

Milestone Plan (+/- 10%)

• Design and Build Extracts to Data Staging Environment. (Task, May-June 2010)
• Design/Model Data Warehouse and Repository. (Task, May-July 2010)
• Reports and Testing. (Task, June-October 2010)
• OK.gov Integration; Automate Uploads & Documentation. (Task, October-December 2010)
• Deploy - ARRA (Milestone, September 2010)
• Deploy - Open Books. (Milestone, December 2010)

Issues

• Financials Analytics will not start until after this project is completed.
• Any delay in the AP Workflow project will impact this schedule.
• New legislation (SB2310/SB1759) will require changes to the current timeline and cost.
• Included ARRA updates due 9/28/2010.

Slide 13

Detailed Milestone Schedule,  BAS - 2801 FY11 Technical Backfill AppDev

Backfill Developers for Enhancement Service Requests.

Milestone Schedule (+/- 10%)

• FIN, EPM Production support and required enhancements. (July 2010-June 2011)
• HCM, ELM, CRM production support and required enhancements. (July 2010-June 2011)

Issues 

• This is for technical backfill services for Enhancement Service Requests and 30-day post go-live support.
• External backfill staff will be targeted to FIN and HCM.
• External Backfill staff could be applied to CRM, ELM & EPM as needed.
• This plan assumes state technical resources average four hours per day to assist and coordinate external resource activities.

Slide 14

Detailed Milestone Plan,  BAS - 2637 Enterprise Learning Management Rollout

Phase II Rollout of Enterprise Learning Management Group A consists of Department of Career and Technology Education (800), CompSource Oklahoma (390), Department of Transportation (345), Administrative Office of the Courts (199, 219, 220 and 677), Oklahoma.

Milestone Plan (+/- 10%)

• Business Process Review and Kickoff. (Task, August-September 2010)
• Setup for Agencies/Update additional HCM fields. (Task, September 2010-April 2011).
• Verify Configuration. (Task; Group A, September-October 2010; Group B, November-December 2010; Group C, January-February 2011)
• Testing - Includes data entry for learners catalog, etc. (Task; Group A, October-November 2010; Group B, December 2010-January 2011; Group C, February-March 2011)
• Business Process Testing. (Task; Group A, October-November 2010; Group B, December 2010-January 2011; Group C, March-April 2011)
• Train Users. (Task; Group A, October-November 2010; Group B, December 2010-January 2011; Group C, March-April 2011)
• Go-live. (Milestone; Group A, November 30, 2010; Group B, January 31, 2011; Group C, April 30, 2011)
• Convert Agency Training History. (Task, December 2010-June 2011)
• Post Production Support. (Task, December 2010-July 2011.)

Issues

• Need to determine if update of additional HCM fields will be manual or load.
• Will we require enrollment to go through a nominating official or employee self enrol?
• To meet the timelines, all Groups must take the system as it is currently designed/configured.
• Additional functionality requirements will not be met in this rollout and may require a consultant and additional technical support (Phrase III).

Group A - 5,000 employees (8/1/2010 - 11/30/2010 - 12/31/2010)

Group B - 2,250 employees plus HRDS courses (11/1/2010 - 1/31/2011 - 3/31/2011)

Group C - 500 employees plus CPO's, CPA's, Financial Managers and Firefighters statewide (1/20/2011 -4/30/2011 - 6/15/2011)

Slide 15

Detailed Milestone Plan,   2800 - Pcard - Bank of America Transition

Design and build the OpenBooks data warehouse and website. New design must include improved search functionality including detailed vendor payments, dashboard look and feel and download capabilities.

Milestone Plan +/- 50%

• Define requirements with BOA. (Task, May-July 2010)
• Development and Testing. (Task, August-October 2010)
• Integration Testing with BOA. (Task, October-November 2010)
• Implementation. (Milestone, November 30, 2010.)

Issues

• One outbound interface: GL Exports.
• Two inbound interfaces: Vouchers, 1099s and OpenBooks.

Slide 16

Detailed Milestone Schedule,   2810 - Asset Management - ODOT

Asset Management Implementation - ODOT

Milestone Schedule

• Prepare for integration testing. (August 2009)
• Perform integration testing. (August-September 2009)
• Prepare for User Acceptance Testing. (September-October 2009)
• Perform User Acceptance Testing. (October 2009)
• Perform System Roll-out / Conversion. (November 2009)
• Go-Live. (November 30, 2009)
• Production support. (December 2009)

Slide 17

Detailed Milestone Schedule - BAS Expense Evaluation

The project will create a working prototype from which we will evaluate whether Expenses is a useful and viable solution for the state.

Milestone Schedule +/- 50%

• Gather initial requirements from OSF. (July 2010)
• Define scope of the Expense implementation. (July 2010)
• Conduct a high-level FIT/Gap. (July 2010)
• Create a working prototype using OSF requirements and data. (July-August 2010)
• Evaluate results and determine next steps. (July-August 2010)
• Develop a +/- 10% Plan. (July-August 2010)
• Decision - Next steps. (mid-August 2010)

Issues

• BPA Questionnaire created and sent to Steve Wilson.
• Response received.
• Meeting scheduled for 7/15.
• Configuration has begun in FSPH2.

Slide 18 

Program Status

HCM

Slide 19

BAS – 1080 Higher Education Payroll

• Status: Green
• Convert higher education agencies from the legacy payroll system to the PeopleSoft system.

Key Activities

Task	Start	Finish
PY Test Scripts	7/1/2010	7/31/2010
HR Interface Testing	7/5/2010	7/31/2010
PY Conversion extract verification	7/16/2010	7/31/2010
PY Conversion/Interface Testing	8/1/2010	9/30/2010

 

Requires Awareness:

Working on project plan to include state specific tasks. OU time is limited during August/September during enrollment.

Slide 20

BAS – 2581 Time and Labor

• Status: Red
• This project is to address Time & Labor functionality for bi-weekly agencies. The pilot agencies are OESC and ODOT. OESC went live on schedule May 17.

 

Requires Awareness:

Integration and User Acceptance Testing for ODOT will be scheduled to coincide with a re-baselined plan.

Slide 21

BAS – 2666 Grants, Projects, Contracts with AR/Billing Monthly Extended Time & Labor

• Status: GREEN
• The Team is performing Prototype Sessions with DEQ and Commerce for implementation of the Phase II modules.

Key Activities

Task	Start	Finish
Prototype Review and Documentation	6/14/2010	7/9/2010
Develop 7 Unit Test (Rules, Conversions, Interfaces & Modifications)	6/7/2010	8/6/2010
Define and Test Security Roles	7/12/2010	7/23/2010
Prepare for Integration Testing	7/19/2010	8/6/2010

Slide 22

Program Status    

Financials

Phase II Modules

Slide 23

BAS – 2611 PeopleTools 8.49

• Status: GREEN
• Upgrade EPM to PeopleTools version 8.49.

Key Activities

Task	Start	Finish
Prepare Change Assistance & Stage Software	8/30/2010	8/31/2010
Upgrade & test non-prod EPM environments	9/10/2010	9/24/2010
Upgrade EPM production environment	9/25/2010	9/25/2010
Upgrade EPM development environment	9/27/2010	9/28/2010

 

Requires Awareness:

Execution starts the end of August. CRM PeopleTools will be upgraded with the CRM ITIL project. FIN PeopleTools will be upgraded with the next maintenance pack project.

Slide 24

BAS - 2675 Data Staging Environment

• Status: Red
• Build staging environment containing PeopleSoft Extracts that will be used by ODOT.

Key Activities

Task	Start	Finish	ODOT Access
Phase I extracts (6) signed off by ODOT		7/2/2010
Assets (0523) & Projects (0514) have been re-migrated to FSTST2 and is ready for functional testing.	6/25/2010	7/12/2010	7/12/2010
Contracts (0513) & Billing (0512) still working on updating programming	6/25/2010	7/31/2010	7/31/2010
Sign-off on Phase Modules		8/15/2010	7/31/2010
Inventory - define requirements	7/1/2010	7/23/2010
Inventory - programming	7/1/2010	8/15/2010	8/22/2010
Sign-off on Inventory		8/31/2010	8/22/2010

 

Requires Awareness:

Interfaces/batch process were not updating audit tables and getting records created in the staging tables. Re-work required on Phase II extracts (db trigger). Request to add inventory information.

Slide 25

BAS - 2681 DCS Vendor Registration

• Status: Green
• Build interfaces between ok.gov and PeopleSoft for validation and upload of vendor bidder data into PeopleSoft.

 

Key Activities

Task	Start	Finish
Go-live with vendor registration - Part 1		7/19/2010
Development/Testing - Tech Specs 0027 - update 'look-up' functionality within PeopleSoft to include bidders	6/4/2010	8/31/2010
Development/Testing - Bidder to Vendor Update	5/10/2010	8/31/2010
Review/Revise process - OSF & DCS	7/31/2010	7/31/2010

 

Requires Awareness:

Missed Phase I implementation by 19 days. DCS is working on Phase II for updated front-end. This will cause some reprogramming of the interface that will be tracked as a service request. Scheduled for the fall.

Slide 26

BAS - Asset Management Rollout

• Status: Green
• Meetings to be held to prepare for Kickoff Session. Will not make much progress until August after the DMH Inventory Implementation is completed, consulting resources are filled and DCS participation is resolved.

 

Key Activities

Task	Start	Finish
Prepare for and conduct project kickoff	TBD	TBD
Configure and verify agency conversion data	8/16/2010	11/5/2010
Perform test Loads	9/26/2010	10/15/2010
Train agency users	10/17/2010	11/05/2010

 

Requires Awareness:

DCS resource is not committed to the project - Brenda is addressing. If no DCS resource, rollout plan may need to be adjusted. Patricia not available until August. Brenda to also assist with agency buy in to rollout plan. Lost consulting resource; took another assignment - will delay start and could impact ODOT assets. ODOT assets require re-baselining of rollout timeline.

Slide 27

BAS - 2682 Inventory Pilot - DMH

• Status: Green
• The following warehouses are in production:
  • Griffin Memorial Hospital
  • Carl Albert Community Mental Health Center
  • Bill Willis Community Mental Health Center

 

Key Activities

Task	Start	Finish
Go-live	7/1/2010	7/6/2010
Post Production Support

 

Requires Awareness:

Working with DMH to cleanse data for the remaining warehouses: Jim Taliaferro Community Mental Health Center Oklahoma Forensic Center Northwest Center for Behavioral Health

Slide 28

BAS - 2692 Treasury GL Implementation

• Status: Green
• The team conducted the Fit Analysis Sessions and has reviewed the notes. They are in the process of identifying final approach and impacts.

 

Key Activities

Task	Start	Finish
Create decision approach papers	5/28/2010	7/2/2010
Identify development requirements	5/28/2010	7/2/2010
Configuration	7/6/2010	7/13/2010
Define security	7/17/2010	7/16/2010

 

Requires Awareness:

Office of the State Treasurer has requested that their go-live date be moved to a month-ender. Rather than go live on 11/15/2010 they would like to look at either 10/31/10 or 12/31/2010.

Slide 29

BAS - 2599 Grants, Projects, Contracts with AR/Billing

• Status: Red
• This project is on hold.

Key Activities

Task	Start	Finish
Functional Unit Testing - ODOT (see below)

 

Requires Awareness:

ODOT cannot supply a date for conversion of legacy data.

Slide 30

BAS - 2610 Inventory ODOT

• Status: Red
• On hold.

Key Activities

Task	Start	Finish
Integration Testing
Prepare for User Acceptance Testing
User Acceptance Testing
Go Live

Slide 31

BAS - 2674 Manager Self Service ODOT/Pilot

• Status: Red
• Project was planned in two phases: (1) limited salary personnel April 24 (complete) and (2) all non Agile Asset personnel to coincide with ODOT GPC go-live date - on hold.

Key Activities

Task	% Completed	Start	Finish
Go-live Limited Pilot - complete	100	4/24/2010	4/24/2010
Requirements - Full implementation - Complete	100	3/23/2010	4/7/2010

Slide 32

Application Enhancement Service Requests

• August 2009 - Pending, Tech, 63; Development, Tech, 27; UAT, Tech 30; Closed, Tech, 6.
• September  2009 - Pending, Tech, 58; Development, Tech, 35; UAT,Tech, 17; Closed, Tech, 16.
• October 2009 - Pending, Tech, 56; Development, Tech, 33; UAT, Tech, 23; Closed, Tech, 14.
• November 2009 - Pending, Tech, 64; Development, Tech, 36; UA,T Tech, 23; Closed Tech, 12.
• December 2009 - Pending, Tech, 54; Development, Tech, 47; UA, Tech, 27; Closed, Tech, 8.
• January 2010 - Pending, Tech, 59; Development, Tech, 42; UAT, Tech,  24; Closed, Tech, 16.
• February 2010 - Pending, Tech, 72; Development, Tech, 37; UAT Tech, 26; Closed, Tech, 9.
• March 2010 - Pending, Tech, 79; Development, Tech, 25; UAT, Tech, 23 ; Closed, Tech, 17.
• April 2010 - Pending, Tech 122 ; Development, Tech, 27; UAT, Tech, 16 ; Closed, Tech, 19.
• May 2010 - Pending, Tech, 125; Development, Tech, 22; UAT, Tech 18 ; Closed, Tech 22.
• June 2010 - Pending, Tech, 87, Function, 37; Development, Tech, 22, Function, 1; UAT, Tech, 11, Function 1; Closed, Tech, 13, Function, 10.

Slide 33

Current Application Enhancement Service Requests - June 2010

(5/29 - 6/30)

 

Functional ESRs		Pending	Config/Setup	UAT	Completed
	CRM	0	0	0	0
	ELM	0	0	0	0
	EPM	0	0	0	0
	FIN	3	0	0	0
	HCM	34	1	1	10
	Total	37	1	1	10

 

Technical ESRs		Pending	Dev	UAT	Completed
	CRM	1	3	0	0
	ELM	3	0	0	0
	EPM	1	0	0	0
	FIN	27	7	4	4
	HCM	55	12	7	9
	Total	87	22	11	13

 

		Pending	Dev	UAT	Completed
	Total	124	23	12	23

Slide 34

Planned Enhancement Service Requests On-Time Completion Based on 60-Day Plan

• March - 6 ESRs completed; 2 not completed; 5 unplanned completed.
• May - 3 ESRs completed; 5 not completed; 4 unplanned completed.

Slide 35

BAS Scorecard

• Within 10% of plan (green indicator)
• Within 20% of plan (yellow indicator)
• Greater than 20% of plan (red indicator)

Project Name	Current Project Phase	Health Indicator Schedule	Project Phase Start Date	Project Phase Baseline Completion	Project Phase Target Completion	Health Indicator Budget
FY11 Technical Backfill	Planning,Execution	Green	7/1/2010	6/30/2010	6/30/2010	Green
Time and Labor Pilot/ODOT	Execution	Red	3/1/2009	7/31/2010	7/31/2010	Red
Inventory Pilot Department of Mental Health	Execution	Green	4/15/2010	7/31/2010	7/31/2010	Green
DCS Vendor Registration	Execution	Green	12/1/2009	8/31/2010	8/31/2010	Green
P-Card - BOA Transition	Initiation, Planning	Green	5/1/2010	8/15/2010	8/15/2010	Green
Grants, Projects,Contract Accounts Receivable Billing ODOT/OESC	Execution	Green	03/01/2010	12/31/2010	12/31/2010	Green
Higher Education Interface	Execution	Green	4/1/2010	10/31/2010	10/31/2010	Green
PeopleTools 8.49	Execution	Green	8/30/2010	9/28/2010	9/28/2010	Green
Inventory ODOT	Execution	Red	8/1/2009	7/31/2010	7/31/2010	Red
Assets ODOT	Planning, Execution	Green	8/1/2010	11/15/2010	11/15/2010	Green
Grants, Projects, Contract A/R Billing, ODOT	Execution	Red	7/1/2009	7/31/2010	7/31/2010	Red
T&L Manager Self Service ODOT	Execution	Red	3/1/2010	7/31/2010	7/31/2010	Red

Slide 36

Program Status

• Within 10% of plan (green indicator)
• Within 20% of plan (yellow indicator)
• Greater than 20% of plan (red indicator)

Project Name	Current Project Phase	Health Indicator Schedule	Project Phase Start Date	Project Phase Baseline Completion	Project Phase Target Completion	Health Indicator Budget
Treasury GL Implementation	Execution	Green	4/12/2010	12/31/2010	12/31/2010	Green
PeopleSoft Extract Staging Environment	Execution	Red	1/14/2010	6/18/2010	8/31/2010	Green
Business Intellignece - FS Analytic	Execution	Red	4/1/2009	7/31/2009	7/31/2010	Green
OpenBooks -  Phase III	Execution	Green	6/1/2010	12/31/2010	12/31/2010	Green
Asset Management Rollout	Execution	Green	4/19/2010	8/31/2010	8/31/2010	Green
Licensing	Execution	R	12/1/2008	8/15/2009	7/31/2010	Green
ELM Rollout	Execution	Green	8/1/2010	7/31/2011	7/31/2011	Green
Scanning and Barcoding functionality for Phase II Modules	Execution
Expense Module	Execution	Green	7/12/2010	8/20/2010	8/20/2010	Green

Slide 37

Issues

Issue	Status
(1) ODOT Phase II (Projects, Grants, AR, Billing Inventory) will not meet their July 3 scheduled implementation date.	ODOT cannot supply an estimated date when they will have the legacy data converted into PeopleSoft. The project is on hold until this data is provided.
(2) The Asset consultant left the project without conducting turnover to a new consultant.	Maximus is looking for an Asset consultant. They have committed that they will supply the necessary resource so that ODOT Assets and Asset rollout dates are met. Any consulting resources required over our plan will not be billed to the state.
(3) The fixed asset rollout plan has been completed and and additional state resource is required to deliver on the current schedule.	Initial meeting held with DCS to obtain resources. No follow up meeting has occurred. Do we need to postpone this project?
(4) Commerce will be going live on Phase 2 without a Grants Provisioning. They will utilize manual work-arounds until we acquire a Grants provisioning package.	We need to expedite the Grants provisioning purchasing process and prioritize Commerce in the first implementation.

Slide 38

Issues

Issues	Status
(5) We need to determine which agencies will be moved to Phase 2 after Commerce and DEQ.	The additional agencies will be scheduled around the ODOT implementation. This project could start as early as November.
(6) ODOT has a staff shortage in AR due to turnover of staff. Payments have been posted in error causing aging to be off. Reconciliation of the initial load of County Leases is still in progress. ODOT is not using functionality implemented last October ( Accelerated AR/BI - Outdoor Advertising, Tuition, etc.	Currently 2 positions are being recruited. Working with Ciber on reconciliation as time permits (required for GAAP). Mark will continue support on County Leases and Deposits until new hires come on. Mark will have to train staff when hired.