620 likes | 786 Views
EmpowHR 9.0 Upgrade UAT/DB Change Status. Thursday, September 18, 2008 8:30 a.m. – 4:00 p.m. (Eastern). Agenda. Welcome/Introductions Billy Dantagnan Recap of UAT Test Results (Interim Report) Jane Ladner/Chris Elwood Recap of Open DPR’s Chris Elwood
E N D
EmpowHR 9.0 Upgrade UAT/DB Change Status Thursday, September 18, 2008 8:30 a.m. – 4:00 p.m. (Eastern)
Agenda • Welcome/Introductions Billy Dantagnan • Recap of UAT Test Results (Interim Report) Jane Ladner/Chris Elwood • Recap of Open DPR’s 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 IR’s John Ward • IR Testing Process Chris Elwood • Database Change (1:30 PM Eastern) • Testing Schedule Jane Ladner • Summary of Changes Jane Ladner • Production Upgrade Timeline Larry Barreca • 9.0 Upgrade Release 1 • Proposed SCR’s for Inclusion in this Release Giuseppe Montalto • Out-of-the-Box Security Implementation Briefing Wes Dahlem • Questions/Wrap-up All
9.0 Stress Test Results Giuseppe Montalto
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
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 • Type in EMPLID • Click + to add address • Sign out • 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 CommAcctg. • Sign out
User Productivity Kit (UPK) Post Go-Live Theresa Trentacoste
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.
HCM Data Warehouse Larry Barreca
HCM Data Warehouse • Purchased PeopleSoft Enterprise Performance Management (EPM), HCM Data Warehouse, and Oracle Business Intelligence Enterprise Edition (OBIEE) Software License • Train Technical Staff (DBA’s 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
Approach for Addressing Open IRs John Ward
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.
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.
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
IR Testing Process Chris Elwood
EmpowHR Changes for the PPS Database Change Jane Ladner
Agenda • Schedule • Reporting Problems • Screen Changes
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
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: 6:00 p.m. CT • PINE Pass Execution Times: 2:00 a.m. CT • Import Time: 4:00 a.m. CT • EmpowHR available for users 6:00 a.m.CT daily
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 • 11:00 ET, 10:00 CT • Open DPR Report distributed prior to meeting • Email notifications will be sent the same as 9.0
123456 XXX-XX-9999 JANE J DOE CAMSXX Click the look up Icon for FIELD TO BE UPDATED.
16 new entries for FIELD TO BE UPDATED: See next slide.
JANE J DOE 123456
123456 Award Data Amount: Size increased to 6 numeric positions followed by 2 decimal positions.
123456 JANE J DOE Jane J Doe Doe, Jane J
123456 DOE, JANE J Click Appt Data link
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.
DOE, JANE J 123456 Coop Overtime Rate: Increased to 3 numeric positions followed by 2 decimal positions. Coop Share Amt: Increased to 6 numeric positions followed by 2 decimal positions. Coop Holiday Rate: Increased to 3 numeric positions followed by 2 decimal positions.
DOE, JANE J 123456 Wage Board Shift Rate Var: Increased to 3 numeric positions followed by 2 decimal positions.
Language Required: Increased to 4 positions. New values added, see http://i2i.nfc.usda.gov/Customer_Support/Database_Change/Language_Code_Change.htm
Accounting Distribution and Hours: Allow up to 10 entries.
Accounting Distribution and Hours: Allow up to 10 entries
JANE J DOE 123456 XXX-XX-9999 Deduction Per Pay Period : Increased to 4 positions followed by 2 decimal
XXX-XX-9999 JANE J DOE 123456 Allotment Amount: Increased to 5 numeric positions followed by 2 decimal positions.
XXX-XX-9999 JANE J DOE 123456 Contribution Rate: Increased to 3 positions Contribution Amount: Increased to 4 positions
XXX-XX-9999 JANE J DOE 123456 Allowance Rate: Increased to 6 numeric positions followed by 2 decimal positions. Allowance Total: Increased to 6 numeric positions followed by 2 decimal positions.
XXX-XX-9999 JANE J DOE 123456 Amount Allotted : Increase size to 4 numeric positions followed by 2 decimal positions.
123456 Number of Bond Owners : Increased to 9 Number of Bond Owners Increased to 9
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
XXX-XX-9999 JANE J DOE 123456 Flex Fund Total Yearly Amount: Increased to 5 numeric positions followed by 2 decimal positions.
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.
Production Upgrade Timeline Larry Barreca
Production Upgrade Timeline • Go-Live with Database Change Project • Shut down EmpowHR v8.8 at 6:00 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 7:00 am EST on Wednesday, October 22nd • First pass of PINE for PP 21 is on Wednesday, October 22nd
9.0 Upgrade Release 1Proposed SCRs for Inclusion in this Release Giuseppe Montalto
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
Implementing 9.0 Delivered Security Wes Dahlem