Oracle BI Senior ERP Specialist

Visa - / ,

Experience: 9 to 11 Years

Job Summary

The Senior ERP Specialist with expertise in Oracle BI will be responsible for designing, developing, implementing, and maintaining ERP solutions, particularly focusing on Oracle Business Intelligence. The role involves optimizing data models, enhancing reporting capabilities, and ensuring the ERP system meets the organization's business requirements efficiently.

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 this 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 modelling, 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.