PROFESSIONAL SUMMARY:

• Over 8 years of extensive IT experience in Analysis, Design, Development, and Implementation of Client-Server and ERP Applications.
• Over 7 years of experience in Upgrade, Support, Customization and Implementation of PeopleSoft Financials 9.1/9.0/8.9/8.8/8.4 General Ledger, Account Receivables, Account Payables, Asset Management, Project Costing, Contracts, Billing, Grants and Expenses , SCM Order Management, Inventory , eProcurement and Purchasing .
• Demonstrated experience in analysis and documentation of various PeopleSoft Security.
• Procedures and Maintenance as per Sox compliance Sarbanes-Oxley compliance .
• Expertise in PeopleSoft Development tools Application Designer, Application Engine, Data Mover , Integration tools Integration Broker, Webservices, Component Interface, Business Interlink, Workflow , Administration tools Upgrade Assistant, Security, Tree Manager , and Reporting tools SQR, PS Query, nVision, Crystal Reports XML/BI Publisher .
• Working knowledge in Oracle, MS SQL Server, PL/SQL Triggers, Procedures and Packages.
• Excellent communication and interpersonal skills.

TOOLS/SKILLS:

• ERP: PeopleSoft Financials/SCM 8.4/8.8/8.9/9.0/9.1 GL/AR/AP/AM BI/EXP/PO/INV/OM
• People Tools: PeopleTools 8.4x/8.5x App. Designer, App. Engine, Integration Broker, Component Interfaces, People Code, Upgrade Assistant, Data Mover Work flow, Security, Tree Manager, Configuration Manager
• Reporting Tools: SQR, Crystal Reports, XML Publisher, PS/nVision
• Operating Systems: Windows 95/98/2000/NT/XP, UNIX, MS-DOS
• Databases: Oracle 9i/10g/11i, SQL Server 7.0/2000, Teradata
• Languages: C, C , Visual Basic 6.0, SQL, PL/SQL, HTML, DHTML, XML

PROFESSIONAL EXPERIENCE:

Confidential

• Designed and developed Departmental reports defined by combination of Business Unit/Operating Unit/Department
• Integration Broker: Developed Integration Broker Webservice and Asynchronous Messages for Loading of Receipts, AP Invoices, Customer, Product Updates
• AP: Configured the Matching Rules for Matching Vouchers with PO's and Receipts.
• AP: Configured the Workflow for Voucher Approvals, Journal Approvals and for Matching Exceptions.
• AP: Developed an Interface using SQR, which would help users to Load the External Voucher Data from spreadsheet into a flat file, so that it can be processed by the EDI manager, which is used to load the data into VCHR HDR STG, VCHR LINE STG and VCHR DIST STG tables
• Involved in troubleshooting Billing Interface process BIIF0001 and extensively used SQL to analyze the interface staging tables to correct the errors.
• Developed Custom Billing interface program, added functionality for Discounts and surcharges for custom invoices, per client requirement.
• Customized AR Aging summary report AR30002.sqr that's based on unit.
• Customized queries inside BIIVCEN.sqr when it's extracting from extract invoice tables before printing crystal reports like BIPRNT00 in Billing.
• AR: Involved in configuring, running, performance tuning and troubleshooting the issues. with Maintenance Worksheets , Transfer Worksheets, Reconciliation, Receivable Update, Payment Predictor and LockBox Processes.
• Involved in setting up the eProcurement Punch-Out process
• Working with users in customizing different modules to improve business functionality in Project costing, AM, AP, GL and Purchasing Modules
• GL Journals/Ledger Data Archiving: As a part of performance tuning the unused data in the Journal, Ledger, Voucher and Payment tables had to be archived and stored in history tables.
• Developed several GL SQR reports such as Daily Transactions by Dept, Daily Transactions by Account, Statement of Condition Daily, Monthly and Earnings reports Daily, Monthly .
• Customized APY2021- Check Copy Crystal Report so that it includes additional fields on the check copy.
• Customized the VCHR EXPRESS page in AP to incorporate the custom fields in all the different kinds of vouchers
• Assisted the users with Production support issues.

Confidential

• Developed a Departmental Manager Approval Setup Page by Chartfields for All Procurement AWE workflow routings. Implement Dynamic Prompts and Validation Code on these dynamic pages.
• Developed a custom Nightly process Application Engine, which will locate user ID's on different pages and assigns Specified roles to them every day.
• Fixed the AR PAYLOAD step that populated only the customer number and business unit as part of customer information, ignoring other fields.
• Customized the As incurred Revenue, As incurred Billing, Single Action Invoice Pages in Peoplesoft Billing and Contracts Module.
• Customized the Contracts to Billing Interface CA BI INTFC according to the client Requirements.
• Modified Delivered Application Engine PSQUERY for Schedule Queries, So that it will automatically send the resulting reports to their respective authorities as emails.
• AP Invoice Loading Process: Developed an App Engine to Load Several External Vendor Invoices on a Daily Basis into Voucher Staging Tables
• AP Positive Pay and ACH: Customized the Delivered FIN2025 SQR and POS Crystal report for the ACH and Positive Pay files with Banks
• Customized Aging Reports AR30001, AR30002, AR30003, AR30004 SQR'S and written a custom SQC that will email the reports to users.
• Assisted the production support front-end personnel in resolving issue in eProcurement , AR, BI, AP and GL Modules
• Customized the Application Engine GL EXCL JRNL, the journal import process, Journal generator to modify the default chart fields.
• Developed GL Interface that loads data from various external systems into PeopleSoft General Ledger using SQR
• Designed an inbound interface in Accounts Payable which loads the invoices sent in xml format by the vendors through the EDI 810.
• Designed inbound interfaces in Accounts Payable which loads the invoices sent in flat file format by the multiple vendors from different systems.
• Configured the Payment Terms , Entry Types , Letter Codes , Aging ID , Statement ID in AR module
• Customized BIIVCLN sqr process in billing to print invoices to take input as invoice amount and not just based on Business Unit and range selection
• Developed an SQR that will produce AM depreciation expense report for current period, year to date, and life to date.
• Data Conversion: Loaded the legacy GL Accounting entries into Peoplesoft GL using Application Engine Component Interface
• GL: Customized Journal Import Application Engine process for conversion of Journal entries from legacy system
• Fixed the AR PAYLOAD step that populated only the customer number and business unit as part of customer information, ignoring other fields.
• Written several SQR reports in AR/Billing Module
• Assisted the users while they tested a newly built Payment Remittance process and heavily modified AP Pay cycle process with the data they needed to test from Teradata database and making sure that those data are available in PeopleSoft tables as well.

Confidential

Project: Peoplesoft 8.9 to 9.1 Upgrade Project, Tools 8.51/8.52

• Worked on Estimates and Reapplying customizations for Peoplesoft 9.1 Upgrade
• Reviewed compare reports and analyzed what all customizations need to be reapplied for PO, GL, ePro, AP and Expenses modules
• Analyzed the New Inbound map VCHRBLD for EDI Loads for AP Payables .
• Customized the APY2021 Crystal for AP Accounts Payable
• Created custom Vendor Inquiry page according to the user requirements. Payables .
• Modified the delivered search for items in e-procurement according to requirements.
• Solved the issues in Workflow, in GL General Ledger , when the workflow is not being routed to correct people.
• AM: Modified the Application Engine Landed Cost Extraction to allow the applicable vouchers to process and create the appropriate landed cost entries.
• Fixed the AR PAYLOAD step that populated only the customer number and business unit as part of customer information, ignoring other fields.
• Loaded Journal entries from current legacy system into PeopleSoft GL module using Component Interface.
• Worked on Reporting in GL on Budgeting Taxation Reports Using SQR Crystal Reports.
• Written several SQR reports in AR/Billing Module.
• AM: Customized Application Engine to capitalize expenditure transactions to flow through PC AM process to Asset management.
• AM: Customized Asset Transaction Loader program AMIF1000 to load data into custom developed application of Asset Management.
• Contracts Interface: Written App Engine to create Bill Plan Events, Revenue Plan Events, Prepaids and Prepaid Bill Plans for provided Projects and activities
• Developed the requirements for tracking the reassignment history of worklist items.
• Involved in design, development and testing of Permission lists, users, Roles and assigned roles to users for diff Business units.
• Worked with Business Analysts to get the Business process information for the custom built pages and Custom Records for Query.
• Worked on T E workflow process and notified employees with automated email message.
• Purchasing: Implemented ASN Advance Shipment Notification and POA Purchase order Acknowledgement Process using the delivered Peoplesoft EDI
• Purchasing: Customized the POPO005 PO Dispatch SQR. Added New Customizations to Remove Schedule Line Totals, Print TAX amount only at the End of the PO Print Page n of m on the Top
• Developed a Billing Inbound Process using Application engine and File Layouts to Load External Bills into the Billing Interface Tables
• Fixed problems with Billing Finalization, Prebuilt, and Bildgl01.
• Fixed issues relating to PO Auto Change Process
• Customized the PO Approval Workflow process in Purchasing.
• Purchasing AWE Workflow: Implemented the new AWE Workflow for Requisition Approvals in 9.1 with Multilevel Approval by Amounts
• Resolved Billing and AR month end close issues.
• Modified invoice print programs for specific requirements.
• Developed a program to load Project Resource table from AR item tables.
• Environment: PeopleSoft FSCM 9.1 AP,GL,ePro, PO, Expenses People Tools 8.51/8.52, People Code, Application Engine, Integration Broker, SQR, Component Interface, Crystal reports, XML, STAT, Publisher, Oracle 11g, PS Query.
• Confidential
• Project: Maintenance 9.1 Modules: INV, AP, AR, GL, PO, BI, EX, PC, AM, ePro, Contracts, Treasury
• Wrote Technical Design Documents for different requirements using the Business Requirement Document. Developed the requirements according to the Technical Design Document.
• Worked on Item Inquiry and Corrected code to include all transaction groups and sort properly and include correct status.
• PO: Create Requisition Status report to display requisitions approved but not yet sourced to a purchase order schedule to run daily at 10a and 2p and deliver to Procurement's point of contact
• PO: Configured the Requisition Approval workflow to have 4 levels of approval
• PO: Setup ExceltoCI tool to load Items and Requester Profile and User Preferences
• PO: Developed Inquiry pages to show ASN and POA Information which will be navigated from Requisition life cycle.
• Inventory: Customized the INS6000 SQR Report
• Set up the eProcurement Approval workflow using AWE Approval Workflow Engine .
• Set up the Direct Connect Punch Out Vendors in eProcurement.
• According to the requirements, controlled dispatch of Purchase Orders from Procurement Contracts.
• Developed the App Engine, to load the Journal from a Flat file General Ledger .
• Customized the AP Payables VCHR EXPRESS component.
• Corrected the Journal Loading SQRs, in GL General Ledger , when Ledger went out of sync because of Audit Codes
• Solved the issue of giving the wrong accounts in the vouchers AP Payables and realized after the voucher is posted to GL.
• Customized the Regular entry voucher page in AP Payables to put some hidden fields so that a third party tools Imaging can use those fields to get the image of the invoice.
• Solved the issue when the Voucher Build in AP Payables went to No Success because of the zero amount divisor.
• The third interface, the monthly invoice file, was another custom-built application engine process which was created to load the Peoplesoft tables from the inbound file sent by the Vendor Company. This data was also processed through a set of verification and validation process before inserting into the appropriate Peoplesoft tables.
• Resolved the application engine payment predictor AR PREDICT issue for minimum underpayment write-off.
• GL: Customized Journal Import Application Engine process for conversion of Journal entries from legacy system.
• Developed functional and technical specifications which included mapping in GL for Journal entries conversion, Beginning balance conversion and Carry forward balances from legacy system.
• Involved in Query and Reports Security design, development and testing.
• Involved in generating Security and Auditing Reports at different Department-wise.
• Created Archive process to remove older MRPs from the MRP tables for Material Request Page.
• Modified the MRP Post code to mark MRP's with CI errors as Errored but continued processing of other MRPs in batch.
• Performance Tuning of the delivered code to run more efficiently for Requisition Inquiry page.
• Tuned the modified code SQR to run more efficiently for parts search page.
• Tuned the delivered code to run more efficiently for receipt load page.
• Involved in complex cross module Conversion of Contracts from Projects/Activities to 9.1 Contracts .
• Integration Broker: Configured Local node, remote nodes and setup the services and queues.
• Created Integration Broker to send the Voucher Information to IBM Imaging system.
• Responsible for supporting key financial processes such as Year-End/Month-end close, Combo edit rules, spreadsheet journal imports.
• Configuration of Integration Broker, defining Gateway, creating and configuring nodes for HR and Finance.
• Modified Report EXC9000 that which summarizes all payments by vendor, payment bank account, payment date, and employee ID.
• Environment: PeopleSoft FSCM 9.1, People Tools 8.51 People Code, Application Engine, Integration Broker, SQR, Component Interface, Crystal reports 9.0, XML ,STAT, Publisher, Oracle 11g, PS Query