Tools/Methods

• PeopleSoft Financials/HCM8.x /9.x GL, AP, PO, AR, AM, BI, PC, INV, Absence Management , Application Engine, Component Interface, File Layout,ExceltoCI, PeopleCode, Application packages, Integration Broker, Security,
• Data Archival Manager,
• Mass Changes utility,
• Process Scheduler, Workflow, Approval Workflow Engine,
• Data Mover, Tree Manager
• and EDI Manager
• SQR, Crystal Reports, PS/Query, XML/BI publisher
• Windows 9x/NT/2003 XP, UNIX
• SQL, SQR, PL/SQL,XML
• Oracle, DB2, and SQL Server
• Ultra Edit and TOAD
• AppWorx, Remedy Client

EXPERIENCE

Confidential

PeopleSoft Financials

• Customized existing mass update of open periods which reduces the time for Business Users while updating Financial accounting periods.
• Involved in Client Meetings for every new enhancement/Customization comes in PeopleSoft 9.1Application.
• Worked on production issues occurs at every Financial Month end and communicated with Business Teams and Users Effectively with updates while resolving issues.
• Developed a new sqr process which generates procurement information from new 3rd party system which will be used in AP EDI interface.
• Developed an SQR data conversion program to import payments from a third party system to Cash Management module for bank reconciliation.
• CustomizedAP check printing process using XML publisher.
• 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 Vendorcomponent 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.
• 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 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.
• 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.
• Designed the technical design documents and maintained entire document repository contains Test Case documents, Test Plan output, Backup/BackOut 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.
• 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

Confidential

PeopleSoft Financials Techno Functional Lead

• 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.
• Developed custom approval workflow engine AWE process in purchasing module as per the requirement given by Client.
• Worked on performance tuning of application engine programs.
• Worked on Upgrade Assistant tool as part of PS upgrade.
• Involved in Fine Tuning of Database Tables, which are used in Data Conversion.
• Items
• Requisition
• Purchase Order
• 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
• Preparation of Weekly status report for client update during the upgrade phase.
• Helped Team to complete Project Deliverables on Time.

Confidential

• 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.

Confidential

• 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.
• TunedSQR's performance

Confidential

• 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

Confidential

PeopleSoft Technical Consultant

• 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

Confidential

PeopleSoft Technical Analyst

• 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

Confidential

PeopleSoft Technical Consultant

• 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

Confidential

• 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