Obiee Developer resume example

Create reports using OBIEE Answers and empowered users to navigate OBIEE Dashboards. Create d Pivot tables allowing managers to analyze the business from different perspectives and in an orderly summarized manner. Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local filters. Developed Reports and Dashboards with different Analytic views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local filters using Oracle BI Presentation Services. Integrated BI Publisher with OBIEE to build reports in word, excel, and doc format. Developer templates and reports in Oracle BI Publisher in rtf format. Met with business representatives, business analysts, and end users to understand the business models and functionality. Gathered Business requirements, interacted with the business users, defined subject areas for analytical data requirements. Perfomed administrative tasks related to the development and configuration of Interactive Dashboards. Created agents for job-critical levels and audit-able differences delivered to dashboards, email, and cell phones to assist process onwers with timely decision making. Helped create connection pools, imported physical tables and defined joins in the physical layer of the repository. Assisted with Building the Physical, Business Model and Mapping and Presentation Layer of the repository. Created dimension hierarchies and level based measures, built time and calculated measures of a fact table. Used the rename wizard to rename fields and tables. Modified Presentation Layer to add presentation tables and columns to meet the business user needs. Created repository and session variables. Created groups and added users to the groups and granted priviledges. Worked in a Multi User Development Environment (MUDE) to check out repository, make changes, and complete merge process. Customized the Oracle BI Presentation Services user interface. Customized and developed OBIEE Analytics Reports and integrated them in dashboards. Used BI analytics to run queries, test, and reports and validated the repository. Performance tuning experience included modeling aggregate tables to speed query processing and partitions and fragments to improve application performance, usability and caching. Enhanced performance tuning using the SQL developer. Participated in designing, coordination and execution of User Acceptance Testing (UAT) with QA, BA and selected business users. Tested and modified OBIEE security for the internal controls environment. Environment: OBIEE 11g, Reports, Dashboards, BI Analytics, SQL, MUDE, HTML, XML. Developed Interactive dashboards with drill-down capabilities and dynamic dashboard prompts to zoom into particular segments of the business. Used Filters and provided customized prompts to appropriately avoid excessive data showing up on reports. Created reports using OBIEE Answers and empowered users to navigate OBIEE Dashboards. Created various templates, reports, and prompts in BI Publisher. Creatively used OBIEE to set up conditional formatting to develop pricing models. Created agents to send pre-processed reports. Created group level security for intelligence dashboards and assigned users to groups based on Business Requirements. Assisted in developing Metadata Repository. Used Alias and Dim tables so that the hierarchy and time series modeling would meet business requirements Used Rename Wizard to rename fields and tables. Created repository and session variables. Met with Business representatives, Buseness analysts and end users too understand the business models and functionality. Customized the OBIEE repository (Physical, BMM, and Presentation layers). Built star and snowflake schemas in the repository. In the BMM- Created logical tables, whole diagrams using complex joins, dimensional modelling design and building business models. Defined drill-down time series and other dimension hierarchies. Environment: OBIEE11g, Reports, Dashboards, BI Analytics, SQL, MUDE, HTML, XML.