Peoplesoft Techno Functional Consultant with over 14+ years of experience as consultant in Implementation, Upgrade, Data Conversion, Security, Report Writing, Data Conversion, Production Support and Maintenance projects that includes Design, Development, Testing, Upgrade, Support and Maintenance of PeopleSoft Applications in HCM/FSCM.

Key Skills: Peoplesoft HRMS/FSCM, Core HR, NA Payroll, Benefits, ESS/MSS, Peoplesoft security, developing custom/bolt-on applications, Peopletools, Problem-solving, Teamwork.

Summary

Strong PeopleSoft experience in Core HR, Base Benefits, Payroll, Benefits, Performance Management, ESS-Employee Self-Service, MSS-Manager Self-Service, Fluid Tiles, Navigation Collections.

Strong expertise in customizations and developing custom bolt-on applications.

Highly Proficient in PeopleTools –Application Designer, Application Engine, Component Interface, Data Mover, PeopleCode, Application Packages, PS Integration Broker, PS Security, Excel to CI, SQR and various other developer tools.

Experience in integrations between PeopleSoft and other applications to send and receive demographic information, payroll/benefits data, and other third-party systems using SFTP and Integration Broker /Application messaging.

Experience in integrating and supporting NA payroll with Kronos.

Experience in integrations between Peoplesoft and Active Directory system for creating and maintaining user profiles.

Experience in setup of LDAP authentication for Peoplesoft user profiles.

Significant experience in conversions between PeopleSoft and legacy systems. Involved in converting employee data, payroll balances (earnings, accumulators, deductions, taxes, and YTD), benefits, tax data.

Worked closely with external vendors on the implementation & upgrade projects.

Proficient in upgrade deployment like PUM, Tax Updates, Patches and Tools Upgrade.

Proficient in developing, enhancing, and retrofitting various PS objects, inbound and out

Self-motivated fast learner, diligent, hardworking, and active team player with high analytical and problem-solving skills and effective communication. Skilled in proactive identification and resolution of critical issues.

Demonstrated proficiency in leading and mentoring individuals to maximize productivity and forming cohesive team environment.

Career Graph

Working as Peoplesoft Consultant at McLaren Healthcare (Grand Blanc, MI) from Aug 2018 to till date.

Worked as Peoplesoft Consultant at Comptroller of Public Accounts (Austin, TX) from Apr 2018 – Aug 2018 to till date.

Worked as Peoplesoft Integration Consultant at State of Ohio from Jan 2018 to April 2018.

Worked as Peoplesoft Consultant at Lucile Packard Children’s Hospital (Palo Alto, CA) from Sep 2017 – Dec 2017 to till date.

Worked as ITS Systems Coordinator at Meijer (Grand Rapids, MI) from Sep 2012 to Aug 2017.

Worked as Peoplesoft Technology Lead at Infosys Technologies from Sep 2006 to Aug 2012.

Education

Bachelor of Technology (B-Tech) from Kakatiya University, Warangal, Telangana, India

Professional Experience

McLaren Healthcare

Aug 2018 to till date.

Role: Peoplesoft Consultant

Responsibilities Include:

The project involves implementing/support of Peoplesoft 9.2 on Oracle cloud and conversion of HR/Payroll/Benefits data from legacy system.

Interact with Business users and capture business requirements and prepare High level design and detailed designed documents.

Engage in all phases of the software development lifecycle. Participate in design meetings and consult with clients to refine, test and debug programs to meet business needs.

Creating data mapping between UltiPro and Peoplesoft, create/modify data conversion programs using component interfaces to load the data into HR/Payroll and Benefits tables.

Created multiple employee demographic interfaces between PeopleSoft and other third-party systems and worked developing both inbound/outbound interfaces.

Created interface to extract data from benefits and map to third party data requirements for FMLA/Disability benefits.

W2/1095C Year End setup, testing and documentation for Payroll/Benefit users.

Create queries to extract W2 box summaries for each company/employee.

Create queries for year end balances for Earnings, deductions, and balances.

Implement ADP employment tax/W2 interfaces in Peoplesoft.

Customized several delivered programs as per business needs.

Configure year-end W2 setup for Payroll Admins and employees through ESS.

Created interfaces to send biweekly payroll deduction information for savings/retirement systems.

Created interfaces to load gift/cafeteria deductions to payroll.

Created custom programs to send and receive data from Kronos system.

Developed multiple interfaces to extract data from JOB, Personal Data, Benefits, Payroll and Security.

Worked on integrating JOB/PERSON information from HR to FIN.

Worked on bringing in new companies to the existing HR system which involves data conversion, configuring data for new companies, security, and user profiles creation.

Worked on creating custom CI for absence management to load calendars and adjust PTO balance for the employees.

Created approximately 18000 user profiles for Go-Live of Peoplesoft HR system.

Created custom HR/Benefits/Payroll/Compensation/ESS/MSS/Performance Management roles and permission lists and assigned to the user profiles.

Created custom row security permission lists as per the business needs.

Designed and coded integration between Peoplesoft and active directory system for new hire user profile creation.

Configured and implemented multiple active directory systems for user authentication.

Support Bi-Weekly payroll process and resolve technical issues during Payroll Process.

Created complex SQL queries to validate and provide required payroll information to Payroll processors.

Resolved multiple issues during Payroll on/off cycle to make sure payroll cycle is completed on-time and support post payroll process.

Provide list of employees with no direct deposit accounts to Payroll team during payroll process.

Customized direct deposit page to send email notifications to employees when direct deposit changes are made.

Created custom program to update earnings to default combo codes after on/off cycle process.

Load combo codes from FIN to HR on a weekly basis.

Created and implemented audit records for various tables in HR/Payroll/Benefits and Security.

Modified quarterly payroll reports to generate files for each company.

Worked on applying tax updates and retrofit changes, test and implement the changes.

Worked on PUM image updates, inform team about new features available, test and implement the changes as needed by the business.

Provide audit reports to the business users when required and during every payroll.

Modified paycheck process to show PTO balance from custom view.

Resolved issues with paychecks that are created with special characters and causing issues in ESS view.

Resolved issues with pay-calc process caused by employees not having pay sheets created.

Resolved issues with earning codes that has hours greater than 9999 and causing issues when inserting the data into earning balance table.

Created queries to provide data and stats at each stage of payroll cycle.

Resolved issues when creating pay sheets for on-cycle and have an off -cycle that is not closed properly.

Created custom tiles for Open enrollment and support Open enrollment, setup document upload process for OE life event process and customize based on custom roles.

Comptroller of Public Accounts

Apr 2018 to Aug 2018

Role: Peoplesoft Consultant

Responsibilities Include:

The project involves deploying CPA’s HR/Payroll system to various agencies every year and converting data from legacy system to PeopleSoft.

Understand the business processes of each agency and map to CPA HR/Payroll system.

Document the gaps during the fit-gap analysis and prepare FDD for customizations if needed.

Conduct CRP sessions to walkthrough agency users and explain the CPA HR system configurations and setup.

Coordinate with agency users to capture security details like Roles.

Conduct Mock cutover and several Dress Rehearsal exercises to identify any data issues or process related issues and fix them before Go-live.

Setup and configure data in PeopleSoft.

Created scripts for loading additional conversion data to load into PeopleSoft using SQL scripts/Excel to CI.

Created several validation SQLs for the team to validate data pre/post conversion.

Actively involved in conversion team to define the processes and strategies.

Modify UAT scripts as per the changes to the PeopleSoft portal and core systems.

Capture any issues identified during UAT and fix them by coordinating with Functional/Tech and Security teams.

State of Ohio

Jan 2018 to Apr 2018

Role: Peoplesoft Integration Consultant

Responsibilities Include:

The project involves Integration from PeopleSoft FSCM to custom Grants management system that includes several real-time integrations and multiple file-based integrations.

Created multiple real-time integrations between Peoplesoft and Grants management system via Oracle SOA.

Created multiple File based integrations between Peoplesoft and Grants management system via Oracle SOA.

Created multiple inbound integrations between Peoplesoft and Grants management system via Oracle SOA and loaded data into PeopleSoft using web service/CI combination.

Played a key role in identifying/resolving the issues between PeopleSoft and SOA.

Guided the technical team in building the integrations and implementing the error handling process.

Responsible for independently testing new interfaces and system changes and working with developers in designing changes.

Resolved complex issues during integration in/out of PeopleSoft.

Created detail business solution document as per State standards.

Created complex SQL queries to provide data for integrations and to provide sample data for unit testing.

Lucile Packard Children’s Hospital

Sep 2017 to Dec 2017

Role: Peoplesoft Consultant

Responsibilities Include:

The project involves PeopleSoft HCM/FSCM Maintenance, Support and enhancements of Core HR, Benefits, Payroll, Recruiting, Purchasing, Billing/AR and other custom modules.

Worked on customizations and enhancements in HCM/FSCM modules.

Production Support to HCM/FSCM modules.

Monitor various interfaces, both inbound/outbound from HCM/FSCM and fix in case of any issues.

Troubleshoot support issues to determine source of issue and the best approach for a resolution. Write SQL queries to research intermittent issues.

Created technical specification documents for various customizations and interfaces.

Modified IB error notification process to exclude given service operations from sending email notifications.

Worked on Fluid pages for custom Manager Self service module.

Developed outbound integrations and used SFTP and PGP encryption.

Meijer

Sep 2012 to Mar 2018

Role: ITS Systems Coordinator

Responsibilities Include:

The project involves PeopleSoft HCM implementation, Maintenance, Support and enhancements of Core HR, Benefits, NA Payroll, mPerformance and custom modules in Peoplesoft.

Played a major role in creating custom module in PeopleSoft to capture hourly employee’s attendance incidents from time management system.

Gathered the business requirements and created functional documents for time and attendance and mPerformance(Bolt-on) system in PeopleSoft.

Created data mapping documents for integration of PeopleSoft with various time management systems to capture the attendance incidents.

Worked with Business users on gathering requirements, design, develop and deploy to production.

Created functional design specification documents and coordinating & conducting system integration, conversion, and user acceptance testing.

Estimate, plan, assign, assist and track development specific to business requirements.

Actively involved in providing data mapping between PeopleSoft and systems like Cornerstone for performance management and training, Achievers for employee recognition and Power BI for reports on employee data.

Assisted system users with daily requests along with the incident tickets created in Remedy tool (help desk software).

Created incident reports using BI publisher and sent these reports to FileNet using Integration Broker.

Created multiple integrations between PeopleSoft and third-party systems using IB/SFTP.

Involved in Production Support and successfully resolved various issues related to payroll and HR by interacting with Users and the Business team.

Worked on enhancing ESS, mPerformance & mPerks

Production support for more than 100 interfaces in/out of PeopleSoft.

Created and maintained custom Application Engine to send anniversary/birthday greetings to all employees.

Created integration between PeopleSoft and mPerks which validate employee phone number for discount at Meijer stores.

Performed a lead role in Design, Implementation & Testing the custom Employee Self Service module.

Worked on AWE in custom module for hiring employees into Peoplesoft.

Responsible for writing Test plan and Test Scripts for implementation HRMS modules

Troubleshoot self-services MyInfo issues to determine source of issue and the best approach for a resolution.

Sending Monthly and Quarterly tax reports to all the states.

Developed number of SQR Reports, PS Queries and other application customizations for fixing issues and new enhancements.

Worked on Integration Broker and Application Class PeopleCode, for automating the Enrollment/Maintenance process for re-hires and new hires.

Security related issues for the stores and performance issues.

Troubleshoot payroll processing issues to determine source of issue and the best approach for a resolution. Write SQL queries to research intermittent issues.

Scheduled the security processes to run on a nightly basis by using the “Job Definition” and “Schedule a Job Set” feature of PeopleSoft.

Developed custom SQR programs and modifications according to Meijer specific business requirements using Application Designer, Component Interface, PeopleCode, SQL, SQR, ExcelToCI, etc.

Data analysis in PeopleSoft HRMS and developing reports using PS Query.

Analyzing the custom functionalities in PeopleSoft.

Worked on Integration Broker created REST services for the integration of phone numbers in mPerks and team member appreciation cards using Application Class PeopleCode

Creating complex SQL to retrieve the data from different time systems.

Assign tasks to the offshore team and system test the offshore deliverables on Integrations.

Participate in weekly and monthly status reporting and governance meetings with the customer.

Involved in Production Support and join tech line calls to help resolve issues.

Open Service Requests with Oracle and assist the development team to solve existing issues

Arranged review meetings and discussed issues with developers and other team members and Implemented Software Development Life Cycle (SDLC) using Agile (scrum).

Infosys Technologies

Sep 2006 to Aug 2012

Role: Technology Lead

Responsibilities Include:

Worked on various projects for PeopleSoft HRMS and Financials modules that includes Upgrade, Implementation, Production support, Developing custom bolt-on applications and Maintenance projects.

Participating in project estimations, project plans, project plans review, discussion with users and providing inputs for enhancements.

Coordinating with users, onsite and offshore teams and scheduling the knowledge transfer sessions.

Helped users to test the system thoroughly and timely fixed the bugs before implementing the system.

Worked on Application Engine, Component Interfaces, SQR and JCL.

Performance tuning of different processes which helped to speed up the production activities.

Converting all the record level audits to Database level triggers.

Extensively worked and given support to Payroll, ESS, MSS, HR users.

Created the Fields, Records, Pages, Components and Menus for customization as per the requirement.

Created new Permission list and Roles for the specific business rules.

Developed programs using File Layout, Application Engine and People Code extensively for the Import and Export of flat files and XML files.

Acted as key contact for any Production issue during Production support.

Worked on Application Engine, Peoplecode and Component Interfaces, Inbound/Outbound Interfaces, SQR and queries.

Deploying Tax updates, Bundles and other Oracle delivered mandatory patches.

Customizing PS Security and providing required access to the people by assigning proper roles.

Created incident reports using BI publisher and sent these reports to FileNet using Integration Broker.

Created multiple integrations between PeopleSoft and third-party systems using IB/SFTP.

Involved in Production Support and successfully resolved various issues related to payroll and HR by interacting with Users and the Business team.

Worked on enhancing ESS, mPerformance & mPerks

Production support for more than 100 interfaces in/out of PeopleSoft.

Performed a lead role in Design, Implementation & Testing the custom Employee Self Service module.

Played a major role in creating custom module in PeopleSoft to capture hourly employee’s attendance incidents from time management system.

Gathered the business requirements and created functional documents for time and attendance and mPerformance(Bolt-on) system in PeopleSoft.

Contact this candidate