SUMMARY

• PeopleSoft Expert with 12+ years of experience in PeopleSoft HRMS and CRM Implementation, Conversion, Development, Upgrade, Production Support and Maintenance projects which includes Design, Development, Testing, Upgrade, Production Support and Maintenance of PeopleSoft Applications.
• 12+ years of experience in PeopleSoft HCM and CRM Implementation, Upgrade, Support and Maintenance
• Proficient in People Code, Application Engine, Component Interface, Application Packages, File Layouts, Integration Broker, Approval Workflow (AWE), PS Query and BI Publisher.
• Work closely with internal teams, partners, and customers to identify and define data conversion requirements.
• Extensive use of salesforce inspector, salesforce Data loader and SOQL Queries.
• Involved in creating custom Fluid Pages and stylesheet
• Worked with reporting and analyzing tools like PS Query, XMLP, BI Publisher
• Proficient in development and customization of complex pages using Application Designer
• Experienced in multiple upgrades, support and implementation projects involving PeopleSoft 8.9, 9.0, 9.1 and 9.2 and PeopleTools, 8.53, 8.54, 8.56 and 8.58 from initial requirements to go live and post production support.
• Co - ordinate development and testing efforts between technical team and functional user groups.
• Worked to implement Security, Creating Roles and Permission Lists and User Profiles
• Worked on end to end implementation of multiple new modules
• Experienced in requirement analysis, fit/gap analysis, creating functional and technical specifications, test scripts, UAT and end user training.
• Created project related documents to be used in production support.
• Responsible in interviewing technical talent for the company
• Co-ordination and review of work of offshore team. Assigning tasks and knowledge transfer of products functionality to offshore team.
• Good Analytical, problem solving and excellent communication skills
• Good Team player, establishing, and maintaining high quality support, high availability, responsiveness to applications user needs and implement best practices.
• Adept in Agile methodology using JIRA in projects

TECHNICAL SKILLS

ERP Packages: PeopleSoft HRMS 8.9, 9.1, 9.2

PeopleTools: Application Designer, Application Engine, Process Scheduler, Data Mover, Excel to CI, IB, PeopleSoft Security, Component Interface, Configuration Manager, PeopleCode, Phire, STAT

PT Versions: Tools version - 8.49/8.51/8.53/8.54/8.56/8.58

Reporting Tools: SQR, PS Query, XML Publisher

Database: Oracle 11g

Other Cloud Knowledge: Workday, Salesforce and Oracle Cloud

PROFESSIONAL EXPERIENCE

Confidential - California

PeopleSoft Lead Consultant

Responsibilities:

• Conduct workshops with internal teams to identify and define data conversion requirements and performed data mapping.
• Involved in Conversion of Peoplesoft CRM to Salesforce
• Converted existing custom pages in Fluid pages and custom tiles for Fluid and non-fluid pages.
• Conduct workshops for Business requirement discussions to understand and achieve client needs.
• Developed New functionality to change Annual Contributions for High Deductible Health Care Plans.
• Developed new BI Publisher reports to process leave Approvals/Denial Notification and trigger emails to employee and supervisors.
• Performed performance tuning on SQL’s to reduce processing timings.
• Managing Fluid Homepages, Tiles, Tile Wizard, Fluid Dashboards and modified Fluid Pages based on client requirement.
• Developed New Custom Application Engine to process T&L Data which involves Component Interface.
• Developed multiple SQR process and Reports according to client needs.
• Created queries using PS-Query tool for creating Reports and for other data validation.
• Involved in People tools Upgrades and Tax Updates throughout my tenure.
• Involved in General Deduction conversions to switch employee’s deductions to new companies which helped smooth Payroll Processing.
• Communicate the Conversion issues to Client wherever Client Action is required.
• Developed new functionality to facilitate Transfer Approval process using AWE.
• Created detailed test scripts for Unit and System Testing after data conversion for validation.
• Created multiple programs to regularly archive transactional and legacy data.
• Setting up Job, Company, Benefits and Compensation data for Winthrop employees.
• Support NA Payroll and created Overpayment Tracker which tracks pay checks for overpayment and notifies payroll team for recovery and processing.
• Setting up Health Savings Account functionality in the eBenefits, dependents and different benefit plans in Base Benefits and other life events.

Confidential, Richardson,Texas

Sr PeopleSoft Technical Consultant

Responsibilities:

• Developed SQR programs to generate conversion files from Peoplesoft to Workday.
• Designed and developed integrations. Created test cases and assisted customer in testing.
• Built Custom Reports in various functional areas of Workday.
• Worked on HCMreporting - Report Writer, creating Workday Calculated fields, Custom and Advanced reports.
• Created Advanced Reports using Calculated Fields, Sorting, Filtering Report Fields, providing Advanced Filtering Option and Creating Sub Filters and by using related Business Objects.
• Resolved issues concerning integrations influencing clients. Created a custom multi file interface SQR to collect Payroll data for Retirees to be sent to vendor.
• Experience in creating and modifying of XML BI Publisher Reports along with RTF templates creation.
• Worked in the Production support team to resolve all production issues and have frequent interactions with End-users.

Confidential, California

PeopleSoft Techno/Functional Consultant

Responsibilities:

• Responsible for working as a developer as part of PeopleSoft HR & Payroll system and maintaining the load process for the core HR data for modules like Core HR, Time and Labor/Absence Management, eBenefits, eRrecuitemnt).
• Involved in conversion of Peoplesoft recruitment to Taleo by developing interfaces for data conversion.
• Responsible for design and development for HR conversion setup mapping that included Job creation, Job codes, Action, Action Reasons etc.
• Conduct workshops for Business requirement discussions to understand and achieve client needs.
• Prepare the Tracking documents to track the timelines for Implementation.
• Involved in implementation of High Deductible Health Plan based on business requirement.
• Involved in modification of Open Enrollment pages like Online Demand Open Enrollment.
• Preparation of Unit Test Cases and Test Plan along with customer support.
• Involved in analyzing the impact of 9.2 Upgrade with current system.
• Participated in several business analysis meetings to gather requirements from administrators about different plan types, benefit plans, benefit programs and plan rules, earning codes, deduction codes,
• Pay Groups and compensation rules to in corporate into the system
• Developed Critical Application like Portal Balloting Modules which allow Confidential Doctors to elect their Leaders through balloting.
• Worked with clients to trigger scripts, monitor and fix the issues during Taleo Implementation
• Responsible for creating the conversion programs for loading the HR and Non-Core data from Legacy to PeopleSoft based on the mapping between two systems.
• Responsible for creating multiple SQR and App Engines error reports as part of these conversions to identify missing or conflicting data.
• Created custom exceptions for hours over or below scheduled hours, meal break, and overtime in Time and Labor.
• Worked on Leave Balance Conversions, custom Absence Upload Interface, Time and Labor conversions and some critical Reports.
• Responsible for building the add-on customizations around the new ESS and MSS transactions.
• Was heavily involved with the creation and approval of Functional & Technical Design Documents
• Creating and loading of setup tables for different modules based on the conversion data.
• Worked on modifying existing and creating new SQRs to retrofit the custom requirements
• Carrying out the customization on pages, records and components acc. to requirement.
• Performed extensive debugging and performance tuning of various processes and troubleshooting issues on Peoplecode, Application Engine, SQR’s & Online.
• Created scripts for large volumes of history/new data uploads using Data Mover and Excel to CI for implementing new modules.
• Involved in retrofitting and analyze current customizations in v9.0 and remove these in v9.1 so that delivered functionality is used as much as possible

Confidential

PeopleSoft Technical Developer

Responsibilities:

• Worked as a technical consultant on PeopleSoft upgrade Project 8.5 to 8.9 for HCM (Core HR, NA Payroll, Benefits, Time and Labor, ESS and MSS)
• Worked on fit-gap analysis, compare reports and developed functional and technical specs for customizations for the HCM and upgrade
• Applied customizations to number of complex Records, Pages, Components, People Code, SQR reports and Permission Lists based on analysis from Compare Report like Job Data component related pages, records.
• Created multiple App Engine programs to archive existing data.
• Worked on modifying existing and creating new SQRs to retrofit the custom requirements in 9.1
• Developed and executed required scripts using SQL, Excel and Data Mover to move data between databases.
• Provided technical assistance to the testing efforts, worked on issues and provided resolutions.
• Developed Data mapping, Data conversion programs using SQRs, application engine programs and call component interfaces and Data loading from the external system into PeopleSoft tables
• Production support and maintenance of PeopleSoft HCM 9.1 for modules like NA Payroll, Core HR, Time and Labor
• Worked on Benefits modules including BenAdmin, eBenefits, Cobra benefits
• For Mercer Implementation created a new interface SQR to send Payroll data acquired from different tables from the bi-weekly payroll tables to help employees with financial services
• Created reports and letters using PSQuery and XMPL/BI Publisher with RTF templates for eRecruit like Job offer letter, Interview Letter and Automated responses.
• Creating Text/Message Catalogues to be used in Email Functionality and HTML areas
• Developed Interface program using Application Engine, and Component Interface, which loads data from excel file into staging tables while doing various data validations using AE Peoplecode and finally loads into PeopleSoft tables through Component Interface
• Effectively used STAT to migrate objects into different environments.