We provide IT Staff Augmentation Services!

Obiee Developer/ Admin Resume

Boston, MA

EXPERIENCE SUMMARY:

  • Proficiency in OBIEE 10.1.x/OBIEE 11.1.x which includes Oracle BI Server, Oracle BI Dashboards, Oracle BI Analytics, Oracle BI Delivers, Catalog Manager, Oracle BI Publisher.
  • Experience with OBIEE Installation and configuring components (BI Analytics, BI Publisher).
  • Involved in SDLC phases like Requirement gathering, Designing, Development and Testing.
  • Excellent skills in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository (RPD) using Oracle BI Administration Tool.
  • Expertise in business model development with Dimensions, Skipped and Ragged-level Hierarchies, Measures, Aggregation Rules, Time Series.
  • Experienced in implementing Row Level Security and Object level security in OBIEE.
  • Extensive experience in setup and working in a Multi-user Development environment (MUDE).
  • Good knowledge on Data Warehousing concepts like Star Schema, Snowflake Schema.
  • Experienced in Code Migration from development stage to testing stage and production stage.
  • Experience in creating out of the box, attractive, user specific and customized OBI Answers, Reports, and Interactive Dashboards using different views available.
  • Experienced in configuring iBots/Agents using OBIEE Delivers to deliver Analytics and weekly/daily reports.
  • Experienced in testing OBIEE Answers, Dashboards, Reports, KPIs and Scorecards.
  • Strong experience in Oracle database and fluent in SQL, PL/SQL (Store Procedures and Functions).
  • Good knowledge on Data Warehousing concepts like Star Schema, Snowflake Schema.
  • Excellent Communication and Documentation skills, ability to learn and adopt new ideas and technologies, Self-motivated and result-oriented.

TECHNICAL SKILLS:

Reporting Tools : OBIEE 11g/10g (Administration Tool, Catalog Manager, Answers,

Dashboards), XML/OBI Publisher 11.1.x/10.x

ETL Tools : Data warehouse Administration Console (DAC), Informatica Power Center 9.x,

8.1x.7.x(Designer, Manager, Workflow Manager/ Monitor)

Database System : Oracle 11g/10g

Tools : MS office, SQL developer, TOAD

Operating Systems : MS Windows 7/Vista/XP/2000/98/95, Unix/Linux ( Shell Scripts).

Languages : C, .NET, SQL

Web Technologies : HTML, HTML 5, XML, CSS, Java Script

PROFESSIONAL EXPERIENCE:

OBIEE Developer/ Admin

Confidential

Boston, MA

Responsibilities:

  • Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
  • Involved in communicating with client to understand/clarify requirements and suggest enhancements.
  • Designed Star schema for fact & dimensional tables from the current OLTP and created alias for the dimensional tables when necessary.
  • Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle Business Intelligence Administration Tool.
  • Specified dimensional hierarchy, aggregate levels for the dimensions.
  • Set up a Multi-User Development Environment (MUDE) for the convenience of the company’s on-shore and off-shore teams.
  • Developed different dimensional level Analysis, Filters and Prompts using Oracle Business Intelligence Answers.
  • Designed and configured Intelligent Dashboards in Analytics using KPIs and Scorecards for different groups of users which include business users from various parts of the world.
  • Developed customized and attractive Analysis/ Dashboards/ Reports with different Analytics Views (Pivot Table, Chart, Tabular, Ticker, Column Selector and View Selector), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
  • Created Time Series Measures, Hierarchies, Level Based Measures, Session and Repository Variables, Initialization Blocks.
  • Created Agents to alert the business users.
  • Use Upgrade Assistant to upgrade metadata and schemas from 10g (RPD, Web Catalog, BI Publisher Repository, and BI Publisher Schema).
  • Manually migrated the Custom Style/ Skin/ XML Messages/ Java scripts. Did the changes to instanceconfig.xml, NQSConfig.INI
  • Implemented object level security for different web groups based on responsibilities.
  • Improved the performance of the Reports by moving huge calculations to the Database and by using the Aggregate tables and Cache management.
  • Installed and configured Informatica PowerCenter 9.0 to be used as ETL engine to load data into the Data Warehouse.
  • Checked data consistency using SQL and PL/SQL queries in SQL Developer.

Environment: OBIEE 10g/11g, Informatica 9.0, Oracle 11g, SQL Developer, PL/SQL

OBIEE Developer

Confidential
Chennai, India

Responsibilities:

  • Involved in Analysis, Study and Design of the Application.
  • Identified Facts and Dimensions (with levels & hierarchy) and developed OBIEE Repository at 3 layers i.e., Physical Layer, Business Model / data mapping (created Logical tables & data source mapping) and Presentation Layer level (created presentation catalogs), created presentation folders, tested and validated the model.
  • Configured and administered existing subject areas and created new subject areas to include new Star Schema information.
  • Extensively used repository variables, session variables and presentation variables.
  • Specified aggregate levels for each source and created dimension sources for each level of aggregates.
  • Developed many OBI Answers using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
  • Extensively used OBIEE Delivers and iBots to deliver reports (layout templates in RTF) to mobile users.
  • Used Filters and provided customized prompts appropriately to avoid excessive data showing up in BI answers.
  • Developed many complex Informatica mappings and reusable mapplets to build key interfaces using transformations and reusable transformation units ( Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for loading data into Data Warehouse.
  • Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduled them to run at specified time with required frequency.
  • Used Workflow Monitor to monitor the performance of the Jobs.
  • Explore prebuilt ETL metadata, including Informatica workflows and mappings, and DAC metadata.
  • Use the Data Warehouse Administration Console (DAC) to configure, manage, and load the Oracle Business Analytics Warehouse.
  • Loaded consolidated data using SQL *Loader in parallel and direct mode.
  • Developed detailed test plans, implemented all related test cases and created a detailed documentation of the above test process.

Environment: OBIEE 10.1.3.4, Informatica PowerCenter 8.1, DAC, Oracle 9i, SQL Developer, SQL*Loader, Windows XP

OBIEE Developer

Confidential
Chennai, India

Responsibilities:

  • Actively involved with business team to gather user requirements.
  • Installed and configured OBIEE Admin tool and web components including Intelligence Dashboards, answers, and requests.
  • Used admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.
  • Worked on BMM layer to customize the tables, hierarchies, dimensions and aggregations and calculations.
  • Involved in performance tuning of the dashboards using cache management.
  • Tested and validated the unit test cases
  • Organized and customized the presentation layer in a format that is easy for end user to use as basis for reporting
  • Worked on creation of repository variables and session variables.
  • Worked with the Security settings in OBIEE Admin Tool to set up users, groups, access privileges.
  • Designed and developed interactive navigational drill down reports in OBIEE Answers, requests and Intelligence Dashboards using various reporting features and functionalities such as formulas, filters, charts, pivot tables.
  • Using the Presentation Variable in prompts Report filters.

Environment: OBIEE 11.1.1.3, OBI Publisher 11.1.1.3, Informatica 8.5, Oracle 10g, TOAD, SQL, PL/SQL, Unix.

Hire Now