SUMMARY

• 7 years of experience in Software development and expertise in OBIEE Repository development, Creating Dashboards and Reports in OBIEE projects.
• Involved in gathering business requirements, analysis, design, data modeling, development, which includes development of business reports using Oracle BI.
• Expertise in Building Metadata Model .rpd , Building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool along with development of dynamic and interactive Dashboards.
• Worked extensively on OBIEE Administration Tool, Oracle BI Server, OBIEE Answers, OBIEE Dashboards, OBIEE Delivers.
• Experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers, creating reports, Dashboards, cache monitor, and building Siebel Analytics Repository using Siebel Analytics/OBIEE.
• Configured and scheduled Intelligence Agents ibots to send real-time alerts to the end users using Delivers and created reports using BI Publisher.
• Extensively worked in Multi-User Development Environment MUD and using OBI Answers to run queries to test and validate the repository and Migration of reports to the Dashboards.
• Involved in upgrade of OBIEE 10g to OBIEE 11g using Upgrade Assistant.
• 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 .
• Strong understanding of transactional data modeling, dimensional modeling and designing Star schemas, Snowflake schemas and Physical and Logical data modeling.
• Expertise in Creating Filters, Global Prompts in Dashboards, Presentation Variables, and Narrative Views to filter the data.
• Experience in Creating Dimensional Hierarchies, Level Based Measures and Time series Functions.
• Experience in implementing security in OBI using Repository Variables, Initialization Blocks, and Session Variables.
• Motivated self-starter with strong desire to exceed customer expectations.
• Excellent problem solving, troubleshooting, communication skills and willing to adapt to the team environment.

TECHNICAL EXPERTISE

PROFESSIONAL EXPERIENCE

Confidential

OBIEE Consultant

Responsibilities:

• Involved in gathering new and existing report Business Requirements.
• Identified the Data Sources Relational, Excel etc. , Facts, and Dimension tables in designing the Star Schema.
• Designed and Built OBIEE RPD at 3 layers i.e., Physical Layer connecting Data sources import schema , Business Model and Mapping create Logical tables data source mapping and Presentation Layer level create presentation catalogs. .
• Designed and implemented Physical and Logical Star Schemas/Diagrams using metric, Dimension, Alias and Extension tables as well as Foreign and Complex joins.
• 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 Delivers and iBots.
• Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security. Extensive experience in Metadata Modeling at all three layers Physical, Business Model and Presentation using the OBIEE. Administration Tool.
• Involved in upgrade of OBIEE 10g to OBIEE 11g using Upgrade Assistant.
• Created groups in the repository and added users to the groups and granted privileges explicitly through group inheritance.
• Worked extensively on OBIEE Answers to create the reports as per the requirements.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Defined additional views compound, table, chart views of the data returned by the request to visualize data in many different ways.
• Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.
• Trained End Users and Pilot Users about OBIEE Tools.

Environment: OBIEE 11.1.1.7.0, Oracle Database 11g, Weblogic, SQL Developer, Informatica 8.2

Confidential

OBIEE Consultant

Responsibilities:

• Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
• Design and build OBIEE data level security base on LDAP to deliver an intelligent authentication mechanism with Row-Level security.
• Used the OBIEE Admin Tool to develop the three layers in the Repository.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on OBIEE Answers to create the reports as per the client requirements.
• Defined additional views compound, table, chart views of the data returned by the request to visualize data in many different ways.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Created Proactive agents iBots and configured Interactive dashboards to alert the employees as per the requirements.
• Created groups in the repository and added user to the groups and granted privileges explicitly through group inheritance.
• Enabled Single Sign On for OBIEE to allow authorized users to login automatically to OBIEE without entering user credentials.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
• Worked on improving the dashboard performance, readability, and security.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting.
• Performed Unit, Integration, and End-to-End testing of data and Dashboards.

Environment: OBIEE 10.1.3.4, Oracle 11g, Toad, Windows Server 2003, Siebel Customer Relationship Management 8.1.1, HP Quality Center 9.2.

Confidential

OBIEE Developer

Responsibilities:

• To analyze the specifications provided by the client, understanding the business.
• Implemented Invoice level security in OBIEE depending on the user level access by integrating with EBS.
• Customized OBIEE Styles, Skins and Messages according to the client requirements.
• Developed Customer Hierarchy to generate reports on the Region/Country/Time zone.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers and dashboards.
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Administration Tool.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers
• Copied existing RPDs from Server into the Local machine for testing and tuning of dashboards.
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns.
• Involved in Migration, UAT, Go-Live, and Production Support.

Environment: OBIEE10.1.3.4, Oracle 10g, SQL Developer, SQL Plus, Toad, Windows XP

Confidential

Siebel Analyst

Responsibilities:

• Build the Siebel Analytics repository RPD /metadata and define/create the subject areas where reporting and analysis are centered around.
• Construct data visibility and security rules and implement them within Siebel Analytics to provide record-level, team-based and group-based security into the Data warehouse.
• Design, configure, and document logical and Physical Data Models, Presentation Layer including administrator functionality.
• Create dimension hierarchies to achieve the drill down functionality.
• Imported Physical Tables and Defined Relations in Physical Layer in Siebel Analytics
• Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents iBots to intelligence dashboards for subscribed users.
• Defined Hierarchies, Aggregate Navigations in the RPD.
• Created User Groups in RPD.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer, Created session repository variables using OBI / Siebel Administration Tool.
• Created Dimensional Hierarchy with drill-down capabilities using global and local filters, Logical tables columns, Aggregate columns, Time-Series and Level based Measures Aggregate navigation and customized Star and Snowflake schemas by linking Fact and Dimension tables in the BMM layer.
• Configured Analytics Metadata objects Subject Area, Table, and Column and Web Catalog Objects Dashboard, Pages, Folders, and Reports .
• Developed many Dashboards / Reports with different Analytics Views Pivot Table, Chart, Tabular and View Selector .

Environment: Siebel Analytics, DAC, BI Publisher, Oracle Database, SQL Developer

Confidential

Siebel Analyst

Responsibilities:

• Gathered and refined requirements from the business users.
• Imported metadata in to the Physical layer, applied Business rules in the Business Modeling and Mapping layer, and created customized user views and set up catalog folders in the Presentation layer using administrator tool.
• Designed and Developed new subject areas/ Customizations.
• Interacted with users, developed and maintained Reports and Dashboards.
• Resolved application issues faced by users during user acceptance test.
• Responsible for Daily/Weekly/Monthly on time report delivery to the end users.
• Configured report level security and user interface designs.
• Thoroughly examined the source structures and leveraged existing hierarchies into the analytic reporting solution.
• Configured caching mechanism to improve performance.

Environment: Siebel Analytics 7.5.2, Oracle 9i, PL/SQL and Windows 2000

Confidential

Responsibilities:

• Worked on Siebel Analytics and OBIEE to create reports and Dashboards.
• Designed repository and implemented hierarchies and also implemented Data level and Object level security.
• Created complex joins, transformations of all types to pass data through ETL maps.
• Created many re-usable transformations, Mapplets and used their instances in many mappings.
• Tuned mappings, transformations and recommended tuning options of source/target database to DBA team for obtaining optimum performance.
• Configured the server for Tasks and Workflows using Informatica Power Center Work Flow Manager and monitored them in the Work Flow Monitor.
• Used session partitions, dynamic cache memory, and index cache to improve the performance of the Informatica server.
• Involved in dimensional data modeling and designing the data staging process.
• Participated in weekly end-user meetings to discuss data quality, ways to improve data accuracy and new requirements.

Environment: Siebel Analytics, Informatica Power Center 6.1, Oracle 8i, SQL Server 2000, Windows NT 4.0, PL/SQL.