PROFESSIONAL SUMMARY

•* years of IT experience with expertise in Designing, Developing, Implementing, Customizing, Upgrading, Testing and Production Support of PeopleSoft HRMS/HCM Applications - Core HR, Base Benefits, Benefits Admin, Payroll, Time & Labor and Self-Service.

•Expert Knowledge of People Tools - Application Designer, Application Engine, People Code, Application Packages, Data Mover, Security Administrator, Tree Manager, Process Scheduler and Process Monitor.

•Expertise in integration tools such asFile Layout, Component Interface, and Integration Broker.

•Proficient in creating complex reports using XMLP,SQR, BI Publisher, Crystal Reports and PS/Query.

•Extensively worked in Designing/Developing/Modifying Customizations.

•Well versed in creatingInbound/OutboundInterfaces.

•Experience in Creating/Executing test plans for Unit testing, System Integration Testing and supported User Acceptance Testing.

•Good experience in documentation of functional/technical designs, code modifications, and analyzing test results.

•Hands on experience in trouble shooting the problems and improving the performance of application processes by Debugging, Tuning and Tracing.

•Strong working knowledge ofRDBMS such as Oracle, SQL Server and MySQL.

•Well-versed exposure on Agile and Waterfall SDLC model.

•Excellent communication and interpersonal skills along with strong analytical and problem solving skills

TECHNICAL EXPERIENCE

ERP: PeopleSoft HRMS/HCM 9.2/9.1/9.0/8.9 (Core HR, Payroll, Base Benefits, Benefits Administration, and Time & Labor).

Development Tools: PeopleTools (8.5x/8.4x), Application Designer, Application Packages, PeopleCode and Application Engine.

Administration Tools: Configuration Manager, Process Scheduler, Process Monitor, Upgrade Assistant, Security Administrator and Utilities.

Integration Tools: Integration Broker, File layout and Component Interface.

Reporting Tools: SQR, PS/Query, XMLP and Crystal Reports.

Programming Languages: PeopleCode, PL/SQL, C, C#, VB and HTML.

Database: Oracle 10g/11g, MS SQL Server, MS access, MySQL.

Operating Systems: Windows 8/7/XP/2000/NT/98/95.

PROFESSIONAL EXPERIENCE

CHI St. Luke’s Health, Houston TX March 2015– Present

Project: PeopleSoft HRMS 9.1 Production Support And Maintenance

Role: Sr. PeopleSoft Techno-Functional Developer/Analyst

Involved in the design, analysis, code and test in the maintenance and production support for PeopleSoft HRMS/HCM applications.

Resolved many production tickets related to HR, Benefits Admin, Payroll, Self-Service (ESS and MSS) of PeopleSoft HRMS/HCM by responding using Cherwell Service System.

Developed an App Engine program to extract the images of all the employees from the PeopleSoft database.

Updated existing 4 digit JobCodes to 5 Digit using ExcelToCI.

Modified existing Newhire App Engine program that loads new hire’s information into PeopleSoft from Taleo to process the new 5 digit Jobcodes.

Developed several Conversion Programs using SQR for transmitting data related to Employee Demographic information, Job information, Benefits, Payroll History and PTO/EIB.

Developed custom reports needed per the client requirements using PS Query.

Modified PeopleCode of Delegate components to pull employees of the Manager assigned when a delegate uses JobChange Request Page.

Worked on configuring security for HRMS modules such as permission lists, roles, and user profiles.

Created new XML Publisher reports for the agreement templates with Contractors. As an example, a report was developed for Pickup and delivery contractor operating agreement listing the pickup and delivery location and exception details.

Tested and Loaded the FTE values into Job Table for all the active employees using ExcelToCI.

Created new Application Engine & Component Interface program to upload employee’s new Compensation rates from input file to Job component.

Developed various Outbound and Inbound Interfaces for transmitting employee Data to Benefits vendors and process the receiving data to insert into various PeopleSoft Tables

Modified a custom SQR related to Payroll to include additional earncodes.

Modified the custom SQR for turnover reports to pull the headcount correctly.

Created PS queries to pull terminated employees for a fiscal year based on the user requirements.

Modified custom SQR report to provide correct employee Life Insurance coverage amounts based on the business requirements.

Used Process Scheduler to run the processes & reports through PeopleSoft pages and used process monitor to view the status of the reports.

Created Process definitions and new run control pages, components to run different reports and processes.

Provided thorough documentation of Requirements, design and test scripts for future reference.

Environment: PeopleSoft HRMS 9.1, PeopleTools 8.54, PS Query, SQR, SQL, Oracle 11g, JCL, Citrix (Remote Access), Data Mover, Change Assistant, Component Interface.

Harris County Hospital District, Houston TX Mar 2014 – Feb 2015

Project: PeopleSoft HRMS Upgrade from 9.0 to 9.2

Role: Sr. PeopleSoft Techno-Functional Developer/Analyst

•Involved in the PeopleSoft Upgrade Project from Version 9.0 to 9.2 for Core HR, Payroll, Benefits and Benefits Administration

•Participated in fit / gap sessions, to create and resolve issues related to upgrade, conversions, customizations, and interfaces.

•Involved in data analysis and data conversion during the upgrade of the person model.

•Worked on preparing Upgrade Analysis document by running Compare Reports between demo database and current production version.

•Created/Customized/Modified Records, Pages, Components and Menu definitions as per the client requirements using Application Designer.

•Modified/Customized the existing Application Engine & SQR programs as per the table changes of 9.2 without affecting the existing functionality.

•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.

•Retrofitted Annual Enrollment Process. Designed and customized various Employee Self Service Pages and Benefits Audit Reports. And got recognized for Best Performance.

•Customized Education and Training pages to populate data into Custom tables PS_SC_HRS_EDU_INFO and PS_SC_HRS_TRAINING.

•Developed custom PS Queries to enable Benefits Functional Users to identify specific employees.

•Created a new page where the user can enter his/her Schedule for the entire Week. This page will save the data into SCH_ADHOC_DTL with the help of a new work/derived record. Also added different functionality and validations for this page.

•Implemented Component Interface based Web Services for Integration broker between HR and Finance for Payroll Accounting Entries.

•Modified existing SQR’s such as PAY003 (Paycheck printing) and DDP003 (Direct Deposit) to make them compatible with new 9.2 changes.

•Developed rules using delivered templates like Holiday, Shift Premium, Period Threshold, and Weekly Threshold and customized new rules as per the client requirement.

•Developed Custom Interface Programs using Application Engine and file layout to validate and then Load Time data from Flat files into Rapid time table.

•Retrofitted custom PeopleCode programs according to the new table changes.

•Developed new Component Interfaces, Application Engine programs for FRS (Fidelity) system.

•Defined Exceptions for the reported time and created custom error/warning messages in message catalog.

Environment: PeopleSoft HRMS 9.0/9.2, PeopleTools 8.50/8.54, PS Query, SQR, SQL, Oracle 11g, JCL, Citrix (Remote Access), Lotus Notes, Data Mover, Change Assistant, Component Interface.

Kaiser Permanente, Pleasanton, CA Dec 2012– Feb 2014

Project: PeopleSoft HRMS 9.1Implementation/Enhancements

Role: Sr. PeopleSoft Technical-Functional Consultant

•Involved in Development, Enhancement and Maintenance of HR, Base Benefits, Benefits Administration, Payroll & Time and Labor.

•Developed/Modified various record(s), page(s) and component(s) based on the business requirements.

•Used Application Engine and Component Interface to load data into to PeopleSoft tables.

•Extensively worked on running Compare reports and moved objects from one database to another when required.

•Developed various Outbound and Inbound Interfaces using SQR as per the requirements.

•Setup the Flat Rate Table, Age Grade Rate Table, and Salary Grade Rate Table.

•Designed the Benefits Interface Design Documents for various vendors.

•Assisted the configuration team to meet their time lines by loading large configuration tables using Application Engine.

•Ran the Open Enrollment and Event Maintenance Process for New Hires.

•Involved in Employee Self service (ESS) and Managerial Self Service (MSS) to provide Kaiser HR's a web based Interface to maintain position management information in the PeopleSoft System

•Developed a new Self-Service functionality to allow the staff to enter educational allowance information online via the self-service home page.

•Ran On-Demand Event Maintenance for Individual Participants from Participant event scheduling to enrollment confirmation.

• Created an SQR interface program that captures all active employees and their dependents data to the Insurance Company.

•Developed a procedure to read all the stored Translate values in conversion SQR programs.

•Involved in generating a process to create interface between Benefits and Time & Labor which compares Employee's leaves recorded in Time & Labor against the allowed leaves.

•Modified the existing Workflow logic to increase the existing limited approvals to higher levels based on the business rules document provided.

Example: If a manager submits a transaction of employee’s increment in salary by 10%, it needs one approval from higher manager, if its 15%, transaction requires two higher approvals etc. Likewise approvals are implemented for Jobchange and transfer requests also.

•Extensively used SQR for Developing reports in 'Time and Labor' for Unapproved Time, Absence History, Comp Time and Reported time according to the requirements.

•Involved in monitoring/support (on-call) weekly and Bi-weekly PeopleSoft payroll cycles, fixes and run the cycle smoothly.

•Worked with component registration wizard to attach the components to Menu, Portal Registry and to assign security.

•Involved in the preparation of Technical documentation based on the functional specifications laid down by the functional people.

•Developed various Attorney, Legal and Admin head count reports using PS Query and Crystal Reports.

•Created Multiple Reports using SQR and provided security using the PeopleSoft delivered security tables so that respective departments get reports concerning to there departments instead of getting the reports of all the departments.

Environment:People Soft HRMS 9.1, PeopleSoft PeopleTools 8.52, Application Designer, People Code, SQR, SQL, PS Query, Crystal Reports, File Layout, Component Interface, Oracle11g, PL/SQL.

CIT Group Inc., Livingston, NJ Dec 2011–Nov 2012

Project: PeopleSoft HRMS 8.8 to 9.1 upgrade

Role:PeopleSoft Technical Consultant

Involved in the PeopleSoft Upgrade Project from Version 8.8 to 9.1 for Core HR, Payroll, Base Benefits, Benefits Administration and Time and Labor.

•Extensively worked on PeopleCode according to the requirementsto implement the business rules and data validations.

•Created/Modified/Customized all tables related to benefits such as Benefit plan types, Benefit plans and Benefit programs.

•Developed Record Definitions, Pages, Components, ad-hoc SQRs & ad-hoc queries, and Run Control Pages as per corporate requirements.

•Customized Benefit program pages to include fields like eligibility criteria and rate factor etc.

•Extensively worked on making online changes such as adding customized translate values, modifying People Code, adding fields to pages and modifying Components and menus.

•Customized Recruiting Profile page (HRS_CE_PROFILE) to populate data into PS_SC_HRS_APP_INFO (delivered table PS_HRS_APP_PROFILE).

•Setting up Vendor profiles and Vendor policies according the organization requirements.

•Designed and developed an interface in SQR to send time from custom Time and Labor table to a flat file to be exported to another department.

•Worked on retrofitting row-level security in all SQR PAR reports from 8.8 to 9.1, like replacing FAST_SCRTY_2 view with FAST_SQR_SEC_VW.

•Wrote an SQR Interface to populate data from the external system into PeopleSoft tables HRS_APPLICANT, HRS_APP_ADDRESS, HRS_APP_EMAIL.

•Worked on developing complex queries using SQR to retrieve the benefit transactions information as per the client requirements.

•Designed interfaces for Benefit Plans, customized Benefit programs integrating them with the Benefit/Deduction Program Table Group. Also enhanced the Benefit's module in People soft with the Company's Benefit program.

•Worked on Tree manager to add records in Access Group to view in PS Query.

•Extensively worked with process Scheduler to run processes & reports through PeopleSoft panels.

•Used process monitor to view the status of the reports and scheduled various periodic reports.

Environment:People Soft HRMS 8.8/9.1, PeopleTools 8.45/8.51, Windows, Application Designer, People Code, SQR, SQL, PS/Query, Crystal Reports, Oracle 10, PL/SQL.

Robert Half International Inc., Pleasanton, CA. Jan 2011– Nov 2011

PeopleSoft HRMS 9.0 Customizations/Support

Role:PeopleSoftTechnical Developer

•Extensively worked on customizing HR application by Creating/Modifying Records, Panels, Panel Groups and PeopleCode.

•Improved the performance of various SQR programs by coordinating with testing team and carrying out necessary testing for specific SQR’s.

•Developed PeopleCode and SQL’s for Benefits data conversion and customization of self-service pages.

•Developed/Modified SQR interfaces to convert legacy system data to PeopleSoft Application tables.

•Worked on SQR functionality for data validation, processing, and error handling procedures.

•Designed/Developed SQR programs for Global payroll.

•Involved in carrying out System Test, Performance Test and Parallel Test.

•Analyzed and fixed various bugs that arises from the Payroll and Benefits Administration Unit Testing process.

Environment: PeopleSoft 9.0HRMS,People Tools 8.50, Application Designer, People Code, Application Engine, Component Interface, SQR, Crystal Report, Quick Test Windows NT, Oracle 10i.

MERCK, NJ Feb 2010 –Dec 2010

PeopleSoft HRMS/HCM Production Support

Role:PeopleSoft Developer

•Involved in maintenance and support of HRMS 8.9 modules (Core HR, Base benefits, Benefits module and Payroll).

•Involved in Configuring troubleshoot and Support all the tables involved in Payroll processing like Pay Calendar, Job Code, Deductions.

•Modified/Customized Records, Pages, Components and Menus for the Human Resources Department using the various People Tools.

•Tuned and enhanced several SQR programs for performance and functionality.

•Used process scheduler to run programs at scheduled times.

•Designed and created various Interfaces, which generate output files required for the third parties.

•Extensively used Application Designer and other People tools to modify existing tables to suffice the application needs.

•Modified the existing menus to reflect the customized panels and controlled the program flow with PeopleCode.

•Formatted the Input files in excel format to the format required to insert and update the data in the PeopleSoft database.

•Tuned and modified the SQL statements in various Application Engine programs.

•Done many fixes of the production problems in the PeopleSoft records, pages, PeopleCode and SQR programs.

Environment:PeopleSoft 8.9HRMS (HR, Payroll, Benefits), People Tools 8.49, SQR, Application Designer, Application Engine, Windows, and Oracle 10i.

Integrys, Chicago, IL Aug 2009 – Jan 2010

Role: PeopleSoft Junior Developer

•Extensively worked on Testing, debugging and making changes to Recruitment, Provident Funds and Pension module as per the business rules.

•Used SQR for creating reports for various modules as per client’s requirements.

•Developed pages using PeopleSoft Application Designer.

•Worked with Component Interfaces and PeopleSoft Application Engine for loading data to the new Database.

EDUCATION

Master’s in Management Information Systems, University of Houston, Houston, TX

Bachelors in Engineering, Indian Institute of Technology (IIT), India

Contact this candidate