SUMMARY

• PeopleSoft Consultant with 8+ years of experience in PeopleSoft HRMS/HCM application.
• Expert in People Tools - Application Designer, People Code, Application Engine, Component Interface, File Layout, XML Publisher and Process Scheduler.
• Expertise in PeopleSoft Reporting tools such as PS Query, SQR and XML/BI publisher.
• Extensively worked on developing & customizing interfaces for Inbound, process, reporting and Outbound SQRs.
• Extensively worked on developing & customizing interfaces using Application Engine, Filelayout and CI.
• Extensively worked on customization of delivered PeopleSoft Core HR, Base Benefits, Payroll, Ben Admin, eBenefits, and Time & Labor.
• Experience in understanding fit-gap analysis.
• Experience in functional setup for the above mentioned modules.
• Experience in HPQC (Quality Center)
• Experience in unit testing and system testing.
• Leadership experience blended with effective communication & organizational skills.

TECHNICAL SKILLS

ERP Package: PeopleSoft HRMS 9.1, 8.x,& PeopleTools 8.5x, 8.4x

PeopleTools: Application Designer, Application Engine, Component Interface, File Layout, Data Mover, XML Publisher, Application packages, Integration Broker

Languages: C, C++, PeopleCode, SQL

Reporting Tools: SQR, PS Query, TOAD, SQL Developer

Operating Systems: MS DOS, Windows 2000, Windows XP, WindowsNT

Databases: Oracle SQL Plus, SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Tempe, AZ

PeopleSoft Technical Consultant

Environment: PeopleSoft HRMS 9.1 People Tools 8.52, Oracle 11g, Unix

Responsibilities:

• Developed technical designs based on the functional requirements given.
• Involved in fit-gap analysis sessions along with the functional/business analysts to identify the technical solutions.
• Involved in understanding report and interface requirements and supporting of business issues to ensure the delivery.
• Took care of the client questions and clarifications to offshore team during the implementation.
• Developed System Testing documents.
• Developed interfaces to load the data that is coming from vendors as flat files into PeopleSoft benefit system.
• Developed an interface to send the new hires information to Taleo system.
• Developed an interface to load the general deductions for the employees that are coming from a flat file.
• Customized Paycheck/Pay advice programs (PAY003.SQR and DDP003.SQR) and XMLP templates to meet the client requirements.
• Customized delivered paycheck/pay advice XMLP templates (PYUSCHKP,PYUSADVP, PYUSCHKB, PYUSADVB)
• Implemented the requirement of zero net pay employees should be available only on SSP templates, but should be suppressed on PRT templates on paycheck
• Developed a SQR program to generate new hire, terminations, company change, and location change reports.
• These are changes only files which include the data from last run date of the program to sysdate
• Developed an Application engine program using Filelayout to generate the output files based on the company.
• These output files are changes only files which contain the employees’ data and their dependents data.
• Developed a Component interface to load the data into custom component using Application Engine.
• Developed application engine program and SQR for data conversion.
• Retrofitted SQR and Application Engine programs.
• Developed an outbound SQR to write the employees information who have been hired in last 60 days to a file.
• Designed and developed PeopleSoft objects such as Menus, Components, Pages and Records using the Application Designer and modified the existing objects like Components, Pages, Records and Menu definitions.
• Developed complex SQL queries for various purposes.
• Worked on production support issues.
• Fixed over 300 defects (issues/bugs) during the testing phase.
• Performed unit testing to ensure quality.
• Assisted object migration.
• Developed numerous data mover scripts for various reasons

Confidential, Cincinnati, OH

PeopleSoft Specialist

Environment: PeopleSoft HRMS 9.0, People Tools 8.50, Oracle 11g, Unix

Responsibilities:

• Developed technical designs based on the functional requirements given.
• Coordinated with Business analyst to gather business requirements to understand & implement the requirements.
• Configured integration broker for outbound CI based service on job data and personal data component.
• Developed a SQR program for data conversion from legacy system to PeopleSoft system.
• Developed a SQR program to generate an output file for employees who have been enrolled in dental plan. This file contains employees and their dependents information.
• Developed Sub-pay module to pay the employees with specified earncodes. The purpose of this module is to have the entry for those employees to enter their claims.
• Developed an application engine program using CI to load the new hire and terminations data to the custom tables.
• Developed a report to have the MTD, YTD, QTD hours and earnings based on the paygroup and dedcd.
• Customized a few application engine programs to meet the new requirements.
• Designed a page to track all the interfaces that the client have.
• Developed a few reports using PS Query and XML/BI publisher s as per the client’s requirements.
• Fixed over 500 defects (issues/bugs) during the testing phase/initial support.
• Worked on production support issues. Provided workaround solutions during the support.
• Coordinated with offshore technical team.
• Analyzed compare reports
• Performed unit testing to ensure quality.

Confidential

PeopleSoft Developer

Environment: PeopleSoft HRMS 9.0, People Tools 8.49, Oracle 11g, Unix

Responsibilities:

• Developed technical designs based on the functional requirements given.
• Developed an ExceltoCI interface to load the data into a custom table.
• Implemented audit functionality on a custom table using Component Interface.
• Developed an inbound SQR to process flat files (like termination, new hire etc.) and insert the data into custom tables.
• Developed an application engine program to coy the data from JOB table to a custom table based on the given criteria.
• Supported various processes (SQR, Appengine, CI etc.) to resolve the existing bugs and to implement enhancements.
• Developed online objects to have a common setup page for all the interfaces that the client have.
• Developed various SQL scripts for one time processing.
• Coordinated with offshore technical team.
• Performed unit testing to ensure quality.
• Fixed over 200 defects (issues/bugs) during the testing phase/initial support.

Confidential

PeopleSoft Developer

Environment: PeopleSoft HRMS 8.8, People Tools 8.46, Oracle 11g, Unix

Responsibilities:

• Supported various processes (SQR, Appengine, CI etc.) to resolve the existing bugs and to implement enhancements.
• Involved in Enhancing SQR Reports like business logic changes, Header and Footer changes and layout of reports.
• Resolved daily defects (issues/bugs) during the maintenance
• Developed a SQR program to generate at output file that contain employees who have been terminated in last 30 days.
• Worked on application engine programs to add new fields to state record and modified them accordingly.
• Developed and modified reports using PS query.
• Developed interfaces for payroll such as deduction calculation: This SQR program generates deduction codes for each employee’s benefit plan elected for the given year.
• Developed a page to enter the dependent’s education details.
• Worked on changes related to year end processes.
• Modified an Application engine program to have the bulk insert functionality.