SUMMARY

• Around 8+ years of experience as a PeopleSoft Techo functional Consultant.
• 8+ years into full life cycle implementation, upgrade and support of PeopleSoft HRMS solutions covering all major modules such as Core Human Resources (workforce administration, workforce development, position management, competency management, global assignment, career/succession planning, compensation/salary planning, HRMS security, department security tree - design/redesign etc) Base Benefits, Benefits Administration, COBRA Administration, Time and Labor, Absence Management, NA payroll, Payroll Interface, Enterprise Learning Management (ELM), HCM Integration with General Ledger. Self Service applications such as eProfile/eProfile Manager Desktop, eDevelopment, Talent Acquisition Manager/Candidate Gateway, ePerformance, eCompensation, ePay, eBenefits.
• Worked very closely with Business users in capturing requirements and creating Functional Design documents (BRD & FRD) and designing Technical Documents based on FRD.
• Strong Expertise in People tools such as Application Designer, Application Engine, Component Interfaces, PeopleCode, XML Publisher, Process Scheduler. Working knowledge of Integration Broker, Application Messaging and Pagelet development using PeopleSoft portal.
• Thorough knowledge and hands-on experience using reporting tools, extensively used in PeopleSoft like SQR and Query tools like PS/Query.
• Excellent process orientation in performing project scoping, business process re-engineering, fit/gap analysis, requirements gathering, functional design, application configuration, user interactions, testing and production support.
• Worked closely with Developers, IT and UAT Testers to make sure work is progressing as expected.
• Strong expertise in Quality Assurance as part of full life cycle implementations of the above modules with specific emphasis on creating system/integration test plans, requirements traceability; developing manual test cases/test scripts; performing functional, integration and regression testing; managing defects and preparing comprehensive test metrics.
• Expertise in PeopleSoft new person model and HRMS applications HR, Payroll, Benefits, Benefits-Admin, Time and Labor, Candidate Gateway, Self Service Modules and ETA.
• Worked on development and modification of Interfaces and data conversion from Legacy systems to PeopleSoft records by performing numerous validations using SQRs and Application Engine.
• Experienced in Batch Processes scheduling, Customization, Conversion and Migration.
• Experience in writing adhoc queries using PS Query.
• Hands on experience using Microsoft Visio.

TECHNICAL SKILLS

• Administer Workforce
• People Tools/AppDesigner/r
• Oracle
• Base Benefits and Ben Admin
• Application Engine
• PeopleCode
• MS SQL
• DB2
• HR
• Self-Service
• SQR
• PS/Query
• NA Payroll
• T&L
• FileLayout
• Integration Broker
• HTML
• Java
• Script
• ComponentInterface/ XML Publisher

PROFESSIONAL EXPERIENCE

Confidential, Branchburg, NJ

Sr Peoplesoft Consultant

Responsibilities:

• Responsible for documenting all technical design documents based on BRD’s.
• Download and updating the required patches accordingly.
• Running Change Assistant scripts and debug any issues during upgrade.
• Configuring the PIA and Process schedulers for the new environment.
• Involved in HR mass data uploads using Excel to CI.
• Integrated Health and safety system with real estate system using Integration Broker.
• Involved in running upgrade compare reports.
• Setup Change Assistant to apply Maintenance Pack.
• Setup Demo and Copy of Production.
• Used PeopleSoft XML Publisher to write certain reports.
• Apply Tax Updates for HCM 9.2
• Tested Payroll Interfaces.
• Responsible for preparing and maintaining the Functional Test cases (SIT) for HR Module.
• Worked on Payroll work Requests and Reports.
• Worked closely with creating pay calendars, creating Pay Sheets and running through the finalpayroll process.
• Retrofit the custom objects.
• Involved in developing the Test strategy, planning, estimate, risk, assessment, mitigation and test cases for QA Evaluations.
• I have run North America payroll while testing Tax Updates to ensure the integration of the system with the new delivered patches and bundles.
• Responsible for preparing and maintaining the System Integration Test Plans for Online Pages.

Environment: Oracle 11i, Peoplesoft HCM 9.1,9.2, People Tool 8.50,8.53, Peoplecode, App Engine, Process scheduler, Application designer, FileLayout, XML Publisher,PSQuery,Component Interface,Integration Broker,SQR.

Confidential, Boston, MA

Sr.PeopleSoft Consultant /Team Lead

Responsibilities:

• Responsible for handling a team of developers and allocating the CSR’s based on the priority of the issue.
• Focused mainly in the modules like Administer work force,Base Benefits,Benifits Administration and NA Payroll.
• Created various custom objects from record, page, component, process, file layout and Application engine as part of automation of unpriced queries.
• Involved in acquiring Specifications from the functional team and modified the SQR’s as per the SPECS.
• Participated in cross-functional initiatives and teams to drive process improvement changes
• Drove system configuration and process improvement changes
• Daily PeopleSoft system maintenance and reporting as needed.
• Performed Hire, Rehire, Transfers, Retire, Terminate and data change events in PeopleSoft and tested the work flow process for provisioning and access control changes to the down stream systems.
• Involved in developing the Test strategy, planning, estimate, risk, assessment, mitigation and test cases for QA Evaluations.
• Used PeopleSoft XML Publisher to write certain reports.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Developed an application engine program using File Layouts to load New Hire interface file with all New Hired employees’ information after each day and load them into the people soft tables.
• Handled various Production CSR’s in Benefits Adminstration and Base Benefits.
• Retrofitted several views to carry forward 8.8 customizations to 9.1
• Customized AMEX process by providing a custom application engine to give input to the delivered external data source application engine.

Environment: IBM DB2, PeopleSoft HCM 9.1, People Tools 8.51,Peoplecode,Process scheduler, Work flow, Application designer, FileLayout, PSQuery,Component Interface,Integration Brokeer,XML Publisher,SQR.

Confidential, Omaha, NE

Sr.PeopleSoft Consultant

Responsibilities:

• Designing and executing test cases for functional and technical testing.
• Creates a custom page with all delivered validations and created programs to keep the custom and delivered direct deposit info in Sync.
• Impact analysis of the changes.
• Involved in acquiring Specifications from the functional team and modified the XML Publisher as per the SPECS.
• Writing queries for the users to identify the changes to the data (as a part of reconciliation).
• Involved in Design, Development, Testing, and Enhancement of PeopleSoft HCM for HR, Payroll Base Benefits and Benefits Administration modules.
• Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Developed number of interface reports using SQR to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications.
• Involved in setting up Open Enrollment for the year 2011.
• Involved in online changes to the delivered pages, components, menus and translate values.
• Extensively used process scheduler for scheduling recurring process for conditional Scheduling of successive process for setting up the reports to run at specific time and implementation of batch processing.
• Used File Layout Definitions to get data from the legacy system to people soft tables.
• Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table.
• Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits and Payroll Modules.

Environment: Oracle10g,PeopleSoft9.0, People tools 8.51, Peoplecode, App Engine, Process scheduler, Application designer, FileLayout, PSQuery,Component Interface,IB,XML Publisher,SQR.

Confidential, Alpharetta, GA

PeopleSoft Consultant

Responsibilities:

• Resolved critical issues on portal solutions (Pagelets) by working closing with the end user
• Optimized Application Engine which improved the process execution time to complete in 20 minutes.
• Enacted SQR to fetch terminated employees details and attached the script to SQR nightly batch process.
• Customized SQL views, records and PeopleCode functions comprising SQLExec and Scrollselect.
• Created a custom program as clone of pay003.sqr to created generate pay stub for an employee for a range of pay end dates.
• Troubleshot and resolved locked/ABEND Application Engine program issues by analyzing state and temporary tables.
• Proposed and identified the solutions to operate with minimum developments and operational efficiency.
• Participated in deep technical discussions on various modules with peers which enabled the team to resolve issues within SLA.
• Involved in online changes to the delivered pages, components, menus and translate values.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Developed an application engine program using File Layouts to load New Hire interface file with all New Hired employees’ information after each day and load them into the people soft tables.

Environment: PeopleSoft HCM 8.9, People Tools 8.49, Peoplecode, App Engine, Process scheduler, Application designer, FileLayout, PSQuery,SQR

Confidential

PeopleSoft Consultant

Responsibilities:

• Responsible for documenting all technical design documents based on BRD’s.
• Customized existing pages and created new pages based on Business Requirement documented
• Responsible for doing certain system changes.
• Created custom pages to handle the stock options for employees, taxing, view the leave balance pages etc.
• Responsible for preparing and maintaining the System Integration Test Plans for Online Pages.
• Responsible for preparing and maintaining the Functional Test cases (SIT) for HR Module.
• Tested Payroll Interfaces
• Worked on Payroll work Requests and Reports.
• Involved in Unit testing of various applications in SQR’s, Application Engine and Online Pages.
• Extensively worked on coding of SQR’s to support upgrade application.
• Worked extensively on Benefits Admin module to set up event and eligibility rules.
• Worked on Application Designer to modify record definitions, pages, components, menus and giving access to them by using maintain security
• Worked extensively on Work force Administration and North American Pay rolls.
• Involved in fixing various issues that are encountered in System testing phase.
• Used PS Query to write certain queries in order to support Upgrade application

Environment: Oracle 9i, PeopleSoft 8.3, PeopleSoft 9.0, People Tools 8.20,8.49, Peoplecode, App Engine, Process scheduler, Application designer, FileLayout, PSQuery,Component Interface,SQR.

Confidential

PeopleSoft Consultant

Responsibilities:

• Involved mainly in the customization of the tasks related to the HR and Base Benefits.
• Extensively worked with Application Designer to modify record definitions, pages, components, menus and giving access to them by using maintain security.
• Created custom pages for managers to submit,approve the position changes,salary changes,stock options eligibility to handle the adhoc changes for employees
• Customized the existing pages and Created new page according to client requirements.
• Developed certain Interfaces from scratch like Healthy roads, Hartford and Medical from scratch using SQR.
• Created a custom page for hr to add(hire) contractors into peoplesoft system.
• Modified the custom hire job to accommodate the contractors
• Involved in setting up Open Enrollment for the year 2007.
• Involved in setting up the core tables for HR and Base Benefits.
• Used People Code to perform data validations and to enforce field level security.
• SQRs have been developed to furnish information as required by the client for reporting and generated customized reports..
• Developed new Run Control Pages for the process scheduler.

Environment: Oracle9i,PeopleSoft 8.2, People Tools 8.14, Peoplecode, App Engine, Process scheduler, Application designer, FileLayout,PSQuery,Component Interface,SQR.