CHRONOLOGICAL SUMMARY of Experience

Sr. OBIEE Developer

Confidential

• Installed and configured the OBIEE 11 g, RCU Utility and dealt with the installation issues.
• Participated in the Business requirements gathering meetings with the end users/business people.
• Involved in the migration of rpd, reports and dashboards from 10.1.3.4 to 11.1.1.6.2
• Build the Physical, Business Model and Mapping BMML , and Presentation layers of a repository Extensive experience in designing dimensional models such as Star Schemas.
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.
• Responsible for creating custom columns in the BMM layer to calculate the percentage changes in the sales.
• Used multiple data sources to logical tables in a business model while building a repository.
• Created calculation measure using Answers, Physical Columns, Logical Columns and Calculation Wizard.
• Configured Oracle BI scheduler in an application and server that manages and schedules the job.
• Developed reports using BI Dashboard and Answers, views charts, created filters to obtain weekly sales for each region send alerts to upper management.
• Used the Aggregate Persistence Wizard to create and model aggregate tables for faster query processing in decision support systems.
• Knowledge in Usage tracking in determining user queries that are creating performance bottlenecks, based on query frequency and response time.
• Involved in Data level and object level security model in OBI presentation catalog to view their report according to the user level/position and permission.
• Created various Ad-hoc reports for day-to-day business requirements making use of global and shared filters with different views in accordance with the requirements.
• Used Oracle EBS as a source system.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
• Generated Agents using the Delivers to send notifications to the management.
• Conducted training sessions for users on how to Subscribe/Unsubscribe for the reports.

Environment: OBIEE 11.1.1.6.6/10.1.4.1, Oracle 10g, Oracle EBS R12, IBM DB2, Teradata V2R6.x, MS Access 2007,Windows XP, SQL, DAC, Toad, Windows 2003

Sr. OBIEE Developer

Confidential

• Involved in meetings with users, BA's, and data analysts, and examined the business, functional and technical design documentation.
• Extensively tested the mappings by running the queries against Source and Target tables and by using breakpoints in the debugger.
• Created a repository using OBIEE Administration tool by importing tables into the physical layer and created the business and mapping model to incorporate the business logic.
• Helped Customize and develop RPD, configured metadata objects Subject Area, Table, and Column and Web Catalog Objects Dashboard, Pages, Folders, and Reports .
• Configured measures in the Logical Layer and mapped to multiple logical source tables.
• Created presentation catalog which allows exposing the business model to users in OBIEE Answers so that users can build requests to analyze the data.
• Implemented Analytics Data level Security by creating Groups and setting up content filters in the repository.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities.
• Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users.
• Created Prompts to Filter Interactive Dashboard Data and Configuring Guided Navigation Links.
• Created Pivot tables, views, charts.
• Implement Operational Dashboards to view the completed tasks and open tasks in the dashboards.
• Co-ordinate with the offshore team and taking care of all the deliverables.
• Migrating the Repository, Answers and Dashboards to 10.1.4 to 11.1.1.6
• Created technical specifications and mapping documents to design and implement ETL process.
• Supported and assisted the production ETL by identifying and recommending the necessary solutions to the production problems.

Environment: OBIEE10.1.4, OBIEE 11.1.1.6,Oracle 11g ,TOAD, UNIX and Windows 7

OBIEE Developer

Confidential

• Studying the existing application architecture, designing and identifying the reporting requirements and prepare the requirements specifications document. This involved interacting with the business users and understanding the requirements.
• Performed Project Scoping, Project Organization and Management including Business IT Requirements, Priorities.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships Foreign Keys Physical Logical between tables
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Experience in BI Applications in development of rpd, data models and integrating with EBS, SFDC for development
• Created Facts like Opportunity, Project for Project Portfolio Subject Area.
• Created Metrics like Conversion rate, Amount in USD.
• Created Customized Dashboards like Pipeline, Project Portfolio catering to provide insight into the sales / marketing / financial data.
• Created different types of Customized Reports Drill-down, Aggregation, Levels to meet business requirements. Generated various Analytics Reports like Formulary Report, Union Report and Direct Sales Report using global and local filters.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes and managed day-to-day Repository, Scheduler iBots.
• Managing appropriate security privileges on subject areas Data Level and dashboards Object Level according to business requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.

Environment: OBIEE 10.1.3.4, Oracle 11g, SQL plus, PL/SQL,TOAD,DB2, Quality Center, Windows XP.

OBIEE Developer

Confidential

• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Worked in data warehouse designing where I need to deal with workflow manager, warehouse designer, and mapplet designer for complex ETL processes.
• Created/Modified Metadata repository .rpd and Configured Metadata Objects using Siebel Analytics Server Admin tool.
• Using Hyperion, business users to quickly model complex business scenarios
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Setup the visibility of Dashboards to employees with respect to their responsibilities.
• Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
• Developed Mappings and Workflows using various Transformations Update Strategy, Router, Expression, and Aggregator .
• Data warehousing development using ETL Tools such as experience in DAC Data warehouse Application Console Configuration
• Using web logic to deploy the data.
• Now we are Implementing OBIEE 11g with smart view.

Environment: OBIEE 11.1.5, 10.1.34, DAC 7.9.5,Weblogic 6 Oracle 10g, Windows, UNIX, Solaris, Mainframes.

OBIEE Developer

Confidential

• Understanding the Client requirements, source data, business objectives and key performance indicators.
• Worked with Retail and sales analytics to make sense of business performance by adding context to real-time business measure
• Interacted with business Management representatives for gathering the Reports/ Dashboards requirements and to define business and functional specifications.
• Designing the Technical Design documents by understanding the Functional Design documents for the sales performance.
• Experience in Dimensional Data Modeling and Technical documentation and presentations.
• Identified the Gaps by analyzing the Data mart Instance and provided alternative solutions as well recommended changes to Database.
• Analyze data components and document Data Strategy to identify Key Metrics for Reporting.
• Installed and configured Oracle BI EE 10.3.3.4
• Responsible for Installing, Configuring and Administration of OBIEE 10.3.3.4 Repository for Physical, Business Model and Presentation services.
• Maintaining the Full and Incremental loads through DAC on different environments like Development and Test environment.
• Responsible for setting up the environment including installation of OBIEE in all the environments.
• Configuring the Analytics repository RPD and implementing the security to authenticate and authorize Oracle users.
• Responsible for implementing OBIEE for the modules Retail and Sales.
• Built the Physical Layer /Logical Layer/Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Using Hyperion to define a dimensional view of the business
• Worked with historical depth and subject-area breadth sets the data warehouse apart from other information files, application databases, report caches, content stores, data marts
• Identified the Facts, Dimensions, and grain of the Dimensional mode, and referential joins.
• Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
• Built Repository at 3 layers i.e., Physical Layer connecting to Data sources and import schema , Business Model / data mapping create Logical tables and data source mapping and Presentation Layer level create presentation catalogs .
• Created Business Facts Dimensions and defined Logical relation between them in BMM layer.
• Testing and implemented Stored Procedures, Triggers, Functions, and Packages at database level.
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.
• Also worked with Security of the application/solution to define users and groups, set permissions, Group Inheritance, Authentication Methods, Query Limits, Timing Restrictions, and Filters.
• Extensively worked on Answers, Created Reports using different Analytics Views Pivot Table, Chart, Column Selector and Table .
• Implemented Security by creating roles web groups, checks with External tables and LDAP.
• Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Designed Executive Dashboards to provide Business Critical Analytical view of the Written Sales for a set of Power Users
• Create/Manage Repository/Web Users and Groups and assigning permissions using OBIEE Administration Tool.

Environment: OBIEE 10.3.3.4, DAC 7.5, Oracle 9i, Windows server 2003, SQL DEV, SQL Loader.

OBIEE/Siebel Analytics Consultant

Confidential

• Analysis, Requirements gathering, function/technical specification, development, deploying and testing.
• Involved in Creating and Administering the Physical Layer, Business Model Mapping Layer and Presentation Layer in a Siebel Analytics repository.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Configured and Created repository using Siebel Analytic Admin tool.
• Developed custom reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards in Sales Analytics and Marketing Analytics.
• Configured and created Siebel Delivers, Scheduler and Alerts
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes.
• Managed day-to-day .rpd, Scheduler iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Handled Full load and refresh load via staging tables in the ETL Layer.
• Involved in Design and Data Modeling using Star schema.
• Logical Physical Database Layout Design using Erwin
• Designed assisted Informatica ETL developer to create new Aggregate.
• Created Informatica mappings for initial load and daily updates.
• Developed several mappings to load data from multiple sources to data warehouse.
• Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL
• Performed Data conversions.
• Involved in troubleshooting the load failure cases, including database problems.

Environment: Siebel Analytics 7.5.2, Informatica Power Center 8/7.1,OBIEE 10.1.3, Oracle 9i, ERWIN 3, UNIX, SQL server

OBIEE Developer

Confidential

• Worked closely with Business Analysts in understanding the Analytics requirements and created Business Models for generating Reports as per the requirements.
• Created and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository .rpd using Oracle BI Administration Tool.
• Developed many Reports/Dashboards with different Analytics Views Drill-Down Drill-Across, Pivot Table, Chart, View Selector, and Column Selector, with global local Filters using Oracle BI/Siebel Analytics Web.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and user Security.
• Creating reports using Oracle's FRS.
• Developed Accounting and Collection Time Series Object Oracle BI Time-Series Functions for comparing the Billings, Collections and Adjustments.
• Created Users, Groups and giving the permissions in Siebel Analytics Administration Tool and verifying the Permissions of the users in Siebel Analytics web.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Developed many complex Informatica mappings and mapplets to build key interfaces using reusable transformations Source Qualifier, Lookup, etc. for loading data into Data Warehouse.
• Worked on OBI Delivers and Configured iBots to deliver Analytics content based on a schedule.
• Created Filters and provided customized prompts appropriately to avoid excessive data.
• Involved in building and migrating the DAC metadata across DEV/ST environments.
• Used JavaScript's in OBIEE to search a Report and Custom Data Format.
• Used Informatica Power Center to develop ETL mappings, transformations, and to load data.
• Enforced Row Level Security for Managers to View the Reports pertaining to their Region.
• Worked extensively on Oracle BI Publisher and provided the capability to download the reports in the user defined formats.
• Used Informatica transformations like Normalizer, Expression, Filter, Aggregator, Update Strategy, Lookup, Joiner, etc. extensively to create complex mappings and mapplets.
• Performed Tuning of Dashboards/Reports by aggregate navigation, and cache management.
• Involved in preparing/executing Test scripts, establishing Test Data, and recording defects.

Environment: Siebel Analytics 7.8.2/ Oracle Business Intelligence 7.8.4, Informatica Power Center 7.7.1, Data Warehouse Administration Console DAC , Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/Linux, Shell Scripting, Oracle 11g/10g, My SQL 2005, PL/SQL, and TOAD 6.3/7.0.