SUMMARY

• Overall 16+ years of experience in Analysis, Design, Development, Testing and Implementation of Applications using Oracle Applications(EBS) and Oracle Development tools.
• Over 8+ years of Professional Oracle Federal Financials Functional experience in Purchasing, Account Payables, Account Receivables, and General Ledger modules in full - fledged support and involved in End-to-End Implementation projects
• 7+ years of Professional Oracle Techno-Functional Experience in Oracle Applications (EBS) R12/11i AR, AP, GL, PA, AOL, HR, CM, OE, FA, Supply Chain, Purchasing modules
• Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User Training, Supporting, Writing MD50, MD70 Documents, Multi-Org Experience, and Data Mapping.
• Extensive experience in Implementation of Interfaces, Data Conversions, Customizations, Migration and Providing Support for Oracle Applications using Oracle development tools like SQL*Loader, PL/SQL, API, TOAD, SQL*Plus, Discoverer, XML Publisher, Workflow Builder, Oracle Application Express (APEX), Oracle Forms and Reports.
• Experience in Forms Personalization’s, Alerts, Custom.pll, Web ADI, OBIEE, Hyperion, JDeveloper tools.
• Strong Programming Experience in writing Packages, Procedures, Functions, Triggers, Cursors. GL Accounting, SLA Accounting and Reconciliation expert. .
• Comprehensive understanding and experience in P2P (Procure to Pay), Order -To-Cash of SDLC
• Self motivated, successful in promoting effective working relationships.
• Excellent analytical, inter-personal and communication skills.

TECHNICAL SKILLS

ERP: Oracle Apps R12/11i - AP, AR, GL, PA, BE, FV, FA, HROrder Management, Inventory, Purchasing, iProcurement, Supply Chain, Cash Management.

PROFESSIONAL EXPERIENCE

Confidential, MD

Oracle Applications Functional support

Environment: Oracle Applications R12(12.2.3) AP, PO, GL, BE, HR, FV, AR, CM, PA, iProcurement modules, Oracle 10g, PL/SQL, Forms Personalization, Oracle Forms, Oracle Reports, Workflow Builder, Discoverer, Web ADI, FBIS, OBIEE, Hyperion, JDeveloper, Kintana, SQL*Loader, Data Loader, Toad, UNIX, Windows.

Responsibilities:

• Configured AP setups such as financial/payables options, payment terms, suppliers, suppliers site, bank accounts for the supplier, invoice holds and releases etc
• Worked on Purchasing Setups like Financial, Purchasing and Receiving Option, Definition of approval group/ assignments, setting up the approval hierarchy etc.
• Worked on CR and IR issues with the supporting opdivs.

Confidential, MD

Oracle Applications Sr. SME

Environment: Oracle Applications R12(12.1.3) /11i (11.5.10) AP, PO, GL, BE, HR, FV, AR, CM, PA, iProcurement modules, Oracle 10g, PL/SQL, Forms Personalization, Oracle Forms, Oracle Reports, Workflow Builder, Discoverer, Web ADI, FBIS, OBIEE, Hyperion, JDeveloper, Kintana, SQL*Loader, Data Loader, Toad, UNIX, Windows.

Responsibilities:

• Working as an Oracle Applications support with exposure to Implementation, development support, R12 (12.1.3) upgrade assistance and UAT testing and Extensive involved in Post-Production support and assisted day to day business activities
• Configured AP setups such as financial/payables options, payment terms, suppliers, suppliers site, bank accounts for the supplier, invoice holds and releases etc
• Worked on Purchasing Setups like Financial, Purchasing and Receiving Option, Definition of approval group/ assignments, setting up the approval hierarchy etc.
• Implemented Cash Management Module and worked on SF224 and 6652 processes.
• In depth knowledge on PO Requisitions, Purchase Order, PO Receiving, AP Invoices, AP Payments modules
• Worked on Requisition Approval Workflow process and added custom validation
• Experience in OBIEE reports implementation and support
• Worked on AR Invoices, Adjustments, and Receipts and support the DMCS process.
• Worked on new Employee setup and define approval hierarchy.
• Added new GL source names, categories, GL periods and custom setups. Worked on Web ADI to import transactions to GL module.
• Performed development/customization of forms and worked on Forms Personalization’s. Developed and customized standard custom RDF reports, Discoverer reports and FBIS reports
• Experience on federal financial accounting process, new CAN validation and mapping support. Worked on Reconciliation process and SubLedger Accounting (SLA) support
• Responsible for UDO process and reconciliation between the UDO and GL.
• Developed MACCS Interface program to upload the invoices information into AP module from the feeder system with the necessary validations.
• Worked on Etravel, HHS Grants, Hyperion modules and IDDA file process
• Prepared MD50 functional design document & MD70 Tech design for new developments

Confidential, Washington D.C.

Oracle Application Consultant

Environment: Oracle Applications 11i (11.5.9) (AR, AP, PO, GL, OM, INV, WIP), Oracle 9i, PL/SQL, TOAD, SQL*PLUS, SQL*LOADER, Reports 6i, Forms 6i, Workflow Builder 2.6, UNIX.

Responsibilities:

• Worked on Electronic Invoice Presentment Process (EIPP) Project, developed IC Print/ re-print invoices program on TCA.
• Worked on Consolidation and de-consolidation program for EIPP Project.
• Developed an interface program Invoice worksheet uploads for legacy system Invoice into the oracle applications with necessary validations.
• Implemented Interface program to import invoices using Auto Invoice in AR, performed validations of invoices.
• Written a program for after successful run the interface program the flat file to be moved in archive directory with date and time using shell script.
• Developed reports like Ship to report in Order Management, Item Shipment report, Inventory Reserve Report in Inventory, Developed in Excel.
• Created Functional setups Batch Source and Transaction Type for Auto invoice Program and Worked on Flexfields.
• Created Descriptive Flexfield Segments for Invoice Worksheet Load Program on Line Transaction Flexfields.
• Reviewed MD.050 functional document and prepared MD.070 tech design for the development work done.

Confidential, Fullerton, CA

Oracle Application Consultant

Environment: s: Oracle Applications 11i (11.5.10) (AR, AP, PO, OM, INV, WIP), Oracle 9i, PL/SQL, TOAD, SQL*PLUS, UNIX, XML Publisher, SQL*LOADER, Reports 6i, Forms 6i, Workflow Builder 2.6.

Responsibilities:

• Developed Workflow for customer adjustment approval notifications, which checks the manager limit for approval and sending status notifications to users and managers.
• Developed PL/SQL script to Import and Validate the Invoice data from the Legacy System to AR Invoices.
• Developed Alert Notification for change address and in-active of addresses of Customers.
• Worked on Custom.pll to added un-apply button for AR apply receipts.
• Developed AR Customer Profile conversion program for updating the Profiles and Collectors of Canada and US Customers, using the TCA APIs.
• Developed and Modified custom reports in AR Modules like Credit Card past due report, Report of unapplied credit memo by adjustor.
• Designed MD70 Technical Design Document.

Confidential, San Jose, CA

Oracle Application Techno-Functional Consultant

Environment: s:

Oracle Applications 11i (AR, AP, PO, OM, INV, WIP), Oracle 9i, PL/SQL, TOAD, SQL*PLUS, UNIX, Oracle Discoverer 4i, SQL*LOADER, Reports 6i, Forms 6i, Workflow Builder 2.6.

Responsibilities:

• Implemented changes to the custom interface (PL/SQL) that sends pick tickets from the OE/OM module (based on the delivery shipping model; WSH) to a vendor’s warehouse management system (WMS).
• Extensive architectural changes and enhanced error checking. Also enhanced the custom ship confirmation process which takes ship confirmations from the vendor’s WMS, and loads them into the standard Oracle Applications interface tables (Open Shipping Interface) so the data can be populated (via the standard Oracle API) into the OE/OM module. This process also includes custom code to store multiple tracking numbers.
• Prepared High-level Technical Design Document for AR Invoice Open Interface.
• Developed PL/SQL script to Import Invoice data Temp Interface tables to Actual AR invoices Interface tables.
• Developed PL/SQL package and program to extract the Hold Related Invoices information from legacy and imported into 11i base tables.
• Performed prerequisite analysis for customizing Workflow Process in Purchasing Module.

Confidential, IR

Oracle Applications Consultant

Environment: Oracle Applications11i ( AR, AP, GL, PO, OM, INV), Forms 6i, Reports 6i, Oracle 9i, PL/SQL, SQL*loader, oracle Discoverer 3i/4i, SQL Navigator, Toad, UNIX, Workflow Builder, Mainframes.

Responsibilities:

• Developed interfaces for importing legacy customers to the Customer interface tables after validating the customer data through PL/SQL validations in AR.
• Involved in loading of vendor data into oracle applications in AP.
• Customized existing forms in Payables, Purchasing and registered them and as well with the template.fmb.
• Developed several workbooks using the discoverer on PO, AP and AR modules.
• Involved in customization of workflow process in the purchasing module, appended new process and the notification.

Confidential

Oracle Techno-functional Consultant

Environment: Oracle Applications 11i (11.5.3), OM, INV, PO, AP, GL, AR/10.7SC, Oracle 9i/8i, PL/SQL, Oracle Discoverer, Workflow Builder 2.6, Developer/2000 6i, SQL*Loader, Toad, UNIX.

Responsibilities:

• Developed PL/SQL program to populate PO requisition interface table to import requisitions.
• Involved in Customization of Reports and forms in AR, PO, INV and AP modules.
• Customized order entry form to meet the business requirements.
• SYSADMIN Role: Defined Responsibilities and assigning it to users, defining Data Groups, Menu and Report security groups.
• Migrated Item Category Accounts form from Oracle Forms 4.5 to Oracle Forms 6i.
• Migrated Invoice validation report from Oracle Reports2.5 to Oracle Reports 6i.