SUMMARY

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

TECHNICAL SKILLS

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, NJ

PeopleSoft Techno Functional

Responsibilities:

• Developed Interfaces with teh 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 teh expenses data from third party system.
• Customize teh expenses entry and detail pages as per teh business requirements.
• Resolved technical and functional issues during application of bundles and patches.
• Involved in customization of Records, Pages, Components and Menus.
• Configuring teh Integration Broker local nodes and third party nodes.
• Retrofitted customizations in financials.
• Modified teh AR Dunning App Engine Extract (AR DUNNING) for adding more fields on teh dunning letter (AR33001).
• Developed many reports using PS/Query.
• Modified teh 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 teh 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 teh drafts on teh draft staging table and create draft control records in Accounts Receivables.

Confidential, NC

Peoplesoft Techno Functional

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 teh data from legacy system to teh 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 teh details of teh customers who failed to pay teh dues within last six months in AP.
• Modified teh GL Chart Field Maintenance Pages as per teh 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 teh (GLS7002) report in GL to get teh ledger balances for a combination of both multiple and single periods.
• Modified teh (AR STMTS) App Engine and crystal reports to get teh required fields for teh statements dat are populated in teh temporary tables during processing.
• Involved in creating a custom process in payment cycle to create a new status and Modified teh people code behind teh pay cycle manager component to add teh new status to teh process.
• Modified teh (AP MATCHING) process to develop a report which gives a list of vouchers dat are matched and not match.
• Developed reconciliation reports to reconcile teh data sent to GL from AP, AR.
• Fixed teh (AR UPDATE) step which did not insert teh values in PENDING ITEM when an item is created through a payment worksheet.

Confidential, IL

PeopleSoft Techno Functional

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 teh newly created dunning letters.
• Developed AE program to populate teh data from other sources to Receivables pending tables.
• Modified pay cycle manager component as per customer requirements.
• Involved in teh setup of teh bank replacement rules in teh pay cycle process (AP APY2015) to replace bank accounts automatically for payments.
• Involved in developing teh business analysis Queries and reports like General Ledger activity and Employee Expenses report using teh capabilities of Business Objects reporting capabilities.
• Worked on various Customizations, Interfaces, and Data Conversions Using SQR.
• Modified teh Travel and Expense entry page to add client specific expense type included teh new expense type in teh delivered code.
• Modified and added new AP MATCH rules
• Modified teh Accounts Payable vouchers page with more fields and description as per teh client requirements.
• Customized attachments functionality in Peoplesoft
• Implemented workflow in AP and GL

Confidential, NC

PeopleSoft Technical consultant

Responsibilities:

• Migrated PeopleSoft projects, RAN compare reports, created migration request, did code review for code created by other developers.
• Assisted functional analysts and prepared data mapping for conversion and developed conversion strategy.
• Worked on Tree Manager and PS Query for analyzing and reporting teh applications.
• 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.
• Developed several new Report, Inventory Monthly Expense Report, Record recommendation Report, PO Accrual to GL report.
• Developed new SQR reports from scratch to identify teh missing positive pay dates for teh payment transactions.
• Worked on Inventory Replenishment process, picking, shipping, depletion process, PO calc, PO create, PO dispatch and other INV and PO processes.
• Modified teh Inventory Packing slip report and Bill of Lading report to distribute to customers via email.
• Developed custom wrapper program dat validates dat chartfields before sending teh data from INV to GL.
• Modified teh PO Dispatch/Print process (POPO005) SQR process with more details on teh PO as per teh client requirements.
• Created new codes and dunning letters and modified teh Crystal templates and PS Query for teh format of teh letter and to retrieve teh data.
• Used Import manager to load teh 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 andtechnical resources. Troubleshooted AP, GL process issues. Sufficiently unit test all coded programs prior to migration to teh Test environment.
• Customized teh (AP VCHRBLD) App Engine to insert teh voucher details in to teh custom tables.

Confidential, NJ

PeopleSoft Technical consultant

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 teh PO dispatch process using Integration broker.
• Done teh SQL Tuning for teh Inventory module where report was taking a long time.
• Moved teh 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.