SUMMARY:

• 8 + years of experience in analysis, design, development and implementation of various enterprise business applications.
• 8 + years of experience in Implementation, Customization, Upgrade and Development of PeopleSoft HRMS v 8.8/8.9/9.0/9.1 /9.2 modules like Core HR, T&L, Payroll, TAM, ESS, MSS, Performance Management, Benefits Administration and Base Benefits etc.
• 8 + years of experience in using People Tools 8.4x/8.5x, People Code, Application Designer, Application Engine, PeopleSoft nVision, SQR & Crystal Reports.
• Good knowledge in all HRMS modules.
• Proficient in making effective use of PeopleSoft Internet Architecture (PIA) and People Tools.
• 9 + years of experience in PeopleSoft Application Development tools such as Application Designer, Process Scheduler and Process Monitor.
• Good experience with Component Interface and Application Engine.
• Achieved maximum productivity by designing and developing dynamic SQR programs to generate similar reports that are required frequently.
• Expertise in Report generation using SQR, XML Publisher Reports, Crystal Reports
• Experience on self - service (ePay, eRecruit and eProfile).
• Accomplished tasks involved in developing interface and data migration processes.
• Extensively involved in trouble shooting and fixing problems at development, system testing and post-production stages for various HRMS modules.
• Experience in gathering requirements and writing, Coding and Test Plans.
• Good experience in UNIX / Oracle environment and PL / SQL.
• Strong communication skills, well organized and able to work individually or in a group.

TECHNICAL SKILLS:

PeopleSoft Applications:  PeopleSoft HRMS 9.2/9.1/9.0/8.8/8.3/8.0 HR, Base Benefits, Benefits Administration, ESS(Employee Self Service), MSS(Manager Self Service), Payroll (North American Payroll), Time and Labor, eBenefits, ePerformance, ePay, eProfile, TAM, Candidate Gateway, Compensation, Commitment Accounting

Development Tools:  Application Designer, Tree Manager , Peoplecode, Workflow Administrator, Upgrade Assistant

Integration Tools:  Application Engine, Component Interface, Application Messaging, Integration Broker, File Layout, EDI Manager

Administration Tools:  Security Administrator,Data Management/,Batch Processing,Data Mover, Process Scheduler, DELL Stat

Reporting Tools:  SQR, PS/Query, Crystal Reports & XML publisher

Operating Systems:  Windows 95/98/NT/2000/XP, Linux, Unix

Languages:  C, C++, C#, PL/SQL, HTML, XML,COBOL

Data Base Systems:  Oracle, SQL Server, DB2, MS Access

PROFESSIONAL EXPERIENCE:

Confidential,Bloomington IL

Sr Peoplesoft Technical Consultant

Responsibilities:

• Interacted with users and Clients to understand Business Processes.
• Gathered requirements from users and customized pages in HR, Base Benefits and Payroll modules to meet specific business requirements.
• Involved in the upgrade from version 9.1 to version 9.2
• Involved in upgrade of people tools objects and primarily responsible for loading base data, fields compare reports and converting, reviewing Application Engine Reports.
• Designed the modifications needed to the existing reports of SQR’s according to the new requirement of the client.
• Responsible for modifying & upgrading several customized reports from PeopleSoft version 9.1 to 9.2 using BI Publisher
• Creation, customization of records, fields, pages, menu etc. through Application Designer for the specific needs of the company.
• Developed and Customized People Code in Field Edits, Save Edits, SavePreChanges and SavePostChanges.
• Involved in some of the modifications done for the pages for self Service for Employees.
• Setting up the base benefit plans for the employees by assigning eligibility, choosing provider, assigning benefits according to eligibility.
• Executing PeopleSoft delivered and customized scripts using tools like Data Mover and SQL Plus.
• Coordinated and developed Interface record layouts for vendors.
• Implement AWE Approval Workflow, Customized Delivered Workflows to have Multi Level Approvals
• Developed Several Integration Broker Messages Between Peoplesoft HR and Time Sheet Systems, Developed Application Package Handlers, Did Setup of External Nodes, Service Operation and Routings
• Involved in design, development, enhancement and maintenance of PeopleSoft HR, Base Benefits and Payroll.
• Modification involved in changing search records to establish row level security by creating views using Application Designer.
• Pages were modified to the specifications and Search record dialog box has been modified by modifying record definition.
• Tailored People Code to implement data validation and to enforce field level security.
• Developed interface reports using SQR to read the data from files and load it into PeopleSoft tables and send data from PeopleSoft to other interfaces.
• Scheduled to run processes at a specific time and/or run recursively at a specific interval using Process Scheduler and used Process Monitor to view status of the process.
• Develop and validate data conversion test scripts, validation of converted data during testing and involved in the creation and verification of test data.
• Communicated and coordinated with other project team members and managers to ensure appropriate integration of processes and modules.

Environment: PeopleSoft HRMS version 9.2 / Tools 8.53 (HR, Base Benefits, NA Payroll, Time & Labor, ESS, MSS, TAM, ePerformance) People Tools 8.4x,SQL, Application Engine, SQR, Crystal Reports, Application Designer, GEAC, Oracle 8i’ WIN2000/UNIX.

Confidential, Michigan

PeopleSoft Technical Developer

Responsibilities:

• As a consultant contributed to Re-Implementation and customization of HR, Payroll and Benefits modules.
• Written various data conversion program from Salerix system to PS HCM Benefit component/records, like health, life, savings, leave, disability, flexible spending account, vacation, dependent, etc
• Developed CONEXIS Cobra Interface feed to the cobra vendor
• Developed custom Anthem HIPAA Health Interface feed.
• Modified Delta Dental 834 5010 interface.
• Developed All State Optional Benefit interface / feed.
• Developed custom Flex Credit Process.
• Developed custom SBS outbound feed.
• Developed many custom offer letter report using XML / BI Publisher
• Worked Manager self-service & AWE customizations.
• Developed custom process to populate employees, who falls 30 and above hours into the custom table. This table is used to populate elig config in job for eligibility rule for ACA and also further processes / reports.
• Developed custom ACA reports for the Ben user group.
• Wrote several template rules to implement comp time and holiday functionality and also custom rules to handle special scenarios of holiday pay and OT in the same week for state of Texas AOC to accommodate the business need
• Assist the functional users to define Static and Dynamic work groups for specific group of time reporters
• Worked on Employee & Manager Self-service for Payable time, Enterprise learning and workflows in Time & Labor and other HRMS Modules.
• Modified delivered Employee Self Service, Manager Self Service and other related objects to retrofit the business requirements of the client.
• Worked on modifying the self-service online paychecks to appear in PDF format.
• Developed custom Workflow to notify the applicant regarding the offer details.
• Conversion: Designed Conversion program to Convert Job Data, Employee Tax Data, Payroll Balances into Peoplesoft
• Resolved issues related Employee and Manager Self-Service Work Flow Transactions Promotions, Terminations, Transfers, Status change, Address change, Name change.
• Worked on various interfaces such as Payroll to GL, performed various types of bank reconciliation and generated reconciliation reports in Payroll.
• Worked on issues with the Payroll Interface, the GL interface, and handled data conversions when new acquisitions were made.
• Setup Combo Data Sync Between Finance to HR for Payroll to GL Interface.
• Developed the functional and technical specifications and coded AP and GL interfaces.
• AP interfaces included garnishment and parking vendor information; benefit accruals for life insurance, medical and dental and quarterly bonuses sent to GL; eligibility information for tuition reimbursement sent to outside vendor.
• Directly involved in Interface Specifications for Time & Attendance to Payroll and also Payroll to GL Interface.
• Payroll: Worked on XML publisher to configure the PDF employee self-service paychecks by creating report definition and data sources for US paychecks and advices
• Customized Earning tables to run Payroll Interfaces by including travel expenses and Overtime Schedules.
• Customized e-Profile for workflow, leave of absence and change of employee information.

Confidential, TX

Sr. PeopleSoft Developer

Responsibilities:

• Handling and coordinating with end Users for gathering of requirements.
• Arranging & chairing weekly team meetings, focusing on targets & achievements.
• Worked in annual open enrollment - Involved in the change impact analysis such as that of change f Vendor, requirement for a new vendor interface or changes in the existing interface.
• Generated interface files for Third party vendors for Sick Pay (STD/LTD), STD/LTD enrollment information and Health Care Enrollment Information and 401(K) Enrollment and deduction information
• Generated SQR reports and queries as per requirements of the corporation for the purpose of audit and analysis in Benefits, Payroll and Payroll tax data
• Benefits Coverage Election Integration: Used Related Content Framework to Integrate Benefits provider website with Peoplesoft
• Sterling Background Check Integration: Used Integration Broker to Integrate submission of new Employee Background and credit checks from within Peoplesoft and populate the information on the Sterling Background Application by passing data over in XML Format
• Benefits: Developed SQR program for the Open Enrollment Process to send Employee and Dependent Eligibility file to the Benefits vendor
• Developed Inbound and Outbound interface files using SQR to various third party Benefit Providers.
• Developed Component Interface and Application Engine Programs for Conversion Process
• Run the Benefit Reports and configured options to run unattended processes for error notification by Email.
• Modified Direct Deposit SQR per requirements of the bank
• Modified Pay Advice SQR program per requirements of the corporation, providing additional information on leave balances.
• Modified Pay003 Paycheck SQR to include Signature Image, which was issued by way of DIM card in the printer (HP8000)
• Modified heading to include company name instead of people soft standard headings
• Debugged Pay calc and Pay confirm errors and identified failing employees and suggest remedies for rectification
• Modified and wrote new peoplecode and used trace and debug techniques for easy error resolution.
• Able to prioritize tasks and workloads in order of importance and allocating of tasks to the team and Track record of delivering results with deadlines and coordinating with offshore team.
• Helping team in resolving critical issues and Dealing with and resolving problems and issues.
• Involved in implementation and customization of ePerformance module.
• Created a new Work Flow using Role Query.
• Involved in creation of reports using Application Engine.
• Involved in creation of out bound interfaces using Application Engine.
• Involved in creating new business logic using people code.
• Developed a custom GL HR accounting line table to load all the HR data like salary, wages, related fringe benefits and other payroll related data into the General Ledger and developed an application engine program to load this data.
• Designed and developed various custom and delivered reports using SQR pertaining to Benefits, Benefits Administration, HR and Payroll modules.
• Developed an SQR program that reads an inbound file from Metlife and inserts elections and terminations as required for the optional life plans - AD&D, Supplemental Life and Dependent (Spousal) life.
• Developed an Outbound SQR Interface Program that creates a file for Fidelity Investments from Clients Peoplesoft system. The outbound file contains Indicative (personal and employment) data for active, eligible employees and former employees (including pensioners) that have Resolving COBOL issues related to Payroll Interface Export Process (PI INRUN).
• Coordinating with users to resolve setup issues.
• Supporting the Business in resolving issues related to Payroll Interface integrated with ADP.
• Coordinating with users to resolve issues related to Setup.
• Created Application Engine to import PDF documents and storing them in Database.
• Resolving issues related to Setup of COBOL Interface and providing solution to the client.
• Involved in increasing the performance of the Payroll Interface Process.
• Responsible in debugging the issues related to Export Process.
• Provided solution to extract data.
• Involved in tuning the Custom Application Engine process.

Environment: Core HRMS, Payroll interface Compensation, Ben Admin, ePerformance PeopleSoft 9.0 HRMS,

PeopleSoft 9.0 HRMS, PeopleTools8.48, Oracle, Mercury Quality Center, ITG tool.

Confidential,Miami, FL

PeopleSoft Developer

Responsibilities:

• Supporting offshore development team
• Developed Conversion programs using App Engine, File layouts and Component Interface to load data from the Legacy system to Peoplesoft HEALTH BENEFIT, LIFE ADD BEN, SAVINGS PLAN, LEAVE PLAN, and LEAVE ACCRUAL Tables.
• Supported Open Enrollment for benefits
• Responsible for Setting up Benefit system, Benefit Plans, Coverage codes and provider information.
• Modified Benefit Summary to reflect Long Term Care and Specified Illness requirements.
• Involved in creation of a variety of reports for Benefits.
• Designed/Developed Custom Interfaces for Benefits vendors
• SQR Report: Developed a report for Disability Export using SQR that provides a listing of Disability programs that Regular and Executive employees are enrolled in.
• Health & Welfare Master Extract File: Developed an SQR for Health and Welfare Interface which reads the DY HLTH BEN table and selects all active employee and dependent health coverage’s. Additionally, it selects employee records with coverage elect dt within the user input from and through dates
• Developed a custom GL HR accounting line table to load all the HR data like salary, wages, related fringe benefits and other payroll related data into the General Ledger and developed an application engine program to load this data.
• Developed an SQR program that reads an inbound file from Metlife and inserts elections and terminations as required for the optional life plans - AD&D, Supplemental Life and Dependent (Spousal) life.
• Developed an Outbound SQR Interface Program that creates a file for Fidelity Investments from Clients Peoplesoft system. The outbound file contains Indicative (personal and employment) data for active, eligible employees and former employees (including pensioners) that have maintained a balance with the 401(k) provider after their termination.
• Created custom PL/SQL stored procedures to create interfaces between third party tool to PeopleSoft.
• Generated SQR reports and queries as per requirements of the corporation for the purpose of audit and analysis in Benefits, Payroll and Payroll tax data
• Modified heading to include company name instead of people soft standard headings
• Debugged Pay calc and Pay confirm errors and identified failing employees and suggest remedies for rectification
• Payroll: Worked on various interfaces such as Payroll to GL, Payroll to AP
• Worked on Production issues in HR configuration, where values in prompt list were not getting displayed due to record group pointing to wrong setid in Table set control. Fixed this issue by changing the setid mapping of record group in table set control, which is holding the prompt record.
• Resolved Tickets & SR's in Payroll & Benefits Modules.
• Work with end-users on system unit testing, QA testing and Product testing.
• Responsible for SQR coding, testing, and documentation for converting data from mainframe to PeopleSoft payroll tables. Created and modified the queries.
• Developed and modified several Reports for Payroll, Payroll summary by department id, location and developed new time upload process, modified direct deposit report.
• Developed and modified.
• Worked on customization of HRMS, Payroll and Benefits modules, which included creating and modifying records, panels and panel-groups
• Developed user interfaces using Application Designer employing validation processing logic using People Code.
• Customized Peoplecode for pages, components, records and fields according to client’s Business Process.
• Debugged and Resolved issues related to Application Engine, People code and Crystal Report.

Environment: PeopleSoft HRMS 8.9 (HR, Benefits Admin, Time & Labor, Payroll ) SQR, Application Engine, Peoplecode, Crystal Reports 10, Integration Broker, Oracle 10g and UNIX/Windows NT, PeopleTools 8.47