Summary:

• IT dedicated professional 11 yrs /Sr. OBIEE Consultant 6 yrs , with expertise in gathering Business Requirements, System Analysis, Design Data Modeling, Development, configuration and deployment.
• Five years of experience in RPD Development of Oracle Business Intelligence Enterprise Edition OBIEE 11.1.6.x , OBIEE 10.1.3.4.2 , Oracle 11g and Data Modeling BI .
• Know how to use Oracle Data Integrator ODI and Oracle OBIA applications
• Very well versed with Agile Methodology working model.
• Worked extensively on OBIEE/Siebel Analytics Administration Tool involving all the 3 layers namely Physical Layer, BMM Layer and Presentation Layer
• Extensive experience in OBIEE/ Siebel Analytics Presentation Services
• including Answers, Interactive Dashboards, Delivers/IBOTS, Cache Management, Scheduler Configuration, BI Publisher.
• Extensive experience in OBIEE security models implementation and OBIEE Environment administration MUD creation, configuration and Support .
• Reporting solution design and OBIEE customizations to meet end users reporting requirements.
• Excellent aptitude in translating high-level business requirements into logical business dimensional model, building business models, configuring metadata, Answers, Delivers / iBots, creating reports / Dashboards, cache monitor.
• Expertise in Business Model development with various functionalities like Dimensional Hierarchies, Measures, Aggregation Rules, Time Series and other functions.
• Skilled with Caching Mapping, data- level and object-level security ,MUD, Integration Variables/Initialization Blocks configuration.
• Highly skilled in building Interactive Dashboards with drill-down drill-across capabilities using global local Filters, Business Rules with User Identity Roles, Profiles Personalization
• Knowledge of implementing the Oracle BI / Siebel Security Setup groups, data access/query privileges , Metadata Objects Subject Area, Table, and Column and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Debugging, Optimizing and Performance Tuning of OBI Siebel Analytical Dashboards / Reports to improve performance at Database.
• Proficient in working on production and development environment in different RDBMS in Oracle 10g/11g .
• Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data
• Very good experience in Onsite offshore development model.

Employment History:

Role: OBIEE Onsite Lead

Confidential

Responsibilities:

• Gathered and analyzed requirements from the business users and translated the business requirements into conceptual and detailed technical design.
• Designed and developed OBIEE Metadata repository .rpd that consisted of Physical layer, business model and Mapping layer Aggregates, Dimensions and time Series functions and presentation Layer.
• Designed and implemented Physical and Logical Star Schemas/Diagrams using Fact, Dimension, Alias and Extension tables as well as Foreign and Complex joins.
• Created numerous executive level reports and Dashboards to provide insight into data at different granularity and perspective.
• Developed many Reports using different Views Pivot Table, Chart, and Column Selector , Interactive Dashboards with drill-down capabilities, charts, tabular using Dashboard and Page Prompts.
• Worked extensively with dashboard prompts to filter dashboards and populate variables.
• Implemented and introduced the Answers capability of OBIEE to the users.
• Created dimensional hierarchies, assigned levels and custom aggregation rules for each level, and configured cross-dimensional drill downs to get more detailed views of the data.
• Implemented security by creating users web groups, setting up External Table, creating session variables and initialization blocks and associating catalog objects with the created groups.
• Created comprehensive and easy-to-understand Oracle Answers Dashboards User Guide, and provided intensive Training to business users.
• Configured Row Level Security and Object level security to allow users to view their respective data only according to the requirement.
• Performed Regression testing for the reports generated in the earlier phases.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.
• Conducted a POC on Map viewer Implementation for further release.

Environment: OBIEE 11.1.1.6.5,SQL Server 2008, SQL Server Management studio, SSIS, Windows 2003/ XP.

Role: Sr. OBIEE Consultant

Confidential

Responsibilities:

• Gathered and analyzed requirements from the business users and translated the business requirements into conceptual and detailed technical design.
• Performed Installation and Configuration of OBIEE Server including additional OBI components.
• Designed and developed OBIEE Metadata repository .rpd that consisted of Physical layer, business model and Mapping layer Aggregates, Dimensions and time Series functions and presentation Layer.
• Designed and implemented Physical and Logical Star Schemas/Diagrams using Fact, Dimension, Alias and Extension tables as well as Foreign and Complex joins.
• Created numerous executive level reports and Dashboards to provide insight into the HR reporting
• Developed many Reports using different Views Pivot Table, Chart, and Column Selector , Interactive Dashboards with drill-down capabilities, charts, tabular using Dashboard and Page Prompts.
• Extensively used Delivers and iBots for delivering personalized reports to users, the management and sales teams as per the business requirements.
• Worked extensively with dashboard prompts to filter dashboards and populate variables.
• Implemented and introduced the Answers capability of OBIEE to the users.
• Created dimensional hierarchies, assigned levels and custom aggregation rules for each level, and configured cross-dimensional drill downs to get more detailed views of the data.
• Implemented security by creating users web groups, setting up External Table, creating session variables and initialization blocks and associating catalog objects and Web modules with the created groups.
• Created comprehensive and easy-to-understand Oracle Answers Dashboards User Guide, and provided intensive Training to business users.
• Configured Row Level Security and Object level security to allow users to view their respective data only according to the requirement.
• Performed Regression testing for the reports generated in the earlier phases.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: OBIEE 11.1.2.0, Oracle, Informatica 7.1.2, SQL Server 2005, SQL, SQL Plus, TOAD, Windows 2003/ XP.

Role: Sr. OBIEE Consultant

Confidential

Responsibilities:

• Requirements gathering from users through meetings, understanding the business model and end
• Worked with Business user in Understanding the OBIEE reporting needs from target user groups.
• Involved in the design of Analytics repository from the Physical layer to the Presentation layer and defining the responsibilities for various users and groups based on position.
• Configured Dimension tables in Business layer for Drill down functionality.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Created dimension hierarchies, levels, level based measures and defined logical levels and keys.
• Implemented the security in OBIEE Admin tool to set up users, groups and access privileges.
• Used the expression builder utility for the new logical columns in the BMM layer and created various calculation measures.
• Created Sales Dashboards for different positions Hierarchy in different Business Units.
• Extensively worked on Data analysis of various data marts and source systems like Oracle ERP Application.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector
• Implemented the Customer Product Dimensions and their hierarchies.
• Created user level security for intelligence dashboards based on Business Requirement.
• Implemented security by creating roles web groups, checks with External tables and Object Level Security.
• Created mock reports and dashboards for review by the business users
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Modified existing reports and created new reports from Siebel Data as source and Siebel DW tables as per the business requirements.
• Extensive Performance tuning in OBIEE by implementing aggregate navigation and cache management techniques
• Involved in Creating the required mappings using Informatica PowerCenter Designer and created the tasks for the mappings developed through Informatica PowerCenter
• Developed standard mapping using various transformations like expression, aggregator, joiner, source qualifier and router
• Good experience in communicating with offshore team
• Extensively performed data validations and created mapping document from source to target
• Involved in testing/validating and debugging the applications using SQL scripts and appropriate log files.

Environment: OBIEE 10.1.3.3/Siebel Analytics, Oracle, Informatica 7.1.2, SQL Server 2005, SQL, SQL Plus, TOAD, Windows 2003/ XP.

3. Role: Sr. OBIEE Developer

Confidential

Responsibilities:

• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business model and mapping and presentation layers of metadata repository.
• Created and modified repository file and modeled data in physical and BMM layer using physical and complex joins.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed Business models to represent business logic for Service and created logical tables and defined the complex joins for a business model.
• Involved in Understanding the user requirement and developing the Technical documentation.
• Extensively involved in review of the Design documents with the peers at different levels
• Involved in resolving the UI layer formatting issues at OBIEE Answers level.
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.
• Responsible for the administration and migration of user reports or repositories between various environments
• Extensively worked with Administration team to resolve the issues happened while migration to different environments.
• Involved in Modifying the existed Fact tables and Dimension tables in the Business Model and Mapping Layer as per the requirement changed.
• Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
• Involved in Modifying the Columns at BMM and Presentation layers by using existing joins.
• Involved in modifying the calculations at Answers level based on the requirement changes.
• Involved in unit testing the reports .
• Extensively worked on the defect fixing, Technical document changes and migration process.
• Updating the status sheets on regular basis to know the status of the objects.
• Involved in MOM preparation
• Worked as a onsite offshore coordinator
• Build test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: OBIEE 10.1.3.4.1 , Oracle 10g, Informatica,Toad, Siebel CRM,DAC 10.1.3.4.1.

Role: OBIEE Developer

Confidential

Responsibilities:

• Created reporting metrics and transfer key performance indicators to a process and database design.
• Create/Modify Metadata repository suiting to company's data requirements by using OBIEE tool.
• Created connection pools, physical tables, schema folders and catalog folders in the physical layer of the repository.
• Defined Primary key-Foreign key relationships, complex joins bridge tables between dimension tables and Fact tables in the physical layer.
• Created dimension sources for each level of aggregated fact data and specified aggregate levels for each source.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Created Aggregate tables and fragmented fact tables for efficient query performance.
• Analyzed and recommended enhancement to metadata reporting in all three layers Physical Business and Presentation .
• Extensively used filter, update, lookup, expression, router and sequence generator transformations.
• Defined the refresh extraction logic based on the last updated column in the Transactional Tables.
• Created workflows for the Initial load and refresh load.
• Created mappings to populate the aggregate, hierarchy and helper tables.
• Involved in the integration testing and unit testing the data. Identified bugs during the testing phase and fixed them.
• Tested and Validated the Repository before making it available for queries.
• Configured query cache to reduce the cost of database processing and reduce the Server processing overhead.
• Defined session variables for users to enhance data level security.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Responsible for making the end users understand the features of Answers.
• Worked Extensively on OBIEE Answers to create the reports as per the client requirements.
• Created and modified the request, modified the result layout and added filters to them according to the need of end-users.
• Configured I-Bots to deliver analytics content-based alerts as per user requirements.

Environment: OBIEE 10.1.3.4, , Oracle 10g, Toad, Erwin, Oracle BI Publisher 10.1.3.4.0, , DataWarehouse Administration Console 10.1.3.4.1. , Siebel 8.0

Role: Siebel Business Analyst

Confidential

Responsibilities:

• Involved in analysis of existing US Siebel functionality and redesigning it for Canada Business to retire MFGPRO/Adesso.
• Refactored Custom BS's and Workflow Processes.
• Involved in HLD's preparation and is responsible for getting them approved by COE.
• Involved in Use Case and PQ documents preparation along with functional team.
• Did requirements gathering and analysis and finalized what are the entities to be migrated using EIM tasks.
• Established conversion strategies to meet business requirements.
• Involved in Effort estimation.
• Responsible for preparing Data Conversion Design documents, High level Mapping documents and maintain Data Issue Trackers.
• SPOC for entire data conversion that involved conversion of data from various legacy systems like Oracle, Customer Master, IB, Pharma Clinical Systems
• Coordinating with EIM team and legacy system teams.

Environment: Siebel Tools 7.8.2, Siebel ePharma, Oracle 9i, Windows Advanced Server 2000, Toad 7.5.2

Role: Senior Siebel Consultant

Confidential

Responsibilities:

• Provided Functional Support.
• Managing support cases logged using Clarify and creating Weekly Reports.
• Proficient in setting up and implementation of HandHeld users, Installation, Trouble Shooting.
• Interacted and fixed issues with HandHeld users from different countries.
• Created drafts for future reference: Handheld Trouble shooting guide, Draft for NewHire Resignation and some more general support Activities.
• Did Enhancements to Release3 of Application.
• Took part in Business requirement Analysis. Prepared HLD's, Functional Test Scripts and UAT scripts.
• Application Administration, Multi Lingual LOV administration.
• Configuration using Siebel Tools. Did some Cosmetic changes to look and feel of the UI.
• Designed LLD's and implemented BC changes, Pick Applets, Web Templates, Logo Changes, Symbolic String Locales for Multilingual Display in line with business requirements. Have Experience in extending columns.
• Generated a couple of SQL queries for Data requests.
• Coding the requirements using Siebel eScript.
• Involved in Territory Realignments, Working knowledge in Assignment manager.
• User/Employees setup in line with the business requirements.
• Created Workflows, RCRs.

Environment: Siebel Tools 7.8.2, Oracle 9i, Windows Advanced Server 2000, Clarify CRM 6.0.1, Toad 7.5.2