Oracle BI developer

Skills

Description

1. OBIEE, OAS, OAC, BI publisher, Oracle Data Integrator ETL
2. Oracle Utility Analytics, Oracle BI Apps
3. PL/SQL, SQL

Responsibilities

• • Provide expert guidance on overall system architecture, Business Intelligence (BI) and technologies
• • Develop scalable and maintainable BI applications to meet business objectives
• • Maintain accurate and complete technical architectural documents
• • Define BI standards, guidelines and best practices for business groups and technical teams
• • Support BI tools upgrades in development, testing and documentation
• • Recommend strategies to improve performance and capacity of BI application
• • Address customer queries and issues in a timely manner
• • Collaborate with BI Administrators, BI Developers and Analysts for successful development of BI reporting and analysis solutions
• • Work with business groups and technical teams to develop and maintain data warehouse platform for BI reporting
• • 12+ years of experience in handling implementations of Oracle BI Apps – ERP/HCM/SCM or development of custom Data Warehouse ERP/HCM projects
• • Candidate should have delivered 3-4 large-scale end-to-end BI/ETL implementation projects.
• • Ensure proper hands-offs and coordination between BI Project teams, Data Architecture Team, Prod Operations, stakeholders, and external providers.
• • Good experience in Implementation of BI analytics using OBIEE, ODI, Oracle Analytics Cloud (OAC), Fusion Analytics Warehouse (FAW), BI Apps, OUA and BI technologies
• • Knowledge in integrating multiple data sources to load into Enterprise DWH
• • Have very good functional understanding of Financials, SCM, Procurement, etc...
• • Worked in at least 6-10 full life cycles of OBIA implementation for modules HR, Financial Analytics, Procurement & Spend Analytics, Supply Chain Management, Project Analytics
• • Ability to identify risks, and communicate mitigation plan with key stakeholders at client
• • Understanding requirements, solution blueprint, performing fit gap analysis, business process designs
• • Good querying skills on Oracle database with ability to understand and debug PL/SQL procedure
• • Experience as architect for Dimension Modelling and Data Warehouse builds
• • Experience with effective performance tuning
• • Must be well versed and hands-on in troubleshooting various issues and providing workarounds
• • Ability to prepare Status reports and communicate with client
• • Good problem solver and prompt decision maker
• • Able to plan, track tasks and activities, co-ordinate, and report on periodical basis
• • Daily onsite/offshore coordination on deliverables and inter-team interaction
• • Skills: OBIEE, Oracle Data Integrator (ODI), Oracle Utility Analytics (OUA), Oracle BI, OAS, BIP, BIAPPS, PL/SQL, Data ware housing, Golden Gate Integrations