SUMMARY

• Over 8 years of experience as an Oracle Applications R12/11i (E Business Suite) Technical consultant, with expertise in Oracle Financials modules(GL, AP, AR, PA,FA, PROCURE TO PAY and Cash Management, Order to cash),ManufacturingModules(OM, INV,PO,BOM), iProcurement, Purchasing,iExpenses, Shipping
• Expertise in implementingRICE(Reports, Interfaces, Conversions, Extensions) components in the area of technical design, development, Integration testing and deployment.
• Excellent knowledge ofAOL(Application Object Library) andSystem AdministrationModules and Property manager.
• Expertise in configuring iPayment module with payment systems
• Expertise in developing and customizing Reports and Forms inOracle E - Business Suite R12/11i,Oracle 11g/10g/9i/8i, Discoverer 10g/9i/4i/3i,Oracle Reports/Forms 10g/9i/6i/4.5/2.5, XML Publisher 5.6.3/5.6.2.
• Expertise in design and development ofInterface/Conversionprograms to import data from legacy systems and integrate it into Oracle Applications using open interfaces andAPIs.
• Experience inCash Management, iProcurement, Purchasing, PO,iExpenses
• Extensively worked on changing the reports according to client requirements and Optimizing the Report Performance.
• Extensively worked onOracle Discoverer(Desktop, Administrator, Plus, Viewer), which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL) Business Areas.
• Knowledge on OAF and ADF doing customizations Design and developed user interface components usingADF Rich Faces.
• Substantial development experience in creatingstored procedures, Packages, Triggers, Functions, Indexes and Views.
• Setup of Cash Management, General Ledger, Account Receivables, Accounts Payable, Purchasing and Cost Management
• Worked on Advanced PL/SQL Concepts (PL/SQL Tables, Record types).
• Good working knowledge in designing technical documents using AIM Methodologies (MD50, MD70, TE20ANDMD120).

TECHNICAL SKILLS

• Oracle Applications E-Business Suite (Version R12 11.5.3 to 11.5.10 Release 2)
• Account Receivables
• Account Payables
• General Ledger
• Inventory
• Order Management
• Cash Management
• Purchasing
• Project Accounting
• Application Object Library (Application Developer / System Administration)
• Operating Systems
• UNIX ( Confidential
• Solaris
• AIX) and Windows
• Oracle Developer 6i (forms and Reports)
• Oracle PL/SQL and SQL
• RDBMS:
• Oracle 8/ 9i /10g
• Quest’s TOAD
• Oracle’s SQL* PLUS
• SQL Loader
• Java
• Work Flow Builder 2.6.3
• Forms6i
• Reports 6i
• JDeveloper 10g
• XML Publisher
• SOAP
• XML
• CSS
• HTML
• Javascript
• SQL Navigator
• Oracle Discoverer Administration 4i/10g
• Oracle Discoverer Desktop 4i/10g.

PROFESSIONAL EXPERIENCE

Confidential, KEENE, NH

Oracle E-Business Developer

Responsibilities:

• Involved in Customer Conversion To load Customer Details by creating staging tables and performing validations and loading into base tables
• Designed and developed User Interfaces in ADF to import chart of accounts from BAAN system and transfer to GL in Oracle E-Business Suite.
• All screens were attached to Oracle E-Business menu for easy access. Extensively worked in performance tuning, security, deployment
• Developed OAF page for Item Recall Implementation
• Developed Custom Interface to load INV adjustments and PO receipts from External system
• Developed Sales order Conversion
• Worked on Order Import Interface to load Header and line details into base tables and developed Conversion Mapping Documents
• Worked on development of Interfaces, Data Conversions, Developing New forms, Customizing Standard reports in Order to Cash and Procure to Pay and various modules such as INV, OM, Shipping
• Developed Pick-Slip report
• Designed and developed an Item Conversion to Import Legacy inventory item data
• Developed Package-Slip Report
• Custom Forms Development for Item Backhaul
• Developed Custom Interface For generating Customer Statements and Shell script to load the data into UNIX architecture
• Schedule reports and bursting as per the requirement in BI Publisher
• Setting up new payee and payment system, linking accounts to GL module for cash management
• Designed solutions to enhance standard oracle flows for Procure to Pay(P2P), Assets to GL
• Participated in providingProcure-to-Pay (P2P)life cycle support.
• Executed process enhancements for application capabilities.
• Researched invoice discrepancies and monitored payment status of accounts
• Developed Packages, Procedures and PL/SQL programs for data conversion and data validation, converting legacy data to client system
• Responsible for developedOAF Data Controlsfrom Web Services and Java Components
• Design, Implement and Test Oracle ADF applications using JDeveloper 11g
• Responsible for Baseline configurations for Accounts Payables, Accounts Receivables, Cash Management
• Developed TE 40 Script and UAT debugging, designed test cases and completed end to end testing

Environment: Oracle E-Business Applications R12, Oracle Applications 11.5.8, PL/SQL, BI Publisher, OAF, Forms, Reports, UNIX

Confidential, Sunnyvale, CA

Oracle E-Business Developer

Responsibilities:

• Customized PO Approval workflow process using Workflow Builder and define processes based on the purchasing amount and ship to location.
• Developed custom Workflows for tracking service requests, and notifying users about the status of these service requests
• Implemented multi-org financial systems using Oracle E-Business modules such as GL, AR, AP, and CE
• Withholding Taxes, Withholding taxes with accounts range and zero payment Invoice in AP module
• Configured Oracle Payments with the Cyber Source for various credit card payments.
• Configure Financial Options and Payables Options in AP.
• Setting up new payee and payment system, linking accounts to GL module for cash management
• Designed workflows for approvals in AP, Purchasing and PO
• Set-up of invoices, debit and credit memos, guarantees, deposit transaction types
• Worked extensively on IAW(Invoice Approval Workflows) in AP.
• Designed solutions to enhance standard oracle flows for Procure to Pay(P2P), Assets to GL
• Participated in providingProcure-to-Pay (P2P)life cycle support.
• Executed process enhancements for application capabilities.
• Researched invoice discrepancies and monitored payment status of accounts
• Designed/Developed AP Invoice Interface to import open AP Invoices from legacy systems to Oracle Payables on periodic basis.
• Developed Packages, Procedures and PL/SQL programs for data conversion and data validation, converting legacy data to client system

Environment: Oracle E-Business Applications R12, Oracle Applications 11.5.8, PL/SQL

Confidential, Houston TX

Senior Oracle E-Business Consultant

Responsibilities:

• Worked extensively on AP, PO, iProcurement, IExpenses modules and Oracle Property manager
• Played key role in developing Invoice Approval workflows in AP.
• Worked on AP Invoice Conversion for one time conversion of historical AP Invoices from Release 11i to Release 12 of Oracle Payables.
• Maintained Lease information and adding recurring invoice details into AP and AR and transferred them to GL module
• Setting up automatic payments and scheduling payments for each lease
• Used oracle property manager for Payment expirations in event notification while using workflows
• Used reporting manager for standard enquiry windows in reports and developed reports using PM
• Developed workflows and automated it using property manager for raising Events and sending notifications
• Viewing status of the process flow In Property Manager
• Integrated with other modules like AP,AR,GL
• Worked on GL Conversion for one time conversion of GL Journal Entries from Release 11i to Release 12 of General Ledger module.
• Developed AP Vendor Sites Report for printing the vendor sites information using XML Publisher.
• Developed Payment Format Document using XML Publisher for AP format payments process.
• Provided technical support and assistance to team members working on other deliverables for the project.
• Involved in performing setups for Oracle Financial modules.
• Prepared test cases and performed unit/integration/system testing.
• Created MD50 and MD70 documents for all the deliverables for project.

Environment: Oracle E-Business Applications Release 12/ Release 11i, Oracle Forms/ Reports, PL/SQL and XML Publisher

Confidential

Oracle E-Business Applications Analyst

Responsibilities:

• Participated in various meetings with functional team and legacy system management to gather user requirements regarding reports and other customizations and in corporate those requirements into Oracle applications features.
• Creating Test documents with all shell scripting files involving in migration of various files using FNDLOAD.
• Successfully troubleshoot performance issues of Oracle Apps R12.1.2, and this is my third case of successful performance tuning of Oracle E-Business Applications.
• Developed SQL * Loader programs to load data from flat file to stage tables. Written PL/SQL procedures to validate and load the data into the Oracle Interface tables or directly into the Oracle base tables for the respective modules.
• Interacted with end users and functional architects for mapping the legacy data to the Oracle tables.
• Worked on Order Import to import open orders from Legacy system.
• Implemented the Payables Open Interface. Activities involved creation of Loader File, importing Invoices into the AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE interface tables using SQL*Loader and then using Payables Open Interface to import the data into the Base tables.
• Debugged the custom interface betweenProject AccountingPAandReceivables AR.
• DevelopedPL/SQLscripts to load data from external system to Account payables Interface tablesand developed asset interface
• DevelopedSQL*Loadercontrol programs and PL/SQL validation procedures to load legacyGL Code Combinationsinto Oracle General Ledger.

Environment: Oracle E-Business Applications R12, Interfaces

Confidential

Oracle Applications Consultant

Responsibilities:

• Worked extensively in financial modules - General Ledger(GL), Accounts Payables (AP), Accounts Receivables (AR).
• Worked on Supplier conversion from legacy system to Oracle Payables.
• Worked on Revenue Recognition Interface from Oracle Receivables to third party system.
• Worked on Purchase Order report customization using XML publisher.
• Developed XML Publisher report for AR customer invoice.
• Customized AR receipts form to change the ordering of fields in LOV.
• Data Conversion from legacy system to assets in FA interface.
• Developed the AP invoices conversion program, loaded the data from flat file to the staging table using SQL * Loader and did all the necessary validations before loading into AP INVOICES INTERFACE, AP INVOICE LINES INTERFACE tables,
• Designed and developed PL/SQL process with validations to convert all legacy suppliers into AP/PO.
• Documented test cases and scenarios.
• Supporting custom interfaces to maintain an uninterrupted data flow between legacy systems and E-Business

Environment: Oracle Applications 11i (Oracle Applications 11.5.10), Oracle Forms/Reports and Pl/SQL.