CHRONOLOGICAL SUMMARY OF EXPERIENCE

PeopleSoft Financials Techno Functional Lead

Confidential

• Maintenance and Support of HCR ManorCare PeopleSoft financial applications along with Enhancements in following modules Accounts payable, Project Costing, Purchasing, Cash Management, Asset Management and General Ledger.
• Developed a custom secured process using application engine which removes secure payment details Information from PeopleSoft system.
• Developed custom inbound process using Component Interface and File Layout for Vendor component to import data from 3rd party system.
• Created custom ExceltoCI for Asset book component as part of Mass updates.
• Developed custom outbound interface using SQR to generate a file of approvers for Procurement transactions in 3rd Party system from PeopleSoft.
• Scheduled Data archival process using PeopleSoft Data Archival Manager for Accounts Payable General Ledger which includes transaction tables with staging tables.
• Worked on customizations in Purchase order dispatch process using SQR.
• Customized existing mass update of open periods which reduces the time for Business Users while updating Financial accounting periods.
• Customized AP check printing process using XML publisher.
• Developed an SQR data conversion program to import payments from a third party system to Cash Management module for bank reconciliation.
• Developed a new sqr process which generates procurement information from new 3rd party system which will be used in AP EDI interface.
• Designed the technical design documents and maintained entire document repository contains Test Case documents, Test Plan output, Backup/Back Out Data Plan For data issues .
• Developed functional flow diagrams for all customizations which will be more useful to the users to understand the flow of the customizations.
• Involved in Client Meetings for every new enhancement/Customization comes in PeopleSoft 9.1 Application.
• Worked on production issues occurs at every Financial Month end and communicated with Business Teams and Users Effectively with updates while resolving issues.
• Changes to People Code so as to reflect the customizations as per the Clients requirements and execution of Queries on Security tables for Performance checks.
• Worked with end users to gather necessary information for the tasks.
• Created several training documents in AP, GL, AR and BI modules and trained the end users.
• Involved in team discussions and conferences to solve technical issues and improve project's performance.
• Involved in Offshore-Onsite Coordination.
• Involved in team discussions and conferences to solve technical issues and improve project's performance.
• Worked in Production Support Team to resolve SQR, People Code, Application Engine issues.

Environment: PeopleSoft Financials/SCM AP, AM, PC, GL,CM, eProcurement, purchasing, Commitment Control 9.1, People Tools 8.50, Application Designer, Application Messaging, People Code, Component Interface, Application Engine, ExceltoCI, Data Mover, Mass Changes, Data Archival Manager, Security

PeopleSoft Financials Techno Functional Lead

Confidential

• Confidential application maintenance and support provided in following modules Accounts payable, Accounts Receivables, Billing, Purchasing, Project Costing, Inventory, Contracts and General Ledger. Recently PeopleSoft financials application upgraded from 8.9 to 9.2 versions.
• FSCM Upgrade activities
• Involved in fit-gap analysis from PS8.9 to PS9.2 version. Designed the document for master customization list which will take care of all the gaps should be fulfilled in PS9.2 version
• Involved in running Upgrade Compare Reports between Demo database and Copy of production before we perform upgrade.
• As part of conversion process, developed inbound interface programs including effective error handling methods for following components which imports data from 3rd party systems to PeopleSoft system
• Purchase Order
• Requisition
• Items
• Involved in Fine Tuning of Database Tables, which are used in Data Conversion.
• Worked on Upgrade Assistant tool as part of PS upgrade.
• Worked on performance tuning of application engine programs.
• Developed custom approval workflow engine AWE process in purchasing module as per the requirement given by Client.
• Preparation of Weekly status report for client update during the upgrade phase.
• Helped Team to complete Project Deliverables on Time.

Confidential

Enhancement and Support activities

• Providing PeopleSoft application support services in following finance modules Accounts Payable, Accounts Receivable, Billing, Purchasing, Inventory, Contracts and General Ledger.
• Worked on Minor/Major enhancements in following modules Gelco, Billing, Accounts Receivable, Accounts Payable and General Ledger.
• Worked on general ledger and billing modules for 3rd party systems Concur systems and STS system which integrate data with PS system.
• Having working knowledge on Shell scripting and PL/SQL packages which are being used to process data in All FSCM modules for current client.
• Resolving data related/ Application related issues in PeopleSoft financials applications as requested by user.
• Working knowledge on PeopleSoft FSCM job scheduling tool called AppWorx currently used by client .
• Used PS Query reporting tool to generate reports in financials modules as per the requirements provided by users.
• Worked on Remedy tool for resolving support tickets created by user.
• Involved in Quality Audit Meetings as a team lead.
• Worked extensively on Workflow, application engine, portal security, data mover and application designer.
• Prepared Weekly Status Reports as part of project quality standards.
• Having knowledge on crystal reports as I involved in changing the printing invoice data format of crystal invoice in billing.
• Designed Functional/Technical Detail Specifications for the Interfaces/Enhancements /Reports by coordinating with the Business team.

HRMS Rollout activities

• Developed payroll interface for India using application engine.
• Analyzing the problems/issues with the functional users and make sure for design/develop the root cause fixes.
• Developed PS-INAZ discrepancy report generation process which generates report containing differences between PeopleSoft system and INAZ system.
• Worked on PS query to generate country specific reports.
• Having working knowledge on XML publisher concepts which are used in report generation.
• Provided analysis and resolution for system defects identified during testing.
• Involved in customization of creating fields, record definitions, pages, views, application engine, creating search records using application designer.
• Preparing the documents like technical design, migration, unit test cases and Impact analysis.

Coordinated with testing team at all levels of testing of the entire application functionality and also fixed the issues related to the changed processes.

• Involved in writing Technical Specifications based on the functional specifications provided by functional team.
• Wrote Data Mover Scripts to migrate data from one database to another.
• Tuned SQR's performance

HRMS Transfers Issue Fix activities

• Involved in impact analysis process of verifying interfaces related to Employee Transfer.
• Identified SQR interfaces which has not handled process properly and Communicated with user.
• Involved in process of testing process for all employee transfer interfaces.
• Prepared documents library contains of list of impacted objects after company transfer and complete analysis/resolution for the fix.
• Worked with end users to gather necessary information for the tasks.

Environment: PeopleSoft Financials/SCM AP, AM, PC, GL, Inventory, purchasing, Order Management, Contracts 8.9/9.2, People Tools 8.49/8.52, PeopleSoft HCM application 9.0, Application Designer, Application Packages, People Code, Component Interface, Application Engine, ExceltoCI, Data Mover, Security, SQR, PS Query, AWE Approval Workflow Engine , XML Publisher, Oracle, PL/SQL, AppWorx, Remedy Client, Crystal Reports, Oracle 10g/11g

PeopleSoft Technical Consultant

Confidential

• This project was about Compass PeopleSoft HCM Enterprise Absence Management 9.0 implementation.
• Involved in development of interfaces and enhancements.
• Developed an outbound interface to integrate Absence Management data with ESA system using Integration Broker.
• Involved in development of absence management reporting phase using SQR and PS Query.
• Developed custom audit application to track the changes in Existing PeopleSoft system as part of requirement.
• Developed custom reports using PS Query reporting tool.
• Worked on integration between PS HCM system and PS Finance system.
• Having working knowledge on Approval Workflow Engine setup in PeopleSoft application
• Maintained quality of deliverables by creating all necessary documentation i.e. Technical Design, Migration, Unit Testing

Environment: PeopleSoft HCM Absence Management 9.0, People Tools 8.48, Application Designer, Application Packages, Integration Broker, People Code, Application Engine, ExceltoCI, Data Mover, Security, SQR, PS Query, DB2

PeopleSoft Technical Analyst

Confidential

• This project was about Compass PeopleSoft HCM Enterprise Absence Management 9.0 implementation.
• Worked as a team member and involved in development of interfaces and enhancements.
• Involved in development of new enhancement for purchasing module using SQR.
• Developed an outbound interface for purchasing module using Integration Broker.
• Developed an inbound interface for Project Costing module using Integration Broker.
• Created users, roles and permission list for users by using maintain security.
• Created custom reports by using SQR in Purchasing module.

Environment: PeopleSoft Financials/SCM AP, PC, GL, Inventory, purchasing 9.0, People Tools 8.49, Application Designer, People Code, Component Interface, Application Engine, ExceltoCI, Data Mover, SQR, PS Query, Oracle 10g/11g

PeopleSoft Technical Consultant

Confidential

• This project involves PeopleSoft Financials 8.9 Implementation, Enhancements and Support.
• Enhancement Lead for the team of 2 people in offshore.
• Developed multiple inbound interfaces for below components in purchasing module using Component Interface, File layout and Application engine along with custom error handling

Requisition

Vendor

• Developed an interface which loads the data into Requestor Component using ExceltoCI.
• Worked on Accounts Payable, Purchasing and General Ledger modules.
• Involved in meetings with Business Teams and Users while configuring new GL/AP/PO business unit definitions.
• Worked along with functional Team in fixing and troubleshooting problems in designing and development.
• Developed custom audit application on custom PeopleSoft AP, PO applications.
• Implemented workflow in purchasing module which should get approval from the approver.
• Involved in customization of existing pages using People Code using dynamic view and dynamic prompt concepts.
• Involved in migration process of objects between Development, QA, UAT and Production environments
• Worked on PS Query, to get information as required by the client for reporting purpose.
• Developed queries to run through Query Manager for report reconciliation using

PS Query.

• Involved in knowledge transfer and training.
• Involved in resolving issues raised during SIT/UAT.
• Involved in modification and fine-tuning of Application Engine, SQR programs.
• Involved in PeopleSoft application security design in Accounts Payable, Purchasing
• Custom applications.

Environment: PeopleSoft Financials/SCM AP, purchasing, General Ledger and EProcurement 8.9, People Tools 8.48, Application Designer, Application Packages, People Code, Component Interface, Application Engine, ExceltoCI, Data Mover, Security, SQR, PS Query, Workflow, Oracle 10g/11g

PeopleSoft Technical Consultant

Confidential

• This project involves PeopleSoft Financials 8.8 Implementation, Customizations and Support in following modules Accounts Payable, Project Costing, Inventory, Purchasing and General Ledger.
• Developed multiple outbound interfaces which generates file with data from Payables and purchasing modules using File Layout and SQR
• Generated Custom SQR process to import data from 3rd party system into PeopleSoft inventory
• Involved in modifying delivered SQR process in purchasing module as per customization requirements provided by business users.
• Implemented query security on custom tables which are used in PS queries for reporting purpose.
• Created new PS queries which involve custom tables along with providing query security as per client's request.
• Worked on People Code customizations using dynamic view and dynamic prompt in Accounts Payable and Purchasing modules.
• Worked as a team member and involved in development and customization of reports.
• Understanding the requirement documents and prepared technical specification, test plans and test cases.
• Review of code changes, test procedure, test plans and other deliverables.

Environment: PeopleSoft Financials/SCM AP, purchasing, Project Costing and General Ledger 8.8, People Tools 8.44, Application Designer, People Code, Component Interface, Application Engine, Data Mover, Security, SQR, PS Query, Workflow, Oracle 9i/10g