We provide IT Staff Augmentation Services!

Peoplesoft Senior Consultant, Resume

2.00/5 (Submit Your Rating)

NJ

SUMMARY

  • More than 11 years of IT experience in Design, Development, Implementation, Upgrade, Security, Testing and Production Support of Applications in PeopleSoft HCM/EPM/ELM/FSCM Applications. Good Domain Knowledge in HCM and NA Payroll.
  • Excellent technical experience includes working on People tools objects like Application Designer, Application Engine, AWE, Component Interface, File layouts, People code, Process Scheduler, PeopleSoft Query, Data Mover and PeopleSoft security including row - level security and setup of User Profiles and Roles.
  • Excellent cognizance in integration tools like Integration Broker in People Tools 8.47, 8.49, 8.51, 8.52, 8.53 Experience in creation of functional and technical documentation for analysis and design, testing.
  • Strong knowledge in Oracle 10g database and also possess zeal to learn new concepts and technologies.
  • Developed data conversion programs using SQR/Application Engines.
  • Techno-Functional PeopleSoft HCM Analyst/Developer with 10 years of experience in PeopleSoft HCM, PeopleSoft CRM and PeopleSoft Portal technologies.
  • Experience on upgrading the PeopleSoft HCM from version 8.8 to 9.2 and upgrading the People Tools version 8.49 to 8.53.
  • Onsite Coordinator since 2016 possessing leadership excellence and proficient communication skills between the business and the offshore team.
  • Well versed in PeopleSoft versions 9.2 and 8.8, People Tools versions 8.53 and 8.49.
  • Demonstrated great technical, functional, programming and analytical skills in PeopleSoft Development and Functional domains.
  • Possesses knowledge regarding the business functionality in the Retail industry across various domains

TECHNICAL SKILLS

  • PeopleSoft Architecture: Experience in PeopleSoft Architecture with an understanding of PIA and its components.
  • Portal Technology Have worked extensively developing skills to understand and implement the portal framework and the technology.
  • People Tools Vast experience in all aspects of People Tools across versions 8.48 to 8.53.
  • Business processes and Reporting Tools Have worked in great lengths related to creating processes and reports using SQRs PS Queries and Application Engines.
  • Administration and Security In Depth understanding of PeopleSoft Security with Core Level and Row Level Security with understanding in Permission Lists, Roles and Data Security.
  • PeopleSoft Application Packages and classes Understanding of the Application packages and its role in PeopleSoft version 9.2.
  • PeopleSoft Fluid Technology Knowledge on PeopleTools version with 8.55 features.
  • Integration Broker Experience with Integration Broker integrating PeopleSoft with third party systems such as Taleo and internal integrations with CRM.
  • Development Tools Worked extensively on Development tools such as Application Designer, Application Engine, SQRs and People Code and Component Interfaces.
  • Query and Tree Manager Experience with PS Queries and understanding of Tree Concepts.

PROFESSIONAL EXPERIENCE

PeopleSoft Senior Consultant,

Confidential, NJ

Responsibilities:

  • Supporting PeopleSoft EPM/HCM and FSCM applications, on fixing the production issues, enhancements and customizations.
  • Converted General ledger, Accounts payable crystal reports into PeopleSoft BI publisher as part of windows upgrade.
  • Involved in data conversions between PeopleSoft HCM system and Workday HCM.
  • Developed SQRs and Application engine programs which is needed for reporting the data in user dashboards.
  • Understand the business requirements for the proposed projects, identify the pain-points, analyze and design the solutions to effectively manage the project as per Rabo bank specific standards and guidelines. Achieving the stability in the project by effective planning, scheduling and execution of activities.
  • Ensure the proper process documentation throughout the project life cycle and all the production implementations meets the CMMI standards. Schedule and attend the meetings with QA Manager periodically, to help maintain the quality standards throughout
  • Created, categorized and tested DMS Scripts for many tables as part of data conversion.
  • Assistance in preparing design documents, Functional and Technical for upgrade related changes/enhancements.
  • Reviewing and creating of various Technical design documents.

Environment: PeopleSoft EPM/FSCM/HCM

PeopleSoft HCM Consultant,

Confidential, MN

Responsibilities:

  • Techno Functional Consultant at work site as a NA Payroll and Benefits and a Workforce Administration expert including resolving high priority issues with effective results and helping the business users in carrying out the day to day activities.
  • Developed Application Engine and SQR programs in HR, Benefits, Pension and Payroll modules for various external agencies for health, dental and savings bond deductions. Coordinated with interface vendors in conducting user testing, fixing the issues addressed by them from time to time.
  • Loaded Pension Plan information from Spread Sheet to PS Tables.
  • Setup Pension Plans, Employee deductions for Pension contribution, retiree administer control tables, calculation rules for Pension Plans.
  • Developed Interface as part of data conversion between Taleo system to PeopleSoft HCM system. Hiring feed should come from Taleo system as a flat file and the interface ALB UNI PS reads the flat file and loads into custom staging record.
  • Participated with verifying correct data was being sent on the data conversion Payroll interface file to be mapped to Kronos data fields.
  • Handled data flow between Taleo and PeopleSoft HCM data flow.
  • Understand the business requirements for the proposed projects, identify the pain-points, analyze and design the solutions to effectively manage the project as per Confidential’s specific standards and guidelines. Achieving the stability in the project by effective planning, scheduling and execution of activities.
  • Configuring and help business maintain Payroll Setup and Data.
  • Implemented Oracle HCM compensation module in Oracle Fusion Cloud. Extensively worked on FT EXTRACT process and modified the programs as per the business functionality.
  • Ensure the proper process documentation throughout the project life cycle and all the production implementations meets the CMMI standards. Schedule and attend the meetings with QA Manager periodically, to help maintain the quality standards throughout.
  • Role of a Functional consultant for NA Payroll and Workforce Administration modules providing assistance in Fit-Gap Analysis.
  • Assistance in preparing design documents, Functional and Technical for upgrade related changes/enhancements.
  • Co-ordinate with the Offshore developers in testing and documenting all the code changes, which includes Unit testing using the CA Sand Box, component integration testing, system integration testing, and performance testing using the CA MAT Tuner tool, capacity testing, quality reviews and implementing them successfully.
  • Reviewing and creating of various Technical design documents.

Environment: PeopleSoft HCM 9.2, People Tools 8.53,8.54,8.55, Oracle Database.

PeopleSoft HCM Consultant,

Confidential,

Responsibilities:

  • Understand and Analyze the enhancement requirement and to provide the statement of work.
  • Developed SQR programs which will generate Retirees with Benefits reports for the employees who had retired from the Kerns High School.
  • Developed bus reservation system EBS transaction setup which will be useful for the kerns students who are going to book the bus services online.
  • Developed AWE flow for EBS reservation system for approvals.
  • Created SQR’s to load the converted data and validate Payroll and Benefits.
  • Worked on Life-Scan component which will be used to record and maintain all LiveScan requests information and results.
  • Developing/Coding the new design into a working functionality thereby resolving & handling all conflicts with other features and functionalities.
  • Thorough understanding of the business process flow with the Human resources department regarding the Administration of workforce such as Employee hire, tax setup, direct deposits, termination and other areas.
  • Preparations of specification documents
  • Unit Testing: Test plan preparation and capturing of test results
  • Preparation of delivery documents like configuration logs

Environment: PeopleSoft HCM 9.2, People Tools 8.53, Oracle Database.

PeopleSoft HRMS Consultant,

Confidential,

Responsibilities:

  • Developed SQR program which will show the structural and data differences between any selected source database like HCM 8.9 to target database HCM 9.1 and writes the differences in two files one file is for Structural and other file is for Data differences which will be very useful for data conversions.
  • Did Fit/Gap Analysis by reading the existing Pension System on Mainframe and analyzed the system with PeopleSoft, modified the Pension admin Reports like Data extracts participant letters, Pension payment reports
  • Created Run Control Records and Pages which will be the input parameters for the Conversion program.
  • Validated conversion data that would feed into the HR interfaces for the global clients.
  • Created test scripts for conversion data.
  • Retrofitting the PSQUERY queries for both Public and Private queries as part of PeopleSoft Upgrade.
  • Handling the Integration issues from HCM 9.1 to CRM 9.1 and validating the Asynchronous messages at both ends.
  • Retrofitted the Delivered Security Application Engine programs as per the HSBC functionality in HCM 9.1
  • Created, categorized and tested DMS Scripts for many tables.
  • Analyzed Compare reports and retrofitted objects of Application Designer (Fields, Records, Pages, Components, Menus, People Code, Activities, HTML etc), PS Queries, SQR’s, Application Engines from HR 8.9 to HR 9.1
  • Fixed defects on priority basis and took appreciations from End user for quick and feasible solutions.
  • Online customizations using People Code based on technical specifications
  • Used with Non Rowset messages
  • Developed a Customized dynamic code for Non Rowset Messages.

Environment: PeopleSoft HRMS 8.9/9.1, People Tools 8.49 and 8.51

PeopleSoft HCM

Confidential,

Responsibilities:

  • Developed Application Engine Program which will take the input file and process the particular associate into the Learning plan Enrollment and maintain the data into the PeopleSoft ELM tables.
  • Developed Setup Pages for Dovetail Learning Plan which is used to give the Template id and Associate id as an input file to the Customized Application Engine.
  • Initially it will delete the Customized records and data will be inserted into the staging records and later it will update the PeopleSoft ELM tables.
  • Created Customized Pages like Associate Transaction Page, Manager self-service page and Admin Page. After successful execution of Application Engine data will be populated into the above listed pages.
  • Extensively worked on File layouts to inbound and outbound of the data.
  • Developed SQR program which will write the data into the flat file from HCM system and update the data into PeopleSoft ELM staging records.
  • Migrating the objects to test environment using STAT.
  • Included the BU level securities for restricting the information from one User to the other user.
  • Implemented the User level restrictions to the PIA
  • Customized the Views for maintaining the Security

Environment: PeopleSoft ELM 8.9 and 9.0, PeopleTools 8.49 and 8.51

PeopleSoft HCM Consultant

Confidential

Responsibilities:

  • Involved in the preparation of technical specifications based on the fit gap analysis and Functional design documents
  • Developed a new run control page, which is having a drop down to which the user has to select the process like Extract/Load, Audit and Flat file. Based upon selection criteria that particular Section has to be executed and generate the log file and data will be inserted into the staging tables
  • Developed Application Engine program, which will fetch the data from PeopleSoft ERP tables and Campus Solutions tables into PeopleSoft Staging tables
  • Developed User-define functions, which the User has to change the Output Path Dynamically. Generally in SQR’s and Application Engines the output file will be saved in Specified location, using this function we can change the Output Path Dynamically from C to D drives.
  • Participated in initial fit-gap analysis for the acquisitions.
  • Held technical conversion meetings to discuss data transformation.
  • Successfully designed and developed Application Engine programs using File Interfaces with Fixed Format.
  • Developed and implemented the Customized Subscription People code.
  • Developed Application Engine Process for reading data from the csv files and posting to the respective tables.
  • Developed new SQRs to create PDF versions
  • Involved testing the developed Application and made documents.
  • Included the BU level securities for restricting the information from one User to the other user.
  • Implemented the User level restrictions to the PIA
  • Customized the Views for maintaining the Security

Environment: PeopleSoft HCM 9.0, CS 9.0 & PeopleTools 8.50

PeopleSoft HCM

Confidential,

Responsibilities:

  • Developed Component Interface and Application Engine Program to upload the employee Re-hire job information to the PeopleSoft system from the feed files.
  • Generated SQR reports to create Time Load to paysheets, master employee listing, employee pension plan data, new hires and terminations.
  • Exclusively working on Application Engine and Application Designer.
  • Involved in Designing of As-Is documents for the Business Process.
  • Developed People code validations based upon the requirement.
  • Used File Layouts to upload the data from External System.
  • Customized Run Control Page and People Code according to the User requirements.
  • Scheduled some of the SQR’s and AE Programs in Process Scheduler to automate Process and used Process Monitor to keep status of the reports.
  • Developed the SQR program which will generate the Projected Revenue of all the Projects which are in the organization.
  • Developed SQR program to generate the mismatch report of job data between HRMS job data and Finance job data.
  • Worked on SQR- Reports/Inbound /Outbound Interfaces.
  • Successfully designed and developed Application Engine programs using File Interfaces with Fixed Format.
  • Used People Code to control the program flow & business logic and for validations to meet the current Business Requirements.
  • Performed page validations and modified the pages in order to satisfy the Business Logic.

Environment: PeopleSoft HRMS 8.0 & 8.8, PeopleTools 8.12

We'd love your feedback!