Manager Project

Avinash.M

Mail Id: *************@*****.***

Mobile: +91-995*******

SUMMARY:

Around 4 years of experience in Information Technology with strong working knowledge in Oracle Business Intelligence OBIEE 10.1.3.2.0, 10.1.3.4.0

Good Knowledge in Informatica 8.6.0 and DAC

Experience on OBIEE Administration Tool, Web, Answers, BI Publisher and interactive Dashboards.

Best practices understanding of creating Physical, Business Model and Presentation layers

Having experience OBIEE developing metadata repository and good experience in working with OBI answers and dashboards.

Good exposure on join manager, variable manager, cache manager and security manager in OBI administration tool.

Worked on Creation of Prompts, Filters, Hierarchies, and Level Based Measures etc.

Good Knowledge on OBIEE installation, configuration and good understanding of OBIEE Architecture and Development Process.

Knowledge on ETL process designing to load data from OLTP into OLAP structure.

Good Understanding of dimensional modeling/Data Warehousing concepts and techniques

WORK EXPERIENCE:

Working as Associate OBIEE Consultant for Genexinfo,Hyderabad from Jan 2010 to till date

Worked as a Associate OBIEE Consultant in Congruentindia, Chennai from Aug 2008 to Nov 2009

Educational Qualification:

B.Tech from JNTU, Hyderabad.

Technical Profile:

OLAP TOOLS : OBIEE 10x

Data Base Applications : SQL

Relational Databases : Oracle 10g

Operating Systems : Windows 2003

PROJECT EXPERIENCE:

Project #1

Project Name

Transportation Management

Client CEMEX, US

Role OBIEE Developer

Organization Genexinfo

Duration Dec’10 to (Till date)

Environment

(With skill versions) Database: Oracle 10g.

Tools: OBIEE 10.1.3.4

O/S: Windows 2003 Server.

Description:

CEMEX is a global building materials company that provides high quality products and reliable service to customers and communities throughout the Americas, Europe, Africa, the Middle East, and Asia. They produce, distribute, and sell cement, ready-mix concrete, aggregates, and related building materials in more than 50 countries, and they maintain trade relationships in close to 100 nations.

Responsibilities:

• Importing the metadata tables from the database to the OBI Administration Tool for customizing and modifying the Physical, BMM Layer and Presentation Layers of the metadata repository.

• Built the Star Schemas based on the functionality

• Creating physical joins in physical layer and Complex joins in BMM layer.

• Creating dimensional hierarchies and level based measures as per business requirements.

• Specified Aggregate levels for each source and created dimension sources for each level of aggregates.

• Created Time Series Wizard to compare the results for previous and current year/month/day.

• Creating users and groups assigning permissions depending on the user.

• Creating the requests in answers and see the results in various views like title view, table view, compound layout, chart, pivot table, ticker and static view.

• Creating reports and charts in Oracle BI answers added then to intelligence dashboards.

• Created page level prompts and dashboards level prompts.

• Used OBI for generating Sales Report, Which provides Web Based Reports for Executives and management individuals.

Project #2

Project Name SALES ANALYTICS REPORT

Role OBIEE Developer

Client MAPLINS, UK

Organization Genexinfo

Duration Jan’10 to Oct’10

Environment

(With skill versions) Database: Oracle

Tools: OBIEE 10.1.3.2 -

O/S: Windows 2003

Description:

This is a data warehousing application made for the analysis and reporting purpose of the sales and marketing company. The main objective of the project is to help the senior and middle level management of the organization to improve the sales and get the knowledge of the new business opportunities. Using this project we can generate various types of reports like best Employee Report, Best Customer Report, Best Product sold report, Best Promotion report, etc.

Responsibilities:

• Development of all layers of Oracle BI Administrator Tool, Physical, Business Model, and Presentation layer.

• Built the Star Schemas based on the functionality

• Creating physical joins in physical layer and Complex joins in BMM layer.

• Creating dimensional hierarchies and level based measures as per business requirements.

• Customization of Oracle BI Answers, Reports and Dashboards.

• Configuring Security and creating User’s Groups and setting Privileges.

• Defining Dimension Hierarchies for the Logical Dimension Table.

• Creating Presentation Catalogs with measures from Multiple Fact Tables.

• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.

• Implement data level security and object level security permissions/privileges as per role of each user.

Project #3

Project Name ASSET PROTECTION

Role OBIEE Developer

Client The Home Depot, US

Organization Congruentindia

Duration Aug’08 to Nov’09

Environment

(With skill versions) Languages: SQL

Database: Oracle 10g.

Tools: 10.1.3.2

O/S: Windows 2000

Description:

The Home Depot is the world's largest home improvement specialty retailer it has more than 2,200 retail stores in the across United States. Asset protection Project should create a fully automate reporting mechanism which should the business to analyze the report and make right decisions than spending the time to generate the report manually. Asset Protection reports are to be generated and stored onto a shared drive every week. Also, a consolidated summary of all resets are to be generated every month and distributed through email.

Responsibilities:

• Created OBIEE Repository (.rpd) which involves Schema Import, Implementing the business logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks and cache management.

• Designed and customized the logical star and snow flake schema by extending the Fact and Dimension tables.

• Successfully configured Interactive dashboards to alert the Business/Field users as per the requirements.

• Extensively used Presentation variables in FILTER function in the report, to filter each report based on the user requirements.

• Created various Static and Dynamic variables for different report

• Developed dimensional hierarchies based on the business requirement of an attribute

Contact this candidate