RESUME

Bezawada Gopi

EMAIL:acn3v1@r.postjobfree.com

MOBILE NO+91-886*******

Professional Summary:

. Having 4.6 years of experience as OBIEE 11.1.1.5, 11.1.1.6.0, which

include building and configuring repository, creating and managing

Oracle Intelligent Dashboards, oracle Answers, Oracle Delivers and

Oracle IBots/ Agents.

. Extensive expertise at developing and scheduling ad-hoc and

Analytics Reports using OBIEE/BI Analysis, Dashboards.

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

Oracle BI Analysis, Oracle BI Dashboards.

. Responsibility includes gathering business requirements, analysis,

design, data modeling, development, Client Interaction and

Compiling Specifications from client, Modification and Testing

. Extensive Knowledge in repository development, configured metadata

objects (Subject Area, Table, and Column) and web catalog objects

(Dashboards, Pages, Folders, Reports). Added Metadata changes to

the OBI .

. Self-reliant and Proactive to identify and understand business

problems and develop solutions.

. Knowledge in SQL, SQL*Plus

. Excellent problem solving skills with a strong technical background

and result oriented team player with excellent communication and

interpersonal skills.

Skill Set:

BI/Reporting Tools: OBIEE 11.1.1.5.0, OBIEE 11.1.1.6.0.

Data Modeling / ETL: Informatica Power Center 8.1.

RDBMS: Oracle 10g / 9i.

Database Tools: SQL*Plus.

Programming Languages: SQL.

Operating Systems: Windows XP / 2000 / 2003 / NT.

Qualification:

. B.Tech (Bachelor of Technology) from Jawaharlal Nehru Technological

University,Hyderabad in 2009

Professional Experience:

Organization Designation Duration

3i Infotech Limited OBIEE Developer Sept-2013 To Till

date

Tata Consultancy OBIEE Developer July-2010 To

Services Ltd. Aug-2013

Project Profile:

Project#1

Project Name Health Net

Client Health Net

Role OBIEE Developer

Organization 3i Infotech Limited

Duration Sept'2013 to till date.

Environment OBIEE 11g, Toad, Win XP, MS Office.

Description:

Health Net, inc .Is among the United States of America's largest

publicly traded managed health care companies. Health net's behavioral

health services subsidiary, MHN, provides behavioral health, substance

abuse and employ assistance programs (EAP)to approximately 7.3 million

individuals in various states, including the company's own health plan

members. The company's subsidiaries also offer managed health care products

related to prescription drugs, and offer managed health care product

coordination for multi-region employers and administrative services for

medical groups and self-funded benefits programs.

Role and Responsibilities:-

. Involved in requirements gathering, designing functional and technical

specification for reporting needs

. Perform Dimension modeling, Identify Fact tables & Measures,

Identify Dimension Tables to store business attributes, Perform data

modeling for proposed architecture

. Built reports and dashboards that leverage configured data model to

meet client's analysis business requirements

. Created and granted privileges for the users using Analytics

repository as well as presentation level privileges

. Configured Intelligence dashboards by adding included and embedded

content such as links/images, HTML objects and folders

. Cache management and enhancing query performance. Apply BI best

practices to enhance the performance of the application

. Implemented Event Polling table to purge the cache periodically

. Defined users, groups, access privileges and query privileges

. Created Agents and Delivers to send Alert messages to subscribed

users

Involved in Root Cause Analysis of issues and day-

to-day production support

Project #2

Project Name Abbott Laboratories.

Client Abbott Laboratories., U.S.A

Role OBIEE Developer

Organization Tata Consultancy Services Ltd.

Duration Feb'2012 to Aug'2013.

Environment OBIEE 11g, Toad, Win XP, MS Office.

Description:-

Abbott Laboratories is an American global pharmaceuticals

and health care products company. Abbott has a broad range of medical

devices, diagnostics products, including ensure, a line of meal replacement

shakes and EAS the largest producer of performance-based nutritional

supplements.

The company's in vitro diagnostics business is a world

leader in immunoassays and blood screening. Its broad range of medical

tests and diagnostic instrument systems are used worldwide by hospitals,

laboratories, blood banks, and physician offices to diagnose and monitor

diseases such as HIV, hepatitis, cancer, heart failure and metabolic

disorders, as well as assess other indicators of general health. Abbott

point-of-care manufactures diagnostic products for blood analysis to

provide health care professionals critical diagnostics information

accurately and immediately at the point of patient care. Abbott also

provides point-of-care cardiac assays to the emergency room.

Role and Responsibilities:-

. Extensively worked on Answers, Dashboards and Security for

users and creating complex reports.

. Worked extensively on various Cache Management techniques to

increase the performance of the both Real-Time and Non Real-

Time reports.

. Created various Static and Dynamic variables for different

report and Security requirements.

. Administered NQSCONFIG.INI and Instanceconfig.xml

configuration files.

. Configured implicit fact columns. Enabled and administered

Usage Tracking by using direct insert method.

. Configured Delivers- iBots to alert the users based on the

requirement.

. Configured issues with Oracle HR Analytics

. Worked on the Time Series Wizard and implemented time

comparison measures.

. Used Column Filter Prompts and provided Dashboard Prompts

appropriately to avoid excessive data showing up Reports.

. Used various transformations Source qualifier, Aggregators,

Connected & Unconnected lookups, Filters & Sequence for

mappings based upon the requirement.

Project #3

Project Name Inventory Management System

Client Canon.,USA

Role OBIEE Developer

Organization Tata Consultancy Services Ltd.

Duration July'2010 to Jan'2012.

Environment OBIEE 11g, Toad, Win XP, MS Office.

Description:

The objective of this project is to provide complete historic

information related with an electronic industry called as "Canon" which was

dealing with sale of nearly 45 electronic products of various vendors. And

it has all the data of this products, vendors and customers in various OLTP

systems of Oracle and certain data in the form of flat files. The Data

Warehouse that has been developed consists of all this Data marts mentioned

above and different types of reports have been developed for analysis

purpose.

Role and Responsibilities:-

. Worked closely with Business Analyst in understanding the

Analytics requirements and generating reports as per the user

requirements.

. Used Analytics Web Catalog to set up groups, access privileges,

migrating reports from dev to production and query privileges.

. Designed and Configured Dashboards in Analytics for different

groups of users to view figures across regions, products with

the facility to drill down to individual customer relationship

manager.

. Developed Role-Based Dashboards for Managers and Business Heads

to review the Forecasts vs. Revenues and Contact Relationship

Management (CRM) to analyze the financial service center

statistics for different campaigns, Customized pre-built

dashboards.

. Analyzed and validated the business model in OBIEE Analytics

Administration tool by performing consistency check validating

logical source tables logical columns and also validating

repository level calculations done in the business model layer.

. Developed custom reports/Ad-hoc queries using OBI Answers and

Filters.

. Implemented the delivery of iBots using OBI Delivers to alert

the associated teams.

. Responsible for Unit and System Testing and Performed Data

Validation for all the reports that are generated from OBIEE.

Contact this candidate