Summary

• Highly accomplished and solutions oriented IT Professional with broad based knowledge in Systems Design and Development, implementing and integrating cost-effective, high performance technical solutions to meet challenging business needs.
• Excel in strategic planning, project management, implementing best practice methodologies and consistently improving delivery times and service levels while reducing costs.
• 8 years of experience in Oracle Business Intelligence Enterprise Edition OBIEE 10G/11G , Oracle 11g, Informatica 8.6.1/9.5.1 and Data warehousing BI ,OBIA.
• Worked extensively on OBIEE/Siebel Analytics Administration Tool involving all the 3 layers namely Physical Layer, BMM Layer and Presentation Layer.
• Extensive experience in OBIEE/ Siebel Analytics Presentation Services and BI Publisher
• Extensive experience in OBIEE security models implementation and OBIEE Environment administration MUD creation, configuration and Support .
• Reporting solution design and OBIEE customizations to meet end users reporting requirements.
• Excellent aptitude in translating high-level business requirements into logical business dimensional model, building business models, configuring metadata, Answers, Delivers / iBots, creating reports / Dashboards, cache monitor.
• Expertise in Business Model development with various functionalities like Dimensional Hierarchies, Measures, Aggregation Rules, Time Series and other functions.
• Skilled with Caching Mapping, data- level and object-level security, MUD, Integration Variables/Initialization Blocks configuration.
• Skilled expertise in creating reporting using BI Publisher from OLTP and OLAP .
• Highly skilled in building Interactive Dashboards with drill-down drill-across capabilities using global local Filters, Business Rules with User Identity Roles, Profiles Personalization
• Knowledge of implementing the Oracle BI / Siebel Security Setup groups, data access/query privileges , Metadata Objects Subject Area, Table, and Column and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Debugging, Optimizing and Performance Tuning of OBI Siebel Analytical Dashboards / Reports to improve performance at Database.
• Proficient in working on production and development environment in different RDBMS in Oracle 10g/11g .
• Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data
• Skilled in the ETL transformations using the tool Informatica
• Created mapping using the various transformations and triggered the mapping based on Oracle DAC
• Very good experience in Onsite offshore development model.

Technical Skills:

BI Product Experience: OBIEE 10.1.3.2/ 10.1.3.3/ 10.1.3.4/ 10.1.3.4.1,

OBIEE 11.1.1.7.0/11.1.1.7.140114

ETL Product Experience: Informatica 8.6.1, Informatica 9.01,Informatica 9.5.1

Database Administration Console: 10.1.3.4.1, 11G

Database Experience: Oracle 7/8/9i/10g/11g, SQL Server 7/2000/2005

Database Tools: Oracle SQL Developer, Toad

Documentation Tools : MS Office

Professional Experience:

1.Role : Tech Lead OBIEE/Informatica

Confidential

Description

The Southern Company is an American electric utility holding company based in the southern United States. It is headquartered in Atlanta, Georgia with executive offices also located in Birmingham, Alabama. The company is currently the 16th largest utility company in the world and the fourth largest in the U.S.

Roles and Responsibilities

• Direct interaction with the end users and business users for requirement gathering and providing delivarables.
• Upgraded the Environment from Informatica 8.1 to 9.5 along with OBIEE and BI Publisher to 11.1.1.7.0
• Fixed all the bugs and issues related to the upgrade project and improved the performance of the Informatica Mappings
• Created new data models for creation of reports from OBIEE and BI Publisher
• Created transactional and analytical reporting from BI publisher using OLTP and OLAP as source
• Managed reports, folders and data sources setup in BI Publisher. Defined data model for BI answers request data set type.
• Installed, configured BI Publisher to integrate with BI presentation services and performed security model integration with LDAP Authentication.
• Managed the MUD multiuser development environment for the project
• Integrate BI Publisher in Windows Office.
• Created user level security for intelligence dashboards based on Business Requirement.
• Designed and implemented Physical and Logical Star Schemas/Diagrams using Fact, Dimension, Alias and Extension tables as well as Foreign and Complex joins.
• Implemented and introduced the Answers capability of OBIEE to the users.
• Created dimensional hierarchies, assigned levels and custom aggregation rules for each level, and configured cross-dimensional drill downs to get more detailed views of the data.
• Implemented security by creating roles web groups, checks with External tables and Object Level Security.
• Created mock reports and dashboards for review by the business users
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Created mappings using various transformations in Power Center and invoked data from different sources.
• Created multiple management level reports with various drill down and navigation capabilities for providing proper insight for the business users to take proper decisions

Environment: OBIEE 11.1.7.0, OBIEE 10.1.3.4.1, BI Publisher 11.1.7.0, Oracle, DB2, Informatica 8.1,Informatica 9.5,Autosys , SQL Server 2005, SQL, SQL Plus, TOAD, Redhat Linux

2. Role: Senior OBIEE Consultant

Confidential

Description:

Move, Inc is a real estate website, which operates the Move Network of real estate web site for consumers and real estate. The headquarters for Move, Inc. is in Campbell, CA.

The project R4 Bethany was to be implemented with OBIEE reports basically on reports based on the Commissions for the Agents, Revenue and Finance modules based on the business requirements and later being a part of the Informatica ETL Transformations for the processing of data from the Legacy systems.

Responsibilities:

• Gathered and analyzed requirements from the business users and translated the business requirements into conceptual and detailed technical design.
• Performed Installation and Configuration of OBIEE Server including additional OBI components.
• Designed and developed OBIEE Metadata repository .rpd that consisted of Physical layer, business model and Mapping layer Aggregates, Dimensions and time Series functions and presentation Layer.
• Designed and implemented Physical and Logical Star Schemas/Diagrams using Fact, Dimension, Alias and Extension tables as well as Foreign and Complex joins.
• Created numerous executive level reports and Dashboards to provide insight into the HR reporting
• Developed many Reports using different Views Pivot Table, Chart, and Column Selector , Interactive Dashboards with drill-down capabilities, charts, tabular using Dashboard and Page Prompts.
• Extensively used Delivers and iBots for delivering personalized reports to users, the management and sales teams as per the business requirements.
• Worked extensively with dashboard prompts to filter dashboards and populate variables.
• Implemented and introduced the Answers capability of OBIEE to the users.
• Created dimensional hierarchies, assigned levels and custom aggregation rules for each level, and configured cross-dimensional drill downs to get more detailed views of the data.
• Implemented security by creating users web groups, setting up External Table, creating session variables and initialization blocks and associating catalog objects and Web modules with the created groups.
• Creation of BI Publisher reporting for Customer Statement using data model directly as SQL as well as from Subject area created in Warehouse
• Invoked LDAP security model in BI Publisher for object level security.
• Integrated different Microsoft Office Tools with BI Publisher and customized different templates and invoked data from the sources to meet business requirements.
• Created comprehensive and easy-to-understand Oracle Answers Dashboards User Guide, and provided intensive Training to business users.
• Configured Row Level Security and Object level security to allow users to view their respective data only according to the requirement.
• Developed Informatica Mapping using the Informatica PowerCenter for the ETL transformation from the Legacy system to the OLAP Data Warehouse.
• Triggered Informatica Mappings using DAC for the Full Load and Incremental Load processes
• Performed Regression testing for the reports generated in the earlier phases.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.
• Implemented OBIA-Sales out of the box, customized and configured rpd and answers to meet business needs and requirements.
• Upgraded OBIEE from 10.1.1.3.4.1 to 11.1.1.7.1 and fixed all the issues at the time of upgrade
• Upgraded Informatica 8.6.1 to 9.01 and ensured and rectified all the issue to run mapping and workflows
• Set up LDAP Security system and remodeled the Security system based on Application Roles and Groups.

Environment: OBIEE 11.1.7.0, OBIEE 10.1.3.4.1,OBIA 7.9.6.3,BI Publisher 11.1.7.0 Oracle, Informatica 8.6.1, Informatica 9.01,DAC 10.1.3.4.1,DAC 11G, SQL Server 2005, SQL, SQL Plus, TOAD, Windows 2003/ XP,AIX.

3. Role: Sr. OBIEE Developer/Lead

Confidential

Excellus BlueCross BlueShield is a non-profit health insurance company headquartered in Rochester, New York. It is part of the Blue Cross Blue Shield Association. Excellus BCBS is upstate New York's largest nonprofit health plan

OBIEE Sales/Service Analytics implementation at Excellus BCBS includes Groups, iFacets Group, Parent Group, Sub Group, CTA Group, Member Firm, Brokers and Activities information designed to provide a best BI application for their Business needs. The goal of this project is to deliver a Customer Relationship Management CRM solution to their Activities of all Group Types, iFacets Manual Process Interaction between Facets System and Siebel Application , iFacets Pre-process and iFacets Post-Process.

Sales/Service Analytics would bring the data from Sales Marketing OLTP application using Informatica and DAC. Build/Customize Reports, Metadata, ETL, DAC and Database objects to include Siebel with Analytics as the single solution that supports the Activities for the different Group Types. ETL Mappings and reports are customized and build in custom dashboard.

Responsibilities:

• Requirements gathering from users through meetings, understanding the business model and end
• Worked with Business user in Understanding the OBIEE reporting needs from target user groups.
• Involved in the design of Analytics repository from the Physical layer to the Presentation layer and defining the responsibilities for various users and groups based on position.
• Configured Dimension tables in Business layer for Drill down functionality.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Created dimension hierarchies, levels, level based measures and defined logical levels and keys.
• Implemented the security in OBIEE Admin tool to set up users, groups and access privileges.
• Used the expression builder utility for the new logical columns in the BMM layer and created various calculation measures.
• Created Sales Dashboards for different positions Hierarchy in different Business Units.
• Extensively worked on Data analysis of various data marts and source systems like Oracle ERP Application.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector
• Implemented the Customer Product Dimensions and their hierarchies.
• Created user level security for intelligence dashboards based on Business Requirement.
• Implemented security by creating roles web groups, checks with External tables and Object Level Security.
• Created mock reports and dashboards for review by the business users
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Modified existing reports and created new reports from Siebel Data as source and Siebel DW tables as per the business requirements.
• Extensive Performance tuning in OBIEE by implementing aggregate navigation and cache management techniques
• Involved in Creating the required mappings using Informatica PowerCenter Designer and created the tasks for the mappings developed through Informatica PowerCenter
• Developed standard mapping using various transformations like expression, aggregator, joiner, source qualifier and router
• Upgraded the OBIEE 10G to 11G and implemented the new roles and policies based on the security realms of 11g
• Resolved all the issues in the RPD and the Answers during the time of up gradation.
• Good experience in communicating with offshore team
• Extensively performed data validations and created mapping document from source to target
• Involved in testing/validating and debugging the applications using SQL scripts and appropriate log files.
• Designed, implemented and tested Informatica mappings from scratch as a part of new approach to load data warehouse with required data according to business requirements.
• Configured Informatica mappings to run in full load mode as well as incremental mode using DAC.
• Adapted the system to ensure that that the same mappings can be used to load all data from the source system full as well as only incremental load that will fetch only update data from source system.
• Identified reusable parts of code inside Informatica mappings and created reusable mapplets, sessions, transformations that can be used in multiple areas.
• Validated ETL errors due to data gaps in source system and customized the ETL mappings to fix the data load issues.
• Coordinating offshore team during build, data loads and UAT phases
• Migrated Informatica, DAC, RPD and Web Catalog objects from Dev environment to QA environment and to the Production environment.
• Involved in installation of Software and configuring of Informatica, DAC and OBIEE in environments like Development, QA and Production instances.
• Integrated dependencies between data load tasks to ensure that tasks run in the order required fetch source data first, do the required transformations and then finally load into warehouse

Environment: OBIEE 10.1.3.4.1/Siebel Analytics, OBIEE 11.1.1.6.1,Oracle, Informatica 8.6.1,9.01, SQL Server 2005, SQL, SQL Plus, TOAD, Windows 2003/ XP,AIX.

4. Role: Senior OBIEE Developer

Confidential

Description:

Victaulic is a developer and producer of mechanical pipe joining systems and is the originator of the grooved coupling pipe joining system. Victaulic specializes in the development of coupling, valve, and fitting technologies for Heavy Industrial Industries such as Oil Gas, Mining, Maritime, Power, Clean Water. Victaulic also designs couplings, valves, fittings, and sprinkler system technologies for HVAC, Plumbing, Fire Protection in Commercial structures.

This project was basically focused on the Finance Section and to create Dashboards and reports out of OBIEE based on the detailed analysis of the revenue profit and forecasting the sales based on the OLAP data which is provided based on the ETL process using Informatica.

Responsibilities:

• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business model and mapping and presentation layers of metadata repository.
• Created and modified repository file and modeled data in physical and BMM layer using physical and complex joins.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed Business models to represent business logic for Service and created logical tables and defined the complex joins for a business model.
• Involved in Understanding the user requirement and developing the Technical documentation.
• Extensively involved in review of the Design documents with the peers at different levels
• Involved in resolving the UI layer formatting issues at OBIEE Answers level.
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.
• Responsible for the administration and migration of user reports or repositories between various environments
• Extensively worked with Administration team to resolve the issues happened while migration to different environments.
• Involved in Modifying the existed Fact tables and Dimension tables in the Business Model and Mapping Layer as per the requirement changed.
• Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
• Involved in Modifying the Columns at BMM and Presentation layers by using existing joins.
• Involved in modifying the calculations at Answers level based on the requirement changes.
• Involved in unit testing the reports .
• Extensively worked on the defect fixing, Technical document changes and migration process.
• Updating the status sheets on regular basis to know the status of the objects.
• Involved in MOM preparation
• Worked as a onsite offshore coordinator
• 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: OBIEE 10.1.3.4.1, Oracle 10g, Informatica, Toad, Siebel CRM, DAC 10.1.3.4.1.

5.Role: OBIEE RPD Developer

Confidential

Project Responsibilities:

• Involved to develop the OBIEE OLTP reporting solution for a public sector Judiciary client- Abu Dhabi, in an End to End OBIEE Development.
• Capture the new reporting requirements from business analysts and end users.
• Collaborated with the business representatives and existing model's development team in
• Understanding the complexities of the requirement.
• Perform GAP Analysis to implement the customization.
• Involved in meetings business representatives for requirement analysis and to define
• Prepared the Project Charter/Design Document for this OBIEE Development
• Created new ETL mappings to load data from multiple sources.
• Modeled BI Repository to create new Subject Areas and Star Schemas.
• Created suitable aggregation tables to capture the various aggregations at different levels.
• Suggested Migration strategies to Business to improvise existing strategies as per the BI best practices.
• Managed reports, folders and data sources setup in BI Publisher. Defined data model for BI answers request data set type.
• Installed, configured BI Publisher to integrate with BI presentation services and performed security model integration with LDAP Authentication.
• Configured OBIA in Public sector and performed and managed reports and customized based on user needs using out of the box subject areas .
• Managed the MUD multiuser development environment for the project
• Integrate BI Publisher in Windows Office.
• Configured DAC and Informatica to implement the Change Data Capture mechanism capture incremental data.
• Analyzed the out of the box ETL mappings SIL's and SDE's and their dependencies
• Implemented Data Level Security and Object Level Security for the new reporting needs.
• Configured BI to authenticate using LDAP.
• Customized DAC Tasks as per Customized Informatica mappings.
• Modify OBIEE RPD to model the new changes and create reports accordingly.
• Managed the onshore and offshore deliverables and maintained a highly organized and
• Streamlined environment.

Environment: OBIEE 10.1.3.4.1, Oracle 10g, Informatica 8.6.1,OBIA 7.9.6.2

5.Role: Jr Developer/System Analyst Confidential

ING's businesses offer individual, business and institutional customers innovative financial products and services in insurance, investment, asset management and Internet banking. This Project mainly deals with worker compensation insurance used by the corporate companies. Scope of the project was to maintained different kinds of accounts with their premium, claims, and new accounts. Had two databases one for the Production and the other was a reporting environment for which was maintained in Data mart.

Responsibilities:

• Involved in requirement gathering, analysis, design, development, change management, deployment and user training
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Migrated data from Heterogeneous Data Sources and legacy system DB2, Access, Excel to SQL Server databases using SQL Server Integration Services SSIS to overcome transformation constraints.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Worked with Flat Files Data source connections, ODBC data source connections to SQL server sources and DB2 data source connections.
• Creating Reports using SSRS tool and ad-hoc report request for end users.
• Created external tables for loading data from flat files using Oracle Loader.
• Created DTS packages for loading data from oracle tables to SQL Server.
• Created automated packages for daily, weekly monthly backups.
• Involved in developing Complex SQL code for developing various kinds of adhoc reports.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables

Environment: SQL Server2005, DTS, Windows 2003 Server.