BHARATH KUMAR

Ph: +919********* hoefqq@r.postjobfree.com

Career Summary:

o Having 3.1 years of experience in Oracle Business Intelligence . Using Oracle Business Intelligence (OBIEE), Siebel Analytics.

o Proficient in building analytical repository, generating reports, and creating dynamic Dashboards using Siebel Analytics/OBIEE.

o Having Knowledge of configuring the scheduler and configuring the ibot.

o Having the knowledge of configuring the connection pool.

o Create the reports like Table, Chart, Pivot, column selector and Narrative views and publish them in dash board using answers

o Configured Repository variables to generate dynamic reports

o Experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Setting permissions to access specific pages of Dashboards and Shared folders in catalog.

o Implemented prompts to provide dynamic filter condition to end users

o Experience in creating variables (Repository, Session) and using in Dashboards, Answers, Delivers & in Repository.

o Experience in OBIEE, Siebel Analytics Admin Tool, Presentation Services and Scheduler Server

o Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure

Experience Summary:

o Working as an OBIEE Developer at Textron IT Services India PVT LTD., from June 2008 to till date.

.

Technical Skills:

Business intelligence Tools : Siebel Analytics 7.8, OBIEE 10.1.3.4

ETL Tools : Informatica 7.1.

Languages : SQL, PL/SQL.

Data Bases : Oracle 9i, 10g

Operating Systems : Windows 2000, XP.

Education: B.E - Electrical and Electronics Engineering from Anna University

Projects Summary:

Project # 01:

Project Name : Target Corporation Reporting System

Client : Target - Minneapolis MN

Duration : June 10 to till date

Environment : OBIEE 10.1.3.4, Oracle 10g, ODBC, Win XP

Company name : Textron IT Services India PVT LTD

Location : Bangalore

Project Description:

Target Corporation is the fifth largest retailer by sales revenue in the United States. Target operates its retailing business exclusively in the United States. It is a rival and competitor of Kmart and Wal-Mart. Target Co. includes clothing, house wares, food etc. The project deal with the transportation department of Target Co. The company implemented OBIEE for the Delivery Analytics of the various goods. The Products are delivered to the stores from various Distribution Centers (DC). Dimensions like product truck Invoice DC, Time etc were considered. Various customized reports/dashboards were developed for the different user groups across the organization.

Responsibilities:

o Worked extensively on OBIEE Administration tool and Presentation Services.

o Get the database connectivity and design the Physical Layer, Business model and Mapping layer and the Presentation layer in the repository(rpd)

o Created Dimensional Hierarchies, Level based Measures in Logical Layer to achieve Drill down Functionality.

o Configured Repository variables to generate dynamic reports.

o Configured session (system) variables to implement data level security.

o Using OBIEE Presentation service Web extensively developed Answers Pages and Dashboards with different views like Pivot Table, Chart, Column Selector, and Narrative Tabular with global and local Filters.

o Implemented prompts to provide dynamic filter condition to end users.

o Experience in Oracle BI EE Unit testing report data validation report data testing based on SQL results OBIEE query log data validation

Project # 02:

Project Name : Pfizer Reporting System.

Client : Pfizer Animal Health, US New York.

Duration : Nov 08 to June 10

Environment : OBIEE 10.1.3.4, Oracle 9i, Toad.

Company name : Textron IT Services India PVT LTD

Project Description:

Pfizer is one of the world’s largest Pharmaceutical/Health Care companies with offices all over the world. The project was on the extraction of data from Siebel and other Systems and building the common operational data store for PAH. PAH periodically assesses and prioritizes various risk areas that may affect the company’s operations and growth. As a result, Pfizer regularly reviews and where necessary refines the several fundamental elements that define its Compliance Program. Pfizer Reporting System is an analytics project implemented to asses and review the companies key performance areas such as Sales, Marketing over the EU region (Both country and EU level).

Responsibilities:

o Enhancing the subject areas as and when suggested by the business analyst.

o Created Drill down Hierarchies and implemented Business Logics for Facts.

o Understanding requirements and customizing the Repository to meet the

requirements.

o Developing Custom Dashboards and reports using Siebel Answers.

o Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic), Pivot Table, Chart, Column Selector, Tabular) using Siebel Analytics Web.

o Configured iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.

o Created presentation catalogs.

o Created reports, filters & charts in Siebel Answers & added them to Intelligence Dashboards.

Project # 03:

Project Name : Empire Analytics

Client : Empire Today, US.

Duration : June 08 to Oct 08.

Environment : Siebel analytics 7.8.2, Oracle 9i.

Company name : Textron IT Services India PVT LTD

Project Description:

Empire Today has been a leading supplier of installed Home furniture and Home Improvements for more than 45 years, with over one million satisfied customers. This assignment was associated to build up the reports at the analytics end. To make sure that user should get flexible and optimal results as per their trade requirement. We were getting weekly requirement from User and same requirement was allocating by Business Analyst. Report was exactly rounded and concentrated on following Subject areas: Carpet, Hardwood, flooring, Laminate flooring, Ceramic Flooring, Window Treatments, Bath & Shower Liners.

Responsibilities:

o Creating new Logical tables and Logical columns in the Business Layer.

o Creating calculation measures using logical columns.

o Creating level based measures.

o Working in Siebel analytics Answers to build various reports like table view, Pivot table view, narrative view etc.

o Developing Dashboards using Prompts.

o Creating and configuration of iBots using delivers option.

Contact this candidate