SUMMARY

• Over 8 years of experience in Analysis, Design, development and implementation of Oracle 11g/10g, Informatica power center 9.x/8.x/7.x, OBIEE11g/10g, DAC 10g/11g which include over 6 years of experience in OBIEE/OBIA Reporting.
• Expertise in providing end to end BI solution by configuring metadata and building Analytics Repository, dimensional modeling design, building business models, generating reports and creating dashboards using Analytics and OBIEE.
• Experienced in Data Warehousing Methodologies.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers includingPhysical, Business Model and Mapping, and Presentation layer.
• Data modeling experience using Dimensional Data modeling, Star Schema/Snow flake schema, Fact and Dimension tables, Physical and logical data modeling in theOBI Administration tool.
• Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
• Experience of installation of OBIEE 10g/11G on windows operating system and worked on Web logic Admin console and Web logic Enterprise manager.
• Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on (SSO).
• Expertise in developing all 3 layers of the Analytics Repository (Physical Layer, Business Model & Presentation Layer).
• Extensive experience in configuring Interactive Dashboards with drill - down capabilities using global and local Filters, Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expert in building repositories using star schema, developing Subject Areas, and applying security at object and data level in Administration Tool.
• Good working knowledge on OBIA (Sales Analytics, Financial Analytics, HR Analytics).
• Expert in configuring, designing, development, implementation and customizing Oracle pre-build RPD’s (Financial, HR, Sales, etc ) and ETL Mappings according to business requirements
• Experienced increating Dimensional hierarchies and designing customized interactive dashboardsin OBIEE using drill down, prompts, filters, and variables.
• Experience in Performance tuning of ETL process, reducing the execution time of overall ETL loads.
• Good experience with configuring Data Warehouse Administration Console (DAC) for creating execution plans, metadata management and monitoring the Informatica ETL Process.
• Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables.
• Extensively used Informatica Power Center 8.x/7.x. for creating various mappings.
• Expertise in Developing Mappings, Maplets, Workflows and Sessions using Informatica Power center.
• Strong understanding of database concepts including Star, Snow-Flake modeling, Tuning, Query Optimization and best practices.
• Experienced in translating business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures.
• Experienced in configuringUsage Tracking and Multiuser Development Environment (MUDE) and also Migration of Repository from one Environment to other Environment.
• Highly motivated and capable of working both individually and in a group environment and proven communication, presentation Skills and Leadership Qualities.

TECHNICAL SKILLS

BI Reporting Tools: OBIEE 11.1.1.7, OBIEE 11.1.1.6, OBIEE 10g

OBIEE Applications: OBIA7.9.6.4, 7.9.5(Financial analytics, HR Analytics, Sales)

Databases: Oracle 11g/10g, SQL server 2008,DB2 8.x

ETL Tools: Informatica Power center 9.x/8.6.1/8.1, DAC 10.1.3.4.1/11 g, ODI 11g

Languages: SQL, PL/SQL, Java, C, HTML, XML

Tools: SQL Developer, SQL*Plus, TOAD, SQL* Loader

Operating Systems: Windows 2003/2008,Windows 7, HP Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, Broomfield, CO

Senior Oracle BI Consultant

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering new business requirements and also understanding the current requirements.
• Identified key dimensions and fact tables and created star schemas.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Expertise in analyzing and designing customized analytical reports and creating Interactive dashboards with drill-down capabilities using OBIEE.
• Created subject areas in OBIEE RPD by importing required fact and dim tables.
• Performed administration work including migration, patching and upgrading OBIEE.
• Created and granted privileges for the users using Catalog Manager.
• Upgraded OBIEE from 11.1.1.6 to 11.1.1.7 version
• Configured Multi User Development Environment (MUDE), Scheduler, Usage Tracking.
• Involved in Migration of Repository from Test Environment to Production Environment.
• Developed different kind of reports using BI Publisher.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Implemented dimensional hierarchy scenarios, level-based measures and aggregation techniques to increase the performance.
• Implemented Authentication by using LDAP and Authorization by using External Table in the database.
• Managed security privileges for each subject area and dashboards at object level and data level security according to user requirements.
• Created proactive Agents and interactive Dashboards to alert the Sales team about incoming changes in reports.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups

Environment: Oracle Business Intelligence 11.1.1.7/11.1.1.6 , ODI 11g, BI Publisher and windows Server 2008

Confidential, San Ramon, CA

Oracle BI Developer

Responsibilities:

• Interacted with the business users for requirement gathering and defined functional and technical specifications documents.
• Performed Data Warehouse analysis and identified the required Facts, Dimensions, Levels / Hierarchies of Dimensional and referential joins.
• Devised a data warehouse model plan to implement the analytical repository from an Oracle Business Intelligence perspective.
• Designed and developed Analytics Metadata Repository (.rpd) using Oracle BI by importing the required objects with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies), Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Configured BI scheduler (IBots) and Multi-User Development (MUD) environment.
• Implemented Single Signe On security between EBS and OBIEE.
• Performed migrations from DEV to QA and QA to Production environment (RPD).
• Configured usage tracking subject area and used usage tracking reports for improving Dashboard performance.
• Implemented various report performance improve techniques like Caching strategy, Cache seeding and Suggested database parameters for oracle data warehouse for improving query performance.
• Upgraded OBI Apps 7.9.5 to OBI Apps 7.9.6 which involves upgrading platform and metadata.
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain daily and weekly reports.
• Created and published highly flexible reports using BI Publisher formerly known as XML Publisher.
• Installed BI Office Client (MS OFFICE Add-ins), configured the connections which enable us to analyze and deploy Business Intelligence reports easily in Microsoft Office applications, Excel and PowerPoint.
• Participated in creating test plans, test objectives, test strategies and test cases in the QA testing phase and also involved in integration and functional testing.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of Analytics that includes (.rpd, Dashboards, Security etc.).
• Developed Informatica Mappings/Mapplets using various Transformations (Filter, Expressions, Router, Aggregative, Lookups, and Update Strategy).
• Developed mappings in Informatica according to functional/application areas to load the data from source to target tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, and database connections using Workflow Manager.

Environment: Oracle Business Intelligence EE 10 g, OBIEE 11.1.1.6, OBI Apps 7.9.6, 7.9.5, E-Business Suite, Informatica Power Center 8.6, Oracle 10g, Windows 2003, 2008.

Confidential, Phoenix, Arizona

OBIEE Consultant

Responsibilities:

• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Siebel Analytics Repository.
• Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Generating Dashboards to provide insight into Sales Analytics, Activity Analytics.
• Created guided navigation links to help files within the dashboards to help the end users.
• Worked in a multi user development environment (MUDE).
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Installed BI Publisher, Publisher Desktop, integrated with OBIEE to develop template. Used MS OFFICE Add-ons in reports, Dashboards and answers.
• Creating Users, Groups and giving the permissions in Siebel Analytics Administration Tool and verifying the Permissions of the users in Siebel Analytics web.
• Creating the logical data models like Hierarchies, Aggregate navigation, Level-Based-Measures, Reporting views.
• Defining the logical grouping and nesting of presentation variables and attributes
• Managing table level cache persistence and purging cache when needed
• Assisting in creation of pivot table requests allowing manager’s to analyze the business/data from different perspectives.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple Data sources into targets.
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance, Supply Chain and Order Management Analytics.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & iBots.
• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.
• Installed and Configured OBI apps environment which includes Informatica, DAC, OBIEE and metadata.
• Built multiple execution plans in DAC for weekly and daily loads.
• Developed Informatica mappings and mapplets to build key interfaces using transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into data warehouse.

Environment: OBIEE 10.1.3.4.0 , OBIA/ BI Apps 7.9.5, Informatica 8.1.1, DAC 7.9.5, Financial Analytics, Order Management Analytics, Supply Chain Analytics, Oracle 10g, Essbase, TOAD, UNIX.

Confidential, Bellevue, WA

OBIEE Developer

Responsibilities:

• Helped with requirement gathering from business users and end users.
• Involved in Analysis and Design of the data warehouse solution.
• Analyzed reporting requirements for dashboard reports and adhoc reports
• Worked extensively on repository administration tool to configure Physical, Logical and Presentation Layers.
• Configured facts, dimensions and Hierarchies in OBIEE RPD.
• Implemented aggregate tables for better analytics performance.
• Setting up Delivers to configure iBots based on the threshold value to the users.
• Implemented reporting cache to faster response time.
• Developed various output formats such as tables views, charts, pivot tables.
• Worked extensively in Siebel Answers and Dashboards.
• Create Logical Joins/keys, Set levels to support Drill-down, Aggregation / Sum over columns etc.
• Created and granted privileges for the users using Analytics Catalog Manager.
• Performed unit testing and supported end users during various test cycles.
• Day to day production support.
• Involved in various enhancements to the reporting

Environment: OBIEE 10.x, Informatica Power Center 7.1.3, Oracle 9i, TOAD, Erwin 4.0, UNIX

Confidential, Irving, TX

Siebel Analytics Consultant

Responsibilities:

• Installed and Configured Siebel Web Components including Siebel Analytics Answers and Intelligence Dashboards.
• Customized Siebel Analytics Repository, defined Physical Data Layer, and Developed Business Model and Presentation Layer using Siebel Analytics Administration Tool.
• Customized the repository and created new requests using Answers.
• Created and configured the Siebel dashboards, customized reports and charts (like Sales, Service and marketing), in Siebel Answers. Created reports and charts for various dashboards
• Implemented the LDAP authentication with in RPD for security.
• Used the Informatica Power Center designer to develop the required mapping based on the ETL requirement spreadsheet.
• Used the Informatica Power Center Workflow Manager to develop the required sessions for the mappings developed based on the ETL requirement spreadsheet.
• Used different transformations - Source Qualifier, Expression, Filter, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner, Router, Aggregator transformation and SQL override.

Environment: Siebel Analytics 7.8, Informatica Power Center 7.x, Oracle 9i.