OBIEE

Summary:

• Over * years of experience in gathering Business Requirements, GAP Analysis, Data Analysis, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.

• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using OBIEE/Siebel Analytics 7.x and Informatica 8.x/7.x

• Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers / iBots, creating reports / Dashboards, cache management, and building OBIEE/Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer)

• Very strong in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & various Tasks and scheduling them using both Workflow Manager and Unix Shell scripts (using pmcmd )

• Experience configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports)

• Experienced in Data Analysis, Identification of dimensions, Facts, Measures and Hierarchies

• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI/Siebel Analytical Dashboards/Reports

• Proficient in working on production and development environment in different RDBMS (in Oracle 8i/9i/10g, SQL Server) and strong troubleshooting skills

• Extensive experience in business process reconciliation, design, configuration, testing, quality analysis and production support

• Experience in working with different operating systems like HP UNIX, Solaris, IBM AIX and Windows NT

• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.

Technical Skills

• OBIEE 10.x, Siebel Analytics 7.x (Repository, Presentation Services, Webcat, Scheduler, i-BOT’s), BI Publisher

• Informatica 6.x/7.x/8.x (PowerCenter and PowerMart), DAC, ETL

• Oracle 8i/9i/10g, Microsoft SQL Server 00/05/08(SSIS, SSAS, SSRS)

• SQL*Plus 8.x/9.x, PL/SQL 8.x/9.x,T-Sql, C, C++, Microsoft Office Suite, Microsoft Visio, Microsoft Project

• HP UNIX, Solaris, IBM AIX and Windows NT

Education

• Awarded Bachelors of Technology (B.Tech) from Jawaharlal Nehru Technological University, India.

Experience

Client: Vesta Labs, Bothell, WA June ‘09 – till date

OBIEE Developer

Responsibilities:

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define Business and Functional Specifications.

• Created prototype of the Requirements and Functional Requirement Documents.

• Understand Business Requirements and translate the same into a Technical Design Document.

• Performed GAP analysis to understand AS IS and TO BE System.

• Performed Data Analysis and Data Validation and created the logical data model.

• Analyzed data sources of legacy systems.

• Interacted with the database team to understand the Physical Schema.

• Identified the required Facts, Dimensions, Levels / Hierarchies of Dimensional and referential joins

• Designed and developed OBIEE/Siebel Analytics RPD using OBIEE/Siebel Analytics Server Admin tool by importing the required objects (Dimensions and Facts) into Physical Layer, Created the Logical model in the BMM Layer with Multiple drill down dimensions to support various business requirements and created the User friendly Subject Areas in Presentation Layer

• Designed reporting environment that gives super users the ability to directly access the data warehouse to create new ad-hoc reports

• Developed many Time Series Objects for comparing the variations between the Years, Quarters, and Months.

• Developed many Reports / Dashboards and Scorecard Dashboards, with different Analytics Views (Drill-Down / Dynamic, Narrative View, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters)

• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports

• Implemented Security Groups and Roles using LDAP Authentication.

• Maintained multiple-user development environment (MUD) for Developmental Procedures.

• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes,

• Involved in developing Initial and Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.

• Developed many PL/SQL stored procedures & functions and used the same in mappings, pre and post sessions

• Performed Unit and Integration testing to validate report and mapping functionality.

• Written all the test cases for the client and also the test scripts as part of the QA Support.

• Responsible for OBI repository file, Migrations and Code Deployment during the project life cycle until Go Live.

• Involved in Release management and Promoting code from DEV-QA-PROD. Involved in UAT and post production support

• Created support documentation for OBI application

Environment: OBIEE 10.1.3.3.1-10.1.3.4.1, Siebel Analytics 7.x, Informatica PowerCenter 7.1, DAC,PL/SQL, Oracle 9i/10g, TOAD

Gilead Sciences, San Francisco, CA Jan ’08 – Apr’09

OBIEE Developer

Responsibilities:

• Involved in gathering new and existing report Business Requirements, performed GAP Analysis, and Data Analysis

• Identified the Data Sources (Relational, Excel etc), Facts, and Dimension tables in designing the Star Schema.

• Designed and Built OBIEE/Siebel Analytics RPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs.).

• Developed the Dimensions and Time Series Objects in the Business Model and Mapping Layer.

• Developed different kinds of Reports Pivots, View Selectors, Column Selectors, and Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters, and Page/Dashboard Prompts. Extensively used Siebel Delivers and iBots

• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.

• Developed many Informatica Mappings / Mapplets using various Transformations (Update Strategy, Filter, Router, Expression, Lookup, and Aggregator) implementing Meter Management Datamart

• Created many PL/SQL packages for ETL Sanity Check and called same in pre & post sessions

• Trained Business Users in using Answers and Dashboards.

Environment: OBIEE 10.1.3.4.0, DAC, Oracle 10g, TOAD, Informatica 8.1.1, Sun Solaris 64

Alltel Communications, Little Rock, AR Nov’ 05 – Dec ‘07

OBIEE Consultant

Alltel provides wireless, local telephone, long-distance, Internet and high-speed data services to residential and business customers in 26 states. Alltel required a complete solutions package Data mart for its Customer Service Request Department to analyze and report the customer service request trends and agreements

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.

• Created/Modified Metadata repository (.rpd) and Configured Metadata objects using Siebel Analytics server Admin Tool.

• Developed many Dashboards/ Reports with different Analytics Views (Drill-Down, Pivot, Chart, View Selector and Tabular with global and local filters) using Siebel analytics Web.

• Configured intelligence dashboards by adding content such as links/images, HTML objects and folders.

• Implemented dynamic dashboard prompts to zoom in to particular segments of the business in a performance-optimized manner.

• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns.

• Diagnosed performance problems with Siebel Analytics and recommended solutions to improve reports’ run time. Preformed Tests for the Data integrity and Consistency.

• Used the Catalog Manager and maintained the Analytics Web Catalog to manage Dashboards, Answers.

• Involved in complex ETL Mappings/Mapplets and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator)

• Designed and documented the business/validation rules, error handling and test strategy of the mapping

• Tuned the sessions for better performance by implementing the partitions

• Performance turning of informatica Mappings data warehouse loads, including informatica server manager and PL/SQL procedures.

Environment: Siebel analytics 7.7, informatica 6.2, oracle 9i, IBM AIX

Lexington Insurance, Boston, MA Jan ’04 – Sep ‘05

IT Analyst /Siebel Analytics Consultant

As an Analyst developed and implemented the Policies, Premiums, Claims and Expenses (PPCE) Data warehouse using Siebel Analytics, Oracle 9i and Informatica Power Center.

Responsibilities:

• Involved in Full project life cycle implementation.

• Gathered user requirements by conducting interviews with business users, stake holders and SME’s.

• Defined the scope of the project and did an impact analysis.

• Scheduled brainstorming sessions to elaborate and validate system solutions.

• Ensured work Product delivered meets all project specifications.

• Worked with Internal customers to understand their reporting requirements.

• Prepared Business requirement documents (BRD) and then converted business requirements into functional requirements.

• Conducted GAP analysis to assess the shortcomings of the existing system and evaluate benefits of the new one.

• Developed Metadata Repository (.rpd), configured Physical & Business Model Layer and Web Catalog Objects as per the data requirements using Siebel Analytics Server Admin and Web tool

• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives, provided optimized Analytics request using column selector

• Developed Interactive Dashboards with drill-down capabilities and dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner

• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets

• Developed Informatica mappings with re-usable Transformations and Mapplets using various Transformations for Initial and Incremental loading of PPCE data warehouse

• Extensively involved in performance tuning of the Informatica ETL mappings and workflows by increasing the caching size, SQL overriding, running sessions in parallel, partitioning etc.,

• Developed PL/SQL procedures for complex business logics like to calculate measures inward, outward premiums, claim payments and reserves

• Involved in Reconciliation Process while testing loaded data with user reports

• Identified and solved numerous technical and operational problems in the Data mart design and ETL implementations

• Developed UNIX and PL/SQL scripts for pre & post session processes to automate daily loads

Environment: Siebel Analytics 7.x, Data Analysis, Informatica PowerCenter 6.2, Oracle 9i, Solaris

KCPL, Kansas City, MO Nov’02 – Dec ’03

ETL Developer

Prevent Analyzer Repository, an Enterprise Data Warehouse (Oracle 9i). PAR is developed using Informatica for integrating data from various Database sources and files like SQL server, MS Access, XML files, flat files etc. and Business Objects was used for analysis.

Responsibilities:

• Created data models for PA (Prevent Analyzer) Data Warehouse.

• Analyzed and created Fact and Dimension tables.

• Implemented ETL Process to load the data from Source systems to ODS to Data warehouse.

• Developed many mappings with mapplets & re-usable transformations using various transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Rank and Router transformations

• Created Tasks / Sessions and Workflows using Informatica Workflow Manager and executed through shell programs using pmcmd

• Fine-tuned the long running reports by re-organizing the data, re-building of indexes and creation of new indexes (if required) and making changes to reports itself

• Implemented reconciliation process for data consistency between source systems and the data warehouse

• Prepared the Design, Unit & Integration Testing, Implementation and Deployment Documents

Environment: Informatica PowerCenter 5.1/6.x, Oracle 8i, HP UX

ITC, India, IT Division Jun ’01– Oct ’02

Programmer Analyst

Insurance System -The Insurance system facilitates collection, reconciliation of data and preparation of consolidated reports catering to Insurance Companies. The system has a provision for calculating premium storing details of policy enhancements and claims.

Responsibilities:

• Developed many mappings and mapplets to extract and load the data from flat files, Oracle to Oracle using transformations & reusable transformations for loading the data into targets like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator

• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager

• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance

• Written Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage

• Interacted with Management to identify key Dimensions and Measures for business performance

• Created views and altered some of the dimensional tables to satisfy their reporting needs

• Developed registration, billing and claims modules using Embedded SQL [Dynamic SQL], and PL/SQL with Oracle as the database

• Studied the performance of SQL queries and the indexes created, either through EXPLAIN PLANS

• Optimized the embedded SQL queries using statement level optimizer hints when essential, to adhere to the defined OLTP response time.

• Prepared test conditions and setup the test environment for Unit and Regression testing

Environment: Informatica PowerCenter 5.1, HP UX, Oracle 8i/9i, SQL Plus, PL/SQL, Pro*C, Forms 6i, and Reports 6i, UNIX (HP-UX), Oracle Discoverer

Contact this candidate