Senior Peoplesoft Qa Analyst Resume
Pittsburgh, PA
Summary
- Over 8+ years of experience in testing PeopleSoft HCM applications (Core HR, North American Payroll, Benefits, Time & Labor and Self Service modules) and FSCM modules like General Ledger, Account Payables, Account Receivables, Billing, Projects, Expenses and Online in-house-built integrated web based applications.
- Extensively worked on Implementation, Upgrade, Conversion, Fit-gap analysis and Testing of PeopleSoft applications.
- Expertise in performing Functional, Integration, Regression, System and User Acceptance testing.
- Extensively involved in testing of interfaces and conversions from Legacy/Third party systems to PeopleSoft applications.
- Proficient in Mercury Quality Center for Test Planning, Test Execution, and Defect Tracking.
- In depth understanding of the Software Development Life Cycle (SDLC) including QA analysis, planning, execution and test management.
- Creation of Test Plans, Test Cases, Test Scripts and project related documentation.
- Tested extensively on Application Messaging, PeopleCode, Application Engine, Integration Broker, Component Interface, Workflow, PS Query, SQR and Oracle PL/SQL.
- Proficient with Debugging tools like SQL trace, PC debugger, and AE trace for troubleshooting.
- Knowledgeable of web based applications in Client/Server & 3-Tier environments.
- Extensive experience in Black Box and White Box testing.
- Familiar with integration points between HCM and FSCM applications.
- Technical Knowledge of Web Servers, Database Servers, and Application Servers.
- Experienced in managing On-site as well as Offshore Software QA Projects from concept through maintenance and providing on time deliverables with highest quality to the aggressive schedules.
- Dedicated, self-motivated who is committed to success and adapt to multiple tasks in a high-pressured environment.
- Good team player with excellent communications and interpersonal skills.
CERTIFICATION
ORACLE Certified Expert – PeopleTools 8.48 Developer Certified
Technical Skills PeopleSoft HCM 9.1/ 9.0/8.9 (North American Payroll, Core HR, T&L, Benefits (Base Benefits & Ben Admin), Absence Management and FCSM 8.9 (GL, AP, AR, BI, PO, EX, PC, Contracts), Application Designer, People Code, Application Engine, Integration Broker, Workflow and Portal technology, SQR, Crystal Reports, PS Query, Kronos, PS/nVision and Tree Manager, Mercury Quality Center, Mercury QTP, IBM Rational Clear Quest, PS Security, Object Security, People Tools utilities and Upgrade Assistant, Cardiff Teleform, Component Interface, Business Interlink, EDI Manager, Message Agent, Database Agent, Application Messaging, Windows XP/NT/2000 Server, Unix (Solaris), Novell Netware and Linux, SQL, PL/SQL, Citrix and Visual Basic 6.0, Oracle 10g/9i, DB2, MS SQL Server, MS Access, and MS Office, ASP, HTML, DHTML, VBScript, Java, .Net, JavaScript, Visual Interdev, BEA Web Logic
Experience
01/2012 – Current Confidential,Pittsburgh, PA
SENIOR PeopleSoft QA Analyst
Project: Implementation of third party time system Kronos into existing PeopleSoft HCM application, Upgrade testing from 8.9 to 9.1, new changes to Pay Calc and recruiting Workflow Routing enhancements. Involved in technical/functional design, analysis and testing.
- Involved in integration testing between PeopleSoft HCM and third party Kronos application
- Validation of converted test data via developing SQL’s to check for data integrity issues.
- Involved in all phases of functional testing, system testing, integration and UAT testing.
- Data keying and testing of various test scenarios in job data component for both regular hourly and salaried employees to impact payroll processing
- Involved in testing and running the custom HR export app engine process to send the most current effective dated row changes from PeopleSoft to Kronos via Full Sync data and Incremental data
- Tested custom Payroll interface process to import payroll paysheet information and benefits accrual balance information from Kronos to PeopleSoft system.
- Involved in integration broker testing to send/receive messages real time from PeopleSoft HCM to Kronos application via Java/JMS system and Monitored service operations message status (publication and subscription messages) using Asynchronous Monitor.
- Creating new test scripts and testing various customizations/enhancements with HR, eService, T&L Benefits and payroll modules.
- Tested new workforce gateway and workforce dashboard with the custom online recruiting careers screen to hire Pick-up & Delivery, Line haul drivers and officers
- Tested new enhancements to workflow routings and email notifications for Person requests.
- Tested custom dynamic security app engine program to delete position based permission lists for positions at locations transitioned to MyTime and update to generic exempt or nonexempt rspl and TL permission list group Id access.
- Keyed and tested HR data via workforce administration on all the scenarios like Hiring, Rehiring, Intercompany transfers, promotion, demotion, terminations and so on.
- Tested custom app engine process to terminate benefit leave plans and zero out the leave accrual balances in PeopleSoft when employees were transitioned to My Time from eTime locations
- Tested custom check print process to sort checks based on location, shift and schedules
- Involved in testing inbound and outbound benefit interfaces with vendor Vanguard
- Keyed and tested various scenarios to validate CDAS P&D calculation process to load rates and various pickup packages/stop related calculations are loaded correctly into pay sheets to process payments.
- Created/Used SQL queries to access data from different tables for backend testing.
- Tested PeopleCode customizations and to apply new functionalities for employee Base Benefits, HRMS and Self-Service modules.
- Tested the employee and manager self service applications.
- Created traceability matrix to map the requirement with test cases.
- Use of quality center to create/track the defects and for creating reports on daily basis.
Environment: PeopleSoft HCM 9.1/8.9 Core HR, North American Payroll, Base Benefits, MSS, ESS, T&L, Leave Tracking, People Tools, Kronos ,Oracle, SQL, People Code, SQR, Application Engine, PS Query, Component Interface, IB, Shell scripts, Mercury Quality Center.
05/2011 – 01/ Confidential,Washington, DC
SENIOR PeopleSoft QA Analyst
Project: Conversion of PeopleSoft federal HCM application from Informix to Oracle, New changes to JENIE Customer Portal, Pay Calc, Self service modules and Retirement Workflow Routing enhancements. Involved in technical/functional design, analysis and testing.
- Involved in data conversion validation of PeopleSoft federal HCM application from Informix to Oracle
- Tested and keyed various job transaction scenarios via remote data entry, HR processing USF pages for current, future and retro adjustment pay periods.
- Keyed time in elapsed timesheet and tested employees and managers can submit and approve leave requests in Leave Tracking.
- Tested the Leave balances will accurately appear in the leave dashboard and earning statements.
- Tested real time integration and transaction updates using integration broker for adding applicants from third party external site to PeopleSoft application.
- Tested the real time integration and transaction updates using integration broker for posting vacancies from PeopleSoft system to third party external site.
- Involved in writing, testing and keying various test scenarios in job data component for both Court and Judge employees.
- Keyed and tested HR data via Remote data entry and HR processing USF pages for scenarios like Hiring, Rehiring, transfers between departments, Retirements, terminations and so on.
- Tested all HRMIS users have access to new JENIE portal page and menu changes.
- Tested enhancements done to Retirements functionality for retirement user roles, paygroup assignments and workflow routing rules.
- Tested outbound interface file of salary, benefit, vacation accrual entries for input into third party finance General Ledger system.
- Involved in testing changes to PeopleSoft benefits system – incorporating new benefit plans, different benefit types, vendor changes and enrolling employees to new plans for test setup to make sure all the way through to the payroll deduction from beginning to end
- Tested the eVacancy, employee and manager self service applications.
- Setup and keyed remote data entry retirements transactions to test the Workflow Routing rules and Email Notifications for Retirement users.
- Tested workflow routing rules and email notification for employees processed with multiple assignments.
- Setup users with different roles to verify access to new HRMIS customer portal application and row level security access to data.
- Created test plan document and mapped the requirement with test cases (Traceability matrix).
- Used Clear Quest to create/track the defects and for creating reports on daily basis.
Environment: PeopleSoft Federal HCM 8.9 Core HR, North American Payroll, Base Benefits, MSS, ESS, eBenefits, T&L, Leave Tracking, eVacancy, People Tools, Oracle, SQL, People Code, SQR, Application Engine, IB, Shell scripts, Rational Clear Quest.
10/2010 – 04/2011 Confidential,San Diego, CA
SENIOR PeopleSoft QA Analyst
Project: Consolidation of PeopleSoft HR and Payroll management for recently acquired staff care and club staffing font office and back office system into existing AMIE PeopleSoft production system. Involved in requirements gathering, technical/functional design, analysis and testing
- Developing and creating all required documents, testing new and existing functionality for all the business entities and post consolidation efforts to combine club staffing and staff care systems with current AMIE PeopleSoft system.
- Actively involved in conversion validation and writing SQL’s to check for data integrity issues.
- Involved in writing, testing and keying various test scenarios in job data component for both regular hourly and daily physicians to impact the pay/bill processing.
- Involved in running Placement, Provider and Customer interfaces for Pay/Bill front office system to successfully interface data out of legacy system into PeopleSoft HR and Finance.
- Extensively involved in testing Time and Labor processing by manually entering time in elapsed time module and running time admin process.
- Tested new custom Staff Care time admin processing for processing rules for physician on Overtime, On Call hours, 24 Hours calls, One Time Allowances, Travel and Expenses and Holiday rules processing.
- Created new customers and setup new holiday rules on customer level to validate the T&L rules.
- Involved in testing custom batch approval process for Staff Care and Club Staffing physicians to push entries into PeopleSoft finance system for Pay/Bill processing
- Tested new defined Time and Labor Dynamic work groups for specific group of time reporters.
- Tested custom Contracts to Billing interface app engine process to calculate sales use tax for each line.
- Created traceability matrix to test the custom SCTA time admin complexity process with requirement and test cases.
- Involved in Test planning, developing and writing Test Plans, Test Scripts, and execution of Test Scripts and deployment of in house built Java applications.
- Tested Cardiff integration and corrections in time and labor elapsed timesheet module for processing electronic forms, paper faxed time sheets and expense reports.
- Tested several Interfaces to send and retrieve information between PeopleSoft Financial system and third party system’s using via XML. Message objects and Component Interfaces.
- Involved in testing real time job transaction updates using integration broker from HR instance to Payroll instance. Pub/Sub messages, queued/error status tracked in Asynchronous Monitor.
- Tested physicians HR Job data with multiple assignments with in pay period and benefits calculation.
- Involved in testing the custom check reconciliation program and file layout structure to send EFT direct deposit check file to ADP.
- Involved in testing the SSN validation to happen from SBDev front office HR data environment to PeopleSoft HR system.
- Used Visual Intercept to create/track the defects and for creating reports on daily basis
- Testing and running interfaces for HR Employee file and Payroll EFT employee payments file to external PeopleSoft finance Accounts Payable system and Project Costing team.
- Provided timely updates to team lead on testing status
Environment: PeopleSoft HCM – Core HR, North American Payroll, Base Benefits, MSS, ESS, T&L, PeopleSoft FSCM (GL,AP,AR,BI, Projects, Contracts, Expenses), People Tools, SQL Server2005, SQL, People Code, SQR, Cardiff Teleform, Application Engine, IB, Unix, Java, Visual Intercept
6/2008 – 10/2010 Confidential,MD
SENIOR PeopleSoft QA Analyst
Project: Implementation and Consolidation of PeopleSoft North American Payroll 8.9 applications for Verizon Wireless (VZW), Verizon Communication (VZC), and Verizon Business (VZB) and Integration with PeopleSoft Finance application. Involving phases starting with requirements gathering, technical/functional design, analysis and testing.
- Supported consolidation efforts to combine current PeopleSoft Payroll Application for Verizon Wireless (VZW) with Verizon Communication (VZC) and Verizon Business (VZB).
- Involved in writing, testing and keying various test scenarios in job data component for both management and associate employees to impact the payroll processing.
- Involved in testing savings plan interface with benefit provider Fidelity investments for changes in weekly employee indicative data and financial savings plan data. Tested new Auto and Home inbound and outbound benefit interfaces with vendors Travelers, MetLife and Liberty Mutual
- Established Integration broker setup between two PeopleSoft systems by creating nodes, routings, service operations and gateway configurations.
- Tested employee base benefits and savings plan changes when intercompany transfers are done between VZW/VZB/VZC.
- Tested new HR and Benefit Reports in Process Scheduler by checking new Pages and Components and implementing security to provide role-based access to view reports in report manager.
- Involved in real time integration testing in foundation tables between VZW payroll & HR instance with VZC PeopleSoft instance via integration broker.
- Test custom app engine process to calculate compensation percentage calculation for management and associate employees.
- Tested new FMLA absence application engine process to calculate the FMLA hours available for each employee and helps in the approval of FMLA leave processing in absence management system.
- Tested the interface to accept files from Disability Vendors for STD in Absence management system.
- Tested the custom check extract and format process for Weekly, Biweekly On-Cycles, regular Off-Cycles and Off-Cycle for Online Checks. Also tested custom component and batch programs for the automation and population of custom paycheck messages that will show up on an employee’s paycheck based on pay period processed.
- Involved in running and testing various Inbounds & Post Confirm jobs, payroll reports against confirmed pay cycle.
- Involved in testing conversion of COBOL programs to SQR’s and JCL scheduling to PeopleSoft Job set scheduler.
- Involved in compensation testing for yearend changes for all the three business units.
- Comparing and testing the check format file with ESS view paycheck and PeopleSoft paycheck and processing the format file to check print shop via ftp script for printing.
- Worked with Production support to test the ftp/shell scripts for Outbound/Inbound interfaces.
- Involved in data conversion validation of PeopleSoft HCM &FSCM system from DB2 to Oracle.
- Testing the automation process and workflow to generate appropriate FMLA letters in Absence management/ARC system
- Tested and monitored the automation framework for HR data across different business unit for VZB/VZC/VZW for hiring job data and company transfers, promotions and so on.
- Involved in testing the custom check reconciliation program and file layout structure to sent positive check pay out files and direct deposit files to PNC and Mellon bank.
- Used Quality Center to create/track the defects and for creating reports on daily basis
- Involved in testing MSS and ESS portal applications.
- Part of external PeopleSoft finance system testing, executed and tested HR and Payroll feeds and sent to PeopleSoft General Ledger, Accounts Payable, Project Costing applications.
- Tested monthly outbound interface file of salary, benefit, vacation accrual entries for input into PeopleSoft finance General Ledger system.
- Involved in testing the custom paycheck print process to be used by the three business entities.
- Tested retrofitted VZC and VZB custom Sqr’s to make them compatible with the VZW PeopleSoft environment.
- Created/Used SQL queries to access data from different tables for backend testing.
- Documented and reported bugs found out during the testing process in Test Director
Environment: PeopleSoft HCM 9.0/8.9 HR, North American Payroll, Base Benefits, MSS, ESS, T&L,TAM,AMTS, Compensation, PeopleSoft FSCM 8.9(GL,AP,AR,BI,PO), People Tools 8.49, Oracle 10g, SQL, People Code, SQR, Application Engine, IB, COBOL, Unix, Mercury Quality Center , QTP, TOAD, Java, .Net, Ultra Edit
3/2007 – 4/2008 Confidential,Pleasanton, CA
PeopleSoft QA Analyst
Project: North American Payroll, Benefits (Base Benefits & Ben Admin), Time and Labor modules
- Involved in System Testing of PeopleSoft HCM System. Participated in the Integration Testing of different modules in PeopleSoft application.
- Involved in the testing of the Benefits Administration process for Open Enrollment, Snap and Event maintenance. Complete understanding of the Benefits.
- Administration process from scheduling to enrollment.
- Tested employee changes include direct deposit account info, Hire date, Birth date and Benefits date.
- Involved in testing of over time pay, over payment & adjustments.
- Involved in testing of Earnings and Deductions with in the Payroll process.
- Extensively involved in Black Box testing, White Box Testing and also in unit testing.
- Involved in creating test scripts and testing various customizations/enhancements with benefits modules and regression testing during benefits open enrollment cycle
- Tested new interfaces to extract the Benefits and Balance related data – Benefit Enroll, Benefit Mapping and Dependents Data, Balance Data Includes YTD and QTD Information.
- Involved in setup and testing various set of benefits rules for benefits administration modules
- Tested various programs to validate the data coming in flat files from different health care providers and to load that data into HR and Benefit tables using Component Interfaces.
- Tested the customizations involved in MSS, ESS and eBenefits Self Service applications
- Majority of work includes in recording and testing the batch stuff and running the scripts. Involved in running of SQRs in UNIX environment.
- Involved in testing various Inbound and Outbound Interfaces for transmitting employee Data to Benefits vendors and for receiving Data to process them and insert into various PeopleSoft Tables.
- Tested SQR Programs to Load the Employees Benefit data from Web Site database to Relevant PeopleSoft database after the enrolment period is over.
- Extensively analyzed results for North American Payroll.
- Updated test plans and test cases for Functional Upgrade tests
- Involved in testing of General Deduction Conversion-To Validate the Deduction Records are inserted into the PeopleSoft deduction Table
- Tested Creating & Printing online checks - This test case creates an online check for an employee. After it has been created it can be Printed or Deleted
- Created/Used SQL queries to access data from different tables for backend testing.
- Documented and reported bugs found out during the testing process in Test Director
Environment: PeopleSoft HCM 8.9, Oracle 10g, SQL Plus, Rational Suite Clear Case, Designer 2000, People Code, SQR, Application Engine, Crystal Reports, SQL, COBOL and UNIX Shell scripts,
12/2005 – 2/2007 Confidential,Milpitas, CA
PeopleSoft QA Consultant
This PeopleSoft HCM Application facilitates the QA automation of HR, Payroll, Time and labor. Worked as a QA Consultant for the upgrade of PeopleSoft 8.8 HCM
- Communicate with other QA analysts and end users how testing will be conducted.
- Identify the major requirements to assure quality system delivery.
- Extensively worked in Data conversion which involved writing complex SQL scripts
- Document the phases and stages of testing.
- Defined Payroll Interface tables to export HR and Benefits data to our third party payroll vendor.
- Tested Load Tax balance - To Load Tax Balance into PeopleSoft Tax Balances table.
- Involved in upgrade testing end to end from 8.3 to 8.8 including creating test scripts, batch execution and third party interface validation
- Tested interfaces to pull data from payroll paycheck tables and write them into flat files that will be sent to external units.
- Executed automated test scripts using Quick Test Pro for testing N/A Payroll, Benefits Administration, HR and Time and Labor modules.
- Testing various SQR Programs for all the current enrollments into various Benefit Plans and Plan types.
- Involved in conversion testing to validate records which are inserted into various PeopleSoft Tables
- Identify the entry and acceptance criteria for each testing stage.
- Extremely involved in functional aspects of North American Payroll Testing
- Worked with business users and tested Payroll Processing - Create & Load Paysheets.
- Involved in testing of Reversal Pay Checks and Direct Check deposits.
- Involved in Fit/gap and requirements analysis for new modules, customization rationalization, report and customization specifications, conversion validation, prototype, troubleshoot, system configuration
- Created and tested tables and pages and did validations using People Code.
- Involved in user-documentation of the manual and automated tested processes.
Environment: PeopleSoft HCM 8.8, Benefits and Payroll, SQR, Application Engine, Mercury Quality Center, QTP, People code, SQL Server and UNIX
8/2004 – 11/2005 Confidential,VA
Peoplesoft Analyst
Project: PeopleSoft HRMS, Payroll, Benefits
Implementation of PeopleSoft 8.8 HR, Benefits, and North American Payroll
- Communicate with other QA analysts and end users how testing will be conducted.
- Identify the major requirements to assure quality system delivery.
- Document the phases and stages of testing.
- Involved in setup of Automated Benefit Programs, Eligibility and Event Rules, Event Classes for Open Enrollment and Event Maintenance.
- To document the methods of testing for each stage in Payroll process.
- Developed test plans for the testing of interfaces to pull data from payroll paycheck tables and write them into flat files that will be sent to external units.
- Communicate with other QA analysts and end users how testing will be conducted.
- To document the methods of testing functionality in North American Payroll process.
- Developed test plans for the testing of interfaces to pull data from payroll paycheck tables and write them into flat files that will be sent to external units.
- Involved in testing the Provinces vacation rules - Each Province has a different set of holiday rules applicable.
- Created and tested tables and pages and did validations using People Code.
- Involved in writing manual testing as well as executing automated scripts.
- Performed extensive debugging and performance tuning of various processes
- Extremely involved in the methods of testing for each stage in North American Payroll process and documenting it
- Responsible for interacting with developers and going through Status reports.
Environment: PeopleSoft HRMS 8.8, Benefits and Payroll, Mercury Test Director, QTP, SQR, Application Engine, People code, Oracle and UNIX.
11/2003 – 7/2004 Confidential,, OH
QA Analyst
- Worked as QA Analyst, Analyzed the business requirement, wrote the test plan and test scenarios for internet service center application and implemented various aspects of the client applications site.
- Scoped and directed build out of QA test environments for new and ongoing products, brought QA test beds to a predictable reflection of live service.
- Identified the test scenarios and executed them as per business requirement documents
- Worked mainly to test issues related to Locked claims, by analyzing existing code, navigating through online application screens and creating data fix SQL’s.
- Provided interface queries and procedures for the front-end Java application.
- Worked directly with developers, project manager and business contacts to produce test scripts and test conditions.
- Intensive analysis of DB2 SQL’s in COBOL programs to test the various defects and JCL’s to execute the jobs in the testing environment
- Created test scripts for Ohio State’s Un-employment Insurance application for enhancement requirements.
- Performed data driven testing to test the application with different sets of data from the test database.
- Prepared use cases according to requirements.
- Performed functionality tests, security tests, performance test on web view GUI screens.
- Attended change request meetings to document changes and implement procedures to test changes.
- Responsible for complete testing life cycle of the project using software methodology.
Environment: Test Director 7.x, Java, JSP, COBOL-II, JCL, JavaScript, XML, HTML, DB2, MS Office, UNIX/Linux, Windows NT/2000.