Summary:

• 8 years of experience in Complete Software Development Life Cycle SDLC implementation of various Business Intelligence and Data Warehouse / Data Marts that covers gathering Business Requirements, GAP Analysis, Design / Modeling Star and Snow flake , Development, Testing, Implementations and Documentation.
• 7 years of experience in designing and developing end-to-end BI solutions according to standard OLAP methodologies using Siebel Analytics/Oracle Business Intelligence OBIEE , including 3 full life cycle implementations.
• Extensive Business Intelligence experience using OBIA 7.9.x, Oracle BIEE 11.1.1.X,10.1.4.X, Siebel Analytics 7.x and Informatica 8.x/7.x/6.x.
• Very strong experience in developing OBIEE / Siebel Analytics Repository .rpd at three layers Physical Layer, Business Model Presentation Layer , Time Series Objects, Interactive Dashboards with drill-down capabilities using page and dashboard prompts, Security Setup groups, object and data level , LDAP, External Tables, configured Analytics Metadata objects Subject Area, Table, Column , Web Catalog Objects Dashboard, Pages, Folders, Reports and scheduling iBots and Smartview.
• Experience with BI server and the Interactive dashboard as well as experience with ETL, metadata development.
• Experienced in managing Security Model introduced in OBIEE 11g, Implemented security using Weblogic Server Administration Console by creating and setting up users and groups and used Enterprise Manager Middleware control to create and setup Application Roles and Application Policies.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Experienced in configuring OBIEE Reports Dashboards, OBIEE Delivers, Narrative views, advance Reports.
• Experienced in complete life cycle implementation of OBIEE with Star and Snow flake schema.
• Experienced in Troubleshooting and providing work around solutions to the business users for bugs in OBIEE 11g.
• Multi-Platform experience on UNIX / Linux and Windows Server family of products.
• Experience in WebLogic and WebSphere to Deploy the data
• Experience in setting up a Multi-User Development Environment MUDE .
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Data warehousing development using ETL Tools such as Informatica Power Center and experience in DAC Data warehouse Application Console Configuration.
• Design of ETL methodology for supporting data transformations processing in a corporate wide ETL Solution using Informatica Power Center 9.x
• Worked with various Transformation Components like Source Qualifier, Expression, Aggregator, Filter, Router, Sorter, Lookup, Joiner and Sequence Generator.
• Have Good knowledge and understanding of OBIEE 11g Architecture, functionality and features.
• Business Analysis experience with excellent communication interpersonal skills, broad understanding of business operations and requirements.
• Experienced in extracting ETL data from SAP R/3 using Logistics LO Cockpit and Generic Extractors
• Involved to develop various aggregation levels, planning functions and planning sequences.
• Good overall SAP R3 Knowledge of modules like SD, MM and FI.
• Good functional knowledge in FI, SD, HR, OTC, Budgeting , Planning, Order Tracking and HR
• Worked with business in identifying opportunities for cost optimization and revenue growth by appropriate use of business intelligence and analytics

Technical Skills:

Professional Experience:

Confidential

Role: Sr. OBIEE Developer

Responsibilities:

• Developed Oracle Business Intelligence Siebel Analytic Repository
• Created Logical Dimension and Fact table in OBIEE Siebel Analytic Repository.
• Created Alias to support flexible TD and AGO transformation.
• Created data for Time Transformation table to be used by flexible TD and AGO transformation.
• Created Prompts, set Filters and Calculations. Created Global Filters for Dashboards.
• Developed Reports and role-based Dashboard in Oracle Business Intelligence.
• Created complex BI answer report using time series KPI like LY, LW, MTD, YTD, WTD, Ch to LY, LW, MTD,YTD,WTD

Environment: OBIEE 10.3.2/11.1.1.7 / 11.1.1.6, Web Logic Server, Oracle 11G, SQL, PL/SQL, SQL Plus, UNIX, OBI Publisher

Confidential

Role: Sr. OBIEE Developer

Responsibilities:

• Developed Oracle Business Intelligence Siebel Analytic Repository
• Created Logical Dimension and Fact table in OBIEE Siebel Analytic Repository.
• Created Alias to support flexible TD and AGO transformation.
• Created data for Time Transformation table to be used by flexible TD and AGO transformation.
• Created Prompts, set Filters and Calculations. Created Global Filters for Dashboards.
• Developed Reports and role-based Dashboard in Oracle Business Intelligence.

Environment: OBIEE 11.1.1.7 / 11.1.1.6, Web Logic Server, Oracle 11G, SQL, PL/SQL, SQL Plus, UNIX, OBI Publisher

Confidential

Role: Sr. OBIEE Consultant

Responsibilities:

• Excellent aptitude in business model development with various functionalities like Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series, Caching Mapping.
• Extensively worked on complex BI Publisher reports, Data Models and creating complex RTF templates using BI Publisher Template Builder.
• Experience in developing different kinds of reports pivots, charts, tabular with drill downs, using global and local filters, prompts both dashboard and page .
• Creating Updating Meta data repository .rpd configuring metadata in BMM layer, physical Data Model and Web Catalog Objects as per the reporting requirements using OBIEE Admin and Web tool.
• Creating templates for presenting results and analytics, and modifying the OBIEE dashboard using cascading style sheets.
• Built PL/SQL Functions and called them using Evaluate Functions in Answers.
• Involved in Installation and Configured OBIEE Environment in the Organization.
• Created Filters and providing customized prompts appropriately to avoid excessive data showing up on reports.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Worked in Repository Configuration, Troubleshooting, Migration and Server Administration.
• Trained End Users and Pilot Users about OBIEE Tools like Answers, Dashboards and BIP reports.

Environment: OBIEE 11.1.1.6 / 11.1.1.5, Web Logic Server, Oracle 11G, SQL, PL/SQL, SQL Plus, UNIX, Windows XP, PeopleSoft EPM, OBI Publisher

Confidential

Role: OBIEE Developer

Responsibilities:

• Created new Dashboards, pages and reports using Siebel Answers.
• Responsible for Performance improvement of the Analytics reports.
• Worked on the testing and validating the Repository.
• Defined and implemented WEBCAT level security.
• Created new star schemas and subject areas in Siebel Analytics repository for the non-Siebel sources.
• Setup Multi User Development Environment MUDE in OBIEE.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias in OBIEE Administrator tool.
• 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.
• Created dimension hierarchies to achieve the drill down functionality.
• Implemented caching to improve performance.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot
• Queries to obtain daily and weekly reports.
• Implemented Dimension Pinning to use Oracle OLAP cube in OBIEE.
• Responsible for processing the data and loading of the tables, created procedures, functions, views in Oracle 10g

Environment: Oracle 10g, Oracle Business Intelligence OBIEE 10.1.3 Siebel Analytics

Confidential

Role: OBIEE Developer

Responsibilities:

• Gathered Business Intelligence application requirements, development and testing
• Configured physical, business model and presentation layers of the Repository, Customized/Modified Metadata repository RPD suiting to the organization's data structure.
• Created Subject Areas, Folders/Sub-folders, and Presentation/Business columns.
• Extracted source data from SQL Server, Oracle and flat files to load into a relational Oracle data warehouse.
• Created/Modified Informatica ETL mappings in various stages folders like Staging area and production area for development and production environment that transfers data from flat file, Oracle Source systems to Target system.
• Applied OBIEE best practices to enhance the performance of the application. Eliminated all circular joins that either cross dimensions or contained within a single dimension. Used Physical Layer table aliases to duplicate certain tables and modify joins so that Circular join is removed.
• Effectiveness was maintained in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Defined additional views narrative, pivot, chart views of the data returned by the request to visualize data in many different ways.
• Analyzed the transaction environment to identify the required facts and dimensions for the OLAP
• Implemented cache management using Event Polling table and aggregate table techniques to improve the performance.

Environment: OBIEE 10.1.3.4, Oracle 10g, BI Publisher, Informatica power center 8.6, PL/SQL, TOAD, SQL Developer, Windows 2000.

Confidential

Responsibilities:

• Gathered Business Intelligence application requirements, BRD writing, development and testing.
• Understanding the Client requirements, source data, business objectives and Interacted with business Management representatives for gathering the Reports/ Dashboards requirements and to define business and functional specifications.
• Experience in Dimensional Data Modeling and Technical documentation and presentations.
• Identified the Gaps by analyzing the Data mart Instance and provided alternative solutions as well recommended changes to Database.
• Responsible for Installing, Configuring and Administration of OBIEE 10.3.3.4 Repository for Physical, Business Model and Presentation services.
• Responsible for implementing OBIEE for the modules Retail and Sales.
• Built the Physical Layer /Logical Layer/Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.
• Extensively worked on Answers, Created Reports using different Analytics Views Pivot Table, Chart, Column Selector and Table .
• Designed Executive Dashboards to provide Business Critical Analytical view of the Written Sales for a set of Power Users
• Designed and implemented Informatica Power Center 8.6 for ETL to load target Oracle 11g database.
• Created Mappings to Demoralize data form a Normalized format

Environment: OBIEE 10.3.3.1, Informatica 8.0, Oracle 9i, Windows server 2003, SQL Loader.