Professional Summary:

• 8 Years of experience as Techno functional Consultant in PeopleSoft 8.3/8.8/8.9/9.1 Finance Accounts Payable, Asset Management, Project Costing, eProcurement, Purchasing, Accounts Receivable, Billing, Contracts, Expenses and General Ledger .
• High Expertise in People Tools - Application Designer, Application Engine, People Code, Application Package, Component Interface, File Layout, Security, Process Scheduler, Data Mover tool, XML Publisher, SQR, Crystal Reports, nVision and PS Query.
• Good understanding of PeopleSoft HRMS modules Payroll, Base Benefits, Self Service.
• Proficient in conducting business process analysis and user training, gathering requirements, analyzing them, creating functional technical design specifications and developing customizations.
• Expert knowledge in performing Upgrade tasks, developing Interfaces and converting migrating data.
• Good experience in Integrating PS applications with other PS applications as well as 3rd party vendors.
• Good hands on experience in trouble shooting the problems and improving the performance of application processes by Debugging, Tuning and Tracing.
• Good knowledge and hands-on experience on UNIX shell scripting.
• Thorough understanding of the Banking and Financial services and its different modules.
• Currently Leading PeopleSoft Financials Development team and coordinating with Users on the Daily Business Activities of the organization.

Areas of Expertise:

PROJECTS SUMMARY

Confidential

PeopleSoft Support Consultant

Roles and Responsibilities:

• Currently Leading the PeopleSoft Development team and coordinating with Users on the Daily Business Activities of the organization.
• Support and maintain the PeopleSoft Financial System Accounts Payable, Asset Management, Project Costing, Travel Expenses, Billing, Accounts Receivable and Purchasing for TMSW including all functional and technical tasks related to ongoing system stability special projects major enhancements and upgrades .
• Analyze and re-engineer current business processes by implementing strategic changes to streamline, automate and improve the overall function.
• Analyzing the user requirements for developing customized reports for end-user feasibility.
• Analyzing the query requirements of the Users and preparing Technical specifications and coordinating with Offshore Support team in developing the queries.
• Supporting the Functional team in running month-end and year-end reports and critical processes for the Organization.
• Conducted Requirements gathering to maintain and modify the existing PeopleSoft customized system.
• Handled change requests, defects and Impact analysis.
• Took up Issue Impact Analysis and monitoring the progress made towards issue resolution.
• Involved in the business meetings with the end users.

Confidential

PeopleSoft FPO Development

Roles and Responsibilities:

• Working with Upgrade and Implementation of PeopleSoft FSCM.
• Handling Business Process Workflows for the PeopleSoft Financials modules AR, BI, GL, AP, AM, PO, Contracts, PC, Travel and Expense in a technical capacity.
• PeopleSoft Development with PeopleCode, Application Engine, SQR, Integration Broker and Component Interface.
• Analyzed the requirements and created technical design documents for the retrofits as well as new customizations.
• Retrofitted various SQR programs related to General Ledger, Accounts Payable as per 9.1 upgrade requirements.
• Successfully ran Full Sync and Incremental Sync messages from PS Finance 9.1 to PS HCM 9.1 using Integration Broker.
• Working on designing developing a Custom Interface IB from PS Finance Labor Allocation to PS HCM using Integration Broker.
• Involved in Day-to-day interactions with the Users on the Project Costing and Asset Management Development requirements and Change requests.
• Working with Enhancement, Data Conversion and Interfaces.
• Developed various reports as per customer requirements using SQR, Crystal Reports and xml publisher.

Confidential

Roles and Responsibilities:

• Lead the Crucial Onsite Support team and coordinated with Clients, Users and Offshore members in regard with the Daily Business Activities of the Bank, relating to Project Costing, Asset Management and accounts Payable.
• Analyzing the user requirements for developing customized processes for such as capitalization engine, PPM upload to PC, and preparing the Detail level Design documents for the enhancements.
• Analyzing the query requirements of the Users and preparing Functional/Technical specifications and coordinating with Offshore Support team in developing the queries.
• Involved in a Reporting enhancement which is aimed at reporting data through PS Queries to the users from varied back grounds like PPM time sheet, ComSci, Project Costing, Asset Management and Accounts Payable.
• Design, developing and Generating/Modifying the Crystal, SQR reports, PS Queries, nVision.

Confidential

Roles Responsibilities

• Analyzing the requirements and understanding various possible approaches for creating a Logical Data model for an existing CRDW system.
• Actively involved in the project for providing the Reverse Engineering effort to obtain DDLs from PeopleSoft Application Designer which would be the input to Erwin and to draw relations between entities and to map User Defined Properties and Data Dictionary for different entities and attributes.
• Worked closely with Erwin consultants to understand the Erwin functionality thoroughly, in order to.
• Developed the 'CDM Relationship' Tool, to derive referential integrity for the tables present in CRDW. This tool was developed using Application Engines and People Code.

Confidential

Roles and Responsibilities:

• Lead the Crucial Onsite Production Support team and coordinated with Clients and Users in regard with the Daily Business Activities of the Bank, majorly involving General Ledger, Data marts.
• Analyzing the requirements and understanding the functionality of the Application Engines, People Code, Application Packages and both source and target systems and preparing the Detail level Design documents.
• Involved in a Reporting enhancement, which is aimed at reporting and development of logic for the bank's customized reporting purpose.
• Effectively used STAT 5.3.1 to migrate objects into different environments and helped various teams in creating archive sets.
• Developed various reports as per customer requirements using SQR, Crystal Reports and xml publisher.

Confidential

Roles and Responsibilities:

• Analyzing the requirements and understanding the functionality of the Application Engines, Application Packages and both source and target systems and preparing the Technical Design documents.
• Worked as a key developer in the project for automating the Testing Schedule using PeopleSoft Application Engines and Application Packages.
• Involved in the peer review of the test scripts.
• Handled new enhancements in the Automation to enhance the functionality to include the Ongoing and newly created developments.

Confidential

Roles Responsibilities:

• Analyzing the requirements and understanding the functionality of the Application Engines and both source and target systems.
• Prepared the Detail level Design documents after understanding the functional requirements.
• Actively involved in the Metadata Manager project for providing the Reverse Engineering effort through Automation to obtain inputs from the Application Engine trace files.
• Coordinated with the Requirements gathering team to design Excel-To-CI interface.
• Involved in the peer review of the scrubber results.
• Developed the 'Traceability' Tool, to eliminate the manual reverse-engineering process for deriving the Process List, Record List, Element List and Constraints List for all the PeopleSoft Application Engines used in the CRDW System. This tool was achieved using Application Engines, Application Packages and People Code.
• Developed new SQR Reports/Conversions/Interfaces.
• Handling change requests, defects and Impact analysis.

Confidential

Roles and Responsibilities:

• Involved in the preparation of test scripts for Asset Management, Accounts Receivable and Accounts Payable modules.
• Experience in PeopleSoft Finance including modules like Asset Management, Accounts Payable, Purchase Order, Accounts Receivable and General Ledger.
• Executed test cases in Account Payables module particularly dealing with Vouchers and Vendors, and Asset Management module relating to Capitalization of an asset.
• Involved in the development of batch processes that were used for posting of vouchers, closing of vouchers and payment processes.

Confidential

Roles and Responsibilities:

• Developed multiple SQR Reports and Troubleshooting Crystal/SQR Reports Problems for AP, GL, AR AM modules.
• Worked on Configuring Integration Broker with Third Party systems to load data Developed Application Class packages to validate data and store into people soft systems.
• Modified reports in Asset management which includes AMAS2000 Cost Activity AMDP2000 Depreciation Activity as per the client requirements.

Confidential

Roles and Responsibilities:

• Ran System Audit Reports to compare data structures defined in the People Tools tables against the underlying database to uncover inconsistencies.
• Used Data Mover custom and delivered scripts to export and import data between PeopleSoft databases.
• Involved in reviewing the customization, code review of reports like SQR's, Crystals, Application Engine for handling the PeopleSoft FIN upgrade. Reviewed changes for the process scripts to handle batch process and scheduling them.