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) Business Services Project Review Meeting - January 2011

Business Application Services (CORE) Publications - Business Services Project Review January 2011

The following is a text transcript of the presentation made at the BAS (CORE) Oklahoma Business Services Project Review (BSPR) meeting in January 2011. 

Slide 0

BAS Business Services Project Review January 26, 2011
Next BSPR February 23, 2011

Slide 1

Agenda

Slide 2

Functional Resource Utilization

Capacity 10/3/2010-12/31/2010

Demand by Quarter by Service Group

Functional Financials - Fourth Quarter

  • Incident/Problem – Assistance Service Request (IP-ASR): Actual, 25%; Target, 22%
  • Enhanced Service Requests (ESR): Actual, 5%; Target, 10%
  • Projects: Actual, 50%; 50%
  • Administration: Actual, 20%;Target, 18%

Functional Payroll - Human Capital Management (HCM) - Fourth Quarter

  • IP-ASR: Actual, 32%; Target, 38%
  • ESR: Actual, 12%; Target, 10%
  • Projects: Actual, 26%; Target, 34%
  • Administration: Actual, 28%; Target, 18%

Slide 3

Technical Resource Utilization

Capacity 1/3/2010-12/31/2010

Demand by Quarter by Service Group

Technical Financials - Third Quarter

  • IP-ASR: Target, 28%; Target, 55%
  • ESR: Actual, 18%; Target, 10%
  • Projects: Actual, 22%; Target, 17%
  • Administration: Actual, 30%;Target, 18%

Technical Payroll - Human Capital Management (HCM) - Third Quarter

  • IP-ASR: Target, 27%; Target, 46%
  • ESR: Actual, 26%; Target, 10%
  • Projects: Actual, 17%; 26%
  • Administration: Actual, 27%;Target, 18%

Slide 4

Project/Enhancement Service Level Dashboard

  • Link to Dashboard

Slide 5

Projects Completed Since Last BSPR

  • Pcard - Bank of America (BOA) Transition: Schedule, green; Budget, green
  • Grants, Projects, Contracts (GPC)/Accounts Receivable (AR)/Business Intelligence (BI) for Department of Environmental Quality (DEQ) and Department of Commerce (Commerce): Schedule, green; Budget, red
  • OpenBooks Phase III: Schedule, green; Budget, green
  • Time & Labor Pilot: Schedule, red; Budget, green

Slide 6

Business Services Change Request On Time (Detail)

  • March (Financials (FIN)): ESRs completed, 6; not completed, 2; unplanned completed, 5.
  • May (FIN): ESRs completed, 3; not completed, 5; unplanned completed, 4.
  • July (FIN): ESRs completed, 6; not completed, 1; unplanned completed, 1.
  • August (HCM): ESRs completed, 18; not completed, 4; unplanned completed, 7.
  • September (FIN): ESRs completed, 9; not completed, 0; unplanned completed, 5.
  • October (HCM): ESRs completed, 12; not completed, 10; unplanned completed, 10.
  • November (FIN): ESRs completed, 12; not completed, 1; unplanned completed, 1.
  • December HCM): ESRs completed, 26; not completed, 5; unplanned completed, 15 Functional, 1 Technical.

Slide 7

Business Services Enhancement Service Requests

  • January 2010: Pending, 59 Technical; Developed, 42 Technical; UAT, 24 Technical; Closed, 16 Technical.
  • February 2010:  Pending, 72 Technical; Developed, 37 Technical; UAT, 26 Technical; Closed, 9 Technical.
  • March 2010:  Pending, 79 Technical; Developed, 25 Technical; UAT, 23 Technical; Closed, 17 Technical.
  • April 2010:  Pending, 122 Technical; Developed, 27 Technical; UAT, 16 Technical; Closed, 19 Technical.
  • May 2010:  Pending, 87 Technical, 37 Functional; Developed, 22 Technical, 1 Functional; UAT, 11 Technical, 1 Functional; Closed, 13 , Functional 10.
  • June 2010:  Pending, Technical 90, Functional 28; Developed, 21Technical, 12 Functional; UAT, 21 Technical; Closed, 13 Technical, 13 Functional.
  • July 2010:  Pending, 85 Technical, 27 Functional; Developed, 20 Technical, 12 Functional; UAT, 9 Technical, 2Functional; Closed, 13 Technical, 7 Functional.
  • August 2010: Pending, 85 Technical, 27 Functional; Developed, 20 Technical, 12 Functional; UAT, 9 Technical, 2 Functional; Closed, 12 Technical, 7 Functional.
  • September 2010:  Pending, 87 Technical, 32 Functional; Developed, 27 Technical, 11 Functional; UAT, 7 Technical, 3 Functional; Closed, 12 Technical, 8 Functional.
  • October 2010:  Pending, 87 Technical, 23 Functional; Developed, 27 Technical, 10 Functional; UAT, 11 Technical 3 Functional; Closed, 5 Technical, 10 Functional.
  • November 2010:  Pending, 84 Technical, 36 Functional; Developed, 33 Technical, 8 Functional; UAT, 7 Technical, 2 Functional; Closed, 11 Technical, 10 Functional.
  • December 2010:  Pending, 84 Technical, 61 Functional; Developed, 35 Technical, 7 Functional; UAT, 35 Technical, 1 Functional; Closed, 16 Technical, 25 Functional.

Slide 8

Problem Management SQL Requests

SQL Requests in Total January 2010 to December 2010
  Jan 2010 Feb 2010 March 2010 April 2010 May 2010 June 2010 July 2010 August 2010 Sept 2010 Oct 2010 Nov 2010 Dec 2010
CRM 0 0 0 0 0 0 3 0 1 0 0 0
DBA/System 0 4 4 2 0 0 4 7 0 0 0 0
HRMS 10 12 14 15 11 11 11 10 17 12 17 13
Financial 8 6 1 2 7 8 2 4 8 7 7 6
EPM 1 0 0 0 0 0 1 0 0 0 0 0
Purchasing 0 8 0 2 0 0 0 0 0 0 0 0

Legend

  • CRM - Customer Relationship Management
  • HRMS - Human Resources Management Systems
  • EPM - Enterprise Performance Management
  • DBA/System - Database

Slide 9

Problem Management Summary
Summary Total Problems Resolved or Resolution in Process Investigating Resolved by Future Functionality DR to be Created Monitor
Financial 20 14 3 2 1 0
PO 2 1 1 0 0 0
HCM 21 14 2 0 5 0
DBA/System 3 3 0 0 0 0
Total 46 32 6 2 6 0

Slide 10

Portfolio Priority 1-18
Project Name Project Manager Dept Function Current Project Phase Priority within Function
OpenBooks Phase III Lisa McKeithan BAS Other Execution/Close 1
Treasury General Ledger Implementation Alex BAS Financial Management Execution/Close 2
data.gov Lisa McKeithan BAS Transparency Initiation 3
Enterprise Learning Management Rollout Michael Grisser BAS Human Capital Management Execution 4
Higher Education Interface Lisa McKeithan BAS Human Capital Management Execution 5
AM Rollout - Tax Commission Michael Grisser BAS Financial Management Execution 6
Broadband GPC/AR/BI Alex Galley BAS Enterprise Service Automation Planning 7
Department of Mines GPC/AR/BI Alex Galley BAS Enterprise Service Automation Planning 8
Time & Labor Self Service Department of Transportation  (ODOT) Pilot Alex/Kim BAS Enterprise Service Automation Execution 9
PeopleSoft Extract Staging Environment Lisa McKeithan BAS Other Execution 10
Inventory - ODOT Alex/Kim BAS Supply Chain Management Execution 11
GPC - ODOT Alex/Kim BAS Enterprise Service Automation Execution 12
3% Federal Withholding Michael Grisser BAS Accounts Payable Planning 13
Licensing Lisa McKeithan BAS Other Planning 14
Grants - Provisioning Lisa McKeithan BAS Other Planning 15
Business Intelligence  Financial Analytics Lisa McKeithan BAS Other Planning 16
Expense Module Alex/Kim BAS Financial Management Planning 17
Backfill Developers for Production Support and Enhancements 2012 Fred Cantrell BAS Financial Management Human Capital Management Execution 18

Slide 11

Portfolio Priority 19-31
Project Name Project Manager Dept Function Current Project Phase Priority within Function
Scanning and Bar-coding Functionality for Phase II Modules Alex BAS Assets Concept 19
Voucher Build Lisa McKeithan BAS Financial Management Concept 21
Financial Upgrade Michael Grisser BAS Financial Management Concept 22
Budget Lisa McKeithan BAS Other Concept/Initiation 23
Absence Management Lisa McKeithan BAS Absence Management Concept 24
Human Resources Dashboard Michael Grisser   Human Capital Management Concept 25
Portal - PeopleSoft Sign On Consolidation Michael Grisser BAS Other Concept 26
ePAF - Electronic Personnel Action Form Michael Grisser BAS Human Capital Management Initiation 27
Manager Service Rolloout Michael Grisser BAS Human Capital Management Concept 28
Inventory - Rollout Michael Grisser BAS Supply Chain Management Concept 29
Licensing Rollout Lisa McKeithan BAS Other Concept 30
E-procurement Michael Grisser BAS Supplier Relationship Management Concept 31

Slide 12

Projects in Execution Delivery Schedule

  • GPC, A/R, Billing / ODOT - July 2009-July 2010
  • Inventory ODOT - August 2009-July 2010
  • T&L Manager Self Service ODOT - March-July 2010
  • PeopleSoft Extract Staging Environment -December 2009-August 2010
  • Treasury GL Implementation - mid-April-January 2011
  • AM Rollout - Tax Commision - Mid-October 2010-March 2011
  • data.ok.gov - January-mid-April 2011
  • FY11 Technical Backfill - July 2010-June 2011
  • ELM Rollout - August 2010-July 2011
  • Higher Education Interface - April 2010-December 2011

Slide 13

Detailed Milestone Plan, 2822 - data.ok.gov

Per Senate Bill 1759, provide transparency data in a downloadable format. The state has chosen Socrata to do this. OK.gov will be the "front-end." Write interface to Socrata to upload files.

Milestone Schedule +/- 10%

  • Prepare Development Requests and Define Process for Loading Data (Task, mid-December 2010-mid-January 2011)
  • Develop and Test Programs (Task, January-March 2011)
  • Migration to Production (Task, mid-January-mid-April 2011)
  • Go-Live (Milestone, mid-February 2011)

Issues

  • These costs/timelines are based on what Office of State Finance (OSF) needs to do to provide data, etc.
  • Initial loads will require manual intervention until all processes are defined and programming is complete.
  • Cost changes from 10% plan due to addition of costs to create APIs. Initially I thought ok.gov would create the APIs.

Slide 14

Detailed Milestone Plan, 2852 - AP 3% Withholding

Implement functionality for 3% withholding.

Milestone Schedule +/- 50%

  • Analysis (Task, June 2011)
  • Design (Config/Setup) (Task, June-July 2011)
  • Development (Specs/Coding/Unit Test) (Task, mid-June to mid-August 2011)
  • Testing (Config/setup in TST & QA) (Task, mid-August to  mid-October 2011)
  • Go Live (Milestone, mid-October 2011)

Issues

  • Where to hold the money
  • How to remit
  • how to report remittance
  • Possible customs
    • Remit - to report who was withheld and how much was withheld
    • Assumes 2 custom reports needed
  • Assumes all Federal Requirements are known by the team.
  • Changes in requirements may increase or decrease effort/cost.

Slide 15

Detailed Milestone Plan, 2853 - ePAF - Electronic Personnel Action Form

Approval workflow for personnel transactions to be approved before posting to the transaction tables in PeopleSoft. Only approved legal actions will be processed in the system. Will reduce data corrections and retro check processing.

Milestone Schedule +/- 50%

  • Analysis (Task, April-May 2011)
  • Install (Task, April-May 2011)
  • Design (Task, April-May 2011)
  • Development (Task, April-June 2011)
  • Testing  (Task, May-June 2011)
  • User Acceptance Testing (UAT) (Task, June-July 2011)
  • Training (Task, June-July 2011)
  • Pilot Go Live (Milestone, mid-July 2011)
  • Remaining Go Live (Milestone, mid-August 2011)
  • Post Live Support (Task, July-August 2011)

Issues

  • Assumes no changes to scope
  • Assumes Pilot Group go-live then remaining agencies one month later
  • Vendor is 25% remote support after Pilot plus 2 weeks for the month to complete remaining agencies
  • Vendor can provide starting Training manual
  • Need to determine if remove the OPM 14 Custom
  • Estimate assumes they will be doing a number of edits that need to be developed

Slide 16

Program Status

Human Capital Management

Slide 17

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 2/28/2010
Finish Human Resources (HR) Interfacing Debugging/Testing 7/1/2010 2/28/2010
Complete PY Interface Coding/Debugging/Testing 9/10/2010 12/28/2010
UAT to begin with OU 3/1/2011 4/26/2011
OU go-live 4/26/2011 5/1/2011
Kickoff with OSU, Cameron, UCO 1/19/2011 1/19/2011
Key Overall Issues
Requires Awareness:
  • OU go-live has been moved to 5/1/2011 due to problems with extracts, program development (bugs) and newly discovered programs to be developed.
  • Plan has been put in place to completed programming, fixed and business porcess testing prior 2/28/2011 when parallel and UAT testing is scheduled to begin.
  • Issues with Innovative have been addressed.
  • Plan will be re-baselined after the completion of Coding/Debugging/Testing

Slide 18

BAS - 2637 ELM Rollout

  • Status: Green
  • Rollout of ELM to agencies to be completed in three groups. Group A Department of Career & Technology (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) - live 1/31/2011
  • Group C: OSF (090), Working on Department of Rehabilitative Services (Rehab) (085) - Department of Human Services (DHS) - Office of Juvenile Affairs (OJA) (400) - go-live estimate: 4/30/2011
Key Activities
Task Start End
Group B - train agency SME's on config and setup for testing 12/10/2010 1/31/2011
Group B - Complete UAT 1/5/2011 1/20/2011
Group B - Go Live (post support 2/1 to 3/15) 1/31/2011 1/31/2011
Update and Load HCM Fields in Prod 11/1/2010 1/31/2011
Group C -Train Agency SME's 4/5/2011 4/25/2011
Group C - Go Live (estimate) 4/30/2011 4/30/2011
Key Overall Issues
Requires Awareness:
  • Waiting on decision from Rehab, DHS and OJA for Group C.
  • DHS demo completed 11/8/10 - may go live with current functionality in Group C.
  • Additional DHS Demo scheduled on 1/25/2011 to show a larger audience the existing functionality.
  • DHS and Department of Health (Health) are interested in additional functionality (will be next Phase SCORM). They may also be interested in using it for external learners.
  • Department of Central Services is considering another product instead of using ELM.

Slide 19

Program Status

Financials

Phase II Modules
 

Slide 20

BAS - 2692 Treasury General Ledger Implementation

  • Status: Green
  • Project is live - in production
Key Activities
Task Start Finish
Integration / User Acceptance Testing 11/4/2010 12/8/2010
System Rollout 12/11/2010 12/14/2010
Go-Live 12/31/2010 1/1/2011
Change Request 1/1/2011 1/31/2011
Key Overall Issues
Requires Awareness:
  • Additional functionality requested by Agency

Slide 21

BAS - 2837 GPC AR/BI Department of Mines

  • Status: Green
  • The Team is in the process of gathering data for a +/- 10% plan
Key Activities
Task Start End
BPS - Fit Analysis 1/5/2011 1/5/2011
Development of Plan 1/6/2011 1/31/2011
Finalization of Plan 1/26/2011 2/4/2011
Key Overall Issues
Requires Awareness:
  • We are meeting with the Water Resources Board on January 25 to assess the viability of including them with this effort.

Slide 22

BAS - 2838 GPC AR/BI Broadband

  • Status: Green
  • The Team is in the process of gathering data for a +/- 10% plan.
Key Activities
Task Start End
BPS - Fit Analysis 1/5/2011 1/25/2011
Development of Plan 1/26/2011 2/4/2011
Finalization of Plan 2/7/2011 2/11/2011
Key Overall Issues
Requires Awareness:
  • Meeting scheduling difficult. Requirements not collected

Slide 23

BAS - 2839 AM Rollout Tax Commission

  • Status: Green
  • Rollout of Asset Management to Tax Commission
Key Activities
Task Start End
Configure Development and load locations and Manufacturers 11/18/2010 1/14/2011
Test data extracts in Test 1/17/2011 1/21/2011
Correct issues and re-test load 1/24/2011 1/28/2011
Configure Quality Assurance and Test Conversion Process 1/31/2011 2/25/2011
Train Agency SME's 3/1/2011 3/18/2011
Production set up/conversion go-live 3/20/2011 3/29/2011
Key Overall Issues
Requires Awareness:
  • Need time for Patricia for oversight during testing in TEST Planning for DCS to participate in QA and additional test conversion process.

Slide 24

BAS - 2675 Data Staging Environment

  • Status: Red
  • Currently testing Assets. Migrated to FSINT to complete testing. Will work on Contracts next. Informal notification that they need more Asset tables.
Key Activities
Task Start Finish ODOT Access
Phase I extracts (6) signed off by ODOT   7/2/2010  
Assets (0523) 6/25/2010 12/31/2010 TBD
Billing (0512)   TBD TBD
Contracts (0513)   TBD TBD
Projects (0514) - will test along with roll-out   TBD TBD
Sign-off on Phase II Modules   TBD TBD
Key Overall Issues
Requires Awareness:
  • Incorporating the remaining testing (projects, billing) with the ODOT project.
  • ODOT has submitted new requests for (4) inventory tables, (39) HR, (39) Payroll and (35) Time & Labor tables. We will need to assess these requests and determine how to move forward.

Slide 25

BAS - GPC AR/BI ODOT

  • Status: Green
  • The Team is in the process of gathering data for a +/- 10% plan.
Key Activities
Task Start Finish
BPS - Fit Analysis 1/5/2011 2/4/2011
Development of Plan 2/7/2011 2/11/2011
Finalization of Plan 2/14/2011 2/15/2011

Slide 26

BAS - 2674 Manager Self Service ODOT / Pilot

  • 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 End
Go-live Limited Pilot - Complete 100 4/24/2010 4/24/2010
Requirements - Full Implementation 100 3/23/2010 4/7/2010

Slide 27

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 28

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/2011 6/30/2011 Green
Higher Education Interface Execution Yellow 4/1/2010 12/31/2011 12/31/2011 Yellow
Inventory ODOT Execution Red 8/1/2009 7/31/2010 7/31/2010 Red
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
Treasury GL Implementation Execution / Close Green 4/12/2010 1/31/2011 1/31/2011 Green
PeopleSoft Extract Staging Environment Execution Red 1/14/2010 6/18/2010 8/31/2010 Green
Business Intelligence - FS Analytics Planning Red 4/1/2009 7/31/2010 3/31/2011 Green
OpenBooks - Phase II Execution / Close Green 6/1/2010 12/31/2010 12/31/2010 Green
Data.OK.gov Planning  Execution Green 1/3/2011 4/15/2011 4/15/2011 Green
Grants - Provisioning Planning Red 7/31/2008 7/15/2009 3/11/2011 Green
Licensing Planning Red 12/1/2008 8/15/2009 3/31/2011 Green
ELM Rollout Execution Green 8/1/2010 7/31/2011 7/31/2011 Green
Scanning and Barcoding functionality for Phase II Modules Planning Green       Green
Expense Module Planning Green       Green
Budget Concept / Initiation Red 8/2/2010 9/15/2010 1/30/2011 Green

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 Project Manager Current Project Phase Health Indicator Schedule Project Phase Start Date Project Phase Baseline Completion Project Phase Target Completion Health Indicator Budget
AM Rollout - Tax Commission Michael Grisser Execution Green 10/15/2010 3/29/2011 3/29/2011 Green
Department of Mines GPC AR/BI Alex Planning Green 1/3/2011 1/31/2011 2/4/2011 Green
Broadband GPC AR/BI Alex Planning Green 1/3/2011 1/1/2011 2/11/2011 Green
3% Withholding Michael Grisser Initiation Planning Green 1/3/2011 2/28/2011 2/28/2011 Green
ELM Rollout Michael Grisser Initiation Planning Green 1/3/2011 2/28/2011 2/28/2011 Green

Slide 30

Issues

Issue Status
(1) The team and sponsors need to gain a common understanding of how Grants, Projects and Contracts will be rolled out. A document describing the Grants, Projects, Contracts rollout is being created. We will distribute and set up a meeting to discuss by the end of February.
(2) Funding for the planning phase for Broadband, Mines and ODOT will last until February 15.

Option 1: Set up meeting to review execution phase funding of these projects.

Option 2: Move forward with the finding and review results in the February 23 review.

(3)Assets rollout is on hold until additional resources are made available.  
(4) Expense Module +/- 10% plan is complete and we are waiting on decision to move into execution Set up executive review and determine when we want to proceed with expenses.
(5) Oracle end of quarter is November. We will get a better price if we buy Business Intelligence and/or expenses at this time.  

Slide 31

Issues

Issue Status
(6) Pay Cycle Conflict - The custom VFRA process sometimes causes pay cycle to abend when they run at the same time. The last time this occurred it delayed $5M dollars in payments by one day. Next steps: 1) investigate use of Voucher Build to replace VFRA - Oracle input & 50% plan, 2) research VFRA to see if it can be changed to avoid the conflict, 3) investigate whether the issue can be avoided via scheduling.
(7) The AP Pay cycle does not always pick up and process AP vouchers with withholding. This is an inconsistent issue and the work around is to reset and rerun the pay cycle. Usually the second run picks them up. This causes delays in processing and extra work for the end user to reprocess

Had a conference call with Oracle to discuss capturing data. Captured the issue with a program trace and provided other info to Oracles. Oracle has not provided a resolution. The case has be escalated.

Last Modified on 12/03/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