SUMMARY:

• Having 10+ years of experience in PeopleSoft as a Techno - functional Consultant. Involved in Design, Development, Implementation, Customization, support, and upgrade of PeopleSoft Modules.
• 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 Data Mover in PeopleTools 8.47/8.49/8.52/8.53 and 8.55, 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, 8.53 and 8.55.
• Involved in setting up the connectivity between third party systems and PeopleSoft using Integration broker in different projects
• Specializing in Accounts Payables, Billing, Accounts Receivables, General Ledger, eSettlements, ePerformance, Purchasing modules
• Extensively worked with Security Administrator to implement security at various levels. Created Roles, Permission Lists, User Profiles, Portal Security, Folders, Content References and Definition Security
• Worked on Full Life Cycle Implementation of PeopleSoft FSCM.
• Involved in configuring and maintaining PeopleSoft Internet Architecture (PIA) elements like Application Server, Web server, Tuxedo and Process Scheduler.
• Involved in the full upgrade of PeopleSoft FSCM versions 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
• Extensively used Component Interfaces to interface data to Database.
• Proficient in administering Jobs in Process Scheduler
• Experienced in gathering requirements for creating and maintain PS queries and administer queries.
• Experience in preparing Functional Design Documents, Technical Design Documents, Unit Test & UAT Documents, Confidential Integration Test Plans and Functional Testing and created DMS scripts to migrate custom configurations from one instance to another.
• Used Integration Web Services for integrating PeopleSoft applications.
• Familiar with SQL, PLSQL and Oracle 10g, 11g databases.
• An avid learner of new concepts and technologies.

TECHNICAL SKILLS:

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

Technologies: People Tools 8.55, 8.53, 8.52, 8.51, 8.49, 8.47 (Application Designer, PeopleCode, Application Engine, Integration Broker, Application Packages, and Data Mover)

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

Microsoft Technologies: ASP.NET, VB.NET, MS Word, MS Visio, MS Project and PowerPoint

Scripting Languages: JavaScript, UNIX shell scripting

Markup Languages: HTML and XML

Reporting Tools: SQR and PS-Query, BI Publisher

Databases: SQL Server 2005 and Oracle 11g

Operating Systems: Windows 2000/NT/XP, UNIX

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

PROFESSIONAL EXPERIENCE:

Confidential, New York

PeopleSoft Technical Lead

Responsibilities:

• Involved in development of Interface between NYSLRS Redesign Project and Mainframe systems.
• Implemented the Loans functionalities to members.
• Customized the Employer Reporting Earnings / Contributions to Billing from there posted as open Receivable items.
• AR process is customized as per the business requirement.
• Used Synchronous process for sending the Messages to the target Confidential .
• Lead the Employer Reporting, Member Data, and various module implementations.
• Involved in creating the Workflow using Business Projects in CRM
• Involved in design and creating the Active Analytics Framework (AAF) policies
• Worked on Account Payable/Purchase Order modules as a data conversion expert for Historic Payables and Open Payables.
• Built custom integration process to integrate the Data from Employees Loan, Contributions and Service Credit Purchase to finance as open account receivables.
• Customized the Billing and Costing Integrations as per business requirement.
• Implemented various developments of Redesign modules.
• Involved in implementing various third-party integrations MEBEL, OFAC Interface and File net with PeopleSoft.
• Designed and developed AP Voucher Match Exception workflow process to send worklists and emails for the Match exception to the appropriate users.
• As a part of the AP, outbound interface developed the custom SQR & SQC programs for creating the payment files in EFT & ACH format
• Customized the integrations to process the data between Account Receivables and Billing.
• GL Combo Sync: Developed Combo Sync Integration Broker Messages to Send Incremental data as XML Messages to Various other Systems that use Combo Edits
• Involved in troubleshooting various App engine Programs and COBOL such as FS JGEN (Journal Generator).
• Customized Application Engine Program GLJEDIT which would populate the analysis type depending on the Project, Fund and Account values.
• Involved in Review and creating of Technical design documents and Unit test case documents.
• Used Excel to CI for posting data from Spreadsheet to PeopleSoft database.
• Developed an Interface to publish the data from External Confidential to Application Engine, Application Packages, File Layout, Component Interface and Integration Broker.
• Customized the below BI Publisher Reports

Environment: PeopleSoft FSCM 9.2, People Tools 8.55, SQR, PL/SQL, People Code, Integration Broker, RTC, SHARE POINT, PHIRE, SOAP UI, OPA, File Net and Oracle 12c

Confidential, Louisville, Kentucky

PeopleSoft Technical Lead

Responsibilities:

• Involved in all steps of admin, development and most of the functional parts of PS 9.1 Upgrade.
• Generated Compare Reports between 8.8 Production and 8.8 Demo to identify customizations.
• Involved in the decision process of customizations and suggested users in keep/drop decisions.
• Configured and tested Excel Upload for Voucher. Activated the Service, Service Operation and gave security to the user permissions to have access to the WEBLIB AP and WEBLIB XMLLINK
• Created New User List and Criteria’s using Application Package PeopleCode for AWE Implementation
• Reapplied Customizations for PO, AP, GL and AM module and tested the functionality in 9.1
• Retrofitted Customizations are done on POPO005 PO Dispatch SQR so that all customizations are brought forward to 9.1
• Extensively involved in the analysis and retrofitting the existing People code, SQL’s, SQR’s, Application Engine’s and other PeopleSoft impacted objects.
• 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.
• Trained as Workday Sr Technical consultant.
• Involved in the production cutover plan and Go-Live activities.

Environment: PeopleSoft FSCM 8.8 /9.1, People Tools 8.48 /8.52, SQR, PL/SQL, People Code, Integration Broker and Oracle 11g

Confidential,New York

PeopleSoft Lead Developer

Responsibilities:

• Involvement and development of Interface between SMART and SCAN systems.
• Customized the Account Receivables, Account Payables, and Billing modules as per the user requirements.
• Used Synchronous process for sending the Messages to the target Confidential .
• Implemented Location, Department and County Integration broker between FSCM to HCM PeopleSoft.
• Worked on Account Payable/Purchase Order modules as a data conversion expert for Historic Payables and Open Payables.
• 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 the dashboard of JAVA Confidential . This is a third party integration between PeopleSoft and Java application.
• Implemented various developments of DSNY modules.
• Created Workflow Engine (AWE)setup using a step, path, and stages for staff assignment process.
• 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 Confidential 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.
• Used STAT tool for migrating the PeopleSoft objects from DEV to TST environment.
• Developed SQR Interfaces to get Siebel data and populate in PS Database
• Used SoapUI for posting the XML to third-party applications for verifying the output.
• Customized the Delivered Crystal Report AR Dunning letter AR3000 according to the Client’s Business Needs.
• Customized the Delivered Crystal Check APY2021 according to the client’s Business Needs. Added University Logo on the Check Print Programs
• Modified the PO PO EMAIL Application Engine that is used by the PO Dispatch Job, as the content of the outgoing email needed a change.
• Used Integration Web Services for integrating PeopleSoft and Third Party application.
• Used Consumed web services of a third-party application (Mainframe application) and created request and response messages using Service operations.
• Used TOAD for verifying the data from the Database using DML commands.

Environment: PeopleSoft FSCM 9.1, People Tools 8.52, Oracle Database People Tools used: Application Designer, PeopleCode, Integration Broker, SOAP UI, Application Package, SQR and Process Scheduler

Confidential

PeopleSoft Integration SME

Responsibilities:

• Developed the Integration Broker web services 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 Confidential .
• Worked with MQ sever Client for maintaining the relation between MQ servers and MQ Clients.
• Created custom 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.
• Created excel based custom process for bulk upload of events in Sourcing
• Created excel based custom process for bidder to respond in sourcing supplier portal
• Added customization for bulk award of events in sourcing module
• 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 route to PeopleSoft.
• Used Web services to Consume and Export the XSD from PeopleSoft to MQ server.
• Used TOAD for verifying the data from the Database using DML commands.

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

Confidential

PeopleSoft Integration SME

Responsibilities:

• Involved in Implementation of PeopleTools 8.47 and upgraded to PeopleTools 8.49
• Involved in all steps of admin, development and functional requirement gathering to upgrade PeopleTools 8.49.
• Generated Compare Reports between 8.8 Production and 8.8 Demo to identify customizations.
• Involved in the decision process of customizations and suggested users in keep/drop decisions.
• Configured and tested Excel Upload for Voucher. Activated the Service, Service Operation and gave security to the user permissions to have access to the WEBLIB AP and WEBLIB XMLLINK
• 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 URLs .
• Customized the Views for maintaining the Security.
• Applied Customizations to the Pay Cycle Process (AP PAY2015) and Payment Selection Process(AP PAYSELECT) to replicate the new development
• Developed Brand New PeopleSoft Objects to create a row of approved vouchers for which the Payment Method is ‘ACH’, ‘Wire’ and vendor layout is CCD+.
• Developed Audit for Open Periods by Products(FIN OPEN ADJ, FIN OPEN PERIOD)
• Applied customizations to the POPO005.SQR to place the client Business Unit and Address Details in Header
• Used the Http connectors in the Integration brokers for sending an Invoice data through XML using the online Confidential .
• Used STAT tool for migrating the PeopleSoft objects from TST to UAT environment.
• Customized EM VOUCHER IN message and delivered it to the vendor for self-processing the vouchers.
• Used Integration Web services for receiving and sending the messages from the customer end.
• Worked with XML Messages on customization.
• Edited the Ctrl + J functionality for restricting supplier to see the Sensitive information like Server details.
• Used TOAD for verifying the data from the Database using DML commands.
• Used PeopleSoft delivered SEND MASTER for posting the XML 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 Upgrade Lead

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 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, People Code, and SQR
• Used TOAD for checking the DML commands and output fetched from the Database.
• 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
• Resolved Issues when Accounting Entries in Billing were not updated with the GL DISTRIB STATUS even when the Journal entries were created in GL.
• Developed GL Interface that loads data from various external systems into PeopleSoft General Ledger using Application Engine process.
• 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 a third-party application.

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

Confidential

PeopleSoft Developer

Responsibilities:

• Developed & customized fields, records, Pages, components, People Code
• Developed new Application Engine programs and customized delivered ones
• Tracking Project Migration across environments.
• Creating and reviewing TDD’s Technical design documents and Training Manuals
• XML/BI Publisher Creating New Reports and Customizing Delivered.
• Ensuring Smooth Fixing and Bug Migration Cycle Smoothly - Tracking of SIT & UAT bugs.
• Co-ordination with Offshore Team on Daily Basis to ensure that work assigned offshore is delivered included code review, document review, coordinating between business users and offshore technical team.
• Working on SIT and UAT Bug Fixes.
• Developing the Pre and Post Production Project Migration Process keeping in mind upgrade path.

Environment: PeopleSoft FSCM (8.8), People Tools (8.48), Application Designer, PeopleCode, SQR, PS Query, AE, IB, Module: Marketing, Tele Marketing, Order, Capture Contracts, Order Management, Billing, Inventory, and AR.