Project Data

Sandeep Kumar

Phone – 281-***-**** Email - ******.*******@*****.***

PROFESSIONAL SUMMARY

8+ years of extensive PeopleSoft Techno-Functional experience in PeopleSoft HRMS 8.X, HCM 9.0, 9.1 & 9.2 in different roles as part of Implementation/ Upgrade/ Conversion/ Development/ QA Testing/Training/ Production Support teams.

Oracle Certified PeopleSoft Developer.

Eight Years of strong PeopleSoft experience in Analysis, Technical Development, Customization, Upgrade, Implementation, QA Testing and Production Support of PeopleSoft HRMS.

Excellent working knowledge of the PeopleSoft Internet Architecture (PIA) and the flow of data exchange between various HRMS modules.

Strong PeopleSoft analytical experience in Core HR, Payroll, Payroll Interface, Time and Labor, Employee Self-Services (ESS), Manager Self-Services (MSS), Base Benefits, Benefits administration.

Expertise in Application Designer, People Code, People Tools, Application Engine, Component Interface, File Layout, Application Packages, Application Messaging, Integration Broker, Workflow, Process Scheduler, Data Mover, Upgrade Assistant, Change Assistant and Reporting tools like XML Publisher, SQR, Crystal Reports, PS Query, UPK.

Well versed with project development life cycle, System Business Process Analysis, Requirements Study, Fit-Gap Analysis and Post-Implementation support.

In-Depth knowledge in Integration Tools including Application Engine, File layout, Component Interfaces, and Integration Broker (Application Messaging).

Specialized in Data Extraction Interfaces and Conversion from legacy to Peoplesoft applications using SQR programs and Application Engine.

Proficient with PeopleSoft HCM database and PIA. Very sound RDBMS concepts and good database programming experience using Oracle 9i/8i, MS SQL Server 7.0/6.5, SQL, PL/SQL and SQL Loader.

Excellent Documentation skills in the creation of Technical Design Documents, Test Scripts and Detailed Design Documents using Oracle’s User Productivity Kit.

Organizational PeopleSoft Support to end-users as well as development team during and after the implementation of the project.

Sound experience in Debugging and Tracing People Code, SQL, Application Engine and SQRs.

Experience working with Oracle Meta Link (Customer Connection).

Excellent Communication, Interpersonal, Leadership, Analytical and Problem solving skills.

EDUCATION AND CERTIFICATES

Bachelor of Engineering in Electronics (Acharya Nagarjuna University, India)

Oracle Certified PeopleSoft Developer

TECHNICAL SKILLS

ERP : PeopleSoft HRMS/HCM v8/v8.3/v8.8/8.9/9.0/9.1/9.2 (HR, North American Payroll,

Base Benefits, Benefits Administration, Self Service (ePerformance, eBenefits), Time and Labor, Talent Acquisition Manager 9.0)

PeopleSoft Tools : People Code, Application Engine, Component Interface, HTML, SQR,

Crystal Reports, PS Query, Application Package, Application Messaging,

Integration Broker, XML Publisher and Data Mover.

Operating Systems : Windows 98 / NT, Sun /Solaris UNIX

Languages : C, C++, VC++, VB, HTML

Databases : SQL Server, ORACLE 7.x, ORACLE 8I, ORACLE 9i

Database Tools : Toad, SQL Tools, SQL Developer, SQL Ace

Domain Knowledge: Insurance, Banking, Marketing, Financial Services, Government, Staffing

PROFESSIONAL EXPERIENCE

Harris County, Houston, TX

Aug ’16 – Current

Project Description

:

PeopleSoft Enhancement / Production Support

Modules

:

HR, Payroll, Benefits

Role

:

Senior PeopleSoft Functional Consultant

Responsibilities:

Performed migrations of different project from Source environments to Destination environments using STAT tool.

Worked on DEPEND_BENEF component (Update Dependent Beneficiary component), to include new logics to accommodate QDP. Logics include, avoid adding QDP to a member who already has a spouse and vice-versa. Also, wrote logic to validate the combination of relationship and marital status codes. Ex: Spouse/QDP should always have a marital status of married/QDP accordingly.

Wrote Tech specs, Test scenarios/scripts for all the modifications/customizations related to project.

Worked on reports which includes different reports like:

oSalary study reports – Which keeps track of current salaries of the pastors, dispersed according to different congregation sizes for different Pins. (Departments -> Churches.)

oDemographic study reports – Which helps upper management to take policy making decisions. It covered the average age and gender and marital status distribution of members per year for ministers and for lay members who were part of the plan as of the end of the year, between years provided.

Worked on the successful resolution of different Production issues which include:

oIssues with Salary Grade process. Generally, salary grade is set according to different salary ranges. But the salary grades for some of the ranges were going wrong. Fixed the effective dated logic in SQL to get salary grades.

o“No matching buffer found for level error” for some EmplIDs. For some members, there were rows in PERS_NID record for their dependents, but were missing the rows on parent/higher level records. The issue was related to past conversions.

oDouble invoice total problems with Benefits billing invoices because of FUTURE_FLG on EMPLMT_SRCH_GBL record.

oFidelity interface issue. The custom program was designed to deal with domestic members only. Modified the program to process international members.

oBCP interface issue. The interface application engine was sending the txt file to the vendor with the first and last name as first name only. Modified the application engine to correct the issue.

Worked on the reports which get the members who are eligible for member couples but are not member couples, and members who are member couples but should not be member couples, according to member couple criteria. Modified the report, to accommodate the new QDP RELATIONSHIP and MAR_STATUS codes.

Developed 2 SQR reports from the scratch, to report the EEs, who has a Health benefit enrollments for Highmark/ESI within 30 Days in the future, excluding the members with future drops.

Wrote DMS scripts to export/import different Benefit Programs and Event rules from/to different environments.

Worked on a process to load Zip codes for Aetna Dental to Production system during open enrollment for coming year.

Modified different Personal data pages to accommodate changes related to QDP, added QDP related fields to the records/pages.

Analyzed Several Benefit Programs for references in database/SQRs, during Aetna Impact analysis project. Decoded all the People Code and SQL definitions from the database to a text file, so that all the developers can do searches in text files instead of doing ‘find in’ in application designer. This greatly helped in reducing the time by 5-10 times the actual time required for analysis.

Environment: PeopleSoft HRMS 9.2, People Tools 8.54, DB2, Toad, SQR, Application Engine, STAT, File Layout.

Hilton Hotels, Plano, TX

Jan ’15 – July ‘16

Project Description

:

PeopleSoft Upgrade/Reimplementation from 9.0 to 9.1

Modules

:

HR, Payroll, Recruitment, MSS, Benefits

Role

:

Senior PeopleSoft Functional Consultant

Responsibilities:

Hilton Hotels, The Project was focused extensively on the Enhancements and maintenance support of HRMS modules like Core HR, Base benefits, Benefits Administration, NA Payroll, Time & Labor and Absence Management. Support includes PeopleTools and the Reporting Tools.

Reimplementation the process UHC_099, which is replica of PER099, which populates UHC_PERSONS instead of EMPLOYEES. Created EMPLOYEES as the view of UHC_PERSONS.

Worked on retrofitting/reimplementation of Payroll Audit Reports and Payroll Archive processes which includes Mercer Error Report, Daily Rehires Report for Payroll Operations, Daily terms Reports, Pay Period Overtime Reports, Employees Not Processed in Current payroll, Payroll Archive Process. Reports and processes include SQRs and Application Engines.

Worked on bolt-on module ReCAP (Requisition Creation and Approval), which allows hiring managers and administrators to create requisitions within PeopleSoft and obtain approval prior to importing them into Taleo for fulfillment, which is a third party application for Recruiting.

ReCAP was subdivided into different processes and reports, which includes, Approvals, Approval Reassignment Process, Batch processes, Core Functionality and Online pages, Delegation, Enhancements, Look and Feel. Worked on complete ReCAP cycle, which includes reimplementation of SQRs, Application Engines and Pages.

Instead of using custom Delegation process, re-implemented all processes using delivered Delegation functionality in 9.1.

For number of MSS components, implemented DirectReportsUI logic instead of OPRROWS direct reports logic, to render the direct reports structure to the managers for processing a transaction for their employees.

Applied retrofits to all Tax/Batch Processes and Reports in Payroll, which includes Tax Location Change Report, WC Quarterly/Monthly Wages and Premium report, Labor Department Report, Tax Deposit Summery (TAX001), Local Tax Deposit summary (TAX009).

Most of the processes worked on, instead of hardcoding values in process itself, used Programmers Set up Table, which keeps track of all hardcoded values in the process, which makes the processes really easy to maintain.

Worked on Benefits processes/reports regarding Leave Plan Enrollment, which includes process Automatic Benefit Plan Assignments, and report Employee Benefit Plan Data Audit Report.

Created New Records, Pages, Menus, Components, Application Engines, SQRs according to client requirements.

Redesigned and implemented sqr process in MSS, which reassigns supervisors when the supervisor has terminated. Redesigned the SQR process as an Application Engine, which uses CI logic instead of Update SQLs in SQRs.

Designed and developed Component Interfaces for Job Data components to load the data from Staging Tables to PeopleSoft Application tables

Environment: PeopleSoft HRMS 9.0 & 9.1, People Tools 8.49 & 8.51/8.52, Oracle 11g, Toad, SQR, Application Engine.

American Online, Dulles, VA

Jan ’13 – Dec ‘14

Project Description

:

PeopleSoft Upgrade from 8.9 to 9.1 and Implemented Customizations required at Client.

Modules

:

HR, Payroll Interface, Position Management, Benefits

Role

:

Senior PeopleSoft Techno Functional Consultant

Responsibilities:

Active participant in fit-gap sessions on upgrade project involves upgrade from PeopleSoft HRMS 8.8 to PeopleSoft HRMS 9.1.

Documented the effect of table structure changes on various Processes.

Worked on retrofitting various SQR reports and processes in HR, Payroll, and Benefits, includes reports like, Position status report, Incumbent history report, Active position history, Employee compensation change, Leave of absence, Cable benefit for employee accounts etc.

Worked on retrofitting the interfaces in HRMS and Payroll interface, includes interfaces, Pub-Sub data repository interface, Market pay interface, World travel interface, Course Mill to PS interface etc.

Worked on retrofitting online changes regarding pages, retrofitted the changes related to records.

Worked on retrofitting Total Rewards interface in Benefits. Due to project deadline limitations, the vendor was unable to accept all the changes in benefit health plans, so I have created the Benefit plan translations table, to map the new benefit plans to old benefit plans.

Fixed a bug in position management, which decides, whether to update the incumbents using update_incumbent function or using delivered application engine batch process, after change in position data, which is new functionality in 9.1.

Created interface File with summary of all benefit Plans employee is currently enrolled in, to Generate Benefit Statements.

Developed Benefits Interface for creating file with Vision Plan.

Customization of the ePerformance pages according to the client needs.

Involved in the data mapping and process definition for the pilot conversion of the Employee data, which involved loading of cleaned data from another application.

Developed and modified People Code for HR, Self-Service and Payroll modules to implement specific business rules and validations to enable the system to perform the business process

Designed and developed new SQR program for performance measurement and management module to make all the HR transactions sync with PMM customized system.

Involved in Performance tuning of SQL queries. Optimized the queries, by setting up the Optimize Query flag for all the users, and for both private and public queries.

Customize the Pub-Sub interface, according to client requirements. This was one of the most important interfaces for the client, which was scheduled to run every night. This interface used to collect data from HR & payroll tables and put that on Pub-Sub repository, which is the separate DB. Data was picked up by all the vendors.

Environment: PeopleSoft HRMS 8.9 & 9.1, People Tools 8.49 & 8.51, Oracle 11g, Toad, SQR, Application Engine.

Robert Half International (RHI), San Francisco, CA

Oct ’11 – Dec ‘12

Project Description

:

Implementation and Production Support for HRMS 9.0 and People Tools 8.49

Modules

:

HR, Payroll, Time and Labor

Role

:

PeopleSoft Techno Functional Consultant

Responsibilities:

Robert Half International is a global leader in professional staffing and consulting services, with a network of more than 400 offices worldwide.

Really proud to be a part of completely modified Time and Labor module project team, which is called TCAST, stands for, PeopleSoft Time Capture and Approval for Staffing application.

Worked at RHI, as a Senior PeopleSoft developer. Area of work includes, creating Custom interface processes using Application Engines, Worked on web services as well as Integration Broker, as part of Interface between different systems. Development of custom Reports.

Worked on development of the process, using Application Engine, which will load the Job Orders from MJQ system (Job order management system +ERP package) to the PeopleSoft system.

Part of a team to develop a custom self-service application within PeopleSoft Time and Labor, that allows candidates to enter and submit time online, print timesheets, view timesheets and timesheet history and clients to approve, print, and view timesheets.

As a part of above mentioned application, designed and developed a process, using Application engine, which will maintain a sync (or create new users) between users from third party user management system (OAM) and PeopleSoft system.

Coordinated with team on OAM side, to develop web services, which needed to interface between these two systems. Also, developed a generalized Application package, which is used to maintain sync between OAM and PeopleSoft.

Responsible for design and development of Email preferences page, which is used to set the email preferences for Candidates/Clients. Also, developed an application package, to access these preferences from different processes.

Worked on interface between two systems PeopleSoft Time and Labor and Livelink (which is a document management system), which will create shortcuts for Group timesheet images which are submitted manually.

Coordinated with the team of Livelink, to successfully develop the web service, which is needed for above mentioned interface between PeopleSoft and Livelink.

Design and developed a generalized application package, which is used to create shortcuts for the group timesheet images.

Designed and developed a process, which will update the attributes of images on Livelink system, after the group timesheets from Peoplesoft Time and Labor are approved and Batch and reference numbers are populated for respected timesheets. Also, responsible for designing the web service, for process, which updates the Livelink attributes.

Developed a report, Worklist activity by Processor, which is used for tracking the volume and activity by Back Office users, whenever a Back-office users maintains a worklist.

Developed the Application Error Management system, which will track all the errors encountered during the interface processes between third party system and PeopleSoft system. Includes development of new objects like fields, records, pages, components etc.

Environment: PeopleSoft HRMS 9.0, People Tools 8.49, Oracle 10g, Application Engine, Integration Broker, XML Publisher.

Trinity Inc., Dallas, TX

July ’10 – Sep '11

Project Description

:

Implementation and Production Support for HRMS 9.0 and People Tools 8.49

Modules

:

HR, Payroll, Time and Labor, Manager Self Service (MSS)

Role

:

PeopleSoft Techno Functional Consultant, Integration Broker Specialist

Responsibilities:

Trinity Industries is the global leader in decorative paints and largest manufacturer of performance coatings. They also manufacture specialty chemicals that are in everyday products. This project involved PeopleSoft HRMS Implementation and Customization.

Worked at EQB as Integration Broker Specialist, Configuration of Integration Broker to Interface between Different modules, like, Payroll and General Ledger, Time and Labor and Project Costing. Setting up the EIPs, Enterprise Integration Points for these Environments. (Configuring Gateways, creating Nodes, Messages, Routings, and XML schemas).

Development of new SQR Reports Includes, Salary Increment Report, Miscellaneous Deductions register, Off Cycle checks Reports, Historical Leave report, Leave Excess Report, Leave balance Report.

Modified existing interfaces, reports and processes. Designed and developed the Data Conversion process using SQR. Customized Payroll / T&L delivered SQR’s to meet the client’s requirements like PAY002.SQR, TL002.SQR, DDP001.SQR and PAY003.SQR.

Developed Data Conversion Programs for Dependent Data Component, Personal Data Component, Job History and other Benefits components using Application Engine, Component Interface and File Layout.

Involved in Design and development of Leave Accrual Process. Development of New Application Engine Process Includes, Paid Balances Adjustment Program, which will update the balances on TL_COMPLEAV_TBL. Developed reports for the process, Leave Balances Report, Historical Leave Report, Leave Excess report.

Provided Production Support for Integration Broker. Support includes manual operation of some processes, which were going fail, because of Database indexes problems. This includes, loading Vouchers from Payroll to Accounts Payable, using Data Mover Scripts.

Involved in the development of Template Based Hire component and customizations to the TBH functionality.

Developed Interfaces to Outside vendors. Created night Jobs and weekly jobs that update various tables and create interface files for the internal and external Use in HGS.

Responsible for maintenance and configuration of PeopleSoft’s Integration Broker.

Developed rules using Rules templates and compiled to add relevant section in the Application Engine (TL_TA_RULES) controlling the time administration process.

Worked with Workgroups – provided Day Breaker and Rounding options, Rule Program ID, TRC program ID both for Positive Time and Elapsed time and whether or not they needed approval.

Involved in Setup of Eligibility rules and Plans in Benefits Administration. Involved in the testing of the Benefits Administration process for Open Enrollment, Snap and Event maintenance. Complete understanding of the Benefits Administration process from scheduling to enrollment.

Designed and developed interface programs to validate the data coming in flat files from different health care providers and to load that data into HR and Benefits tables using Component Interfaces.

Customized delivered Open Enrolment Confirmation Form BAS005, and developed online confirmation form to provide employees the ability to print their own Confirmation Statement.

Developed SQR, which checked for employees who haven’t entered any Beneficiary Information (During Open Enrollment) and gets their Previous Beneficiary info and loads them into different dependent tables.

Used different Environments like Test, Development to test the Bugs and to create a replica of the Problems.

Coordination with the Other Module Team Leads for the Business-Related Issues.

I was also responsible for reviewing and updating training materials (using PeopleSoft’s User Productivity Kit- UPK).

Environment: PeopleSoft HRMS 9.0, People Tools 8.49, Oracle10g, SQR, Application Engine, Integration Broker.

State Farm, Bloomington, IL

May ’09 – June ’10

Project Description

:

PeopleSoft HCM Upgrade from 8.8 to 9.0, and also in Post Production Support & Maintenance.

Modules

:

HR, Payroll, Employee Self Service (ESS), Time and Labor, Benefits

Role

:

PeopleSoft Techno Functional Consultant

Responsibilities

Participated in appropriate Fit-Gap sessions, and create and resolve alternatives related to conversions, customizations, or interfaces.

Monitored progress on the upgrade project plan and tasks, and coordinated communications between the upgrade team members, clients and third party vendors.

Facilitated weekly meetings with the project team to discuss progress and issues, and altered the scope of the upgrade or obtained additional resources, as required, to ensure that the project is completed on schedule.

Worked on Payroll tables PS_PAY_CALENDAR, PS_PAY_CHECK, PS_PAY_EARNINGS, PAY_OTH_EARNS and PS_PAY_DEDUCTIONS.

Setup employee information in Payroll Module to calculate employee earnings and Taxation of their Earnings and Benefits.

Created work groups and time reporting codes for work groups. Involved in creating task groups. Have a thorough understanding of functionality provided by Time and Labor.

Responsible for developing SQR Interface Programs which gets Pay sheet Data from Time Keeping Systems and Validates Key fields against corresponding Master Tables and loads data into Staging Table for further Payroll Pay sheet Process.

Performed troubleshooting of Time Admin Process failure and its failure to create time – analyzed Exceptions, Time reporter active status, Effective dates, Rules, and Time reporter status.

Customized the Open Enrollment Forms Interface to not to show SSNs, Dependent benefits from dependent records and deleted department IDs, Location, Bas Group IDs from Employee Record.

Enhanced BEN100 Run Control Page to enable user to run the snapshot by scheduling it and also to be able to run it manually when needed.

Customized the Self Service Transactions Pages. Additional fields and component People Code was written to enhance the functionality to meet customer requirement. Approval rule set and Activities were modified to route approval transactions and email notifications to administrators based on location.

Creating Self Service permission lists that would be given to the manager and employee roles, creating administrator roles, assign it to the user profile

Customized the search for Job Data, Personal Data and other components to enforce search based on the custom fields - Login name and Phone tool name.

Creation of Data Conversion programs from HRMS 8.8 to 9.0.

Analyst, Designer and Developer for the cleanup of duplicate data in the Personal Data Component.

Developed SQR to Read from file and Write to file as part of the Data Cleanup.

Customized the pages in Benefits based on the Plan Type and region.

Design and Developed user training materials using Oracle UPK (User Productivity Tool) tool, for different modules including Payroll, Time and Labor.

Working on UPK includes, developing different training (Playback) modes, like See It, try It, Know It, Do It.

Extensively used PS/Query to develop ad-hoc queries, generate Crystal Reports and to produce analyzing reports using excel.

Generated reports using XML Publisher with Query, Row set and XML as data source and into PDF, RTF and XLS as output format.

Environment

PeopleSoft HRMS 8.8/9.0, People Tools 8.48/8.49, SQR, Crystal Reports and Oracle 9i

Contact this candidate