Job Title:  Manager | OTBI | Bengaluru | HR Transformation

Job Summary:

We are seeking a Manager with expertise in Oracle OTBI (Oracle Transactional Business Intelligence) and Oracle BI Publisher (BIP) reports. The ideal candidate will have a strong background in designing and implementing reporting solutions using Oracle Cloud applications and have deep knowledge in developing, customizing, and optimizing reports. As a Manager, you will work with clients to understand their reporting requirements and deliver tailored, high-quality reports using OTBI and BI Publisher.

Key Responsibilities:

• Lead the design, development, and delivery of customized OTBI and BI Publisher reports for Oracle Cloud Applications (ERP, HCM, SCM, etc.).
• Collaborate with functional teams to understand reporting requirements and translate them into technical specifications.
• Develop, customize, and optimize OTBI reports to ensure efficient and accurate reporting from Oracle Cloud applications.
• Build and deploy BI Publisher reports, including layouts, data models, and templates.
• Perform data extraction, transformation, and reporting tasks within Oracle Cloud and integrate with other applications as needed.
• Troubleshoot and resolve issues related to OTBI reports, BI Publisher reports, and data discrepancies.
• Participate in the full SDLC, from gathering requirements and designing reports to testing and deployment.
• Perform performance tuning on OTBI and BIP reports to improve efficiency and data retrieval times.
• Provide best practices and guidance to junior consultants, development teams, and end-users on Oracle reporting tools.
• Work closely with clients to gather feedback and ensure reports meet business needs and user expectations.
• Maintain and enhance existing reports, ensuring they remain aligned with business requirements and Oracle Cloud updates.
• Stay up to date with the latest Oracle Cloud updates and reporting tools enhancements.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• Minimum of 7+ years of experience in Oracle reporting, with at least 4 years of hands-on experience in Oracle OTBI and BI Publisher (BIP).
• Strong knowledge of Oracle Cloud applications and how OTBI/BIP integrates with these modules.
• Extensive experience in designing, developing, and deploying OTBI reports and BI Publisher reports.
• Expertise in developing custom layouts, data models, and templates in BI Publisher.
• In-depth understanding of Oracle Data Models, SQL, and data retrieval techniques.
• Familiarity with data warehousing concepts, ETL processes, and reporting best practices.
• Experience in performance tuning of OTBI and BIP reports.
• Strong troubleshooting skills to resolve issues related to data quality, report performance, and functional requirements.
• Knowledge of other Oracle tools like Oracle Analytics Cloud (OAC), Oracle BI, or Oracle Reports is a plus.
• Experience with XML, XSL, and web technologies related to BI Publisher is highly desirable.
• Strong communication and interpersonal skills, with the ability to work directly with clients and business stakeholders.

Preferred Skills:

• Oracle certifications in BI, OTBI, or Oracle Analytics Cloud (OAC) are a plus.
• Familiarity with Oracle Cloud security and roles management related to report access.
• Experience in Agile project management or implementation methodologies.
• Familiarity with integration of OTBI/BIP with external systems or third-party tools.

Personal Attributes:

• Strong analytical and problem-solving skills with attention to detail.
• Ability to work independently and manage multiple projects simultaneously.
• Customer-focused, with the ability to understand and address client needs effectively.
• Ability to mentor and guide junior consultants and team members.
• Strong organizational and time-management skills, with the ability to prioritize tasks efficiently.