We provide IT Staff Augmentation Services!

Obiee Developer Resume

Columbia, MD

PROFESSIONAL SUMMARY:

  • 5 Years of experience in IT with full life cycle implementation of Oracle Business Intelligence Product suites (OBIEE).
  • Extensive expertise in providing end - to-end business intelligence solution by configuring metadata& building analytics metadata repository, star schemas, snow flake schemas, dimensional modeling design, building business models, generating reports, and creating interactive BI dashboards.
  • Extensive experience in building and customization of interactive dashboards with drill down capabilities using global & local filters, contextual navigation, guided analytics, Business Rules with User Identity & roles, profiles & personalization and creating and scheduling I-Bots.
  • Experience in up gradation from OBIEE 11g to 12c and performing environment setups as per client requirements.
  • Experience in up gradation from OBIEE 10g to 11g migrating RPD, Catalogs and applying patches
  • Extensive experience in migration of OBIEE Presentation Services objects using OBIEE Catalog Manager and repository files between different environments
  • Experience in performance tuning, security, cache management, aggregation and usage tracking.
  • Experience in Setting the Write back functionality to update or insert the data into the tables in the database in OBIEE.
  • Experience of working in MUDE, resolve conflicts and maintain consistency
  • Experience in OBIEE Administration activities as OBIEE Installation, LDAP Configuration, Map Viewer Configuration, Essbase Connectivity and Cluster Configuration.
  • Worked in importing data from heterogeneous data sources like database, flat file, XML files, excel.
  • Designed Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse.
  • Export/Import interfaces, packages and it’s scenarios across different environments.
  • Implemented Interfaces for loading Source data into Staging area and Staging data into Dimension and Fact tables of Reporting Data mart
  • Expertise in debugging, optimizing the performance tuning of Oracle BIEE 10g/ 11g Repository & Dashboards / Reports by implementing Aggregate tables, Fragmentation of data sources, Indexes and Cache management.
  • Experience in performing end to end testing including Data Validation, Unit Testing and UAT.

TECHNICAL SKILLS:

Reporting Tools: OBIEE 10G/11G/12C, OBIA 7.9.6.3, BI Publisher, BI Publisher Desktop.

RDBMS: Oracle 8i/9i/10g/11g, MS SQL server, MS Access

ETL Tools: Oracle Data Integrator 10g,12C(ODI)

Operating Systems: Unix,Windows Server 2003 Enterprise Edition

Scheduling Tools: DAC, Cron Jobs

Applications: MS Office Suites (Excel, Word, PowerPoint, Access)

Querying: T-SQL,PL/SQL

Database: Oracle 11g/10/9.x, Teradata, MS SQL Server

Database Clients: TOAD, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, MD

OBIEE Developer

Environment: ODI 11g, OBIEE 11.1.1.6, 11.1.1.1.9, OBIEE 12C

Responsibilities:

  • Very good at 12c, with new features like Visual Analyzer, Heat Matrix, the BAR File, and using the command line to upload and download the RPD.
  • Captured and developed OBIEE 11g technical solutions. Complete requirements analysis, capture and document the customers business and technical needs.
  • Building a business and presentation layer within OBIEE 11g to meet the business requirements of the project.
  • Create reports and graph dashboards using OBIEE 11g to meet the business requirements of the project.
  • Develop user friendly reports/interactive dashboards with different analytic views including column selector, pivot tables, charts allowing managers to analyze the business from different perspectives.
  • Use filters and provide customized prompts appropriately to avoid excessive data showing up on reports
  • Perform administrative tasks related to the development and configuration of Interactive Dashboards
  • Actively train users so that they could efficiently navigate the dashboards
  • Help create connection pools, imported physical tables and defined joins in the physical layer of the repository
  • Assist with building the physical, business model and mapping and presentation layer of the repository.
  • Define facts, dimensions, level based measures/hierarchies, time Series and aggregation in dimensional modeling.
  • Analyze and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and validating repository level calculations done in the business model layer
  • Create variables in OBIEE to streamline administrative tasks
  • Upgraded OBIEE from 11.1.1.7 to 12.1.1.0 and performed Environment setup as per our client requirements.
  • Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.
  • Created complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
  • Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
  • Implemented Write back functionality to update or insert the data into the tables in the database in OBIEE.
  • Managed security privileges for each subject area and dashboards.
  • Migrated Code from Development to Testing to production.

Confidential

OBIEE Developer

Environment: Linux, OBIEE 11.1.1.6, 11.1.1.7.1

Responsibilities:

  • Responsible for working with the DBAs, Data Architects, ETL Consultants to define data sources and issues
  • Created/modified reports and dashboards using BI Analytics
  • Used filters and prompts in reports and dashboards to limit data showing in reports
  • Created reports with different views (table, chart, narrative, pivot)
  • Extensive experience in using BI Admin Console, Enterprise Manager and BI Analytics
  • Managed security by creating users and assigned them to groups as per business requirements
  • Deployed RPD in EM ready for analytics
  • Extensive experience in working in RPD's three layers (Physical, BMM, Presentation layers)
  • Created connection pools, alias tables, star/snowflake schemas in the physical layer
  • Created business models, logical columns, hierarchies, level based measures in BMM layer
  • Created subject areas, presentation tables and columns, and reordered them in the presentation layer
  • Used the consistency checker to check for errors, warnings, and best practice violations
  • Used caching and aggregate tables to manage performance
  • Validated RPD by creating reports to make sure there are no errors

Confidential

OBIEE Developer, BI Publisher 11g

Environment: ODI 11g, OBIEE 11.1.1.5.4, 11.1.1.7

Responsibilities:

  • Working closely with end user community to enhance and improve the user experience look and feel
  • Requirement gathering from the client and perform gap analysis and build the solution
  • Proposed the enhancements required and effort estimates on the reporting requirements
  • Proposed the required changes that are required in the data ware house for generating the required reports
  • Customized and developed the OBI dashboards and reports
  • Implemented changes to the Star Schemas and in all the 3 layers of the RPD(Physical, Business Model and Mapping Layer and Presentation Layer)
  • Created and modified hierarchies in the Business Model and Mapping Layer
  • Involved in the design activities and created the design specifications documents.
  • Provided the knowledge transition to the project support team.
  • Fixed performance issues for improving report performance.

Confidential

OBIEE Developer

Environment: Informatic, OBIEE 11g, Oracle 11g and Windows NT

Responsibilities:

  • Involved in the design activities and documented the required changes for the mappings
  • Involved in the DB design and implementation of the Staging Area
  • Developed and validated the loads of the EDW
  • Customized the out of the box data flows and jobs in the BO Data Services for Marketing, Supply Chain and Production planning modules
  • Executed, monitored and troubleshoot the ETL for the History and the Incremental loads to test the customized rapid marts

Confidential

OBIEE Developer

Environment: OBIEE 11.1.1.6.5, OBIEE 11.1.1.6

Responsibilities:

  • Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.
  • Created complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
  • Implemented Human Resources (HR) Analytics and Financial Analytics applications.
  • Designed and implemented custom business intelligence solutions (Dashboards/Reports) and dashboard prompts using the BI Applications Analytics platform.
  • Configured global filters and page prompts in OBI reports and dashboards.
  • Modified presentation layer filters and attributes to match user requirements.
  • Used the Security settings in Oracle BI Admin Tool to set up users, groups, access privileges and query privileges.
  • Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
  • Managed security privileges for each subject area and dashboards.
  • Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
  • Worked on DAC for creation of Tasks, Task Groups, Subject Areas, Execution Plan, and to configure, monitor and schedule ETL routines.
  • Created & customized mappings using different Transformations like SQ, Filter, Router, Aggregator, Lookup, Expression, Sequence Generator and Update Strategy.
  • Extensively worked in fine-tuning of Informatica mappings.
  • Configured lookup files and Source files

Confidential

OBI Developer

Environment: Oracle Database operating on a Unix System.

Responsibilities:

  • Deployed RPD in EM ready for analytics
  • Extensive experience in working in RPD's three layers (Physical, BMM, Presentation layers)
  • Created connection pools, alias tables, star/snowflake schemas in the physical layer
  • Created business models, logical columns, hierarchies, level based measures in BMM layer,
  • Worked in analysis of reporting requirements and coming up the custom data model and creation of custom repository for meeting the reporting requirements.
  • Worked on the Configuration files for configuring the modules and prepared the Data Lineage for HR Projects and Supply Chain Management Analytics for meeting the requirements.
  • Customized the data model and development and enhancement of ETL and DAC objects.
  • Report Customizations in OBIA application and creating Data Validation test cases from Source to target.
  • Performed the Admin related Activities like Configuring and Installing OBIA Out of Box Applications and OBIEE 11g and Applying OBI 11g interim and bundle patches, and refreshing the servers, shutting and starting up the servers
  • Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
  • Managed upgrade and maintained the environments with latest patches
  • Troubleshooting the issues related to repository models and report development.

Hire Now