Summary

• 6 Years of experience in PeopleSoft HCM / HRMS modules including Core HR, North America Payroll, Time and Labor, ESS, MSS, Base Benefits, Benefits administration and ePerformance and GL.
• Hands on Experience in Analysis, Design, Development, Upgrade, Customizing and Enhancement of PeopleSoft Applications.
• Experienced in PeopleSoft Upgrade, Devising Implementation Methodology, Reporting, Interfaces, Conversion Strategy, Enhancing, Production Support and Troubleshooting.
• Extensively involved and worked with Security Administrator to implement security in various levels like Roles, Permission Lists, User Profiles, Portal Security, Query/Tree Security and Definition Security.
• Hands on Experience in Developing and Customizing of PeopleSoft objects using Application Designer, PIA/Online, Integration Tools, Reporting Tools, PeopleTools, Data Mover and SQL Scripts.
• Worked Extensively on PeopleTools, Application Messaging, PeopleCode, Application Engine, Component Interface, File Layouts, Integration Broker, PS Query, SQR, Crystal Reports, Workflow Processing and Approval Framework.
• Experienced in working with technical issues with SQR programs, Application Engine Programs, Migrating Objects and Projects between databases.
• Experienced in Performance tuning of processes. Well versed with Debugging tools like SQL trace, PC debugger, AE trace and SQR trace for troubleshooting.
• Understanding the functional design documents to develop Technical Design Document along with test strategy / test plan.
• Very good understanding on PeopleSoft Internet Architecture PIA
• Developed several DMS and UNIX scripts for the Integration Projects.
• Developed Test scenarios and participate in testing.
• Document the processes developed and updated for future references.
• Involved in applying Tax Updated for future references.
• Well organized, and able to work individually or in a Team environment.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Title : PeopleSoft Techno/Functional Consultant

This Project is initially an upgrade from 8.9 to 9.1 and later Production Support for PeopleSoft HCM 9.1. Responsibilities included customizing Payroll, HR, Time Labor and eBenefits Modules. Customizing existing reports, creating new reports, loading from flat file to PS application tables

Roles and Responsibilities:

• Involved in requirement gathering, fit-gap analysis, design, development, Testing and documented processes.
• Involved in running Upgrade scripts using Change Assistant for the Upgrade process and analyzed Upgrade Compare reports to identify and document existing customizations.
• Involved in Data Conversion from the legacy System in to Oracle using SQL Loader, DMS scripts and SQRS. Developed number of conversion scripts and uploaded data. Used Change Assistant tool to move the objects from 8.9 to 9.1.
• Used People Tools in carrying over the customizations from the existing version to new upgrade version. Extensively used Application Designer for creating new objects, modifying the existing customizations and bringing them over successfully into 9.1.
• Resolved a security issue where row level security functionality was no longer available after the application was upgraded.
• Developed a batch Application Engine which uses CI to load General Deductions and Garnishments for each employee to reflect the company changes.
• Customized the eBenefits module according to functional requirements so that the employee has the ability to review and update benefits information online.
• Created new SQR Programs to update Annual Base Salary, and to add new Benefit programs, Plan, Plan Types and automated Benefit Admin Process.
• Involved in creating of Task Groups and establishing Time Periods, Calendars, Shifts, work schedule templates and work groups.
• Customized Daily Time Calendar, Weekly Elapsed Time Entry, Punch Time Entry and Manager Time Approval pages as per the requirements. Extensively used People Code and People Tools during the customization.
• Worked on setting up HSA and FSA Retirement Benefits.
• Developed Application Engine Process to Evaluate Retirement Indicators based on Employees Birth Service Dates.
• Modified 401K Interface to change the employee company.
• Implemented online and batch customizations in Payroll, HR, Time Labor, Benefits and Benefits Administration modules as per functional requirements.
• Effectively utilized tools and utilities provided by PeopleSoft Debugger, tracing etc for trouble shooting issues on PeopleCode, Application Engine, COBOL, SQR's Online.

Environment: PeopleSoft HCM V 9.1/8.9, PeopleTools 8.51/8.42, Oracle 10G, Windows NT.

Confidential

Title : PeopleSoft Techno/Functional Consultant

Roles and Responsibilities:

• Ran and reviewed the Initial Audit reports against copy of production to ensure that database is clean and also checked performance.
• Applied pre and post upgrade fixes and customized the pages according to change requests.
• Developed new Payroll Interface technical objects to create a streamlined integration with ADP Connection - outsourced payroll.
• Performed detailed functional analysis of all employee-level data elements shared between PeopleSoft HRMS and ADP Payroll.
• Developed Payroll Interface configuration and mappings. Worked with ADP performing partner relation.
• Developed a turnkey solution to interface to ADP PC/Payroll for Windows with PeopleSoft HRMS.
• Independently developed a turnkey solution to interface to ADP Payroll US with PeopleSoft HRMS.
• Design and set-up of Time and Labor interface to ADP system.
• Successfully completed the performance evaluation for the ePerformance module wherein a manager can perform performance evaluation of his employees.
• Extensively worked on Process Scheduler, Tree Manager and Query Manager.
• Provided Security to various Menus, Components Pages using Security Administrator and also Added Folders and Content references using Portal Administrator.
• Involved in debugging Application Engine programs and PeopleCode using PeopleCode Debugger.
• Enhanced the Journal approval workflow, which includes the approval/deny journal activity and the journal entry approval Rule Set to meet the requirements of the company policy.
• Bug fixing and Trouble shooting of Application Engine and Batch programs using PeopleSoft Debugger.
• Retrofitted PeopleCode, SQR to accommodate customizations to meet the business requirements.
• Applied Patches and Bundles delivered by PeopleSoft during the upgrade and tested them before applying to the production database.
• Provided post production support in resolving all production issues.
• Involved in the process of Upgradation from PeopleSoft 8.4 HRMS to PeopleSoft 9.0 using Upgrade Assistant, Data Mover. Ran numerous .dms scripts, .sqr scripts using Data Mover.
• Reapplied all the customizations, which are effected by Upgradation process and Upgraded SQR's from 8.4 to 9.0.

Environment: PeopleSoft HCM 9.0/8.4, People Tools 8.48/8.42, Oracle 9i, Windows XP.

Confidential

Title : Senior PeopleSoft Technical Consultant

This Project involved creating interfaces, creating SQR and PS Query reports, Customizations for the HRMS modules, data validations using PeopleCode and creation of new records, panels using Application designer.

Roles and Responsibilities:

• 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.
• Customized the delivered Application Engine HR PER502 for Change ID and Delete ID Process as per the client requirement.
• Created the Year end SQR process for enrolling the new Deductions who are employees turning AGE50.
• Designed and Develop the new Workers Compensation Code report using SQR.
• Develop the new SQR for the employee suspension Process to stop the restoration bonus Deductions for employees on suspension.
• Created the custom processes to track the employees shares and dividends in PeopleSoft Payroll system and off set the netpay and calculated the taxes.
• Worked on Payroll deductions, Pay calendars, running of the Payroll process from Pay calendar, Pay sheet/unsheet, Pay calculation to Pay confirm/unconfirm .
• Involved in applying theTaxupdates.
• Cloned and modified complex SQRs DDP003 and PAY003 as per the client requirement to print the paycheck information to the My HR system third party .
• Worked on XML publisher to generate employee promotion letter as per the client requirement.
• Created new Application Package for sending request and getting response from the work brain system to PS system using web services.
• Worked on Separation Customized module, developed online pages and custom records to store Employee separation Process and developed Approval Workflow Engine for Approval Process as per the Client Requirement.
• Developed Promotion Interface using File Layout, Application Engine, and Component Interface, which loads data from CSV into staging tables while doing various data validations using AE Peoplecode and finally loads into PeopleSoft tables through Component Interface.
• Developed synchronous request/response type of integration in Same Day Termination Tool with work brain system third party using web services for worked hours.
• Developed SQR reports that displayed Leave Accrual information by leave plan and employee. It included information such as plan year eligibility hours, carryover hours earned year-to-date, hours taken year-to-date and remaining leave balances.
• Designed technical approach for data conversion using Application Engine and Component Interface.
• Created new and customized existing PeopleSoft objects Panels, Panel Groups, Menus, People Code, Process Definition and applied Security.
• Trouble shooting HR and Payroll issues as part of daily production support.
• Worked extensively on People Code to implement the new required business rules of the client and also modified the Delivered People Code as per Business requirements.
• Was involved in coding, unit testing and peer reviews of the requests in the project which includes People Code, App Engine Programs, and File Layout.

Environment: PeopleSoft HRMS 8.4, People Tools 8.42, Oracle 10G, Windows XP.

Confidential

Title : PeopleSoft Technical Consultant

Roles and Responsibilities:

• Designed Technical specifications and Developed new objects, Reports and Customization of vanilla Reports, Objects as per the Business process requirements and End User / Client requirements.
• Involved in writing Interface programs, Data Conversion programs, Key reports for HR and Benefits modules. Setup Workflow rules and roles, wrote queries. Also modified pages and panels according to the user's requirements.
• Worked with functional analysts and collected data requirements for Conversion and Interface programs.
• Executed test plans to cover from the initial acceptance of employee time from the third party to pay sheet creation by the custom modules. Modification and Customization using Application Designer and PeopleTool.
• Developed Conversion programs using App Engine, File layout and Component Interface to load data from the Legacy system to People Soft HEALTH BENEFIT Table, LIFE ADD BEN Table, SAVINGS PLAN Table, LEAVE PLAN Table, and LEAVE ACCRUAL Table.
• Customized various components/pages in the areas of Job Data, Job Entry application engine programs and other SQR programs in HR and Payroll Modules.
• Devised, Documented, Implemented Security features Page, Processes, Definition Security, and Data security for all modules.
• Wrote validation SQL for Payroll interfaces to provide new organization structured Payroll related data to the ProBusiness such as Deduction data, Direct Deposit data, Earnings data etc.
• Implemented Sign-on security, Row-level security, Field-level security, Object-level security to control application security using Administrator and Object Security.
• Developed an Application Engine program in Time Labor, which loads employee data for multiple Business Units from flat file via Component Interface. Various data validations are performed using Application Engine PeopleCode.
• Developed Custom Workflow to notify Managers, Leave Administrators after running time admin where an employee's reporting time has leave TRCs.

Environment: PeopleSoft HRMS 8.9, PeopleTools 8.46, Oracle 9i, Windows XP.

Confidential

Title : PeopleSoft Developer

Roles and Responsibilities:

• Involved in User Security Setup like creating new roles, permission lists, assigning authorizations for users etc.
• Created Interfaces using Application Engine, Component Interface and File Layout to create User profiles depending on the employee information in a flat file.
• Involved in setting up the rules and roles and routings for the various Workflow E-Mail notifications such as marital status change, reporting change, Benefits enrollment notification, dependent benefits info change in collaborative applications.
• Update the Job Data component using Application Engine program and Component Interface whos employees jobcode change,company change and paygroup change.
• Used File Layout Definition to get data from the legacy system to PeopleSoft tables using Application Engine Program.
• Worked with Prompt tables,Dynamic prompt tables and also worked in SQL Views and Dynamic Views to optimize the Query performance and used views as search records.
• Developed Dashboards using pagelets for Manager which shows his/her employee's time approval needs to be done when they login on to PS.
• Created technical design, unit test plan and test case documents for the development.
• Worked extensively on People Code to implement the new required business rules of the client and also modified the Delivered People Code as Business requirements
• Prepared technical specifications for Payroll, HR, Time Labor and Benefits Modules.
• Involved in Field Mapping for the tables.
• Developed Workgroups, TRC'S. TRC Programs, Rule Programs, Value Lists, Static and Dynamic Groups.
• Developed Custom Time and Labor Reports which included Compare Reports, which were extensively used while transferring data from a Third party system to PeopleSoft Time and Labor.
• Developed Technical Design Documents and Test Case Documents.
• Developed a custom report to get employee status and head count for each department.
• Involved in Testing Applications.
• Developed Application Messaging to poll Job data from legacy system.

Environment: PeopleSoft HRMS 8.8, People Tools 8.44, Windows NT and Oracle 8i.