We provide IT Staff Augmentation Services!

Oracle Apps Om Techno Functional Consultant Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • Oracle Applications Techno Functional Consultant with more than 13 years of development and Support Experience
  • Experience in Support, Upgrade, Development, enhancements, customizations and maintenance of Oracle Applications (R12 and 11i) in the modules like Order Management, Inventory, Oracle Purchasing, BOM, GL, AP, AR System Administration etc.
  • 2+ years of Experience leading Demantra Development/Upgrade projects
  • Strong expertise in Oracle Application RICE (Reports, Interfaces, Conversions, Extensions) development using the Development Suite/tools (like Forms, Reports, PL/SQL, Workflow, SQL*Loader, PL/SQL Developer, Toad, SQL*plus, UTL Files etc.).
  • Design and development of Order Import interface to import orders from legacy system
  • Developed R12 Items, customer, supplier and supplier bank accounts conversion scripts using interface/APIs
  • Strong in PL/SQL coding, advanced PLSQL concepts, Analytical function, Packages, stored procedures, Functions, triggers, bulk processing, dynamic SQL, table partition, multithreading, Data loading and performance tuning.
  • Very Good exposure to performance tuning, resolved performance related issues in multiple projects.
  • Design and Development of various interfaces, Forms and Reports, PL/SQL SOAP API for web service
  • Experience leading Onsite and Offshore teams and well versed with AIM - SDLC methodologies.
  • Good communication and interpersonal skills.
  • A highly motivated, energetic individual and a team player with excellent analytical & problem solving skills.
  • Willingness and ability to adapt to learn new technology and application.

TECHNICAL SKILLS

  • Oracle EBS R12 /11i, Demantra
  • (OM,INV,PO), Order to Cash Cycle, Demantra (GL, AP, AR)Languages/Frameworks
  • SQL, PL/SQL
  • Forms 10g/6i, SQL*Loader, SQL*Plus, SQL Developer, Toad, VSS, PVCSDatabases
  • Oracle 12c,11g/10g/9i/8i
  • Reports 10g/6i, XML/BI Publisher

PROFESSIONAL EXPERIENCE

Confidential

Oracle Apps OM Techno Functional Consultant

Responsibilities:

  • Oracle Apps Techno Functional Consultant for Confidential EDI Integration.
  • Development, Unit Testing and deployment of Order Management Interfaces, Service Contracts, Install Base and Account Receivable APIs, Reports and Forms for EDI Integration.
  • Development and End to End testing of Sales Order creation to Invoice Integration using EDI.
  • Development of Sales order API which does the loading of data received from Partners, validation of the data and call standard Oracle API to create Sales Order and fulfill the Order.
  • Development of Oracle forms for Invoice Credit hold release.
  • Development of BI Publisher reports for various Order Management and financial reporting.
  • Development of API for Subscription Interfacing from Zoura to EBS R12
  • Development of Customer conversion scripts to Interface customers from Legacy to Oracle apps R12.
  • Developed Workflow for Credit Hold Release Approval and Payment Term Change Approval process

Confidential

Demantra Consultant

Responsibilities:

  • Leading Demantra Development team which involved requirement gathering from globally distributed planning teams (APAC/EMEA/AMR), solution design, coding and testing.
  • Developed customer replenishment solution which involved development of complex plsql procedures, functions and interfaces using bulk collection, ref cursor, dynamic sql, multithreading and partition concepts to process large volume data.
  • Worked extensively on performance tuning, analyzed AWR reports/Explain plan to analyze code performance and implemented measures to resolve performance issues.
  • Implemented multithreading (based on both table partition and threads) and parallel processing of code to improve performance.
  • Developed Interfaces to load Item/Location/Sales data from ERP to demantra
  • Development of Levels, series, methods, workflows, worksheets.
  • Support NPI/New Country/ New Store/Chaining setup in Demantra
  • Drive the design, coding and testing of Inventory planning application involving heavy customization and huge data volume.
  • Involved in building custom replenishment solution for client
  • End to End Demantra Application upgrade to 12.2.5 version
  • Involved in performance review
  • Leading the onsite and offshore development team
  • Strong Functional & Technical experience on Oracle Demantra Collaboration Workbench, Business Modeller, Workflow Manager, Analytical Engine Setup/debug, Integration, Customization and Interface(Location/Item/Sales data ) development.

Confidential

Principal Support Engineer

Responsibilities:

  • Handling service requests that come from across the globe from the customer base that Oracle supports. Communicating with customers spread geographically including US, UK, Asia Pacific, Middle East, Australia, New Zealand to understand their issues and get a better hand at their problems.
  • Worked in GL module of Oracle Financials and got a very good hand over the functional aspects of Oracle Financial modules.
  • Resolving the issues faced by customers in Oracle Applications by debugging the underlying code.
  • In case of defect in the standard Oracle product, my responsibility included reproducing the scenario locally and logging bug with the development team, getting patch fix and passing it on to customers.
  • Attended training on GL concepts and performance tuning

We'd love your feedback!