kumar BI

NARESH KUMAR Phone :+91-994**-*****

OBI Consultant Email : ******.*****@*****.***

PROFESSIONAL SUMMARY:

2.2 Years of extensive experience in IT industry, which includes Experience with 2 years of OLAP reporting tool like OBIEE .

Extensive experience in Analysis, Design, Development, Dimensional modeling and Implementations of Data warehousing.

Extensive work experience on all the layers (Physical, Business Model and Presentation layers) in repository (rpd) for enterprise versions of OBIEE (Siebel Analytics).

Experienced in designing Star Schema/ Snowflake Schema methodologies.

Design experience in Business Intelligence using Oracle Business Intelligence.

Customized and developed repository(rpd), configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboards, Pages, Folders, Reports)

Extensive experience in configuring OBI Answers, OBI Delivers (OBI Ibots) and OBI Dashboards.

Developing database schemas like Star schema and Snowflake schema used in relational, dimensional and multi dimensional modeling.

Good Experince and Knowledge in DataStage.

Solid analytical & functional skills, ability to effectively communicate with technical & business users.

Extensive ability in writing specifications and gathering requirements from the user to develop Reports as per the needs of the client and maintain documentation for future reference

SKILLS SUMMARY:

Business Intelligence Tools : Oracle Business Intelligence 10.1.3.4 ,

Operating Systems : Windows-Xp, Win7, Server 2003 & 2008.

ETL : DataStage

RDBMS : Oracle 9i,10g,

Languages : Basics C, SQL.

EDUCATION:

B.Tech from JNTU Anantapur, A.P, India

EXPERIENCE:

Worked as BI Developer , Bangalore, from Apr 2009 to till date .

Project#1

Client : STC, Saudi Arabia

Environment : OBIEE, OBIA (DAC), Siebel eBusiness Applications, Oracle,Informatica,QC, TOAD, and Win xp.

Period :

Role : OBI developer

Description:

Saudi Telecom Company (STC) is the leading telecommunication provider in Saudi Arabia. STC has embarked upon a program “Customer Care”, to modernize the Customer Service Centers for its ALJAWAL Mobile Business Unit, by deploying new state of the art systems for its core functions the Billing and Customer Relationship Management (CRM).This exercise will help STC ALJAWAL Mobile Business Unit to attain its vision of continuing to be the largest mobile network with customer-centric and profitable services. The proposed solution would enable ALJAWAL in getting insight into the cross functional areas

All the reporting and analytics requirements for the Sales, Service and Marketing Department. The information is based on a study of the current reporting system, future reporting requirements, CRM Analytics and reporting Workshops and follow-on meetings and interviews with business users, from all the respective departments

Role and Responsibilities:

Prepared TDD for all Analytics tasks and Informatica mappings as per functional document.

Extensively used Siebel Analytics Administration Tool for developing & modifying the physical, business & presentation layers of metadata repository.

Defined Logical Join Key relationships between dimension tables and Fact tables in the Business model & mapping layer.

Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups and responsibilities.

Used drill down tables & charts to Hierarchical reports.

Created dimension hierarchies as per requirements.

Created logical columns and calculated measures using Expression builder.

Created level based measures in business model layer.

Created presentation catalogs.

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

Developing mappings using by using transformations.

Designed Unit test Cases for all mappings.

Developed various Mappings to load data from various sources using different Transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Source Qualifier, Expression and Union.

Developed ETL mappings, Transformations and Loading using Informatica Power Center7.1.3

Developed and tested all the Informatica mappings.

Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.

Populating data for Siebel Analytics reports using DAC.

Project#2

Project Name : MCRS (Microsoft Centralised Reporting Systems)

Client : Microsoft

Environment : OBIEE, OBIA (DAC), Siebel eBusiness Applications, MS SQL Server,Informatica,and Win xp.

Period :

Role : OBI developer

Description

MCRS is the reporting system front end tool to analyse the status for Microsoft incidents and defects. In the Microsoft Centralized reporting system brings the data from multiple datasouces to generate the reports. We have to monitoring the DAC Loading and Informatica mappings customization to brings the data from data sources.

Role and Responsibilities

Extensively used Siebel Analytics Administration Tool for developing & modifying the physical, business & presentation layers of metadata repository.

Defined Logical Join Key relationships between dimension tables and Fact tables in the Business model & mapping layer.

Created dimension hierarchies as per requirements.

Created logical columns and calculated measures using Expression builder.

Created level based measures in business model layer.Created presentation catalogs.

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

Extensively used Global, Page and Column Prompts to filter data to customize the report according to user requirements and to increase performance.

Created Revenue Report based on Period Dimension.

Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups and responsibilities.

Used drill down tables & charts to Hierarchical reports.

Worked on Merging the webcats and reports and Involved on Unit Test.

Contact this candidate