SUMMARY OF EXPERIENCE

• 8 years of comprehensive experience with PS Applications in designing and delivering solutions to clients across multiple industries.
• Two full life cycle Implementation, Upgrade and Support of PeopleSoft Financials solutions covering all the major modules including Accounts Payable, General Ledger, Billing, Purchasing, Accounts Receivables, Inventory, Travel and Expense, Asset management, Purchasing and Order Management across multiple industries.
• Excellent technical skills of People Code, People Tools, Application Engine, Component Interface, and Integration broker, Workflows, Application Packages, PS Query, SQRs, Crystal Reports, XML Publisher and N-vision.
• Excellent hands-on experience in PL /SQL, SQL loader utility and UNIX Shell scripts.
• Experience in software development methodologies, design and implementations.
• Involved in addressing the issues related with PeopleSoft Security related to Users, Roles, Permission Lists, Password related, Object and Query Security.
• Worked on various Customizations, Interfaces, and Data Conversions.
• Domain experience includes Banking, Financial, Logistics, Manufacturing and Restaurant domain.

SKILLS SUMMARY

• Functional Modules: PeopleSoft Financials Accounts Payable, General Ledger, Billing, Purchasing and Accounts Receivables, Order Management, Inventory, travel and Expense 9.x/8.x/7.x
• PS Technical : Application Designer, People tools, PeopleCode, Query designer, Application Engine, File Layouts, Integration broker, Component Interface, Workflow, Process Scheduler, Tree manager, EDI Manager, Data Mover
• Reporting: PS Query, SQRs, N-vision Crystal Reports, XML Publisher
• RDBMS: Oracle 9i/10g, SQL Server
• Languages: HTML/DHTML, VBScript, JavaScript, PL/SQL, UNIX Shell script
• Version control: VSS, PVCS, STATS
• Operating Systems: Windows XP, UNIX
• Third party tools: Toad

PROFESSIONAL EXPERIENCE

Confidential

PeopleSoft Techno Functional

Projects:

• 1 PeopleSoft Upgrade from Version 9.0 to 9.1
• 2 9.1 Support

Modules: General Ledger, Accounts Payable, Accounts Receivables, Billing, Travel and Expense.

Responsibilities:

• Developed Interfaces with the existing legacy system for AP and GL.
• Involved in implementation of new functionalities
• Voucher spreadsheet upload through integration broker and EXCEL to CI assets upload OFAC
• Analysis and implementing workflow in several financial areas like Requisition approval, Purchase Order Approval, Journal Approval and Voucher Approval.
• Applied Patches and Bundles to AP, AR, GL and Billing application modules.
• Developed a custom process to load the expenses data from third party system.
• Customize the expenses entry and detail pages as per the business requirements.
• Resolved technical and functional issues during application of bundles and patches.
• Involved in customization of Records, Pages, Components and Menus.
• Configuring the Integration Broker local nodes and third party nodes.
• Retrofitted customizations in financials.
• Modified the AR Dunning App Engine Extract AR DUNNING for adding more fields on the dunning letter AR33001 .
• Developed many reports using PS/Query.
• Modified the pay cycle process AP APY2015 .
• Customized Journal Entry Detail Report, FIN2001 to show only correct chart field values.
• Created an interface to load data from flat file into the PeopleSoft Journal Header JRNL HDR and Journal line JRNL LN tables in GL.
• Involved in creating interface reports both Inbound and Outbound using Application Engine to send and receive data from third party applications.
• Involved with functional team in fixing and troubleshooting problems in designing and development.
• Set up Integration Broker services such as gateways, nodes, services and service Operations etc for automatic updates between HR and FIN application.
• Worked on correcting errors in the drafts on the draft staging table and create draft control records in Accounts Receivables.

Confidential

Peoplesoft Techno Functional

Projects: PeopleSoft 9.1 Financials Implementation and Support

Modules: Billing, General Ledger, Accounts Payable, Accounts receivables

Responsibilities:

• Involved in technical and online support in various stages of development to production environments.
• Involved in troubleshooting and fixing bugs in Accounts Payable and General Ledger.
• Design and Development of AE programs for converting existing legacy flat files to PeopleSoft Financials application database tables.
• Prepared conversion strategy and used AE and Data Mover to load the data from legacy system to the PeopleSoft.
• Developed a Component Interface to load data from flat file to PS BI HDR, PS BI LINE tables.
• Used File layout, Application Engine and component interface to load data from legacy system into PeopleSoft financials application database tables.
• Wrote an AE program to print the details of the customers who failed to pay the dues within last six months in AP.
• Modified the GL Chart Field Maintenance Pages as per the client's requirement by adding an additional field by name Comments.
• Developed an interface program to fetch all direct POs including Change Orders, Cancellations from legacy system to PS system.
• Modified the GLS7002 report in GL to get the ledger balances for a combination of both multiple and single periods.
• Modified the AR STMTS App Engine and crystal reports to get the required fields for the statements that are populated in the temporary tables during processing.
• Involved in creating a custom process in payment cycle to create a new status and Modified the people code behind the pay cycle manager component to add the new status to the process.
• Modified the AP MATCHING process to develop a report which gives a list of vouchers that are matched and not match.
• Developed reconciliation reports to reconcile the data sent to GL from AP, AR.
• Fixed the AR UPDATE step which did not insert the values in PENDING ITEM when an item is created through a payment worksheet.

Confidential

PeopleSoft Techno Functional

Project: PeopleSoft 9.0 Financial Maintenance and Support

Modules: Accounts Payables, Accounts Receivables, General Ledger, Billing

Responsibilities:

• Responsible for identifying, modifying and re-developing SQR programs, Crystal reports, PS queries and people code programs to be compatible with newer version.
• Modified AR33001 dunning letter and created new Queries for the newly created dunning letters.
• Developed AE program to populate the data from other sources to Receivables pending tables.
• Modified pay cycle manager component as per customer requirements.
• Involved in the setup of the bank replacement rules in the pay cycle process AP APY2015 to replace bank accounts automatically for payments.
• Involved in developing the business analysis Queries and reports like General Ledger activity and Employee Expenses report using the capabilities of Business Objects reporting capabilities.
• Worked on various Customizations, Interfaces, and Data Conversions Using SQR.
• Modified the Travel and Expense entry page to add client specific expense type included the new expense type in the delivered code.
• Modified and added new AP MATCH rules
• Modified the Accounts Payable vouchers page with more fields and description as per the client requirements.
• Customized attachments functionality in Peoplesoft
• Implemented workflow in AP and GL

Confidential

PeopleSoft Technical consultant

Project: PeopleSoft 9.0 Financials and Supply-chain

Modules: General Ledger, Accounts Payable, Accounts Receivables, Order Management, Inventory, Purchasing

Responsibilities:

• Created Application Engine programs and File Layout definitions such as writing data to a file, reading from flat file by adding new Sections, Steps and Actions through Application Designer.
• Worked on Tree Manager and PS Query for analyzing and reporting the applications.
• Assisted functional analysts and prepared data mapping for conversion and developed conversion strategy.
• Migrated PeopleSoft projects, RAN compare reports, created migration request, did code review for code created by other developers.
• Developed several new Report, Inventory Monthly Expense Report , Record recommendation Report , PO Accrual to GL report.
• Developed new SQR reports from scratch to identify the missing positive pay dates for the payment transactions.
• Worked on Inventory Replenishment process, picking, shipping, depletion process, PO calc, PO create, PO dispatch and other INV and PO processes.
• Modified the Inventory Packing slip report and Bill of Lading report to distribute to customers via email.
• Developed custom wrapper program that validates that chartfields before sending the data from INV to GL.
• Modified the PO Dispatch/Print process POPO005 SQR process with more details on the PO as per the client requirements.
• Created new codes and dunning letters and modified the Crystal templates and PS Query for the format of the letter and to retrieve the data.
• Used Import manager to load the data from flat files and Excel files in to PS tables.
• Involved with functional team to gather specifications and information in designing applications and reports.
• Converted Customer, Customer Contacts from Files extracted from Legacy system into PeopleSoft using Application Engine, File layouts and Component Interface.
• Interacting with end users and technical resources. Troubleshooted AP, GL process issues. Sufficiently unit test all coded programs prior to migration to the Test environment.
• Customized the AP VCHRBLD App Engine to insert the voucher details in to the custom tables.

Confidential

PeopleSoft Technical consultant

Project: People Soft Financial Upgrade from 8.4 to 8.8 and Support

Modules: Billing, Accounts Payables, General Ledger, Accounts Receivables

Responsibilities:

• Customization for AR realized gain or loss calculation and accounting on settlement of foreign travel advance is added to reflect account code and control amount.
• Customization for Manual Check printing in Accounts Payables and AR.
• Involved in setup of Bank, Bank Accounts, Calendars, Time Spans, journal and Ledger templates.
• Customizations to billing entry and Voucher entry page.
• Interfaces to load master data such as Customer, Sub-customer, Vendor and Employee as well as to load Projects, Speed types, Speed Charts, Distribution codes, combination rule from external systems such as excel sheet into PeopleSoft systems.
• Used PeopleSoft EDI Manager for voucher upload process.
• Customization in Inter unit Journal approval Workflow.
• Setup the PO dispatch process using Integration broker.
• Done the SQL Tuning for the Inventory module where report was taking a long time.
• Moved the tree from one instance to another using Tree manager and Tree mover.
• Customized reports as per requirements such as Expense report and Cash advance report and Bank book report-GLS7005.