visit OK.gov OMES: Chief Information
Officer (CIO)
Skip to Content   Contact Information  |  News Room  |  RSS Feeds
  • Home
  • Overview
  • Customer Portal
  • Business Segments
  • Procurement
  • Policy and Standards
  • Careers
  • Share
    • Email to a Friend
    • Subscribe to eGov News
    • Blinklist
    • Blogger
    • Del.icio.us
    • Digg
    • Facebook
    • Google Bookmarks
    • Linked In
    • Myspace
    • Stumble Upon
    • Twitter
    • Yahoo Bookmarks
Home / Customer Portal / Business Application Services Essentials / Publications / Business Application Services (CORE) Executive Board - September 22, 2010

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

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

Slide 1

BAS Executive Board September 22, 2010
Next CEB Scheduled - October 27, 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

SQL Requests in Total September 2009 to August 2010
  Sept 2009 Oct 2009 Nov 2009 Dec 2009 Jan 2010 Feb 2010 March 2010 April 2010 May 2010 June 2010 July 2010 August 2010
ARBI 0 0 1 1 0 0 0 0 0 0 0 0
CRM 0 0 1 1 0 0 0 0 0 0 3 0
DBA/System 0 0 0 0 0 4 4 2 0 0 4 7
Procurement 5 2 0 0 0 0 0 0 0 0 0 0
HRMS 13 10 3 6 10 12 14 15 11 11 11 10
Financial 10 4 14 8 8 6 1 2 7 8 2 4
EPM 1 0 0 0 1 0 0 0 0 0 1 0
ELM 0 0 0 0 0 0 0 0 0 0 0 0
Purchasing 0 0 0 4 8 8 0 2 0 0 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 15 9 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 38 22 6 4 4 2

Slide 5

Portfolio Priority 1-17
Project Name Project Manager Dept Function Current Project Phase Priority within Function
Backfill Developers for Production Support and Enhancements 2011 Fred Cantrell BAS Financial Mgmt + Human Capital Mgmt Execution 1
Time and Labor Pilot/ Oklahoma Department of Transportation (ODOT) Alex / Kim BAS Human Capital Mgmt Execution 2
Department of Central Services (DCS) Vendor Registration Lisa McKeithan BAS Supply Chain Management Execution 4
P-Card - Bank of America (BOA) Transition Lisa McKeithan BAS Financial Management Execution 5
Grants, Projects, Contract (GPC),  Account Receivable Billing, Time &Labor  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 CORE FIN, CRM, EPM Execution 8
Inventory -  ODOT Alex / Kim BAS Supply chain management Execution 9
Assets - ODOT Alex BAS Financial management 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 (GL) 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
OpenBooks - Phase III Lisa McKeithan BAS Other Execution 16
Asset Management Rollout Michael Grisser BAS Assets Execution 17

Slide 6

Portfolio Priority 18-24
Project Name Project Manager Dept Function Current Project Phase Priority within Function
data.gov Lisa McKeithan BAS Transparency Initiation 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 Execution 21
Scanning and Bar-coding for Phase II modules Alex BAS Assets Concept 22
Loan Processing       Initiation 23
Expense Module Alex/Kim BAS Financial management Planning, Execution 24
Budget Lisa McKeithan BAS Other Concept, Initiation 25

Slide 7

Projects in Execution Delivery Schedule

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

Slide 8

Detailed Milestone Plan, 2833 - ODOC Loans Processing

Two options for implementing the Contracts module functionality are presented in this document: Options #1 involves the development of a conversion process to convert open contract (Loan) definitions into PeopleSoft. After the Contract definitions are loaded, Contract Billing and Receivables history will be converted using the standard BAS conversion methodology. Option #2 involves he agency converting open Contract definitions manually.

Milestone Schedule +/- 50%

  • Project Start (Milestone, mid-November 2010)
  • Prototype Review (Task, late-November 2010)
  • Development (Task, late-November-December 2010)
  • Integration Testing / User Acceptance Testing/Training (Task, late-December 2010-January 2011)
  • Roll out/Conversion (Milestone, January 31, 2011)

Issues

ODOC HP System needs to be replaced.

Slide 9

Program Status

Human Capital Management

Slide 10

BAS - 1080 Higher Education Payroll

  • Status: Yellow
  • Convert higher education agencies from the legacy payroll system to the PeopleSoft system.
 Key Activities
Task Start Finish
Configuration - 95% complete 7/1/2010 11/1/2010
Conversion Scripts - 75% complete 7/1/2010 11/1/2010
Finish Human Resources (HR) Interfacing Debugging/Testing 7/1/2010 11/1/2010
Complete PY Interface Coding/Debugging/Testing 9/10/2010 12/15/2010
UAT to begin with OU 1/1/2011 1/26/2011
Key Overall Issues
Requires Awareness:
  • Functional consultant left company, a Maximus replacement is on site.
  • Using remaining budget from Innovative and reducing the project backfill amount to fund functional consultant.
  • Re-assessed resources and timeline for implementing OU while maintaining the overall project schedule.
  • Loss of OU involvement in August and September.
  • If OU does not meet minimum requirements in new Roles and Responsibilities, plan will slip.

Slide 11

BAS - 2666 Grants, Projects Contracts with AR/Billing Monthly Extended Time and Labor

  • Status: Green
  • The team is in the process of finalizing integration testing and preparing for User Acceptance Testing.
Key Activities
Task Start Finish
Integration Testing 8/4/2010 9/10/2010
Preparation for User Acceptance Testing 8/27/2010 9/17/2010
User Acceptance Testing 9/13/2010 10/18/2010

Slide 12

BAS - 2637 ELM Rollout

  • Status: Green
  • Rollout of ELM to agencies to be completed in three groups (original plan); Group A consisted of Department of Career & Technology (800), CompSource Oklahoma (390), ODOT (345), Courts (199, 219, 220, &677), Oklahoma Developmental Disabilities Council (a division of (830). Group A go-live date is 11/30/2010.
  • Confirmed agencies: Group A: Career Tech (800), ODOT (345), Oklahoma State and Education Employees Group Insurance Board (OSEEGIB) (516); Group B: Office of Personnel Management (OPM) (548), State Department of Health (340)
  • Declined Agencies - Firefighters (C); Courts (A)
Key Activities
Task Start End
Kickoff meeting with rollout agencies 8/25/2010 8/25/2010
Set up learning environments 9/1/2010 10/25/2010
Load HCM Data in Prod for messaging to LM Prod (email & reports to information. 9/20/2010 10/10/2010
Train agency SME's on config and setup for testing 10/10/2010 11/30/2010
Set up Prod Environments 11/1/2010 11/25/2010
Go Live 11/30/2010 11/30/2010
Key Overall Issues
Requires Awareness:
  • No decision from CompSource (A), ODDC (A), OSF (C), DCS (C).
  • Firefighters (C) has declined, Office of Emergency Management (OEM) (C) may take their place.
  • If other agencies back out, we will continue to find others to replace them or move to the next phase of the project (SCORM).

Slide 13

Program Status

Financials

Phase II Modules

Slide 14

BAS – 2611 PeopleTools 8.49

  • Status: GREEN
  • Project started on time.
  • However, we lost four days because the hard drive went out on Greg Linn's PC. Greg's PC has been rebuilt and he is progressing.
Key Activities
Task Start Finish
Prepare Change Assistance & Stage Software, 100% complete 8/30/2010 8/31/2010
Upgrade & test non-prod EPM environments, 5% complete 9/7/2010 9/24/2010
Upgrade EPM production environment 9/25/2010 9/25/2010
Upgrade EPM development environment 9/27/2010 9/28/2010
Key Overall Issues
Requires Awareness:
  • It will be tight with the loss of four days, but if there are not a lot of issues to deal with during testing, then we might be able to catch up to the project schedule.

Slide 15

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 To Be Determined (TBD) TBD
Contracts (0513) & Billing (0512) have been re-migrated to FSTST2 and is ready for functional testing. 6/25/2010 TBD TBD
Sign-off on Phase Modules   TBD TBD
Key Overall Issues
Requires Awareness:
  • Waiting on testing resources from ODOT.

Slide 16

BAS - 2681 DCS Vendor Registration

  • Status: Red
  • Build interfaces between ok.gov and PeopleSoft for validation and upload of vendor/bidder data into PeopleSoft.
Key Activities
Task Start Finish Estimated 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 9/30/2010
Development/Testing - Bidder to Vendor Update 5/10/2010 8/31/2010 10/15/2010
Review/Revise process - OSF & DCS 7/31/2010 7/31/2010  
Key Overall Issues
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.
  • Status has changed to Red due to two remaining items.

Slide 17

BAS- 2676 OpenBooks Phase III

  • Status: Green
  • Utilize Oracle Business Intelligence Enterprise Edition (OBIEE) for OpenBooks reporting. Update American Recovery and Reinvestment Act (ARRA) reporting per Senate Bill 1759.
Key Activities
Task Start Estimated Completion Finish
ARRA updates 7/1/2010 9/15/2010 8/26/2010
Expenditure and Funding (Build Data Interface Module (DIM)/Create Reports/Test) 10/1/2010 12/31/2010 January 2011
Pcard (Load/Build DIM/Create Reports/Test/Automate) 6/1/2010 10/31/2010 January 2011
Vendor Payments (Build DIM/Create Reports/Test) 8/1/2010 9/30/2010 January 2011
Payroll (Load/Build DIM/Create Reports/Test/Automate) 8/1/2010 12/31/2010 January 2011
Go-Live     January 2011
Key Overall Issues
Requires Awareness:
  • Determine approach for the file transfer/load.
  • Possible upgrade to v11 (XML export functionality.
  • Financials Analytics will not start until this is complete.
  • Potential Conflicts:
    • ARRA Reporting (October)
    • Federal Funding Accountability and Transparency Act (FFATA)

Slide 18

BAS - 2800 PCard Transition to Bank of America (BOA)

  • Status: Green
  • Build interfaces between ok.gov and PeopleSoft for validation and upload of vendor/bidder data into PeopleSoft.
Key Activities
Task Start Finish
General Ledger Export (0613) Segment values and combo code values 8/30/2010 9/30/2010
Voucher Build (0614) 8/30/2010 10/31/2010
1099 processing (0xxx) 8/30/2010 12/31/2010
Key Overall Issues
Requires Awareness:
  • DCS will have some cardholders as a pilot starting in October. Their initial GL segment values and combo values have already been loaded into the production site.
  • Statewide implementation is scheduled for November/December.

Slide 19

BAS - 2665 Asset Management Rollout

  • Status: Green
  • Meetings to be held to prepare for Kickoff Session. Replacement consultant is on board. Consultant will be working on ODOT Assets and the AM Rollout. Brenda is working with DCS to get a resource for four days a week. Looking at changing the plan to do small agencies (<100 assets) first. If we do small agencies we will be doing an incremental rollout.

 

Key Activities
Task Start Finish
Prepare for and conduct project kickoff TBD TBD
Configure and verify agency conversion data 9/16/2010 11/5/2010
Perform test Loads 10/26/2010 11/15/2010
Train agency users 11/17/2010 12/5/2010
Key Overall Issues
Requires Awareness:
  • DCS resource is not committed to the project - Brenda is working to get a resource committed (four days a week). If no DCS resource, rollout plan will need to be adjusted or possibly put the project on hold.
  • Brenda to also assist with agency buy in to rollout plan.
  • Evaluating the new AM consultant to be sure he meets the needs of the project.
  • Will need to re-verify the plan timelines once the resources issues are resolved.

Slide 20

BAS - 2692 Treasury GL Implementation

  • Status: Green
  • The team is in the process of creating business process flows, validating design, finalizing configuration and creating the development requests. Test scripts are being written in preparation for business process testing.
  • The team is currently behind schedule regarding requirements and configuration. A plan for getting back on track is being created.
Key Activities
Task Start Finish
Create Business Process Flows, Reconciliation Points, Checklists 7/6/2010 8/19/2010
Create Development Requests 8/2/2010 8/20/2010
Preparing for Business Process Testing 8/27/2010 9/3/2010
Business Process Testing 9/7/2010 9/17/2010
Key Overall Issues
Requires Awareness:
  • Office of the State Treasurer has requested that their go-live date be moved to a month-end. Rather than go live on 11/15/2010 they would like to look at either 10/31/10 or 12/31/2010.

Slide 21

BAS - 2810 Assets ODOT

  • Status: Green
  • On schedule.
Key Activities
Task % Complete Start Finish
Clean-up and format asset conversion data for FY 2010 100 7/1/2010 8/13/2010
Prepare for integration testing 100 8/16/2010 8/27/2010
Perform integration testing   8/30/2010 9/24/2010
Prepare for User Acceptance Testing   9/27/2010 10/4/2010
Perform User Acceptance Testing   10/5/2010 10/22/2010

Slide 22

BAS - 2581 Time and Labor

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

Key Overall Issues

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

Slide 23

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 24

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 25

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 26

Application Enhancement Service Requests

  • 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; UAT, 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, Functional, 37; Development, Tech, 22, Functional, 1; UAT, Tech, 11, Functional 1; Closed, Tech, 13, Functional, 10.
  • July 2010 - Pending, Tech, 90, Functional, 28; Development, Tech, 21, Functional, 12; UAT, Tech, 6; Closed, Tech, 13, Functional, 13.
  • August 2010 - Pending, Tech, 85, Functional, 27; Development, Tech, 20, Functional, 12; UAT, Tech 9, Functional, 2; Closed, Tech, 13. Functional 7.

Slide 27

Current Application Enhancement Service Requests - August 2010

 

 

Functional ESRs   Pending Config/Setup UAT Completed
CRM 0 0 0 0
ELM 1 0 0 2
EPM 0 0 0 0
FIN 1 0 0 0
HCM 25 12 2 5
Total 27 12 2 7

 

Technical ESRs   Pending Dev UAT Completed
CRM 3 0 0 1
ELM 2 0 0 1
EPM 1 0 0 0
FIN 28 11 4 6
HCM 51 9 5 5
Total 85 20 9 13

 

    Pending Dev UAT Completed
Total 112 32 11 20

Slide 28

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

  • March (FIN) - 6 ESRs completed; 2 not completed; 5 unplanned completed.
  • May (FIN) - 3 ESRs completed; 5 not completed; 4 unplanned completed.
  • July (FIN) - 6 ESRs completed; 1 not completed; 1 unplanned completed.
  • August (HCM) - 18 ESRs completed; 4 not completed; 7 unplanned completed.

Teachers Retirement mod was cancelled after the reporting period ended.

Slide 29

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
FY11 Technical Backfill 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
DCS Vendor Registration Execution Red 4/1/2010 8/31/2010 8/31/2010 Green
P-Card - BOA Transition Execution Green 8/18/2010 12/31/2010 12/31/2010 Green
Grants, Projects,Contract Accounts Receivable Billing Commerce/DEQ Execution Green 03/01/2010 12/31/2010 12/31/2010  
Higher Education Interface Execution Yellow 4/1/2010 10/31/2010 10/31/2010 Yellow
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 Execution Green 8/1/2010 11/15/2010 11/15/2010 Green
GPC, 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 30

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
PeopleSoft Extract Staging Environment Execution Red 1/14/2010 6/18/2010 8/31/2010 Green
Business Intellignece - FS Analytic Planning 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
Grants - Provisioning Planning Red 7/31/2008 7/15/2009 9/30/2009 Green
Licensing Planning Red 12/1/2008 8/15/2009 9/30/2010 Green
ELM Rollout Execution Green 8/1/2010 7/31/2011 7/31/2011 Green
Scanning and Barcoding functionality for Phase II Modules Concept          
Expense Module Planning Green 9/1/2010 11/30/2010 11/30/2010 Green
data.gov Initiation Green 8/1/2010 3/31/2011 3/31/2011 Green
Budget Concept, Initiation Green 8/2/2010 9/15/2010 9/15/2010 Green

Slide 30

Issues

Issue Status
(1) ODOT Phase II (Projects, Grants, AR, Billing Inventory) have not committed to a date to start integration testing. We need to determine if ODOT or other agencies (DPS, Health, Mental health, etc) will be next in line for Phase II modules. This decision needs to be made by mid-October
(2) The fixed asset rollout plan has been completed and and additional state resource is required to deliver on the current schedule. No state resource has been identified for this project.
(3) Commerce will be going live on Phase 2 without a Grants Provisioning or Loans. They will utilize manual work around until we acquire a Grants Provisioning and/or Loans package. Waiting on finalization of award so that we can start working with the vendor.
Last Modified on 03/09/2012
RSS Feeds get adobe reader get adobe reader get adobe reader get adobe reader
                                                                                                                                                                                                                                                           
 
Copyright © State of Oklahoma
Help Desk  |  Policies  |  About Oklahoma's Web Portal  |  Feedback  |  Accessibility