SUMMARY

• Over 9 years of experience as a PeopleSoft HCM/HRMS Techno functional Consultant involved in complete PeopleSoft Implementations involving, Requirements analysis, Fit - Gap-Analysis, Specification, Design, Development, Conversions, Upgrade, Maintenance and Performance Tuning.
• Possess good Functional and Technical knowledge of various modules in PeopleSoft HCM/HRMS such as Human Resource, Payroll, Benefits, Benefits Administration, Time & Labor, Absence Management, Employee Self-service (ESS) and Manager Self-service (MSS).
• Well conversant with documentation for specifications, developing test cases, technical design and writing training manual for end users.
• Involved in implementation, customization, upgrade and maintenance of HR, Benefits, Benefit Admin, Payroll, Time & Labor, Absence Management and Self Services modules (eRecruit, ePay, eProfile, ePerformance, eCompensation and eBenefits).
• Extensively worked on People Tools, People code, Application Designer, SQR, Maintain Security, Object security, Tree Manager, Process Scheduler, Component Interfaces, Data Mover, Application Messaging, Application Engine, Workflow, Component Interfaces, Integration Broker etc.
• Expert in PeopleSoft Internet Architecture (PIA) and Open Integration Technology tools Application Engine, Component Interface, Approval Workflow Engine and Approval Framework.
• Extensively used reporting tools such as PS Query, SQR, XML Publisher, Crystal Reports and nVision to continually improve the reporting experience for the user base.
• Developed new SQR’s from scratch to meet the customer requirements and supported the customization. Developed and modified Outbound and Inbound SQR interfaces
• Built Application Engine processes for ensuring data integrity and third-party interfaces and was involved in performance tuning of the Application Engine Programs using Traces.
• Extensively worked on implementing updates/fixes and upgrades for PeopleSoft applications and People Tools.
• Worked individually, as well as in team environment, to achieve project goals.
• Skilled at building a strong team environment, and have the ability to acclimatize to new technologies and situations with ease.

TECHNICAL SKILLS

Application Release: PeopleSoft v 9.2/9.1/9.0/8.9/8.8/8.3/8.0 People Tools Versions 8.46, 8.47, 8.48,8.49,8.51,8.53

People Tools: Application Designer, People Code, Application package, Portal UtilitiesApplication Reviewer, Workflow, Application Engine, Component Interface, Process Scheduler, Tree Manager, Data Mover, Change Assistant

Reporting Tools: XML Publisher, SQR, PS Query, Crystal Reports, Query Analyzer 8.0

Integration Tools: Integration Broker, File Layout, Application Engine & Component Interface

RDBMS: Oracle 9i, 10g,11g, MS-SQL Server 2000

Languages: SQL & PL/SQL, C, C++

Operating Systems: Windows NT 4.0,2000,XP MS-DOS, UNIX and AIX Unix

Bug Tracking tools: Test Director

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Sr. PeopleSoft Consultant

Responsibilities:

• Involved in Fit Gap analysis of the upgrade project.
• Customized PeopleSoft delivered transcripts and Application Engine Program to meet Client requirements.
• Created new templates and sub templates for Hospitals requirements.
• Developed new Application Engine Program and Component interface for inactive employee process.
• Involved in working on Approval Workflow setup.
• Involved in gathering functional requirements.
• Retrofitted AWE customizations.
• Setting up configurable sections for extended absences & approvals with absence management.
• Customized workflow Message Notification Templates.
• Participated in Design meetings, code reviews and implemented Technical Design documents.
• Modified the Roll prior term’s schedule program to copy the facility information.
• Developed new interface using Integration Broker to publish messages when the vendor information is updated.
• Design and develop custom rules in Time and Labor.
• Verified SYSAUDIT and DDDAUDIT reports and fixed the errors.
• Involved in modifying the custom SQR reports and developing new SQR reports.
• Involved in writing new XML Publisher reports for their needs.
• Developed outbound interfaces PeopleSoft HR Vendor information using Web services, Integration Broker.
• Involved in Preparing design document & technical specifications.
• Involved in preparing the change control package, implementation log for production moves.
• Involved in Preparing Test Plans & Executing the Test Cases for Unit, System testing.

Environment: PeopleSoft v9.2 ( HR, Payroll, Benefits, T&L & Self Service), People Tools - 8.53, People code, SQR, UNIX, COBOL, Oracle(TOAD,SQL*plus).

Confidential, Seattle WA

Sr. PeopleSoft Consultant

Responsibilities:

• Retrofitting of both online and batch objects, (i.e., pages, fields/records, modified PeopleCode, SQR, Application Engines, Component Interface, Application package etc.) through patch application and/or application development.
• Involved in Fit Gap analysis of the upgrade project
• Retrofitted Approval workflow Engine changes.
• Worked on enhancements in Levels of Approval’s required in Workflow.
• Worked on Employee Self Service and Manager Self Service.
• Customized workflow to hide Supervisor field on the Promote Employees page.
• Worked on Employee Self Service workflow setups for Promotion, Salary Change, Transfer Employee, Termination Transaction, Name Change, Marital Status change, Reporting Change and Etc.
• Worked on Manager Self Service workflow setups for View Employee personal Data.
• Verified SYSAUDIT and DDDAUDIT reports and fixed the errors.
• Involved in modifying the custom SQR reports and developing new SQR reports.
• Involved in writing new XML Publisher reports for their needs using query and Connected Query.
• Converted SQR reports into XML publisher reports, as they needed templates to be modified by users when needed.
• Involved in modifying the PS Queries.
• Used People Tools Application Designer, Peoplecode, Application Engine, Process Scheduler, Process Monitor, Query and Maintain Security.
• Involved in Preparing design document & technical specifications.
• Involved in preparing the change control package, implementation log for production moves.
• Involved in Preparing Test Plans & Executing the Test Cases for Unit, System testing.

Environment: PeopleSoft v9.1 (HR, Payroll, Benefits, T&L & Self Service), People Tools - 8.53, People code, SQR, UNIX, COBOL, Oracle (TOAD,SQL*plus).

Confidential, Charlotte,NC

Sr. PeopleSoft Consultant

Responsibilities:

• Conversion and implementation of PeopleSoft 9.0 (HR, Payroll, T&L, Benefits, Self Service).
• Involved in requirement analysis sessions for health & welfare, 401k, Total rewards projects.
• Worked with functional analysts in gathering the requirements for converting the third party vendor interfaces according to requirements.
• Involved in Taleo data migration to load data from excel sheets to load it into oracle database.
• Designed & Developed an SQR process to read the payroll instructions files for a third party vendors called Hewitt & Travelers into PeopleSoft module.
• Designed & Developed an SQR process to write a third party vendor outbound interface as per Hewitt, Traveler & Mass Mutual vendors as per their file layout formats, which contains amounts that have been deducted from their salary towards their deductions as and when payroll runs.
• Designed & Developed an SQR to generate salary & Incentive Database file from PeopleSoft for ecomp module.
• Involved in customizing workflow for self-service modules.
• Conversion of COBOL programs to SQR’s and App Engines.
• Involved with Functional Analysts to design & develop an SQR processes to process roll over plan in savings plan module when an employee hits their maximum contribution limit as per client business requirements.
• Involved with Functional Analysts to develop several data migration sqls to compare the before and after converted data between Tessreact legacy system and PeopleSoft system.
• Developed ecomp statement custom pages as per new business requirements.
• Modified custom eligible pay compensation app. engine to in corporate new business requirements.
• Involved in Benefits annual enrollment project to modify batch interface programs as per functional requirements.
• Worked with external providers to understand interface requirements and deliver solutions to meet those requirements
• Responsible for converting interfaces into PeopleSoft from legacy Tesseract system using SQR’s.
• Involved in ExcelToCI process to load the rapid entry data into PeopleSoft environment.
• Involved in preparing the change control package, implementation log for production moves.
• Involved in preparing NDM Unix Scripts and Auto sys Jill scripts for newly developed batch interfaces.
• Involved in Preparing design document & technical specifications.
• Involved in Preparing Test Plans & Executing the Test Cases for Unit, System testing.

Environment: PeopleSoft v8.9 (HR, Payroll, Benefits, T&L & Self Service), People Tools - 8.49.20, People code, SQR, UNIX, COBOL, Oracle(TOAD,SQL*plus), Serena Change Control, Tesseract.

Confidential, Chicago, IL

Sr. PeopleSoft Consultant

Responsibilities:

• Worked with functional analysts to determine what customizations were needed for the new release and reinstated the pertinent customizations.
• Analyzed existing customizations in 8.8 and documented the changes required for new release.
• Analyzed compare reports to determine objects to carry forward during the upgrade effort.
• Retrofitting of both online and batch objects, (i.e., pages, fields/records, modified PeopleCode, SQR, AppEngines, Component Interface, Applicaton package etc.) through patch application and/or application development.
• Involved in verification of converted data in the test environments. Worked with conversion team in fixing the data defects found in the test environments.
• Retrofitted, recompiled & tested TL rules using Templates, SQL objects, User Exits during reapplying customizations phase.
• Worked on e-Recruit & Benefits module to rewrite interfaces by using component interface, App. engine, Application package, Peoplecode, etc.
• Conversion of COBOL programs and debugging COBOL Programs.
• Retrofitted and Tested all TL related online and Batch objects
• Fixed Mass time reporting App. engine process in MSS during reapplying customization phase.
• Worked on TL Admin process to fix some errors during testing phase.
• Worked on TL Managaer Approval page in MSS to fix some defects & add some enhancements on deleivelerd page.
• Involved in Data conversion process to load the TL EE user preference data and then migrated that same processes into system test environment.
• Worked on data conversion issue regarding the Rehire date value on job record.
• Worked on ePay customization for check printing and Advice printing SQR process as per the new business enhancements to make it work as per new release by using XML Publisher.
• Involved in XML Publisher Setup, Modified the Paycheck Template as per new business requirements.
• Worked on MICR code customization for paycheck and added the font XML Publisher Template to preview.
• Retrofitted several eBenefit & ePerformance customizations to make it work as per new release.
• Worked on third party vendor interfaces under Benefits admin module as per business requirements.
• Retrofitted the custom Workflow objects such as Business process, Activity, Events
• Involved in TAM Module for rewriting Hire Applicants process for hire, rehire & contingent worker assignments by using component interface, App. engine, Application package, Peoplecode, etc.
• Worked on GL Account error when setting up Deduction and Company Local Tax Pages.
• Closely worked with DBA’s to rectify performance related issues by analyzing the explain plan results.
• Modified & fixed several reports processes during the application upgrade process.
• Unit tested using JCL’s & defects fixed for several Batch processes in HR, Benefits, TL & Payroll.
• Preparing design document, migration document and technical specifications.
• Involved in Preparing Test Plans & Executing the Test Cases for Unit, System, Parallel and UAT.

Environment: PeopleSoft v8.8-9.0 (HR, Payroll, Benefits Admin, T&L & Self Service), People Tools - 8.49.09/8.49.20 , People Click Recruitng Application, XML Publisher, Change Assistant, Win-XP, DB2, OS390,Unix, JCL, TSO/ISPF, QMF, DB2-Commad Center.

Confidential

PeopleSoft Consultant

Responsibilities:

• Configured and maintained all the tables involved in Payroll processing, such a Pay calendar, Job Code, Deductions and processes such as Pay sheet creation, Pay Calc, Pay Confirm, Tax Tables, etc.
• Created fields, Records, Customized PS Online pages, Components and Menu per the Company’s business rules for HR Application.
• Developed various new components including the payment tracking for vendors under different Benefit plans in Medical, Dental and Vision plan.
• Setup the Base Benefits including the Benefit Plans, Programs, Flat Rate and Calculation Rules Tables.
• Debugged and troubleshot payroll issues. Planned and prepared for the up gradation from 7.5 to 8.0.
• Ran initial Audit Reports to find inconsistency among database objects before initiating the upgrade process.
• Ran the PS Delivered Application Engine process for data conversion from our current Peoplesoft 7.5 application to Peoplesoft 8.0.
• Used Application Engine for batch processing that processes large amount of data without user intervention.
• Designed and Developed the Interface programs to move data from Mainframes to PeopleSoft tables using SQR and Import Manager as the primary tools.
• Used Process Scheduler to Schedule various SQRs and COBOL programs.
• Prepared a training documentation and trained developers and end users.

Environment: PeopleSoft 7.5/8.0 HRMS (HR, Payroll, Time & Labor, Benefits and Benefits Admin), People Code, SQR, Crystal Reports 8.0, People Tools 7.59/8.12, COBOL, JCL, and DB2 OS390