Professional Experience:

• Innovative professional with over 7 years of experience in the IT industry with prime focus on Implementation, Development, Customization, Analysis and Design of Data warehousing business systems.
• Expertise in debugging and optimizing the Oracle BI/Siebel Analytics Dashboards / Reports.
• Experience in creating Metadata Objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboards, Pages, and Reports) using OBIEE.
• Developed Informatica Mappings using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Tasks.
• Configured Answers (ad-hoc querying, reports), Interactive Dashboards with drill-down, drill-across capabilities (charts/tables/graphs), Delivers/iBots (alerts) and administered Web Catalog Objects (pages, folders).
• Extensive experience with SQL, PL/SQL and sound working knowledge of Oracle Database.
• Responsible for all activities related to the development, implementation, administration and support of reporting using OBIEE.
• Knowledge in Data warehouse Administration Console (DAC) to Configure, Monitor and Schedule ETL routines of Full and Incremental ETL loads of the Oracle Business Analytics Warehouse.
• Experience in working with different operating systems like Linux and Windows.
• Worked with Business Analysts /Users to identify information needs and business requirements for reports and finalizing Requirement Specifications, Design Specifications.
• Business Analysis experience and broad understanding of business operations and requirements.
• Good Communication and Interpersonal Skills, resulting in excellent rapport with employees and executive management.
• Ability to understand new concepts and applications and experience working with business user’s community and leads/managers.

Technical Skills:

• Reporting Tool : Oracle BI EE 11g/10g
• ETL : Informatica 9.x/8.6/8.5.1/8.1.1/7.1.4
• Operating Systems : Win NT/2K/XP, Windows 2008/2003 Server, UNIX/LINUX
• Languages : SQL, PL/SQL
• RDBMS : Oracle 11g/10/9i/8i,SQL Server 2005,SQL Server 2008
• Office Applications : MS Office Suite

Academic Profile:
Bachelors of Technology in Electronics and Communication Engineering

Projects:

Confidential, June 2012 Present
OBIEE Consultant
Description:
The project was aimed at Purchasing and Supply chain implementation. The main objective was to build ODS, Datamart and Data warehouse for its Parts/Supplier chains around the nation. The purpose of project was to prepare reports for analysis of order entry through OBIEE Reporting system.

Responsibilities:

• Used simple to complex analytical SQL queries against the source databases to identify and analyze the authenticity of the data before importing to build the OBI repository
• Involved in laying out a strategy with senior management and technical team for building the metadata that presents the business model to support the business requirements
• Involved in creating POC’s (proof of concepts) for the repositories and business functionalities with the architect team and business users
• To design and implement database indexes and partitions to improve application and dashboard performance.
• Identified the appropriate facts, metrics, hierarchies, and territories to structure the initial conceptual model of the business from the requirement documentation
• Created a repository using OBI Administration tool by importing tables into the physical layer and created the business and mapping model to incorporate the business logic
• Add calculated measures that involve operations on existing columns
• Created presentation catalog which allows exposing the business model to users in Oracle BI Answers so that users can build requests to analyze the data
• Created presentation folders and test with Answers
• Created Dashboard Pages, Created a New Interactive Dashboard Page by using answers from presentation catalog.
• Created Prompts to Filter Interactive Dashboard Data
• Perform unit testing and create test plans for reports built in Oracle Answers
• Identify causes of performance issues and helped to resolve the same.
• Worked on BI Publisher reports in generating the templates (Word, PDF, and HTML) as required.
• Prepared Detail Design Document of the complete implementation of Business modules

Environment: OBIEE 11g, Informatica 9.0.1, Oracle 11g, SQL Developer, SQL Server 2008

Confidential,Michigan Jan 2011 June 2012
OBIEE Consultant
Description:
The project was aimed at HR and Financial Analytics implementation, which provides Financial Statements, Capital Gain Analysis. The objective is to extract data stored in different databases and to load into the data warehouse, which is in Oracle enabling to build interactive reports.

Responsibilities:

• Actively involved with Business Users for gathering the Reports / Dashboards requirements and to define business and functional specifications
• Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Analytics Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool
• Interacted with Systems Engineering team to design - Facts & Dimensions for Repository (.rpd)
• Prepared Detail Design Document for Repository (.rpd)
• Created measures in Administration tool for the requirements using expression builderand calculation wizard
• Developed multiple Dimensions (Drill-Down, Hierarchies) & Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer
• Designed and developed Business Intelligence reports and dashboards using Oracle Enterprise Edition BI Answers and BI Interactive dashboards
• To design and implement database indexes and partitions to improve application and dashboard performance
• Extensively used dashboard prompts and formatted the reports, resultand pivot sections according to the end user requirements
• Configured Financial and worked on the customizations of Financial Analytics to meet the reporting requirements of the client
• Worked extensively on security for users and groups based on the individual and group responsibilities
• Developed simple & complex mappings using Informatica to load Dimension & Fact tables as per STAR schema techniques
• Developed Informatica Mappings to load data from relational and flat file sources into the data warehouse
• Worked with Workflow manager and validated the workflow
• Scheduled and ran Extraction, Loading processes and monitored sessions using DAC (Data Warehouse Application Console)

Environment: OBIEE 11g/10g, Informatica 9.0.1/8.6.1, Oracle 11g/10g, DAC 10.1.3.4.1, SQL Developer

Confidential,Michigan Jan 2009-Dec 2010
OBIEE Developer
Description:
The goal of this project was to implement Business Intelligence Solutions to measure Pay for performance, corporate contribution employee expense trend, demographics and deliver flexible business solutions for various HR scorecards. The project involved HR and Financial Analytics implementation and customizing the reports to suit the business need.

Responsibilities:

• Worked with Business Users for gathering the requirements and to define business and functional and technical specifications
• Configured Physical Layer Import tables, Create Tables, add/change physical joins/keys. Configured Logical Layer Create Logical tables/dimensions, columns, Create Logical Joins/keys, Set levels to support Drill-down, Aggregation / Sum over Columns. Configured Presentation Layer Create Folders/sub-folders, Standard Queries for different User Groups
• Developed Dashboards using Reports with different Views(Drill-Down, guided navigation, Pivot Table, Chart, Column Selector, dashboard and page prompts)using Oracle Presentation Services
• Configure analytics repository with logical dimensional modeling using Star Schema (Facts and Dimensions)
• Worked extensively on security for users and groups based on the individual and group responsibilities
• Involved logical and physical modeling to create structures in core database using Erwin modeling tool
• Configured Financial Analytics and worked on the customizations of Financial Analytics to meet the reporting requirements of the client
• Created comprehensive and easy-to-understand Documentation of the complete implementation of Business modules (Reports, Dashboards, Security, star schema) for Repository (rpd)
• Designed the report layout templates in the BI Publisher
• Extensively used ETL to load data from multiple sources to Staging area (Oracle) using Informatica Power Center 8.6.1
• Involved in QA, UNIT testing

Environment: OBIEE 10.1.3.3.2, Informatica Power Center 8.5.1, Oracle 10g, SQL Server

Confidential, INDIA Oct 2005-Dec 2008
Siebel Analytics Developer
Description:
EV offer services for K-12, Higher Education, Corporate, Publishing Houses and Coaching Institutes. The main focus of this project was to monitor if the business is on track and take any corrective action if needed.
Responsibilities:

• Extensively worked on Siebel Analytics server and presentation server
• Developed new reports and migrated existing excel reports to Siebel Analytics dashboards
• Designed and developed the Siebel Analytics Metadata Repository (.rpd) using Siebel Analytics Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints using connection pool into Physical Layer, developed multiple Dimensions (Drill-Down Hierarchies) & Logical Facts / Measures in Business Model Layer, and created the Presentation catalogs inPresentation Layer
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) for performing the customer insights / trends using Siebel Analytics Web
• Installed and configured Informatica PowerCenter server and clients
• Analyze, design, construct and implement the ETL jobs using Informatica

Environment: Oracle 9i, Siebel Analytics 7.5, Informatica (Power Center 7.1), Windows XP.