Oracle Fusion Reporting Manager

Main Purpose:

Founded in 1993, Trafigura is one of the largest physical commodities trading groups in the world. Trafigura sources, stores, transports, and delivers a range of raw materials (including oil & refined products and metals and minerals) to clients around the world. The trading business is supported by industrial and financial assets, including 49.3 percent owned global oil products storage and distribution company Puma Energy; global terminals, warehousing, and logistics operator Impala Terminals; Trafigura’s Mining group; and Galena Assets Management.

The company is owned by over 700 of its 8,000 employees who work in 80 offices and 41 countries around the world. Trafigura has achieved substantial growth over recent years, growing revenue from USD 12 billion in 2003 to USD 171.5 billion in 2019. The Group has been connecting its customers to the global economy for more than two decades, growing prosperity by advancing trade.

Trafigura Global Services (TGS) is the fully owned subsidiary of Trafigura, a Global In-House Delivery Center, set-up for aggregating Middle and Back-office functions critical to support our trading life cycle. The entity has 600+ employees, adopts best in class technology and practices enabling operations across Europe, Africa, Middle East and Asia-Pacific.

The Oracle Fusion Reporting Specialist is responsible for designing, developing, and maintaining high-quality reports and analytics within the Oracle Fusion platform to support business decision-making. This role focuses on leveraging Oracle Fusion’s reporting tools, such as Oracle Transactional Business Intelligence (OTBI) and Oracle BI Publisher, to deliver actionable insights, ensure data accuracy, and meet organizational reporting needs. The specialist collaborates with business stakeholders to understand requirements, optimize reporting processes, and provide technical expertise in enhancing the reporting ecosystem.

Knowledge Skills and Abilities, Key Responsibilities:

Knowledge, Skills and Abilities

• In-depth Knowledge of Oracle Fusion Reporting Tools: Proficiency in Oracle Transactional Business Intelligence (OTBI), Oracle BI Publisher, and related analytics features within Oracle Fusion.
• Technical Expertise:
  • Strong understanding of SQL, data modelling, and Oracle Fusion data structures to create and troubleshoot complex reports.
  • Knowledge of ETL tools preferably Informatica, Warehousing database
  • Expertise in reporting tools like FAW, Qlik Sense, SAP BO is an added advantage.
• Analytical Thinking: Ability to interpret business requirements and translate them into effective reporting solutions.
• Problem-Solving Skills: Competence in identifying and resolving reporting issues, optimizing performance, and ensuring data integrity.
• Collaboration and Communication: Excellent interpersonal skills to work with cross-functional teams and present insights to non-technical stakeholders.
• Attention to Detail: Precision in designing reports and validating data to ensure accuracy and reliability.
• Experience with Oracle Fusion Modules: Familiarity with specific Oracle Fusion modules (e.g., HCM, ERP, SCM) relevant to the organization’s implementation.
• Adaptability: Ability to stay current with Oracle Fusion updates and enhancements to reporting functionalities.
• Project Management: Basic skills in managing reporting projects, prioritizing tasks, and meeting deadlines.

Key Responsibilities:

• Define and reporting strategy.
• Report Development: Design, develop, and customize reports and dashboards using OTBI, BI Publisher, and other Oracle Fusion reporting tools to meet business requirements.
• Design, develop and support data sync requirement with external reporting tools like QV, SAP BO, FAW
• Requirement Gathering: Collaborate with business users and stakeholders to gather and document reporting needs, ensuring alignment with organizational goals.
• Data Validation: Ensure the accuracy, consistency, and integrity of data in reports by performing regular validation and troubleshooting discrepancies.
• Performance Optimization: Monitor and enhance report performance, optimizing queries and configurations for efficiency.
• User Support: Provide training, documentation, and ongoing support to end-users on accessing and interpreting Oracle Fusion reports.
• Security Management: Implement and maintain report-level security, ensuring compliance with data governance and access policies.
• Process Improvement: Identify opportunities to streamline reporting processes and introduce best practices within the Oracle Fusion environment.
• Testing and Deployment: Conduct testing of new and updated reports, ensuring functionality before deployment to production.
• Stay Updated: Keep abreast of Oracle Fusion updates, new features, and industry trends to recommend improvements to reporting capabilities.
• Documentation: Maintain comprehensive documentation of report specifications, processes, and configurations for future reference and audits.

Competencies:

• Strong oral and written communications with strong inter-personal skills to collaborate with vendor teams and global IT owners with attention to micro level details.
• Must be acclimatized working and dealing with client managers / senior management.
• Strong analytical and problem-solving skills.
• Strong change management skills, ability to manage several projects simultaneously while working under pressure to meet deadlines.
• Capable of working in groups as well as independently.

Experience:

• More than 12 years of experience in Oracle Applications that includes 3-4 years of experience in Oracle cloud Reporting.
• At least 2 years of experience leading team of 10+ resources, with ability to provide mentorship and training to others.
• Experience with Data Warehouses.
• Minimum of 5 years of experience working with outsourced vendor partners is BIG plus.
• Bachelor’s degree in engineering or physics or mathematics is required.
• Understanding of Oracle product development cycle, Oracle security, Oracle Instance strategy, On-premises ERP, Oracle Cloud ERP is a MUST.
• Understanding of Commodities, Logistics, Financing, Accounting or Derivatives is a BIG plus.

Key Relationships and Department Overview:

Key Relations and Reporting Structure

• Robust collaborative relationship with business stakeholders, architects, developers, project managers, implementation/outsourcing partners & other business analysts

• Testing and training groups

Key Attitudes / Competencies:

• Delivery focused

• Develop and maintain close relationships with business and IT stakeholders

• Team worker, mentoring of junior IT Business Analysts

• Good communicator, engaging and able to work with offshore teams across various time zones

• Ability to make decisions & thrive in a fast-paced environment

Equal Opportunity Employer

We are an Equal Opportunity Employer and take pride in a diverse workforce. We do not discriminate in recruitment, hiring, training, promotion, or other employment practices for reasons of race, colour, religion, gender, sexual orientation, national origin, age, marital or veteran status, medical condition or handicap, disability, or any other legally protected status.