Oracle Business Intelligence Consultant
Summary:

• Having 8 years of experience in IT industry with 5 years of experience in OBIEE/Siebel Analytics reporting, design, development and implementation
• Proficient in providing end-to-end OBIEE business intelligence solution by dimensional modeling design, building business models, reports / Dashboards development, metadata management, Answers, iBots, MS Office plug-in, cache management
• Worked extensively with all the three layers(physical, business model, presentation layers) of Siebel Analytics/ OBIEE repository development and implemented various functionalities in the business model layer like Dimensional hierarchies for drill-down, Time series measures, level based metrics
• Expertise in full lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using OBIEE/Siebel Analytics 7.x.
• Experience configuring Interactive Dashboards using global and local Filters, OBIEE Security Setup (data level security, object level security), Repository Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI/Siebel Analytics Dashboards/Reports and query optimization based on OBIEE best practices
• Performed Unit, Integration and Regression testing of various Reports/ Dashboards and Repository
• Involved in User Acceptance Testing (UAT) for reports and validation of the reports
• Developed Informatica Mappings & Mapplets using various transformations for ETL( extract-transform-load) of data from Multiple Sources to the Data mart/ Data Warehouse and creating Workflows with Worklets & various Tasks and scheduling them using both Workflow Manager and Unix Shell scripts
• Implemented execution plans and tasks to run Informatica workflows using DAC (data warehouse administration console)
• Excellent oral and written communication skills, interacted at various levels with Business users, developers, Business analysts

Technical Skills

• OBIEE 10.x, Siebel Analytics 7.x (Repository, Presentation Services, Webcat, Scheduler, BI Publisher
• Informatica 6.x/7.x/8.x (PowerCenter and PowerMart) DAC
• Oracle 8i/9i/10g, Microsoft SQL Server 00/05/08
• Microsoft Office Suite, Microsoft Visio, Microsoft Project

Experience

Confidential Virginia Beach VA June ‘09 – Aug ‘10
OBIEE Consultant

Responsibilities:

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define Business and Functional Specifications.
• 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 (OLTP, OLAP) 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.
• 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.
• Responsible for OBI repository file, Migrations and Code Deployment during the project life cycle until Go Live.
• 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, PL/SQL, Oracle 9i/10g, TOAD

Confidential Georgia Jan ’08 – Apr’09
Sr. OBIEE Developer

Responsibilities:

• Involved in gathering new and existing report Business Requirements, performed GAP Analysis, and Data Analysis
• Identified the Data Sources (Relational, Excel, OLTP, OLAP etc), Facts, and Dimension tables in designing the Star Schema.
• Designed and Built 3 layers of RPD 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
• Unit and Integration testing for data validation of reports.
• Written all the test cases for the client and also the test scripts as part of the QA Support
• Trained Business Users in using Answers and Dashboards.

Environment: OBIEE TOAD, Informatica 8.1.1, BI Publisher

Confidential Austin, TX Nov’ 05 – Dec ‘07
Siebel Analytics Consultant

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 by importing objects from the relational table structures within the datawarehouse
• 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
• Involved in Reconciliation Process while testing loaded data with user reports
• 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, PL/SQL, SQL developer, IBM AIX

Confidential Jan ’04 – Sep ‘05
Siebel Analytics Developer

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.
• Implemented ERD, dimensional data modeling diagrams using ERwin
• 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
• 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, Informatica PowerCenter 6.2, Oracle 9i, Solaris

Confidential Nov’02 – Dec ’03
Data Analyst

Responsibilities:

• Created the 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
• Implemented ERD, dimensional data modeling diagrams using Erwin
• 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 & manual Integration Testing, Implementation and Deployment Documents

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