Summary

• Lead Oracle EBS Techno-Functional Consultant with over 12 years of experience in providing IT solutions in implementing Oracle Enterprise Business Suite.
• Expertise in Financials, Supply Chain and Manufacturing SCM , Procure-to-Pay P2P and Order-to-Cash O2C of Oracle EBS 11i R12. Good Knowledge of Multi organization Access control MOAC architecture and Sub-Ledger Accounting SLA .
• Successfully managed onsite and offshore teams and lead delivery of technical components and coordinate and communicate status, issues and delivery plan.
• Extensive experience in Oracle Applications Modules Account Payables AP ,Account Receivables AR , General Ledger GL , Fixed Assets FA , Purchasing PO , iProcurement ICX , Inventory INV , Order Management OM , Advanced Pricing QP , Bill of Materials BOM , and Project Accounting PA .
• Worked extensively on Trading Community Architecture TCA and Multi-Org Environment.
• Expertise in Design, Development and Customization of RICE Reports, Interface, Data Conversions and Extensions/Customization using SQL, PL/SQL, UNIX Shell scripts and SQL Loader.
• Experience in developing custom forms in oracle applications using Oracle Application Framework OAF technology.
• Experience in development and customization of forms in Oracle applications using standard AOL functionality and CUSTOM.pll and Template.fmb. Extensive experience using Oracle Forms 10g/6i and Reports 10g/ 6.0 and BI XML Publisher.
• Experience in creating SOA components like DB Adapters, File Adapters and also integrating with third party sources using BPEL processes.
• Involved in performance tuning in oracle using Explain plan, Auto Trace and Tkprof.
• Experience in preparing AIM document like MD050, MD070 MD120.

Project Profile

Confidential

Lead Oracle Functional Consultant

Roles and Responsibilities

• Played multiple roles in the project including that of a business analyst, a technology and database consultant, a workflow and apps developer, a team lead, owner of the workflow change and release management.
• Converted last 2 yrs.legacy GL Journal Balances from multiple markets into R12.
• Developed custom validation program and Import program for AP Suppliers, Sites, Contacts Supplier Bank Conversion.
• Importing Sales Orders from Legacy system into Oracle using Sales Order Import Interface.
• Developed PL/SQL procedures, for SOA interfaces, to validate and import them into Oracle EBS. Import all the Book Orders to Oracle EBS and initiate the order fulfillment process.
• Developed a custom interface to create unapplied receipts for all the commission balances that are due and apply the commission receipt against available invoices.
• Designed and developed a custom OAF Data Entry Form and a Search Page integrating with oracle applications.
• Designed a custom OAF Error Corrections Form for various different custom interfaces in Oracle for easier error corrections.
• Customization of Order Management OEOH Standard Workflow to close the Sales Order in 1 Day after the lines is closed. Apply Custom Holds on the order, when payment method conditions are met or when a payment typeACH was selected.

Oracle Applications R12.1.3 AP, AR, GL, PO, OM, QP, OPM, Forms 10g, Reports 10g, Workflow, Oracle Application Framework OAF , SOA, BI XML Publisher, Oracle 11g, TOAD, SQL loader and IBM-UNIX

Confidential

Lead Oracle EBSTechno Functional Consultant

Roles and Responsibilities

• Gathered requirements for various RICE elements from the Business users and created technical design documents.
• Managed onsite, offsite teams and software partners. Ensure that functional specifications are conceived well by offshore team, and transformed into clear and concise technical specifications and code development.
• Developed custom program to identify and convert legacy accounting segments to new accounting segments in R12.
• Converted legacy GL Journal Balances and JE Lines to R12.
• Developed custom validation and Import program for AP Suppliers, Sites, Contacts Supplier Bank Conversion.
• Converted Open Purchase orders and receipts using custom validation and import program.
• Developed custom validation and Import program for open AP invoices.
• Designed a custom OAF Error Corrections Form for various different custom interfaces in Oracle for easier error corrections.
• Preparation of Audit validation reports for the each of the conversion elements.
• Managing CEMLI Conversion program development and deliveries. Addnew functionality to the developed CEMLI's.
• OAF extension in iProcurement to display new project shared region within the Requisition Approval Notification Page.

Oracle Applications R12.1.3 PO, AP, GL Forms 10g, Reports 10g, Workflow, BI XML Publisher, Oracle Application Framework OAF , Oracle 11g, TOAD, SQL loader and IBM-UNIX

Confidential

Lead Oracle EBSTechno Functional Consultant

Roles and Responsibilities

• Gathered requirements for various RICE elements from the Business users and created technical design documents.
• Developed Financial Statement Generator FSG reports using BI XML Publisher.
• Developed Project Costing Project Billing reports using BI XML Publisher.
• Developed reconciliation reports using Oracle reports 10g and BI XML Publisher on modules AP, AR, GL, FA, PO, PA modules to facilitate the users in validating the interfaced data.

Confidential

Lead Oracle EBSTechno Functional Consultant

Roles and Responsibilities

• Gathered requirements for various RICE elements from the Business users and createdtechnical design documents.
• Managed onsite, offsite teams and software partners. Ensure that functional specifications are conceived well by offshore team, and transformed into clear and concise technical specifications and code development.
• Performed migration of Purchase Requisition and Purchase Order using SQL Loader and Oracle Interfaces.
• Responsible for the creation and evaluation of Oracle custom solutions to support specific business requirements, for example, AP Trial balance report customization and automation, Employee SSN Conversion.
• Developed custom validation and Import program for AP Supplier Conversion.
• Conversion of Item On-hand balances.
• Developed an interface to transfer Inventory Transactions to General Ledger.
• Has very good experience in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively.
• Build multiple new RTF templates for Standard Purchase Order, Blanket Purchase Agreement and Release Blanket and attach to the respective operating units using BI XML Publisher.
• Customized AP reports Aging Report, iExpense report, Exceptions Report using BI XML Publisher.
• Developed Project Costing Billing reports ProjectTransactionsReconciliationReport, Project StatusInquiryReport, Projects Roll Forward Report using BI XML Publisher.
• Customized FSG reports using GL Wand.
• Developed integrated test plans, test cases and documenting testing specific documents. Prepared Unit, Integrations and User Acceptance Test scripts test data for various cross functional business processes.
• Assist training department with preparation of training materials and train key business users on the business solutions.

Oracle Applications R12.1.2 AP, AR, GL, FA, PO, PA, INV, OM Forms 6i, Reports 6i, BI XML Publisher 10.1.3.42, Oracle 10g, TOAD, SQL loader and IBM-UNIX

Confidential

Oracle Apps Techno Functional Lead

Roles and Responsibilities

• Played multiple roles in the project including that of a business analyst, a technology and database consultant, a workflow and apps developer, a team lead, owner of the workflow change and release management.
• Prepared the TDD Technical Design Document based on the FDD Functional Design Document .
• Assisted in the functional design and setups for finance modules AP, AR GL.
• Developed an interface to upload journal data from various applications ADB, PeopleSoft, and KRONOS into General Ledger and prepare an error report.
• Developed a conversion program to convert fixed assets from legacy system FACE into the Oracle Fixed Assets.Developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validations.
• Developed Vendor conversion program to import vendors from the legacy system PeopleSoft into Oracle with required validations.
• Performed migration of Purchase Requisition and Purchase Order using SQL Loader and Oracle Interfaces.
• Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
• Developed an interface to transfer Inventory Transactions to General Ledger.
• Develop various PL/SQL packages for use by the entire development team to meet generic requirements like Mailing, Excel File generation etc.
• Experienced in Vertex integration with EBS for Sales Tax and Receivables.
• Develop loose integration between systems using Standards Oriented Architecture SOA concepts
• Customization of OAF pages, extension and creation of new OAF pages.
• Customized 'PO Printed Purchase Order Report' according to the business requirements using BI XML Publisher.
• Developed Negative AR Aging Report with aging buckets forecasting future revenues. This was a 2 in 1 report with Summary and Detail Formats using BI XML Publisher.
• Customized AR reports Print invoice report, invoice aging report, Dunning Letters using BI XML Publisher.
• Developed custom Financial Statement Generator FSG reports to accommodate elimination and conditional logic using BI XML Publisher.
• Developed reconciliation reports using Oracle reports 10g and BI XML Publisher on modules GL, AP, PO, FA, PA modules to facilitate the users in validating the interfaced data.
• Analyzing the change requests whether the scenario is feasible and helping the team in incorporating the Change Requests.
• Preparations for R12 pre-upgrade activities include analyzing various changes and new features of Oracle E-Business Suite R12 that affect custom business flows and application customizations.

Oracle Applications 11.5.10.2 R12 AP, AR, GL, FA, PO, PA, INV, OM, WIP, BOM Reports 10g, BI XML Publisher, Oracle Application Framework OAF , Oracle 10g, TOAD, SQL loader and IBM-UNIX

Confidential

Oracle EBS Technical Lead

Roles and Responsibilities

• Hands on participation in each and every phase of the project starting with requirement gathering, feasibility study, database designing, application designing, design reviews, actual development, application testing, documentation, end user training and finally ongoing application support
• Interacted with end users and functional architects for developing Conversion mappings of legacy data to Oracle tables.
• Developed an interface to upload the journal data into the Oracle Application's General Ledger, developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validations.
• Developed an API for Converting the Invoice Payments AP and was able to convert all the Historical Invoice Payment History into Production.Written an Interface for Account Payables AP Invoice Upload, which creates invoices from a CSV file.
• Developed PL/SQL Procedures for Customer interface in Accounts Receivables AR . Responsible for creating an interface for Purchase Order upload, which creates PO from a CSV file.
• Developed Conversion program to import Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data
• Created custom alerts when Account Status in customer profile is changed.
• Developed reports in AP, AR, GL, PO modules using BI XML Publisher, Reports 6i.
• Created several Requests and Request Set to attach the PL/SQL procedures, SQL Loader routine and Reports with Application.
• Created test scripts for every level of testing from unit testing stage to integration testing.

Oracle Application 12.0.6 AP, AR, GL, PO , Oracle11g, TOAD, SQL loader and FSG

Confidential

Oracle EBS Technical Lead

Roles and Responsibilities

• Gathered requirements for various RICE elements from the Business users and created technical design documents.
• Developed an interface for monthly import of journal entries from payroll running on a legacy system by using the journal import interface provided by Oracle General Ledger.
• Worked on creating new GL Payables Open Interface Import to create invoices from external systems into AP Invoice tables.
• Run Journal Import in General Ledger GL to load the data into Oracle application tables.
• Developed customer conversion into TCA.
• Designed TCA Interfaces/APIs to successfully convert legacy data into Oracle Applications using Oracle's standard Open Interfaces and APIs.
• Designed and developed Travel Voucher process using Oracle AP interface.
• Developed the Notification mail using workflow.
• Developed FSG reports using BI XML Publisher to give department managers a high level view of their current operating revenue and expense categories compared to their budgets using FSG.
• Developed multiple oracle form personalization to enforce business rules.

Oracle Applications 11.5.10.2 AP, AR, GL , ADI, Forms 6i, Reports 6i, Oracle Discoverer, Oracle 9i, TOAD, SQL loader and IBM-UNIX

Confidential

Senior Technical Consultant Team Leader

Roles and Responsibilities

• Gathered requirements for various RICE elements from the Business Users and created technical design documents.
• Extract the GL Balances from old Legal Entity and upload into excel in ADI format. Load as a Journal in the new LE using Web ADI.
• Developed a custom item interface program for loading legacy items information into Inventory Item Interface tables, by validating items according to their predefined item categories and category sets.
• Developed SQL Loader files to load data from legacy system into the Account Receivables AR staging tables for importing Customer data.
• Converted Invoices from Legacy System into Oracle Receivables using Auto Invoice Import program.
• Migrating Resource Cost and Average cost from Source Organization to Destination Organization.
• Validating Price List data in the staging table and populates into the interface tables.
• Developed concurrent programs and scheduled jobs as per the requirement

Oracle Applications 11.5.10.2 GL, AP, AR, INV, OM, BOM , Web ADI, Oracle 9i, TOAD, SQL loader

Confidential

Senior Technical Consultant

• Given Estimation for the Technical Components, Preparation of Technical Specification using MD50, Worked on custom stored procedures using PL/SQL, Preparation of test cases Design, Construction and testing, Unit testing of the modules that are developed.