We provide IT Staff Augmentation Services!

Hcm - Peoplesoft Technical Consultant Resume

Pleasanton, CA

PROFESSIONAL SUMMARY:

  • About 10+ years of experience in PeopleSoft HRMS v8.4/v8.50/v8.51/8.52/v8.53/v8.54 and PeopleSoft FSCM v8.45/v8.50/v8.52/v8.54.
  • Proficient in grasping the Functional and Technical aspects of various modules in PeopleSoft HRMS - Core HR, Administer Workforce, Benefits, NA Payroll, Recruiting, Time &Labor, Absence Management, Self Service modules and those in PeopleSoft FSCM include Accounts Payable, Billing, Products, Orders and Customers.
  • Experience includes HR, Finance, Health Care, Air force and Railways.
  • Experience in People Tools - Application Designer, Application Engine, Component Interface, File Layouts, Workflow and Fluid Interface.
  • Experience in Reporting Tools - SQR, PS Queries, Crystal Reports, XMLP, and Web Services based Integration Broker.
  • Experience in ExcelToCI, People Code, Process Scheduler.
  • Development and modification of Outbound and Inbound SQR interfaces and Application Engine programs.
  • Involved in Fit/Gap analysis of the HRMS processes in the PeopleSoft Version 8.54 and identified the customizations that needed to be carried forward.
  • Analyzing and writing complex database reports and customizing PeopleSoft Delivered SQR reports.
  • Analyzing and customizing PeopleSoft Delivered Application Engine programs.
  • Worked on multiple end-to-end implementation and Upgrade projects.
  • Involved in Unit Testing and System Integration Testing during Upgrade of PeopleSoft from 9.0 to 9.2
  • Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
  • Created Data Mover scripts to move the data from one instance to another.
  • Worked on identifying the root cause for the issues raised during both User Acceptance Testing as well as Production and successfully resolved the tickets within timelines.
  • Responsible for leading the team to follow the protocol in resolving the tickets in L1, L2 and L3 levels.
  • Accomplished in successfully customizing the modules based on business needs and developed projects for the same.
  • Proficient in data migration using Data Mover and Project migration using Application Designer.
  • Assist with PeopleSoft Security in the creation and maintenance of Users, Permission List and Roles.
  • Proficient in troubleshooting issues using a methodical and analytical approach in solving the issues and focused on end user satisfaction.

SKILL:

ERP Packages: PeopleSoft HCM 8.8/8.9/9.0/9.1/9.2 , PeopleSoft Financials 8.9/9.0/9.2

Databases: Oracle 9i/10g/11g

Operating Systems: Windows Server / 2008, Linux.

Tools: Application Designer, Application Engine, SQR, Crystal Reports, Data Mover, Component Interface, ExcelToCI, File Layout, XML Publisher, IB.

WORK HISTORY:

Confidential, Pleasanton, CA

HCM - PeopleSoft Technical consultant

Responsibilities:

  • Designed and Developed Audit Record Definitions, Pages, Sub Pages and Components based on Business requirements.
  • Modified and added people code to provide a method for the customer to alert Confidential that they do NOT approve the touched payroll. If the customer reviews their payroll and wants to reject/not approve the payroll, they should be given a systematic method to alert their service team that they do not approve the payroll.
  • Provide a hard stop when a processor selects a check date that is not in the same month/year as the On-cycle Pay Calendar selected. Do not allow a check date to be entered in the Check Date field of the Default Page for the cases - If the month in the check date does not match the Paycheck Issue Date month of the On-cycle Pay Calendar the user selected. If the year in the check date selected does not match the Paycheck Issue Date year of the On-cycle Calendar.
  • Retrofitted sqr’s to include the CPEO value to accommodate the company value PEO07.
  • Developed custom sqr that reads the input file and loads data into the Single Annual Wage Base (SAWB) records. Data is read from the input file processed into the staging records with the Employee, SSN and balance values and then loaded into the records.
  • Worked and provided solutions on the service now tickets that are raised by the Business.
  • Developed sqls to determine data from PeopleSoft and Passport tables for State, Tax and Federal components.
  • Worked on Atlassian tool JIRA to develop the sub tasks on the stories created by the Business.
  • Developed projects and deployed to multiple instances using CAPI tool.
  • Developed SQR audit report to generate multiple reports like State Unemployment report, Worker’s Compensation report and Service fee report.

Environment: PeopleSoft HCM 9.2, People Tools 8.54

Confidential, Miami, FL

HCM - PeopleSoft Technical consultant

Responsibilities:

  • Developed new custom process in Payroll module to update the Tax Data Component.
  • Generated browser Compare reports for TAX PUM update from 16A to 16E.
  • Developed custom View to give the resultant set for which the system checks the absence entry and give the details based on absence end date.
  • Designed and Developed Record Definitions, Pages, Sub Pages and Components based on Business requirements.
  • Developed, modified and debugged People Code and Application engine programs.
  • Analyzed the Component Processor Flow to determine where People Code programs can be placed more appropriately.
  • Used Application Engine, People Code and SQR extensively to create processes, outbound files and reports.
  • Developed outbound files to generate reports with different criteria from the Employee, Benefits modules using SQR.
  • Developed component interface to load bulk data into setup pages and Plan Admin components.
  • Customized the existing interface programs for the HR to send flat files to various vendors for employees enrolled in different medical and dental plans.
  • Developed SQR programs to create Time Load to pay sheets, Employee application submission data.
  • Involved in Data mapping for legacy data conversion.
  • Worked on retrofit of complex custom SQRs during upgrade.
  • Developed an application engine program using File Layouts to load New Hire interface file with all New Hired employees' information after each day and load them into the people soft tables.
  • Developed complex SQR program that creates multiple reports based on various parameters.
  • Worked on XML publisher to get the Interface data for client request.
  • Work involved development of interfaces with Component Interfaces and File Layouts to read inbound files and manipulating the PeopleSoft tables.
  • Tuned SQL/SQRs to improve performance using advance features like Load lookup and Arrays.
  • Customized ELM Reports like Learning History by Department, Mass Enrollment Status Report and Learning Transcript by Organization.
  • Work involved analysis of functional specification and preparing technical specifications based on the given functional specification.
  • Testing the end-user desired output and application functionality.
  • Involved in analyzing the tickets raised by users in Kaseya tool and resolve them.
  • Involved in enhancement of Timesheet to make a field available through Application package code.
  • To provide resolution to the tickets raised without changing the existing customization code.
  • Modified the Application Engine code to resolve a critical issue in Production raised by the Business.

Environment: PeopleSoft HCM 9.2, People Tools 8.54

Confidential, Houston, TX

PeopleSoft Techno-Functional Consultant

Responsibilities:

  • Involved in developing Fluid pages for few of the custom pages.
  • Involved in testing all the modules in the new instance after upgrade.
  • Analyze the issues raised by users through Service-now ticketing tool and provide them comprehensive solutions.
  • Worked on Change Request, System enhancements and new releases on a weekly basis.
  • Help team members on certain critical requirements and ensure to deliver SR in timely manner and met project’s SLA.
  • Worked on multiple Change Requests and fixed them without any issues.
  • Supported when there is upgrade in Tools from . Frequently monitored the Application system to avoid alignment issues.
  • Worked on customized Vendor Workflow for Confidential and fixed the change Request raised by User to restrict the Workflow for Insurance Certification types.
  • Created New SQL query to determine if the Workflow Revision is required or no as per the Change request from User.
  • Monitoring Process Monitor post upgrade to act upon in case there are any unsuccessful processes and maintain stability in the system.
  • Analyzed user requirements and developed plans for Change Request, New applications and Interface development using People Tools, People Code, SQR, XMLP.
  • Identified and documented all customizations and mapped them to functional specifications for the customizations.
  • Developed GL controls to lists the summary of Adjusted journal entries by account and period in a given period or range of periods for the revenue accounts and higher than the acceptable amount, Journal entries that have the creation date in a later accounting period compared to the GL period.

Environment: PeopleSoft HCM 9.0, People Tools 8.54

Confidential

Technology Lead

Responsibilities:

  • Involved in the knowledge transition from Client at Netherlands along with the team.
  • Trained the team to understand the processes (L0-L1, L2-L3) at NN.
  • Involved in handling the change requests following the change management at NN.
  • Involved in solving the incidents raised for PeopleSoft Financials.
  • Involved in creating new shell scripts to route notification emails to the new group email box.
  • Responsible for daily batch check to ensure if the PeopleSoft System is up without any issues.
  • Responsible to check on daily basis through putty if the PeopleSoft files have been transferred successfully to the target systems.
  • Responsible to perform chain testing as and when requested by the Functional Support to load Journal data into the PeopleSoft system.
  • Responsible to work on the incidents in Top Desk and resolve within the timelines.
  • Responsible to monitor the system that it is always stable.
  • Responsible for daily check in Informatica to ensure if all the files have been transferred successfully as per schedule.
  • Received appreciation from Client for resolving an issue which was pending from past 2years.

Environment: PeopleSoft FSCM 9.0 People Tools 8.52

Confidential, Raleigh, NC

Sr. Technology Analyst

Responsibilities:

  • Involved in Development, Testing and Enhancement of PeopleSoft HCM for HR, Payroll, and Base Benefits, Time & Labor, Absence Management and Self-Service modules.
  • Created and modified Components, Pages, Records, Fields and Process Definitions.
  • Involved in online modifications to the delivered pages, components, people code and translate values.
  • Developed an Application Engine Programs like Blue cross blue shield and Orbit Interfaces to generate outbound files with Confidential data.
  • Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
  • Conducted meetings with the Users and involved in discussing their issues and helped them out in finding the proper solutions for their requirements.
  • Active role in modifying the SQRs as per the change requests from the users.
  • Involved in Development, Testing, and Enhancement of PeopleSoft FSCM for AP, Payroll, General Ledger and Vouchers modules.
  • Worked on Customization of the ESS pages to make it client specific by making changes on the Application libraries.
  • Modified an Application Engine Program like Wachovia Positive Pay to generate outbound files specific to bank with Confidential data.
  • Developed BIP reports in FSCM92 instance to convert Crystal reports that were created in FSCM90 instance.
  • Modified online objects like pages, people code and fields to implement business rules for AP, GL and Payroll modules.

Environment: PeopleSoft HCM 9.2, FSCM 9.2 People Tools 8.54

Confidential, Indianapolis, IN

Sr. Technology Analyst

Responsibilities:

  • Involved in Development, Testing, and Enhancement of PeopleSoft HCM for HR, Payroll, Base Benefits, Self-Service and Recruiting modules.
  • Involved in online modifications to the delivered fields, pages, components, people code and SQRs.
  • Customized people code for the Job application pages in Careers.
  • Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
  • Modified delivered Resume sqr to bring in all the data of the applicant including the customizations of 9.2.
  • Active role in changing the SQRs as per the change requests from the users.
  • Modified the grid on the Job Application page to display the Disposition field with relevant data.
  • Successfully resolved the bugs that are raised as part of User Acceptance Testing.
  • Customized and modified Fields, Tables, pages, components, Menus and portal registry.
  • Modified Record Level People Code, page level People Code, component level People Code.
  • Upgrading all SQR's, SQC's and Query Reports modified based on new custom tables and fields.
  • Customized and developed SQR, nVision and Crystal for Payroll, Benefits, T&L and HR.
  • Identified all customized interfaces, reports and queries and prepared design documents to list the impact of the upgrade on these programs and identified parts of the program that needs to be altered.

Environment: PeopleSoft HCM 9.2, People Tools 8.53

Confidential, New York, NY

Technical Architect

Responsibilities:

  • Involved in Development, Testing, and Enhancement of PeopleSoft FSCM for Products, LOV, Orders, Customers and Contracts modules.
  • Worked on Integration Broker tool using Web Service based operations to load data into the tables with data from third-party system into the PeopleSoft system for the modules Products, Customers and Orders.
  • Involved in Client meetings to discuss on issues and customizations on the requirements.
  • Involved in Peer review for the customizations & development of the projects and maintained review reports to meet the coding standards as per the Client.
  • Mentored team members to make them understand the Business requirements and develop projects with minimal defects.
  • Received appreciation from Client and Peers for prompt solutions for the defects raised as part of UAT, Performance testing and Regression testing.
  • Maintenance of Code review documents and Checklists for subordinate projects.
  • Developed Component Interface for loading data into staging tables and then into PeopleSoft table successfully.
  • Developed Application Package code using arrays to load data into LOV tables and products using XML file as input source for data.
  • Received appreciation for solving defects that were raised as part of Performance testing and Regression testing.

Environment: PeopleSoft FSCM 9.0, People Tools 8.50

Confidential, Columbus, OH

Technical Architect

Responsibilities:

  • Involved in preparing High level design documents of the Sqrs that were designed and developed as per the Business. This documentation is useful for the users which guide them with full-fledge technical and functional details on the development.
  • Involved in preparing Visio diagrams on the flow of Sqrs.

Environment: PeopleSoft HCM 9.0, People Tools 8.48

Confidential, Jacksonville, FL

Technical Architect

Responsibilities:

  • Developed various online pages for Help Desk module using Application Designer and People Code.
  • Involved in converting all the custom SQRs of 8.9 version to Application Engine programs in 9.2 version using XMLP as Business requires it for parallel processing.
  • Modified the Oracle Logo in PeopleSoft Application with that of CSX Client. Customized such that the CSX Logo appears on all the pages and Time out warning.
  • Involved in preparing ExcelToCI spreadsheets with sample test data of all the custom components like Employee Self-Service, 360 Degree View and Case Management to Load Data.
  • Involved in modifying and retrofit the JCL’s to run for new 9.2 version.
  • Involved in modifying Shell Scripts which are created to run the Application Engine for 9.2 version.
  • Developed XMLP reports like CSX Provider Group Report, Case Management Report, CSX Connect Daily report and the generated output file is sent as email attachment for all the Users who ran the report.
  • Mentoring my sub-ordinates, conducted peer reviews and resolved many issues technically.
  • Participated in code review and responsible for working on changes specified by the business.
  • Working on tickets raised by the customer as a part of support.

Environment: PeopleSoft CRM 9.2, People Tools 8.53

Confidential, Mooresville, NC

Sr. Software Engineer

Responsibilities:

  • Involved in customization of multiple pages for Account Payables module using Application Designer and People Code.
  • Developed customization for two-way matching and three-way matching so that when a Vendor is marked as Two-way then the Flag in the Voucher page should be changed based on certain conditions.
  • Involved in modifying SQRs to make them applicable for both US and Canada and generate reports with Confidential ’s data.
  • Involved in modifying and retrofit JCL’s to roll out for both US and Canada.
  • Involved in creating DM Scripts from importing and exporting data from existing instance to target instance.
  • Developed project on the customization for Vendor, if the payment method is EFT (Electronic Fund Transfer) then the Payment instruction for the bank is mandatory.
  • Maintenance of ExcelToCI spreadsheets of all the custom objects to Load the Data.
  • Developed customization on Mass update for which Confidential ’s need to change unpaid vouchers due date/ pay priority for one or more Vendors to take better terms.
  • Assisted sub-ordinates, conducted peer reviews and maintained review reports. Participating in code review meetings with business team and responsible for working on changes specified by the business.
  • Working on the tickets raised by the customer as a part of support.

Environment: PeopleSoft FSCM 9.1, People Tools 8.52

Confidential

Software Engineer

Responsibilities:

  • Involved in creation of multiple setup and transactional pages for forms and applications using Application Designer and People Code.
  • Developed an Application Engine program which generated an outbound file that has details of the students who applied for examinations in different departments.
  • Developed custom approval process up to three levels using Workflow, Application Designer and people code.
  • Developed multiple PS queries for roles and data of all the students in different departments.
  • Developed custom pages to create unique User ID and password.
  • Developed a report which fetches the details of all the transactions and stages of approval process.

Environment: PeopleSoft CS 8.9, People Tools 8.50

Confidential, Chicago, IL

Software Engineer

Responsibilities:

  • Involved in the functional overview of the requirement specifications with clients to understand the implementations.
  • Developed many online objects like fields, records, pages, components using Application Designer.
  • Developed multiple transactional pages for all the Bill types like Delivery Bill, Milestone Advance, Progress Payment and Cost Voucher using Application designer and people code.
  • Developed Crystal Reports with PS query as the input source.
  • Developed various PS queries with different prompts and filter criteria.
  • Developed Application Engine programs which generated outbound files with Boeing data.
  • Developed customization to change the translate value on the page to a prompt table.
  • Prepared and executed the Test cases for the customizations and worked on the foot print tickets raised by the Customer as part of UAT.

Environment: PeopleSoft FSCM 9.1, People Tools 8.50

Confidential, Pleasanton, CA

Project Engineer

Responsibilities:

  • Worked on the high-level design documentation of the SQR’s that was customized.
  • Involved in preparing flow-charts for the sqr’s to replicate the program flow of the sqr process in detail.

Environment: PeopleSoft HRMS 8.0, People Tools 8.16

Hire Now