SUMMARY

• Confidential is an accomplished Senior OBIEE Developer with 7+ years of experience in designing and developing end - to-end BI solutions according to standard OLAP methodologies using Siebel Analytics/Oracle Business Intelligence (OBIEE), including 3 full life cycle implementations.
• Oracle Certified Specialist with expertise in Complete Software Development Life Cycle (SDLC) implementation of various Business Intelligence and Data Warehouse / Data Marts that covers gathering Business Requirements, GAP Analysis, Design /Modeling (Star and Snowflake), Development, Testing, Implementations and Documentation.
• Extensive Business Intelligence experience using Oracle BIEE 11.1.1.X, 10.1.4.X, Siebel Analytics 7.x and Informatica 8.x/7.x/6.x.
• Very strong experience in developing OBIEE / Siebel Analytics Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using page and dashboard prompts, Security Setup (groups, object and data level), LDAP, External Tables, configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots and Smartview.
• Experience in implementing pre-built Analytics such as Order Management, Order Fulfillment, Sales, Marketing, Forecasting and Finance.
• Expertise in debugging, optimizing the Performance Tuning of Oracle BI / Siebel Analytics Repository & Dashboards / Reports and ETL, Informatica / Mappings / Workflows.
• Experience in setting up a Multi-User Development Environment (MUDE).
• ImplementedUsage trackingto analyze and tune the query performance.
• Multi-Platform experience on UNIX / Linux and Windows Server family of products.
• Business Analysis experience with excellent communication & interpersonal skills, broad understanding of business operations and requirements.
• Worked with business in identifying opportunities for cost optimization and revenue growth by appropriate use of business intelligence and analytics.
• Extensive experience in indentifying and resolving bottlenecks to improve performance at database and reporting level.

TECHNICAL SKILLS

• OBIEE 11.1.1.x 10.1.4.x
• Siebel Analytics 7.5 7.7
• C
• C++
• C#
• SQL
• PL/SQL
• ER Diagram
• Entities
• Attributes
• Cardinality
• Relational Modeling
• Physical Modeling
• Logical Modeling
• Dimensional Modeling (Star Schema
• SnowFlake
• FACT
• Dimensions)
• ORACLE 11g 10g/9g/9i/8i
• SQL Server - 2005/2000/7.0/6.0
• Sybase SQL
• DB2
• EBS
• Ms-Access.
• Microsoft-Office
• Microsoft Visio
• IBM Rational Rose Requisite.
• HTML
• CSS
• XML
• Java Script.
• Windows
• Server 2003/2007
• UNIX
• Linux Red Hat.
• SQL * Loader
• Toad 9.0/8.5.1
• SQL Developer
• OID.

PROFESSIONAL EXPERIENCE

Sr. OBIEE Developer

Confidential, Sacramento, CA

Responsibilities:

• 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 tablesfor 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, OH

Responsibilities:

• 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 in corporate 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
• Createdtechnical specifications and mapping documentsto 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

Confidential, WA

Responsibilities:

• 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, Tampa, FL

Responsibilities:

• 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, OAK, CA

Responsibilities:

• 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, CT

Responsibilities:

• 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

Responsibilities:

• 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.