SUMMARY:

• 11 years of experience as a PeopleSoft HCM Consultant.
• 11 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.
• Worked with business users in capturing requirements for Time Clocks to interface with PeopleSoft Time Admin system and to make chart of accounts to be in compliance with OSHPD.
• 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.
• 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, Stockton, CA

Sr. PeopleSoft Consultant

Responsibilities:

• Identified fits and gaps between OSHPD chart of accounts and Department structure that includes cost center in Hospital system.
• Designed and developed interface between time clock Accu time and PeopleSoft Time admin system to avoid manual entry of time.
• Configured new Departments.
• Modified Labor Disribution Report in Payroll to get Benefit,Cost,Full time Equivalence and Hours per Earn code and drilled down to Job code and then to Department level and to total departments.
• Designed As Is Process and To be process for Payroll GL interface.
• Identified requiremnts by working with users in Hospital Payroll department and designed interface to generate three Journal Entry files to load into PeopleSoft General Ledger.
• Made sure that Chart of accounting fields are in OSHPD compliant when interfacing with PeopleSoft General Ledger.
• Developed unit test cases for all functional requirements.
• Designed mapping for Payroll GL Interface to replace from existing PeopleSoft Payroll to Keane GL system to PeopleSoft Payroll to PeopleSoft GL.
• Cretaed Payroll GL Interface to generate Journal entry lines in XML format using SQR.
• Developed HR Interface between PeopleSoft HCM and Cerner Clairvia system.
• Worked closely with users in SJGH to design User acceptance test cases.
• Developed an Interface between HRIS Pro and PeopleSoft to load Certification, Evaluation data.
• Developed interface between Heath Stream and PeopleSoft to load Certification data.

Environment: Oracle 11i, PeopleSoft HCM 9.2, PeopleTools 8.54, PeopleCode, App Engine, Process Scheduler, Application Designer, SQR, PeopleSoft Time & Labor, PeopleSoft NA Payroll.

Confidential, Albany, NY

Sr. PeopleSoft 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, Medical Determination and Internet functionality.
• Worked extensively in HCM/CRM modules that involves from creation of cases to meber enrollment process and Employer reporting process.
• 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.
• Integrated HCM system with CRM to create cases as part of Member enrollment using Integration broker.
• 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.

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 Payroll GL Interface.
• Created Crystal Reports for GOLF Enhancements.
• Worked on Application classes to key new templates in SMART HIRE.
• Created a payroll 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 in Payroll that 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

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.

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.