OTBI BIP DEVELOPER (Oracle Fusion)

Title Oracle ERP OTBI / BIP Developer

Location: San Francisco, CA

Duration: 6 Month (Possible Extension)

Client : Metropolitan Transportation Commission

Description:

The role would be hybrid in San Francisco, CA and would require someone who can work directly with business users to gather reporting requirements and develop reports using Oracle OTBI and BI Publisher. The ideal candidate would have strong report development experience, be comfortable with scripting when needed, and have a good understanding of Oracle ERP modules and the underlying data structures.

Required Technical Qualifications

Oracle OTBI Expertise
Strong hands-on experience designing and developing Oracle Transactional Business Intelligence (OTBI) analyses, dashboards, and subject areas, including advanced filtering, calculated columns, and drill-down capabilities.

BI Publisher (BIP) Development
Proven experience developing and delivering BI Publisher reports, including:

• Data templates (XML/SQL-based)
• RTF, Excel, and PDF layouts
• Bursting configurations and scheduling

Report Design & Solutioning
Ability to analyze business requirements and determine the appropriate reporting approach (OTBI vs. BIP), including trade-offs related to performance, real-time vs. batch reporting, and formatting needs.

SQL and Data Modeling Skills
Strong proficiency in writing complex SQL queries, data extraction, joins, aggregations, and query optimization. Solid understanding of relational data models and reporting layer design.

Oracle Fusion Cloud Functional Knowledge
Hands-on experience with Oracle Fusion Cloud modules, including Finance (ERP), HCM, Procurement (PPM), and/or EPM, with strong understanding of underlying data structures and subject areas.

Oracle Reporting Architecture
Deep understanding of Oracle Fusion reporting ecosystem, including:

• OTBI subject areas and metadata layers
• BI Publisher architecture
• Data security models and role-based access controls
• Integration with Fusion data sources

Performance Optimization
Experience tuning OTBI and BIP reports for performance, including query optimization, efficient use of subject areas, and minimizing runtime.

Testing & Validation
Experience conducting report validation, reconciliation with source data, troubleshooting discrepancies, and ensuring data accuracy and completeness.

Security & Data Governance
Understanding of role-based security, data access controls, and ensuring reports comply with organizational data governance and audit requirements.

Documentation & Knowledge Transfer
Ability to produce technical and functional documentation, including report design specifications, data mappings, and user guides.

Training & Enablement
Demonstrated ability to:

• Train business users on OTBI self-service reporting
• Train IT staff on BI Publisher report development and maintenance

Collaboration & Integration Experience
Experience working with cross-functional teams (business SMEs, functional leads, technical teams) to gather and validate reporting requirements and outputs across integrated systems.

Optional Qualifications:

• Familiarity with FBDI/ADFdi data structures and extracts
• Experience in public sector or large government ERP programs