OBIEE Consultant Profile

CURRICULAM VITAE

SATISH KUMAR

Mobile: 91-808*******,988-***-****

E-Mail: *************@*****.***

Summary:

4+ yrs Experience in IT which includes 3+ yrs in Oracle Business Intelligence Enterprise Edition

Experience in developing three layers (Physical Layer, Business Model & Presentation Layer)

Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.

Expert in Creating the Dimensional Hierarchies, Level Based Measures, Time- series Functions and Initialization Blocks depending upon the need for Business Reports using the OBIEE Admin tool.

Worked with different Sources such as Oracle, MS-Excel and XML Files.

Good knowledge on Data level & object level security

Worked on creation of repository variables and session variables

Experience in Design and Implementation of Data warehouse/Data Mart, gathering Business Requirements, System Analysis, and Design and Data model

Good knowledge of the SDLC and Experience in Support, Maintenance and Development of Projects

Good Knowledge on Oracle(SQL,PL/SQL) and Knowledge in SIEBEL CRM

Having functional knowledge in e-Sales, e-consumer, e-Communication and Marketing Applications

Knowledge on Data Warehousing concepts like Star Schema, Snow Flack Schema Dimensions and Fact tables

Knowledge in Oracle BI Applications(OBIA)

Knowledge in Informatica and Data warehouse Application Console (DAC) Architecture

Quick learner and Good Team player

Self – Managed, Result-oriented and producing quality work on time.

Technical Skills:

OLAP TOOL : Siebel Analytics 7.8.4, OBIEE 10.1.3.x

CRM : Siebel 7.5/ 7.7

Operating Systems : Ms-Dos, Windows NT/2000/XP, UNIX

RDBMS : MS-SQL 2000, MS-Access, Oracle 9i/8i, 10g

Languages : C, C++, Java

Scripting Languages : e-script, Java Script, VB Script

GUI : VB 6.0

Web-Technologies : Java, SOAP

Version Controls : VSS, CVS

Tools : TOAD, QTP, ANT, Clear Case

Internet Technologies : HTML, DHTML

Educational Qualifications:

Master of Information Technology (MIT) from University of Southern Queensland, Sydney, Australia.

Bachelor of Computer Application (BCA) from Vivekananda Degree College (OU) - Hyderabad.

Certification: Oracle Business Intelligence Foundation 10.1.3 Essentials

Professional Experience:

Working as a Senior Software Engineer in Accenture Services Oct.2011 to Till date

Worked as a OBIEE Developer in Igate-Patni Computers from Jan.2011 to Sep.2011

Worked as a Consultant in IBM, Bangalore from Jan. 2010 to Jan.2011

Worked as a Consultant in Wizard Systems INC, USA from May2008 to April2009

Worked as a Software Engineer in Anna Global Consulting Services, Australia Feb2007 to Sep2007

Accenture India Pvt. Ltd. Oct.2011- Till Date

Hyderabad

Project : ARTL

Client : Accenture Internal

Description:

(ARTL) for Oracle is a great example of our Company's commitment towards industrialization. The ARTL for Oracle which covers Oracle Seibel has grown tremendously over the last one year in terms of usage (@ IDC 70% Coverage and effort savings of 5.3%) of the reusable assets (480+).

Roles & Responsibilities:

• Involved in Understanding the Business Requirements and Preparing Technical Design documents based on HLD, SRS and Data Model.

• Identify Facts and Dimensions and Creating OBIEE Repository at 3 layers (Physical Layer, BMM Layer and Presentation Layer).

• Developing business reports using BI Answers and to display the reports on Dashboards.

• Created Dimensional Hierarchies.

• Created Reports using different Analytics Views (Pivot Table, Chart, View Selector and Column Selector).

Environment: OBIEE 10g, Siebel 8.0, Window XP Professional, Oracle 10g, VSS

IGATE Patni Computers Jan2011-Sep2011

Hyderabad.

Project : C & D

Client : Church & Dwight

Description:

Church & Dwight Co., Inc., founded in 1846, is the leading U.S. producer of sodium bicarbonate, popularly known as baking soda, a natural product that cleans, deodorizes leavens and buffers. The Company's ARM & HAMMER brand is one of the nation's most trusted trademarks for a broad range of consumer and specialty products developed from the base of bicarbonate and related technologies.

Roles & Responsibilities:

• Involved in preparation of Design Document

• Created dimensional hierarchies in logical layer to achieve drill down functionality

• Configured session (system & non-system) variables to implement data level security.

Created reports using OBIEE reporting views like tables, chart, filters and pivot and narrative etc and integrate them in dash board

• Implemented prompts to provide dynamic filter condition to end users

• Worked on creation of repository variables and session variables

• Worked with the security settings in OBIEE Admin Tool to set up users, groups, access privileges

• Developed interactive navigational drill down reports in OBIEE, requests and Intelligence

• Dashboards using various reporting features and functionalities such as formulas, filters, charts, pivot tables

• Involved in defect fixing

Environment: OBIEE 10g, Siebel 7.7, Window XP Professional, MS-SQL Server

2008, VSS

IBM, Bangalore Jan.2010- Jan.2011

Employer: Artech India.

Project Name : VMU

Client : Virgin Mobile

Virgin Mobile USA is the first Mobile network Operator in the US and it is does not operate on its own network. Instead, it piggybacks on the network of Sprint Communication. VMU selected Siebel Communication as a critical part of its IT infrastructure. Siebel Communication ensures that customer can “top-up” their accounts instantaneously at any time of day, through any channel and continue to receive uninterrupted wireless service. VMU customers procure mobile handsets from retailers but engineered to connect to SPRINT Network. Initially the handsets are inoperable. Calling customer care can do activation of those sets.

Roles & Responsibilities:

• Involved in Understanding the Business Requirements and Preparing Technical Design documents based on HLD, SRS and Data Model.

• Identify Facts and Dimensions and Creating OBIEE Repository at 3 layers (Physical Layer, BMM Layer and Presentation Layer).

• Developing business reports using BI Answers and to display the reports on Dashboards.

• Created Dimensional Hierarchies.

• Created Reports using different Analytics Views (Pivot Table, Chart, View Selector and Column Selector).

• Created Prompts and Filters

• Participated defects fixing

Environment: OBIEE 10.1.3. Oracle 9i, Bugzilla, VSS

Wizard Systems Inc., NJ, USA May2008-April2009

Project Name : WFS

Client : WACHOVIA, Sanfranciso

WACHOVIA is a diversified financial services company providing banking insurance, investments, mortgage and consumer finance, headquartered in San Francisco. Sales Order management was used to maintain data for mortgage warehouse loans. This application would give the information to the client about the number of mortgage loans sold by the company.

Roles & Responsibilities:

• Involved in meetings business representatives for requirement analysis and to define business and functional specifications

• Built OBIEE Repositories at three layers i.e. Physical layer, Business model Layer and Presentation layer

• Created Drill down Hierarchies and implemented Business Logics and Facts

• Created Pivot Tables, Charts and manipulated initialization blocks for report analysis

• Worked on OBIEE Answers to build Dashboards with drill down capabilities

• Created measures and level Based measures in Business Model

• Involved in creation of logical Tables and logical columns

• Created Dimension hierarchy in Business model layer

• Created and tasks and tasks groups and subject matters in DAC for informatica servers

• Involved in Bug Fixing and Unit Testing

Environment: Siebel 7.7, OBIEE10.1.3.3.2, Informatica Power Center 8.1.1, Oracle 10g, DAC, PL/SQL

Anna Global Consulting Services, Australia Feb.2007-Sep.2007

Project Name : COS

Client : COLES Super Markets, Sydney

Coles is a one of the biggest leader in Australia food retailing with more than 100,000 employees and over 11 million customer transactions a week. For more than 90 years, Coles has been a highly regarded and much loved part of Australian life.

It has used Sales Management System to keep track of the Orders, Inventory, Products, Sales, and Customers. By analyzing the application Coles came to know about its business whereabouts. The application was customized using OBIEE.

Roles & Responsibilities:

• Involved in Understanding the Business Requirements and Preparing Technical Design documents based on HLD, SRS and Data Model

• Identify Facts and Dimensions and Creating OBIEE Repository at 3 layers (Physical Layer, BMM Layer and Presentation Layer)

• Developing business reports using BI Answers and to display the reports on Dashboards

• Created Dimensional Hierarchies.

• Created Reports using different Analytics Views (Pivot Table, Chart, View Selector and Column Selector)

• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation

• Created workflows to schedule and trigger mappings

• Created Aggregation tables in OBIEE and Created Job Scheduling for Aggregation Tables.

Environment: OBIEE, DAC, Informatica 8.1Siebel 7.5, Window NT, Oracle 9i, Toad, VSS

Finnsoft Solutions, Bangalore Sep2003-Aug.2004

Project Name : Propest-Sales

Client : Propest Co.Ltd

This project is related to the pesticides company, which develops a system that can be used by the company management to keep track of the sales, dealers and its clients. It fulfills different requirements of management, clients and dealers of the company. The specific purpose of the system is to automate the communication between the management, clients and the dealers of the organization.

Roles & Responsibilities:

• Interacted with business analysts to understand the business requirements

• Creation of Tables, Triggers and Stored Procedures

• Created Stored Procedures, triggers script to populate data into different tables according to different parameters specified

• Write and Optimize Triggers, Stored Procedure and Queries

• Maintained referential integrity by inserting Primary and Foreign Keys

• Involved in Unit Testing

Environment: Oracle 8i, Sql, Pl/Sql, Toad, Windows Xp, CVS

Contact this candidate