SUMMARY

• Over 3+ years of experience in all phases of software development life cycle including 2+ years of experience in Design, Configuring and Testing different modules of the ERP - PeopleSoft HRMS.
• Hands on experience in identifying the test conditions and wring manual Test Scripts and Test Cases and executing them as a functional tester.
• Good PeopleSoft Functional and hands on experience in PeopleSoft HCM 9.2, 8.9 - Core HR, Workforce Administration, Talent Acquisition Management(TAM), Candidate Gateway(CG), Payroll, Base Benefits, AWE, Manager Self Service(MSS).
• Good knowledge on PeopleSoft HCM modules - Ben Admin, TAM, Time & Labor, e-Recruit, e-Pay and e-Performance.
• Functioned onTAM (Talent Acquisition Manager)to complete, integrated system that enables organizations to effectively manageworkforce acquisitionacross allemployment categories, as well as ideally suited to meet organizations needs inhiring conditions, applicants screened, interviewed, and hired quickly and efficiently.
• Experience in designing, configuring and implementing of PeopleSoft HCM modules.
• Experience in performing roles as HCM Functional Consultant and Functional Tester involving in PeopleSoft HCM Implementation, Upgrade, and Production Support & Maintenance project.
• Good Functional knowledge on Payroll for NA with experience in configuring Payroll tables, creating Pay groups, pay calendars, Pay Run Ids etc. and supporting Payroll processes like Creating Pay sheets, running Pay calculation, Pay Confirm.
• Production Support & Enhancement experience in Administer Workforce, North American Payroll, and Base Benefits.
• Experience in writing Test plans, Test cases and executing Regression, System integration, Base line, Parallel, Performance and User Acceptance testing.
• Provided valuable insights, keen analysis, and team approach to implement best practices & processes.
• Worked very closely with Business users in capturing requirements and creating Functional Design Documents (FDD) and Business Review Documents (BRD).
• Good Conceptual understanding of various PeopleSoft Applications.
• Good knowledge on SQL and PL/SQL and basic knowledge on Oracle 10g/11g.
• Good knowledge in developing tables, views, joins, indexes and sequences using SQL.
• Good experience in writing SQL queries, views and materialized views.
• Experience in working with third party tools like SQL Developer and TOAD.
• Effective Team Player and an individual contributor with steep learning curve.
• Excellent communication skills, analytical and problem-solving capabilities, with emphasis on clearly communicating/documenting detailed Business Requirements and Functional Specifications.

TECHNICAL SKILLS

ERP: PeopleSoft HRMS/HCM 9.2/9.1/8.9

Data Management Tools: Data Mover+

Administration Tools: Configuration Manager, Process Scheduler

Reporting Tools: SQR, PS Query

Testing Tools: HP ALM/QC

Other Tools: SQL Developer, TOAD

RDBMS: Oracle 10g/11g

Scripting: SQL, PL/SQL, JavaScript

Operating Systems: WIN NT/XP/7/8/10, UNIX

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

PeopleSoft HRMS Consultant/Functional Tester

Responsibilities:

• Involved in the production & support and upgrade of the PeopleSoft HCM 8.9 (HR, Benefits, Payroll, AWE, TAM, and Self-Service application) modules based on organizational needs and requirements.
• Involved in writing Manual Test Cases and Test Scripts for new and enhanced version of PeopleSoft HRMS 8.9(Human Resource, Benefits, and Payroll).
• Responsible for identifying the test conditions, writing the test scripts based on the System requirements and executing them as part of the functional testing.
• Resolve Prod support issues in N.A Payroll. Creation of new entities like Earnings code, deductions, Departments, Action Reasons etc., as per the business needs.
• Setting up control tables and configured core application tables for all core HR modules, Base Benefits.
• Helped technical team in understanding the requirements, reviewing technical design documents, and assisted them during construct phase.
• Configured the delivered and the custom approval transactions in AWE.
• Configuration of Pay group, Earning codes, deductions, Federal, State and local Tax tables.
• Worked on payroll process such as Pay Sheets, Pay calculation, Pay confirmation and created Paycheck for the employees on off cycle and on cycle basis.
• Creation of Test cases for Core HR and Payroll modules and triage defects during UAT.
• Involved in the Fit gap analysis for Recruiting, HR, Benefits and benefits administration and Payroll modules and documented the gaps in the system.
• Involved in analyzing and documenting the customizations from 8.9 and retrofitting the same to 9.2.
• Wrote the functional specs for the upgrade changes related to the benefits and Payroll modules as the part of the upgrade 9.2.
• Proposed a QA Life Cycle and ensured standards are followed throughout the Organization.
• Performed Requirement Analysis, Business Analysis, Use-Case Analysis, and Gap Analysis.
• Involved in system Integration, Parallel, Performance and User acceptance testing for all the above-mentioned modules.
• Used quality center to create, execute test cases and for tracking the defects that have been logged as part of different testing cycles.
• Responsible for identifying the test conditions, writing the test scripts based on the System requirements and executing them as part of the functional testing.
• Tested the Payroll, and Benefits functionality in PeopleSoft HR.

Environment: PeopleSoft HRMS/HCM 9.2/8.9, People Tools (8.55/8.51), Oracle 9i/10g, SQL, HP ALM/QC.

Confidential

Oracle Developer

Responsibilities:

• Involved in complete SDLC Life Cycle requirements gathering, analyzing, design, development, implementation, testing, and maintenance of the project.
• Created new tables, views, materialized views, Sub queries, Correlated queries, Packages, Stored procedures and functions as per the requirements usingSQLandPL/SQL.
• Perform code review and made enhancements as required.
• Developed Oracle database triggers, cursors, Packages, stored procedure, Functions, Cursors, Collections.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Designing and rebuilding indexes for faster overall data processing.
• Used Exception Handling to handle runtime, user defined and pre-defined exceptions.
• Designed Database Triggers for audit and validation purpose.
• Worked closely with other teams while gathering requirements and development process.

Environment: Oracle 10g/11g, Windows 7, SQL, PL/SQL, SQL Developer, UNIX.