SUMMARY

• Over 10.5 years of experience in PeopleSoft as a Techno functional Consultant. Involved in Implementation, Customization, support, upgrade for Peoplesoft Modules in FSCM, HR and CRM.
• Thorough knowledge of all Stages of SDLC Requirement Gathering, Design, coding, Reviewing, Migrations, Database tuning, Defect Resolution in Support Engagements, preparation of test scenarios and cases, monitoring job schedules, 3rd party Integrations.
• Excellent in Application Designer, Application Engine, Process scheduler, Application Package, People Code, PS Query and Datamover in PeopleTools 8.47/8.49/8.52 and 8.53, SQR report generation and Crystal Reports.
• Excellent and Strong in integration tools like Integration Broker, and worked with different Listening / target Connectors in People Tools 8.47, 8.49, 8.52 and 8.53.
• Involved in setting up the connectivity between third party systems and PeopleSoft using Integration broker with different projects
• Involved in analysis, implementation and customization of HR/Benefits/Payroll modules
• Experienced in PeopleSoft Financials in PO, AP, AR, Billing, AM, MM and GL modules
• Worked on Full Life Cycle Implementation of PeopleSoft FSCM/HCM.
• Involved in full upgrade of PeopleSoft HCM / FSCM versions 8.8 to 9.0, 8.0 to 8.8 using Upgrade Assistant/Change Assistant, Application Designer and Data Mover Scripts.
• Customized the e - Settlements Module for increasing the BU level securities and created XML structure for publishing from the Vendors end.
• Worked on interface programs for migrating data from third party systems to People Soft
• Integrated the FileNet Business Process Management with PeopleSoft Modules
• Proficient in administering Jobs in Process Scheduler
• Experience interacting with End Users and Customers to gathering requirements
• Experienced in gathering requirements for creating and maintain PS queries and administer queries.
• Good Domain Knowledge in Finance, HR, Payroll and CRM.
• Experience in preparing Functional Design Documents, Technical Design Documents, Unit Test & UAT Documents, System Integration Test Plans and Functional Testing and created DMS scripts to migrate custom configurations from one instance to another.
• Having good knowledge on XML.
• Familiar with SQL, PLSQL and Oracle 10g databases.
• Possess zeal to learn new concepts and technologies.

TECHNICAL SKILLS

ERP Applications: PeopleSoft FSCM 9.2/9.1/9.0/8.9

Technologies: People Tools 8.53,8.52, 8.51, 8.49, 8.47 (Application Designer, People Code, Application EngineIntegration Broker, Application Packages and Data Mover)

PeopleSoft Modules: FSCM Purchasing, Accounts Payable, e-Settlements

HCM: HR, Payroll and CRM

Microsoft Technologies: ASP.NET, VB.NET

Scripting Languages: JavaScript

Markup Languages: HTML and XML

Reporting Tools: SQR and PS-Query

Databases: SQL Server 2005 and Oracle 10g

Operating Systems: Windows 2000/NT/XP, UNIX

Languages: SQL, PL/SQL and Core Java (Basics).

PROFESSIONAL EXPERIENCE

Confidential, Louisville, Kentucky

Sr Peoplesoft Consulatant

Responsibilities:

• Involved in all steps of admin, development and most of the functional parts of PS 9.2 Upgrade.
• Generated Compare Reports between 8.8 Production and 8.8 Demo to identify customizations.
• Involved in decision process of customizations and suggested users in keep/drop decisions.
• Extensively involved in the analysis and retrofitting the existing People code, SQL’s, SQR’s, Application Engine’s and other PeopleSoft impacted objects.
• Implemented single sign-on for various benefit vendors.
• Retrofitted the departmental security and permission lists using Tree Manager.
• Retrofitted the Account payable objects.
• Created new roles and permission lists for user’s security and followed THR methodology to migrate to production and maintained documents for audit.
• Tuned conversion SQL’s to decrease the execution time which helped to minimize the cutover time.
• Involved in the production cut over plan and Go-Live activities.
• Production Support (Post 9.2 upgrade & Pre 9.2 Upgrade)
• Developed several SQR processes for inbound and outbound interfaces.
• Developed Component interfaces to load the data into HR, Benefits, Time & labor, Payroll…etc
• Maintained 8.8 eRecruit and Implemented 9.2 Candidate gateway and Talent Acquisition.
• Modified and Created several Application designer objects (Pages, Components, Peoplecode, Menu, Records, Application Engines, Component Interfaces…etc) to in corporate THR needs.
• Used Excel to CI tool for on demand data loads to setup tables and some transaction tables.
• Developed several audit SQL’s for payroll users which are used in payroll process.
• Involved in discussions for key design changes with system users and functional consultants.
• Responsible to check Service Operation Monitor of the Integration Broker.
• Developed several SQL’s on time & labor and Payroll tables for audit processing.
• Tuned several SQL’s with using SQL hints and Oracle optimizers.
• On call 24/7 payroll and other processes production support.
• Involved in Issue solving day-to-day Production Issues and checking the Process.
• Responsible to download and install the Tax updates. Retrofit the objects if needed.
• Developed Application Engine’s and SQR’s for open enrollments.
• Administering Open Enrollment and Event Maintenance.
• Developed several SQR’s which are useful for yearend processing data loads.
• Responsible to migrate the Time & labor rules and compile them.

Environment: PeopleSoft HCM 8.8 /9.1/9.2, People Tools 8.48 /8.52/ 8.53 , SQR, PL/SQL, PeopleCode, Integration Broker and Oracle Database

Confidential, NYC, NY

Sr PeopleSoft Analyst

Responsibilities:

• Involvement and development of Interface between SMART and SCAN systems.
• Customized the Job Code, Job Data and Personal Data Panels in Manage Human Resources and Administer Workforce modules as per the user requirements.
• Used Synchronous process for sending the Messages to the target system.
• Implemented various EIP’s for the interfaces, between HCM and FSCM
• Implemented Location, Department and County Integration broker between FSCM to HCM PeopleSoft.
• Worked on AP/PO modules as a data conversion expert for Historic Payables and Open Payables.
• Customized the Work force sync and Person Data Integrations as per business requirement.
• Implemented Live Summary (Explores the Peoplesoft date like staff details/ Bin status/update asset availability details/asset attach/asset detach details) Integration to display on dash board of JAVA system. This is a third party integration between PeopleSoft and Java application.
• Implemented various developments of Confidential modules.
• Involved in implementing various third party integrations like NYCAPS, City Time and NTI interfaces with peoplesoft.
• Reviewing and creating of various Technical design documents.
• Used Excel to CI for posting data from Spreadsheet to PeopleSoft database.
• Created Application packages for maintaining the uniform code.
• Developed an Interface to publish the Denied Party Screening data from External system to Order Management using FTP and Application Engine, Application Packages, File Layout, Component Interface and Integration Broker.
• Developed SQR’s which creates a copy of the existing test script and updates the same with different test data in METADATA tables for Test Cases types ‘Test’ and ‘Shell Test’
• Developing and running Post Go-Live scripts to perform select and deletes for Base and Non-Base tables.
• Developed SQR Interfaces to get Siebel data and populate in PS Database
• Used SoapUI for posting the XML's to third party applications for verifying the output .
• Used Integration Webservices for integrating Peoplesoft and third Party application.
• Used Consumed webservices of third party application (Mainframe application) and created request and response messages using Service operations.

Environment: PeopleSoft HCM / FSCM 9.1, People Tools 8.52, Oracle Database

Confidential, Memphis, TN

Technical Consultant

Responsibilities:

• Developed the Integration Broker to fetch the SCI (Single customer Information) data from MQ server to Peoplesoft FSCM.
• SCI contains various types of employee information, which will extract the data from the XML and stores in the respective Peoplesoft database tables.
• Implemented JMS connectors using Integration Broker PS 8.51
• Used synchronous process for sending the response to the target system.
• Worked with MQ sever Client for maintaining the relation between MQ servers and MQ Clients.
• Created XSD and XML formats and provided to MQ server, Request messages to the PeopleSoft will come in the provided format.
• Used Non Rowset messages structure, for receiving the request Messages.
• Developed a Customized dynamic code for Non Rowset Messages.
• Developed the Dynamic code for fetching the MQ servers messages input to Peoplesoft using Application Package code.
• Involved in Configuration of Websphere was done to MQ server for enabling the JMS connectors.
• Involved in checking the input of MQ explorer tool queues for MQ server messages.
• Used the MQ Explorer tool for sending the XML to MQ servers which will routes to Peoplesoft.

Environment: PeopleSoft FSCM 9.1, People Tools 8.52, Oracle Database

Confidential, Memphis, TN

Technical Consultant

Responsibilities:

• Involved in Implementation of Peopletools 8.47 and upgraded to Peopletools 8.49
• Involved in all steps of admin, development and most of the functional parts of Peoplesoft 9.0 Upgrade.
• Generated Compare Reports between 8.8 Production and 8.8 Demo to identify customizations.
• Involved in decision process of customizations and suggested users in keep/drop decisions.
• Extensively involved in the analysis and retrofitting the existing People code, SQL’s, SQR’s, Application Engine’s and other PeopleSoft impacted objects.
• Implemented single sign-on for various benefit vendors.
• 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 Branding related changes for changing the LOGO as per the Internet / Intranet based URL's.
• Customized the Views for maintaining the Security
• Used the Http connectors in the Integration brokers for sending a Invoice data through XML using by the online system.
• Customized EM VOUCHER IN message and delivered it to the vendor for self processing the vouchers.
• Worked with XML Messages on customization.
• Edited the Ctrl + J functionality for restricting supplier to see the Sensitive information like Server details.
• Used Peoplesoft delivered SEND MASTER for posting the XML's to third party applications for verifying the output .

Environment: PeopleSoft e-Settlements 8.8/ 9.0, People Tools 8.47/8.49, Oracle Database

Confidential

PeopleSoft Developer

Responsibilities:

• Involved in the preparation of technical specifications based on the fit gap analysis and Functional design documents
• Created a filenet interaction with http Connectors using Integration broker.
• Provided and implemented a solution between PeopleSoft and Filenet Application (JAVA based application) for fetching the image.
• Developed a third party layer for fetching the Images from Filenet through PS
• Integration broker was implemented for receiving the External messages.
• Worked with Rowset - XML Messages
• Integration broker Http Connectors was used for third party integration purpose.
• Developed and implemented the Customized Subscription People code.
• Customized the Application Engine process (PO RECVACCR) Interfaces Receipt Accrual process to load unbilled receipt amounts in a receipt accrual liability account and debits identical amounts from the designated expense accounts into General Ledger module. Before loading, the data would be edited through ChartField validations and combo rules
• Developed ad-hoc reports and ad-hoc queries and developed run control pages as per requirements and attached to menu to run SQRs
• Involved in training the users and developed hand out documents that are used by the users for understanding the new changes
• Developed PS queries in order to help the client day-to-day activity like Budget Status Report,, Journal Entry Detail, Un Paid Items which have been billed
• Involved in customizing the check formats as required by the countries specific.
• Involved in training the users and developed hand out documents that are used by the users for understanding the new changes
• Designed and developed various other conversion and Interface programs using SQR, like Customer Conversion & Interface, AR Open Item Balances, Asset Conversion, Vendor Conversion, Voucher Conversion etc.
• Perform Insert/Update on METADATA tables using application engine, peoplecode and SQR
• Tailored People Code to implement data validation and to enforce field level security.
• Extensively used Process scheduler for setting up the reports to run at specific time
• Used Data mover scripts for to migrate the Data Across Different Databases for the Custom and Delivered Tables to fix the Data conversion Issues
• Attend project status meetings to review project progress and present risks including issues and constraints that are impeding or may impede project performance. Provide recommendations for risk mitigation
• Prepare and issue requested project status reports covering all assigned pending and current project activities
• Worked on Integration Broker and Application package Class PeopleCode for subscribing the data to the database.
• Used Send master to test the XML structure and sending it for third party application.

Environment: PeopleSoft FSCM 8.9 / 9.0, People Tools 8.47/8.49, Oracle Database

Confidential

PeopleSoft Developer

Responsibilities:

• Created new PeopleSoft objects like Fields, Records, Pages, Menus, and Components.
• Customized the Job Code, Job Data and Personal Data Panels in Manage Human Resources and Administer Workforce modules as per the user requirements.
• Designed a new Automated Salary Increment batch process using SQR, which update the compensation rate of all the employees or a particular employee category as given by the user. This process uses Salary Plan/Grade/Step tables.
• Implementing the Workflow and Business rules using Workflow Administrator and Business process maps.
• Production support and System Enhancements as per new requirements.
• Customized and maintained PeopleSoft Organization and Department/Location Security Trees.
• Scheduling the on-line and background processes using Process Scheduler.
• Generated SQR’s for employee nationality details.
• Developed People code to get Employee Leave Date in Absence Monitory Module.
• Employee Absence History and Leave Break History.
• Inbound data from legacy system to PeopleSoft database using Excel to CI.
• Developed an AE program to get employees Job data related to Self Service Module.
• Generated SQR’s for employee nationality details.
• Created employee date of joining, payroll setup/fix, pay revision, loan transactions.
• Provide the rule-based elements, payroll generation - month wise and batch, full and final settlement upon employee separation.
• Customized and retrofitted SQR’s
• It includes reports for HR and Payroll Modules like Manpower statement, IT Report, Deductions, Salary breakdown or the component statement
• Part of the functional team for Time and Labor and Absence Management implementation.

Environment: PeopleSoft HRMS (8.8), People Tools (8.48) and Oracle Database

Confidential

PeopleSoft Developer

Responsibilities:

• Setting up of Integration Broker Components, Gateways, nodes, messages, message Channels, Transformations and URL’s
• Use of iWay SOAP switch
• Generate WSDL from PeopleSoft component interface and message definitions

Environment: PS CRM 8.9, PS Financials 8.8, People Tools 8.45, Application Designer, PeopleCode, AE, IB