Summary:

• 7 years of experience in Software Development and Expertise in OBIEE 11.x/10.x Siebel Analytics 7.x and Informatica 8.x/7.x.
• Expert in OBIEE Intelligent Dashboards, BI Publisher, Delivers and Agents (alerts) with OBIEE Applications.
• Experience in installation and configuration of OBIEE, DAC.
• Strong at configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Strong in Data Analysis, Identification of dimensions, Facts, Measures and Hierarchies
• Efficient in Debugging, Optimizing and Performance Tuning of Oracle BI/ Siebel Analytical Dashboards/Reports.
• Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers/Agents, creating Reports/Dashboards, cache monitor, and building Metadata Repository (.rpd) file consisting of three layers (Physical Layer, Business Model & Presentation Layer) using OBIEE/ Siebel Analytics.
• Used DAC (Data warehouse Application Console) for both incremental and full loads.
• Monitored and Scheduled ETL along with reducing application configuration and development time by using DAC.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
• Involved in setting up Agents to run reports after the load for Cache Seeding to Improve Query Performance using Caching.
• Expert in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment.
• Experience in migrating reports to BI publisher.
• Strong conceptual background of RDBMS and access methods SQL, PL/SQL.
• Good Knowledge of database experience using Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, TOAD, PL/SQL, SQL and SQL*Loader.
• Very Good at Data warehousing and OLAP technology – designing star schema, snowflake schema, FACT and dimension tables, physical and logical data modeling using ER studio, design of ETL methodology.
• Experienced in tuning Informatica Mappings, Sessions and SQL queries for better performance.
• Worked on different transformations such as joiner, lookup etc in Informatica.
• Experienced in project management and knowledge of all the phases in a Software Development Life Cycle (SDLC) i.e. Analysis, Design, Building and Testing.
• Solid experience in using PL/SQL for writing Stored Procedures, Functions, Packages, Triggers and in the creation of tables, views, indexes.

Technical Skills:

BI Tools/Analytics : OBIEE 11.1.1.x/ 10.1.3.x, Siebel Analytics 7.8.x
ETL Tools : Informatica 8.1.x/7.x, Oracle Data Integrator (ODI), OWB.
Database : Oracle 11g /10g/9i/8i, SQL Server 2008R2/2008/ 2005/2000,
MS-Access
Scheduling Tools : DAC (Data warehouse Administration Console)
Languages : SQL, PL/SQL, C, HTML, XML
Data Modeling Tools : Erwin, Oracle Designer, and Microsoft Visio
Oracle Tools/Utilities : SQL*Loader, Oracle Designer, SQL Developer, TOAD 8.x/7.x, SQL
Navigator, Oracle Developer 2000
Scripting Languages : JavaScript, UNIX shell script
Operating Systems : Windows Vista, Win 95/98/2000/2003/2007/XP, Linux, UNIX,

Professional Experience:

Confidential,Orlando, Florida Sep 2011 – Present
Sr. OBIEE Developer

Sales & Analytics Project supports the Sales and Financial Teams of Disney to analyze the Daily Gross Sales, Net Sales, Backlog in Orders, Orders Shipped, Orders Booked of Consumer Products Division, The Reports has the ability to determine the Sales against their forecasted Budgets of different Brands and compare the current year Sales with Previous Year Sales of Disney Products, the Report helps in identifying and relocating the Workforce on the manufacturing line to decrease and increase the working hours on a particular brand based on the trend analysis of the Sales of Products.

Responsibilities:

• Worked closely with the business users to identify various KPI\'s and designed solutions to enhance business decision-making.
• Worked on OBIEE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• To create Connection pools, import physical tables and define joins in the Physical Layer.
• Developed and customized some of the existing Dimensions (Drill-Down Hierarchies)& Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Installed and configured different versions of OBIEE, DAC, & Informatica.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in BI Answers.
• Developed Dashboards for each of metrics by embedding reports and providing intuitive drill-downs and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Used OBIEE Delivers to automate Agent queries, obtain weekly reports and to send alerts to related managers and secured team members.
• Designed and Tested Reports in theDashboardsfor theOracle Financial Analyticsmodules likeGL, AP, ARand created the Ad-hocreport according to the client needs.
• Used DAC (Data warehouse Application Console) for both incremental and full loads.
• Monitored and Scheduled ETL along with reducing application configuration and development time by using DAC.
• Experience in performing ETL (Informatica) Execution for SDE and SIL mapping using DAC.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
• Created & saved several BI Publisher reports by selecting an Answers request as Data Source.
• Built multiple execution plans in DAC for weekly and daily loads.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules (Reports, Dashboards, Security and Star schema).
• 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: OBIEE11.1.x,10.1.x, Informatica Power Center 8.x, DAC, Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/LINUX Oracle 11g/10g, SQL, PL/SQL, and TOAD 8.x/7.x.

Confidential,Roanoke, Virginia. Jul 2010 – Aug 2011
Sr. OBIEE Developer

This project is to use a data warehouse to analyze the effectiveness of the marketing campaigns for the incentives and financial services offered by Advanced Auto Parts. This data warehouse was developed by extracting data from Oracle and different sources and is loaded into an oracle target. Different customer related metrics like customer opinions, loyalty, customer profiles and customer satisfaction are analyzed.

Responsibilities:

• Validated the target/destination tables after the data loading mechanism was automated using Data Stage routines.
• Created and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository (.rpd) using Oracle BI Administration Tool.
• Developed Calculated Measures, level based measures and dimension hierarchies in the Business Model and Mapping Layer
• Created Aggregated Tables to improve the Performance of the Reports.
• Created Business Model to support Adhoc Reports for User Access based on Requirements.
• Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.
• Managed Security privileges for each subject area and dashboards according to user requirements.
• Configured Web Catalog Objects (Dashboards, Pages, Filters, Reports)
• Worked on Oracle Answers to build Interactive Dashboards with drill-down capabilities based on period and class hierarchies
• Implemented different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Created Filters and providing customized prompts appropriately to avoid excessive data showing up on reports.
• Involved in setting up Agents to run reports after the load for Cache Seeding to Improve Query Performance using Caching.
• created highly formatted reports using BI Publisher based not only on conventional data sources (such as Oracle Database) but also on various other data sources (such as Web Services, RSS feeds, and so on).
• Created RTF templates in MS Word by connecting to BI Publisher, and publish these templates for the reports to view data in BI Publisher.
• Performed Unit Testing of the reports and involved in writing Test Cases to test the generated Reports.
• Involved in user trainings on the generated reports for this project.
• Participated in Post implementation reviews with the Project teams.
• Worked on Informatica Power Center client tools - Mapping designer, Workflow manager, Workflow monitor, Repository manager, Mapplet designer and Transformations.
• Tuned the Informatica ETL processes for optimum performance by integrating ETL processes based on common sources and optimizing the source SQL to use the correct indexes.

Environment: Oracle 10g, OBIEE 10.1.x, Oracle BI Publisher, DAC, Informatica 8.1, Pl/Sql Developer, Sql, Sql * Loader, Pl/Sql Procedures, Functions, Packages, TOAD8.x, Windows 2000, UNIX, Shell Scripts, ER Studio

Confidential,Columbus, Ohio JAN 2009 – JUL 2010
Sr. OBIEE Developer

Confidential,is a property and casualty insurer domiciled in the State of Ohio with primary interest in Property and causality, Health, Banking and Mortgage, Life insurance & Retirement Savings and Asset Management. The project primarily involved Extracting Underwriting, Rating and Product rules from online and batch process of Policy Administration System. These rules will be loaded
into a rule engine as a next phase. The main aim of the project was to develop new data warehouse using OBIEE thereby creating reporting environment that helps end users to analyze the reports.

Responsibilities:

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Performed gap analysis and feasibility study for the given requirement and functionality required by end users.
• Created mockup reports and dashboards for review by the business users.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository, created level based measures, dynamic and session variables.
• Created materialized views and aggregates to improve performance of slowly and time consuming queries.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Customized reporting with OBIEE Answers and integrated them into the Dashboards, provided users flexibility of viewing summary report and navigate to detail level using navigation.
• Developed various Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Performed Data Validation, unit testing of data in the reports and dashboards,
• Extensively worked on Tuning SQL to improve performance of the reports.
• Created and scheduled iBots to send pre-processed reports using OBIEE Delivers to send users.
• Involved in Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Designed and developed transformations, mappings and sessions using Informatica to load target database.
• Developed mappings in Informatica with transformations like lookup, router, aggregator, expression and joiner confirming to the business rules.
• Performed production support for the project.

Environment: OBIEE 1O.1.x, Informatica Power Center 8.1.x, TOAD7.x, Oracle 10g, Windows server 2003.

Confidential,Seattle, Washington Nov 2007 – Dec 2008
OBIEE Developer

Confidential,is a subsidiary of Northwestern Mutual that is headquartered in Seattle, Washington, U.S.A. The company is a global asset management firm which provides multi-asset investment solutions to individuals and institutions in 47 countries. By bringing together capital markets insights, manager research, strategic asset allocation, portfolio implementation and indexing, Russell is able to deliver the full spectrum of investment strategies and asset classes to help investors achieve outcomes

Responsibilities:

• Interacted with the business users in analyzing and preparing the OBI data, report requirements
• Involved in the installation and configuration of the OBIEE 10.1.3.3 on the Development and Test environment on the Unix boxes
• Created connection pools, imported the physical tables and then creating aliases, defined joins and implemented authorizations in the physical layer of the repository.
• Developed the necessary star schemas in the BMM layer and modified them in order to accommodate the new business requirements
• Created different Hierarchies, Levels and implemented Business Logic by creating level based measures.
• Developed the Facts, Dimensions, necessary hierarchies and complex joins between the logical tables, adding aggregates in the BMM layer
• Created Users and Groups and managing the object level and data level security.
• Implemented the external table authentication and utilized the external table by implementing dynamic session variables and Initialization blocks in repository
• Extensively used different performance tuning methods like Caching, Aggregate tables and creating indexes on tables.
• Developed many Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using in the OBIEE framework.
• Developed reports using Drill across, Drill down using hierarchies like Geography, Position, product and also the dashboards based on (Groups, Aggregated Navigation, Time series wizard, Slowly changing dimension, caching strategy)
• Configured iBots using Delivers, Job Manager to deliver Analytics content through mail, phone to business users based on schedule
• Developed mappings using Informatica to Extract, Transform and load the data from source to the target system.

Environment: OBIEE v10.1.x, Siebel CRM, Informatica 8.1.x, DAC, DB2 v9, AIX 5.3, TOAD, SQL, BI Publisher, Delivers

Confidential,India Feb 2006 – Aug 2007
Siebel Developer

The System is meant for automating and standardizing the operations of the Dealers and Stockiest. The manufacturing organization plans the production schedules and dispatch schedulers depending on the stock levels at the dealers and stockiest. A Siebel CRM application is in place to maintain the opportunities. The project’s aim is to develop the reports on the opportunities and provide ad-hoc capabilities to national center users and the affiliates.

Responsibilities:

• Worked closely with Business Analyst, Discussed and Gathered the Analytics requirements and created the Business Model using Star schemas.
• Generated various Analytics Reports like APAR, ACPAR, Formulary Report and Direct Sales Report etc.
• Extensively used Siebel Analytics Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository.
• Specified aggregate levels for each source and created dimension sources for each level of aggregates.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created iBots and Delivers to send Alert messages to subscribed users.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Configured and administered existing subject areas and created new subject areas to include new Star Schema information.
• Performed end-user training to develop ad-hoc reports using Siebel Answers.

Environment: Siebel Analytics 7.8.x,, Informatics Power Center 7.2, Oracle 8i, TOAD, SQL Navigator, PL/SQL, XML, Windows XP

Education:

Bachelor’s