SUMMARY:

• 6 years of experience in OBIEE 11.1.1.5, and OBIEE 10.1.3.3.2, which included building and configuring repository, creating and managing intelligence Dashboards, Answers, Delivers and iBots (Agents).
• Extensive experience on OBIEE Administration Tool covering all three Layers namely Physical, layer, BMM Layer and Presentation Layer.
• Extensive experience in OBIEE/ Siebel Analytics Presentation Services including Answers, Interactive Dashboards, Delivers/agents (iBots), Cache Management, Scheduler Configuration, BI Publisher.
• Used Administration tool to configure Multiuser Development Environment (MUDE) for multiple user for the development environment.
• Expertise in OBIEE Publisher, Oracle BI / Siebel Security Setup (groups, data access/query privileges), Metadata Objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports) and BI Publisher.
• Well versed in Performance Tuning of OBI Dashboards / Reports to improve performance at Database
• Excellent problem - solving skills with strong technical background and good interpersonal skills.
• Developed and debugged Dashboards/reports visibility with respect to user’s responsibility and web groups in an integrated environment.
• Quick learner and an excellent team player, ability to meet deadlines and work under pressure.
• Analyzed, designed, developed and implemented data warehousing in ETL processes using ODI 11g

TECHNICAL SKILLS:

Reporting tools: Siebel 7.8.4, OBIEE 11.1.1.5/6, OBIEE 10.1.3.x.

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, TX

OBIEE Consultant/Data Analyst

• Data discovery using Endeca Information Discovery tool
• Collect data and metadata using Oracle business Intelligence as native data source for Endeca to analyze it to render statistics such as: maximum and minimum values; attributes, lengths, patterns, data types and data integrity.
• Experience with the Integrator Knowledge Module for Oracle Data Integrator to enable the Enterprise Information Module to load data into the Endeca Server.
• Data Profiling: assessing the quality of data through metrics to discover rules based on the data.
• Experience in Cross Column analysis and inter-table analysis
• Profiling on Impala with Talend.platform
• Identify, compare, and resolve data quality problems.
• Evaluate large dataset for quality and accuracy.
• Determine business impact level for data quality issues.
• Collaborate with business area representatives for requirement analysis and to define business and functional specifications.
• Create/Modify metadata repository (RPD) by using BI Administration tool. Physical Layer, Business Model and Mapping, and Presentation Layers.
• Created dashboards/reports and also customize pre-built dashboards.
• Have used Administration Tool to configure Multiuser Development Environment (MUDE) for multiple user for the development environment.
• Created Pivot tables and views including dashboard prompts for creating intelligent dynamic dashboards.
• Extensively used Delivers and agents.
• .Developed and debugged Dashboards/reports visibility with respect to user’s responsibility and web groups in an integrated environment.
• Performance tuning
• Set up Data level and Object level Security
• Add Users and Roles

Confidential, San Francisco, CA

OBIEE Consultant

• Developed Metadata repository (RPD), configured the Physical Layer, Business modeling and Mapping and the Presentation Layer as per the data requirements using OBIEE Admin tool.
• Performed modeling activities which included building star schemas as per the business requirements and configuring the Logical Layer, Logical tables, dimensions and columns. Established the logical joins/keys.
• Used Aggregate Tables and specified Aggregate Levels for each source.
• Designed Intelligence Dashboards and created Global Filters.
• Customized the logical tables and columns, defined the Analytics dimensions, aggregations and levels.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Configured charts, views, filters in user interface. Configured Global Filters and Prompt in Presentation Services.
• Added new Dimensions and Columns to the Subject Areas to full fill the additional Requirements of the Business Analysts.
• Have used Administration Tool to configure Multiuser Development Environment (MUDE) for multiple users for the development environment.
• Used customized, Dashboard prompts & local prompts on UI.
• Formatting results, Filtering requests, and Showing results with Pivot, Chart, & Views in Presentation Services.
• Set up Data level and Object level Security
• Add Users and Roles
• Cache Management
• Used ODI designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouses.

Environment: Oracle Business Intelligence 11.1.1.5, Oracle 10g, Oracle SQL developer, Toad, Windows 2007. Linux

Confidential, Orlando, FL

OBIEE Consultant

• Partnered with Database Administrators and DW developers to achieve great BI performance
• Act as Subject Matter Expert in OBIEE metadata and metadata standards
• Help BI and users understand and query data to accomplish their business purpose
• Respond promptly and effectively to resolve incidents.
• Gather requirements for change by meeting with customers and listening actively
• Meet time and cost estimates when implementing a change
• Ad hoc report
• Analyzed, designed, developed and the implementation of data warehousing in ETL process using ODI 11g.
• Used Aggregate Tables and specified Aggregate Levels for each source.
• Designed Intelligence Dashboards and created Global Filters.
• Customized the logical tables and columns, defined the Analytics dimensions, aggregations and levels.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Configured charts, views, filters in user interface. Configured Global Filters and Prompt in Presentation Services.
• Added new Dimensions and Columns to the Subject Areas to full fill the additional Requirements of the Business Analysts.
• Used customized, Dashboard prompts & local prompts on UI.