TECHNICAL SUMMARY:

• Experience developing and implementing OBIEE as enterprise wide reporting solution for various clients.
• Excellent analytical skills for understanding the business requirements, business rules/processes and detailed design of the applications.
• Strong experience in OBIEE versions (11x, 10x) which includes Administration tool, Intelligent Dashboards, Answers, Delivers and Oracle BI Publisher.
• Designed repository based on business requirements, followed design best practices for the RPD and Dashboard designs.
• Worked extensively on OBIEE Repository, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE.
• Used different filter conditions both in the repository and in front end based on business rules provided by the business users.
• Experience in using Aggregate tables, Partitions & Fragments to improve performance.
• Experience in creating dimension hierarchies and level - based measures.
• Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill - down capabilities using OBIEE.
• Installed and configured OBIEE 11g at clients place.
• Developed various Reports using different Analytics Views (Pivot Table and Column Selector), Dynamic / Interactive Dashboards.
• Developed dashboards using prompts.
• Built reports using Answers including drilldown objects, union based reports, formatting and functions within the reports, and filters based on Another Analysis, and prompts.
• Good hands on experience in using BI Publisher as an independent tool to create data models and show reports and also migrate reports from OBIEE 10g to OBIEE 11g using BI Publisher.
• Strong experience in creating Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data, and Repository Variables.
• Have good understanding of Key Performance Indicators and its implementation in the administration tool.
• Possess excellent problem solving capabilities along with strong debugging skills.
• Committed Team Player, with excellent Communication & interpersonal Skills and self-starter capable of working independently.

TECHNICAL SKILLS:

Reporting Tools: OBIEE Obiee (11.1.1.x) Oracle BI Publisher (11.x,10.x), Excel

Database /Tools: Oracle SQL Server, MS Access, SQL Developer, SQL Plus, TOAD for Oracle

ETL Tools: Informatica Power Center ODI 11.1.0

Languages: SQL, PL/SQL, T-SQL

Platforms: Windows (7, Vista, XP, NT), UNIX, Red Hat Linux Microsoft Windows 8.x, Solaris 5.8, Oracle Enterprise Linux 5.7, Mac OSX

Scheduling Tool: DAC( 11G&10G)

Others: Erwin 4.0/4.5, EBSR12, HTML, VB Script, JavaScript, XML,MS Word Toad, SQL Navigator, SQL Plus, SQL Loader

WORK EXPERIENCE:

Senior OBIEE Developer

Confidential, Milford, MI

Responsibilities:

• Analyze and document business process, user requirements, and functional needs and provide innovative solutions.
• Translated the Functional Specifications to Technical Reporting Requirements.
• Installation of 11.1.1.7 on the Development and new training windows environments for initial evaluation.
• Design and Develop Metadata required for reports.
• Administered the OBIEE web catalog and repository.
• Set up Business End Users with appropriate application roles.
• Modified existing analyses, dashboards and creating new analyses.
• Consolidated the reports in different views as per client requirement.
• Documented the Design Standards used for presentation, repository elements.
• Understand the business process and the technical solution (OBIEE reporting solution) implemented to address the business needs.
• Technical development of all OBIEE system objects needed, including developing OBIEE subject areas, measures, attributes, filters, dashboards and analysis.
• Monitored usage and performance of the reporting environment and suggest and help design and implement the steps to improve the performance.
• Responsible for 2nd level technical end-user support, which may include telephone technical support, complex user report creation, promoting end-user created objects to the sharable system level and troubleshooting any system failures.
• Identifying the key performance Indicators and designing KPI watch list to depict the performances of different measures at various levels.
• Also used scorecards to compare the performances of multiple key performance Indicators.

Environment: OBIEE 11.1.1.7, Oracle 11g, SQL Server 2008, Windows 8.

Senior OBIEE Developer

Confidential, OH

Responsibilities:

• Extensively used OBIEE for customizing and modifying the Physical layer, BMM and Presentation layers of the repository.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Also created hierarchies, variables, and event poll strategies in the repository.
• Responsible in designing and introducing new FACT or Dimension Tables to the existing model and decide the granularity of fact tables.
• Created dimension hierarchies & level based measures in BMM layer based on requirements.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.
• Developed reports/ dashboards against Oracle ERP data.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.
• Projecting the created reports in different views as per the client’s requirement.
• Used BI Publisher to create reports from an Answers Request, and from BI Server data.
• Created Aggregated Tables and configured the content in Business Model Layer to use them for better performance.
• Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from Development environment to QA environment and then to the Production environment.
• Conducted user training to familiarize them to the new reporting environment.
• Also identified key performance indicators to show the running performance of the business for better analysis.
• Scheduled the reports as per the requirement using BI Publisher and represented them in Web Application (dynamic/static scheduling).

Environment: OBIEE 11.1.1.6/11.1.1.5 , BI Publisher, Oracle 11g, SQL Server 2008, Windows XP.

OBIEE Developer

Confidential, Miami, FL

Responsibilities:

• Provided development, application and administrative support for the entire OBIEE environment at Confidential Headquarters.
• Responsible for primary communications of all environment activity that impacted end users, developers, testers and management.
• Provided development support for various projects, including monitoring, troubleshooting, tuning, installation, upgrades, migration and deployment of various environments.
• Responsible for OBI repository file, Migrations and Code Deployment during the project life cycle. Managed and escalated issues as needed.
• Created RPDs, defined Physical Layer, and developed Business Model & Mapping and Presentation Layer using Admin Tool.
• Created and managed many dashboards such as Project status summary Dashboards for a particular market etc.
• Set up Metadata Objects like Subject Area, Tables and Columns. Modified Metadata Logical definitions in Analytics Repository using OBIEE Administration Tool.
• Created Physical and Complex Joins. Exposed custom attributes in Presentation Layer.
• Used narrative text, column selector, global and column filters to provide the functionality of viewing selective data for the end users.

Environment: OBIEE 10.1.3.4.2 , Admin tool, Windows Server 2003, 2008, Oracle 10g

OBIEE Developer

Confidential, Boston, MA

Responsibilities:

• Involved in Requirements Gathering, Data Modeling and creation of detailed design Documents.
• Involved in meetings with Business users to get the functional specifications.
• Involved in analysis and designing Functional/Technical Specifications.
• Was responsible for understanding requirements from the customer and in turn proposing an efficient solution, which can meet both client requirements as well as the System Architecture specifications.
• Prepared detailed report specifications for reports. Involved in designing a BMM design document.
• Involved in developing OBIEE Repository as per user requirements. Worked on the design of logical data model.
• Identified and Created Facts and Dimensions for the Business model.
• Created connection pool, imported physical tables and defined joins in the physical layer of the repository.
• Created an Initialization block to retrieve allowable values.
• Created hierarchy for the dimensions to enable drilldown within the hierarchy based.
• Developed various Reports using different Analytics Views (Pivot Table and Column Selector), Dynamic / Interactive Dashboards using global and local Filters.
• Developed dashboards using dashboard prompts. Built reports using Answers including drilldown objects, union based reports, formatting and functions within the reports, and filters based on Another Analysis, and prompts.
• Debugged reports and Dashboards. Prepared the release notes for the reports.

Environment: OBIEE 10.1.3.4.1 , BI Publisher, Oracle 10G, Windows 7.

OBIEE Developer

Confidential

Responsibilities:

• Gathered Business Requirements by interacting with IT and documented them unambiguously as System Requirements Specifications (SRS).
• Created High level Design Documents (HLD) according to the Business System Requirements (FR/NFR). Documented Application Design Mapping & ETL Mapping, which helps Developers to implement ETL and RPD.
• Designed and Developed Custom Business Intelligence Solutions (Metadata and Dashboards/Reports) using OBIEE platform.
• Developed the OBIEE Metadata repository (.rpd) model with the necessary logic that involved creating the Physical, BMM layers with aggregates, dimensions &time series functions, Presentation layer with catalogs & folders and external table security using Siebel Server Admin tool.
• Also created hierarchies, variables, and event poll strategies in the repository.
• Developed Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Implemented Groups and Hierarchy Level Based security to dashboards based on Role.
• Configured and automated iBots to deliver daily and weekly reports based on schedule.
• Performance Tuning of Reports by implementing the aggregate navigation, Cache and Oracle Materialized Views.

Environment: OBIEE 10.1.3.4, Oracle 10g, Oracle Enterprise Manager, SQL Server 2000, Windows XP

OBIEE Developer

Confidential

Responsibilities:

• Participated in gathering and analyzing the Business Requirements.
• Worked on Oracle BI EE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• Created Connection pools, imported physical tables and defined joins in the Physical layer.
• Developed and customized some of the existing Dimensions (Drill-Down Hierarchies) & Logical objects in Business Model Layer, and created the Presentation catalogs in Presentation Layer. Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Developed Dashboards for each of metrics by embedding reports and provided intuitive drill-downs and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Performed Dimension modeling, Identified Fact tables & Measures, Identified Dimension Tables to store business attributes, Identified Aggregate tables & their definitions.
• Created materialized views to fasten slower queries with complex joins in them.
• Scheduled sessions to run at specified time with required frequency and monitored the performance of the Jobs.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.3/10.1.3.4 , Windows XP, Oracle 10g and SQL Server 2000.