SUMMARY

• PeopleSoft Consultant with 7+ years of experience in all stages of Application Development including Business requirements gathering, Development, Implementation, Customizations, Production Support, Interfacing/Reporting, and Upgrade of PeopleSoft HCM applications.
• Expertise in PeopleSoft concepts, tools and technologies like Application Designer, People Code, People Tools, Application Engine, Component Interface, Integration Broker, File Layout, PS Query, Process Scheduler,pivot grids, Security, Data Mover, SQR, Excel to CI.
• Worked on PeopleSoft HCM that include various modules like HR, Payroll (NA), Benefits, Benefits Admin, Time & Labor, e - Benefits, ESS and MSS, Absence Management.
• Worked on Component Interface, File Layout and Excel to CI to connect third party systems using both inbound and outbound interfaces.
• Experience in reporting tools SQR, XMLP/BI Publisher and modifying the existing ones as per the changes specified.
• Technical expertise in working with different modules of PeopleSoft HCM which include Core HR,Base Benefits, North American Payroll, Time & Labor, Recruitment, Absence Management and Peoplesoft ELM(Enterprise Learning Management).
• Good amount of experience in Implementing, Customizing and Upgrading HCM modules include Recruiting, Base Benefits, Benefits Administration, Core HCM, Absence management and NA Payroll.
• Worked intensively with Security Administrator to implement Row Level Security, Single Sign on, and LDAP integration, Creating Roles, Permission Lists, User Profiles, Portal Security and Definition Security.
• Functional Expertise in Core HR, Position Management, Compensation, Base Benefits, ESS & MSS, Payroll.
• UAT strategy and providing support to users during UAT.
• Worked on development and modification of Interfaces and data conversion from Legacy systems to PeopleSoft records by performing numerous validations using SQRs and Application Engine.
• Experience in PeopleSoft Financials/Supply Chain Management(FSCM) General Ledger(GL), Purchasing(PO), Account Payables(AP), Inventory(INV), Account Receivables(AR) and Project Costing modules.
• Have good understanding of Functional and technical aspects of modules in peoplesoft HRMS.
• Excellent communication, interpersonal, analytical, trouble shooting and presentation skills.
• Varied work experience in Agile and waterfall environments.

TECHNICAL SKILLS

ERP Solutions: PeopleSoft HCM 9.2, 9.1 and 9.0; Tools Release 8.54, 8.53,8.52,8.51, 8.50 and 8.49.

HCM: Core HR, NA Payroll, Absence Management, Base Benefits,Time & Labour

PeopleTools: People Code, Application Package, Application Class, Application Engine, Workflow, Component Interface, File Layout, Security, Process Scheduler, Tree Manager and Data Mover.

Reports: SQR, Crystal Reports, n/Vision, PS Query, XML/BI Publisher and Application Engine.

Databases: Oracle SQL Developer, SQL Server and Toad

Languages: C, C++, HTML, CSS, XML, JavaScript, PeopleCode and Java.

PROFESSIONAL EXPERIENCE

Confidential, SFO,CA

Sr.Peoplesoft consultant

Responsibilities:

• Principle Developer for HCM upgrade project from PeopleSoft 9.1 to PeopleSoft 9.2, People Tools .
• Developed Application Engine program from Scratch and PeopleCode changes based on the client's requirements.
• Added PeopleCode customizations to apply new functionalities for employee Base Benefits, and Self-Service modules.
• Extensively worked with People Tools such as Application Designer, Approval Workflow Engine, Application Engine,PeopleSoftparchitecture, File Layout, Component Interface, People Code, Security, Tree Manager, Process Scheduler, Data Mover and Query tools.
• Developed an Application Engine Program which fetches data from PS EMPLOYEES table based on paygroup criteria and send email.
• Designed and developed the XML Publisher reports in Time & Labor.
• Worked intensively with Security Administrator to implement Creating Roles, Permission Lists, User Profiles, Portal Security and Definition Security.
• Developed an SQR program in generating outbound interface files which contain employee information in a period and transmitted the Encrypted file to third Party and this Employee data acts as key records for data from ADP.
• Wrote an app engine to diagnose and fix discrepancies between PS LEAVE ACCRUAL (benefits) leave balances and those in PS TL COMPLEAV TBL (Time and Labor).
• Gather requirements for the new functionalities to be implemented which include Payroll WorkCentre, Self Service - ePay, HR and Manager Dashboards.
• Worked on SQR changes related to the Leave accrual process in Time and labor SQR.
• Involved in Pre-and Post-production support of HR modules like Global Payroll, Absence Management, Benefits and Recruitment, ESS/MSS.
• Generated SQR reports creating Time Load to pay sheets, master employee listing, employee pension plan data, new hires & terminations.
• Worked on Integration Broker on messaging services to link PS HCM and Financial applications.
• Involved in UATTestingof reports and helped client to determine errors before going live.
• Generated a process to create interface between Benefits and Time and Labor which compares employee's leaves recorded in Time and Labor against the allowed leaves. This process is used as an alternative to the existing Payroll feature, which calculates the Leave Accruals.
• Developed and run PeopleSoft queries to generate daily, weekly, bi-weekly, and monthly payroll reports.
• Developed an App Engine program that sends Forecasted Payable time hours to Payroll and e-mail the hours to the manager.
• Read to records and writing to the files by using the File Layout and App Engine.
• Using STAT tools for migration and EMS tools to create the migration request.
• Developed several reports in SQR, XML publisher, PS query reports and Crystal reports.
• Responsibility includes design and developing Stored Procedures, performance tuning. Development of complicated sql for PeopleSoft application engine and SQR.
• Worked with reporting and analyzing tools such as XML Publisher. Used PS/Query, Connected Query and Tree Manager for reporting purposes to fulfill company's specific needs.
• Create test plans for System and Integration testing, Regression Testing, User testing.

Confidential, Tucson, Arizona

Peoplesoft consultant

Responsibilities:

• Worked on Upgrading PeopleSoft HCM 9.1 to HCM 9.2 using Agile Methodology.
• Project involved in carry forward the customizations done in various modules such as Absence Management, Global Payroll, Employee Self Service, and Manager Self Service.
• Configure Payable System (Pay cycle), Requisition, Purchasing, Templates, Workflows and notifications for the PO. Lead functional walk-thru sessions with clients tx and executives, including project status presentations
• Worked on SQR changes related to the Leave accrual process in Time and labor SQR.
• Interfaces done from 3rd party system to create the Auto Project Number (only for fixed price contract). Built detailed "road maps" for conversion planning and data mapping to PeopleSoft Products/Applications.
• Assist technical development staff with technical specification documentation and technical unit testing .
• Wrote AE programs as part of data conversion process using CI to load data from Third party systems to PeopleSoft System.
• Worked on converting Crystal to BI publisher reports.
• Involved customizing pages, Records, Components and written new people code to meet the Business requirement.
• Read to records and writing to the files by using the File Layout and App Engine.
• Worked on Integration Broker on messaging services to link PS HCM and Financial applications.
• Document and manage defects and issues related to the testing of designed solutions. Develop and deploy enhancements to Sourcing Module and Implemented Purchasing Processes.
• Provide subject matter expertise for the implementation and integration of Self-Service, Benefits, Payroll, Time and Labor and Absence Management modules.
• Generated a process to create interface between Benefits and Time and Labor which compares employee's leaves recorded in Time and Labor against the allowed leaves. This process is used as an alternative to the existing Payroll feature, which calculates the Leave Accruals.
• Work on several enhancement requests including changes to AR/express deposit pages, writing custom queries using the PS Query Tool, PeopleCode changes, importing conversion Data, creating and configuring 3rd party Interfaces into and from PeopleSoftand out/in, to/from other systems.
• Perform customizations on delivered business process and work on new enhancements using PeopleCode, AE, CI, and SQR.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins and sub-queries.
• Designed and mapped data for a conversion program which reads the data from a flat file and writes it into a file so that Journal load program (GLS9002) will read that data and insert into Journal Tables. Uploading bundles and patches for maintenance management activities.
• Developed various PS queries in order to help the client day-to-day activity. Conducted meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements.

Confidential, Columbus,OH

Peoplesoft consultant

Responsibilities:

• Involved inPeopleSoftUpgrade fromPeopleSoft8.8 to 9.1 related to core HR, Base Benefits and payroll for North America modules.
• Retrofitted customizations impacted by Maintenance Pack, Tools and Application upgrade.
• Created new roles and permission lists for user's security and Retrofitting of Security objects with respect to changes occurred during the upgrade.
• Customized and created new message catalog information according to the business requirement.
• Involved customizing pages, Records, Components and written new people code to meet the Business requirement.
• Created newPeopleSoftobjects such as Menus, Components, pages and records using Application Designer as per thetechnicalspecification.
• Developed and modified Application Engine programs to suit the modifications brought out in application release.
• Involved in writing App Engine Programs that which uses Component interfaces in order validate the components like Employee General Deductions and Additional Pay.
• Primary role is to develop the Accounts Payable Workflow, Configure, and Design and develop integration broker messages for Inventory and purchasing module with third party systems.
• Designed and Developed Application Engine program to Automate Termination process.
• This included creating Component Interface for Additional Pay, Direct Deposit, Disability Benefits, General Deductions, Payroll Data, Health Benefits, FSA Benefits, and Saving Plan component.
• Developed interface programs in Benefits and Payroll through Application Engine.
• Developed outbound interfaces for third party vendor's, which consisted of employee, benefit related data.
• Created inbound interfaces for updating the employee's and dependent's benefit election data which was sent from web.
• Analyzed and developed a new interface for payroll audit which determines and reports changes to payroll deductions.
• Worked on Integration Broker on messaging services to link PS HCM and Financial applications.
• Supported Payroll (Payroll Administration - PaySheet, PayCalc and PayConfirm Processes) and worked on issues related to payroll.
• Designed Application Engine programs using component interface, Excel data capture templates and Excel to CI to process acquired company's HR data intoPeopleSoftHCM.
• Developed and run PeopleSoft queries to generate daily, weekly, bi-weekly, and monthly payroll reports.
• Developed an App Engine program that sends Forecasted Payable time hours to Payroll and e-mail the hours to the manager.
• Created BI Publisher Reports using PS Query, XML as Data Source. Also, converted Crystal reports to BI Publisher reports.
• Data keying in job data component for both regular hourly and salaried employees to impact payroll processing.
• Worked on Customized PeopleCode for Core HR, Time and Labor and NA Payroll modules for different requirements as demanded.
• Developed several new Inbound and Outbound SQR Interface Programs and Written many business critical programs through SQR and customized number of SQR Reports for employee's PERSONAL INFORMATION.
• Re-apply the all custom people code.
• Moved Data from old tables to new tables using Upgrade Assistant

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Works directly with business IT and end users in requirement gathering followed by translating business requirements in totechnicalspecifications and developsPeopleSoftsolutions.
• Designs Business Solution document, high level design and detailed designed documents after doing thorough impact analysis and discussing changes, if any required, with Business analyst.
• Wrote Peoplecode for validating the data in the pages and for implementing the functionalities in the Application.
• Involved in Creation/Development and Customization of Records, Pages, Components and Menus, Application Engine processes and File Layouts using Application Designer.
• Coordinates with offshore team on a regular basis to update and follow up on assigned tickets and new enhancements.
• Designed and developed the XML Publisher reports in Time & Labor.
• Created new page in SETUP HRMS where JOBCODES remapped with Client specific codes and developed an outbound interface to transmit this mapping to the third party system.
• Designed custom Online Pages, Run Control pages and PeopleCode to validate user interface meeting needs of the company.
• Worked on Integration Broker on messaging services to link PS HCM and Financial applications.
• Designed Application Engine programs using component interface, Excel data capture templates and Excel to CI to process acquired company's HR data intoPeopleSoftHCM.
• Read to records and writing to the files by using the File Layout and App Engine.
• Involved in designing and customizing the reports using the tools PS Query, SQR and XMLP.
• Enhances and customizes existing objects to accommodate requests for new processes and reports.
• Extensively used Process scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.
• Expertise in PeopleSoft Security, creating permission lists and roles, assigning them to users.
• Not only resolves Production issues but ensures to provide a permanent fix to each one of them.
• Provides support forPeopleSoftapplications in PO, AP, AM & GL modules on 24x7 basis.
• Worked on Setting up the core records for Benefit Administration. Records include Benefits Cost Setup, Eligibility Rules, Event Rules, Program Definitions, etc.
• Reapplied People Code, application engines, sections, actions, People Code, SQL, PsQueries, Pages, Components, SQRs and Crystal Reports.
• Works on shell scripts and batch objects as a part of support.
• Acquired knowledge on EXCEL to CI

Confidential

Jr.PeopleSoft Technical consultant

Responsibilities:

• Developed new Records, Online Pages, and Run Control Pages using PeopleTools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.
• Created and customized new pages, records, fields and components through Application designer.
• Worked with Process Scheduler, Process Monitor, Edited Run Control, Granting security access and scheduled programs on recurring basis.
• Involved in enabling and updating Security Definitions for Pages, Components and Menus to restrict users to the Database tables holding sensitive data.
• Developed and Modified PeopleCode for various validations as required by our business process.
• Created SQR reports/interfaces, Crystal reports and modified custom PS objects.
• Used Process Scheduler to make SQR available from within PeopleSoft.
• Work involved development of SQR's and also customization using PeopleTools based on the technical design specification given by client.
• Designed and developed Roles and Permission lists and assisted to assign roles to Users.
• Designed Functionality for Application Engine Program to upload Hire Information from Data file into PS Staging Tables using File Layouts and People Code, which will be further populated into Corresponding PS tables using Conversion SQR programs.
• Designed and developed the XML publisher reports in payroll modules.
• Created and developed various Outbound and Inbound Interfaces like as per the requirements using SQR.
• Responsible for testing of various transactions and fixing of various issues and bugs at different stages of Upgrade process.
• Worked as atechnicalconsultantresponsible for analyzing and creatingtechnicalspecifications for all the new and customized processes.
• Wrote/Modified PeopleCode to accomplish the Business Functionality.
• Customized Application Engine programs and also in debugging created programs.