Summary

• Over seven years of experience in PeopleSoft HCM modules like Payroll, HR, Benefits and Time and Labor and FSCM modules like General Ledger, Account Payables, Account Receivables, Purchasing, Billing, Projects and Expenses.
• Hands on Experience in Fit-gap analysis, design, testing of PeopleSoft applications.
• Extensively worked on Upgrade, Implementation, Conversion, Testing and Data Migration.
• Testing expertise in performing Functional, System, Regression, Performance, Integration, End to End and User Acceptance Testing. Extensive experience in Black Box and White Box testing.
• Extensively worked in Testing with Security Administrator to implement security in various levels. Creating and Testing Roles, Permission Lists User Profiles, Portal Security and Definition Security.
• Proficient in Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, and Defect Tracking
• Good knowledge of web based applications in Client/Server & 3-Tier Environments
• Extensively worked in integration between HCM and FCM applications
• Worked and Tested extensively on Application Messaging, PeopleCode, Application Engine, Integration Broker, PS Query, SQR and Oracle PL/SQL.
• Well versed with Debugging tools like SQL trace, PC debugger, and AE trace for troubleshooting.
• 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.

CERTIFICATION
ORACLE Certified Expert PeopleTools 8.48 Developer Certified

Technical Skills PeopleSoft HCM 9.0/8.9 (North American Payroll, HR(Human Resources), T& L, Benefits (Base Benefits & Ben Admin), and FCSM 8.9 (GL, AP, AR, BI, PO, EX, PC), Application Designer, People Code, Application Engine, Workflow and Portal technology, SQR, Crystal Reports, PS Query, PS/nVision and Tree Manager, Mercury Quality Center, IBM Rational Suite, PS Security, Object Security, People Tools utilities and Upgrade Assistant, 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, JavaScript, Visual Interdev, BEA Web Logic

Experience

6/2008 Confidential,Silver Spring, 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.

• Actively involved in documenting, testing the new and redesigning the existing functionality for all the business entities and involved in post consolidation efforts to combine current PeopleSoft Payroll application for Verizon Wireless (VZW) with Verizon Communications (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.
• Creating new test scripts and testing various customizations/enhancements with Benefits, HR and payroll modules.
• Involved in testing changes to PeopleSoft Core HR system Hire/Rehire employees, incorporating new company/paygroup changes, departments, job codes and enrolling employees for test setup to make sure all the way through to the payroll deductions from beginning to end
• Involved in testing and accommodating new changes in benefits plan
• Tested PeopleCode customizations and to apply new functionalities for employee Base Benefits, HRMS and Self-Service modules.
• Involved in real time integration and keying of employee HR data between two PeopleSoft instances using different action/action-reason combinations.
• Established Integration broker setup between two PeopleSoft systems by creating nodes, routings, service operations and gateway configurations.
• Involved in testing exempt and nonexempt associate/management employees.
• Tested employee base benefits and savings plan changes when intercompany transfers are done between VZW/VZB/VZC.
• Involved in testing real time job transaction updates using integration broker from HR instance to Payroll instance. Publication and subscription messages, queued status and error status are tracked in Asynchronous Monitor.
• 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.
• Interactive involvement with the development team in migrations, data conversions, building test scenarios and sample test files to validate different Payroll and Benefit Interfaces.
• 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
• Involved in testing HR data via workforce administration on all the scenarios like Hiring, Rehiring, Intercompany transfers, promotion, demotion, terminations and so on.
• Involved in real time integration testing in foundation tables between VZW payroll & HR instance with VZC PeopleSoft instance via integration broker.
• 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.
• Involved in testing the SSN validation to happen from common services HR data environment to PeopleSoft HR system VZC/VZW.
• 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.
• 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.
• Involved in requirements gathering, technical/functional design and testing file layouts for interfaces and Application Engine programs in HR, Benefits and Payroll modules for various external agencies for health, union and savings bond deductions
• 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.
• 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.
• 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
• Provided timely updates to team lead on testing status

Environment: PeopleSoft HCM 9.0/8.9 Core HR, Payroll, Base Benefits, MSS, ESS, T& L,TAM,AMTS, PeopleSoft FSCM 8.9(GL,AP,AR,BI,PO), People Tools 8.49, Oracle 10g, SQL, People Code, SQR, Application Engine, IB, COBOL, Unix Shell scripts, Mercury Quality Center , TOAD, Ultra Edit

3/2007 4/2008 Confidential,Columbus, OH
PeopleSoft HCM 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 testing Records, Views, Pages and Components.
• 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
• Provided timely updates to team lead on testing status

Environment: PeopleSoft HCM 8.9, Oracle 10g, SQL Plus, Rational Suite Clear Case, Designer 2000, People Code, SQR, Application Engine, Crystal Reports, Oracle9i, 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 full life cycle implementation 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.
• Tested interfaces to pull data from payroll paycheck tables and write them into flat files that will be sent to external units.
• 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.
• Did regressive testing as well User Acceptance testing
• Involved in user-documentation of the manual and automated tested processes.

Environment: PeopleSoft HCM 8.8, Benefits and Payroll, SQR, Application Engine, Rational Suite (Clear Case, Clear Quest, Requisite Pro), People code, SQL Server and UNIX

8/2004 11/2005 Confidential,GA
Peoplesoft QA 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.
• Did regressive testing as well User Acceptance testing.
• 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, SQR, Application Engine, People code, Oracle and UNIX.

11/2003 7/2004 ODJFS, Columbus, 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
• Tested PL/SQL stored procedures, packages, and triggers for data load and transformation, and data extraction.
• Prepared and documented functional and technical specifications from user requirements.
• 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.
• Performed data driven testing to test the application with different sets of data from the test database.
• Followed established formats and procedures, created new formats, as well as researched, created, edited technical and business data documents.
• 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.
• Involved in weekly walkthrough and inspection meetings, to verify the status of the testing effort and the project as a whole.
• 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, C/C++, JavaScript, XML, HTML, SQL Server 2000, MS Office, UNIX/Linux, Windows NT/2000.