EmpowHR 9'0 Upgrade UATDB Change Status

1
EmpowHR 9.0 Upgrade UAT/DB Change Status

• Thursday, September 18, 2008
• 830 a.m. 400 p.m. (Eastern)

2
Agenda

• Welcome/Introductions Billy Dantagnan
• Recap of UAT Test Results (Interim
  Report) Jane Ladner/Chris Elwood
• Recap of Open DPRs Chris Elwood
• 9.0 Stress Test Results Giuseppe Montalto
• User Productivity Kit (UPK) Post
  Go-Live Theresa Trentacoste
• Current Status of HCM Data Warehouse Larry
  Barreca
• Approach for Addressing Open IRs John Ward
• IR Testing Process Chris Elwood
• Database Change (130 PM Eastern)
• Testing Schedule Jane Ladner
• Summary of Changes Jane Ladner
• Production Upgrade Timeline Larry Barreca
• 9.0 Upgrade Release 1
• Proposed SCRs for Inclusion in this
  Release Giuseppe Montalto
• Out-of-the-Box Security Implementation
  Briefing Wes Dahlem
• Questions/Wrap-up All

3
9.0 Stress Test Results

• Giuseppe Montalto

4
Stress Testing Approach

• Purpose is to ensure 9.0 performs on par with 8.8
• Performing an apples to apples comparison of
  8.8 to 9.0
• Testing being performed on identical hardware
• Testing on 9.0 to be done on results from Dry Run
  2
• Using Open Demand for testing scripts
• Using Symantec I3 to monitor the CPU and memory
  of the Web and Application layers
• Scripts selected for known performance issues and
  as a result of trouble shooting Forest Service
  performance issues

5
Scripts Tested

• Worklist
• Login as User
• Click on Worklist
• Click on Worklist Details tab
• Click on Summary
• Click Worklist Filters Dropdown tab
• Sign out
• Setup HRMS Workforce Admin
• Login as User
• Click on Setup HRMS
• Click Product Related
• Click Workforce Administration
• Click Workforce Data USF
• Click Geographic Location
• Type 010000003 in lookup
• Sign out
• PAR Processing
• Click on Par Processing
• Click on Address Processing

• Position Management
• Click on Position Management
• Click on Job Codes
• Type in Job Code
• Click on Default Compensation
• Click on Affected Positions and EmplIDs
• Sign out
• Setup HRMS Foundation Tables
• Click on Setup HRMS
• Click on Foundation Tables
• Click on Organization
• Click on Departments USF
• Type in Department
• Click on Comm Acctg.
• Sign out

6
User Productivity Kit (UPK) Post Go-Live

• Theresa Trentacoste

7
UPK Post Go-Live

• URL will remain available through production
  implementation and afterward.
• UPK product will be updated with the data base
  change information during UAT.

8
HCM Data Warehouse

• Larry Barreca

9
HCM Data Warehouse

• Purchased PeopleSoft Enterprise Performance
  Management (EPM), HCM Data Warehouse, and Oracle
  Business Intelligence Enterprise Edition (OBIEE)
  Software License
• Train Technical Staff (DBAs and Developers)
• Purchase and Install Hardware (Completed August
  22nd)
• Install Software and Configuration (Completed
  Week of August 25th)
• Oracle Consulting Services for Implementation
  (Started August 25th)
• Ready for Testing (Winter 2008)
• Ready for Production (Spring 2009)
• Initial Implementation will have Out-of-the-Box
  functionality
• Next Phase will include necessary customization
  from EmpowHR

10
Approach for Addressing Open IRs

• John Ward

11
Defect Problem Report (DPR)

• Post Production 9.0 DPRs will be submitted to the
  Help Desk to be assigned an IR number in Remedy.
• Remaining Open Quality Assurance Testing (QAT)
  and User Acceptance Testing (UAT) DPRs (cat 2
  3) will also be submitted for an IR number in
  Remedy.
• All IRs (from DPRs) will keep the assigned
  priority.
• Once DPRs are assigned IR numbers the DPRs will
  be closed and the IR will be worked through the
  normal IR process.

12
IR Resolution Strategy

• Development team will implement the Tiger Team
  approach that was used prior to the code freeze.
• The team will begin with higher priority IRs and
  work through the IR backlog.
• Higher priority IRs will take precedence over
  lower priorities as new IRs are reported.
• All IRs will go through the standard process.
• QA Test Team will coordinate User Acceptance Test
  (UAT) and be responsible for obtaining migration
  certificates.
• IR fixes will be migrated on the normal weekly
  schedule once migration certificate is received.

13
Post 9.0 IR Process
Analysis and Design
User contacts Helpdesk
Design Review
Code Review
HD documents and forwards IR
Integration Testing
No
TC reviews IR
Valid?
EmpowHR IR?
Valid
Yes
Quality Assurance
14
IR Testing Process

• Chris Elwood

15
IR Testing Process
16
EmpowHR Changes for the PPS Database Change

• Jane Ladner

17
Agenda

• Schedule
• Reporting Problems
• Screen Changes

18
Testing Schedule

• September 22 October 3
• QAT and UAT will be in the same time/environment
• EmpowHR changes will be available September 22
• PPS interface will be available September 24
• Data will be as of end of processing for PP 17
• Mainframe PPS environment
• IDMS61, DICT03
• 100 SSNs loaded for each agency

19
Payroll/Personnel Processing Schedule

• IDMS Database IDMS61/DICT03 (CLIST DICT03)
• Data will be as of end of processing for PP 17 
• Processing Pay Period 19 Effective Date
  09/14/08 
• Export Time 600 p.m. CT 
• PINE Pass Execution Times 200 a.m. CT
•  Import Time 400 a.m. CT 
• EmpowHR available for users 600 a.m.CT daily

20
Reporting Problems(same as 9.0 upgrade)

• Submit DPR to QAEMPOWHR mailbox
• QA Team will triage DPR
• EmpowHR problems will be forwarded to Unisys
• PPS mainframe problems will be forwarded to GESD
• Daily DPR meetings
• 1100 ET, 1000 CT
• Open DPR Report distributed prior to meeting
• Email notifications will be sent the same as 9.0

21
CAMSXX
22
16 new entries for FIELD TO BE UPDATED See next
slide.

23
Master File Change New Elements
24
(No Transcript)
25
123456
Award Data Amount Size increased to 6 numeric
positions followed by 2 decimal positions.
26
JANE J DOE
123456
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
Appointment Limits Amount Total Increased to 6
numeric positions followed by 2 decimal
positions.
Appointment Limits Amount Balance Increased to
6 numeric positions followed by 2 decimal
positions.
31
(No Transcript)
32
DOE, JANE J
123456
Wage Board Shift Rate Var Increased to 3
numeric positions followed by 2 decimal
positions.
33
Language Required Increased to 4 positions. New
values added, see http//i2i.nfc.usda.gov/Customer
_Support/Database_Change/Language_Code_Change.htm
34
Accounting Distribution and Hours Allow up to 10
entries.
35
Accounting Distribution and Hours Allow up to 10
entries
36
JANE J DOE
123456
XXX-XX-9999
Deduction Per Pay Period Increased to 4
positions followed by 2 decimal
37
(No Transcript)
38
Contribution Rate Increased to 3 positions
Contribution Amount Increased to 4 positions
39
Allowance Rate Increased to 6 numeric positions
followed by 2 decimal positions.
Allowance Total Increased to 6 numeric positions
followed by 2 decimal positions.
40
Amount Allotted Increase size to 4 numeric
positions followed by 2 decimal positions.
41
123456
Number of Bond Owners Increased to 9
Number of Bond Owners Increased to 9
42
123456
JOHN R DOE
EmplID 999999
Rcd 0 SSN XXX-XX-1234
Number of Co-Owner/Beneficiary Increased to 9
Number of Bond Co-Owners /Beneficiaries
Increased to 9
43
Flex Fund Total Yearly Amount Increased to 5
numeric positions followed by 2 decimal
positions.
44
New Page EHRI RSM (444 Doc) Elements

• See EHRI/RSM New Elements for a description of
  the new fields.
• This new page is used to enter values in the 444
  document fields.
• To clear a field, use Master File Change.

45
Production Upgrade Timeline

• Larry Barreca

46
Production Upgrade Timeline

• Go-Live with Database Change Project
• Shut down EmpowHR v8.8 at 600 pm EST on Friday,
  October 17th
• Will complete final export/import for PP 20 after
  shut down
• Upgrade of EmpowHR v8.8 to v9.0
• Saturday, October 18 thru Tuesday, October 21
• Upgrade of EmpowHR
• Verification Process
• System available for users at 700 am EST on
  Wednesday, October 22nd
• First pass of PINE for PP 21 is on Wednesday,
  October 22nd

47
9.0 Upgrade Release 1Proposed SCRs for Inclusion
in this Release

• Giuseppe Montalto

48
Proposed Release 1 Schedule

• Design and Development In Progress
• Integration Testing 10/13/08 10/24/08
• Quality Assurance Testing 10/27/08 11/14/08
• User Acceptance Testing 11/17/08 12/05/08
• Go-live 12/15/2008

49
SCRs Included in Release 1
50
Implementing 9.0 Delivered Security

• Wes Dahlem

51
Agenda

• Timeline
• 9.0 Security Implementation Tasks
• 9.0 vs. 8.8 Security Comparison
• 9.0 Distributed Security
• Impact of 9.0 Security on Agencies
• Benefits
• Current Project State
• Next Steps
• Questions

52
Timeline

• Scheduled for EmpowHR Release 1
• Analysis / Design 45 days
• Design Review Meeting October 16th
• Development 20 days
• Testing 30 days (QAT 15 days, UAT 15 days)

53
9.0 Security Implementation Tasks

• 8.8 Security Rollback Steps
• Identify all the customized security objects in
  8.8
• Analyze / document the custom data security in
  8.8
• Analyze / document current custom security setup
  / configuration
• Setup 9.0 delivered security
• Configuration
• Database / object changes
• Data conversion
• Refresh / update process

54
9.0 vs. 8.8 Security Comparison

• Data and/or row-level security is the primary
  element that will change in 9.0 versus the
  customized data security in 8.8

55
9.0 vs. 8.8 Security Comparison (cont)

• Although EmpowHR 9.0 will utilize the Dept
  Security Tree as the backbone of data security
  (as does EmpowHR 8.8), the existing customized
  data architecture will be rolled-back

1
2
New DEPTID Permission Lists will need to be
created and assigned to users in 9.0
1
Refresh process of security tables required to
update application security in 9.0
2
56
9.0 vs. 8.8 Security Comparison (cont)

• The Row Security field value in the User Profile
  gt General page will always be a permission list
  and not an OPRID

57
9.0 Distributed Security

• Security administrators can distribute some or
  all user profile administration tasks by enabling
  selected users to use the Distributed User
  Profiles component to control the granting of
  selected roles to other users.
• Driven by DHS-110 and will impact all agencies

58
Impact of 9.0 Security on Agencies

• EmpowHR team will work with agencies to define
  new business processes based on detailed analysis
  and comparison of customized 8.8 security and
  delivered 9.0 security
• Security administration
• centralization vs. de-centralization (distributed
  security impact)
• Application security update process
• delivered 9.0 refresh processes
• Change management plan
• training for 9.0 delivered security
• communication of 9.0 changes

59
Benefits

• Reduction of overall customizations (facilitates
  future upgrades)
• Required for implementation of AWE
• Increased security administration flexibility
  (distributed security)

60
Current Project State

• Detailed analysis / research phase to determine
• Affected security objects
• Steps to rollback 8.8 customized security
• Steps to configure / setup 9.0 security
• Database changes
• Data conversion

61
Next Steps

• Identification of agency POCs to communicate
  ongoing status and issues during the course of
  the project
• Response to NFC due September 26th
• Follow-up meeting with user group to reveal
  results of detailed analysis / research (October
  16th Meeting)
• Summary of findings (preliminary testing /
  development)
• Identification of risks
• Identification of impact to agencies

62

• Questions?