Oracle BI Senior ERP Specialist

HMG America LLC is the best Business Solutions focused Information Technology Company with IT consulting and services, software and web development, staff augmentation and other professional services. One of our direct clients is looking for Oracle BI Senior ERP Specialist in Miami, Florida. Below is the detailed job description.

Title: Oracle BI Senior ERP Specialist

Location: Miami, Florida, USA Fully Onsite

Oracle BI Senior ERP Specialist / Contractor / Associate

Job Description:

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.

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.

• 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.

• 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.