Business Application Services (CORE) Publications - Executive Board Meeting May 3, 2010

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

Slide 1

BAS Executive Board May 3, 2010
Next CEB Scheduled - June 2, 2010

Slide 2

Agenda

• SQL Requests/Problem Management Summary
• Completed Projects
• Portfolio
  • Budget Status
  • 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

	April 2009	May 2009	June  2009	July 2009	Aug 2009	Sept 2009	Oct 2009	Nov 2009	Dec 2009	Jan 2010	Feb 2010	March 2010
ARBI	0	0	0	0	0	0	0	1	0	0	1	0
CRM	2	0	0	0	0	0	0	1	0	0	0	0
DBA/System	0	0	0	0	0	0	0	0	0	0	4	0
Procurement	8	3	9	4	1	5	2	0	0	0	0	0
HRMS	18	10	11	7	24	13	10	3	6	10	12	14
Financial	28	14	16	15	14	10	4	14	8	8	6	0
Financials	0	0	0	0	0	0	0	0	0	0	0	1
EPM	2	4	1	2	0	1	0	0	0	1	0	0
ELM	0	0	0	0	1	0	0	0	0	0	0	0
Purchasing	0	0	0	0	0	0	0	0	4	8	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	11	4	1	4	1	1
PO	2	2	0	0	0	0
HCM	13	10	0	0	3	0
DBA/System	2	0	1	0	0	1
Total	28	16	2	4	4	2

Slide 5

Completed Project, since last BAS Executive Board

Asset Management Pilot, Schedule (Green); Budget (Green)

 

Slide 6

Portfolio Priority 1-14

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	Execution	1
Time and Labor Pilot	Alex / Kim	BAS	Human Capital Mgmt	Execution	2
Commitment Accounting - Rollout	Michael Grisser	BAS	Human Capital Mgmt	Execution	3
Asset Mgmt - Pilot	Alex / Kim	BAS	Assets	Execution	4
Grants, Projects, Contracts, AR Billing - Oklahoma Department of Transportation /Oklahoma Economic Security Commission (ODOT/OESC)	Alex / Kim	BAS	Enterprise Service Automation	Execution	5
Time & Labor Manager Self Service ODOT Pilot	Alex / Kim	BAS	Enterprise Service Automation	Execution	6
People Soft Extract Staging Environment	Lisa McKeithan	BAS	Other	Execution	7
Inventory Pilot Department of Mental Health	Alex/Kim	BAS	Supply Chain Management	Execution	8
AP Workflow	Michael Grisser	BAS	Financial Mgmt	Planning, Execution	9
Higher Education Interface	Lisa McKeithan	BAS	Human Capital Mgmt	Planning, Execution	10
HCM Functionality Enhancements	Michael Grisser	BAS	Human Capital Mgmt	Execution	11
Inventory - ODOT	Alex / Kim	BAS	Supply Chain Mgmt	Execution	12
Grants, Projects, Contracts, AR Billing, ODOC/DEQ	Alex / Kim	BAS	Enterprise Service automation	Planning, Execution	13
Business Intelligence, Financials Analytics	Lisa McKeithan	BAS	Other	Planning	14

Slide 7

Portfolio Priority 14-26

Project Name	Project Manager	Dept	Function	Current Project Phase	Priority within Function
Employee Self Service Rollout	Michael Grisser	BAS	HCM	Execution	15
Travel & Expense EFT	Steve Wilson	DCAR	Financial Mgmt	Execution	16
OpenBooks Phase III	Lisa McKeithan	BAS	Other	Planning	17
Asset Mgmt - Rollout	Michael Grisser	BAS	Assets	Planning, Execution	18
Grants - Provisioning	Lisa McKeithan	BAS	Other	Planning	19
Licensing	Lisa McKeithan	BAS	Other	Planning	20
Treasury General Ledger Implementation	Alex	BAS	Financial Mgmt	Execution	21
eBill Payment	Lisa McKeithan	BAS	Financial Mgmt	Concept	22
BI - CAFR	Lisa McKeithan	BAS	Other	Concept	23
Scanning and Bar-coding for Phase II modules	Alex	BAS	Assets	Concept	24
DCS Vendor Registration	Lisa McKeithan	BAS	Supply Chain Management	Execution	25
EFT Remit Advices	Lisa McKeithan	BAS	Accounts Payable	Planning, Execution	26
Federal Funding Accountability and Transparency Act (FFATA)	Lisa McKeithan	BAS	Accounts Payable	Concept	27
PeopleTools 8.49	Mike Jorski	AppDEV	FIN + CRM + EPM	Initiation, Planning	28

Slide 8

Projects in Execution Delivery Schedule

• HCM Funtionality Enhancements - January 2010-May 2010
• EFT Remit Advices - April 2010-June 2010
• PS Extract Staging Environment - January 2010-June 2010
• Commitment Accounting Rollout - September 2009-June 2010
• Backfill Developers - June 2009-June 2010
• Inventory Pilot Department of Mental Health - April 2010-July 2010
• ODOT/OESC Grants/Projects/Contracts/Accounts Receivable/Billing - July 2009-July 2010
• Inventory ODOT - August 2009-July 2010
• Time & Labor MSS ODOT Pilot - March 2010-July 2010
• Time & Labor Pilot - June 2009-July 2010
• DCS Vendor Registration - December 2009-August 2010
• Treasury General Ledger Implementation - April 2010-December 2010
• Grants/Projects/Contracts/Accounts Receivable/Billing Time & Labor Extended, Commerce, Department of Environmental Quality - March 2010-December 2010
• Asset Management Rollout - April 2010-August 2011
• Higher Education Interface - May 2010-October 2011

Slide 9

Detailed Milestone Plan, BAS - 2602 AP Workflow

The project will focus on a basic implementation of workflow for the Accounts Payable (AP) module for pilot agencies ODOT, OESC and Office of State Finance (OSF). ODOT and OESC will enter vouchers into control groups and submit the vouchers for workflow approvals. there will be a maximum of three workflow approval steps.

Milestone Plan (+/- 10%)

• Fits/Functional Design. (Task, April-May 2010)
• Technical development. (Task, May 2010)
• Functional build/role mapping. (Task, May 2010)
• Integration testing. (Task, June 2010)
• Prepare for and conduct User Assisted Testing (UAT). (Task, June 2010)
• Production setup. (Task, June-July 2010)
• Go live. (Milestone, July 2010)

Issues

• Immediate approval required to meet dates.
• State resources to be identified and confirmed.

Slide 10

Detailed Milestone Plan,  2676 - OpenBooks Phase III

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

Milestone Plan (+/- 50%)

• Design and build extracts to data staging environment. (Task, April-May 2010)
• Design data warehouse. (Task, May-June 2010)
• Design website. (Task, May-July 2010)
• Build website. (Task, June-September 2010)
• Deploy. (Milestone, October 1, 2010)

Issues, Assumptions

• Schedule includes interruptions for staff functions including training, ARRA reporting period, etc.
• AP workflow will delay this timeline.
• Financials Analytics will not start until after this project is completed.

Slide 11

Detailed Milestone Plan, AppDev-2611 PeopleTools 8.49

Upgrade the BAS FIN, CRM & EPM systems to PeopleTools 8.49. See notes below as this project now only includes the PeopleTools upgrade in the application.

Milestone Plan (+/- 10%)

• Prepare change assistant and stage software - 2 days. (Task, August 2010)
• EPM non-production environments (dmo, tst, qa) & test - 3 weeks. (Task, August-September 2010)
• EPM production - (prd) 1 day. (Task, September 2010)
• EPM development (dev) - 2 days. (Task, September 2010)

Issues

• CRM will de done with the CRM ITIL project (when?)
• EPM will be done separately. September is earliest it can be started due to seasonal business activity.
• FIN will be done with the 2010 Bundle project

Slide 12

Program Status

HCM

Slide 13

BAS – 1080 Higher Education Payroll

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

Key Activities

Task	Start	End
System Testing - test script preparation and validation and system testing	5/32010	8/31/2010
User Acceptance Testing - includes conversion and parallel runs for the University of Oklahoma (OU)	9/1/2010	15/15/2010
Production preparation	10/16/2010	10/31/2010
Production - OU	11/1/2010	11/1/2010

 

Requires Awareness:

Statement of Work (SOW) has been signed and Purchase Order (PO) prepared. OU will be the pilot agency and will participate in all testing phases. UAT will consist of running conversion process and parallels for OU which should provide final sign-off on system readiness. OU is unavailable during parts of August and September due to extra workload for fall semester.

Slide 14

BAS – 2581 Time and Labor

• Status: Integration testing complete for OESC. UAT in progress. Integration Acceptance awaiting ODOT.

Key Activities

Task	Start	End
UAT - OESC & Statewide	4/12/2010	4/30/2010
Intgration Testing - ODOT (see awareness)	4/19/2010	5/14/2010
System Roll - OESC	5/3/2010	5/16/2010
Go Live - OESC		5/17/2010
UAT - ODOT	5/24/2010	6/18/2010

 

Requires Awareness:

BAS integration has not started.

Slide 15

BAS – 2636 Commitment Accounting Rollout

• Status: GREEN
• Roll out plan is progressing as scheduled. Group F successfully converted and payrolls processed. Group G being prepared for the May roll out.

Key Activities

Task	Percentage Complete	Start	Finish
Group F Roll Out	100	1/21/2010	4/30/2010
Group F Question & Answer (Q&A) Session	100	3/16/2010	3/16/2010
Group G Q&A Session	100	4/13/2010	4/13/2010
Group G Roll Out	25	2/8/2010	5/30/2010
Group H Q&A	0	4/26/2010	4/26/2010
Group G Training	0	4/26/2010	4/29/2010
Group G Conversion	0	5/15/2010	5/16/2010
Group H Conversion	0	5/22/2010	5/23/2010
Group I Conversion - Human Resource data only	0	6/5/2010	6/6/2010

 

Requires Awareness:

No issues at this time.

Slide 16

Commitment Accounting Rollout Statistics

Group	Conversion Date	Agencies	Number of Employees
A	9/15/2009	5	4,230
B	12/13/2009	19	3,812
C	1/16/2010	14	3,885
D	2/13/2010	18	3,393
E	3/13/2010	8	5,493
F	4/17/2010	43	5,000
Total Live		107	25,813
G	5/15/2010	19	5,125
H	5/22/2010	1	8,571
I	6/5/2010	1	526

Slide 17

BAS – 2667 HCM Functionality Enhancements

• Status: GREEN
• All Functional specs are completed. All Technical specs are completed. Enhanced Search Match is complete and has been released to all system users. Salary Survey are in User Acceptance Testing. SQR reports are still being developed and tested.

Key Activities

Task	Percentage Complete	Start	End
ODOT - Completed Location table updates as well as updates to job and position with the new locations	100	1/1/2010	1/15/2010
Enhanced Search Match	100	3/1/2010	4/15/2010
Salary Surveys	80	1/1/2010	5/7/2010
Queries (71%) and Reports	80	1/1/2010	5/12/2010
Implement Badge Functionality	100	4/5/2010	5/14/2010

Slide 18

Service Catalog Requests - Employee Self Service Rollout

	Agencies	Number of Employees
Live on systems as of 4/1/2010	94	25,663
Scheduled after 4/1/2010	16	3,591
Exempted/Legislative/Judicial	7	10,021
Total live/scheduled/exempted	117	39,275
To be completed/scheduled	11	439
Target	128	39,714

Slide 19

BAS – 2674 Manager Self Service ODOT / Pilot

• Status: GREEN
• Project will be in two phases: (1) limited salary personnel April 24 and (2) all non-Agile Asset personnel will go at same time as Projects go-live.

Key Activities

Task	Percentage Complete	Start	End
Go-Live Limited Pilot	100	4/24/2010	4/24/2010
Requirements - Full Implementation	100	3/23/2010	4/7/2010
User Acceptance	0	5/24/2010	5/29/2010
Train the Trainer	0	5/24/2010	6/1/2010
Go Live	0	To Be Determined (TBD)	TBD

 

BASSlide 20

Program Status

Financials

Phase II Modules

Slide 21

BAS – 2675 Data Staging Environment

• Overall Issues Status: Green
• Build staging environment containing PeopleSoft extracts that will be used by ODOT.

Key Activities

Task	Start	Finish	ODOT Access
Development: Contracts (0513) and Project Costing (0514) are still in Development.	2/15/2010	5/14/2010	N/A
AP Alltrans (0287) - OSF Testing	4/19/2010	5/14/2010	4/28/2010
Deposit Alltrans (0515) - OSF Testing	4/19/2010	5/14/2010	4/28/2010
Vendors (0152) - OSF Testing	4/26/2010	5/28/2010
AR/Billing (0512) - OSF Testing	4/26/2010	5/28/2010
Assets (0523) - OSF Testing	4/26/2010	5/28/2010
Purchase Orders (0234) - OSF Testing	4/26/2010	5/28/2010
Production - GL alltrans (0188) & Setup Tables (02235)	4/26/2010	6/30/2010	4/28/2010

 

Requires Awareness:

Gave Phil access to FSDEV so he has access to tables as soon as OSF staff does; he can begin his development/testing as we are testing.

Slide 22

BAS – 2680 EFT Remit Advices

• Overall Issues Status: GREEN
• Merkur has software that works with delivered PeopleSoft functionality to email remit advices to vendors for electronic payments. This alleviates the need for agencies to mail invoices that typically arrive several days after money is deposited into a bank account. This will streamline processing for vendors.

Key Activities

Task	Start	Finish
Finalize Contract and Requisition for Merkur	4/21/2010	5/21/2010
Configuration and Setup	5/31/2010	6/04/2010
Customization of Remit Advices	5/31/2010	6/4/2010
Testing	6/7/2010	6/11/2010
Production	6/14/2010	6/14/2010

 

Requires Awareness:

Will work with transaction Processing and Security teams to identify any necessary changes to the delivered remit advices so that it will meet state standards.

Slide 23

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
Finalize SOW and Interagency Agreement	4/15/2010	4/23/2010
Development	4/19/2010	5/31/2010
Testing	5/10/2010	6/30/2010
Documentation	5/10/2010	6/30/2010

 

Requires Awareness:

Development request have been completed. Routing for signatures. SOW (Innovativ) and DCS Interagency Agreement have been sent to DCS. Development is in progress - ok.gov and Innovativ.

Slide 24

BAS – 2665 Asset Management Rollout   

• Overall Issues Status: GREEN
• Project approved in last CEB Meeting but will not make much progress until July after the DMH Inventory Implementation is completed.

Key Activities

Task	Start	Finish
Prepare for and conduct project kick off	TBD	TBD
Configure and verify agency conversion data	7/16/2010	10/5/2010
Perform test loads	8/26/2010	9/15/2010
Train agency users	9/17/2010	10/5/2010

 

Requires Awareness:

DCS resource is not committed to the project.

Slide 25

BAS – 2682 Inventory Pilot - Department of Mental Health (DMH)

• Overall Issues Status: Green
• Project started. DMH currently cleaning up inventory item IDs.

Key Activities

Task	Start	Finish
Kick-off meeting	3/15/2009	3/15/2009
User Cleanup	3/15/2010	4/30/2010
Conversion Testing	5/1/2010	5/14/2010
User Testing / Training	5/17/2010	6/14/2010
System Configurations and Conversion	6/14/2010	6/30/2010
Go-Live	7/1/2010	7/1/2010

Slide 26

BAS – 2692 Treasury General Ledger Implementation

• Overall Issues Status: Green
• Project Kick Off was held April 21

Key Activities

Task	Start	Fininsh
Prepare for and conduct project kick off	4/12/2010	4/21/2010
Prepare for and conduct and document business process analysis sessions	4/21/2010	4/30/2010
Prepare for and conduct and document fit analysis sessions	5/3/2010	5/27/2010
Define statement of work	5/28/2010	7/2/2010

Slide 27

BAS - 2599 Grants, Projects, Contracts with Accounts Receivable, Billing

Status: The team is in user acceptance testing for statewide and OESC.

 

Key Activities

Task	Start	Finish
UAT - OESC & Statewide	4/12/2010	4/30/2010
Integration Testing - ODOT (see below)	4/19/2010	5/14/2010
System Roll - OESC	5/3/2010	5/16/2010
Go Live - OESC		5/17/2010
UAT - ODOT	TBD	TBD

 

Requires Awareness:

Go live is scheduled for: OESC - 5/27/2010, on target; ODOT, TBD. Tentative date for starting ODOT Integration Testing was April 19; not yet started.

Slide 28

BAS - 2610 Inventory ODOT 

Status: Integration testing not started.

Key Activities

Task	Start	Finish
Integration Testing (see below)	4/19/2010	5/14/2010
Prepare for User Acceptance Testing	5/15/2010	5/23/2010
User Acceptance Testing	5/24/2010	6/18/2010
Go Live		TBD

 

Requires Awareness:

Integration Testing not started. Testing is still in TST2.

Slide 29

ODOT Phase II Update

Key Activities

Milestone	Target	Complete
Accelerated OSF/ODOT AR/BI	10/30/2009	10/30/2009
Commitment Accounting	12/14/2010	12/14/2010
Time and Labor Life	1/10/2010	1/10/2010
Leave Conversion	1/10/2010	1/10/2010
Deposits	1/18/2010	1/18/2010
Item Maintenance	1/19/2010	1/19/2010
Bi-Weekly	1/20/2010	01/20/2010
Contracts - County Leasing	4/1/2010	4/1/2010
Asset Management Pilot Rollout	TBD
Inventory	TBD
Grants, Projects, Contracts	TBD
Time & Labor with Project Costing	TBD
Agile Assets	TBD
Manager Self Service - Phase 2	TBD

Slide 30

Phase II Integration Testing

Open Bugs by Week Ending Date

Statewide / OESC Grants, Projects, Contracts, Accounts Receivable, Billing

Definitions: Block, The functional team is stopped pending resolution; Crash, program will not execute; Major, must be fixed before UAT and Production; Minor, not critical for going live; Feature, nice but not critical for going live.

Week ending 2/27/2010: Block, 1; Major, 2; Tweak, 1 - Statewide, OESC Grants, Projects, Contracts, AR, Billing  integration testing.

Week ending 3/6/2010: Block, 1; Major 3; Tweak, 1 - - Statewide, OESC Grants, Projects, Contracts, AR, Billing  integration testing.

Week ending 3/13/2010: Block, 1; Major 7; Minor, 1 - Statewide, OESC Grants, Projects, Contracts, AR, Billing  integration testing.

Week ending 3/20/ 2010: Block, 3; Major 6; Minor, 1 - Statewide, OESC Grants, Projects, Contracts, AR, Billing  integration testing.

Week ending 3/27/2010: Block, 6; Major 6; Minor, 1; Feature, 1 - Statewide, OESC Grants, Projects, Contracts, AR, Billing  UAT Prep.

Week ending 4/3/2010: Block, 5; Major, 10; Minor, 1; Feature, 1 - Statewide, OESC Grants, Projects, Contracts, AR, Billing  UAT Prep.

Week ending 4/10/2010: Block, 2; Major, 3 - Statewide, OESC Grants, Projects, Contracts, AR, Billing  UAT Prep.

Week ending 4/17/2010: Block, 1; Major; 3; Minor, 1 - Statewide, OESC Grants, Projects, Contracts, AR, Billing  UAT.

Week ending 4/24/2010: Minor, 2; Major, 2 - ODOT integration testing.

Week ending 5/1/2010: Major 2, Minor 2 - ODOT integration testing.

Slide 31

Phase II Integration Bug Trend

Open Bugs on 5/1/2010

Billing: Block, 1.

Human Resources: Major, 1.

Project Costing: Minor, 1.

Payroll: Major, 1.

Time and Labor: Minor, 1.

Slide 32

ODOT Development Requests in Integration Testing, Testing and Development 

Week ending 3/20/2010: Integration Testing, 2; Testing, 9; Development, 26.

Week ending 3/27/2010: Integration Testing, 2; Testing 12; Development, 23.

Week ending 4/3/2010: Integration Testing, 2; Testing 19; Development, 15.

Week ending 4/10/2010: Integration Testing, 2; Testing 19; Development, 17.

Week ending 4/17/2010: Integration Testing, 3; Testing 23; Development, 31.

Week ending 4/24/2010: Integration Testing, 3; Testing 24; Development, 29.

Week ending 5/1/2010: Integration Testing, 3; Testing 41; Development, 12.

Integration testing - 4/19/2010.

Prepare for UAT - 5/15/2010.

UAT - 5/24/2010.

Prepare for and conduct FWHA audit - 5/24/2010

Issue resolution and System Rollout - 6/21/2010.

Go live - 7/3/2010.

Slide 33

Application Enhancement Service Request

August 2009: Pending, 63; Development, 27; User Test, 30; Completed 6.

September 2009: Pending, 58; Development, 35; User Test, 17; Completed, 16.

October 2009: Pending, 56; Development, 33; User Test, 23; Completed, 14.

November 2009: Pending, 64; Development, 36; User Test, 23; Completed, 12.

December 2009: Pending, 54; Development, 47; User Test, 27; Completed, 8.

January 2010: Pending, 59; Development, 42; User Test, 26; Completed, 16. 

February 2010: Pending, 72; Development, 37; User Test, 26; Completed, 9.

March 2010: Pending, 79; Development, 25; User Test, 23; Completed.

April 2010: Pending, 122; Config/Setup, 1; Development, 27; UAT, 16; Completed, 19.

Slide 34

Application Enhancement Service Request Summary - April 2010

(3/26 - 4/30)

	Pending	Development	Configuration/ Setup	User Test	Completed
May
June
July
August	63	0	27	30	6
September	58	0	35	17	16
October	56	0	33	23	14
November	64	0	36	23	12
December	54	0	47	27	8
January	59	0	42	24	16
February	72	0	37	26	9
March	79	0	25	23	17
April	122	1	27	16	19

Slide 35

Application Enhancement Service Request Detail - April 2010

(3/26 - 4/30)

 

Problem Mgmt		Pending	Config/Setup	Dev	UAT	Completed
	CRM	0	0	0	0	0
	ELM	0	0	0	0	0
	EPM	0	0	0	0	0
	FIN	3	0	0	1	1
	HCM	5	0	1	6	4
	Total	8	0	1	7	5

 

Service Requests		Pending	Config	Dev	UAT	Completed
	CRM	1	0	2	0	0
	ELM	3	0	0	0	1
	EPM	1	0	0	0	0
	FIN	21	0	12	4	6
	HCM	88	1	12	5	7
	Total	114	1	26	9	14

 

		Pending	Config	Dev	UAT	Completed
	Overall Total	122	1	27	16	197

 

Slide 36

Planned Enhancement Service Requests (ESR) On Time Completion

Based on 60-day plan

March 2010 - 2 ESRs not completed; 6 ESRs completed; 5 unplanned ESRs completed.

Slide 37

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
Backfill Developers for Production Support & Enhancements	Execution	Green	6/15/2009	12/18/2009	6/30/2010	Green
Time & Labor Pilot	Execution		3/1/2010	7/31/2010	7/31/2010
Commitment Accounting Rollout	Execution	Green	9/1/2009	06/30/2010	6/30/2010	Green
Asset Management Pilot	Close	Green	6/1/2009	4/14/2010	4/14/2010	Green
Grants, Projects,Contract Accounts Receivable Billing ODOT/OESC	Execution		7/1/2010	7/31/2010	7/31/2010
Time & Labor Manager Self Service ODOT Pilot	Execution	Green	3/1/2010	7/31/2010	7/31/2010	Green
PeopleSoft Extract Staging Environment	Execution	Green	1/14/2010	6/18/2010	6/18/2010	Green
Inventory Pilot Department of Mental Health	Execution	Green	4/15/2010	7/31/2010	7/31/2010	Green
AP Workflow	Planning, Execution	Green	5/3/2010	7/16/2010	7/16/2010	Green

Slide 38

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
Higher Education Interface	Execution	Green	4/1/2010	10/31/2011	10/31/2011	Green
HCM Functionality Enhancements	Execution	Green	1/4/2010	5/28/2010	5/28/2010	Green
Inventory ODOT	Execution		3/1/2010	12/31/2010	12/31/2010
Grants, Projects,Contract Accounts Receivable Billing Commerce, Department of Environmental Quality	Execution	Green	3/1/2010	12/31/2010	12/31/2010	Green
Business Intelligence - FS Analytics	Planning	Red	4/1/2009	7/31/2009	7/31/2009	Green
Asset Management Rollout	Execution	Green	4/19/2010	7/31/2011	7/31/2011	Green
Grants - Provisioning	Planning	Red	7/31/2008	7/15/2009	5/29/2010	Green
Licensing	Planning	Red	12/1/2008	8/15/2009	5/15/2010	Green
Treasury General Ledger Implementation	Execution	Green	4/12/2010	12/31/2010	12/31/2010	Green
Scanning, Barcoding functioning for Phase II Modules	Concept
DCS Vendor Registration	Execution	Green	12/1/2009	8/31/2010	8/31/2010	Green

Slide 39

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
EFT Remit Advices	Execution	Green	4/12/2010	6/15/2010	6/15/20108/31/2010	Green
OpenBooks - Phase III	Initiation, Planning	Green	4/19/2010	5/30/2010	5/30/2010	Green
PeopleTools 8.49	Initiation, Planning	Green	3/9/2010	4/30/2010	4/20/2010	Green

Slide 40

Issues

Issue	Status
Need improved coordination between all Teams (DCS, ODOT, BAS) to get the new items setup, assigned to contracts and PO's.	Project plan has been created.
BAS will be involved in the integration testing and UAT. This includes fixing bugs. BAS resources are required to finish the OESC project (live date May 17).	Daily meetings between the CORWE and ODOT project managers are occurring to address project blockers as quickly as possible. Weekly meetings are held to review project issues.
DCS resources for the Asset rollout are not committed	We will need to obtain the appropriate resource or re-baseline the project
BAS team is supporting an increased number of services. The team does not currently have the capability and capacity to support these services. Current plans include in FY 2011.	Analyze team capability and capacity verses 2011 plans and create a plan to improve self sufficiency.