PRAVEEN.N

Mobile:+91-998*******

Professional Summary :

Email: acn47h@r.postjobfree.com

Having 4.3 years of strong experience Adminstration in OBIEE10g /11g and also have

working knowledge in

WebLogic ServerAdministration Console& EnterpriseManager in OBIEE 11g.

Technical Summary:

Good experiencein Working IN OBIEE11g Adminstration and Dimensional Modeling,

Star schema in implementing Decision support system using FACT and DIMENSION

t ables.

• Strong Experience in Business Intelligence (OBIEE) Reporting, Good experience in

creating the Repository and creating the reports by using the Administrator Answers and

Dashboards in OBIEE (11g).

• Expertise in Business Model development with Dimensions, Hierarchies, Level Based

Measures, Aggregation Rules, and Caching.

• Implemented Usage Tracking in OBIEE 11g

• Developed Physical Layer, Business Model & Mapping and Presentation Layer using

O racle BI Administration Tool.

• Implemented Customized Skins, Styles, Images and Messaging in OBIEE 11g.

• Managed Security privileges for each Subject area and Dashboards according to user

requirements.

• Expertise in Manage Catalogue Groups and setting permissions of Reports,

Dashboards, Agent and filters to the Business user according to the requirement.

• Good experience on OBIEE Application Roles l ike BI_Administrator,

B I_Consumer,BI_Author.

• Strong Experience in creating reports with various functions on the OBIEE Web

i ncluding sub report, guided navigation, pop chart report.

• Created Dimension Hierarchies in the BMM layer to drill down and Date H ierarchies

• Creating Users and Groups and managing the object level and data level security.

• Worked with Repository Variable, Session Variable and Presentation Variable.

• Implemented Mapviewer in OBIEE 11g using Oracle DB.

• Having Good knowledge in Informatica

• Having Good Exposure in DAC

• Having Good Knoweldge in OBIA

Technical Expertise

OBIEE 10G/11G,OBIA,Siebel Analytics 7.8.x

OLAP Tools

RDBMS Oracle 9i/10g/11g

ETL Tools Informatica 8.x,9.1

Database Tools TOAD, SQL

Programming Languages HTML, CSS, XML, JavaScript,

OS Platforms Windows XP, UNIX

E xperience

P resently working as Senior Software Engineer TATA CONSULTANCY SERVICES, Bangalore

from DECEMBER, 2013to till date.

Worked as a Software Engineer at SYNTEL,PUNE from AUG2010 to NOV 2013.

Qualification:MCA-2010 JNTU H

Project Profiles:#1

Client : Telstar Telecom,Austrila

Role : OBIEE Developer

Duration : DEC 2013 to TI LL date

Environment : : OBIEE11g, Informatica, SiebelCRM, Unix,Oracle,

ProjectDescription:

Telstra Corporation Limi ted (ASX: T LS, N ZX : T LS ; known as Telstra) is an

A ustralian t elecommunications and media company, building telecommunications

networks and marketing voice, mobile, Telstra was privatised in three different stages

i nformally known as T1 ($3.30), T2 ($7.40) and T3 ($3.60) respectively, Telstra is

A ustralia's dominant and largest provider of Fixed Line services. These include home

p hone, business and other PSTN, i t’s positioning the Group strongly in the Austrila

l argest markets for telecom. Telstar Analytics is implemented to calculate the sales and

revenues for i ts varied Offers across various locations .

Responsibilities:

Involved in upgrade activities

Resolved all issues after post upgrade from obiee10g to obiee11g

Involved in understanding of requirement documents and produced

f unctional specifications.

Presented functional and technical requirements information in-group

settings.

Created high-level and detailed design documentation.

Implemented the best practices, which reduced the cycle time and

i mproved profitability for the organization.

Worked closely with the DBA and ETL Leads for gathering necessary

data.

Worked extensively with Physical Layer, Business Layer and Presentation

L ayer.

Configured Repository (.rpd) on the Physical, Business and Presentation

levels.

Identified data sources, corresponding Mappings and Logical Joins

Configured tables and columns between Business and Presentation layers.

Worked with development te am to create and configure source data.

Generated queries and placed fil ters in Siebel Answers.

Performed Pre and post implementation testing of Dashboard, Answers

and validating Repository (.rpd).

Involved in creating Dashboards for the reports also using Guided

Navigation and Links.

Involved in Performance Tuning of reports by identifying the indexes

required on the backend tables and also from the data available in the Cache.

Project #2

Client : KAS BANK, Amsterdam

Role : OBIEE Developer

Duration : OCT 2012 to Nov 2013

Environment : OBIEE 11g,Informatica,DB2, BI APPS, Windows - XP

Project Description:

KAS BANK N.V. is a solid, specialist European bank offering a wide range of

securities and investor services. KAS BANK's main target groups are institutional

i nvestors (pension funds, insurance companies, investment funds and asset managers)

and financial institut ions (banks and brokers). KAS BANK does not provide active asset

management services itself and is fully independent, guaranteeing i ts absolute

neutrality and autonomy. A low r isk profile is an integral part of i ts services. KAS

B ANK focuses on value-added services in the field of t reasury, r isk control and

management information

Responsibilities:

Designed S tar Schema/Diagrams using Fact, Dimensions, Physical, Logical

and t ables.

Imported and configured the OBIEE RPD Physical, Business Model and

P resentation L ayers and published data in dashboards and Answers.

Creating reports and publishing them in the dashboards using answers

Used constrained fil ters, column fil ter prompts and various views such as Pivot

t ables

Developed B usiness models conforming to functional mapping, defined

Logical and complex joins for the dimension tables.

Identified the aggregate levels for each source and created dimension sources for

each level of aggregates.

Extensively worked with D imensional hierarchies and level based measures

Created different types of customized reports (Drilldown, Aggregation) to meet client

requirements.

Creating and managing variables, Init ialization Blocks using Oracle BI

A dministration Tool.

Implemented caching to increase performance.

Generated the Reports Weekly and Monthly basis as per the Client Requirements.

Defined dynamic repository variables to modify metadata content dynamically to

adjust to a changing data environment.

Configured Web Catalog Objects (Dashboards, Pages, Folders and Reports) and

I mplemented different views of report i.e. Pivot table, Titles, Graph, Fil ters etc.

Designed and developed Fronted dashboards and reports by incorporating complex

business rules.

Worked with the ETL team to design the Star Schema and populate the

Data warehouse.

Buil t the Physical Layer /Business Model and Mapping Layer/

P resentation Layer of a Repository by using Star Schemas.

Added Aggregate measures using Aggregate Persistence Wizard.

Project #3

P roject Title :Johnson & Johnson CRM IN IT

Client : Johnson & Johnson, U SA

Role : OBIEE Developer

E nvironment : OBIEE10G IN formatica, SiebelCRM, Oracle,

D uration :Aug, 2010 to Sep,2012

P roject Description

Johnson & Johnson is an American m ultinational medical devices, pharmaceutical and

consumer packaged goods manufacturer company, Johnson & Johnson is headquartered in

New Brunswick, New Jersey w ith the consumer division being located in Skillman, New

Jersey, it’s includes some 250 subsidiary companies with operations in over 57 countries

and products sold in over 175 countries,the company's major franchises in the

Pharmaceutical segment include Immunology, Neuroscience, Infectious Disease, and

Oncology,The world’s largest and most diverse medical devices and diagnostics company,

T he world’s fifth-largest biologics company,

Using OBIEE System Developed Different kinds of reports for Decision making purpose

Responsibilities

• Analyzing the requirement gathered from Business Users.

• Developed P hysical Layer, Business Model & Mapping and Presentation Layer

using Oracle BI Administration Tool.

• Developed different brand level Reports, Filters, and Prompts using Oracle BI

A nswers.

• Managed Security privileges for each Subject area and Dashboards according to user

requirements.

• Used F ilters (Global and Local) and provided customized prompts to avoid excessive

data showing up in the reports.

• Configuring Agents to deliver analytics content based on schedule to obtain weekly

reports and sent notification Alerts.

• Involved in R PD Development, Oracle BI Administration, Oracle BI Answers,

d ashboards, and star schema modeling .

• Implemented T ime Comparison and calculation measures i n the business model using

T ime series wizard and modeled slowly changing dimension data.

• Created groups in the repository and added users to the groups and granted

p rivileges explicitly and through group inheritance.

• Created Dimension Hierarchies in the BMM layer to drill down and Date

H ierarchies.

• Creating Users and G roups and managing the object level and d ata level

security.

Contact this candidate