SUMMARY:

• Over Ten years of experience in Configuration, Customization, Implementation and Upgrade of PeopleSoft HRMS/HCM applications covering HR, Payroll, Talent Acquisition Management eRecruit , Absence Management, Talent Management, Manager Self Service MSS , Employee Self Service ESS , Benefits and Benefit Administration modules.
• Experience includes Analysis, Design, Implementation, Testing and Maintenance of Business Application Systems.
• Excellent working knowledge in PeopleTools, Application Designer, PeopleCode, Application Packages, Application Engine, Process Scheduler, SQR, Component Interface, PS query and SQL Programming.
• Involved in the fit gap analysis and implementation requirements gathering. Created Specification Documents, Detailed Design Documents, Test Plans and User Manuals.
• Expert at not only customizing delivered PeopleSoft applications, but also creating components, pages, Application Engine programs and SQRs from scratch to meet the business needs.
• Well-versed with delivered PeopleSoft objects and backend table structures.
• Strong Data Migration / Conversion experience from legacy systems to PeopleSoft systems.
• Expertise in using SQL tools with SQL Performance tuning experience.
• Loaded data from flat files to PeopleSoft tables using App. Engine/SQR programs and SQL scripts.
• Experience in creating interfaces with-in and outside of PeopleSoft applications using Integration Broker, Application Messaging, Component Interfaces, Application Engine programs and SQRs.
• Expert in preparing complex reports using SQR, PS Query and Crystal reports.
• Profound knowledge on Workflow technology. Configured Approval Workflow Engine AWE .
• Good understanding of databases and client-server architectures.
• Good at writing UNIX shell scripts and scheduled jobs to run automatically using Cron.
• Certified by Oracle as PeopleSoft People Tools Enterprise Developer Certified Expert.
• Certified by RedHat Inc. as 'RedHat Certified Engineer' which includes system and network administration of RedHat Linux systems .
• Excellent debugging and problem solving skills. Worked in primary Production Support role.
• Experienced in handling multiple tasks at a time, emphasize on timely delivery of my deliverables.
• Good communication and inter-personal skills. Quick learner and a good team player.

SKILL SET:

Application ERP : PeopleSoft HRMS/HCM 9.2/9.1/9.0/8.9/8.8/8.3/8.0. HR, Payroll, AM, TAM eRecruit , Talent Management, MSS, ESS, Benefits, Benefit Administration modules

Development Tools: Application Designer, People Tools 8.53/8.52/8.51/8.50/8.49/8.48/8.46/8.42/8.18, PeopleCode, Application Engine, File Layout, Component Interface, PS Security, Portal, Process Scheduler, SQR, Crystal Reports, PS Query, Tree Manager, Data Mover, Application Messaging, Integration Broker, XML Publisher, Workflow, AWE, Upgrade Assistant.

Databases: Oracle, DB2, SQL Server, MySQL.

SQL Tools: TOAD, SQL Plus, Oracle SQL Developer.

Operating Systems: UNIX, Linux, Windows 2000/2003/NT, OS390.

Languages: C, C , C , Java, SQL, PL/SQL, HTML, PHP.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. PeopleSoft Analyst/Developer

Key Responsibilities:

• Gather requirements from the end users, design and develop an optimal software solution, unit test and deploy the application.
• Created technical design documents, test case documents and user manuals.
• Customized the Job component to enroll/disenroll employees in AM based on the business rules. Also, created Initial Enrollment process using App. Engine, Job CI to enroll eligible associates into Absence Management create work schedules for them. Performance tuned this process.
• Configured Absence Elements Entitlements, Takes, Take types and Country Takes to meet the business needs.
• Customized the Absence Request page and Absence Details page for Self Service to meet business rules and validations. Also customize the Administrator Absence Entry page.
• Customized peoplecode on different events, libraries and Application packages to implement validations and control of the program flow. Generated custom notifications.
• Developed a custom 'Absence Request History' page for Self Service which includes Nationwide custom fields and provides options to edit/delete absences based on the business rules. This page also includes Absences from 3rd Party system, Aetna FMLA, STD/LTD absences .
• Created interfaces between PeopleSoft HR/AM system and 3rd party vendor Aetna . Claims Interface loads FMLA, STD LTD absences into PS AM system using AE Abs. Event page CI. Payroll interface loads Earnings and offsets for the STD and LTD claims using AE.
• Code mapping between Aetna and Nationwide PeopleSoft system.
• Developed a custom AE process which is run in the payroll flow after pay calc., to apply the LTD/STD earnings/offsets and to fix negative paychecks due to unpaid absences, holds them and deducts them in future pays. Used Rapid Entry Paysheet CI to update the paysheets.
• Created online reports for Aetna Claims, Payroll interfaces and Unprocessed Absence process holding tank for administrators to monitor, make fixes and skip/reprocess rows that are errors.
• Created custom records, pages and components, registered the components, created portal definitions and provide security using permissions lists. Customized portal objects.
• Created process definitions, run control pages and ran processes from process scheduler.
• Generated complex reports using SQRs/PS Query. Wrote SQL scripts for data load and cleanup.
• Performance tuned the reports and processes by optimizing SQLs, building indexes, creating temporary tables and splitting processes.
• Provided support for System, Integration/UAT testing and post production support by monitoring the defects in HP Quality Center, debugging/fixing them and providing necessary documentation. Supported and coordinated with testers, other developers and business as needed.

Environment: PeopleSoft HCM 9.1, People Tools 8.52, Linux, Oracle 11g, Application Engine AE , SQR, PS Query, Component Interface CI , XML Publisher, Toad 10.1, WinSCP, HP Quality Center 11.

Confidential

Sr. PeopleSoft Analyst

Key Responsibilities:

• Gather requirements from the end users, design optimal solution to meet their needs, develop a software solution, test it to confirm expected results, and then deploy the final software to the customer so they can utilize it. Provided detailed documentation in every step.
• Configured and customized PeopleSoft Applications to meet the business needs of the client.
• Designed and developed custom applications from scratch and tailored them to the PeopleSoft suite. This includes creating new PeopleSoft objects like fields, records, pages, components and registering the components and providing security.
• Worked on setup configuration for PeopleSoft MSS and TAM modules.
• Customized MSS module to match the Verizon business process. Worked on Job Change, Supervisor Change, Location Change, Termination and Sales Plan Change Transactions including delegations and interface with Portal todos using Integration Broker IB .
• Configured Approval Workflow Engine AWE to route MSS Termination and Job Change transactions through various approval levels based on business logic region, employee type etc .
• Worked on customizing WFA module including Person Data and Job Data component.
• Worked on TAM module and customized Job Opening page and also worked on enhancements to Candidate Gateway application.
• Generated custom worklists and emails wherever needed for MSS, TM and TAM modules.
• Customized Talent Management and ePerformance modules.
• Made extensive PeopleCode changes at various places throughout the Application including Events, Application Packages, App Engine programs and CIs to meet the business needs.
• Worked as part of primary production support team and provided production support to HR, MSS, ESS, TAM and Payroll modules.
• Created many SQL statements/scripts to fix data issues from backend. Generated various on demand ad hoc reports needed by the clients using complex SQLs.
• Created SQR, App. Engine processes and SQL scripts to load data from flat files into PS HR tables which include bulk jobcodes load, preferred title load, SSN and other Personal data load.
• Worked on applications that involve large volumes of data resulting in performance tuning challenges in order for applications to achieve optimal performance.
• Created indexes, stats, arrays/load lookups and temp tables to increase the performance of the batch processes.
• Deployed various complex reports SQR, PS Query and processes to users by creating custom run control pages and configuring/scheduling them using PeopleSoft Process Scheduler.
• Worked on IB Integration Broker interfaces to provide communication between Verizon PeopleSoft OneHR System and PINTS Verizon International HR System .
• Created interfaces using App. Engine and Unix scripts between Verizon PeopleSoft OneHR system and OrgPlus vendor to send organization data on a nightly basis.
• Created/customized SQR interfaces between Verizon PeopleSoft OneHR system and other third party vendors, AON and MetLife to send and receive recruiting and benefits data respectively.
• Worked on PeopleSoft Portal and PeopleSoft Security.
• Upgrade from PeopleSoft 8.9 to 9.1 for Verizon wireless and Payroll box.
• Compare and migrate projects from one environment to another using Application Designer and copy data using Data Mover.
• Resolved various Production and UAT defects. Used HP Quality Center to maintain and track of both Production and UAT defects.
• Created Requirements and Specification Documents, Functional and Technical Design Documents, Test Plans and User Manuals.

Environment: PeopleSoft HCM 8.9/9.0/9.1/9.2, People Tools 8.49/8.50/8.51/8.52/8.53, Linux, Oracle 10g/11g, App. Engine, SQR, PS Query, CI, Integration Broker, AWE, XML Publisher, Toad 10.1, WinSCP, HP Quality Center 11.

Confidential

Sr. PeopleSoft Developer

Key Responsibilities:

• Worked with clients and functional team during Requirements Analysis and Design phases. Created Technical Design documents from the Functional Designs and Requirement Documents.
• Worked on interfacing Kohls PeopleSoft System with Third Party Vendor, Hewitt which handles the Commuter Benefits for Kohls.
• Wrote SQR processes to load PeopleSoft General Deduction tables with Commuter Benefits data from Hewitt.
• Configured General Deduction and Payroll settings to handle the Commuter Benefits.
• Ran payroll for both hourly and salaried employees execs to test Commuter Benefit deductions are taken out correctly and configured and tested arrears processing.
• Worked on interfacing Kohls PeopleSoft system with Third Party Absence Management vendor Sedgwick.
• Added new Actions and Action Reasons to handle leaves based on the client needs.
• Modified online pages, people code, SQR processes and reports to reflect the new Action and Action Reason changes.
• Worked on enhancements to Kronos time reporting system interfaces to PeopleSoft System.
• Created pay adjustment processing SQR and tied it online to a custom run control page to run the process through the process scheduler.
• Created processes that generate various personal data, job data, location data and other HR information files to send them to third party vendors Earnest Young E Y , Sedgwick and Hewitt.
• Developed and modified JCLs to run the SQRs , schedule processes, FTP files and back up files.
• Customized online pages, wrote PeopleCode, created new tables and views to meet the client needs.
• Created test cases, involved in unit testing and debugging.
• Created test plans and involved in end to end testing.
• Supported existing PeopleSoft HR, Payroll, Absence Management and Benefits modules.

Environment: PeopleSoft HCM 8.9/9.1, People Tools 8.49/8.51, Application Designer, PeopleCode, PS Query, SQR, IB, CI, Mainframes, JCL, MVC, IBM DB2, Linux, Oracle 11g.

Confidential

PeopleSoft Developer/Analyst

Key Responsibilities:

• Involved in Analysis, Design and Implementation of PeopleSoft HCM 8.9 HR, Talent Acquisition Management TAM /Candidate Gateway, Payroll and PeopleSoft HCM 9.0 Compensation, Talent Management TM , Self Service Modules .
• Participated in Requirements gathering from business users, Analyzed the requirements and created Detailed Design Documents.
• Involved in customization/creation of fields, records, pages, components and menus, to provide additional functionality, used PeopleCode to incorporate business logic and validation rules. Also registered components and provided security.
• Made extensive PeopleCode changes at various places throughout the Application including Events, Application Packages, App Engine programs, CIs to meet the business needs.
• Developed functionality for the employees to create Standing Requests for jobs from the Self Service Recruiting page.
• Made intense customizations to the Manage Applicants page and other pages including Job Opening Page, Prepare-to-Hire, Resume page and My Careers tools Page.
• Developed from scratch custom components for Background Investigation, Lists for recruiters and more others based on the business needs.
• Created various lists for recruiters, which are auto populated with applicants, and applicants from these lists are auto matched to the Job Openings posted based on the standing requests and other business rules using Application Engine program.
• Generated work lists and emails for various hiring tasks and escalations using PeopleSoft Workflow.
• Customized the custom Talent Assessment page in the Talent Management module and created batch SQR to update the Assessment table when there is a change in employee's position.
• Done data mapping and wrote conversion programs and Loaded data into Talent Management tables from Legacy system.
• Customized delivered workflow for TAM by adding additional approval levels.
• Worked on sending Background Investigation data from PeopleSoft to Third party vendor using Integration Broker.
• Involved in Payroll processing and customized payroll SQRs and COBOLs involved in payroll processing.
• Created various SQR Reports and PS Query Reports for TAM module used by Recruiters and Hiring Managers to get summarized information about Job Openings and Applicants. Also created SQR to generate posters for Associate Job Openings that will be posted on the Company's notice boards. Created run control pages for the SQR reports and ran them through the process scheduler.
• Coded from scratch, as well modified existing SQR and Application Engine Processes to perform various batch Jobs and scheduled them to run through the process scheduler at a specified time.
• Customized Application packages in TAM module to meet various business rules and exceptions.
• Having HR and Payroll on different Database systems, used Application Messaging/Integration Broker to keep the tables in sync and used synonyms and dblinks in PeopleCode and SQRs to access tables from other environment.
• Used XML Publisher to give the employees ability to view historic paychecks.
• Designed and configured the Roles and Permission Lists according to the responsibilities and functions of the users
• Retooled SQR Batch Jobs running on Mainframes/DB2 to Linux/Oracle platform.
• Worked on retooling and upgrading PeopleSoft Applications for TAM, Payroll and OSS modules.
• Performed Upgrade steps for the Initial Pass using Change Assistant.
• Converted Foundation and Transaction Tables to 9.1 and customized ESS and MSS as per business requirements.
• Verizon having huge number of employees, applications which involved huge data are tuned for performance.
• Used Data Mover to load data from one environment to another.
• Provided production support, also responsible to fix SIT and UAT defects. Used HP Quality Center to maintain and track both Production and UAT defects.

Environment: PeopleSoft HCM 8.9/9.0/9.1, People Tools 8.48/8.49/8.50, Linux, Mainframes, Oracle 10g/11g, DB2, SQR, PS Query, App. Engine, App. Packages, CI, Integration Broker, AWE, TOAD, Win SCP, XML Publisher, HP Quality Center.

Confidential

PeopleSoft Developer

Key Responsibilities Activities:

• Worked with clients to design and implement modifications and customizations to tables, components and programs to meet business requirements.
• Worked on various customizations for upgrading application from 8.0 SP1 to 8.9 involving People Code, SQR, Application Engine, Component Interface, Components, Pages, Menus, and Shell scripts.
• Worked to retrofit customizations to the upgraded 8.9 system.
• Responsible for applying any production data changes to the upgrade environment while upgrade is in progress. This includes tax bulletins and other client specific customizations.
• Involved in setting up Workflow Administration.
• Performed Upgrade steps for the Initial Pass using Change Assistant.
• Created maintained Upgrade Project Plan and upgrade strategy.
• Responsible for running On-cycle payroll for Semi-monthly pay schedule and Off-cycle Payroll run in Production.
• Involved in defining the Earnings, Deductions and Absence rules.
• Responsible for setting up calendars, earnings, deductions and tax data for payroll processing.
• Providing the solutions for e-Recruitment/TAM for retrofitting the Application as it is.
• Customized Job Opening, Applicant pages by adding new fields and implemented business logic using PeopleCode at record, page and component level as well customized Application Packages.
• Worked on scripts to load data from data files into PeopleSoft tables and also created scripts to extract data from PeopleSoft tables and created data files.
• Worked on portal security including the access to pages and folders.
• Developed TL business process for Time entry, approval, and view/ manage time processes.
• Developed reports using SQR that give information about time not reported, time that needs approval, time that is over 8 hours per day and time that uses holidays.
• Involved in Production Support activities for On-cycle Payroll, which includes batch job stream monitoring, Payroll Confirm activities and support for payroll cycle from First day of payroll through Payday.
• Involved in open enrolment process in Ben Admin.
• Provide day-to-day support for queries, problems and changes to programs within agreed service levels.
• Created test scripts performed functional testing.
• Loading Earnings, Deduction and Tax Balances files into PeopleSoft for Mergers.
• Developed an interface that generates file with Quarterly, Semi-Annual and Annual Incentive Overtime payments for employees.
• Worked on Profile management and succession planning.
• Designed and developed SQR to load data into Garnishment tables for Mergers.
• Applied PeopleSoft Payroll Tax Updates that includes updates to tax tables, Garnishment tables, COBOL program changes and SQRs for payroll reporting.
• Developed new connectors for interface with third party systems by using Application Messaging.
• Developed an interface to balance Calc partitions by dividing employees into eight pay groups.
• Developed interfaces that generated files containing personnel data, earnings and hour's data accumulated by employees every pay period for various earnings code.
• Developed UNIX shell scripts to transfer of files to vendor systems using FTP protocols.

Environment: PeopleSoft HRMS versions 8.0 SP1/8.9, People Tools 8.49 Oracle 9i/10g, Windows NT, Oracle SQL Developer, SQL Plus, PS Query, SQR, App Engines, CI.