Title:  Sr Technical Lead

Looking for Oracle BI Solution Architect with 10+ years of experience in OBIEE 12c and ODI 12c, extensive expertise in data warehousing, business intelligence, and ETL processes.

Profile Summary:

Highly experienced Business Intelligence and Data Warehousing professional with over 10+ years of expertise in OBIEE 12c and ODI 12c. Proven track record in designing, developing, and implementing robust BI solutions and ETL processes. Adept at managing large-scale data projects, optimizing performance, and delivering actionable insights to drive business decisions. Strong background in Oracle SQL/PL SQL, data modeling, and dashboard/report development.

Core Skills:

• OBIEE 12c: Report and dashboard development, RPD modeling, performance tuning
• ODI 12c: ETL design and development, data integration, error haandling
• Oracle SQL/PL SQL: Complex queries, stored procedures, performance optimization
• Business Intelligence: Data visualization, KPI tracking, ad-hoc reporting
• Project Management: Agile methodologies, team leadership, stakeholder communication

Professional Experience:

• Lead the design and development of OBIEE 12c reports and dashboards, enhancing data visibility for key business units.
• Architect and implement ODI 12c ETL processes, ensuring seamless data integration and transformation.
• Collaborate with cross-functional teams to gather requirements and deliver customized BI solutions.
• Conduct performance tuning and optimization of SQL queries, improving report generation times.

• Develop and maintain OBIEE 12c RPD models, ensuring accurate data representation and efficient query performance.
• Design and execute ODI 12c ETL workflows, managing data extraction, transformation, and loading from multiple sources.
• Develop and maintain complex OBIEE 12c reports and dashboards.
• Collaborate with business stakeholders to gather requirements and translate them into technical specifications.

• Perform performance tuning and optimization of OBIEE and ODI processes.
• Conduct code reviews and ensure adherence to best practices and standards.

• Repository Development: Design and develop the OBIEE repository (RPD) including physical, business model, and presentation layers.
• Data Modeling: Create and manage complex data models to support reporting requirements.
• Report and Dashboard Development: Develop advanced reports, dashboards, and scorecards using OBIEE 12c.
• Security Implementation: Implement security features including object-level security, data-level security, and user authentication.
• Performance Tuning: Optimize the performance of OBIEE reports and dashboards through caching, indexing, and query optimization.
• Migration: Manage the migration of OBIEE components across different environments (development, testing, production).
• Customization: Customize OBIEE components using JavaScript, HTML, and CSS to meet specific business requirements.
• Troubleshooting: Diagnose and resolve issues related to OBIEE server, repository, and reports.
• Documentation: Create and maintain technical documentation for OBIEE configurations, processes, and procedures.

• OBIEE 12c Architecture: In-depth understanding of OBIEE 12c architecture and components.
• SQL and PL/SQL: Proficiency in writing complex SQL queries and PL/SQL scripts.
• ETL Processes: Knowledge of ETL processes and tools, particularly Oracle Data Integrator (ODI) 12c..
• Web Technologies: Familiarity with web technologies like JavaScript, HTML, and CSS for customizing OBIEE dashboards.
• BI Publisher: Experience with Oracle BI Publisher for creating pixel-perfect reports.

• Architecture Design: Design and implement the architecture for Oracle Data Integrator (ODI) 12c solutions, ensuring scalability and performance.
• Data Integration: Develop and manage data integration processes, including Extract, Load, and Transform (ELT) operations.
• Mappings and Interfaces: Create and maintain complex ODI mappings, interfaces, and packages to support data transformation and integration.
• Metadata Management: Manage and maintain metadata repositories, ensuring data consistency and integrity.
• Error Handling: Implement robust error handling and logging mechanisms to ensure data quality and process reliability.
• Security: Configure and manage security settings, including user roles, privileges, and access controls.

• Data Warehousing: In-depth knowledge of data warehousing concepts, including star and snowflake schemas.
• Changed Data Capture (CDC): Expertise in implementing CDC to capture and process data changes in real-time.
• Cloud Integration: Experience with cloud-based data integration solutions, particularly Oracle Cloud.
• ODI Agents: Proficiency in configuring and managing ODI agents for executing data integration processes.
• Topology Management: Strong understanding of ODI topology, including physical and logical architecture configurations.

• Module Expertise: Provide functional support and expertise in Oracle EBS modules such as Financials (AP, AR, GL, FA), Oracle ASCP, Supply Chain Management (SCM), Human Capital Management (HCM), and Procurement.
• Integration: Work with technical teams to integrate Oracle EBS with other systems and applications, ensuring seamless data flow and process automation.

• Oracle EBS Modules: In-depth knowledge of Oracle EBS modules, including Financials, Oracle ASCP, SCM, HCM, and Procurement.
• SQL and PL/SQL: Proficiency in SQL and PL/SQL for querying and manipulating data within Oracle EBS.
• Business Process Knowledge: Strong understanding of business processes related to finance, supply chain, human resources, and procurement.
• Communication: Strong communication skills for interacting with business stakeholders, technical teams, and end-users.

• Design, Architect the data models and provide the solution to load data to DWH, Data Lake and to down stream systems based on business requirements.
• Design and implement ETL processes using Oracle Data Integrator to extract, transform, and load data from different source systems (RDBMS,Salesforce, CSV, JSON, API, EBS, Oracle ASCP) to target databases, Data Lake or data warehouses.
• Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis
• Proficiency in writing SQL queries and PL/SQL scripts for data manipulation and validation.
• Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI)
• Experience in handling a Large Volume of Data Ingestion and Transformation
• Performs SQL queries design, code, test, and aggregate the results to create useful information
• Responsible for building online analytical processes (OLAP) using relational and multidimensional databases
• Experience in profiling source and raw data
• Define transformation logic of data from business requirements
• Understand normalized and star-schema physical models and logical modeling concepts.

Certifications:

• Certification in OBIEE and/or ODI.