Project Developer

NAME : N.Satyakumar

MOBILE NO:+91-850*******

EMAIL :ab07ey@r.postjobfree.com

PROFESSIONAL SUMMARY:

Having 3+ year of total IT exp in the Business Requirements Analysis,Aplication Design,Development

and Implementations of DataWarehousing,web Based Applications.

KEY SKILLS:

Have good knowledge and experience in the areas of Data Warehousing Concepts & Report

development.

Extensive expertise at developing and scheduling ad hoc and canned Analytics Reports using

OBIEE/BI Answers, Dashboards.

Responsibilities included Building of RPD application design for Physical, Logical, and

Presentation layers, configuration of those layers, development of Reports, Dashboards,

Publisher and testing, and deployment.

Translating business requirements into logical business dimensional model. Defining various logical

subject areas and organization of Presentation Layer metadata; Understanding and defining key

metrics, dimensions, hierarchies and attributes.

Developed various reports based on different Views in OBI Answers and developed Dashboards.

Good knowledge of how business processes work and interact.

Proficient in using the following tools: Oracle BI Administration, Oracle BI Answers, Oracle BI

Dashboards.

Self reliant and Proactive to identify and understand business problems and develop solutions.

PROFESSIONALEXPERIENCE:

Designation Duration

WIPRO OBIEE Developer May’ 2012 To Till date

iQuest Developer April’ 2010 To May’ 2012

PROJECT PROFILE:

Project#1

Project Name OLAP for Hospital Management System

Lambton Hospitals Group, U.S.A

Client

Role Developer

May’2012 to Till date

Duration

Oracle 10g, OBIEE 10.1.3.4, Windows XP, OBIEE 10.1.3.4, SQL,

Environment

Windows XP.

(with skill

versions)

Description:

OLAP project for Hospital Management system provides analysis reports dealing with usage and

allocation of hospital resources. Designed to help management to estimate the processes for

admission and discharge times and tracks delay in both the cases. This is helpful for doctors who

are busy, to find all the information about wards and about patients.

Role and Responsibilities:

Studying the Sources data based upon the Functional Specification given by the onsite

team, and preparing the LLD’s.

Developed new Repository.

Created Views for Reporting.

Using the OBIEE Administration tool to import data and enhance meta-data to Build

Business model.

Organize presentation layer in a format that is easy for end user to use as basis for

reporting.

Developing custom Dashboards and Reports using Answers. Created Prompts, Filters,

Charts, Pivot Tables and Views as per client requirement.

Developed report with conditional filters.

Developed reports with prompts.

Developed Drill Down reports

Project #2

Project Name Data warehouse for Alembic Labs

Alembic Labs

Client

OBIEE DEVELOPER

Role

Duration Apr’2011 to may’2012

Environment Oracle 10g, OBIEE 10.1.3.4, SQL,Windows XP,

(with skill

versions)

Description:

Alembic is a very large pharmaceutical company lab with global clients spread across 55

countries. It is leading lab in India. Alembic lab deals the business with distributors. The

distributors categorized based on the region. Each distributor contains certain number of

customers, who are customized in two groups based on their transaction level; those are regular

and non-regular customers. The regular customers invoice preparation done b checking of their

credit limit and debit notes. The non-regular customer invoice preparation had done b checking

of their debit amount only.

The project aimed at providing a single source of truth for enterprise

reporting for the crucial business data. As a first step, ETL was developed. The outcome of the

ETL is asset of de-normalized tables. These tables were then used as source for reporting.

Reporting was done based on obiee products.

Responsibilities:

• Extensively worked on understanding the Business Requirements and designing

• applications to meet their needs.

• Creating and managing Metadata Models for report authors for creating ad-hoc

reports .

• Creating new and arranged in different Folder Structure for Business View.

• Used Reports to develop various types of reports like List Reports, Cross-tab

Reports, Chart Reports, Repeaters, and Master Detail Reports

Project#3

Project Name Welch Foods Inc.

Welch Foods Inc., U.S.A.

Client

Developer

Role

Duration Apr’2010 to mar’2012

Environment Languages: SQL

(with skill Database: Oracle 9i

versions) Tools: Informatica 7.1.2 and Obiee 10x

O/S: Windows 2003 Server and HP UNIX

Description:

Welch's is the food processing and marketing arm of The National Grape

Cooperative Association, which comprises 1,300 grape growers located in various states in USA. The

company also manufactures and markets an array of other products, including refrigerated juices, frozen

and shelf stable concentrates, organic grape juice and dried fruit. Welch's has also licensed its name for

the Welch's line of grape flavored soft drinks, since 1974.

Role Involved:

Installed and configured OBIEE Admin tool and web components including Intelligence

Dashboards, answers, and requests.

Used admin tool to creation of repositories by using physical layer, business model and mapping

layer and presentation layers.

Worked on BMM layer to customize the tables, hierarchies, dimensions and aggregations and

calculations.

Tested and validated the unit test cases

Organized and customized the presentation layer in a format that is easy for end user to use as

basis for reporting

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.

Designed and 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.

Using the Presentation Variable in prompts Report filters.

Contact this candidate