SUMMARY:

PeopleSoft Techno-Functional consultant with 10+ years’ experience in Information Technology as a techno-functional consultant in PeopleSoft HRMS/HCM implementation, upgrade, troubleshooting and support.

Oracle Certified Expert in PeopleTools Application Developer and PeopleTools Advanced Developer.

Proficient in conducting business process analysis, gathering requirements, Fit-Gap Analysis, creating functional and technical design specifications and user training.

Extensive experience in Information Systems encompassing strategic planning, analysis, design, development and enhancement of client/server based applications with 3-Tier Architecture and Web based applications.

Strong PeopleSoft technical skills in PeopleTools that include Application Designer, PeopleCode, Application Engine, Component Interface, File Layout, Integration Broker, Process Scheduler, Workflow, Query, Data Mover and Security.

Strong PeopleSoft analytical experience in HR, Payroll for North America, Payroll Interface, Base Benefits, Benefit Administration, Time and Labor, Employee Self-Service and Manager Self-Service modules.

Expertise in writing, tuning and debugging the PeopleCode, SQR and Application Engine programs.

Extensive experience on data mapping and conversion of data from legacy systems to PeopleSoft systems using Integration Broker, SQR, App Engine, Component Interfaces, and Excel-To-CI tools.

Specialized in developing and customizing reports for PeopleSoft HRMS and Involved in debugging COBOL processes for NA Payroll.

Worked as Team lead and a team player as well.

Involved in Production support, responsibilities include maintaining, updating, and providing fixes for applications, configuration, specifications and migration of fixes to different environments for testing.

Experience in Unit Testing, System Acceptance Testing, user Acceptance Testing, Integration Testing and Parallel Testing.

In-depth understanding of PeopleSoft Internet Architecture (PIA), Data Model and client server applications.

Proven the ability to work in the team as well as individually on various projects.

TECHNICAL SKILLS

ERP

:

PS HRMS 9.2 / 9.1 / 9.0/ 8.x / 7.5 – Core HR, NA Payroll, Benefits, Time and Labor, Employee Self-Service and Manager Self-Service

People Tools

:

People Tools 8.5x / 8.4x / 8.0 - Application Designer, Component Interfaces, File Layout, PS Query, Data Mover, Integration Broker, Process Scheduler, Application Engine, PeopleCode, Object Security, Workflow, Portals, Import Manager, Security Administrator and PIA

Reporting Tools

:

SQR, BI/XML Publisher and Crystal Reports

Programming

:

PeopleCode, SQL, PL/SQL, COBOL

Database

:

Oracle 11g / 10g/ 9i, MS SQL Server 2012 / 2008 / 2005 /2003 and DB2

Pennsylvania Treasury July 2015 – Till date

Role: PeopleSoft Techno-functional Consultant

Environment: PeopleSoft HCM 9.2 (Core HR, ESS, MSS, NA Payroll, Base Benefits, Absence Management), People Tools 8.54, SQR, SQL Server2012.

Responsibilities

Involved in discussions for implementing PeopleSoft 9.2 for Pennsylvania Treasury Department.

Involved preparing technical designs and developing and unit testing of interfaces and reports using SQR and Application Engine tools.

Involved in Data Conversion of Personal data and Job Data from legacy system(Great Plains) to PeopleSoft9.2

Created a new SQR Interface to send Payroll information to PeopleSoft Financials using core Payroll tables.

Involved in sending Payroll data to General Ledger by using Distribute Actuals process (PSPPFUND), Commitment Accounting Actuals (PAYG02). Also customized paygl02.sqr to fetch correct account numbers for Offset accounting lines.

Involved in debugging COBOLs like PSPPFUND.cbl, PSPPFDST.cbl & PSPPFNRM.cbl for NA Payroll Distribute Actuals process and GPPDPRUN.cbl for Absence Management.

Created SQR reports for Absence Management like Generate yearly work schedules, Work Schedule report, Negative or Non eligible takes report, YTD leave calculations report, Employee scheduled leave report, etc.

Involved in creating Calendar group IDs and calculate and finalize absence and payroll processes.

Knowledge in Absence adjustments and Retro processing of absences.

Involved converting Company Seniority data, Position data from Legacy system to PeopleSoft 9.2

Involved in data conversion of Health Benefits, Retirement, FSA, Savings and Life Benefit data.

Created a SERS (State Employees Retirement System) Interface to send retired employees benefits data using SQR.

Used PeopleSoft PHIRE for migrating objects from source to target.

Created reports for State Employee Combined Appeal (SECA) data using BI Publisher. Also created Health deductions report, deferred compensation report, Payroll Reconciliation report, Union dues report and Interface, etc.

Involved in post-production support by fixing issues and working on enhancements.

NiSource Inc. December 2014 – July 2015

Role: PeopleSoft Techno-functional Consultant

Environment: PeopleSoft HCM 9.1 (Core HR, ESS, MSS, NA Payroll, Benefits), People Tools 8.51, SQR, Oracle.

Responsibilities

Involved functional discussions to segregate programs based on Companies, JobCodes, Departments for NiSource and Columbia Pipeline Group (CPG).

Involved in analyzing requirements and preparing technical designs.

Development and unit testing of requirements using Application Engine, SQRs, File layout, PeopleCode and Process Scheduler.

Involved in Setup of Process group security and row level security.

Worked on interfaces which involving inbound and outbound with third party providers like AON Hewitt, Fidelity and Workbrain.

Involved in debugging of SQRs, PeopleCode as per the requirement.

Worked on compensation interface which sends data to the third party called Hewitt.

Worked on supporting for Success Factors interface, Communicator interface and ADP Quarterly, periodic and Check print programs.

Working on issues when users logged tickets using HP Application Lifecycle Management 11.52 (ALM) tool.

Debugging issues on reports like Monthly step progression, vacation carryover, leave report and Workforce planning reports.

Working closely with then users when User Acceptance testing and System acceptance testing.

Responsible for Migration requests to move objects from development to SAT & UAT. Upon receiving compare reports from PS Admins need to review and validate for smooth migration of objects.

Extensively used Oracle SQL Developer to write SQLs as per the program debugging and modification of programs.

Rimini Street January 2013 – September 2014

Role: PeopleSoft Techno-functional Consultant

Environment: PeopleSoft HCM 9.x / 8.x / 7.x (Core HR, NA Payroll, Canadian Payroll, Benefits), People Tools 8.12 to 8.53, SQR, Oracle, SQL Server and DB2.

Responsibilities

Involved in the design and development of Tax and Regulatory updates for Rimini Street PeopleSoft Clients and worked on on-shore and off-shore model.

Provided Fit/Gap and Business Analysis to identify process changes and their impact.

Involved in the business process meetings along with Functional resources to identify the customizations.

Played key role in retrofitting Interfaces, Online Customizations, SQR's, PeopleCode and Application Engine programs.

Responsible for performing User Acceptance Testing to ensure that configurations produced desired results.

Configured benefit plan, vendors, benefit program, event rules and event class tables.

Developed and customized Application Engine programs, Component Interfaces to load data from external systems into PeopleSoft System.

Created inbound/outbound interfaces and generated reports using People Tools, SQR, Application Designer, Application Engine and application packages.

Documented table structure setup, modification of the Workflow process for daily event processing, Open Enrollment functionality and strategy for Data conversions.

Assist Payroll, Benefits and HR users with troubleshooting and issue resolution involving W-2 printing, leave accrual adjustments and annual Benefits Open Enrollment.

Extensively used App Designer for creating new objects, modifying the existing customizations.

Designed, coded, tested and implemented several complex new SQR reports for the Staff Analysis according to the Business Requirement.

Worked on analyzing and debugging of COBOL programs PSPPYCAL, PSPCPCAL Pay Calculation programs for US and Canada when errored out.

Customized several SQR programs. These SQRs included interfaces to/from vendors, internal processes and user reports.

The Hackett Group August 2010 – January 2013

Client: CERIDIAN

Role: PeopleSoft Technical Lead

Environment: PeopleSoft HRMS 8.8, People Tools 8.45, SQR, Oracle 9i, SQL Server 2003, Windows NT/2000, Mainframe.

Responsibilities

Worked as a Technical Lead for four member team and worked on off-shore and on-shore model.

Gathering requirements from Ceridian, analyzing the requirements, preparing FDD and working closely with Ceridian clients and off shore team in order to complete deliverables on time.

Involved in the business process meetings to identify the customizations.

Worked on analyzing and debugging of COBOL programs when errored out Paysheet creation, Pay Calculation and pay confirmation processes.

Worked with Setups, Core Payroll Tables, and Employee data. Payroll Process (create, calculate and confirm process, direct deposits)

Prepared documentations – FDD/TDD, Release docs, Installation guides, Test Plans, Test Scripts

Multi-client interactions based on issues, interact with Oracle regularly on Tax updates, patch enhancements and probable solutions

Involved in analysis, customization and implementation of HR/Benefits/Payroll modules using PeopleSoft 8.3 to 8.9 and Oracle 9i.

Involved in the data mappings, and data conversion of Legacy system data (.CSV file) to PeopleSoft HRMS tables using App Engine programs and SQRs.

Involved in the design, development and testing of all HR, Payroll, Benefits.

Used Application Engine, Application Packages, People Code and SQR extensively to create processes, outbound files and reports.

Work involved development of interfaces with Component Interfaces to read inbound files and manipulating the PeopleSoft tables.

Created an Application Engine Program to load data into Job table by using Job Data Component Interface.

Used Application Designer to modify existing records, pages, and menus. Created new records and pages for the specific needs of the client.

Performed data conversions, report writing, report customizations, page customizations and People Code programming. Developed conversions programs to load Payroll and Benefit tables in PeopleSoft using SQR.

Involved in setting up the Security, which contains creation of permission lists, Roles, assigning Roles to the User Profiles.

HSBC September 2008 - July 2010

Role: Software Engineer

Environment: PeopleSoft 9.1 (Core HR, Payroll, Benefits, T&L, Ben Admin, ESS, MSS), People tools 8.51, XML Publisher, App Engine, Mainframe, Application Designer, DB2, SQR, MS Office.

Responsibilities

Involved extensively in Level1 Payroll production support for more than 50,000 HSBC employees of North America and Canada region.

Involved in giving Business As Usual support and working closely with users to resolve the issues.

Worked on Mainframe environment to upload and modify SQR programs.

Worked on enhancements based on business user’s requirement, resolving user’s issues and involved in activities like Unit testing, System Acceptance testing, User Acceptance testing and moving the deliverables to production environment whenever the nearest production window was available.

Involved in Time Admin process support for Time and Labor module.

Used STAT tool for migrating objects from source to target.

Applied Tax updates regularly and did regression testing every time whenever Tax updates are applied.

Involved in supporting of United for Hope (UFH) and Compensation Management System (CMS) batch processes.

Extensively used DB2 database to create SQL scripts.

Involved extensively in NA Payroll module by running paysheet, precalc, final calc and pay confirmation processes. Involved in running audit report processes and reviewing Payroll error messages and fixing the errors while payroll processes were running.

Involved in year-end activities including W2-forms processing and reporting.

Worked on Offshore-Onsite model.

Created SQR process to send Email notifications to Time Keepers and Time Reporters to remind them to approve the time.

Designed & Developed SQR Reports which will be generated when a new contract is created or if any changes to the existing contract.

Fixed Issues related to Manager Self-Service (MSS) for Job Opening Approvals, Absence Approvals.

Responsible for writing PeopleCode for the Operations Manager Approval process using MSS.

Worked on fixing issues related to Benefits & Workflow.

Customized the Application Engine and used job Component Interface to load salary data of Global employees from 3rd party system.

Involved in tuning of existing SQR's to improve performance.

Sierra Atlantic April 2008 - August 2008

Client: NUMMI

Role: PeopleSoft Technical Consultant

Environment: PeopleSoft Financials 8.0 SP3 / 9.0, PeopleTools 8.19 / 8.48, Oracle 9i / 10g.

Responsibilities

Involved in the design and development of the upgrade plan from 8.0 to 9.0.

Provided Fit/Gap and Business Analysis to identify process changes and their impact.

Involved in the business process meetings along with Functional resources to identify the customizations.

Played key role in retrofitting Interfaces, Online Customizations, SQR's, PeopleCode and Application Engine programs.

Retrofitted the existing customizations for online pages

Developed and customized Application Engine programs, Component Interfaces to load data from external systems into PeopleSoft System.

Extensively used App Designer for creating new objects, modifying the existing customizations.

Designed, coded, tested and implemented several complex new SQR reports for the Staff Analysis according to the Business Requirement.

Retrofitted several SQRs from 8.0 to 9.0 These SQRs included interfaces to/from vendors, internal processes and user reports.

Sierra Atlantic February 2006 – March 2008

Client: Juniper Networks

Role: PeopleSoft Technical Consultant

Environment: PeopleSoft HRMS 9.0 / 8.0 (HR, Base Benefits, Payroll, Time and Labor), People Tools 8.49/8.16,Oracle 9i / 10g.

Responsibilities

Involved in the upgrade to PeopleSoft HRMS 9.0 from PeopleSoft 8.0. As a team member my Responsibilities included customization specifications, upgrade & conversion validation, prototyping and testing, troubleshooting and support.

Created interfaces (inbound and outbound) and online customizations for HR, Compensation, Base Benefits, Benefits Administration, payroll and Self Service modules. Used Application Engine & SQR for these conversions and interfaces.

Created an Application Engine program to insert new data into PS tables for bulk transfer of employees to new departments by using CI_JOB_DATA component interface from AppEngine.

Developed various Disability/Special Accommodation reports for regulatory compliance. Created run control pages, process definitions, components and menu item to run these reports online.

Created several technical design documents for various Benefits and HR reports to be developed using SQR

Actively involved in creating test cases and carrying out those tests for Unit Testing of various Application Engines and SQR applications.

Reviewed and customized coding of COBOL programs for changes of fields and records in Upgrade process from HRMS 8.0 to 9.0.

Responsible for operational changes and running ad-hoc reports for different business groups.

Sierra Atlantic July 2005 – January 2006

Client: NEC Personal Products, Ltd.

Role: PeopleSoft Technical Consultant

Environment: PeopleSoft CRM8.9, PeopleSoft Enterprise Portal8.8 (Order Creation, Order maintenance, Product Configurator, Enterprise Pricer), PeopleTools8.43, Oracle 9i, Windows NT.

Responsibilities

Created inbound/outbound interfaces and generated reports using People Tools, SQR, Application Designer and Application Engine

Created Process Definitions to all conversions and SQR programs.

Done requirement study of client legacy system which is developed in BroadVision portal.

Designed and developed mapping between PeopleSoft and BroadVision portal.

Involved mainly in the implementation and customization of the tasks related to the Customer Relationship Management (CRM) modules of people soft 8.9 version.

Involved in developing NEC Direct portal using Enterprise Portal features.

Customized PeopleSoft delivered Shopping Cart, Payment options, Order confirmation pages by applying style classes according to the requirements of NEC.

Involved in Order Capture like Managing orders and Quotes.

Integrated Advance Configurator with Portal Pagelets.

Designed NEC specific custom Pagelets and sites using Portal Content Mechanism, News Publication and Branding.

Set up Catalog templates, Catalog Definitions, Products in CRM.

Used Application Engine, People Code and SQR extensively to create processes, outbound files and reports.

Work involved development of interfaces with Component Interfaces to read inbound files and manipulating the PeopleSoft tables.

EDUCATION DETAILS:

Bachelor of Engineering from Andhra University from 1998 – 2002.

Contact this candidate