OBIEE Consultant

Position: OBIEE Consultant

Location: Miami, FL- Onsite- Onsite

Contract

Visa: USC, Green card, TN Visa, E3 visa

Job description:

Key Responsibilities

· Designing and implementing oracle bi solutions within the erp system.

· Developing and maintaining data models to support bi reporting.

· Optimizing bi dashboards and reports for performance and usability.

· Collaborating with cross functional teams to gather requirements for bi solutions.

· Providing technical support and troubleshooting for bi tools and applications.

· Ensuring data accuracy and integrity within the ERP system.

· Keeping abreast of industry trends and best practices in oracle bi to recommend improvements.

Skill Requirements

· In-depth knowledge of oracle business intelligence tools and technologies.

· Proficiency in Oracle ERP systems and modules.

· Strong understanding of data warehousing concepts and methodologies.

· Experience in designing and optimizing data models for bi reporting.

· Ability to collaborate effectively with different teams and stakeholders.

· Analytical mindset with problem-solving skills.

· Excellent communication and presentation abilities.

Certifications: Oracle BI certification is preferred but not mandatory.

Additional requirement:

Primary Skill OBIEE senior profile with exposure to SAP

· In depth understanding of SAP modules SD, MM, FICOPS.

· Good understanding of end to end business process in O2C, P2P, PL2PRC2R including S4HANA tables reports in these process.

· Should be able to understand customization in S4 system including custom tables, CDS views reports.

· Should have good understanding of data structures, data analysis data reconciliation methods in S4 system

· Requirements Gathering and Analysis of working with business stakeholders to understand reporting needs and translate them into technical specifications.

· Experience on OAS with DV Data Visualization skills and able to handle complex business logics.

· Experience in Data Warehouse Integration with ETL knowledge and should be able to resolve data discrepancy issues while tracing back thru ETL and source systems.

· Experience in end to end process from source system analysis to OBIEE deployments with data reconciliation and validation skills.

· Designing, developing, and maintaining Business Intelligence solutions using Oracle Business Intelligence Enterprise Edition OBIEE).

· Proficiency in writing SQL queries for data extraction and manipulation.

· Strong analytical and problem solving skills to identify and resolve data related issues.

· Experience in OBIEE RPD modeling, designing start snowflake schemas.

· OBIEE Expert with a thorough understanding of OBIEE architecture and the role of different OBIEE components like Analytic Server, Web Server, RPD, Web Catalog, Security, Dashboards, Reports, iBots and Scheduler.

· Experience in writing and profiling complex PLSQL queries and fetch appropriate data from huge data sets efficiently Oracle).

· Experience in OBIEE Features i.e. Cache, Usage tracking, Dimensional hierarchy, Variables Initialization Blocks configuration etc.), converting Snowflake Schema to Star Schema, Dim Hierarchies, Dim Extensions, and Physical Logical Data Modeling.

· Possess good communication, interpersonal skills, an ability to quickly grasp new concepts both technical and business related. Flexible and experienced to work independently or in a team environment.