Oracle Apps Technical Consultant - Noida, India - TITAN CONSULTANCY

    TITAN CONSULTANCY
    TITAN CONSULTANCY Noida, India

    1 week ago

    Default job background
    Full time
    Description

    Job Description

    Location- Noida (WFO)

    Experience- 3+ years

    Relevant experience- 3 years is required

    Notice period- Immediate to 30 days (max)

    Budget- 6 LPA-7 LPA

    Skills required- Communication skills, Oracle EBS (11i and R12), APEX, SCM, Oracle Purchasing, Order Management (OM), Oracle Inventory (INV), Oracle Forms 6i/10g, Oracle Reports 6i/10g, SQL/PL SQL, Application object Library (AOL), MD070, MD0120

    Interview process- 2 technical rounds (vitural). Last round can be F2F if needed.

    Working days and timings- 5 days working- 9:30am to 6pm.

    Job Responsibility:

    3+ years as Oracle Apps Technical Consultant in implementation, upgrade, customization and development of complex applications using Oracle Applications 11i and R12.

    Good experience on Oracle EBS(11i/R12) Oracle Supply Management (SCM), Order Management (OM), Oracle Inventory (INV), Oracle Purchasing (PO).

    Technical Skills include SQL, PL/SQL, Oracle Forms 6i/10g, Oracle Reports 6i/10g, SQL*Loader, Form Personalization, Conversions, Interfaces.

    Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, SQL Developer and SQL* plus.

    Created indexes on the tables for faster retrieval of the data to enhance database performance.

    Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

    Strong Knowledge of Application object Library (AOL) implementation standards.

    Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.

    Expertise in registering menus, forms, reports, concurrent programs.

    Created custom templates with Data Definitions for XML Publisher and Developed reports using reports and registered as XML reports in applications.

    Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

    Created extensions using Oracle recommended frameworks.

    Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).

    Extensively worked on technical documents like MD070, MD0120