Komali Rayidi

IT professional currently working as OBIEE/OAC/FDI Developer with 7+ years of experience. Strong knowledge of OBIEE as a Business Intelligence tool and OAC.

Experience in Data Warehousing Concepts like Star Schema, Snowflake Schema Methodologies. Designing and Deployment of Reports for the End-User requests using OBIEE. Managing the OAC, creating the users and roles from the console.

Created

Data sets, Projects and Data Flows in OAC. Creating DV and Analytical reports in OAC. Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher. Experienced in set up of OBIEE Security.

Worked on Data Augmentation in FDI. Worked on Semantic Model Extensions and DFF in FDI. Expertise in developing Oracle BI Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer) and good knowledge working with Administrative Tool to build Meta data, Analytics security and caching.

Worked on the BI Publisher Reports, created Data Models, Data sets and Parameters. Involved in moving Web Catalog from DEV to QA, QA to PROD. Involved in Unit testing, System testing to check if the reports are behaving correctly and fixing the same.

Experience in training business users on OBIEE Answers and Dashboards and educating technical super users and administrators on repository and web catalog migrations procedures with Oracle best practices. Excellent communication, adaptability, leadership, team collaboration, staff training, and time management skills to build consensus across relevant parties and drive business success. Excellent work ethics, professionalism, attention to detail, ability to work in a highly collaborative, collegial, and multidisciplinary team environment.

OBIEE Developer at INFOSYS (2022-04 – 2024-05)

OBIEE Developer at M9 Consulting (2017-01 – 2022-03)

OBIEE Developer at Sandwell Metropolitan Borough Council (2023-05 – 2024-05)

• RPD Design (physical layer, Business model mapping layer and Presentation layer using on oracle BI Server administration).
• Creating connections and data sets in OAC.
• Deploying rpd using snapshot in OAC.
• Creating data sets with different tables and SQL queries in OAC.
• Creating different type of DV reports in OAC.
• Creating different calculation for DV reports in data sets and in calculations.
• Creating analytical reports in OAC.
• Designed and developed Web catalog, Reports/Dashboards with different Analytics using Oracle Business Intelligence Presentation Services.
• Configured Web Catalog Objects (Dashboards, Pages, Folder and Reports).
• Created different Views like Table, charts, pivot tables, view selectors, narratives and column selectors.
• Involved in creating the Dimensional Hierarchies.
• When required worked on creating the BI reports by writing custom logical SQL to represent the data from multiple subject area at same granularity on report and avoid duplication.
• Worked on the BI Publisher Reports, created Data Models, Data sets and Parameters.
• Worked on the Action link, guided navigation.
• Created Initialization Blocks, Session Variables and Presentation Variables for Use in Reports and Dashboard Prompts.

OBIEE Developer at East Sussex County Council (2022-04 – 2023-05)

• RPD Design (physical layer, Business model mapping layer and Presentation layer using on oracle BI Server administration).
• Worked with Business users for Requirements Gathering, Business Analysis and Functional Specification documents.
• Designed and developed Web catalog, Reports/Dashboards with different Analytics using Oracle Business Intelligence Presentation Services.
• Configured Web Catalog Objects (Dashboards, Pages, Folder and Reports).
• Created different Views like Table, charts, pivot tables, view selectors, narratives and column selectors.
• Involved in creating the Dimensional Hierarchies.
• Modified existing reports and created new reports from various sources as per the business requirements.
• Created Application Roles in Oracle Enterprise Manager 11g and set the permissions on dashboard pages using the application roles.
• When required worked on creating the BI reports by writing custom logical SQL to represent the data from multiple subject area at same granularity on report and avoid duplication.
• Worked on the BI Publisher Reports, created Data Models, Data sets and Parameters.
• Worked on the Action link, guided navigation.
• Created Initialization Blocks, Session Variables and Presentation Variables for Use in Reports and Dashboard Prompts.

OBIEE Developer at University of Wisconsin (2018-05 – 2022-03)

Development of dashboards using Oracle Business Intelligence Enterprise Edition ("OBIEE") in an environment with Oracle databases using best practices. This includes designing and coding the metrics that appear on high-level Dashboards, graphs, and maps, through the drilldowns to detailed transactional-level reports.

• RPD Design (physical layer, Business model mapping layer and Presentation layer using on oracle BI Server administration).
• Deploying the RPD using Snapshots in OAC.
• Managing the Snapshots in OAC.
• Creating the users and roles from the console in OAC.
• DV reports in OAC.
• Created data set in DV using OAC.
• Created Data Flows and Sequences in OAC.
• Created Oracle BI Publisher reports using templates.
• Unit testing the reports, debugging and fixing the errors for Right reports.
• End to End testing of Reports for data and functional behavior.
• Created the reports in different views like Table, Pivot, Chart, Filter, Title, view selector, column, and narrative.
• Involved in creating the Dimensional Hierarchies.
• Providing support and fixing issues related to Data on Reports, Dashboards etc.
• Provided RPD support to manage the Reports and Dashboards.
• Worked using Oracle SQL.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Creating the navigations from one report to other pages, Action links.
• Involved in creating Page and dashboard prompts and conditions for certain requirements.
• Created different reports using set operators and Request based on another analysis.

OBIEE Developer at The NYS Office of Information Technology Services (2017-01 – 2018-04)

• RPD Design (physical layer, Business model mapping layer and Presentation layer using on oracle BI Server administration).
• Worked with Business users for Requirements Gathering, Business Analysis and Functional Specification documents.
• Designed and developed Web catalog, Reports/Dashboards with different Analytics using Oracle Business Intelligence Presentation Services.
• Configured Web Catalog Objects (Dashboards, Pages, Folder and Reports).
• Created different Views like Table, charts, pivot tables, view selectors, narratives and column selectors.
• Involved in creating the Dimensional Hierarchies.
• Modified existing reports and created new reports from various sources as per the business requirements.
• Created Application Roles in Oracle Enterprise Manager 11g and set the permissions on dashboard pages using the application roles.
• When required worked on creating the BI reports by writing custom logical SQL to represent the data from multiple subject area at same granularity on report and avoid duplication.
• Worked on the BI Publisher Reports, created Data Models, Data sets and Parameters.
• Worked on the Action link, guided navigation.
• Created Initialization Blocks, Session Variables and Presentation Variables for Use in Reports and Dashboard Prompts.

BTech – JNTU (2010)