SUMMARY

• Around Seven years of experience in Implementation, Upgrade and Development of PeopleSoft HRMS modules like PeopleSoft HR, Benefits, Payroll, Time and Labor.
• Expert with strong PeopleSoft technical skills include PeopleTools (Application Designer, PeopleCode, Application Engine, Component Interface, Process Scheduler, Query, Data Mover, Security Administrator and Definition Security.
• Very good at interacting with users and discussing about different PeopleSoft business issues, and the gathering business requirements, and translated them into to Techno - functional specifications.
• Very good at developing new applications from scratch /customizing existing applications using Application Designer capabilities, People Code, Core Workflow and other People Tools.
• Good at PeopleSoft Application Integration technologies like Component Interfaces, Integration broker and Business Interlinks.
• Developed many reports using PS/Query &Crystal and SQR, including dynamically changing output-generating reports using SQR methods like Break Logic, Load-Lookup, Arrays, Multiple reports, and Form reports etc.
• Very good in debugging, analytical thinking, error fixing, testing, and Performance tuning of the code.
• Experience in Batch Processing, Upgrade, Migration and Interfaces Development.
• Extensive experience in reporting using various reporting tools such as SQRs, Crystal Reports.
• Involved in test plans &scenarios development, and in actual unit, system integration, performance of various on-line application components and reports developed /upgraded.
• Techno-Functional support to address any production issues/bugs and enhancements.
• Involved in addressing the issues related with PeopleSoft Security related to Users, Roles, Permission Lists, Password related, Object and Query Security.
• Excellent problem solving, analytical, interpersonal and communication skills. Ability to work in groups as well as independently.
• Excellent troubleshooting and problem-solving skills.
• Team player with excellent interpersonal communication skills and technical documentation.

TECHNICAL SKILLS

ERP: PeopleSoft 9.1/9.0/8.9/8.8/8.3 HRMS (HR, Payroll, Benefits, Time & Labor)

Reporting Tools: XML Publisher, SQR, Crystal Reports.

People Tools: Application Designer, Configuration Manager, Tree Manager, Process Scheduler, Process Monitor, People Code debugger, Application Engine.

Data Management Tools: Import Manager, Data Mover

RDBMS: Oracle 7.x/8.0, MS SQL Server, Sybase SQL server, MS Access, DB2

Operating Systems: Windows NT, Windows 2000/98/95.

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

PeopleSoft Techno/Functional Consultant

Responsibilities:

• Actively involved in all stages of Upgrade of PeopleSoft HCM from version 8.9 to 9.1
• Involved in running upgrade scripts using Change Assistant
• Conducted multiple Fit Gap Analysis sessions and analyzed upgrade compare reports to identify and document existing customizations
• Involved in Retrofitting of several customized objects like Application Engines, SQR's in the process of upgrade
• Run SYSAUDIT, DDDAUDIT reports to identify integrity issues.
• Developed Application Engine Program to upload Hire Information from data file into PS staging tables using File Layouts and PeopleCode, which will be further populated into Corresponding PS tables using Conversion SQR programs
• Involved in Pay Sheet Generation, performing Pay Calculations, Pay Confirmations and producing payroll reports.
• Configured and maintained all the tables involved in Payroll processing like Pay Calendar, Job Code, Deductions and processes such as Pay Sheet Creation, Pay Calc, Pay Confirm, Tax Tables
• Modified existing offer letter report formats and developed XML Publisher reports using PS query
• Used Integration Broker to publish the employee information from PS HCM to other application.
• Designed and Developed Inbound Interface to import employee health care and benefit changes from third party benefit provider to PeopleSoft using Application Engine and Component Interface
• Developed several reports to audit the weekly Payroll Process such as future dated tax balance rows, pay line status count, payroll summary.
• Developed Data Conversion Programs for Dependent Data Component, Personal Data Component, Job History and other Benefits and Payroll components using Application Engine, Component Interface and File Layout
• Developed the SQR inbound interface to insert the company match data into Payroll deduction tables after each pay calculation.
• Involved in changing search records to establish Row Level Security. Created Permission Lists, User Profiles to maintain Security
• Created a customized Workflow which transfers a Hiring Document from one manager to another
• Designed and developed PeopleCode to set up Workflow for Hiring and triggering events to mail the new hire details to all administrators such as Payroll, Benefits
• Participated in on-going Production Support. Involved in the debugging of errors and modifications to various objects related to HR, Payroll, Benefits & Time and Labor modules

Environment: PeopleSoft HCM 8.9/9.1 (HR, Benefits, Payroll, Time & Labor) PeopleTools 8.46/8.52, App Engine, File Layout, Component Interface, Integration Broker, SQR, PS Query, XML Publisher, Oracle 10g

Confidential, South Portland, ME

PeopleSoft Techno/Functional Consultant

Responsibilities:

• Developed conversion programs using Application Engine, File Layout and Component Interface to load data from the legacy system to PeopleSoft Health Benefit Table, Life Add Ben Table, Savings Plan Table, Leave Plan Table and Leave Accrual Table.
• Customized Daily Time Calendar, Weekly Elapsed Time Entry, Punch Time Entry and Manager Time Approval Pages as per the requirements. Extensively used PeopleCode and PeopleTools during the customization.
• Involved in creating of Task Groups and establishing Time Periods, Calendars, Shifts, Work Schedule Templates and Work Groups.
• Developed interfaces for Payroll, such as Deduction Calculation, this SQR generates deduction codes for each employee's benefit plans elected for that particular year, these deduction codes are used by the payroll department to process (Benefits Billing Process) the pay of employees.
• Involved in organizing the Payroll Process using Pay Groups, Pay Calendars and Pay Run Ids. Also created Pay Sheets which are the repository data required for employees Pay Calculations for each pay period.
• Created various XML Publisher reports across various modules for specific client requirements.
• Defined Time and Labor Static and Dynamic work groups for specific group of time reporters
• Worked on employee Payroll Deductions, Pay Calendars, running of the payroll process (from Pay Calendar, Pay Sheet/unsheet, Pay Calculation to Pay Confirm/unconfirm). Customized paycheck interfaces and yearly earnings statement reports.
• Customization of Health, Disability, Savings Plan, Life & FMLA page in the Benefits module
• Defined Benefit Plans, Customize Benefit programs with the Benefit/Deduction Program Table Group, adopted Benefit programs for Health plans, Life plan, Dental plans, Establishing Rates and Calculation Rules.
• Worked on Row Level Security Permission List to limit the access of records and fields for time reporters based on the group membership.
• Maintained PeopleSoft User Security using PeopleSoft Security Administrator and Operator Preferences, using Query Trees, User Profiles, Permission Lists and Roles
• Set up and customized Work Schedules by creating Shifts, Workdays, and Schedule Definitions
• Assisted and guided employees with report and interface development. Performed the design and development of several HR Payroll interfaces using SQR
• Used Process Scheduler to run the processes & reports through PeopleSoft Pages and used process monitor to view the status of the reports
• Developed the Customizations to the delivered package of PeopleSoft as per the client's requirements. Customizations include restructuring the table structure, redesigning the delivered pages, modifying the People code to change the functionality

Environment: PeopleSoft HCM 9.0 (HR, Benefits, Time & Labor, Payroll), PeopleTools 8.48, Application Engine, Component Interface, File Layout, PeopleCode, SQR, PS Query, Oracle 9i, Windows Server 2003.

Confidential, Hartford, CT

PeopleSoft Technical Developer

Responsibilities:

• Extensively involved in upgrade of PeopleSoft HRMS v8.3 to v8.9
• Involved in the retrofitting of SQR'S and Application Engine programs for 8.9 Upgrade
• Analyzed SYSAUDIT and DDDAUDIT report to fix orphaned objects and inconsistencies
• Created and maintained documentation of all changes in the upgrade process
• Participated in the daily meetings to discuss the status of issues with the user groups
• Troubleshooting of day to day production support problems from technical as well as functional perspective for the business processes
• Analyzed the existing Applications and evaluated the customization involved in the Development, Upgrade and Testing of all the HR, Benefits, Payroll and Time and Labor interfaces as a key team player of the Interface team
• Custom designed delivered Pages, Components as per the required functionality
• Used Application Engine program, its related objects like State and Temp record, File Layouts and PeopleCode for extracting data, validating data, creating outbound files and other processes like updates and insertion of data into various tables
• Used the Upgrade Assistant tool to guide in upgrade process by creating and running jobs in sequence as listed. Involved in running and reviewing the compare reports to override or keep the custom objects from version 8.3. The new release objects were copied from 8.9 databases to the Copy of Production databases
• Involved in online changes like adding customized-translated values, modifying PeopleCode, adding fields to record definitions and pages. Involved in unit testing. Coordinated with developers, users and testing team in specifically implementing the business requirements and customization into PeopleSoft application

Environment: PeopleSoft HRMS 8.3/8.9 (HR, Benefits, Time & Labor, Payroll), PeopleTools 8.16/8.46, Application Engine, PS Query, SQR, Oracle 8i.

Confidential, Atlanta, GA

PeopleSoft Technical Consultant

Responsibilities:

• Developed a process to load the timesheet information to payroll, benefits day accrual and employee balances. Created a workflow for timesheet approval
• Customized the PAY003.sqr, DDP003.sqr, paycheck and pay advice generation process
• Synchronized Setup data, such as task detail, time reporter and supervisor information with the clock system
• Solved issues which arise due to elapsed time and punch time errors
• Developed custom Time and Labor Queries to enable Functional users to identify specific employees
• Manage exceptions for Time reporters and approve time by Time reporters, requesting batch approval processes, reviewing attendance history
• 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
• Performed Interfacing, Conversions, data migration and report writing (using People Code, People Tools and SQR)
• Involved in developing new People Code and customizing existing People Code based on specific client functional requirements
• As a PeopleSoft Developer, was involved in designing the Payroll and Benefits Systems, Paycheck Generation, setting up of employee payroll data, calculating pay and customizing payroll and tax reports.

Environment: PeopleSoft HRMS 8.9 (Time and Labor, Payroll), PeopleTools 8.46, PeopleCode, SQR, PS Query, Oracle 8g

Confidential, Jacksonville, FL

PeopleSoft Technical Developer

Responsibilities:

• Solved issues which arise due to elapsed time and punch time errors.
• Developed custom Time and Labor Queries to enable Functional users to identify specific employees.
• Manage exceptions for Time reporters and approve time by Time reporters, requesting batch approval processes, reviewing attendance history.
• Set up 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 custom Time and Labor rules to take care of Rounding Rules, Meal over Times and Scheduled Day off.
• Created custom processes to have hourly employee counts based on the Full or Part Time status and the number of active hours worked.
• Performed Interfacing, Conversions, data migration and report writing (using People Code, People Tools and SQR).
• Involved in developing new People Code and customizing existing People Code based on specific client functional requirements.

Environment: PeopleSoft HRMS 8.8, PeopleTools 8.43, Time and Labor Payroll, Benefits, Application Engine, SQR, PSQuery, Windows 2000.