We provide IT Staff Augmentation Services!

Obiee Consultant Resume

Reston, VirginiA

SUMMARY

  • 7+ years of professional experience in IT in the architecture, design and development of Data warehousing and Business Analytics application, Data Analysis, Data mapping, Reporting, ETL.
  • 5 years of experience in implementing OBIEE 11.1.1.X,10.1.3.3.X, Oracle BI Applications 7.9.X which include, hands on expertise in RPD Development, Siebel/Oracle Answers, Siebel/Oracle Dashboards, Siebel/OracleDelivers, BI publisher, Configuring Datawarehouse Administration Console(DAC)and ETL (Informatica Power Center 8.6, 8.1.1/7.1.4 ).
  • Worked extensively with Oracle BI (OBIEE) applications includes meta data configuration, dashboard report development, configuring Physical Layer, Business Model, Logical Table, Dimension, Column, Logical Table Source, Logical Joins, Aggregation Rules, Dimension Hierarchies, Complex Case Expressions, Facts, Dimensions, Repository Static/Dynamic Variables, Session Variable, adding multiple sources, executing direct Database requests, Oracle BI Views (Compound Layout, Chart, Gauge, Title, Narrative, Table, Pivot Table, Funnel Chart) etc.
  • Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, OBIEE Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
  • Expertise in converting and using Oracle pre-build Rpd’s (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) according to business requirements.
  • Working knowledge on oracle application Procurement and Spend Analytics.
  • Developed Use Cases and performed Design Analysis conducting functionality testing and User Acceptance Testing (UAT).
  • In depth knowledge of Software Development Life Cycle (SDLC) and Agile Methodology with thorough understanding of various phases such as Requirements, Analysis/Design, Development and Testing.
  • Expertise in debugging and optimizing the Oracle BI Dashboards / Reports and Informatica Mappings / Workflows.
  • Worked on dimensional modeling (Star Schemas, SCDs, and Aggregates), Metadata Configuration, and Design ETL Data Extraction processes apart from Prebuilt.
  • Extensive experience in creating database objects like Tables, Synonyms, Views and Materialized views.
  • Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
  • Highly motivated team player with good communication skills and excellent problem solving abilities would be willing to work independently or as part of a team.

TECHNICAL SKILLS:

B usiness Intelligence - OBIEE 11.1.1.x, 10.1.3.x, Siebel Analytics 8.x, 7.x (Administration, Answers, Interactive Dashboards, BI Publisher, Disconnected Analytics, Briefing Books, BI Delivers, Analytics Server Administration).

ETL Tools - Informatica 8.6.x, Informatica Power Center

Scheduling Tools - Datawarehouse Administration Console (DAC).

Database - ORACLE 10g/9i, SQL Server 2005, IBM DB2, MS Access, MYSQL

Oracle Tools - TOAD and Developer 2000

Operating Systems - Windows 9x/2000/XP, UNIX

Languages - SQL, PL/SQL, PHP, HTML, CSS

PROFESSIONAL EXPERIENCE

Confidential , Reston, Virginia

OBIEE Consultant

Responsibilities:

  • Analyze Design, and Develop Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
  • Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
  • Install, configure, and administer the OBIEE platform. Created the OBIEE environment for migration between Development, Testing and Production environment over Windows.
  • Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures, and Security using External Table Authentication, Session Variables, and Initialization Blocks.
  • Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
  • Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
  • Performance has been an issue with many of the custom built reports & Dashboards which are solved in many ways like tuning the Query, content filters, Bitmap Indexes.
  • Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users.
  • Implemented Row level security in repository using filters and object level security and assigned privileges according to the AD groups.
  • Performed Unit testing, Integration testing, and Regression testing to validate report and mapping functionality.
  • Closely adheres and works towards milestones on development. Develop the repositories keeping in view best practices/methods from vendor.

Environment: OBIEE 11.1.7 .X, BI Publisher, Toad, SQL, PL/SQL, Oracle 11g,Windows 7

Confidential , Chantilly, VA

OBIEE Consultant

Responsibilities:

  • Responsible for setting up OBIEE 11.1.1.6 and OBIEE 11.1.1.7.0 environment on various servers. Installed relevant patching levels of OBIEE environment and upgrade environment to the latest supported versions.
  • Work with business analyst to formulate requirements and mapping source data, interpret business requirements and technical specifications.
  • Work as admin and set up OBIEE environment at the end client, which includes installing OBIEE on servers, installing patches, upgrading to new version and performance tuning.
  • Define OBIEE standards and best practices. Development of OBIEE reports and assists with the conversion of existing reports to the OBIEE.
  • Design and develop business intelligence components and reports, database integration, ETL processes, data warehouse architecture, reports and dashboard creation, KPI and analytics integration.
  • Installed, supported and maintained OBIEE environments (11g) and system components for various business functions
  • Initially set up security in a active directory in Weblogic later it was moved to single sign for EPA SMO Portal.
  • Developed Dashboard and reports (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters for different subject areas.
  • Security-restricting access to specific users, removing some built in options on Dashboard, adding clear button on dashboard for prompts, customizing oracle logo with EPA SMO logo on dashboards etc.
  • Provided guidance on standardization of policies, procedures and also provided supporting documentation of OBIEE environments.
  • Worked extensively on Data modeling. Design and develop schemas in data warehouse as the system has OLTP data model.
  • Developed many different Deliverable reports, Scheduling, Regional, Status reports which involves calculating different metrics and using time series functions.
  • Used Filters and provided customized Prompts (filtering options) appropriately to limit the appearance of excessive data on the reports.
  • Responsible for merging RPD and catalog from Dev to Stage and Production environments for every release which is usually a sprint (2 week) release.
  • Creates test scenarios and develops test plans to be used in testing the business applications in order to verify that client requirements are incorporated in to the system design.
  • Train users on building adhoc reporting using OBIEE tool and BI Publisher.

Environment: OBIEE 11.1.1.X,BI Publisher, Toad, SQL, PL/SQL, Golden, Oracle 11g, Oracle My Support, Windows 7, MS-Office Suite, WebEx, HTML

Confidential , Raleigh, North Carolina

OBIEE Consultant

Responsibilities:

  • Responsible for setting up OBIEE 11.1.1.5 environment on various servers and upgrading RPD, Catalog from 11.1.1.3
  • Installed, supported and maintained OBIEE environments (11g) and system components for various business functions
  • Supported the configuration items for failover, load balancing, caching, and security etc. with respect to OBIEE.
  • Involved in installing relevant patching levels of OBIEE environment and upgrade environment to the latest supported versions.
  • Responsible for setting up security in an Active Directory environment in Weblogic Server and other components (Enterprise manager).
  • Responsible for developing customized Dashboard and reports like adding an image to the Dashboard, Increase number of records excel can download, Security-restricting access to specific users, removing some built in options on Dashboard, adding clear button on dashboard for prompts, customizing oracle logo with Cisco logo on dashboards etc.
  • Developed and debugged many Dashboards, Reports using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
  • Provided guidance on standardization of policies, procedures and also provided supporting documentation of OBIEE environments.
  • Developed many Lab cases reports, Case monitoring, Inventory control reports which involves calculating different metrics and using time series functions.
  • Responsible for setting up Agents to send reports as emails to users.
  • Installed different patches which involved OBIEE to run on Firefox 10 and above version, security patch on Weblogic server, Patch on Legendry chart for not to display metrics labels on charts.
  • Used Filters and provided customized Prompts (filtering options) appropriately to limit the appearance of excessive data on the reports.
  • Assisted in analyzing testing results throughout the project
  • Responsible for merging RPD and catalog from Dev to Stage and Production environments for every release.

Environment: OBIEE 11.1.1.X, Toad, SQL, PL/SQL, Pentaho, Oracle 10g, Oracle My Support, Windows 7, MS-Office Suite, SnagIT8, WebEx, HTML

Confidential , Herndon, VA

Sr. OBIEE Developer

Responsibilities:

  • Involved in building OBIEE Reports for Financial and People Services sectors and validating data for the reports.
  • Involved in developing reports and setting up Dashboard Reports OBIEE.
  • Responsible for the Metadata design document (Physical Layer, Business Model and Mapping Layer and Presentation Layer, Variables, Initialization Blocks, Dimension Hierarchies, Level Based Measures) in the implementation phase.
  • Developed Calculated Measures and assigned Aggregation levels based on Dimension Hierarchies.
  • Created and administered the Physical Layer, Business Model and Mapping (BMM) Layer and the Presentation Layer in an OBIEE Repository using Administration Tool.
  • Configured Drilldown from General ledger to Subledger transaction level by using navigation feature in Oracle BI Answers as per user requirement.
  • Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns. Established the logical joins/keys.
  • Worked on BI Office integration with OBIEE 11.1.1.5
  • Worked on BI Publisher, MS Office Plug-in for rich reporting fixed the issues caused while generating the BI Publisher reports in OBIEE.
  • Responsible for upgrading OBIEE 11.1.1.3 to 11.1.1.5 including catalog and RPD migration.
  • Created Security settings in Administration Tool to set up Groups, Access Privileges and query privileges and also managed security for groups in Answers.
  • Customized Dashboards, Administered Permissions and Privileges for Dashboard visibility and modifications to users.
  • Involved in merging applications from Dev - Test – Prod for deployment.
  • Responsible for the Functional and Technical Design of the reports to be delivered.
  • Installed patches during migration from QA to Production environment.
  • Test the data against the Interactive Reports which were developed and also against the Essbase cubes using Excel Plug in.
  • Involved with the Testing team to resolve, fixing and testing problems found during the Systems integration test, UAT Phases.

Environment: OBIEE 11.1.1.x,Oracle 11g, BI Publisher, MS Access, Oracle My Support (SR), Hyperion 11.1.1.3, TOAD 9.0.1, Putty, WinScp, Secure CRT, MS-Office Suite, Windows XP Professional, MS-Office Suite, SnagIT8, Visio, Data Load, HP Project Management.

Confidential , Omaha, Nebraska

Sr. OBIEE Developer

Responsibilities:

  • Involved in developing Reports for FTI and OTM. Remodeled existing structure in FTI and designed BMM in RPD. Customizing out of box tables and creating required reports.
  • Customize the logical tables and columns, defined the Analytics dimensions, aggregations and levels.
  • Created Variables like Fiscal Week start date, Prior Fiscal Week End Date, Fiscal period start date and Fiscal Year start date which is used for creating Time Dimension Metrics.
  • Created Metrics which involves calculation like Year to Date, Month to Date, Weekly for shipments load.
  • Created customized tables and views at the backend and as well as in Physical Layer for developing fact tables.
  • Created and administered the Physical Layer, Business Model and Mapping (BMM) Layer and the Presentation Layer in an OBIEE Repository using Administration Tool.
  • Created and used Star Schema and Snowflakes for joining tables, Time Series Objects, Hierarchies, Level Based Measures, Session Variables, and Initialization Blocks.
  • Configured Fiscal Calendar in to FTI and used it instead of Out of box Gregorian calendar. This process involved creating time dimension hierarchy and by defining physical and logical joins between Tables.
  • Work on several Tables related to Transportation and Finances.
  • Created additional Dimensional Hierarchies and build metadata around new custom dimension & facts table. Confirmed the new fact tables to the existing dimension tables.
  • Created reports which involved navigation, filters, and prompts. Used Pivot table and table view for all the financial reports.
  • Designed interactive Dashboard to Dashboard to launch these OTM reports based on user privileges.
  • Configured Drilldown for Summary Level report to Detail level report by using navigation feature in Oracle BI Answers as per user requirement.
  • Used Filters and provided customized Prompts (filtering options) appropriately to limit the appearance of excessive data on the reports.

Environment: OBIEE 10.1.3.3.4 ,OTM 6.1,SQL Developer, SQL, PL/SQL, UNIX,SQL Query Analyzer, Oracle 10g, XML Publisher, Oracle Metalink, Putty, WinScp, Windows XP,UNIX, MS-Office Suite, SnagIT8.

Confidential, San Antonio, Texas

Sr. OBIEE Developer

Responsibilities:

  • Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs documents by following Oracle AIM methodology.
  • Maintenance business representatives for gathering the OBIEE Reports / Dashboards requirements and to define business and functional specifications Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling.
  • End to End Repository creation, Reports Creation, Prompts, Dashboards and Data Modeling in OBIEE on Oracle 10g database.
  • Customizing and Developing reports as per client requirements.
  • Worked on Oracle BI Repository- Presentation Layer, Business Model and Mapping Layer (BMM), Physical Layer. Dashboard Reports from Development to Test/QA and to Production.
  • Configured measures in the Business Model Layer and mapped to multiple logical source tables.
  • Developed Time Series objects for comparing the usage variations between the current and previous years and months.
  • Created Dimensional Hierarchy (Geo, Calendar, Product, Account, Customer Type ), Level based Measures such as, Yearly Revenue, Quarterly Revenue, Month to Date Revenue and Aggregate navigation in BMM layer
  • Analyzed and validated the business model in Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the Business Model and Mapping layer.
  • Developed Reports / Dashboards Pages, Sections, Requests/Answers with different Analytics Views (Drill-Down / Dynamic, View/Column Selector, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).
  • Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, re-building of indexes, overwriting the SQL execution path.
  • Implemented Security by creating roles & web groups using LDAP Authentication.
  • Used OBIEE’s BI Publisher to create various interactive Sales related reports drillable by Region, District, Territory, Date, Customer etc. Reports were provided in several intuitive and visually appealing formats such as Charts, Graphs, Tables, PDF. Designed and implemented an interactive Dashboard to launch these enterprise reports based on user privileges.
  • Worked on BI Publisher in developing the templates and generating the reports.
  • Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.
  • Tested and debugged the application using SQL scripts and appropriate log files.
  • Also worked on Business Objects which was used by Client in order to validate data for the developed reports.
  • Help testing team with test scripts, defects resolution, etc. and Interact with Users during User Acceptance Testing (UAT).

Environment: OBIEE 10.1.3.3.4 , Business Objects, Oracle 10g, BI Publisher, Oracle My Support (SR), TOAD 9.0.1, , Mercury Test Director, XML Publisher, Oracle Metalink, Secure CRT, Windows XP Professional, MS-Office Suite, SnagIT8, Oracle SQL, Putty, WinScp.

Confidential , Jacksonville, Florida

Sr. OBIEE Analyst/Developer

Responsibilities:

  • Performed Installation & Configuration of Oracle Business Intelligence Enterprise Edition.
  • Reviewed Functional Design Document and Technical Design Document.
  • Worked closely with Business Analyst, Discussed & Gathered the requirements from different user groups.
  • Designed Prototype of the project repository and developed reports/dashboards to make it easier for business users to visualize how reports will look like in OBIEE.
  • Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns. Established the logical joins/keys.
  • Used Aggregate Tables at Sales Fact over different measures and specified Aggregate Levels for each source.
  • Designed Intelligence Dashboards and created Global Filters like Year, Quarter, Month, Product, and Distributor.
  • Customized the logical tables and columns, defined the Analytics dimensions, aggregations and levels.
  • Created Dimensional Hierarchy (Geo, Calendar, Product, Distributor), Level based Measures such as Category Sales, Yearly Sales, Regional Sales and Aggregate navigation in BMM layer.
  • Configured bar/pie charts, title/table/pivot table/compound/narrative/filter/gauge/column selector/view selector/static text/no result views, filters by region/product in user interface. Configured Global Filters and Prompts by year/quarter/month and other measures in Siebel/OBIEE Analytics Web.
  • Added new Dimensions and Columns to the Subject Areas to fulfill the additional Requirements of the Business Analysts.
  • Worked on BI Publisher, MS Office Plug-in for rich reporting.
  • Involved in Unit/Integration Testing & user training of the generated reports.
  • Involved in merging applications from Dev - Test – Prod for deployment.
  • Involved with the Testing team to resolve, fixing and testing problems found during the Systems integration test, UAT Phases.
  • Created Migration Documentation and Process Flow Documentation for mappings and sessions.
  • Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping
  • Created Test plan and Unit test case Traceability Matrix and tested the validity of the data in warehouse.
  • Created Sessions, Workflows and database connections using Informatica Workflow Manager.

Environment: OBIEE 10.1.3.3.3 , Informatica PowerCenter 8.1.1, Data Warehouse Administration Console(DAC), Oracle BI Applications 7.9.5, BI Publisher, Oracle 10g, PL/SQL Developer, Oracle SQL, SQL * Loader, PL/SQL Procedures, TOAD, Windows 2000, UNIX, Shell Scripts, ER Studio.

Confidential , Pune, India:

Siebel Consultant

Responsibilities:

  • Analyze Design, and Develop OBIEE/Siebel Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
  • Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures, and Security using External Table Authentication, Session Variables, and Initialization Blocks.
  • Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters. Extensively used Siebel Delivers and iBots.
  • Developed many complex Initial/Incremental Informatica Objects (Workflows / Sessions, Mappings/mapplets with various transformations i.e., expressions, aggregators, filters, lookup, stored procedures transformations, join, normalize, filter, router, sorter and update strategy).
  • Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
  • Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users.
  • Implemented the delivery of iBots using Siebel Delivers to alert the associated teams.
  • Performed Unit testing, Integration testing, and Regression testing to validate report and mapping functionality.
  • Responsible for Functional Design Document.
  • Interact with Users during User Acceptance Testing (UAT).
  • Manages detail design efforts based on agreed requirements/scope.
  • Closely adheres and works towards milestones on development.
  • Develop the repositories keeping in view best practices/methods from vendor.
  • Responsible for deliverables needed for vendor reviews.
  • Help testing team with test scripts, defects resolution, etc.

Environment: Oracle BI Applications 7.9.3, OBIEE 7.8.4, Informatica 7.1.4, TOAD, SQL, PL/SQL, SQL Query Analyzer, Oracle 10g, XML Publisher, Oracle Metalink, CVS/Eclipse, Sun Solaris 5.10, Mercury Test Director, Putty, WinScp, Windows XP Professional, MS-Office Suite.

Hire Now