Summary:

• Dedicated IT professional for over 8 years of progressive expertise in design, configuration, development, testing and implementation of Data warehousing and Business Intelligence Applications.
• Deep understanding of Information Technology Software Development Life Cycle SDLC methodology and project management principles.
• Worked extensively in the analysis and development of Data warehousing applications using Siebel Analytics 7.5/7.7/7.8.4, OBIEE 10g/OBIEE11g 11.1.1.5, 11.1.1.6, 11.1.1.7 , Informatica 8.x/7.1.4/6.x.
• Extensive experience in BI Administration Tool, BI Analysis, Dashboards, BI Publisher, Delivers and iBots with OBIEE Applications.
• Having Very Good knowledge in Data modeling OLTP, OLAP and ERWIN Data Modeling Tool.
• Extensively experienced and comprehensively skillful in using various features/tools of OBIEE involving both server side and web backend, front end .
• Experience with Oracle EBS Oracle E-Business Suite .
• Experience in installation and configuration of OBIEE, DAC and administering permissions, privileges to users based on their groups and responsibilities.
• Excellence in providing end-to-end business intelligence solutions by building business models, configuring metadata and building OBIEE Repository consisting of three layers Physical Layer, Business Model Presentation Layer .
• Building of RPD application design for Physical, Logical BMM , and Presentation layers, configuration of those layers, development of Reports, Dashboards, BI Publisher, and integration to Microsoft suite of tools, testing, and deployment.
• Expertise in creating complex and standard reports using various views in Answers.
• Extensively designed Interactive Dashboards, incorporating user friendly capabilities such as dashboard prompts, navigation, drill-down and Web Catalog Objects using OBIEE.
• Implemented Multi user Development MUD Environment in Development Environment
• Experienced in Debugging, Optimizing and Performance Tuning of Oracle BI. Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views.
• Experience configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup groups, access / query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Expertise in integrating and customizing BI Office Plugin for BI Publisher with OBIEE.
• Strong Expertise in designing the report layout templates in the BI Publisher.
• Experience in creating requests, adding filters, creating prompts, and creating pivot tables using OBIEE.
• ETL jobs creation customization using Oracle Data Integrator ODI .Modify existing ETL jobs in Oracle Data Integrator ODI .
• Develop data extracts from the data warehouse environment using ODI.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Solid understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data modeling.
• Experience in developing Dimensional Hierarchies/New logical columns/Variables per business requirements.
• Experience in building and deploying an OBI repository Physical, Business and presentation model to create Dashboards, answers, iBots.
• Excellent understanding of bridging gap between IT and business to exchange ideas, resolve outstanding issues and rolling out innovative and strategic reporting roadmaps utilizing key performance Indicators KPI's and business performance metrics.
• Implementation of data level security in Business Model for both position and geo based security for different user groups .
• Devised strategy for refreshing report query by both purging and seeding cache
• Created Table partitions, Materialized views with query rewriting, creating appropriate indexes, re-building indexes, ran statistical analysis and query plans for tuning and enhancing query performance.
• Operational Administrator for Analytics production environment, ensuring smooth maintenance and high availability.
• Extensive knowledge in creating dimension hierarchies and level-based measures.
• Experience in adding disparate sources to business model objects.
• Extensive experience in modeling aggregate tables to speed processing.
• Excellent understanding of Data Warehouse Architecture, Star Schema, and Data Marts decomposing High-level design documents into ETL specification document.
• Customized the User interface design look and feel Skins Styles for OBIEE products Answers Login Page, Banners, CSS files, etc. as per company specific standards.
• Working Knowledge in developing various Informatica Transformations and Mappings.
• Extensive experience in Oracle 11g/10g/9i/8i - design and developing stored procedures/packages, database triggers, cursors using SQL, PL/SQL.
• Strong knowledge of SQL Loader for extraction of data from legacy databases to Siebel interface tables.
• Very strong analytical and presentation skills, problem-solving techniques, proven leadership qualities with emphasis on individual and team effort backed by excellent communication skills.

Skill Set:

Oracle 7.3,8i, 9i, 10g, 11g, SQL Server 2000,2003,2005, MS Access., C,C , SQL, PL-SQL, Informatica Power center 9.0.1,8.1.6 , Oracle OLAP, OBIEE 10.1.3.x/11.1.1.x, SQL Loader, TOAD, SQL developer , Unix Shell Scripting, Java, JavaScript, HTML, XML, Windows 7/XP/00/NT/98/95, Windows 2008/2003, Linux, UNIX Solaris ,MS Visio, Teradata, Erwin.

Professional Experiences:

Confidential

OBIEE Developer

Responsibilities:

• Gathered user requirements, reporting requirements and prepared the requirement specifications document.
• Designed and developed OBIEE repository at 3 layers i.e., Physical layer connecting to Data sources and import schema , Business Model Mapping Layer create Logical tables and data source mapping and Presentation Layer level create presentation catalogs .
• Customized prebuilt Repository according to the Business requirements with necessary logic that involved creating the physical, BMM and the presentation layer. Also created hierarchies, variables, and poll strategies in the repository.
• Implemented DYNAMIC column naming.
• Implemented security at the data and object levels as per the business user requirement.
• Administered various OBIEE environments with large number of users and provided optimum system uptime and performance. Designed security matrix, configured Authentication and Authorization architecture, and provided permissions to users according to their role.
• Created dimensional hierarchies and multiple dimensional hierarchies and various set levels in the Business Model Layer and Mapping Layer of Repository implementing drill down, Aggregation and Sum over columns.
• Used appropriate filters, column filters, prompts, dashboard prompts and calculations in reports.
• Developed Reports and Dashboards in different Analytical Views ticker, narrative, column selector, view selector, legend, funnel Pivot Table, Chart to visualize data in different perspectives using OBIEE Answers.
• Used Variable Manager in OBIEE Administration tool to define various Repository Session variables.
• Extensively used pivot table view and chart views to enhance the presentation.
• Designed and developed BI- Publisher Reports Layouts using BI-Publisher Desktop using sample Xml data source Answers request as data source and Deployed on to the BIP server.
• Created layouts using XSL-FO-Style sheet.
• Customized the look and feel Skins Styles for OBIEE products Answers Login Page, Banners, CSS files, etc. as per company specific standards.
• Performance Tuning of dashboards/Reports and made recommendations for changes to database by implementing the materialized views and aggregate tables.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance optimized manner.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Used column formatting functions in Oracle BI Answers.
• Responsible and assisted in migrating the web catalog and RPD from different environments.

Environment: OBIEE 11.1.1.7 , Oracle 11g, Informatica Power Center 9.1.0, PL/SQL.

Confidential

OBIEE Developer

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements and Data Analysis.
• Integrated OBIEE with PowerBuilder application.
• Integrated OBIEE with the CRM application.
• Creating and Implementing Subject Area with Various Business logic Rules including Logical Columns, Aggregate Persistence, Level Based Measures , Dimensional Based Measures, YTD AGO Measures, Multiple LTS in Business Logic Mapping Layer in Repository.
• Created metadata BIPLATFORM and MDS metadata repository schemas using RCU.
• Configured the data sources in web logic and scheduler connection settings of the database in em for the database connection issues after moving OBIEE repository database schemas to another database.
• Extensively Used different types variables which includes Repository Variables, Presentation variables and Session Variables.
• Installed OBIEE 11g with horizontal clustering.
• Scaled out the OBIEE between servers for high availability.
• Involved in Identifying and defining Various Joins in the Physical Layer and BMM Layer.
• Upgraded the OBIEE 10g repository and catalog to 11g.
• Configured weblogic console to authenticate OBIEE with MS Active Directory.
• Installed and configured Oracle HTTP Server as web server in front of weblogic server.
• Applied the patch sets 11.1.1.6.4 and 11.1.16.8 to fix the product bugs.
• Upgraded the OBIEE from 11.1.1.5.0 to 11.1.1.7.0
• Configured the usage tracking.
• Created ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Created ODI Sunopsis interfaces for loading the data from Sybase to CDW and from CDW to different Marts.
• Did SQL and PL/SQL programming for ODI and oracle.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Implemented Row level Security, Column level Security, Object level security and Subject Areas Security for Users, Application Roles, Reports, Dashboards.
• Tuned the OBIEE 11g components to increase the performance.
• Implemented Dimension Hierarchies which includes Level based hierarchies Ragged, Skipped Value Based Hierarchy Parent-Child to meet business requirements.
• Worked closely with Business Analyst in understanding the requirements and created the business model for generating reports as per the user requirements.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns.
• Improved the login time by deferred execution of the Initialization Blocks.
• Created the new RPD and detail level drill downs to as per business requirements using OBEE Analysis.
• Involved with ETL team in Creating, Running Monitoring ETL loads including Incremental and Full loads using DAC.
• Involved in Detail Analysis Validation of the Fact Dimension tables, which were used for Reporting Purposes in the Out Of the Box.
• Worked on the different layers in the data model Physical, Business and Presentation .
• Created Session variable, Repository variable in RPD and used the same for role based security in OBIEE.
• Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
• Created new logical columns by using the Time series functions as per specifications.
• Created different reports by using Table, Pivot Table, Chart, Narrative Views etc.
• Designed Dashboards as per specifications.
• Built Time-Series calculations using AGO and TODATE functions on BMM Business mapping and modeling layer of repository.
• Involved in meetings with the Modelers to establish star schema using 1NF, 2NF, 3NF .
• Configured Scheduler, Delivers and Cache Seeding by using IBots.
• Installed and configured BI Publisher and Integrated with OBIEE server.
• Integrated MS Word, BI Publisher and OBIEE to publish the reports in different formats.
• Created RTF templates in MS Word by connecting to BI Publisher, and publish these templates for the reports to view data in BI Publisher.
• Responsible for managing the entire Dare Warehouse.
• Involved in applying best practice and Performance tuning the mappings by using SQL Override, session override, Lookups, Caching, many more.
• Involved in writing complex SQL queries in Toad for Data Analysis Validation.
• Migrated Catalog's and RPD's from different environments by using Catalog Manager.
• Involving in Unit Testing, Validating Reports and production support.

Environment: OBIEE 11.1.1.7.0/11.1.15.0, Oracle 11g, BI Publisher, TOAD, Oracle Data Integrator 11.1.1.6, DAC 10.1.3.4.Sql plus, PL/SQL.

Confidential

OBIEE Developer

Responsibilities:

• Connected with the Business Analysis, Functional design, Gap Analysis, Technical design, Development, Deployment and Testing and also in creating Traceability Matrices for the project.
• Creating Subject Areas for Logical Stars and Snowflakes.
• Involved In performing full load using Informatica 9.0.1 DAC 10.1.3.4 and loading the Sales Financial Analytics data into Repository for the purpose of designing and developing of reports dashboards.
• Extensively Implemented Configured MUDE environment to be able to work on different Projects and merging changes to the Master Rpd.
• Builded proactive agents and interactive Dashboards to alert the Sales team about incoming changes in reports.
• Designed and Tested Reports in the Dashboards for the Oracle Sales Analytics Financial Analytics modules and created the Ad-hoc report according to the Business needs.
• Worked on Financial Analytics Modules such as General Ledger, Profitability, Account Payables and Receivables. The Reports were made to analyze the past year's financials data to help grow the company revenue Increase profitability. The reports displayed the key Areas of Performance including the Balance sheet, Cash flow, Liquidity, GL Balance.
• Worked on HR Analytics Modules such as Absence, Compensation, Human Resource Performance, Work Force Development, Recruitment. The Reports Dashboards' were built to provide strategic workforce Performance Information and to determine key factors that drive Employment Productivity.
• Customized, Configured and Created the OBIEE Repository physical, BMM, and presentation layers .
• Built Business Model and established relationships Foreign Keys Physical Logical between tables.
• Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, and Oracle materialized views and making changes to reports.
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Worked Extensively on OBI Applications including Sales Analytics Financial Analytics to generate reports and identify any incoming changes.
• Managed security privileges for each subject area and dashboards according to user requirement.
• Performed Full and Incremental loads through DAC on different environments.
• Involved in Migration of Repository from Test Environment to Production Environment.
• Developed custom reports/Ad-hoc queries using Obiee Answers and assigned them to application specific dashboards.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Developed different kinds of Reports Pivots, Graphs, Tabular using global and local Filters.
• Worked on repository and session variables.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Configuring Agents and Delivers.
• Applied Optimization Techniques for the better performance of the reports.
• Extensively used SQL Tuning to improve performance.
• Created different types of Customized Reports Drilldown, Aggregation, Ragged to meet client requirements.
• Upgraded OBIEE 10g to 11g.
• Created Highly formatted pre- built reports with BI - Publisher.
• Extensively worked in Configuring fine-tuning the Out of the Box Informatica Mappings.
• Involved in Data Analysis Testing of few Out of the Box Mappings and built a Technical Design Document to Address the issues and rectify them.
• Followed a good change management process by addressing the Issue from the source itself and move forward.
• Involved modifying few Pre- Built Fact tables Dimension tables according to the Business Needs
• Implemented Slowly Changing Dimensions Type 2 to create new Fact's Dimension's.
• Created Custom Mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target tables.

Environment: OBIEE 11.1.1.3/10.1.3.4, Oracle 11g, OBIA 7.9.6.3 , Informatica Power Center 9.0.1, DAC 10.1.3.4 , E Business Suite 12.2 , Sybase V6.0 , TOAD, Teradata, Erwin, Rapid Sql, Sql plus, PL/SQL.

Confidential

OBIEE Developer

Responsibilities:

• Associated with in the Analysis, functional and technical specifications, development, deployment and testing of the project.
• Implemented Security by creating users, groups throughexternal table authentication.
• Gathered business needs by Interacting with the business users for analytical data requirements.
• Build prototype reports from excel spreadsheet during the requirement phase to visualize the reports and clarify requirements.
• Requirement validation of the reports and drilldowns.
• Designed repository based on business requirements, followed design best practices for the RPD and Dashboard designs.
• Involved in Importing the Essbase 9 Cubes into the Physical layer of Admin tool and Building reports in Answers which supported multidimensional Data source in a repository.
• Performed full Loads with the help of DAC and Monitoring the Same.
• Worked on the design of logical data model.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• The main Modules I worked on are General Ledger and Account Payables. The reports dashboard that were build contained detailed information on Company's Financial Structure , GL balance, Liquidity and Balance Sheet. These reports were build to analyze the Key Areas of Performance.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Concerned on repository and session variables.
• Created materialized views and aggregates to improve performance.
• Customized Claims, Holdings and Service requests star schemas.
• Generated Reports and Dashboards by using Report features like Pivot tables,chartsand view selector.
• Associated with Building reports and Dashboards using out of box OBIA in which PeopleSoft was the primary Source.
• Fabricated proactive agents iBots and interactive Dashboards to alert the financial team about business changes.
• Scheduled the reports in Oracle BI Publisher Enterprise.
• Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, Oracle materialized views and making changes to reports.
• Communicated project status and escalated issues as needed.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Designed and developed Informatica mappings for data loads.
• Involved in designing the ETL loads, developed and implemented ETL process for executive management reporting.

Environment: OBIEE 10.1.3.2, Oracle BI Publisher, Oracle 10g, Oracle Apps 7.9.6.1, DAC 10.1.3.4 , Oracle E Business Suite 11.X , Essbase 9, Informatica Power Center 7.1.3, TOAD, Sql Plus, PL/SQL.

Confidential

OBIEE Consultant

Responsibilities:

• Concerned in business meetings and working closely with the business analysts to gather user requirements and did thorough Data Analysis. Based on the requirements identified the scope of new data, confirming dimensions between new and existing Warehouse tables, Drill Downs and data security and developed the business requirement document.
• Worked on deployment of different OBIEE builds on LINUXProduction Server.
• Developed new dimensions, facts and aggregate tables. Worked on Physical, BMM and Presentation layer of the Oracle Business Intelligence Admin tool to create the physical and business model diagram and the logical hierarchies.
• Identified granularity level of the data required for analysis that exactly meets the user reporting requirements.
• Building interactive and selective data reports pivots, charts, tabular using concepts such as filters, column selectors, global prompts and extensively used repository and presentation variables.
• Generated logical tables and defined the complex joins for a business model.
• Responsible in creating Alias and configured repository with logical dimensional modeling using star schema.
• Performed Consistency Check and Global Consistency Check of the Business Model before exposing Business Models in the Presentation Layer considering errors, warnings and best practices.
• Developed custom reports/Ad-hoc queries using OBIEE and assigned them to application specific dashboards.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance using the Security settings in Oracle Business Intelligence Administration Tool.
• Created dimensional hierarchy and used shared child level when creating the sub level hierarchies.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Responsible for migrating the web catalog and RPD from DEV and PROD environments.
• Worked extensively on OBIEE Answers to create the reports as per the client requirements and was also solely involved in delivering write back functionality.
• Environment:Oracle 10g, Teradata,Informatica 8.1.1,Informatica 7.x Informatica Server, Informatica Repository Server, Repository Manager, Designer, Workflow Manager, and Workflow Monitor , OBIEE 10.1.3.2, BI Publisher,
• Toad, SQL, SQL Loader, PL/SQL Procedures, Windows 2000, UNIX, Shell Scripts.

Confidential

ETL Developer

Responsibilities:

• SDLC experience which involved the phases of Analysis, User requirement gathering, development of System Requirement specifications and detailed design document.
• Extensively involved in the requirement analysis, development, writing test cases and unit testing.
• Used Designer to create source definitions, target definitions, reusable transformations and mappings.
• Worked on transformations like Source Qualifier, Lookup, Aggregator, Joiner, Filter, expression, Router, Sequence generator and Rank.
• Created and extensively worked on tables, views, indexes, triggers, functions, user roles, regular backups and monitored the performance.
• Planning and designing the system, writing queries in SQL and PL/SQL.
• Understand current PL/SQL code and make changes to existing PL/SQL to incorporate maintenance requests.
• Used UNIX shell scripts for running the informatica session.
• Involved in Data loading to oracle based tables and extracting functions using SQL Loader.
• Writing, editing and maintaining database objects using SQL Navigator.
• Analyzed user requirements, developed user interactive screens using Oracle Forms.
• Involved directly with end users in requirements gathering stage.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Interacted with business user in getting the change of request and the implementation.
• Designed and developed various mappings in Informatica to load the data from Source to Target.
• Extensively worked in the performance tuning the programs, ETL procedures and processes.

Environment:Oracle 8i,SQLServer,PL/SQL,SQL Loader,SQLNavigator,InformaticaPowerCenter7.1, UNIX, ShellScripts.