8 years of IT experience, with 6 yrs. focused on Data warehouse and OBIEE reporting development life cycle involving Requirement Analysis, Design, Coding, Testing and Deployment. Deep expertise in Business Intelligence and ETL technologies. I am self-motivated, team player, intend to make a career in an esteemed organization giving ample scope for professional growth.

Major Strengths:-

• Experience in OBIA Architecture and in depth experience in OBIA suite Oracle Database, ODI and OBIEE . Experience in Implementing Oracle BI Apps OBIA HR, Financial and Procurement Spend Analytics. Expert in Oracle BI Server, Oracle BI Answers, Oracle BI Interactive Dashboard, Oracle BI Publisher, Oracle BI Delivers and OBIEE performance tuning of BI Applications 7.9.6.
• Extensive experience in providing end-to-end business intelligence solution by configuring metadata and building OBIEE Repository .rpd consisting of three layers Physical Layer, Business Model Presentation Layer using of Hierarchies, Aggregates, Partition Fragments, Time Series functions, Level based measures and Cache mechanisms.
• Excellent in developing OBIEE Reports and Interactive Dashboards with drill-down capabilities using global and local Filters, Security Setup groups, access/ query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Analysis .
• Extensive Data Warehousing experience with the Integration of various data sources like Oracle11g/10g/9i, MS SQL Server, DB2, Teradata, VSAM files, XML files and Flat Files into the staging area, ODS, Data Warehouse and Data Marts.
• Extensively designed and developed ETL mappings with various transformations in Informatica Power Center 9.01. Creating Workflows with Work lets Tasks and scheduling using both Workflow Manager and DAC. Extensively used DAC to Configure, Monitor and Schedule ETL routines of Full and Incremental ETL loads of the OBIA.
• Experience in OLTP / OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling including OLAP Cube. Extensive experience with Fact, Dimension tables, slowly changing dimensions, Physical and Logical Data Modeling. Experience in working with Erwin tool.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, and Packages. Experience in writing UNIX shell Scripts and automation of ETL process using scheduling tools like AUTOSYS. Experience in performance tuning of mapping and sessions.

• Experience in various Solution Areas, such as Customer Relationship Management CRM , Supply Chain Management, Financial Services, and Sales Revenue Management.
• Created strategic and innovative Reporting Templates, utilizing Key Performance Indicators KPIs and business performance Metrics.

• Worked with Oracle BI Marketing Analytics and GL Analytics.
• Sourcing and presenting data from Oracle E-Business Suite and another large ERP environment.

Project: 1

Confidential

Sr. OBIEE Developer

Responsibilities:

• Analyzed the business requirements and understand the Dimensional data model in the data warehouse designed based on mixed Star Schema. Identified Facts, Dimensions and defined the keys, relationship among the tables and prepared the design document.
• Extracted and customized the pre-built BI solutions of tables using Oracle BI Apps 7.9.6 HR Financial Analytics . Worked on repository development, configured metadata objects Subject Area, Table and Column and web catalog objects Dashboards, Filters, Prompts, Reports .
• Import the Meta data RPD of HR and Financial BI Apps into OBIEE11g Development Environment and creating the aliases to establish the joins and developed Oracle Out of box BI Apps solutions and done customizations according to the requirements.
• Configured Physical Layer - Import tables, Create Tables, add / change physical joins / keys. Setup the Cache settings for various tables and import the event polling table. Configured the separate connection pools for session variables, Aggregate tables.
• Configured Logical Layer - Create Logical Facts / Dimensions, columns, Create Logical Joins/keys, Set levels to support Drill-down, Aggregation / Sum over Columns. Added new Calculations to the Fact tables and defined new Hierarchies to the dimensions.
• Configured Presentation Layer - Create Folders / sub-folders, Standard Queries for different User Groups. Setup the implicit columns for dimension only queries. Setup the permissions for objects like subject area, table, and column and specify the access type.
• Developed Analyses and Dashboards with different Analytics Views including Pivot Table, Graphs, Gauges, Column Selector and View Selector with global and local Filters Defined new prompts, filters and variables and customizing the existing objects.
• Implemented the delivery of BI-Agents using OBI Delivers to alert the associated teams. Implemented Object level security and data level security by setting the permissions in OBIEE Administration Tool and Analytics Page. Verified the Permissions of the users in OBIEE web.
• Develop Test Plan including test scripts for Unit, Integration, and User Acceptance Testing including resolution of bugs.
• Provided guidance and support to end users during the implementation in production.

Environment: OBIA 7.9.6, ODI 11g, OBIEE 11g, Oracle11g, SQL, SQL Developer, Erwin, UNIX

Project: 2

Confidential

Sr. OBIEE Lead Developer

Responsibilities:

• Being as a team player, analyzed the Reporting Requirements and designed and developed the Application Design and Test cases Document.
• Developed Oracle BI Metadata repository using BI Administration tool by importing data from various OLTP sources, Flat files.
• Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model mapping layer.
• Developed measure for Time comparison using Time functions, To Date and Ago.
• Developed Analysis and Dashboards with different Analytics Views including Pivot Table, Graphs, Gauges, Column Selector and View Selector with global and local Filters using Oracle BI Presentation Services.
• Developed Analysis and Dashboard prompts with Inline and saved type and controlled the dashboard pages with 'Is Prompted' Option.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA.
• Configured BI Scheduler and Oracle BI Delivers- Agents to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
• Developed test cases and performed Unit testing, Integration testing of the repository and web catalogs generated by OBIEE and reports by BI Publisher.

Environment: OBIEE 11g, BI Publisher, Oracle11g, SQL, SQL Developer, LINUX

Project: 3

Confidential

Sr. OBIEE Developer

Responsibilities:

• Requirements Gathering to implement Oracle Business Intelligence 10.1.3.2.
• Installation and configuration of Oracle business intelligence Enterprise Edition 10.1.3.2.
• Understanding the Healthcare services business process for building business Intelligence.
• Understanding the source systems and the data being populated in the source systems.
• Decision making on filters to be used to restrict source data.
• Understanding the Oracle custom Data warehouse model.
• Preparing technical specifications for the Custom Oracle Business Intelligence purchased by the client.
• Decision making on how to customize the necessary reports picked by the client.
• Preparing specification documents with formulas involved in the business model layer.
• Doing data validations in the front end reports, applying filters and checking for data accuracy in the customized reports.
• Checking the data values in the reports compared to the values in the database.
• Preparing dashboards, answers with restrictive filter conditions.
• Obtaining access to analytics application used in various environments.
• Configuring the odbc setup in Oracle Business Intelligence to communicate with the underlying database.
• Checking for OBIEE services as and when required.

Environment: Oracle business Intelligence enterprise edition tool 10.1.3.2 OBIEE , Oracle 11g database, Oracle 9 Database, SQL, TOAD, Windows XP and Microsoft tools.

Project: 4

Confidential

OBIEE Architect/TEAM Lead

Responsibilities:

• Was assigned to get familiar with the Business Requirements statement BRS document, System Requirement specification SRS document and Solution design document SDD .
• Installation and Requirement Gathering Analysis.
• Installed and configured the OBIEE 10.1.3.2 server and dealt with the installation issues.
• Participated in the Business requirements gathering meetings with the end users/business people.
• Involved in Siebel Analytics gap analysis related to SRMW Data Model and ETL, creation of detailed design documentation, accurately mapping requirements into Siebel Analytics functionality
• Responsible for preparing the Technical Design document keeping in view the end user requirements.
• Design and Developed Logical and Physical Data Model and ETL process mapping configuration.
• Configured the three layers in the OBIEE repository using the Administration tool.
• Involved in Usage tracking and scheduler implementation
• Configured Oracle BI scheduler in an application and server that manages and schedules the job
• Configured Proxy Users.
• Involved in Data level and object level security model in OBI presentation catalog to view there report according to the user level/position and permission.

• Preparation of test cases for the existing DHL application.
• Implementation of unit testing on the DHL application in phases of rounds I II.
• Testing one of the key subject areas in the DHL analytics application called the Revenue subject Area.
• Revenue subject area testing included cross checking whether all metrics are available in repository or not, checking for the joins in subject area whether they are matching with the joins mentioned in Solution Design document.
• Daily iBots Status checking for the iBots scheduled by users.
• Above testing also included checking for any errors when executing all the columns.
• Doing unit testing on the Global Score Card GSS dashboard by adding a comparison of the global score card content in the application with the values in the underlying database.
• Have been assigned to do unit testing on Metrics.
• I was assigned to do security set up for OBIEE.
• Obtaining access to the analytics application, remote servers and Teradata database.
• Authenticating the shipping metrics with account and customer dimensions.
• Authenticating the billing metrics with account and customer dimensions.
• Identifying the location of reports in the application, Identifying dimensions and fact entities.
• Checking various other entities and their values in the answers of the application versus the database.
• Checking for the OBIEE services as and when needed.
• Following up on getting correct privileges to access various server machines.
• Thorough revision of the repository RPD before getting it in online mode.

Informatica ETL Process:

• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Identified and documented all gap and restrictions make sound technical and tactical recommendation.
• Identified Facts, Dimensions, and Hierarchies of the business model.
• Identified the granularity level of the business model based on the end user requirements.
• Developed Informatica mappings and defined transformation code rules.
• Involved extracting data and transforming the data before loading the data into target warehouse Oracle tables
• Responsible to tune ETL procedures and STAR schemas to optimize load and query performance.
• Extensively worked on different transformations via Source Qualifier, Expression Filter, Lookup, Update Strategy, Stored Procedure, Sequence Generator, Joiner, Router, Aggregator Transformation and SQL override.

Environment: Oracle business Intelligence enterprise edition tool OBIEE , Teradata database, Informatica Power Center, Accessing various remote server machines, SQL, Windows XP and Microsoft tools.

Project: 5

Confidential

OBIEE/SIEBEL Consultant

Responsibilities:

• Understanding what are the basic reporting needs of GWIM division of Bank of America.
• Understanding what are the different Bank of America GWIM applications, which need Business Intelligence.
• Presented the client a bigger picture in terms of GWIM Enterprise wide business Intelligence.
• Pro-actively given client presentations on GWIM Enterprise wide Business Intelligence in phases starting with one Line of business LOB and then building on it to add other Line of businesses LOB's .
• Given a generic framework which will fit for all Line of businesses LOB .
• Initiated and converted the Client presentations into Individual Proof of Concept POC phases. This way every Line of business got a feel for Oracle Business Intelligence capabilities. POC replicated MAAP and Maestro applications.
• Worked closely with Business Analyst in understanding the analytics requirements and creating the business models for generating reports as per the requirements.
• Worked closely with the data modeler in designing the logical data model/physical data model star schema .
• Prepared the ETL Mapping spreadsheet and Fact Dimension Matrix simultaneously prior to performing the ETL process.
• Experience in DTS for Scheduling jobs, data mappings and creating users.
• Experience in Proxy tools for creating users and giving access to all environment.
• Assisted the ETL team in regards to schema and data model design Configured Implemented Siebel Analytics:
• Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Siebel Analytics Repository using Siebel Analytics Administration Tool.
• Client wanted me to exhibit Oracle Business Intelligence on some more additional requirements as part of POC phase. These additional business requirements required understanding of Functional concepts. Hence system appreciation document, Functional design document and technical design document had to be prepared.
• Some challenges to address: BOFA business requirements were changing over the time and so as the BOFA applications. So a release strategy is bought into place to release the changing requirements into code in periodic phases.
• Another challenge to address was There were no edited documents on any BOFA GWIM applications .
• Interpreted entities in a business language ranging from attributes to the reports level.
• Set up and documented Oracle Business Intelligence Infrastructure at client place.
• Propose any short comings of Oracle Business Intelligence in developing Bank of America GWIM applications. Participate in solutions review meetings on how these short comings can be addressed.
• Vigorous client interactions, business meetings, co-coordinated with business and various strategic teams, giving client business training on Oracle Business Intelligence were some strategic assignments what I was doing.
• Implemented the delivery of iBots using Siebel Delivers to alert the associated teams.

Environment: Oracle business Intelligence enterprise edition tool OBIEE , Netezza database, Oracle 10g database, SQL server 2005 database, Computer networking, DTS, T-SQL, Windows XP and Microsoft tools.

Project: 6

Confidential

SIEBEL Developer

Responsibilities:

• Analyzed system specification, requirements and developed Use Cases
• Conducted JAR/JAD in gathering requirements with the business user groups or stakeholders and understanding business needs and the value of their proposition
• Gathered Data Extract Requirements to enable other warehouses i.e. EDW to perform enterprise level reporting via Enterprise Data Warehouse.
• Worked with business in writing Business Requirement Document BRD
• Involved in all phases of the Software Development Life Cycle SDLC and acted as the main liaison between corporate business managers and IT division
• Coordinating with the development team and integrating the business requirements for all projects across all work streams
• Create Use Cases to describe ETL process to land data into the warehouse and source Siebel Analytics or Extracts according to the RUP standards.
• Liaise with different department to integrate all the system reliability or dependency.
• Worked closely with Data Architect during Data Model created/modification by utilizing ERWIN.
• Prepared documentation to map data from Diamond to Siebel Analytics
• Once development is complete, I validate the contents of the Siebel Subject Area against requirements for testing
• Ensure that the report in the dashboard is functional and designed as per requirements.
• Developed business level activity diagram utilizing UML to visualize use cases, identified gaps between the current model and future model
• Verified data integrity utilizing Oracle and DB2
• Performed gap analysis, mapping document and wrote business process rules given by business
• Participated in the UAT session and assisted users with questions
• Assisted testers with test cases and questions
• Utilized Test Director as a bug reporting tool

Environment: Siebel Analytics, Requisite Pro, Test Director, DB2, Oracle