N.SatyaKumar

Mobile:+91-988*******

Professional Summary:

Email: acpza2@r.postjobfree.com

Having 4+ years of strong experience in OBIEE10g/11g and also have working knowledge in

Analytics &EnterpriseManager in OBIEE 11g.

Technical Summary:

Good exposure in Dimensional Modeling, Star schema in implementing Decision support system

using FACT and DIMENSION tables.

• 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 Oracle BI

Administration Tool.

• 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 like BI_Administrator, BI_Consumer,BI_Author.

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

report, guided navigation, pop chart report.

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

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

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

• Having Good knowledge in Informatica

Technical Expertise

OBIEE 10G/11G,

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

Experience

Presently working as Senior Software Engineer TATA CONSULTANCY SERVICES, Bangalore

from DEC’2013to till date.

Worked as a Software Engineer at SYSTIME,MUMBAI from DEC’2010 to NOVEMBER’2013.

Qualification:MCA-2010 JNTUH

Project Profiles:#1

Client : Celgene biopharmaceutical company,newjersy,USA

Role :OBIEE Developer

Duration : DEC’2013 TO TILL DATE

Environment : OBIEE11g, Informatica, DAC,Unix,Oracle,

Projects Summary:

Celgene is a global biopharmaceutical company committed to improving the lives of patients

worldwide, is to build a major global biopharmaceutical corporation while focusing on the

discovery, the development, and the commercialization of products for the treatment of cancer

and other severe, immune, inflammatory conditions, There are more than 300 clinical trials at

major medical centers using compounds from Celgene, Discover Celgene's deep and diverse

intellectual property portfolio - a variety of novel scientific targets and approachesThe goal of

this project is to provide Sales Analysis and Purchase Analysis reports for the management to

take decisions. The whole process has been automated and entire extraction, transformation

and loading process has been done with the help of Informatica and reporting done using

OBIEE.

Responsibilities:

Used the OBIEE 11g Administration tool to develop and enhance meta-data.

Created connection pools, physical tables, defined joins and implemented authorizations in the

physical layer of the repository (.rpd).

Worked extensively with Physical Layer, Business Layer and Presentation Layer.

Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension

tables.

Created different types of Customized Reports (Drilldown, Aggregation) to meet client

requirements.

Built Business model and established relationships & Foreign Keys (Physical & Logical) between

tables.

Created business reports using Siebel Answers as per requirements.

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

aggregates.

Involved in managing appropriate security privileges on subject areas and dashboards according

to business requirements.

Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to

application specific dashboards.

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

Created proactive agents iBots and interactive Dashboards to alert the Marketing team about

business changes.

Managed security privileges for each subject area and dashboards according to user

requirements.

Project #2

Client : KAS BANK, Amsterdam

Role : OBIEE Developer

Duration : AUG’ 2012 to NOV’ 2013

Environment : OBIEE 11g,Informatica,DB2,Oracle11G, Windows – XP,Unix.

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 investors (pension funds,

insurance companies, investment funds and asset managers) and financial institutions (banks and

brokers). KAS BANK does not provide active asset management services itself and is fully

independent, guaranteeing its absolute neutrality and autonomy. A low risk profile is an integral part

of its services. KAS BANK focuses on value-added services in the field of treasury, risk control and

management information

Responsibilities:

Designed Star Schema/Diagrams using Fact, Dimensions, Physical, Logical and tables.

Imported and configured the OBIEE RPD Physical, Business Model and Presentation Layers

and published data in dashboards and Answers.

Creating reports and publishing them in the dashboards using answers

Used constrained filters, column filter prompts and various views such as Pivot tables

Developed Business 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 Dimensional hierarchies and level based measures

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

requirements.

Creating and managing variables, Initialization Blocks using Oracle BI Administration 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 Implemented

different views of report i.e. Pivot table, Titles, Graph, Filters 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.

Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of

a Repository by using Star Schemas.

Added Aggregate measures using Aggregate Persistence Wizard.

Project #3

Client : Telstar Telecom,Austrila

Role : OBIEE Developer

Duration : DEC’2010 to JULY’2012

Environment : OBIEE10g/11g, Informatica 7.1, Oracle 9i, UNIX

ProjectDescription:

Telstra Corporation Limited (ASX: TLS, NZX: TLS; known as Telstra) is an Australian

telecommunications and media company, building telecommunications networks and marketing voice,

mobile, Telstra was privatised in three different stages informally known as T1 ($3.30), T2 ($7.40)

and T3 ($3.60) respectively, Telstra is Australia's dominant and largest provider of Fixed Line

services. These include home phone, business and other PSTN, it’s positioning the Group strongly in

the Austrila largest markets for telecom. Telstar Analytics is implemented to calculate the sales and

revenues for its 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 functional

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 improved

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 Layer.

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 filters 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.

Contact this candidate