SUMMARY

• Around 9 years of IT industry experience in Functional & Technical knowledge of PeopleSoft Human Capital Management (HCM) involved in maintenance/ support/ upgrade/ implementations of various PeopleSoft HRMS projects.
• Having hands on experience in modules like Core HR, ESS, MSS, eRecruit, ELM, NA Payroll, Workforce admin, Base Benefits, Benefits Administration, Absence, Compensation, Time and Labor, Talent Acquisition Manager/Recruiting, and HR Helpdesk. Etc.
• Worked extensively with Application Designer, Application Engine, PeopleCode, Integration Broker, File Layout, Data Mover, Approval Workflow Engine(AWE),Component Interface, PS Query, PS Security, Utilities, Process Scheduler, Process monitor, Report manager, Work list, Workflow administrator, Tree manager, Nvision and SQR etc.
• Experience in all phases of the project lifecycle including requirements gathering, analysis, design, development, testing, deployment and post - production support.
• Worked very closely with Business users in capturing requirements and creating Functional design documents.
• Created and modified Application Engine programs and processes (SQL and Application Engine PeopleCode) based upon business requirements.
• Proficient in writing complex database reports using SQL queries and customizing PeopleSoft delivered SQR reports.
• PeopleSoft Skills include Security Administration, Workflow Administration, PS Query, and SQR Reports along with significant SQL skills and Application Designer experience.
• Involved inmaintaining Securityfor all the custom components and pages.
• Created Public and Private Queries using PS Query.
• Experience in Business Process Functional Design Documentation, Job Aids, Test Planning/Execution, Training Guides, Recruiting solutions.
• Strong team player and communicates effectively to enable execution of projects flawlessly.
• Involved in full length Life-Cycle implementation of PeopleSoft modules.
• Documented all new changes in requirements and maintained up-to-date specifications for developers and testers.

TECHNICAL SKILLS

People Tools: PeopleTools 8.48v to 8.55v Application Designer, Application Engine, PeopleCode, PS QueryExcel to CI, PS Security, Data Mover, Process Scheduler, SQRXML Publisher, File Layout, Workflow, AWE, Component InterfaceTree Manager.

PeopleSoft Modules: PeopleSoft HRMS (8.9v to 9.2v), Core HR, ESS, MSS, eRecruitNA Payroll, Workforce admin, Base Benefits, Benefits Administration, Administrator workforce, Time and LaborTalent Acquisition Manager, Enterprise Learning ManagementPeopleSoft Security and HR Helpdesk.

RDBMS: Oracle, DB2, SQL Server.

PROFESSIONAL EXPERIENCE

Confidential, New Orleans, LA

Sr.Techno Functional Consultant

Environment: PeopleSoft HCM 9.2v, PeopleTools 8.55v, Oracle DB.

Responsibilities:

• Modified Application Engine programs and processes (SQL and Application Engine PeopleCode) based upon business requirements.
• Documenting the Technical Design Documents (TDDs) to include all the details regarding the architecture and design of the project.
• Modified People code & Application Programs by running People code Trace, SQL-Trace & AE trace to fix production issues in HRMS environment.
• Worked on performance related issues in AE programs using Managing Abends and application engine debugging, restarting ABEND programs.
• Testing the module at different levels and fixing the issues. Creating the test scripts and test cases for the module in testing.
• Worked on defects in Benefit Enrollment pages, Health Plan pages, Managing Insurance Plans.
• Working sessions with Architects to demonstrate application capabilities related to that particular module.
• Carrying out functional testing of all testing functionality and tracking defects and retesting following resolution and preparing completion report.
• Analyzing the documentation impact and working with the documentation team to prepare user manuals.
• Working sessions with business process owners to demonstrate application capabilities related to that particular module.
• Setting up user security for these modules by preparing permission lists and roles.
• Involve in preparing paperwork using Excel sheets to the Project with all elements while going Live.

Confidential, Columbus, Ohio

Sr.Techno Functional Consultant

Environment: PeopleSoft HCM 9.1v, PeopleTools 8.52v, Oracle DB.

Responsibilities:

• Analyzing the FDD documentation impact and working with the documentation team to clear the understanding of requirements.
• Involved in testing, checking for the required functionality and also discussed with team mates and users in various aspects to improve the quality.
• Developed Application Engines used in bolt-on modules to insert job row into job data according to the functionality at particular time.
• Handled enhancements on the existing Application Engines along with testing and production movement of new enhancements.
• Modified People code & Application Packages by running People code Trace, SQL-Trace & AE trace to fix production issues in HRMS environment.
• Worked on performance related issues in AE programs using Managing Abends and application engine debugging, restarting ABEND programs.
• Carrying out functional testing of all testing functionality and tracking defects and retesting following resolution and preparing completion report.
• Involve in preparing paperwork using Excel sheets to the Project with all elements while going Live.

Confidential

Sr.Techno Functional Consultant

Environment: PeopleSoft HCM 9.2v, People Tools 8.53v, Oracle DB.

Responsibilities:

• Involved in Development of bolt-on modules like E-Resignation, Transfer Module that includes Resignation, Domestic Deputation, Internal Transfers and Reporting Manager change for employees.
• Analyzing the FDD documentation impact and working with the documentation team to clear the understanding of requirements.
• Involved in the development phase of Module as a Technical Team Member.
• Involved in testing, checking for the required functionality and also discussed with team mates and users in various aspects to improve the quality of functionality.
• Developed custom fields, pages, components, permission lists, roles for bolt-on modules mentioned above.
• Developed Application Engine programs and processes (SQL and Application Engine PeopleCode) based upon business requirements.
• Worked on Security Administration, Workflow Administration, PeopleSoft Query, and SQR Reports along with significant SQL skills and Application Designer experience.
• Involved inmaintaining Securityfor all the custom components and pages by creating new roles and permission lists.
• Developed Public and Private Queries using PS Query for user reporting purpose.
• Developed Application Engines used in bolt-on modules to insert job row into job data according to the functionality at particular time.
• Configured AWE in Production system once the project migrated.

Confidential

Sr.Techno Functional Consultant

Environment: PeopleSoft HCM 9.0v, PeopleTools 8.50v, DB2.

Responsibilities:

• Interacted with end users on daily basis to understand more about the PeopleSoft customizations required by them. Also worked closely with the end users in resolving their issues
• Created customDependent Ben verification pageto check whether the Dependents/ Beneficiary has been verified or not by the approving manager.
• Created new application engine programs by adding new sections, steps and actions through application designer.
• Used state records to pass the values between steps and actions.
• Used dynamic call section to call the section dynamically based on business.
• Handled enhancements on the existing Application Engines along with testing and production movement of new enhancements.
• Modified People code & Application Packages by running People code Trace, SQL-Trace & AE trace to fix production issues in HRMS environment.
• Designed & customizedeBenefitsHome Pages (Benefits enrollment) Flexible spending Accounts pages & life Events (Marital status Change) Using Application Designer, People Tools, People Code.
• Involved in testing, checking for the required functionality and also discussed with team mates and users in various aspects to improve the quality.
• Analyzing the documentation impact and working with the documentation team to prepare user manuals.
• Study existing business model and operations and de-code business requirements to devise business-IT solution addressing business’s strategic and operational goals.

Confidential

Techno Functional Consultant

Environment: PeopleSoft HCM 9.1v, People Tools 8.51v, SQL Server.

Responsibilities:

• Involved in analysis, design and development in a series of PeopleSoft Requirements.
• Generated data mover scripts to import and export the data from one database to another database.
• Modified, Designed and build Fields, Records/Views/Sub records, assign table edits like prompt table etc
• Providedproduction supportforHR, BenefitsandPayrollapplications
• Involved inPayroll Tax Updatemigrated to development and test environment.
• Ran Weekly, Semi Monthly and Bi weekly Payrolls in QA databases to validate employee pay data for Tax updates - 07E and various test moves in PeopleSoft Payroll.
• Involved in running theCompare reportsafter the Tax Updates to reconcile the data between the production and test environment.
• Documenting the Technical Design Documents (TDDs) to include all the details regarding the architecture and design.
• Migrated configuration data into various environments using data mover.
• Developed and modified the production control reports which help in identifying the data integrity in the PeopleSoft tables.
• Incorporated the restart ability logic in the conversion programs.
• Involved in performance testing and fine-tuning of the SQR programs.
• Involve in preparing paperwork using Excel sheets to the Project with all elements while going Live.
• Validating the data in Data prove Excel spread sheet for assuring that data was placed with efficiency after project upgraded.
• Created inbound interfaces to load data from flat file to the PeopleSoft database using CI.

Confidential

Technical Consultant

Environment: PeopleSoft HCM 9.1v, PeopleTools 8.52v, Oracle DB.

Responsibilities:

• Involved with PeopleSoft MSS / ESS enhancement in PeopleSoft HRMS 9.1 for the client.
• Worked on eProfile module in ESS and MSS customizations. Wrote PeopleCode to meet the requirements.
• Involved in creating PeopleSoft Security-User profiles, Roles, Permission lists.
• Worked on setting up Data security usingTree manager, Department tree, and Query tree.
• Generated theSQRreports, Interfaces and Process from the scratch.
• Trouble shooting various testing, production and performance issues using Indexes & tuning SQL Scripts.
• Modification involved in changing search records to establish row level security. In order to accomplish row level security, Views were created.
• Created Component Interfaces to populate data into Visa/Permit pages. Created customized pages based on Derived Records.
• Customized pages for eBenefits to deliver Benefit Enrollment pages, Health Plan pages, Managing Insurance Plans an employee can access.
• Involved in the development phase of Module as a Technical Team Member.
• Analyzing the FDD documentation impact and working with the documentation team to clear the understanding of requirements.
• Involved in enhancements, customization, maintenance and support of E-Resignation module.
• Documenting the Technical Design Documents (TDDs) to include all the details regarding the architecture and design.
• Testing the module at different levels and fixing the issues.
• Creating the test cases for the module in unit testing.
• Setting up user security for these modules by preparing permission lists and roles.
• Involve in preparing paperwork using Excel sheets to the Project with all elements while going Live.
• Working sessions with Service Matter Experts to demonstrate application capabilities related to that particular module.
• Providing support to the module ones after it went Live.

Confidential

Technical Consultant

Environment: PeopleSoft HCM 8.9v, PeopleTools 8.48v, SQL Server.

Responsibilities:

• Prepared and executed test scripts and sign off on changes to production environment.
• Prepared and delivered training materials used by both SIT and UAT testers during and post implementation.
• Write SQR to automate Admin event maintenance tasks to close more events.
• Involved in logging all the defects: code, documentation, Data issue, and environmental bugs in Quality Center.
• Worked on performance related issues in AE programs using Managing Abends and application engine debugging, restarting ABEND programs.
• Participated in cross-functional initiatives and teams to drive process improvement changes.
• DevelopedCustom Application Engine program - Security Script process, converted existing SQR to new Application Engine process.
• Involved in creating PeopleSoft Security-User profiles, Roles, Permission lists.
• Worked on setting up Data security usingTree manager, Department tree, and Query tree.
• Generated theSQRreports, Interfaces and Process from the scratch.
• Modification involved in changing search records to establish row level security. In order to accomplish row level security, Views were created.
• Create Beneficiary designations statement-Insurance benefits report.
• Developed and tested delivered and custom workflows for on boarding custom and HR Module.
• Involved in on boarding (workflow) Bolt-On System development.
• Maintenance of production batch processing

Confidential

Trainee Software Engineer

Environment: PeopleSoft HCM 8.9, PeopleTools 8.48, SQL Server.

Responsibilities:

• Capturing prioritized business requirements from business process owners.
• Working sessions with business process owners to demonstrate application capabilities related to Talent Acquisition Manager and Candidate Gateway.
• Carrying out fit-gap analysis based on the business requirements gathered and reviewing fit-gap document with business process owners.
• Developing functional specifications based on the gaps identified.
• Analyzing impact of custom process for job opening and offer approval processes, new hire contract administration, absence recording & racking, car management among others.
• Preparing the configuration design document and completing configuration of the systems.
• Carrying out functional testing of all delivered and custom functionality and tracking defects and retesting following resolution Preparing test completion report.
• Setting up user security profiles for the New Users.