Professional Summary

• More than nine years of experience years of experience that includes Analysis, Design, Development and Implementation of Businessapplication systems in PeopleSoft, Oracle and Java.
• Excellentfunctional experience in project SDLC documentation including business requirement work sessions, process flowcharts, project recommendations, detail design including functional and technical specifications fit gap analysis, data mapping and other project related.
• Strong Technical experience in PeopleSoftHRMS/HCMin Analysis, Design, Implementing, Maintenance, Upgrade, Production Support, Troubleshooting, Conversions, Project Management, Administration, Security Services and Performance Optimization.
• Excellent working knowledge in People Tools Application Designer, Application Engine, Process Scheduler, SQR, Security, Component Interface, PS query, Tree Manager, Change Assistant/Data Mover .
• Extensively involved in HR, Payroll, Benefits, Time and Labor, eRecruit Candidate Gateway and Talent Acquisition Management , Compensation, Training, Employee Self-Service and Manager Self-Service modules - eResignation/Self-Terminate,eProfile, eBenefits, ePay and eCompensation
• Experience in PeopleSoft Internet Architecture and Open Integration Technology Tools like Application Designer, Application Engine, Component Interfaces and Integration Broker for interacting with in and outside PeopleSoft applications, Application Messaging, Business Interlink, People Code, Web Services, SQL Programming and COBOL Microfocus.
• Specialized in Upgrades, Implementations, Enhancements, Customizations, Bolt-on Applications, Custom Modules, Bundles, Patches, migration, Data extraction and conversion from legacy to PeopleSoft applications, Tax Updates and Production Support.
• Proficient in preparing complex reports using SQR/Hyperion reports, PS Query, Crystals.
• Uploading data from flat files to PeopleSoft tables using Application Engine and Component Interface programs.
• Modification and testing of SQR COBOL programs as per the user requirements.
• Experience in designing databases and client-server architectures and expertise in PL/SQL, SQL Plus and TOAD.
• Accomplished in customizing modules based on organizational needs and requirements.
• Expert in fixing all types of issues which include testing issues, implementation issues, incidents and day-to-day production access security issues, performance issues, file transfer issues and process failure issues.
• Created Upgrade Plans, executed and reviewed Compare Reports, applied Upgrade Application steps, fixes and patches for the upgrade process
• Provided direction for users, managers, database administrators, system engineers and other developers.
• Has excellent analytical, debugging and problem solving skills, pays attention to details, dedicated, go-beyond to find solutions.
• Excellent communication and written skills, capable of working closely with users, able to rapidly translate user requests into technical specifications.
• Worked on PeopleSoft HCM/HRMS 9.2/9.1/9.0/8.9/8.8 and People Tools 8.54/8.53/8.51/8.50/8.49/8.46/ 8.45/8.44.

Technical Skills

ERP People Soft HRMS/HCM9.2/9.0/8.9/8.8/8.3/8.0/7.5

Tools PeopleTools8.46: Application Designer, Process Scheduler, Data mover, SQR,

People Code, Query Manager and Application Engine.

Languages Java, People Code, SQR, PL/SQL, SQL Loader, COBOL Micro Focus.

Modules PeopleSoft HRMS, Security, Portal, HR, Payroll, Benefits, Time and Labor, eRecruit

Candidate Gateway CG , Talent Acquisition Management TAM , Absence Management

AbM , Compensation, Training, Employee Self-Service and Manager Self-Service modules -

eResignation / Self-Terminate, ePerformance, eDevelopment, eRecruit, eProfile, eBenefits,

ePay and eCompensation.

Database Oracle 9i, 10g, 11g and MS SQL Server 2000.

ServersAIX 7.1

Web ServersWeb logic 10.1, Tuxedo

Reporting tools SQR, Crystal Reports and knowledge in OBIEE Dashboards and Reports.

Operating systems Windows 95/98/2000/XP/NT/7, UNIX, Linux and IBM AIX.

Professional Experience

Confidential

Peoplesoft Techno-Functional Developer

Responsibilities:

• Involved in the PeopleSoft Upgrade Project from Version 9.0 to 9.2 for Core HR, Payroll, Benefits and Benefits Administration.
• As a key member of the development team, was responsible for requirement gathering for the custom applications, modifications to the delivered applications identified during the fit gap analysis and resolve issues related to upgrade, conversions, customizations, and interfaces.
• Worked on preparing Upgrade Analysis document by running Compare Reports between demo version and current production.
• Implementation, support and troubleshoot daily Production, Reporting and Development environment occurrences.
• Extensive work experience with People Tools such as Application Designer, Application Engine, Query manager, Data mover, Workflow, Process Scheduler, Upgrade Assistant, Tree Manger, Security Administrator.
• Constructed new and edit existing on-line objects, including: Components, Component Interfaces, Pages, Records, PeopleCode and Application Engines, integration broker, application messaging, and execute the testing and follow through projects.
• Developed SQR reports and interfaces for Benefits, HR, Payroll, which have data of new hires and changes to certain HR/Payroll data to generate flat files to be sent for third party.
• Created SQR Reports along with creating interfaces to feed in data from other Databases or from flat files.
• Implemented conversion of data from legacy System to PeopleSoft Application database by using SQL Loader, Import Manager by creating tables , scripts for data mapping, migrating, convertingand writing SQR programs.
• Modified and customized the existing Application Engine SQR programs as per the table changes of 9.2 without affecting the existing functionality.
• Setup Security User Profiles, Managing Roles, and Managing Permission List Securities.
• Implemented Component Interface based Web Services for Integration broker between HR and Finance for Payroll Accounting Entries.
• Experience in Install patches/fixes, application and technology updates.
• Involved in monitoring and troubleshooting the batch jobs in Peoplesoft using the batch scheduler, TOAD/SQL Navigator and ensure that the jobs are running as per the production schedule. Used telnet clients like WS FTP, Putty to work with UNIX files from windows and Check the log files of the Critical jobs periodically and ensure that the jobs are running properly.
• Wrote unix shell scripts to process multiple files and ftp them from one machine to another.
• Extensive experience in writing, performance tuning Hints and troubleshooting of Oracle Queries used in SQR and COBOL DMS's.
• Retrofitted Annual Enrollment Process. Designed and customized various Employee Self Service Pages and Benefits Audit Reports and customized MSS transactions Name Change, Date of Birth Change, Location Change, and termination .
• Involved in doing the changes to data conversion Application Engine programs and also involved in running the data conversion in the upgrade. Worked on the development tool Application Engine, by creating and modifying main Sections, Steps and Actions using State Record and Temporary Tables. Used Application Engine to transfer the data from flat files to PeopleSoft tables.
• Involved in creating new Component Interfaces to load additional pay data of employees from Excel Sheet to PS payroll tables.
• Involved in the Implementation of Integration broker between HR system and Payroll system.
• Involved in the regular Tax updates to the system during the upgrade.
• Worked on Employee and Dependents Benefits for Cobra Report in Dental, Vision, Medical and FLSA Report.
• Defined Exceptions for the reported time and created custom error/warning messages in message catalog.
• Developed custom payroll and benefits reports using SQR and Crystal Reports that give information about employee earnings, deductions, tax reports and also exception reports like Negative Net Pay.
• Expert in analyze and assist with the resolution of technical/functional issues associated with the delivered programs.
• Analyzed and understood the PL/SQL code and resolved the issues accordingly and do the root cause analysis for the failed database jobs.
• Worked on New hire Report using XML Publisher using Application Engine Process.
• Involved in preparing and evaluating the technical specifications while developing SQR programs and customizations.
• Analyzed the requirements and created functional and technical design documents.

Environment:PeopleSoft HRMS 9.0/9.2, PeopleTools 8.50/8.54, Application Designer, People Code ,PS Query, SQR, SQL, Oracle 11g, Data Mover, Change Assistant, Component Interface, Crystal Reports and File Layouts..

Confidential

Peoplesoft Techno-Functional Developer

Responsibilities:

• Involved in the implementation and Upgrading People soft HCM from 8.9 to People soft 9.1. Modules implemented were HR, Payroll, Benefits and Time Labor.
• Involved in the development and customization of reports, records, Panels Pages , menus, queries, processes and security using SQR, PS/Query, People Code, Data Mover and other People Tools.
• Worked extensively on Customization after up gradation to meet the current version requirements
• Involved in preparing the technical specifications while developing SQR programs.
• Worked with Production support team 24/7 during the Bi-weekly Payroll run process to fix any problems for the PayCalc process and nightly batch process.
• Created and Modified People soft objects like Pages, Components, Menus, and People Code.
• Submitted processes to the Process Scheduler to run daily/weekly tasks at a specific time to run process recursively at a specific interval.
• Involved in setting up core tables in HR and eRecruit application. Implemented processes for job application, agent, referrals, interview evaluation and schedules.
• Generation of various Standard Reports such as SQR like Employees Summary, Absence history, Benefits and Payroll information.
• Used Upgrade Assistant to automate some of the upgrade tasks and to keep track of the begin time and end time to run a process.
• Involved in online changes like adding customized translate values, People Code, panels and menus.
• Writing complex queries using SQR programs and PS Query Manager by considering the performance issues.
• Uploading the data from legacy systems in to PeopleSoft systems.
• Extensively Experienced in XML Publisher in Writing People code to Generate and Distribute the XML Reports.
• Involved in creating the test plans and test scripts for SQR reports and crystal reports.
• Rewrite People Code as per the requirement on different events to implement the business rules and validation.
• Modified and Created Work force Analysis Report, Vendor Aging Report, Job Roaster Group Report, Career Invoice Report, Health Invoice Report, subsidy Report, New Hire Report and Cobra Report using XML Publisher.
• Evaluated PS applications and analyzed to derive design and customization documentations.
• Developed conversion designs and data mapping from legacy system to PeopleSoft.
• As a key member of the development team, was responsible for requirement gathering for the custom applications, modifications to the delivered applications identified during the fit gap analysis.
• Developing custom SQRs and enabling custom reports to be executed through Process Scheduler.
• Customization, Addition, Validation and debugging of People Code according to the changed functional requests.
• Used Data Mover to export project to a data file then used the file to load data in to new copy of Production.
• Involved in Unit testing of people soft delivered and modified functionality customized SQR programs using HR, Benefits and Payroll Modules.
• Handled bundles for the process of solving the issues in the enhancements.
• Changed /customized PeopleSoft delivered fields, records, and tables as per the business requirements.
• Used People Tools to create SQR associated objects including run control records and Process Ids.
• Involved in customizing related records, panels, Queries, SQRs, SQCs and Reports.
• Analyzed and Performed performance tuning for the slow Queries and Processes in PeopleSoft applications using SQL Traces.

Environment: Peoplesoft HRMS 8.9/9.1 HR, Benefits, Employee Self Service, Manager Self Service , People Tools 8.5, Oracle 10g, UNIX and IBM AIX, Windows XP/7, Application Designer, Application Engine, Process Scheduler, SQR.

Confidential

PeopleSoft Technical Developer

Responsibilities:

• Developed Technical Design documents after understanding the functional specifications.
• Involved in writing People Code programs to implement the Business Rules and Data Validations as per the requirements
• Implemented conversion of data from legacy System to PeopleSoft Application database by using SQL Loader, Import Manager and by writing SQR programs. Created and tested SQRs for year-end processing of Leave accruals for active employees and history of terminated employees at their time of termination.
• Responsible for specification preparation converting many COBOL based reports and process into SQR's.
• Also involved in eCompensation, which is a self-service Web application that interfaces with the PeopleSoft Human Resources system. This application enables employees to review and update their compensation information.

Environment: PeopleSoft HRMS 8.9/7.51 and Time Labor, Payroll, Benefit Administration,eBenefits, eRecruit, eCompensation 7.51/V 8.9, PeopleTools 8.4x, Oracle 9i. , COBOL, Windows 2000.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Involved in Development and Customization of PeopleSoft HR, Base Benefits, Benefit Administration.
• Modifications involved in changing search records to establish row level security. In order to accomplish row level security, views are created using Application Designer.
• Worked on the development tool Application Engine, by creating and modifying main Sections, Steps and Actions using State Record and Temporary Tables.
• Customized different Online Objects records, record fields, Pages, Components, component record fields according to the specifications, and also modified Search Record dialog box.
• Involved in generating Pay Sheets, Pay Confirms, Pay Calc and Pay checks.
• Also involved in interface of North America Payroll with Time and Labor for calculating Payables Time.
• Involved in configuring servers to make use of Peoplesoft Internet Architecture
• Generated Reports annually and quarterly reflecting all the active employees whose deferrals have reached the limit specified by organization and developed employee category according to business needs.
• Tailored People Code to implement data and to enforce field level security.
• Involved in the customization of Online Processes records, pages, menus, processes and Security using SQR, PS/Query and People Code.
• Using SQL Loader done custom records conversion by the Specifications provided by.
• Used Application Engine to transfer the data from flat files to PeopleSoft tables.
• Used Process Scheduler to run scheduled processes at a specific time and/or run recursively at a specific interval and used Process Monitor to view status of the process.

Environment: PeopleSoft HRMS 8.9 Base Benefits, North America Payroll, Benefit Administration, Time and Labor , Application Designer, Application Engine, People Code, SQR, SQL, PS/Query, MS-SQL Server, Query Analyzer, Configuration Manager

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Involved in the upgrade from version 7.5 to version 8.3.
• Involved in reapplying customizations.
• Involved in the conversion of custom panels to pages.
• Involved in doing the changes to data conversion Application Engine programs and also involved in running the data conversion in the upgrade.
• Worked on the development tool Application Engine, by creating and modifying main Sections, Steps and Actions using State Record and Temporary Tables.
• Used Application Engine to transfer the data from flat files to PeopleSoft tables.
• Customized different Online Objects records, record fields, Pages, Components, component record fields according to the specifications, and also modified Search Record dialog box.
• Involved in the regular Tax updates to the system during the upgrade. Created an exhaustive upgrade document for the client.
• Involved in retrofitting the public queries to take the changed records in to account.
• Involved in all phases of upgrade such as upgrading tools, application and customization.
• Part of the team during the final move to the production phase.
• Writing control file scripts for loading the data into tables using SQL Loader.
• Involved in fixing Global Payroll, Time Labor and Ben Admin issues during Upgrade.
• Involved in supporting the two payrolls of the PeopleSoft 8.3 system and handed the support to the production support team.

Environment: PeopleSoft HRMS 7.5 to HRMS 8.3/People Tools 8.17 and PeopleSoft Internet Architecture, Application Designer, Application Engine, Process Scheduler, SQR, Oracle 8.1.6, Windows 2000.