SUMMARY

• Over 9 years of IT experience including 8 years of experience in PeopleSoft, includes gathering user requirements, Systems Analysis, Design, Implementation, Upgrade, Development, Testing, Production support for Client Server and ERP applications.
• Expertise in PeopleSoft Implementation, Maintenance, Upgrading, Data Conversion, Interfacing/Reporting, Troubleshooting and Production support.
• Strong PeopleSoft analytical experience in HR, Base Benefits, Payroll, Payroll Interface, Time and Labor, Employee Self - Services and Manager Self-Services and complete understanding of complete project life cycle.
• Strong PeopleSoft technical skills including PeopleTools (Application Designer, PeopleCode, Application Engine, Component Interface, Process Scheduler, Component Interface, Workflow, Data Mover, Security Administrator and Security), SQR, and PSQuery.
• Experience and expertise in developing Application Engine Programs and performance tuning of Application Engine Programs using traces.
• Experience in developing interfaces, reports, and processes using Component Interface, File Layout, Application Engine, SQR and PeopleCode development.
• Expertise in the development of Interface applications by creating PeopleSoft objects such as fields, records, page, component, grids and menus.
• Experience in testing and issue resolution during the parallel test and the postproduction support.
• Excellent management and documentation skills.
• Proven ability to work in a team as well as individually in various projects.

TECHNICAL SKILLS

ERP: PeopleSoft 9.1/9.0/8.9/8.8/8.3/8.0/7. xHRMS (Time and Labor, HR, Payroll, Benefits, eApplications)

PeopleTools: Application Designer, Configuration Manager, Tree Manager, Process Scheduler, Process Monitor, PeopleCode debugger, Application Engine, File Layout, Component Interface

Reporting Tools: SQR, PSQuery

Programming Languages: PeopleCode, SQL, PL/SQL, Java, C, C++

RDBMS: Oracle 11g, MS SQL Server, Sybase SQL server, MS Access, DB2

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

PROFESSIONAL EXPERIENCE

Confidential, Orangeburg, NY

Sr. Peoplesoft Tech-functional Analyst

Responsilities:

• Performed fit-gap analysis, retrofit analysis for Payroll and Time & Labor Online and batch processes for 8.9 to 9.1 Upgrade.
• Retrofitted Payroll and Time & Labor online objects and batch processes for 9.1 upgrade.
• Retrofitted various custom Payroll inbound and outbound processes for 9.1 upgrade as per client requirements.
• Fit gap analysis, Impact Analysis for 8.9 to 9.1 Upgrade
• Retrofitted timesheet page, timesheet audit page, exceptions page for ESS, MSS and TL Admin roles.
• Modified various custom TL SQRs and App Engine programs as per client needs.
• Requirement analysis with business managers for One HR data standardization.
• Performed impact analysis and involved in data conversion and for OneHR Data Standardization for the same.
• Customized Online components, Batch Programs for OneHR Data Standardization.
• Involved in Post production issue resolution.
• Co-ordination with testing teams for QAT and UAT testing.
• Involved in project change control meetings for project deployment into production environment.
• Involved in gathering requirements for California MEAL TRC revision project.
• Setting up TRC code, creating/updating TRC programs for California Non-exempt, Intern employees.
• Customized value lists, Rule programs and workgroups for CA MEAL rev. project.
• Detail documentation of both technical and functional requirements.

Environment: Peoplesoft 9.1, Peopletools 8.52

Confidential, NY

Sr. Peoplesoft Techno-functional Analyst

Responsibilities:

• Conducted fit gap analysis for Payroll ADP conversion as per the client needs.
• Lead and completed all system configuration/setup tasks.
• Authored all functional designs
• Lead System Test and UAT for Payroll conversion to ADP.
• Developed various custom SQRs for payroll conversion to ADP.
• Designed and developed the PETS (Personal Employee Trading system) as per the client requirements.

Environment: Peoplesoft 9.0, Peopletools 8.5

Confidential, NY

Sr. Peoplesoft Techno-functional Consultant

Responsibilities:

• Configuring and setting up of pay groups and earning codes to process encumbrances and performed fit-gap analysis for the same.
• Involved in developing data conversion programs from legacy (mainframe systems) into Peoplesoft.
• Developed custom App Engine program for Encumbrance process to encumber Regular Compensation and Additional pay.
• Configuration and setting up of Template Based Hires templates as per the client needs.
• Developed custom application packages for template based hires to validate additional compensation and salary distribution.
• Customized hire and rehire templates to add salary distribution and additional data pages.
• Developed custom App Engine Program to extract the Actual and Encumbrances to FAS Finance systems.
• Developed custom component interfaces to load the additional pay and compensation distribution for the additional pay component and department budget component.
• Developed various custom inbound and outbound interfaces.
• Developed various run control pages to execute various App Engine Programs.
• Involved in creating and executing unit test and system testing scripts.
• Involved in the requirement gathering, analysis and detail documentation of technical and functional specs.

Environment: Peoplesoft 9.0, Peopletools 8.5, Stat 5.5

Confidential, Bedminster, NJ

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Analyzed, gathered functional requirements and review the requirements with users and technical teams.
• Project design, including functional and technical specifications for California pay in arrears project implementation.
• Configured and designed row level security system according to the requirements and as per the compliance.
• Setting up custom paygroup defaults based on Business unit, company, full/part time.
• Setting up pay calendars, run ids for CA employees to be paid in arrears.
• Fit-gap analysis, impact analysis for all the payroll/benefit inbound and outbound processes.
• Fit-gap analysis for data conversion of the legacy data into peoplesoft for one the companies acquired by the client.
• Developed programs for data conversion programs from legacy data into Peoplesoft.
• Setting up new paygroups for Hourly and Exceptional Hourly employees.
• Developed custom conversion programs using SQRs and App Engines to load legacy data into payroll tables.
• Developed various SQRs and App Engines to load data to payroll and benefits tables.
• Involved in production support for post production defects and issues.
• Involved in design, Development and testing of Permission lists, users, Roles and assigned roles to users.
• Customized the timesheet audit page to correctly display the arrears pay end date for the California employee population.
• Implemented passive approval logic to load Unapproved Payable time for exceptional hourly employees for the oncycle pay cycle using the custom TL Upload process.
• Impact analysis, functional changes required to be incorporated to modify various Inbound and outbound interfaces.
• Developed custom self service pages for employees to display the Disability data.
• Developed custom pages for HR power users to display/to modify the disability data.
• Developed various custom Time and Labor Reports like Missing/Unapproved timesheets report, On-call pay report, perfect attendance report.

Environment: Peoplesoft HRMS 8.9, Peopletools 8.49

Confidential, Bedminster, NJ

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Gathered requirements to develop a Custom TL upload to pay roll process for both oncycle and offcycles based on the client needs.
• Defined Time and Labor Static and Dynamic work groups for specific group of time reporters.
• Set up Row security permission list to grant/limit the access of records and fields for time reporters based on the group membership.
• Closely worked with Functional teams for Semi-monthly to Biweekly payroll conversion.
• Fit-gap and impact analysis for the semi-monthly to biweekly conversion.
• Setting up core payroll tables like paygroup table, pay calendar table, run id table for biweekly payroll cycles.
• Customized various payroll, benefit inbound and outbound processes as a part of biweekly conversion.
• Implemented Direct Deposit Overide Functionality to send the offcycle payments to Balance Accounts.
• Developed new SQRs for generating the details of time reporters with exceptions, time reporters in a particular department with missing punch times and late punches.
• Developed various ad-hoc reports using PS Query, to get the time reporter’s head count of each union on a particular day.
• Involved in applying tax updates at client place.
• Running complete payroll cycle in the Test and UAT environments prior to production run to analyze the possible issues and payroll error messages.
• Involved in year-end payroll processing for running various Tax reports as a part of year end payroll processing.
• Implemented Savings plans like Roth, Roth Basic and Roth Supplemental for the employees.
• Developed Custom SQRs to load the Savings Plan data into peoplesoft benefit tables.

Environment: Peoplesoft HRMS 8.9, Peopletools 8.49

Confidential, Bedminster, NJ

Sr. Peoplesoft Technical Consultant

Responsibilities:

• Gathering requirements from functional users to implement Time and Labor for Hourly and Exceptional Hourly employees.
• Setup Time Periods including Daily, Weekly, Bi-weekly and Monthly and Build Time Period Calendar.
• Worked extensively in setting up Shifts, Workdays, Templates and creating Schedule definitions, building Schedule Calendars and Assigning Work Schedule
• Worked on defining Time Reporting Codes, Mapping TRC’s to Earnings Code, TRC Programs, Rule Programs, Value Lists, Static and Dynamic Groups.
• Worked on setup of Workgroups for Exception and Positive Time Reporters based on different Compensation Controls, Rounding options, Day Breaker options and Day Breaker Range
• Involved in gathering requirements to implement the Alt OT FLSA status, set up job codes and map employees to the Alt OT FLSA status on job.
• Setting new earning codes for the ALT OT hours and mapping the earnings programs to the employees.
• Developed custom Rule programs to process the reported time for the ALT OT employees to payable time.
• Developed custom SQRs to merge the paylines split in multiple paygroups due to mid week transfers.
• Involved in applying tax updates, retrofit changes, unit testing the on and offcycle payroll processing before and after applying the tax updates.
• Extensively worked on ESS and MSS for customize the timesheet audit page, Leave Request pages for Managers and Delegates.

Environment: Peoplesoft HRMS 8.9, Peopletools 8.47

Confidential, Warren, NJ

PeopleSoft Technical Consultant

Responsibilities:

• Upgrading People Soft HRMS 8.3 to 8.9 for the client, implemented Benefits, Payroll, T & L and Self Service
• Implemented PeopleSoft HRMS8.9 by retrofitting the Page, Components, Menus, Application Engine programs and Record people code for customized objects.
• Generated several compare reports to list out the changes from 8 to 8.8 and also the records which have been modified in 8.9
• Modified the Application Engine program and Component Interfaces and File layouts, Application messages based on record changes.
• Retrofitted several SQRs for 8.9 changes and modified the joins in Select, Insert and Update statements based on the compare reports.
• Executed the Application Engine program from the Application to check for their correct functioning after the retrofits.
• Customized various Payroll, time and labor, benefits SQRs to be functionally correct by running them on the application as well as on two-tier.
• Documented technical specifications for all the SQRs that need to be retrofitted for 8.8.
• Developed and implemented various new pages, Components and Menus and related People code based on client needs.

Confidential, Columbus, OH

PeopleSoft Technical Consultant /Analyst

Responsibilities:

• 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 users requirements.
• Worked with functional analysts and collected data requirements for conversion and interface programs.
• 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.
• Involved in setting up permissions for the users, to work with workflow for the self-service transactions for Job, Change Location, Reporting Change, Transfer Employee and Terminate Employees based on the approval rules of the organization.
• Worked on Tree, by adding new objects to trees and looking all the process flow mechanism and securities.
• 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.
• Created Interfaces using Application Engine, Component Interface and File Layout to create user profiles depending on the employee information in a flat file.
• Developed interface programs using SQR for interfaces between. Developed and modified SQR reports as per requirements. Developed Several Multi-report SQRs
• Developed queries using PS queries to get the employee status and head count of each business unit integrate it to the Crystal Report Writer.
• Gathered requirement from users and developed pages. Created reports in SQR such as generating form letters at different stages financial aid application received and reviewing, financial aid checklist, disbursements etc.
• Upgraded batch processes Application Engine programs. Upgraded reports and interfaces for Benefits Providers using SQR.
• Actively involved in the testing and issue resolution during the parallel test and the postproduction support.

Confidential, CT

PeopleSoft Technical consultant

Responsibilities:

• Created Functional and Technical specifications for many customizations by interacting with the end users.
• Customized and implemented PeopleSoft 8.8 HRMS (Payroll and Benefits Administration) Modules.
• Converted data from Legacy system to Peoplesoft using Application Messaging, Component Interface and Application Engine.
• Customized Records Employment and Employees to include customized data fields like as in legacy system.
• Developed Pages, Components, Component Interfaces, Application Messaging, Application Engine, PeopleCode, SQR for customizations.
• Defined Permission lists, Roles, and Object security.
• Set up permissions for users to work with workflow for the self-service transactions for Job, Change Location, Reporting Change, Transfer Employee and Terminate Employees based on approval rules of the organization.
• Setup employee information in Payroll Module to calculate employee earnings and Taxation of their Earnings and Benefits.
• Worked in Payroll Processing Pay Calendar, Pay sheet Creation, Pay Calculation, and Pay Confirmation.
• Modified Payroll Check Print report and Direct Deposit Advice Print Report programs as per client’s requirement
• Created new SQR Programs to update Annual Base Salary, and to add new Benefit programs, Plan, Plan Types and automated Benefit Admin Process.
• Modified existing SQRs and performed fine tuning of delivered SQR repots.
• Developed several new Inbound and Outbound SQR Interface Programs.

Confidential, NJ

Peoplesoft Techno-functional Consultant

Responsibilities:

• Involved in development of PeopleSoft HRMS modules based on organizational needs and requirements besides setting up foundation tables for HR, Payroll and Benefits.
• Created PS new object such as record definitions, SQL Tables, fields, Panels, Panel groups, Menu items.
• Performed troubleshooting the problem areas in setting up HR tables that serve as the foundation of HR system and in producing HR reports.
• Worked on customization of HR, Payroll and Benefits modules, which included creating and modifying records, panels and panel-groups.
• Developed SQR Reports for Various Payroll Data including Paycheck data, deduction, Earnings, Balance Data, Employee work hrs by Employee and Location
• Resolution of Pay calculation, pay confirmation and Benefits issues/abends. Involved in the development of various organizational decision-making reports like Absence History, Scheduled hours, Employee Review Audit.
• Modified delivered PeopleSoft SQR as per clients requirements for HR/Payroll/Benefits Modules. Created new views, added new menu definitions and modified existing menu definitions to include new panel-groups.
• Written PeopleCode to implement the business rules and to validate the data entry process. Implemented Row Level Security by creating Views, which will be used as Search Records.
• Developed test plans, which included test case scenarios for unit testing, end-to-end testing. Identified and developed specifications for customizations, resolved the issues and completed testing of test case scenarios.