Oracle Fusion OTBI Senior Technical Consultant

Designation

LEAD TECHNICAL CONSULTANT

Role: Oracle Fusion OTBI Senior Technical Consultant

Job Summary
The Senior Technical Consultant in Oracle Fusion OTBI is responsible for providing technical expertise and guidance in implementing and customizing Oracle Fusion OTBI solutions. The role involves working closely with clients to understand their business requirements and designing, developing, and deploying OTBI reports to meet those requirements effectively.
Key Responsibilities
1. Collaborate with clients to gather and analyze business requirements for otbi reports
2. Design and develop custom otbi reports and dashboards based on client specifications
3. Provide technical expertise in oracle fusion otbi to optimize report performance
4. Conduct end-user training and support for utilizing otbi reports
5. Work closely with cross functional teams to ensure successful integration of otbi solutions
6. Stay updated with oracle's latest otbi features and functionalities to recommend best practices to clients
Skill Requirements
1. Proficiency in oracle fusion otbi and strong technical skills in designing and developing otbi reports
2. In-depth knowledge of oracle fusion middleware and bi publisher
3. Experience in data modeling, sql, and pl/sql for creating complex reports
4. Strong problem-solving abilities and analytical thinking
5. Excellent communication and interpersonal skills to effectively interact with clients and internal teams

Certifications: Oracle Fusion Middleware certification is preferred

Oracle Fusion Financials reports, data extraction

great knowledge of Fusion Financials data model, schema, tables, etc.

Fusion Generate Data File for Export

write sql for Oracle Fusion Financials extracts using:

• Smart View / Web Studio
• Item / Product Data Publication
• OTBI (Online Transactional BI)
• BIP (Business Intelligence Publisher)
• BICC (BI Cloud Connector)
• Microsoft PowerBI