EXPERIENCE SUMMARY: -

• Around 8 years of experience as a PeopleSoft Technical Consultant.
• Handled various Implementation,upgrade and Support projects.
• Worked on various versions of PeopleSoft HCMS and FSCM.
• Proficient in People Tools - Application Designer, Application Engine, PeopleCode, Component Interface, File Layout, Process Scheduler and PS Query.
• Proficient in Query Manager and PSQuery,XMLP Reports.
• Accomplished in successfully customizing modules based on Organizational needs and requirements.
• Development and modification ofOutbound and InboundSQRinterfaces.
• Experience in resolving certain priority based issues on time in Support project
• Involved in Fit-Gap, Anlyzing compare reports, mapping issues, testing, UAT,Go-Live support during PeopleSoft application upgrade.
• Proficient in writing complex database reports and customizing PeopleSoftDeliveredSQR report
• Flexible and versatile to adapt to any new environment and work on any project.
• Work well as a part of a team, quick-learner and able to meet deadlines.
• Extremely adept at quickly learning software and applying it to meet client’s requirements.
• Hands on experience in handling Maintenance and support & Upgrade Projects.
• Hands on Knowledge in various PeopleSoft modules such as Base Benefits, Benefits Administration, North American Payroll, Core HR, AP, Expenses and Administer Workforce.
• Proficient in developing New Custom Objects, Retrofitting or Customizing the existing Objects and also provided additional support in reviewing and unit testing the objects to ensure proper delivery.
• Expertise in data analysis, data mapping and data conversion from legacy system to PeopleSoft application database tables interfacing through SQR, Application Engine, File layout, Component Interface.

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
• File Layout
• HTML/
• Java

PROFESSIONAL EXPERIENCE:-

Confidential, Dublin, CA

Sr. Peoplesoft Consultant

Roles & 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.
• Retrofit the custom objects.
• Testing and UAT Support.
• Production Live Support.

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,SQR.

Confidential, Boston, MA

Sr.PeopleSoft Consultant

Roles and 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,Expenses 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.
• 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/FSCM 9.1, People Tools 8.51,Peoplecode,Process scheduler, Work flow, Application designer, FileLayout, PSQuery,Component Interface,SQR.

Confidential, Omaha, NE

Sr.PeopleSoft Consultant

Responsibilities:

• Understanding the client requirements by studying functional document. Creating/ updating technical design document
• Designing and executing test cases for functional and technical testing
• Impact analysis of the changes.
• 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 and Base Benefits 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 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,SQR.

Confidential, Alpharetta, GA

PeopleSoft Consultant

Responsibilities:

• Resolved critical issues on portal solutions (Pagelets) by working closing wif 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
• Troubleshot and resolved locked/ABEND Application Engine program issues by analyzing state and temporary tables
• Proposed and identified the solutions to operate wif minimum developments and operational efficiency
• Participated in deep technical discussions on various modules wif peers which enabled the team to resolve issues wifin SLA

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

Confidential

Software Engineer

Roles and 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.
• 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 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

Software Engineer

Roles and Responsibilities:

• Involved mainly in the customization of the tasks related to the HR and Base Benefits.
• Extensively worked wif Application Designer to modify record definitions, pages, components, menus and giving access to them by using maintain security.
• 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
• 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 has 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.