We provide IT Staff Augmentation Services!

Obiee Developer/ Bi Analyst Resume

San Francisco, CA

SUMMARY:

  • 8 years of experience as Oracle Business Intelligence and Applications Consultant with successful track record in gathering user requirements, designing, developing and supporting different Business Applications.
  • Experienced in customizing Intelligence Dashboards/Scorecards with drill - down capabilities using global and local Filters Analytics Security Setup (groups, access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders and Reports).
  • Good Knowledge in Developing OBIEE Reports using 11G/10g.
  • Well versed with using SQL and PL/SQL for BI Publisher and XML Publisher.
  • Developed different types of reports including RTF, EXCEL, and ETEXT TEMPLATES.
  • Expertise in Oracle BI Publisher, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Server.
  • Followed the Agile methodology to develop full life cycle project development.
  • Experience in data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification, and OLAP.
  • Experience in providing end-to-end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports).
  • Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
  • Experience in creating and using Initialization blocks, Dynamic, Static, and Session Variables.
  • Experience in XML/BI Publisher, which includes working on report development objects like data templates and RTFs.
  • Strong experience in developing and customizing Reports and Forms using Oracle Reports 10g/4i Discoverer 10g/4i and XML Publisher 5.6.3/5.6.2, OBIEE 10.1.3.x.
  • Experience in supporting the production system and handling day-to-day issues.
  • Experience in training business users on OBIEE Answers and Dashboards and educating technical super users and administrators on repository and web catalog migrations procedures with Oracle best practices.
  • Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self-motivated to work independently with excellent communication skills.
  • Migrated Repository and Web Catalog from one environment to another environment.
  • Devised strategy for refreshing reports Query caching. Optimized database indexes and run statistics process for enhancing query performance.
  • Very proficient in SQL tuning and optimization of queries
  • Excellent analytical, problem solving and communication skills with ability to be an effective team member and have the capability to work under severe time constraints.

TECHNICAL SKILLS:

BI Tools: Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.0.0/11.1.1. x/ 10.1.3.x, BI Apps 7.9.6.x/7.9.5.x and BI Publisher

ERP: Oracle EBS

ETL Tools: Informatica 9.1/9.5/8.x/7.x

RDBMS: Oracle 11g/ 10g/9i/8i/7.x,Netezza

Utilities: SQL Developer, TOAD, SQL*PLUS

Scripting Languages: Unix Shell scripts, K shell, C shell.

Languages: SQL, PL/SQL, XML, XLST.

Operating System: Windows 07/NT/XP/2000/98, Sun Solaris, Unix, Linux

WORK EXPERIENCE:

Confidential, San Francisco, CA

OBIEE Developer/ BI Analyst

Responsibilities:

  • Designed, Developed and Analyzed OBIEE Metadata repository (.rpd) that consists of physical layer, multiple business model/layers with aggregates, dimensions & time series objects, presentation layers with catalogs & folders.
  • Interacted with the end users for requirement gathering and defined requirement specifications document.
  • Involved in Data Modeling, Design documents and data warehouse.
  • Installed and Configured OBIEE 11g and 12C.
  • Understand project requirements and work towards design and developments of the plan layout.
  • Created connection pools and imported the metadata into Physical layer.
  • Built Business model and established relationships, created joins, level based measures in BMM Layer. Created Time-series function.
  • Created different types of Customized Reports Drilldown, Dimensional hierarchies, Aggregation to meet client requirements.
  • Organize presentation layer in a format that is easy for end users to use as basis for reporting using Oracle BI Administration tool (.RPD).
  • Worked with session and repository variables and initialization blocks to streamline administrative tasks for generating filters and defining security.
  • Generated various Analytics Reports.
  • Implemented OBIEE security at the object, data levels and Restricting data for particular users using Row level security and User filters.
  • Developed OBIEE Dashboards, Analysis, Prompts, KPI’s and scorecards using global and local filters.
  • Created different analytics views including Pivot Table, Charts, Gauges, Column Selector, View Selector and prompts using Oracle BI Presentation Services.
  • Validated the data in SQL Developer to make sure the reports were consistent.
  • Migrated OBIEE Dashboard, Pages, Reports and other web catalog folders from DEV to UAT and UAT to Prod
  • Added users, Application and Catalog roles and configured security in WebLogic console of OBIEE 11g.
  • Involved in Performance tuning and enhancing the reports/dashboards using cache management and working with the DBA to figure out if we needed to create indexes, aggregate or partition columns to increase the processing time of reports.
  • Created detailed design documentation and unit test plans in SDLC documents.
  • Providing guidance and support to end users during the implementation and in production

Environment: OBIEE 11g, OBIEE 12c, BI Publisher 11g, ODI, Oracle 11g, SQL Developer, TOAD, Windows7, Supply chain management, PeopleSoft

Confidential, Lake Forest, IL

OBIEE/ BI Publisher Developer

Responsibilities:

  • Worked as an OBIEE /BI Publisher Developer in multiple projects
  • Primary responsibilities include gathering business requirements, designing the functional and technical specifications
  • Analyze, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository as per the Standards
  • Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns
  • Worked on Dashboard and Page level prompts and Report filters
  • Created Logical Columns based on other Logical and Physical columns in the BMM layer
  • Worked on Agile methodology to keep the whole team involved in the project in terms of communication.
  • Gave a scope for enhancements and Change management in place with agile methodology.
  • Designed Schemas using Fact, Dimensions, Hierarchical, Physical, Logical, Alias and Extension tables with star and snowflake architecture
  • Managed security privileges for each subject area and dashboards according to user requirements
  • Developed ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters)
  • Developed and tested Store procedures, Functions and packages in PL/SQL for BI Publisher reports
  • Developed BI Publisher reports using Dynamic SQL
  • Migrated Oracle 6i reports into Oracle BI Publisher
  • Trained IT resources to Develop reports using BI Publisher tool, OBIEE Admin tool and trained Business users for ad hoc Reporting
  • Developed different TEMPLATES for BI Publisher reports.

Environment: OBIEE 11.1.1.6, BI Publisher 11g,Oracle reports6i/9i,Maximo,ODI, Oracle 11g,TOAD, Unix

Confidential, Rockville, Maryland

OBIEE Developer/ BI Analyst

Responsibilities:

  • Worked as an OBIEE Developer/Technical Analyst in multiple projects. Implemented OBIEE/BIP across multiple environments and developed metadata for each aspect of the business to report on.
  • Worked extensively with OBIEE Administration tool, Presentation services and BI Publisher.
  • Analyze, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
  • Worked with Security team to define users and groups, set permissions, Group Inheritance, Authentication Methods, Query Limits, Timing Restrictions, Filters and also implemented Object level and data level Security
  • Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE 11g Administrator tool.
  • Reporting on two Fact tables using conformed dimension
  • Migrated Analytics RPD and Web catalog from one environment to another
  • Developed ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, and business rules with user identity and roles within the OBIEE/BIP
  • Developed BI Publisher reports using Bursting Definition to deliver to a server/File.
  • Developed different types of BI Publisher reports including RTF, EXCEL, ETEXT TEMPLATES
  • Worked with JAVA Developers to run BI Publisher reports using BI Publisher web services
  • Trained IT resources to Develop reports using BI Publisher tool and trained Business users for ad hoc Reporting
  • Designed Reporting Standard and Guidelines Document(SPP Standards)
  • Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
  • Designed, implemented and tested security privileges on Dashboards and reports.
  • Migrated Web catalog and RPD from one environment to other environment.
  • Used the expression builder in the BMM layer and created various calculation measures.
  • Created Dimensional Hierarchy, Aggregate columns, Level based Measures and Aggregate navigation in BMM layer to improve performance in rpd.
  • Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
  • Involved in Unit Testing and Performance Testing for reports.

Environment: OBIEE 11.1.1.7/11.1.1.6, BI Publisher 11g, Oracle 11g, Informatica 9.5/9.1, TOAD, Unix, Netezza

Confidential, TAMPA, FL

OBIA/ OBIEE Developer

Responsibilities:

  • Analyze, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
  • Created Dimension hierarchies to achieve the drill down functionality.
  • Designed and Developed Custom Mappings, Workflows and Registered in DAC.
  • Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
  • Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse (OLAP) system.
  • Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.
  • Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
  • Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
  • Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and to date functions.
  • Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level. .
  • Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.
  • Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
  • Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
  • Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications
  • Developed many Full/Incremental Informatica Objects (Workflows/Sessions, Mappings/mapplets) with various transformations.
  • Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
  • Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.

Environment: Oracle Applications 11.5.10, Service Requests, Service Contracts, Install Base, General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Oracle Purchasing, Oracle 11g, OBIEE 10.1.3.4.1, Informatica 8.6.1, DAC 10.1.3.4.1, XML/BI Publisher 5.6.3, Discoverer 10g, Reports 10g, SQL*PLUS, SQL*Loader, TOAD, Unix

Confidential

OBIEE Developer

Responsibilities:

  • Integrated OBIEE with EBS for Single Sign On (SSO).
  • Extracted the data from the source system EBS R12, transformed the data and loaded into the OBIEE analytics warehouse using Informatica.
  • Implemented Financial Analytics, Procurement and Spend Analytics, integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
  • Worked on Oracle/PeopleSoft reports on OBIEE for GL, AP and Projects.
  • Created Budget vs Actual report with details drill down for each Cost Center.
  • Created/Modified/ Customized Metadata repository (.rpd) and Configured Metadata Objects using OBIEE Admin tool.
  • Analyzed, Designed, and Developed OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
  • Interacted with SME’s, Business Analysts and Users for gathering and analyzing the Business Reports Requirements.
  • Gathered requirements from the client for GAP analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
  • Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures and Security using External Table Authentication, Session Variables, and Initialization Blocks.
  • Designed, implemented and tested security privileges on Dashboards and Reports.
  • Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
  • Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System (EBS) to staging system (SDE mappings) and to the target Analytics Warehouse.

Environment: Oracle Applications R12 (GL, AR, AP, OM, INV, PO), OBIEE 10.1.3.4.1, Oracle BI Applications 7.9.6.1, Oracle 10g, Informatica 8.6.1, DAC 10.1.3.4.1, SQL*Loader, TOAD

Hire Now