Data Project

B.TECH from J.N.T.University with distinction.

Project 1:

Client: Andrew Peller, Canada Role: OBIEE

Developer

Environment: OBIEE 11g, Financial Analytics, Oracle, Oracle E-Business Suite and Windows

7.

Description: Andrew Peller has begun in 1927 when Andrew Peller first arrived in Canada from

Hungary. Having owned a series of successful businesses, he came here to finally pursue his dream. In

2006 marked the 46 year history of the company and a corporate name change from Andrés Wines Ltd.,

to Andrew Peller Limited was completed in honor of the company's founder Andrew Peller. And here

wine making is going on and vintage will be placed on every wine bottle .

Responsibilities:

Direct Interact with different QA teams and program managers located at different

locations in onshore and offshore before delivering fix packs to customers ensuring

quality of fix packs.

Created calculated logical columns according to business requirements.

Object and Data level Security Implementation

Created Logical Columns based on other Logical and Physical columns in the BMM

layer

Customized users, groups and assign privileges for the users to access the data from the

warehouse.

Customized the repository and created new requests using Answers.

Identified the granularity level of the business model based on the end user requirements.

Created Complex Joins, Alias Tables and Views.

Defined Primary key - Foreign key relationships, complex joins between dimension tables and

Fact tables in the physical layer and BMM layer

Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance gains.

Created multiple aggregated tables and setup aggregated navigation to enhance performance.

Extensively used Repository Variables, Session Variables and Initialization Blocks for

Configuring the Data and User Security.

Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services

Web Catalog.

Created presentation layer with catalog folders, to show different views of the business model to

different users and group assigned permissions to the catalog folders.

Extensively worked on Combine Similar Request features in Answers to satisfy critical report

requirements

Enabled Caching for want better performance and implemented Event Pooling for Automatic

Purging of Stale data.

Project 2:

Present Client: Western Digital, Malaysia. Role: OBIEE

Developer

Environment: OBIEE 11g, Oracle, Oracle Ebs and Windows 7.

Description: We are thousands of people worldwide working to enable you to store, collect, access and

use a vast and growing body of digital information. Especially science, Technology, Engineering and

Math; Basic needs programs, especially those leading to economic self-sufficiency; and Civic programs,

with an emphasis on environmental protection and community volunteer projects.

Responsibilities:

Interacted with Procurement and Operation/Maintenance business representatives for

gathering the OBIEE Reports/ Dashboards requirements and to define business and

functional specifications.

The Inventory Dashboard provides insights into by using supply chain analytics

Fast moving items of various category

Transaction by plants and warehouses

Component Utilization

The Order Management dashboard provides order statistics, insights and trends.

Analyzed and used various data sources- Oracle and Excel.

Identified Facts and Dimensions levels/ Hierarchies of Dimensional model.

Customized and developed RPD (Physical, Business model and Presentation Layer),

configured metadata objects and Web Catalog Objects.

Developed many reports/dashboards Analytic views (Pivot Tables, Charts, Column

Selector, and View Selector).

Created measures and level Based measures in Business Model

Created logical Tables and logical columns, Physical Columns.

Created measure with Logical Columns and Physical Columns.

Object and Data level Security Implementation

Created Dimension hierarchy in Business model layer.

Performance tuning of Dashboard/Reports and made changes to database by

implementing materialized views and partitions, rebuilding of indexes.

Created Saved Filters for all Common filters to be reused in reports

Created different types of variables like Presentation, Session and Repository Variables.

Created users and Groups assigned privilege’s to them.

Involved in creating reports using OBIEE Answers using forced selection prompts, common go

button for multiple prompts, guided navigation, GO URL and many other features.

Extensively worked on Combine Similar Request features in Answers to satisfy critical report

requirements.

Project 3:

Client: NBTY, USA. Role: OBIEE Developer

Environment: OBIEE 11g, Oracle, Oracle Ebs and Windows 7.

Description: NBTY, Inc., formerly known as Nature's Bounty, Inc., is an American manufacturer of

vitamins and nutritional supplements which are distributed under many third party brands in the United

States and internationally. Its name was changed from Nature's Bounty, Inc. to NBTY, Inc. in 1995.

NBTY distributes its products to supermarkets, drug store chains, mass merchandisers, club

stores, and health food stores under various brand names, as well as selling direct-to-consumer. Some of

their more recognizable brands include Nature's Bounty, Sundown Naturals, Puritan’s pride,Vitaman

world, Osteo-Bi-Flex, Balance Bar, MET-RX, and GNC (UK). Other brands owned by NBTY

include Holland & Barrett (UK),Rexall, Solgar, Precision Engineered, WORLDWIDE Sport Nutrition,

American Health, DeTuinen, LeNaturiste, Flexamin, Knox, Herbal Authority, Doctor's Trust and Leiner

Health Products.

Responsibilities:

Provide support in the development OBIEE components and solutions

Understand project requirements and work towards design and development of the plan

layout

Develop and deploy dashboards, analytics and reports properly

Design and develop data modeling concepts using various data modeling tools like star

schema and dimensional modeling

Design and place data in layers varying to Physical, business and presentation

Work with administrators, users and analytics to maintain exchange of reporting

requirements.

Use the best practices of business intelligence to meet project and company objectives

Identified the production faults and critical issues followed and troubleshoot them.

Provide remedial measures to the production issues or process failure

Train the administration team on OBIEE,BI and ETL tools

Prepare monthly reports and present it to the management.

Contact this candidate