Cell No: 832-***-**** Bhavani Yarlakula

Email: abn1r1@r.postjobfree.com

Summary:

. Over 6 years of work experience in the IT, acquiring both technical

and functional skills

. Over 5 years' experience in Business Intelligence projects that span

the full life cycle implementation of Oracle Business Intelligence

(Siebel Analytics), Informatica and Data Warehousing

. Expertise in building repositories, developing Subject Areas, and

applying security at object and data level in Administration Tool

. Strengths include Seibel Analytics development and Administration,

attention to detail and problem solving

. Expertise in analyzing and designing customized analytical reports and

creating Interactive Dashboards with drill-down capabilities using

OBIEE

. Expertise in creating complex reports in Answers using various views

. Extensive experience in creating iBots and scheduling them using

delivers

. Designing the report layout templates in the BI Publisher

. Extremely strong in OBIEE Metadata development

. Expertise in OBIEE DAC configuration

. Strong understanding of data modeling and dimensional modeling, and

designing Kimball's Star and Snowflake schemas

. Good at understanding business requirements and translating them into

data warehouse dimensional modeling

. Significant experience with ETL/Data Integration using tools such as

Informatica

. Expertise in analyzing business issues and providing possible

reporting solutions to end users

. Expertise in providing end-to-end user training and support and

provided detail documentation

. Excellent analytical, problem solving skills and a motivated team

player with an excellent inter-personal skills and familiar with

offshore and multi site development

Technical Proficiencies:

Reporting Tools OBIEE 11.1.1.6,OBI EE 10.x (Administration Tool,

Analytics, Answers, Dashboards, Delivers and BI

Publisher), BI APPS 12.1.2, Hyperion OBI SE 10.x

(Discoverer) and Siebel 7.x (Administration Tool and

Analytics)

ETL Informatica (Power Center 8x/7.x/6.x), ODI

RDBMS Oracle 11g/10g/9i, MS SQL Server 2000/2005, MS Access,

Teradata and DB2 UDB 9.x/8.x

Languages/ SQL, PL/SQL, HTML and XML.

Technologies

Operating Systems Windows XP/2000/NT 4.0/Vista, UNIX, Sun Solaris and

Linux.

Tools Erwin 4.0, Oracle JDeveloper 11g/10.1.3.3, Autosys, Tidal

Enterprise Scheduler, and MS Visio.

Education:

Bachelors of Science in Information Technology

Southern Polytechnic, State University of Georgia, GA

Professional Experience:

Client: National Industries for the Blind, VA

Aug' 10 - Till' Date Role: OBIEE Specialist/BA

National Industries for the Blind provides opportunities for economic and

personal independence of persons who are blind, primarily through creating,

sustaining and improving employment.

Environment: OBIEE 10.1.3.2.1/ 11.1.1.6, Oracle EBS 12.1.2, BI Applications

7.9.4(Financial analytics, Order Management), Oracle 10g/11g, SQL

Developer, SQL Server 2005 and Windows 7

Responsibilities

. Gathered the requirement from user through meetings, understanding the

business from end user technical perspective and preparing a

functional design document.

. Involved in integrating OBIEE with Oracle E-business suite

. Involved in Migration of OBIEE 10g to 11g

. Worked with business and finance stakeholders to develop BI Portals

and reporting solutions

. Conducted project planning and work estimations

. Created an Logical Star Schema in OBIEE

. Independently Designed and developed subject areas in the RPD

. Mapped different data sources to the Physical Layer and created the

Business Model and Mapping Layer (design of hierarchies, dimensions,

and aggregates)

. Define appropriate joins, calculations, dimensions and measures in the

repository

. Wrote Custom SQL Codes (Views) for the reports

. Created and customized various Reports and Dashboards for various user

groups

. Designed and Tested Reports in the Dashboards for the Oracle Financial

Analytics modules like GL, AP, AR and created the Ad-hoc report

according to the client needs

. Designed various reports as per the requirements for user interface

design like Drill Down, Pivot, Break down Reports, Narrative and

Nested reports in Answers

. Developed and scheduled iBots for delivering personalized reports to

users on time

. Migrated RPD and Catalog from DEV to TEST to PROD

. Secured Dashboards and Reports by defining user roles

. Implemented OBIEE security at the data and object levels

. Created Repository Users/ Groups and Web Groups and assigned

permissions to the user groups to define security in the repository

. Managed security privileges for each subject area and dashboards

according to user requirements

. Applied Optimization techniques and tuned performance of the reports

such as caching and building summary tables

. Created Materialized Views to improve the performance of the reports

. Applied Patch

. Created user manuals and troubleshooting guides

. Responsible for supporting and enhancements of OBIEE

. Trained End Users to Build Ad Hoc Reports using OBIEE

Client: CMAX Inc. Cleveland, TN

Aug'09 - June'10

Role: OBIEE Report Developer

A high performance, integrated application for companies in the deferred-

deposit market and financial technology solutions that drive customer

relationship management, electronic banking, and electronic funds transfer

and card solutions

Environment: OBIEE 10.1.3.4.1, Oracle 10g Windows 2003 Server and Linux.

. Participated in the installation and configuration of Oracle BI EE in the

windows as well as the Linux environment

. Involved in analysis and requirements gathering of the various work

streams by meeting with the business user and base lining the details

. Involved in the detailed design of the reports/dashboards and data model.

. Managing the intelligent dashboards by using dashboard, page and report

level security.

. Worked Extensively on Siebel Answers to create reports as per the client

requirements.

. Developed custom reports using Seibel Answers and assigned them to

application specific dashboards.

. Developed different kinds of Reports (pivots, charts, tables/compound

layout) using global and local Filters.

. Implemented the delivery of iBots using Oracle BI Delivers to alert the

associated teams and Agency personnel also used iBots for Cache Seeding

and Cache purging.

. Implemented Object Level Security for the objects like Dashboards and

Reports, and Data Level Security for Region and Product dimensions, using

Session Variables.

. Performed Unit Testing, Integration Testing, and User Acceptance Testing

(UAT), to validate reports, and played an active role in product

rollouts.

Client: United Health Care, CT

Oct'08 - June'09 Role: Oracle BI Analyst.

United Health Care Company provides innovative health benefit plans, dental

and vision pharmacy benefits management services. This project was intended

to implement OBIEE and to develop reports for Financial Department.

Environment: OBIEE 10.1.3.2.1, HR Analytics, BI Publisher, Oracle 10g and

Windows 2003 Server

Responsibilities

. Gathered and analyzed reporting requirements for the claims and payment

departments

. Involved in Data Modeling, Design Documents, and data warehouse

. Conducted project planning and work estimations

. Responsible for supporting and enhancements of OBIEE

. Hands on experience in data warehousing technologies including ETL,

Oracle BI Server architecture, and metadata management

. Created an Logical Star Schema in OBIEE

. Independently Designed and developed subject areas in the RPD

. Mapped different data sources to the Physical Layer and created the

Business Model and Mapping Layer (design of hierarchies, dimensions, and

aggregates)

. Define appropriate joins, calculations, dimensions and measures in the

repository

. Migrated and moved Webcat files to obiee using saw migrate tool

. Created Repository Users/ Groups and Web Groups and assigned permissions

to the user groups to define security in the repository

. Created and customized various Reports and Dashboards for various user

groups

. Designed various reports as per the requirements for user interface

design like Drill Down, Pivot, Break down Reports, Narrative and Nested

reports in Answers

. Created reports with different views (Compound, Chart, Table, Pivot,

Ticker and Narrative)

. Developed and scheduled iBots for delivering personalized reports to

users on time

. Secured Dashboards and Reports by defining user roles

. Implemented OBIEE security at the data and object levels

. Created report templates using BI Publisher

. Developed BI Publisher Reports and published them on dashboards

. Integrated BI Publisher with concurrent manager within Oracle E-business

suite

. Configured Repositories on XMLDB on file systems

. Extracted data from multiple Databases in the same report

. Created Reports using BI Publisher for Word, Excel and Pdf

. Applied Optimization techniques and tuned performance of the reports such

as caching and building summary tables

. Created user manuals and troubleshooting guides

. Trained End Users to Build Ad Hoc Reports using OBIEE

Client: SBC-Ameritech, IN

Aug'07 - Sep'08

Role: Siebel Analytics Lead

SBC-Ameritech provides local telephone/data services in mid-west region.

This project was intended to develop reports for the Human Resources

Department.

Environment: Siebel Analytics 7.8.2, OBIEE 10.1.3.2.0, HR Analytics, BI

Publisher, Informatica Power Center 7.1.3, Oracle 10g, Teradata and Linux

Responsibilities

. Gathered information by interacting with clients and end users.

. Involved in full Life Cycle Implementation of OBIEE

. Upgraded and migrated Siebel repository (.rpd) database from Siebel

Analytics7.8.2 to OBIEE

. Designed and build Star schemas

. Configured repository (RPD) to use the LDAP authentication

. Define the mapping from various physical databases to Business Layer to

create the various subject areas in Presentation Layer

. Defined dimensions and facts in the subject areas

. Involved in migration of reports from production to testing using Webcat

. Implemented OBIEE security for users and groups in administrator tool

. Created report templates using BI Publisher

. Developed BI Publisher Reports and published them on dashboards

. Integrated BI Publisher with concurrent manager within Oracle E-business

suite

. Configured Repositories on XMLDB on file systems

. Extracted data from multiple Databases in the same report

. Created Reports using BI Publisher for Word, Excel and Pdf

. Created reports by applying views, filters, calculations and conditional

formatting in answers

. Designed Intelligent Dashboards for different user groups to view updated

KPIs

. Created and scheduled iBots as per the business requirements

. Participated in the Modeling of several multidimensional Data Marts

including surrogate key design and index placement

. Created the source and target instances and various transformations

(Joiner, Aggregate, Lookup, Filters and Router Transformations) in

informatica and also created mappings, sessions and workflow to run ETL

process using Informatica Power Center

. Used DAC (Data Warehouse Administration Console) Client to manage,

configure, customize and monitor ETL process

. Applied Optimization techniques and tuned performance of the reports

. Provided technical and user documentation and training

Client: Internet Securities Inc, Manhattan, NY

Mar'06 - July'07

Role: Siebel Analytics Developer

ISI Company is an online emerging markets information service. It

aggregates and produces unique content including full-text news articles,

financial statements, and company information. This project was intended to

work on Sales and Marketing Department.

Environment: Siebel Analytics 7.5.2, Oracle 9i, PL/SQL and Windows 2000

Responsibilities

. Gathered and refined requirements from the business users

. Installed and configured Siebel Analytics

. Configured the Siebel Analytics repository (rpd) to implement

organization wide data-level security

. Imported metadata in to the Physical layer, applied Business rules in the

Business Modeling and Mapping layer, and created customized user views

and set up catalog folders in the Presentation layer using administrator

tool

. Developed Star schema as per business requirements

. Designed and Developed new subject areas/ Customizations.

. Interacted with users, developed and maintained Reports and Dashboards

. Resolved application issues faced by users

. Configured Analytics Dashboard HTML style sheets to meet reports layout

requirements

. Configured Analytics iBots and the Scheduler

. Responsible for Daily/Weekly/Monthly on time report delivery to the end

users

. Developed front end reports

. Configured report level security and user interface designs

. Applied Optimization techniques and tuned performance of the reports

. Implemented caching to improve performance

Contact this candidate