We provide IT Staff Augmentation Services!

Lead Oracle Ebs Technical Consultant Resume

2.00/5 (Submit Your Rating)

Charlotte, Nc

SUMMARY:

  • 9 years of experience in the Oracle EBS implementing ERP systems primarily usingPL/SQL, Workflow Builder, Developer 2000/6i/9i/10g, SQL* Loader, Discoverer, XML publisher and Oracle Applications.
  • Good understanding of data flow in the different modules of Oracle Applications.
  • Good understanding and knowledge of the Apps data model, which helps in all aspects of development cycle such as building Custom Reports, data validation, data import etc.
  • Successfully completed 4 Full life cycles projects with Oracle Applications 11i (11.5.10, 11.5.8, 11.5.6 and 11.5.4) and recent experience in R12.
  • Strong experience in system study, business requirement analysis and business process analysis.
  • Extensive Experience in Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets (FA), Cash Management (CM), E Business Tax (eBTax), Project Accounting (PA), Advanced Global Intercompany System (AGIS), Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Purchasing (PO), Order Management (OM), Advanced Pricing, Service Contract, Record to Report and AOL modules.
  • Proficient in Procure to Pay (P2P), Order to Cash (O2C) cycles.
  • Involve in Implementation, customization of several Oracle Financial Applications, Data mapping of Oracle functionality with Business requirements, historical conversions, interfaces and customizations.
  • Expertise in preparing AIM(Application Implementation Methodology) Documents and User Manuals Functional Specification Document (MD050),Technical Design Document (MD070/CV060) and Conversion Mapping Document (CV040)
  • Integration of Modules and Business rules along with Setups, Standard and Custom Interfaces, custom reports and other customizations in Oracle Applications have been successfully implemented using strong technical and functional understanding of modules.
  • Technically proficient in RICEF (Reports, Interfaces, Conversions, Extensions and Forms) methodologies including Implementation, Interfacing, Conversion and Data Migration, experience in up gradation to Oracle Apps 11i.
  • Hand on experience in P2PCycle in end to end as per technical.
  • Production Support on Oracle modules covering: Procure to Pay (P2P), Oracle General Ledger (GL), Oracle Advanced Collections, and System Administrator.
  • Assist in implementation of Oracle Financials (P2P, GL and Advanced Collections) across the organization.
  • Experience in generating Standard, Discoverer6i/9i and XML publisher reports.
  • Expert inOracleApplication Framework (OAF) applications, customization ofOAFpages, extension and creation of newOAFpages in JDeveloper 9i and 10g environment.
  • Expert in requirement gathering, design and development of custom applications inOracle Applications Framework (OAF) environment.
  • Responsible for Managing and coordinating test sessions like Conference Room Pilots (CRP) and User Acceptance Testing (UAT)
  • Work on helping teams adopt Acceptance Test Driven Development (Requirements By Example or Behavior Driven Development)
  • Experience with test automation tools like QTP, JIRA, Load Runner and Quality Center
  • Work on coaching others including task based mentoring and one on one Coaching, especially entry level employees.
  • Involve in Unit Testing and System Testing.
  • Work closely with Developers team for different issues
  • Test new enhancements for a Business Process
  • Involve End - to-End testing for business process using all application tiers.
  • Involve in troubleshooting issues on Auto Import Program for all the import process including Invoice, Requisition, Receipts, Asset, Inventory, etc.
  • Experience in Forms9i/6i/4.5i creation, customization and personalization and registering them as concurrent programs in oracle applications by using Application Object Library (AOL).
  • Well versed with client server environment & tools like SQL*LOADER, TOAD and WORKFLOW BUILDER.
  • Identify product gaps, coordinated with Development Team by creating Service Requests (SR) and obtained one-off fixes. Managed and monitored SRs for several P1 Issues. Provided on site solutions and resolved showstopper issues.
  • Experience with ticketing systems (Jira) and agile development board.
  • Strong communication skills with ability to manage expectations of Business and IT users. Possess good organizational, analytical and problem solving skill.

TECHNICAL SKILLS:

ERP Software: Oracle Applications R12.2.5, 11.5.10,11.5.9,11.0.5 Order Management, Purchasing, Inventory, Bill of materials, Work in Process, Advanced Pricing, Shipping, Purchasing, Cash Management, General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets, General Ledger, HRMS, Payroll, INFOR.

E-Business suit modules: GL, AP, AR, AGIS, EBTax, SCM,PO WSH, INV, OM, Record to Report HRMS, SYSADMIN

Databases: Oracle 11g/10g/9i/8i,SQL Server, MS Access 2003.

Languages / others: C/C++,Java,PL/SQL, SQL / Unix Shell Scripting

Oracle Tools: XML/BI Publisher, Oracle Forms / Reports 6i/10g, SQL Loader, SQL Plus, SQL Developer, Toad, Oracle Workflow Builder, Noetix views, APEX, JDeveloper,Cloud IO.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC.

Lead Oracle EBS Technical Consultant

Responsibilities:

  • Design, documented (MD050, MD070, CV040) and developed Staging tables, Conversion routines, Custom PL/SQL API’s for converting
  • eveloped and customized Financial Modules (AP, CM, GL, AR, PO, OM), Interacted with end users to gather requirements and Draft specifications for development Phase.
  • Technically proficient in Order-to-Cash (O2C) and Procure-to-Pay (P2P).
  • Strong Domain knowledge in various business flows including Financial Modules like Account Receivables, Account Payables, Order to Cash (O2C) and Procure to Pay (P2P) cycles.
  • Developed Extensions to custom business flow from Order management, install base to service contractfor raising credit memos and invoices in AR.
  • Implemented Advanced Global Intercompany System (AGIS) for all the 46 countries to have Intercompany Transactions with any of the Entities.
  • ConfigureOracleR12 FA, AR, AP AND EBTax to include integration withVertexand the TCA setups.
  • Designed, developed and documented an inbound interface for AP Invoices from windows-based applications.
  • Assisted client in design customization of the process to interface invoices, from legacy systems, to Oracle AP.
  • Worked on Auto Lockbox Interface Account Receivable module for automatically processing receipts that are sent directly to the bank instead of manually feeding them in Oracle Receivables.
  • Designed documented and developed interface Cash Management module for uploading Bank statements.
  • Enhancing the COPS (Change of Project Status) Process to integrate with Iprocurement in order to change the project status to over budget when the requisition commitment amount is greater than budget amount.
  • Personalized page to enable submit button on the train flow of iProcurement page
  • Designed and Developed Custom Reports,(Customer, Vendor, Sales Order, Purchase Order, Aging Reports) as per the user requirement using Oracle Apex (Application Express) 3.2
  • Customized the workflow for Fixed AssetFAAccount Generator Process "TRU Generate Default Accounts" with new custom settings for UK instance.
  • Worked on the issue where the drill-down from the GLto the Fixed AssetFASub-Ledger was not available. (Found bug in the Oracle Standard system).
  • Worked on the development of Interfaces, Data Conversions,developing new Forms, Reports, Customizing Oracle Reports in Order to Cash Cycle touching various modules such asGL, AR, FA, CM, OM.
  • Handling daily tickets related to various user problems in FA, AP, AR, GL and CE modules.
  • EB-TAX Rate Analysis: Provided a solution to the Tax team to understand and comprehend the tax rates provided byVERTEXand uploaded every month. This solution helps the team to understand the increased, decreased tax rates along with any Jurisdiction and name changes
  • Participated in all the phases of the Parthenon interface Process development involving analysis, design, development,testingand deployment of the project.
  • Actively participated in planning project backlogs, 2-week sprints and daily stand up meetings to analyze the time frame and report the status of the project.
  • Involved in making the detailed Project Test Plan regarding the scope and focus of the testing (TE 10), Test Strategies
  • Written standard Integration test scripts forOracleFinancials, Order to Cash and Procure to Pay Modules.
  • Act as a Test liaison between business users and technical team.
  • Customizations, Personalization's and Extensions on Contracts Workbench Administrator web page usingOracleApplication Framework as per client requirements.
  • Created custom page using OA Framework to view AP invoice History.
  • Created Test Scripts (TE040's) for UAT sessions.
  • Prepared project deliverable such as requirements gathering documents, future business mapping documents, SanitytestingResults, Data collection Templates, User acceptancetestingand obtained business user signs off.
  • Involved in design and developing all the packages, procedures, trigger and custom DB objects for the project.
  • Created a newOAFscreen for production tracking of Batches, Resources inOAFProcess Manufacturing (OPM) module.
  • Extension of Sub-Inventory transferOAFscreen to issue Billet Items (Finished goods) in BOM (Bill of Materials).
  • Used Oracle Apex (Application Express) 3.2 to query the data and developed packages, procedures, and functions
  • Designed, Documented and Developed inbound interface between 3rd party payroll system Ceridian and oracle General ledger for importing the journal entries, using Shell script, SQL*Loader, PL/SQL package and populated the data into the GL interface and developed a PL/SQL API to run journal import concurrent program and send an email notification to a group of people.
  • Developed AR invoices batch report using XML/BI Publisher. Created Data Definition Templates, rtf templates and split the xml file using bursting feature in XML Publisher reports.
  • Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report and consolidation journal report in General Ledger
  • Developed Custom Reports for Billing History by Client, Invoices by Client Report and Projects NDR Report using Discoverer 4i.
  • Designed and developed new Form using TEMPLATE.fmb for Purchase Returns irrespective of Purchase Order Number.
  • Did forms personalization to make view only forms.
  • Customized the Accounts Payable (AP) Vendor Entry Form as per business requirements.
  • I have been the SME for supporting the Oracle EBS suite modules: GL, AR, AGIS, CM, eBTax, AP support for month-end close and on-going support lead
  • Module focus: GL, AP, AR, CM, TCA, Inventory, EBtax/Vertexintegration, iExpense, SLA, FAH, and AGIS.
  • Was working for Receivables, iReceivable, Cash Management,eBtax, Subledger Accounting, Advance Collections and Bill Presentment Architecture as part of product support team.
  • Created new users, new menus, new responsibilities, registered concurrent programs and request sets.
  • Did daily support to financial department to fix everyday tickets, month end and quarter end closing. Created service requests (SR/TAR) with metalink.
  • Oracle EBS suite support, OTC,AGIS, EBTax, P2P,RtoR Lead SME for system and end-user errors and issue that arise from day to day activities.
  • GL financial model support lead, support and month-end close SME.
  • Used FNDLOAD to download and upload AOL data (request groups, menus, forms, functions; responsibilities; flex field value sets; users) from one instance to another instance.

Confidential, Samsung, CA

Sr. Oracle EBS Technical Consultant

Responsibilities:

  • Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.
  • Developed and customized Financial Modules (GL, AR, AP, PO), Interacted with end users to gather requirements and Draft specifications for development Phase.
  • Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.
  • Strong Domain knowledge in various business flows including Financial Modules like Account Receivables, Account Payables, Order to Cash (O2C) and Procure to Pay (P2P) cycles
  • Implementing, Customization ofOracleE Business Suit (EBS). Strong in SCM (INV, PO, OM) andFinancials (AP, AR, GL), Procure to Pay (P2P), Order to Cash (O2C), internal sales order, dropshipment, back to back cycle.
  • Designed service contract API's program and data mapping from Siebel to Oracle.
  • Designed the Install Base, service contract Concurrent Program, Executable, Request set, Values Sets and Report (RDF) file, shell script and PLSQL programs for applications.
  • EBTax: We performed system configuration for multiple tax regimes
  • Involved EBTax performed Self-Assessment setup for different countries - process included requirement analysis, design and implementation
  • Performed upgrade activities related to EB-Tax andVertexintegration.
  • Have extensively worked on implementations of EB-Tax withVertex/Sabrix Integrations.
  • Responsible for running Receivables open interface, imported data into RA interface tables and used the Auto Invoice to import the customer invoices.
  • Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
  • Extensively worked on EB-Tax integrations withVertexand Sabrix/Thomson Reuters OIDT.
  • Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
  • Strong Oracle RICE development experience in all AP, AR, GL, PO and OM Modules.
  • Implementation of oracle Applications (PO, AP, INV, iProcurement, iExpenses and AR)
  • Oracle On-Demand; Modules: PO, IProcurement, OM, INV, Discrete Manufacturing and Quality and numerous 3rd Parties’ Software.
  • Responsible for converting the entire Historical Purchase Orders (PO) using Import Standard Purchase Orders into Production.
  • Responsible for converting all the Historical Purchase Order Receipts using Receiving Transactions Processor into Production.
  • Designed, developed and documented an inbound interface for AP Invoices from windows-based applications.
  • Did Consolidation setups for Consolidation set, Consolidation, segment rules in General Ledger Module throughout global companies
  • Responsible for providing production support for Account Receivables (AR) and Account payables (AP).
  • Designed, documented and developed Bank Reconciliation interface to Oracle Cash management Interface.
  • Responsible for running the Open Interface to import data from OM interface tables into the base tables.
  • Involved in Implementation of iProcurement module and Customization of interfaces in this Module.
  • Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.
  • Creating staging tables required for loading the legacy data and loading the staging tables with the legacy data using SQL Loader.
  • Developed Item Master Conversion program using Item Interface inOracleInventory (INV).
  • Worked on Open Item Interface to convert Purchased Item Information from Custom Purchasing System toOracleInventory (INV) module.
  • Developed Invoice Custom Form in AP usingOAF.
  • Modified the HRMS (Hire, Re-Hire, and CWK Hire) Self Service Pages to include the Costing information on the Review Page usingOAF.
  • Developed a PL/SQL program, which reconciles the Reply Bank file data (Lockbox) and calls Receipt API to reverse the receipts for which credit card status is declined.
  • Prepared project deliverable such as requirements gathering documents, future business mapping documents, CRP Scripts, SanitytestingResults, Data collection Templates, User acceptancetesting, obtained business user sign off
  • Facilitate CRP (Conference Room Pilots), SIT (System IntegrationTesting), and UAT (User Acceptance Testing).
  • Worked on different customization of pricing and quoting modules during implementation
  • Handling daily tickets related to various user problems in FA, AP, AR, GL, CE,and eBTax modules.

    Environment: UNIX, Oracle Applications (R12) - AP, AR, Purchasing, GL, FA, Cash Management, OM, INV, TCA, Procurement (iProcurement, iSupplier Portal, Purchasing, Payables), Work Flow, Oracle Approvals Management (AME), OA Framework, Oracle 10g, Forms 9i, Reports 9i, Discoverer 4.1/9.0.2, XML publisher, SQL*Loader, PL/SQL developer, UNIX, Java, JDK, J2EE, TOAD.

    Confidential

    Oracle Techno Functional Consultant

    Responsibilities:

    • Designed and developed an interface custom package to create and Update vendor/vendor sites implementation according to BR, which is not provided by standard API’s.
    • Communication from legacy to Oracle applications were established through IBM MQ series using data contracts, which were signed off for both parties integrating the applications.
    • Designed and developed the Reconciliation process for GL module.
    • Performed Standard Functionality testing in AR, AP, GL, FA, Cash Management, i-Expense, E-Business Tax and Sub Ledger Accounting
    • Was involved in Standard Functionality testing in Phase I and Phase II for 3 instances.
    • Tested Multi-Org Setups as a result of the new Parts Operating Unit that is being introduced as part of the upgrade to Release 12.
    • Involved in Unit Testing and System Testing.
    • Documented and communicated test results to the Test Management and Business Management Team
    • Provided hands on training to business user community for Post- Production support issues & daily and month-end closing of accounting periods for GL.
    • Written 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.
    • Strong Oracle RICE development experience in all AP, AR, GL, PO, INV and OM Modules.
    • Did Consolidations setups for mapping set, mapping, segment rules in General Ledger throughout global companies.
    • Setting up system for foreign currency translation and re-evaluation performing financial consolidation of multiple currency set of books.
    • Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
    • Developed PL/SQL Procedures for Customer interface in Accounts Receivables (AR).
    • Analyzed, developed, configured and tested the UHG customer model into the Oracle 11i TCA (Trading Community Architecture) framework.
    • Responsible for creating an interface for Purchase Order upload, which creates PO from a CSV file.
    • Written PL/SQL packages with cursors, functions and procedures for inserting the data into vendors, invoices and purchase orders interface tables from various staging tables while validating the data.
    • Prepared Technical Specification (MD70) documents.
    • Responsible for running Receivables open interface, imported data into RA interface tables and used the standard API Auto Invoice to import the customer invoices.
    • Analysed requirements of the client for various legacy applications that needed migration and integration with Oracle Applications.
    • Prepared high-level and low-level designs for bridging and migrating data to AP, AR and PA modules.
    • Created shell scripts to load data into staging tables of expenditures, tasks, events and projects of project accounting using SQL*Loader direct path.
    • Worked on Inbound and Outbound programs for passing the Picked lines to the 3rd party system and shipping the records sent from 3rd party system back to Oracle.
    • Created test scripts for every level of testing from unit testing stage to integration testing.
    • Oracle EBS suite SME for support for system, end-user issues and month-end system support

    Environment: Oracle Applications - AP, AR, GL, OM, PO, INV, Service Contracts, Work Flow, Oracle 10g, Forms 9i/6i, Reports 9i/6i, SQL*Loader, XML Publisher, BPEL, PL/SQL developer, TOAD, Java.

    Confidential

    Oracle Techno Functional Consultant

    Responsibilities:

    • Implemented Oracle Financials 11i Account Payables and Project accounting for a large distribution network of a major apparel company.
    • Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.
    • Worked on Oracle API bug in Supplier Sites Open Interface Import, causing all the legacy data to be rejected because of duplicate Vendor Site Code.
    • Responsible for converting the entire Historical Purchase Orders (PO) using Import Standard Purchase Orders into Production.
    • Responsible for converting all the Historical Purchase Order Receipts using Receiving Transactions Processor into Production.
    • Responsible for converting all the Historical Invoices using Payables Open Interface Import into Production.
    • Written an API for Converting the Invoice Payments and was able to convert all the Historical Invoice Payment History into Production.
    • Wrote PL/SQL packages/procedures to retrieve order-booking data, based on the search criteria entered in the OA Framework based search screen.
    • Handled the implementation stages for EDI, Financials, Purchasing and setting up the interface for Order Management system.
    • Worked with interfaces from AP to PA (Project Accounting).
    • Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.
    • Customized various reports by adding new fields as per the business requirements.

    Environment:Oracle Applications 11.5.9 (11i) - PA, AP, AR, GL, OM, PO, TCA, iProcurement, OA Framework, Work Flow, Oracle 9i, Forms 6i, Reports 6i, XML publisher, SQL*Loader, PL/SQL developer, TOAD, Java.

    Confidential

    Developer

    Roles & Responsibilities

    • Development of Forms based on Procedures/Views etc.
    • Usage of Dynamic Execute Immediate statements to fetch data as needed.
    • Performance Tuning of the entire Application to the best throughput.
    • Loading Data into Multiple Database environments using PL/SQL Packages.
    • Wrote Stored Procedures/Functions and Packages to meet the Rate Structure.
    • Developed a lot of Tree Screens like Object Navigator to display hierarchical data representation dynamically for easy use by the Underwriters.
    • Developed a Common Screen, which includes 100 sub-screens to minimize the user navigation process.
    • Developed screens for enrolling the Groups and Dropping Existing Groups.
    • Developed Complex screens for Renewal of Groups from year to year and their claims history.
    • Wrote number of Packages and Procedures to support the Rate Screens such as Rate Packages, Prospective/Renewal Packages.
    • Wrote Database Triggers as needed to meet business functionalities.
    • Extensive use of Oracle Advanced Queues to communicate data between Multiple Applications.
    • Used Database Level Triggers such as LOGON/LOGOFF/DATABASE STARTUP, and DDL Triggers to track Schema activities.
    • Developed various Reports to meet the customer needs.
    • Used SQL * Loader to populate Oracle Tables from data flat files.
    • Web based Development using 9iAS, Forms 4.5 and Reports 2.5.

    Environment: PL/SQL, Oracle Forms 4.5, Reports 2.5, UNIX, SQL Navigator, SQL* Loader

We'd love your feedback!