SUMMARY:

• Around 6 years of experience in Development, Implementation, Customization, Upgrade and Maintenance of various PeopleSoft HRMS/ HCM modules such as Core HR, Benefits, Ben - Admin, Absence Management, NA Payroll, Time Labor and Self-Service ESS, MSS, Talent Acquisition.
• Knowledge and hands on experience in configuring Oracle Fusion/Cloud HCM, including Core HR, Benefits, Absence Management, Payroll, Compensation and Talent modules with proven project delivery through full life-cycle from requirements through deployment / support.
• Involved in micro managing build /delivery of key functionality within PeopleSoft Core HR including PeopleSoft HCM - SAP Finance integration, profile management, Staffing, ESS and MSS.
• Resolved the tickets and/or MECs related to HR/Self Services, Compensation and Security Administration and NA Payroll. Developed outbound interface to send employee compensation data to external systems.
• Extensive experience on support and enhancement of people soft HRMS - Time & Labor, North America Payroll, Core HRMS, Manager Self Service, Employee Self-service, Compensation and Profile Management.
• Extensively used PS Query to develop various queries based on User requirements.
• Experienced closely with the Compensation team to map the Salary Plans, Grades and Steps for Union and Non-Union Employees, and uploading Employee compensation information using Excel to CI in PeopleSoft.
• Experience in customizing PeopleSoft HRMS/ HCM (HR, Base Benefits, Workday, Benefit administration, Time & Labor, e-Modules, Compensation and North America Payroll).
• Predominantly focused on design and customization of PeopleSoft HCM Modules (Core HR, Workforce Administration, Benefits, Recruiting, E-Performance, E-Compensation and NADM).
• Designed of OBIEE Reports & Dashboards on Core HCM processes (Employee/Workforce details, Hires/Headcount/ Terminations, compensation/Diversity/benefit, Turnover reports & VIP dashboards).
• Proficient in working with People Tools, Application Designer, People Code, SQR, Component Interface, PS Query, XML/BI Publisher, Data Mover, Integration Broker, Application Package.
• Expertise in people soft Concepts, tools and technologies like Application Designer, People Code, People Tools, Application Engine, Integration Broker, Workflow, AWE, Component Interface, PS Query.
• Extensively involved in HR, NA Payroll, Benefits, Time and Labor, e-Recruit (Candidate Gateway and Talent Acquisition Management), Compensation, Training, Employee Self-Service and Manager.
• Expert in using Application Designer, SQR, People Code, Application Engine, Excel to CI, Integration Broker, Component Interface, Process Scheduler, Fluid Pages, PS Query, Process Monitor, Data Mover and File Layout.
• Experienced in all phases of ERP lifecycle Upgrade, Conversion, Interfaces, Production support and troubleshooting of PeopleSoft applications release 9.x
• Performed prototype demonstrations for all Talent Management related modules to the Sr. HR Directors as a part of requirements gathering workshops.
• Experienced in working on PeopleSoft reporting tools like XML PUB (BI Publisher), PS Query and Workflow technology for notification Frameworks.
• Experienced in Integration Broker services such as Nodes, Messages, Services, Operations, Routings and Queues for automatic updates between PeopleSoft to PeopleSoft applications and Third-Party applications.

PROFESSIONAL EXPERIENCE:

Sr. PeopleSoft Developer

Confidential - New Brighton, MN

Responsibilities:

• Retrofitted multiple Interface Programs in Core HR, Time & Labor and Payroll Modules during Upgrade from Version 9.0 to 9.2.
• Prepare the Compare report analysis after identifying the objects to be carried forward to 9.2 and objects to be dropped from carrying forward.
• Retrofitted multiple Custom template built rules.
• Retrofitted multiple agencies custom Time and Labor Auto enrollment application engine Programs.
• Customized number of existing SQR's/PS Queries/Crystal Reports etc. to suit the Business requirements. Worked on SQR's to bring them in sync with the new features brought in PS 9.2.
• Modifying, Compiling and Running Payroll Batch Processes.
• Developed Technical Design documents for the existing reports identifying the retrofits to be made to run them in 9.2.
• Customized the View Pay Check functionality.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
• Retrofitted Enhancements, build new and retrofitted existing interfaces to support to extract and load HR/Payroll Data for Internal and External interfaces and also load data into PeopleSoftHR/Payroll tables.
• Participated in fit/gap analysis of an Integrated Payroll and Benefits System.
• Performed Performance Tuning on Time and Labor's Time Administration processing and resolved Time and Labor production issues.
• Responsible for retrofitting the interface programs for Payroll and Benefits with Vendors and customizing delivered functionality according to Client.
• Modified SQRs and online pages according to new Version Changes as per the business requirement.
• Worked on interfaces with Kronos time keeping device and time & labor.
• Retrofitted Custom Time and Labor Interface application engine program that loads data from the flat files sent by various different Time Keeping Systems into PeopleSoft Reported Time table.
• Retrofitted multiple Payroll PeopleSoft Queries, SQR's and XML publisher Reports.
• Created Security Roles and Permissions for end users in PeopleSoft, gave specific security access to supervisors to enter, approve and process reported time.
• Resolved tickets on priority basis and attend calls with functional team for early resolutions.
• Performed an inventory of existing Time and Labor rules and identify and document the rules that need to be modified for Version 9.2.
• Primary Support for Time and Labor and Payroll Modules during User Acceptance Testing and after Upgrade go-live.

Environment: PeopleSoft 9.0/9.2 (HR/ELM), Benefits, Payroll, TL, People Tools 8.55, App Designer, People Code, Application Engine, PS/Query, Application Messaging, Data Mover, Crystal Reports, SQR.

Sr. Peoplesoft HCM Techno Functional Consultant

Confidential - Portland, OR

Responsibilities:

• Developed Application Engine programs to export Personal Data - Name, date of birth and address information to flat files using File Layout.
• Developed Conversion Application Engine programs to export Job Data information to flat files.
• Developed programs to extract setup information Departments, Job Codes, Locations, and Department security to flat files to send to SAP.
• Compared the exported information from PeopleSoft to the imported information to data dumps from SAP.
• Involved in analyzing the Data Errors that occurred when offcycle payroll is run and fixed those Issues.
• Developed and maintained Manual Checks Detail Report. This report is intended to provide complete details of the manual checks issued in a pay cycle.
• Developed a custom Application engine program using Component Interface to create User Profiles in HR for all employees based on their location.
• Customized and Printed SQR Report 'Tax910PR' for the layout of W-2 forms as per the client requirement.
• Developed data mover scripts (DMS) to migrate Rules, SQL Objects, Messages and Message Catalogs, and Exceptions.
• Developed workflow to automate the notification for the employee about the open enrollment dates and changes occurred in the benefits and payroll rules.
• Configure, troubleshoot and Support all the tables involved in Payroll processing like Pay calendar, Job Code, Deductions and processes such as Pay Sheet creation, Pay Calc, Pay Confirm, Tax Tables etc.
• Reviewed client data and prepared Data Mapping for File Layouts from legacy to PeopleSoft formats.
• Produced PDF and spreadsheets report formats for HR by creation of SQR processes.
• Migrated customized objects from Development to Test Instances using STAT.
• Composed Queries and Crystal Reports for generating reports for modules HR, Benefits, Time and Labor.
• Handled security related issues for certain roles and also gave department level security through Tree Manager.
• Worked on various queries to provide information for TPIA requests.

Environment : PeopleSoft HRMS/ELM/CRM 9.1 and People Tools 8.52 (App Designer, People Code, Application Engine, Component Interfaces, App Packages, AWE, XMLP), SQR, MS SQL Server

PEOPLESOFT HCM CONSULTANT

Confidential, New York, NY

Responsibilities:

• Configured NA Payroll and Compensation for Business Traveler employees as per the client requirements. Customized Reporting tools like SQR to include EDS employees in HP PeopleSoftsystem.
• Developed Test Plans, Test Scripts and Test Cases for QA and UAT testing of PSFT 9.2 Payroll and Compensation functionality and help troubleshoot root cause issues.
• Configured the setup tables for e-Performance, e-Compensation, TAM, Candidate Gateway, ELM, Talent Management modules, manage Profiles. Configured Manager Dashboard and Organization structure.
• Worked on several inbound and outbound interfaces using Application Engine, Component interface, File layout and Integration Broker.
• Worked on modules include Talent Management and ELM, e-Performance, e-Development, e-Compensation, ESS and MSS.
• Developed Various Interfaces/Batch process through App Engine, SQR programs and several online customizations through People code and Cis.
• Modified/ Customized Records, Pages, Components and Menus for the Human Resources Department using the various People Tools.
• Used People Tools for creation and modification of Process Definitions, Records, Pages, components to run Custom SQR's and Application Engine.
• Developed SQR programs for one-time conversion of Vendor and Customer's Data from legacy system to PeopleSoft.
• Involved in building Workflow Maps, defining Worklist records, adding Events and Routings, Worklist and Email notifications by giving necessary attributes and field mapping.
• Created various Reports using PeopleSoft Reporting Tools, SQR, Crystal Reports, XML publisher, PS Query. Developed and tuned SQL queries.
• Developed the PS Queries for Payroll and Configuring the Earn Codes for the Payroll, working on Vacation payout and On Cycle and OFF Cycle Payroll.
• Gathered the requirements from users for reports, interfaces, conversions and implementation of different modules. Created Functional and Technical Design Documents (FDD & TDD).
• Involved in development and customization of interfaces and reports using Application Designer, Integration Tools, and Reporting Tools like Workday Report Writer, PS Query, and SQR's.

PeopleSoft Consultant

Confidential, Jersey City, NJ

Responsibilities:

• Implement the setup of Benefits Administration (Benefit Programs, Benefit Plans, Eligibility Rules and Event Rules)
• Establish and administering benefit plans for FMLA, COBRA, health and life insurance, savings (including 401(k) and 403(b) plans).
• Worked on Open Enrollment which produces a file with all employees Open Enrollment options, current elections, current beneficiary details and employee & Dependent demographic data.
• Worked on job component PeopleCode for recurring deduction elements.
• Created Rule and Non Rule Packages with the criteria provided by the functional people and used to migrate from Functional Configuration Dev environment to UAT environments using data mover.
• Worked on Data Mover to migrate setup, import setup data from DEV to UAT for regression testing.
• Co-ordinate with Functional team and Technical team in upgrade for resolving issues.
• Finding the date objects in custom Peoplecode and SQL Execs to include date wrappers as part of PeopleTools upgrade.
• Worked on PeopleTools upgrade from where cleaning the SYSAUDIT and DDDAUDIT.
• Worked on performance issues in queries either by tweaking the queries or by requesting database admins for Analyzing rdms stats for 100%.
• Using Application Engine and Component Interfaces data is loaded in to PeopleSoft tables from staging tables,
• Worked on tweaking SQR for HCMI status report which is a detailed report used by users to see error report from interfaces and types of error captured in Description field, status report also includes success rows report.
• Worked on Production support issues from Global Payroll.

Environment: PeopleSoft HCM 8.9/9.1(HR, Benefits, Payroll), People Tools 8.48/8.53, PeopleCode, Application Engine, Component Interface, Data Mover, Oracle 11g, SQR, STAT.