SUMMARY:

• Strong understanding of Dimensional Modeling, Star and Snowflake schemas
• Extensive knowledge of Oracle Business Intelligence Enterprise Edition 11g
• Development experience includes Oracle BI Analytics Repository (.rpd) which consists of: Physical Layer, Business Model and Mapping Layer, Presentation Layer, Interactive Dashboards, Reports with drill - down capabilities using page and dashboard prompts and other Web Catalog Objects such as Filters, Folders
• Extensive knowledge of setting up Data Level Security.
• Extensive knowledge of tuning report/query performance by utilizing aggregate tables, materialized views etc.
• Extensive experience in building Interactive Dashboards with drill- down and drill- across capabilities
• Experience in modeling aggregate tables to speed processing and building calculated measures for the fact tables.
• Hands on experience in developing OBIEE repository development, configuring metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports).
• Experience in creating dimensional hierarchies, level-based measures and adding multiple sources to business model objects.
• Experience with Authorization to the external tables.
• Experience in setting up a Multi-User Development Environment (MUD) and using OBI Answers to run queries to test and validate the repository.
• Proficient in using the Time-Series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts and creating pivot tables using OBI.
• Strong knowledge in working with core Java
• Quick learner, able to work with conflicting priorities, excellent team player with the ability to meet deadlines under pressure.

TECHNICAL SKILLS:

BI Tools: OBIEE 11gR1/R2, 10.1.3.x, Web Logic Server 10.3, 10.3.3, BI Publisher

Languages: SQL, PL/SQL, XML, HTML, SQL server Management studio 2008

Databases: Oracle 10g/9i, MS SQL Server 2000/2005, MS Access

Operating: Windows 7, Windows Server 2003/2008/2012 system

PROFESSIONAL EXPERIENCE:

Confidential -Fargo, ND

OBIEE Developer

Responsibilities:

• Customizing Physical, Business and Presentation layers in Oracle Business Intelligence Administration Tool.
• Used BI Publisher to generate Rich Text Format reports.
• Created and modified Database Views as part of the production support
• Made modifications to the repository as well as to the reports to eliminate the design issues with the reports.
• Configuring repository and session variables
• Developed report level and dashboard level prompts.
• Designed new reports using BI Publisher with the custom layouts.
• Creating documentation step by step for the approach in the development of OBIEE code.
• Tuned Database Views for performance.
• Migration of Web catalogs and Repository files (.rpd file) across environments.
• Involved in the Upgrade process from OBIEE 10.1.3.4 to
• Created reports and dashboards on usage tracking
• Used Multi User development in order to make any modifications to the rpd.
• Used Web catalog to migrate reports, dashboards and User groups from Dev environment to UAT Environment.
• Involved in OBIEE 11g Upgrade.

Confidential

OBIEE Developer

Responsibilities:

• Analyze and Gather business requirements to provide better & enhanced reporting solution
• Created the Technical Specification Document and Functional Specification Document based on business specs.
• Configured OBIEE Repository to provide Analytical Reporting solutions to business.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features to meet the business requirements.
• Implemented MUD (Multi User Development) Environment.
• Implemented Security & Cache features to accommodate business requirements.
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs.
• Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users.
• Used prompts such as Global Filters, Column Filters for the manager to select particular column
• Used the Catalog manager and maintained the web catalog to manage Dashboards, Answers.
• Developed various reports using OBIEE presentation services.
• Extensively worked in Dashboard Prompts, Page Prompts, Narratives and presentation variables in the RPD and Dashboards.
• Involved in setting up Data level security for the OBIEE Reports and also handled the security and privileges from the Database to the Oracle repository.
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and making some changes to Reports.
• Use of Key Performance Indicators in viewing the results from the database.

Confidential

OBIEE Developer

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements.
• Involved in creating the Star Schema, Logical and Physical Modeling.
• Built the repository (Physical Layer, Business Model and Mapping Layer and Presentation Layer).
• Created Complex Joins, Alias Tables and Views.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively.
• Created Aggregated Tables and Configured the Content in Business Model Layer to use the Aggregate Tables for better Performance.
• Worked extensively on Answers, Delivers, and Interactive Dashboards for Procurement and Spend Analytics.
• Developed Various Dashboards and Reports and Created the Business Model for Ad-hoc queries using Oracle BI Answers and assigning them to application specific dashboards.
• Designed the Row Level Security for the Managers to View the Reports pertaining to their Region.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Involved in Testing the reports and writing Test cases for Reports developed.
• Installed and configured Oracle BI Publisher and its integration with Oracle BI Presentation services.
• Analyzed the Functional specifications provided by the Data Architect and Created Technical Specification Documents for all the mappings.

Confidential

OBIEE Developer

Responsibilities:

• Involved in user requirement and requirement specification from users.
• Documenting business requirements, functional specifications and test requirements.
• Worked with Business users to create new reports and modify existing reports.
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters)
• Identified the key facts and dimensions necessary to support the business requirements.
• Customizing Physical, Business and Presentation layers in Oracle Business Intelligence Administration Tool.
• Conceptualization of business models and defining different aggregates and hierarchy in Oracle Business Intelligence tool.
• Addition of multiple sources to a dimension and to add calculation to a fact table.
• Configuring repository and session variables
• Authenticate users and maintained Object and Data level security.
• Created users and repository groups for different permission level.
• Implementing cache management and enhancing query performance.
• Created several reports including table view, pivot table view and chart view in OBIEE Answers
• Customized the different dashboards and reports to look and feel as per the business requirements.