We provide IT Staff Augmentation Services!

Sr. Obiee Analyst Resume

New, JerseY

SUMMARY:

  • Five years of experience in analysing and implementing the business intelligence solutions .
  • Having experience in capturing the business requirements, poc, resource estimation and execution strategy planning for smooth production delivery.
  • Expertise in providing end - to-end business intelligence solutions by configuring metadata & building Analytics Repository, dimensional modeling design, building business data marts, generating reports, and creating Interactive Business Intelligence Dashboards using Oracle Business Intelligence .
  • Excellent understanding of Dimensional modeling techniques such as Star and Snow flake Schema methodologies.
  • Experience in using Master-Detail Event navigation, Mapview,Oracle eLocator.
  • Worked in different Industrial Verticals and well experienced in Finance and HR Functional Areas.
  • Deployment of rpd/webcat, creating application roles, groups, setting the configuration parameters using Enterprise Manager/Weblogic console.
  • Experience in developing reports and configuring various delivery options in BI Publisher and Capacity, Scaling and Performance planning in OBIEE.
  • Extensively designed Interactive Dashboards, incorporating user friendly capabilities such as dashboard prompts, navigation, drill-down and Web Catalog Objects using OBIEE.
  • Experience in creating OBIEE Scorecards for various KPIs, enabling write back feature Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Analysis by implementing Aggregate navigation, cache management and materialized views.
  • Excellent problem solving skills with strong technical background and having the ability to meet deadlines and quickly master new technologies and skills.

TECHNICAL SKILLS:

FMW Technologies: Orace Business intelligence Enterprise Edition, Oracle BI Cloud Service, Oracle BI Publisher, Weblogic

ETL: PL/SQL

Tools: Toad, SQL Developer

Databases: Oracle 10g/11g, MS SQL Server

Programming Languages: SQL, PL/SQL, c

Operating System: Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Sr. OBIEE Analyst

Responsibilities:

  • Coordinating with product management for gathering the requirements and writing functional specification documents.
  • Analyzing the requirements, performing feasibility and gap analysis for existing FTI Catalyst Repository and dashboards.
  • Logical and Physical data modeling was done for FTI Catalyst data warehouse in STAR Schema.
  • Using Informatica Power center created mapping and mapplets to transform the data according to the business rules.
  • Used various transformations like Source Qualifier, Joiner,Lookup,Filter, Expressions and Update strategy.
  • Created and configured workflows and sessions to transport the data to target warehouse Oracle tables using informatics workflow manager.
  • Developed stored procedures and used them in Stored procedure transformations for data processing and have used data migration tools.
  • Designed FTI Catalyst repository data model and dashboards for Productivity, Core Measures subject area.
  • Implemented various Time Series calculations and dimensional Ragged/Skipped hierarchy, Master detail’s events.
  • Added performance tuning parameters across Weblogic, BI Server, BI Presentation server.
  • Configured monthly alerts for FTI Catalyst summary dashboard page for executives and department managers.
  • Involved in upgrade FTI Catalyst dashboard and repository and security migration from 10.1.3.4.2 to 11.1.1.7.0 . Resolved various 11g upgrade issues.

Environment: OBIEE 10.13.4.2,OBIEE 11.1.1.1.7.0, Oracle DB 11g, Informatica 8.1,PL/SQL,SQL, Web logic Server,, Enterprise Manager, Windows 7

Confidential

Sr. OBIEE Consultant

Responsibilities:

  • Interacted with business teams to gather Business Requirements as well as to define business and functional specifications for new and BAU enhancements.
  • Involved design and development of repository (RPD) (creating/Modifying objects in Physical, Business and Presentation layer) and the process of repository migration.
  • Expressions mapped logical columns in BMM layer to physical columns in the physical layer. Developed Reports/ Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Column Selector, Tabular with global and local Filters).
  • Used Filters and provided Customized prompts appropriately to avoid excessive data showing up in reports to improve performance.
  • Administered Permissions and Privileges for dashboard visibility and modifications to Users based on their groups or responsibilities.
  • Responsible for implementing Object level security for the various users who would be using the BI system.
  • Extensively involved in setting up Data level security for the BI Reports and also handled the security and privileges from the Database to the Oracle repository.
  • Setting up the Administered Privileges and Security for various users using the LDAP security.
  • Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes
  • Involved in migration of OBIEE 10g to OBIEE 11g by doing minimal RPD changes where ever it is required to accomplish 10g results.
  • Communicating with Oracle product team on the product limitations after 11g upgrade in terms of data download issues(like excel 2003, 2007)
  • Security User maintenance by migrating existing 10g user list to LDAP Authentication service support in 11g.
  • Managed SIT, UAT tests for the 10g and 11g using HP ALM Application.

Environment: OBIEE 10.13.4.2,OBIEE 11.1.1.1.7.1, OBIA 7.9.6.2, Oracle DB 10g,PL/SQL,SQL, Web logic Server, Enterprise Manager, Unix, Shell script

Hire Now