SUMMARY:

• Around 13+ of IT experience as Oracle E - Business Suite Techno Functional Consultant using ERP Package Oracle Applications.
• Having experience in Analysis, Design, Development, Data Conversion, Upgrades, Customization, Interfacing, Implementation & Supporting of business applications using Oracle Applications R12, 11i
• Extensive Experience is Oracle Applications Modules which include Account Payables (AP), Purchasing (PO), Project Accounting (PA), General Ledger (GL) and Account Receivables (AR)
• Profound knowledge in implementation, Migration, Customization and Production support of various EBS modules including Trading Community Architecture (TCA), Accounts Receivable (AR), Order Management (OM), Shipping (WSH), Advanced Pricing (QP), Inventory (INV), General Ledger (GL), Fixed Assets (FA), Oracle Projects (PA), Purchasing (PO), Account Payables (AP), Service Contracts (OKS), Install Base (IB), Bill of Materials (BOM), eBtax, XLA(Sub Ledger Accounting), HRMS and Application Object Library (AOL).
• Sound functional knowledge of Order to Cash (O2C), Plan to Manufacture (PTM) and Procure to Pay (P2P) life cycles
• Extensive work experience on Oracle Apps Modules which include Account Receivables, Advance Collections, I-Receivables, Accounts Payables, I-Expense, Purchasing, I-Procurement, I-Payments, General Ledger, HRMS .
• Experience in other modules like Fixed Assets (FA), Cash Management (CM), Oracle Incentive Compensation and Oracle Contracts (OKC) modules.
• Designed solutions to enhance standard oracle flows for Order to Cash(O2C), Procure to Pay(P2P), Assets to GL, Inventory, TCA, Credit Card.
• Developed Inbound and Outbound interfaces using SQL*Loader, UTL FILE, PL/SQL Packages and SOA/BPEL.
• Sound knowledge of Oracle Application tables, Schema, Interfaces, Application Program Interface (APIs) and MOAC.
• Documentation experience, keeping in line with the AIM Methodology (MD70, MD50, CV040, CV060 MD120).

TECHNICAL SKILLS:

ERP Applications: Oracle EBS (12.0.3) /11i (11.5.8, 11.5.9,11.510.2)/11.0.3

Methodology: Application Implementation Methodology (AIM)

Languages/Frameworks: SQL, PL/SQL, Java, JSP, JSF, OAF, ADF, HTML, XML, C, C++

GUI/Tools: JDeveloper 10g/9i, Forms 10g/6i, SQL*Loader, SQL*Plus, SQL Developer, Toad, VSS, PVCS, Forms Personalization.

Databases: Oracle 11g/10g/9i/8i, MySQL, MS Access

Reporting Tools: Reports 10g/6i, XML/BI Publisher, Oracle Discoverer 10g/9i, Workflow builder, Optio 7.8

Utilities: IE 5.0/5.5, Netscape 4.7/6.0, Mozilla, Putty, WinSCP

WORK EXPERIENCE:

Senior Oracle EBS Financial Consultant

Confidential, Los Angeles, California

Responsibilities:

• Customize and convert existing RDF reports that will run compatible as per the new multi-org structure and user requirement.
• Develop PL/SQL program that extracts and generate a flat file with the information from Stelplan. Automate the data load process from Stelplan by scheduling PL/SQL packaged procedure as a concurrent program.
• Develop Account Analysis report that shows current A/R balance, credit limit and past 12 months transaction history for the customer(s) defined in TCA. This report is being used by credit department in order to analyze the customer history and approve for higher credit limits.
• Resolved issues in embedded workflow of Order flow in OM module and had the modified workflow re-deployed in the instance.
• Customized Workflow Order routing process and Notification process based on the approval Hierarchies to notify the stake holders.
• Requisition approval process and order routing process validation logic has been customized using the custom functions at activity nodes on the standard workflow processes
• Created and customized reports using XML Publisher in OM, AR, AP and INV.
• Extensive Experience in OM API's like order creation, order updation and pricing.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Develop Open Purchase Orders report using XML that queries all Open PO's at header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.
• Create and define template and data definitions for Open Purchase Order repor
• Conditionally display company logo information based on run time parameters.
• Developed Sales by Customer Ship-To Location report that shows the sales information with corresponding order number, invoice number, Item number, and PO and customer ship-to location.

Senior Oracle EBS Financial Consultant

Confidential, Sunnyvale, California

• Worked on requirements gathering, gap mappings, and various functionalities in Purchasing and Payables.
• Handling of Functional and Technical Support issues across financial modules (AR, Advance Collections, AP, GL, Purchasing, FA, Trade Management and ‘I’ modules) from very high to low severity.
• Created “As-Is” and “To-Be” (Gap - Analysis documents) system documents to show the current state and future state processes and functionalities of the system.
• Coordination of RICEW design, development, testing and delivery with offshore team
• Developed functional designed documents (MD50’s) based on business requirements.
• Involved in implementation and testing of Oracle Applications Financial R12 GL, AP, AR and CM modules
• Developed test plans and scripts and conducted testing for quality assurance.
• Configured Gland AP modules in R12 Environment.
• Created and customized reports using XML Publisher in AR, AP and PO Modules.
• Created custom Shell scripts to handle the loading the data file into the custom tables and archiving of the data file.
• Oversaw mapping business processes to Oracle Financials modules and conducted functional analysis, requirements, definition, and Oracle Financials module configuration and testing; designed and operated financial reports through the use of Final Statement Generator (FSG) tool; and trained users on various processes, such as AP, AR, GL, and CM (Release 12) while creating a detailed user manual.
• Assisted the client with the functional aspects of upgrade from 11i to R12 in AR, AP, FA and GL from end to end process cycle, month end close and reconciliation activities

Oracle EBS Financial Consultant

Confidential, Sacramento, California

• Involved in requirements gathering, analysis, development, QA and post-production support.
• Performed GAP analysis to ensure that the requirements are captured properly. Worked with SQL Loader and PL-SQL Built in packages to convert legacy data into Oracle Applications as necessary.
• Played conversions lead/developer role to complete both master (Customers, Suppliers, Inventory Items and Employees) and transaction (Fixed Assets, Install Base, On hand Inventory and Cost, Open Receivables Invoices, Payables Invoices, Open Purchase Orders/Lines, PO Receipts, AR Receipts and GL journals) data conversion.
• Extensively worked on conversion, inbound/outbound interfaces and BI Publisher reports.
• Interacted with functional team, track leads and business team to complete the full conversion activity during SIT, UAT and Mock Conversion phases.
• Handling of other Functional issues across financial modules on a needy basis ( Receivables, Payables,, Purchasing, I-Expense and General Ledger )
• Administered business requirement definition and gap analysis, and defined business processes, setups, and test scenarios for Oracle Financial modules.
• Handled the application of Oracle Financials that automated accounts payable, accounts receivables, fixed assets and cash management
• Worked on SLA (Sub-Ledger Accounting) and TCA(Trading Community Architecture)rules to replace traditional transaction codes for generating multiple accounting representations for one business transaction.

Oracle EBS Developer

Confidential, Los Angeles, California

• Single point of contact for the Business System Analysts and End users for gathering all requirements for Canadian Implementation of Oracle EBS (AR,AP,I-Procurement and I-Receivables).
• Performed fit/gap analysis, per-production business testing, conference room pilot support, interface/conversion mapping, and related documentation (including BRD and BR100s) for financial modules AR and AP.
• Functional Design for Customization of I-Procurement/I-Receivables Pages and End to End Testing.
• Functional / Technical analysis of existing business process flows
• Development of custom Oracle reports using Reports 6i and Oracle Discoverer.
• Prepared Module Design technical documentation MD070
• Development of custom BI Publisher templates.
• Develop Account Analysis report that shows current A/R balance, credit limit and past 12 months transaction history for the customer(s) defined in TCA. .
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of new Invoices.
• Implemented E-Business Sales Tax forUS - Regime to Rate flow with Rules and Exceptions and Self assessment Tax
• Assisted the client with the functional aspects of upgrade from 11i to R12 in AR, AP, FA and GL from end to end process cycle, month end close and reconciliation activities

Oracle EBS Developer

Confidential

• Responsible for the support of financial systems, including Consolidation, Inter Company journals of Oracle ERP
• Manage the monthly, quarterly and annual financial closing process in conjunction with the different support teams.
• Work closely with the region finance managers to support the system requirements of the Finance Organization.
• Responsible for the implementation of the Financials modules like GL, AP, AR & CE. The role includes all tasks from business requirements gathering to user training and go-live / ongoing support.
• Implementation of setups and configuration of Oracle Financials 11i GL, AR, AP and CE for AR Lockbox, Inter-Agency funds transfer, cash/funds position and forecasting processes.
• Configured setups of iExpense, iSupplier & iProcurement Setup employee user account, default expense account and expense report templates for iExpenses.
• Worked on integration of CE module with AR and AP module for reconciliation.
• Provide implementation and post implementation functional support for the Oracle eBusiness Applications suite Oracle 11i.
• Provided Business consulting, testing and training on the Oracle GL application.
• Collecting of business requirements, studying current business process.
• Translate business and functional needs to development teams in a technical-wise aspect.
• Setting up and configuration of Oracle Financials modules like GL, AR, AP.