SUMMARY

• Over 6 years of experience in customization, upgrade, implementation and production support of PeopleSoft 8.3/8.8/8.9/9.0/9.1/9.2 HRMS/HCM (Employee Self Service, Manager Self Service, HR, Payroll, Base Benefits, Benefits Administration, Recruiting Solutions and Talent Acquisition Manager) modules.
• Worked extensively on integration of PeopleSoft Time and Labor with HR, Benefits, Absence Management, and Payroll for North America including Global payroll, eProfile, eBenefits, ePay and ePerformance.
• Expert noledge of PeopleTools - Application Designer, Integration Broker, Application Packages, PeopleCode, Application Engine, Component Interface, PS Query, Process Scheduler, XMLP, Data Mover and File Layouts.
• Created an Inbound/Outbound interface Application Engine to get data into teh PeopleSoft system from various third-party systems.
• Hands on experience in Integrating PS applications with other PS applications as well as 3rd party vendors.
• Wrote many SQR processes to solve Inbound/Outbound interaction issues.
• Strong experience in Batch processing, Upgrade, Migration, Data Conversion, Interfaces Development, Integration and Integration development (Component Interface, Integration Broker, Application Messaging).
• Expert noledge in applying fixes & patches, performing upgrade tasks, developing interfaces and converting & migrating data.
• Positive attitude and superior work ethics combined with excellent communication, interpersonal skills and fast learning capabilities.
• Excellent logical, analytical, presentation and time management skills and self-learning attitude.

TECHNICAL SKILLS

ERP: PeopleSoft HRMS/HCM 9.2/9.1/9.0/8.9/8.8/8.3 (ESS, MSS, Core HR, Base Benefits, Benefits Administration, Time &Labor and Payroll, Candidate Gateway).

Programming Languages: Java, J2EE, C, C++ and UNIX Shell.

Development Tools: PeopleTools(8.54/8.52/8.50/8.39/8.36), Application Designer, Application Packages, PeopleCode and Application Engine.

Administration Tools: Configuration Manager, Process Scheduler, Process Monitor, Upgrade Assistant, Security Administrator and Utilities.

Data Management Tools: Data Mover.

Integration Tools: Integration Broker and Component Interface.

Reporting Tools: SQR, PS/Query, NVision, Tree Manager, Crystal Reports, XMLP

RDBMS: Oracle and DB2

Web Servers: WebLogic 4.5/5.0, Tuxedo 6.5 and Jolt 1.2, Java web server

Operating Systems: Win XP, WIN2K, Win NT 4.0, Win 95, Win 3.1, UNIX and MS-DOS.

PROFESSIONAL EXPERIENCE

Confidential, Altamonte Springs, FL

Sr. PeopleSoft Techno-functional Consultant

Responsibilities:

• Analyzed teh requirements and created functional and technical design documents.
• Involved in data analysis and data conversion during teh implementation
• Involved in creating new Component Interfaces to load additional pay data of employees from Excel Sheet to PS payroll tables.
• Customized ESS and MSS transactions (viz., Name Change, Date of Birth Change, Location Change, Termination etc,.).
• Involved in System Integration Testing of Talent Acquisition Manager & Candidate Gateway.
• Worked on CI JOB DATA in Application Designer and implemented teh PeopleCode to apply business logic on teh inserted data.
• Worked on creating integration between PeopleSoft HMS system and Taleo Business Edition to load data of a new Hire into teh system.
• Designed and Developed custom reports using application package in XMLP.
• Designed Component Interfaces to load data into Personal Data Component.
• Developed w eligq SQR which writes employees eligibility information into output files.
• Developed custom w deltim process which inserts terminated employees data into audit table PS AUDIT TLRPTTIME.
• Developed w daysful process which inserts future day’s regular time entry into PeopleSoft tables
• Implemented Integration broker between HR system and Payroll system
• Developed new interfaces using SQR Reporting and Application Engine in teh areas of Benefits, Payroll and HR.
• Modified an Application Engine program to send emails to employees regarding paychecks.
• Developed an Application Engine program using File Layouts to load New Hire interface file into PeopleSoft tables.
• Created Application package for Warning messages that will be imported while save/submit and will issue a warning message to teh user. Also vigorously tested these messages for different scenarios to make sure they are triggered as per teh requirement.
• Trouble shooting issues occurred during teh implementation and conversion process.
• Created detailed unit test case documents.

Environment: Windows XP, RedHat Linux, PS HCM 9.2, PeopleTools 8.54, Oracle 11g, PeopleSoft Internet Architecture (PIA).

Confidential, Chicago, IL

Sr. PeopleSoft Techno-functional Consultant

Responsibilities:

• Teh project involved implementation, customization and production support of PeopleSoft HCM (HR, Payroll, Benefits and Absence Management modules).
• Developed an Application Engine program to generate a file (biweekly or annual) containing hours worked in Terminals to be used for staffing and budgeting purpose .
• Developed an automated process to calculate and load adjusted salary used to determine life and disability benefits for commissioned employees using Application Engine and Component Interface.
• Development of customized SQR to update sick plan leave accrual with personal day carryover for selected personal day leave plans.
• Development of SQR to create check register file to be transmitted to teh bank which handles check reconciliation. Teh file contains valid payroll checks and void payroll checks.
• Developed customized pages to restrict access to Additional Pay Insert and Additional Pay pages so as that only Payroll Department and any other Department that has access to these pages can submit information of International Employee/Pay group only but should of read only access to USA employee information.
• Created dynamic groups for Security setup to implement row level security.
• Worked on a setup issue in Core Row Level Security Options where employees were not being shown up on SJT PERSON table when employee is hired and terminated with same effective date.
• Made configuration changes to PTAF PRCS MAIN page since single table was being used to store teh Criteria details for Stage, Path and Step(PTAFCRTA) but made sure no functionality is disturbed.
• Involved in loading teh HR data from teh legacy system to teh ELM side using Integration broker and Application Engine.
• Involved in bringing over teh Legacy systemHRdata into theELMside by using teh Full sync messages, some of teh messages that were used arePerson Basic Sync, Workforce Sync, Person Basic Fullsync andWorkforce Fullsync.
• Worked extensively on Application Package PeopleCode to fix teh messed up criteria options in Approvals page.
• Played key role in development of Interfaces using SQR’s, Application Engine.
• Developed custom reports using SQR and XML Publisher.

Environment: HRMS 9.1, People Tools 8.52,SQR, Crystal Reports 8.0,SQL Server2000,ORACLE, Windows NT 4.0.

Confidential, Pittsburgh, PA

PeopleSoft Consultant

Responsibilities:

• Existing customizations in 8.8 are analyzed and teh changes required for new release are documented.
• Compare reports are analyzed to determine objects to carry forward during teh upgrade effort.
• Part of teh team responsible retrofitting of both online and batch objects, (me.e., pages, fields/records, modified People Code, SQR, etc.) through patch application and/or application development.
• Modified PeopleSoft Enterprise delivered Batch Objects and upgraded teh Custom added Batch Objects to teh new release environment.
• Performed Interfacing, Conversions, data migration and report writing (using People Code, People Tools and SQR).
• Modified Data Conversion Application Engine Programs to increase teh performance.
• Worked on Component Interfaces for Payroll and Benefits.
• Responsible for designing Application engine program to update personal status whenever their is change in teh valid life event.
• Worked on Annual Benefits enrollment project that encompasses design and coding of various programs in relation to annual enrollment. Teh programs includes Annual Enrollment/Termination Reports, IVR Outbound Interface, Pension System Feed, Age based Reports, and HMOs eligibility listings.
• Developed and executed test cases, Benefits administration (Event Maintenance and Annual enrollment) test cases. Involved in testing quarterly and annual reporting batch processes.
• Involved in Unit Testing, System Integration, User& Paralleltesting during upgrade of PeopleSoft system from 8.8 to 9.1.

Environment: PeopleSoft v 8.8/9.1 HRMS, SQR, Crystal Reports 8.0, PeopleTools 8.48/8.51,SQL Server2000,ORACLE, Windows NT 4.0.

Confidential, Ohio

PeopleSoft Development and Production Support

Responsibilities:

• Analyzed custom business process, gatheird business requirements, prototype and present feasible solutions.
• Created Technical Design Documents and test scripts based on teh client requirement.
• Performed Fit-Gap Analysis and client requirement study for upgrade project.
• Retrofitted customizations during upgrade from 8.3 to 9.1.
• Designed & developed various inbound & outbound interfaces using SQR’s & Application Engine.
• Involved in preparing teh PeopleSoft instances planning for upgrade, parallel and UAT.
• Customized teh Components related to ePerformance and payroll based on teh Client’s requirement.
• Worked on re-applying teh customizations and new development using People Tools, People Code and Application Engine.
• Proposed several designs for representing Organization Structure efficiently in PeopleSoft and developed teh selected design. Developed a conversion program to load teh data using Application Engine and Component Interface from a flat file to teh customized Organization Structure tables.
• Analyzed teh existing PL/SQL process to feed data from teh legacy system to teh Lotus Notes. Worked with different teams to confirm their will be no gaps and designed and developed an interface from PeopleSoft using SQR.
• Developed custom SQR reports for HR, Payroll and Benefits.
• Developed a program to load a file containing voluntary elections from Hewitt. Teh program loads teh information into teh database and produces a load report and an error report.
• Used Upgrade Assistant to monitor upgrade status and phases.
• Designed inbound/outbound interfaces using SQR to update/transfer 401K Loans information in Fidelity.
• Developed an interface using SQR to send a file containing employees eligible for benefits to Hewitt.
• Customized teh Payroll module according teh requirements.
• Involved in analysis and customization of teh ePay module according to teh organization’s needs. Assisted in documenting teh training material for end-users.
• Developed several SQR reports in Payroll module like Earnings summary, Overtime, YTD Overtime.
• Providing Production Support for teh modules implemented.
• Created new Records, Panels and attached them to menu’s and assigned teh menus to operator classes through security administrator.

Environment: PeopleSoft v 8.3/9.1 HRMS (HR, Payroll, and Ben-Admin), PeopleCode, SQR, Crystal Reports 8.0, PeopleTools 8.48/8.50,SQL Server2000, ORACLE, Windows NT 4.0.

Confidential, CA

PeopleSoft HRMS Technical Consultant

Responsibilities:

• Designed and developed conversion programs to populate JOBCODE table from Legacy Systems using Component Interface
• Created data conversion scripts to convert teh data from teh legacy system to PeopleSoft HRMS tables such as Personal Data, Job Data, Employment Data and Payroll tables, General Deduction and General Deduction code table.
• Developed new custom SQRs for Benefits including health Benefit, Dependent Benefit, Dependent Coverage, Health Dependent Coverage and health Dependent.
• Supported data conversions, developed various reports and interfaces.
• Developed Application Engine programs for conversion .
• Involved in Setup of Eligibility rules and Plans in Benefits Administration
• Developed Queries using PS Query and export teh results with Microsoft Excel
• Developed Crystal Reports as per teh business requirements for complex calculations.
• Involved in design and usage of Application Engine, usage of Data Mover and SQR for efficient data transfer.
• Used Import Manager extensively to transfer data from ASCII text files to PeopleSoft tables.
• Extensively worked on PeopleCode to validate data, setting default values for fields, Calculations and events.
• Created new report formats using PS Query for customized application.

Environment: PeopleSoft HRMS 8.8/9.0, People Tools 8.46/8.49, Oracle 9i, MS Excel, Crystal Reports, Windows NT/2000