SUMMARY

• 9+ Years of experience as a PeopleSoft HCM Techo functional Consultant.
• Over 9 years into full life cycle implementation, upgrade and support of PeopleSoft HCM 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) Base Benefits, Benefits Administration, COBRA Administration, Time and Labor, Absence Management, NA payroll, Payroll Interface, 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.
• Successfully implemented Time & Labor in PeopleSoft HCM 9.0 with following responsibilities: Perform fit gap analysis among HRIS, SCO, and Time & Labor to identify and document requirements.
• Strong Expertise in People tools such as Application Designer, Application Engine, Component Interfaces, PeopleCode, XML Publisher, Process Scheduler. Working knowledge of Integration Broker, Application Package,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 and Self Service Modules, GL Interface.
• 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

ERP Package: PeopleSoft HCM 8.2, 8.3, 8.9, 9.0,9.1,9.2

Modules: Core HR, Base Benefits, Benefits Admin, Self Service, North American Payroll, Time & Labor, ePerformance

People Tools: Tools v 8.14, 8.48, 8.49, 8.51, 8.52,8.53.

Development Tools: Application Designer, Application Engine, People Code, File Layout

Integration Tools: Component Interface, Integration Broker

Reporting Tools: SQR, PS/Query, Process Scheduler, XMLPublisher

Database: Oracle 9i, 10g,11g,12c,IBM DB2, SQL Server 2012

Migration Tools: Data Mover,Phire,STAT

Other Languages: C, C++, JAVA

Web Progamming: HTML, JAVA Script

PROFESSIONAL EXPERIENCE

Confidential, Torrance, CA

Sr. PeopleSoft Consultant

Responsibilities:

• Involved in all stages of Upgrade of PeopleSoft Hcm from version 9.1 to 9.2.
• Specification documentation for the new changes brought out in version 9.2.
• Prepared the groundwork for implementing to PeopleSoft 9.2, including evaluation of customizations, project plan, fit Gap Analysis.
• Actively involved with giving the Estimates for the functional designs and configurations for the requirements
• Involved in several customizations for Benefits, Absence management and HR to meet business needs for clients of different regions.
• Collaborated with Core HR, Payroll, Benefits, and Absence Management team members to assess their business needs and recommend IT solutions.
• Conducted business analysis and developed functional specifications related to Client Corporate Employees Benefits and Benefits Administration modules.
• Involved in setting up the core HCM configurations as per the requirements to add new Custom Ruleset values, Benefit Programs, Benefit Plans, Deduction Codes, Event Rules, and Eligibility Rules.
• Configured and tested the snapshot process to populate the interface tables for different Vendor interface files.
• As part of Affordable care Act implementation enabled ACA event handler, worked with ACA component interface to update records in ACA component by coordinating with developers, updated ACA eligibility field for job codes, and developed a process to calculate average hours of the employees and also worked with ACA eligibility criteria for benefit programs.
• Involved in creating ACA Benefits inbound/outbound interfaces to provide temp and salaried employee demographic and benefits eligibility data to benefits vendor.
• Designed new Pages/Reports/Interfaces and new application enhancements.
• Created employee self-service customizations for e-Benefits open enrollment, and Payroll.
• Conducted unit testing and user acceptance testing. Created test data and test scripts as a part of system and parallel testing.
• Responsible for identifying the test conditions, writing the test scripts based on the System
• Requirements and executing them as part of the functional testing.
• Troubleshooting the problem areas in interfaces with Benefits programs, enrolling employees into Benefit plan, calculating payroll deductions and in producing Benefits reports.
• Worked on two Open enrollment cycles as functional consultant involved in the design of configurations, processes and interfaces.
• Worked with new vendors to gather the requirements for Medical, Dental and vision vendors to design file layouts and develop 834 EDI format files (HIPAA).
• Involved in configuring Open Enrollment Definitions, schedule ids for multiple windows each year to create OE events for employees. Designed and developed Bas group id update process to update bas group id each year before running Open enrollment process.
• Ran benefits administration process to create OE events in testing and UAT environments for testing purposes.
• Updated text catalog to update the text in self-services for different benefit programs and based on events.
• Designed interfaces to send enrollment and eligibility data to vendors on Weekly, Bi weekly basis to united health, delta dental and VSP vendors.
• Assisted UAT team members in creating test data for complex scenarios.

Environment: - PeopleSoft 9.1 / 9.2 upgrade; PeopleTools 8.53, Oracle 11g.

Confidential

PeopleSoft Application Developer

Responsibilities:

• Involved in design and development of 4b phase of NYSLRS Redesign Project.
• Worked on various functionalities like Employer Reporting, Member Enrollment, Member Data and Internet functionality.
• Worked extensively in HCM/CRM modules that involves from creation of cases to meber enrollment process and Employer reporting process.
• Developed various interfaces programs among Time & Labor, HRIS system, and other billing systems for labor tracking.
• In Member enrollment involved in developing enrollment design pages and validaitons necessary to complete the process. worked extensively on Portal pagelets.
• Hands on experience in Java Script and HTML programming to work on pagelets.
• Worked on Member enrollment to allow self service enrollment of a member by writing various validations using Peoplecode and inserting data to respective personal data and job tables using component interface and application package people code.
• In employer reporting, worked on input data in a file format from MEBEL and validated and passed the data into PeopleSoft tables based on format of data whether it is enhanced or legacy.
• Created security views to allow data that is present in HCM and Finance data in Employer reporting to be visible via Hub interface, which is the interface that has access to the user.
• Written various queries to create different types of reports in Employer reporting using Query Manager.
• Worked on 360 degree view pages in CRM to allow specific access to external and internal users.
• Has hands on experience in writing Technical design documents, Build design documents, and unit test documents.
• Hands on experience working on design tool like MS Visio and migration tools like Phire and STAT.

Environment: Oracle 12c, Peoplesoft HCM,CRM 9.2, People Tool 8.53, Peoplecode, App Engine,Process Scheduler, Application designer, FileLayout,XML Publisher, PSQuery, ApplicationPackage, Integration Broker, SQR,Component Interface,Phire. Sr. PeopleSoft Consultant

Confidential, Horsham,PA

Sr.PeopleSoft Consultant

Responsibilities:

• Developed a new report using Application Engine to provide statistics of HR Recruiting. This report will help to determine how long some one stays in APM role before being promoted and determine relationship between internal promotions and how long they stay after being promoted.
• Developed two custom Application Engines for Deferred Compensation, one to upload data from CSV file to General Deduction table and another to extract Deferred Compensation by pulling employees based on input criteria of file whether it needs to print weekly or annually,
• Modfied SQR report to ensure that Prudential 401K Interface picks contribution amount from DEDCD with negative values from PAY DEDUCTION.
• Made changes to Rimini Street SQR to report for those employees who does not have any benefit coverage elect.
• Created a new EAF (Employee action request) for GOLF employees by crating custom records, views and writing PeopleCode validations to accomdate the same.
• Created new custom accounts and cost codes and calcuated amount earned by mapping these accounts and cost centers to job codes using GL Interface.
• Created Crystal Reports for GOLF Enhancements.
• Worked on Application classes to key new templates in SMART HIRE.
• Created a report to get Auto, GAS and Mobile Reimbursements amounts to employess whenever you find a change in these DEDCD for all active and termed employees bases on ELIG CONFIG fields.
• Created ICIMS interface to report data to HR based on active employee referrals and their role.
• Modified Position Request form to enable save for each row on summary page.
• Added Color Selection date as criteria to get Pay begin date and Pay end date and load them to PSHUP TXN row.
• Written code to exclude employees with Employee Class A and Job title Landscape Laborers and Crew Laborers.
• Added code to get report between two run control parameters and to process all crystals in a batch so that all comission pay requsets can be uploaded to approved at a time in a batch.
• Set up Integration Broker services(such as gateways, nodes, services and service Operations etc) for automatic updates between HR and FIN applications.
• Worked on Non structured messages using Integration Broker for ePerformance.

Environment: SQL Server 2010, Peoplesoft HCM 9.1, People Tool 8.52, Peoplecode, App Engine,Process Scheduler, Application designer, FileLayout,XML Publisher, PSQuery, ApplicationPackage, Integration Broker, SQR.

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.
• Hands of experience in Absence Management module.
• 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.
• Designed, Developed Singled Sign on between HR and FIN applications.

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

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.
• Provided functional and technical support for Payroll, Time & Labor and TAM modules
• 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

Sr.PeopleSoft Consultant

Responsibilities:

• Understanding the client requirements by studying functional document. Creating/ updating technical design document.
• Designed and Developed Various customizations based on Integration Broker Class and SOAP and XML Doc.
• 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.
• Provided functional and technical support for Payroll, Time & Labor and TAM modules
• 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

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.