Job Title:  Consulting - T&T - Oracle - OIC, BI, RICE, OAC, FAW - Senior Consultant

Job Title: Oracle ERP Cloud Technical Consultant with OIC Experience
Experience Level: 2 to 15 Years
Location: PAN India
Notice Period: Immediate to 90 Days

Roles and Responsibilities:

The responsibilities of the role include:

• Integration Development: Design, develop, and implement technical solutions for integrations using Oracle Integration Cloud (OIC), ensuring seamless connectivity between Oracle Cloud and other enterprise applications.
• Report Development: Create and enhance reports using BI Publisher, OTBI, and Financial Reporting Studio (FRS) to meet business requirements, ensuring data accuracy and reliability.
• Conversions and Extensions: Develop technical solutions for data conversions, interfaces, and customizations to extend Oracle Cloud functionalities according to business needs.
• Oracle Cloud Modules Expertise: Leverage a strong understanding of Oracle Cloud Financial Modules such as Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), Project Accounting (PA), Fixed Assets (FA), Purchasing (PO), and Cash Management.
• Technical Documentation: Prepare detailed Technical Design Documents (TDD) and Unit Test Scripts, ensuring clarity and completeness for development and testing teams.
• Collaboration and Support: Work closely with functional teams, end-users, and stakeholders to understand requirements, troubleshoot issues, and provide technical support for implemented solutions.

Requirements:

• Adaptability: Ability to perform effectively in a dynamic and rapidly changing environment, demonstrating flexibility and a proactive approach to problem-solving.
• Technical Expertise: Strong proficiency in Oracle Integration Cloud (OIC), BI Publisher, OTBI, FRS, and other Oracle Financial tools and technologies.
• Knowledge of Oracle Cloud Modules: In-depth knowledge of financial modules, with a focus on integrating and customizing solutions to meet business objectives.
• Analytical Skills: Ability to analyze requirements, identify gaps, and develop robust technical solutions that align with business processes.
• Communication Skills: Strong verbal and written communication skills, with the ability to interact effectively with technical and non-technical stakeholders.
• Documentation Skills: Proficiency in creating technical documentation, including design specifications, test scripts, and user guides.

Job Title: Oracle EBS Technical Consultant
Experience Level: 2-15 Years
Location: PAN India

Roles and Responsibilities:

• Technical Development and Customization:
  • Develop and enhance Oracle E-Business Suite (EBS) R12 applications using SQL, PL/SQL, APEX, XML/BI Publisher, and Oracle Forms.
  • Design and implement RICE components (Reports, Interfaces, Conversions, and Extensions) to customize and extend Oracle EBS functionality according to business needs.
  • Develop and manage Oracle Workflows and integrate with other systems using Oracle Integration tools.
• Implementation and Rollout:
  • Lead or contribute to a minimum of three full-cycle implementation projects, enhancements, and rollouts within Oracle EBS.
  • Provide technical expertise and support during the implementation phase, including requirements analysis, solution design, development, and deployment.
• Finance and SCM Modules Expertise:
  • Work with key Oracle EBS modules, particularly in Finance (AP, AR, GL) and Supply Chain Management (SCM) modules, to deliver technical solutions that align with business processes.
• Scripting and Programming:
  • Utilize strong programming skills in SQL and PL/SQL to develop complex queries, scripts, and procedures for data manipulation, reporting, and system integrations.
• Technical Documentation and Support:
  • Prepare and maintain technical documentation, including design specifications, test scripts, and user manuals.
  • Provide ongoing technical support and troubleshooting to resolve issues, ensuring system stability and performance.

Requirements:

• Technical Expertise: Proficiency in Oracle EBS R12, SQL, PL/SQL, APEX, XML/BI Publisher, Oracle Forms, Oracle Workflow, and RICE components.
• Project Experience: Minimum of 3 full-cycle implementation projects with hands-on experience in system enhancements and rollouts.
• Module Knowledge: Strong working knowledge of Oracle EBS Finance and SCM modules, with the ability to develop custom solutions tailored to these areas.
• Programming Skills: Advanced skills in SQL and PL/SQL, with a strong ability to write and optimize scripts for performance.
• Problem-Solving Skills: Proven ability to troubleshoot technical issues, perform root cause analysis, and implement effective solutions in a timely manner.

Job Title: Oracle Analytics Cloud (OAC)/FAW Consultant
Experience Level: 5-15 Years
Location: PAN India.

Roles and Responsibilities:

• OAC Dashboard and Report Customization:
  • Design, customize, and configure interactive dashboards, reports, and visualizations in Oracle Analytics Cloud (OAC) tailored to business requirements.
  • Perform OAC administration tasks, including user management, security setup, and performance optimization.
• Data Integration and Performance Tuning:
  • Develop complex Oracle SQL queries and perform performance tuning by implementing views, materialized views, and creating indexes to enhance data retrieval speed.
  • Design and develop interfaces to load data into Oracle Autonomous Data Warehouse (ADW) from various sources, including external relational databases and flat files, ensuring data accuracy and consistency.
• Data Warehouse Development:
  • Utilize strong data warehousing skills to design, build, and optimize data models, ensuring alignment with business intelligence needs.
  • Work with large datasets to create ETL processes that support analytical and reporting requirements, enhancing overall data usability.
• Defect Resolution and Support:
  • Manage the resolution of defects identified during testing, migration, and support phases, ensuring issues are resolved promptly to maintain data integrity and system performance.
  • Provide ongoing support to troubleshoot and optimize analytics solutions, maintaining high levels of user satisfaction.

Requirements:

• Technical Expertise:
  • Proven experience in Oracle Analytics Cloud (OAC) dashboard, report development, and administration.
  • Strong command of Oracle SQL, performance tuning techniques, and experience with Oracle Autonomous Data Warehouse.
• Data Warehousing Skills:
  • Deep understanding of data warehouse design, development, and optimization, with hands-on experience in ETL processes.
• Defect Management:
  • Demonstrated ability to manage and resolve defects during testing, migration, and support, ensuring robust analytics performance.
• Analytical Skills:
  • Excellent problem-solving skills with the ability to analyze complex datasets and develop meaningful insights.