. Over * years of IT experience in Data Warehousing, Business

Intelligence and Analytics, Data and Systems Analysis, Project

Coordination across various domains.

. Over 5 years of experience in Dashboard and Reports design,

Development, Tuning and Leading Developmental Effort for various

Business Intelligence Applications using OBIEE+.

. Extensive knowledge in configuring Interactive Dashboards with drill-

down capabilities, Security Setup (groups/access privileges),

Metadata, Web Catalog Objects (Folders, Dashboard, Pages and

Reports).

. Expert in configuring and managing OBI Server, Oracle BI Answers and

Dashboards; iBots, Publisher, OBIEE plug-ins, BI Publisher and

configuration of Analytics Metadata objects.

. Expertise in development of Reports / Dashboards with different

Analytics Views (HTML/Dynamic, CSS, Pivot Table, Chart, Column

Selector, Tabular with global and local Filters) using Siebel

Analytics Web.

. Knowledge in dealing with various OBIEE functionalities like Dashboard

prompts, views, aggregates, global filters, scheduling,

contextual/guided navigation, conditional formatting of reports to

satisfy the end users.

. Hands on Experience developing with BI Development in Physical,

Business Model and Presentation Layers. Expertise with BMM development

- Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series,

Cache Management.

. Sound understanding of various aspects of ETL Development in various

platforms like Informatica/Data Stage

. Experience with Conceptual, Logical and Physical Data Modeling.

Experience creating and maintaining Data Dictionaries/Metadata

Repositories.

. Excellent Business Analysis Skills. Expertise creating High Level

Requirements Document, Technical Specifications Document. Experience

creating and managing Requirements Traceability Matrix.

. Experience gathering requirements from both Business and Technical

Users. Experience writing use cases and test cases.

. Experience in Oracle BI Apps that include OBIEE/Siebel Analytics, ETL

Tools and DAC in HR, Sales & Marketing domains.

. Experience with SQL tuning, writing complex SQL queries, triggers and

stored procedures. Hands on exposure in the RDBMS development with

Oracle 9/10/11.Involved in Unit Testing, Integration Testing and User

Acceptance Testing.

. Well acquainted with Software Development Life Cycle. Excellent team

player with problem-solving and trouble-shooting capabilities.

. Excellent written and spoken communication skills

TECHNICAL SKILLS

|BI Tools |OBIEE 11g, OBIEE 10.1.3.4/3.3/3.2, Siebel Analytics 7.5/7.7/7.8 |

|Data |Informatica Power Center 8.1.1/8.0, Workflow Manager, Workflow |

|Warehousing |Monitor, Power Mart |

|Languages |SQL, PL/SQL, UNIX Shell |

|DB Tools |Erwin, Toad, Oracle Applications/ EBS, SQL Plus |

|Databases |MS SQL Server 2008/2005, Oracle 10g/9i, MS Access, Teradata, |

| |DB2, UDB |

|Environment |Win Server 2008/2005,Win NT, Win XP, Unix, LINUX |

TMG HEALTH, PA

Jul'11 - Present

Sr. OBIEE Developer

Data warehouse/Business Intelligence project is TMG initiative for better

streamlined process and faster decision making. The primary objective is to

initiate the delivery of analytics through the new tools and architecture

in each of business units Claims, Enrollment, and Customer Service. Initial

launch of the OBIEE generated Internal Dashboards included Route

Management, and Call Center, Enrollment, Eligibility, and Claims Key

Performance Indicators and also includes deployment of the Internal Member

End-to-End Report for Additional Clients. Developed DW/BI 2.0 with the

objective to build on the Vision and Strategy established in the earlier

efforts and provide additional analytics to the participating business

units including real-time analytics

Responsibilities:

. Created Repository and OBIEE reports for Enrollment, Claims, Customer

Service and Routes

. Worked on the OBIEE Dashboards and reports based on the requirements

and specifications given by Business analysts.

. Involved in Business Model Design and development for Enterprise Data

Warehouse.

. Designed Star schema for fact & dimensional tables and created alias

for the dimensional tables when necessary. Defined the Foreign keys

and Complex joins between various Dimension and Fact Tables at BMM

layer.

. Installed and Configured OBIEE 11.1.1.5 on Win Server 2008 and

configured for SQL Server 2008 as Data Warehouse

. Integrated Windows Active Directory authentication LDAP with OBIEE

including the security levels at group level.

. Modeled the Logical Layer based on the Business requirements in the

Business Mapping and Modeling Layer and Developed the necessary Star

Schemas.

. Implemented the OBIEE upgrade process from OBIEE 10.1.3.4 to OBIEE 11g

for better support for real time decisions

. Developed a Roadmap for the Client Dashboard and work with Client

Partner to deploy a beta dashboard

. Created Aggregates, Hierarchies, Calculation wizard in the Logical

Layer.

. Worked for performance tuning by finding out the bottlenecks in

Reports.

. Involved in Migration in Development, Testing and Production

environment. Provided End User Training and documentation for DWH-BI

Project.

. Developed security matrix for dashboards/Answers users based on

Individual responsibilities and LDAP Authentication type.

. Customized/Created presentation layer catalog folders, to show

different views of the business model to different users and assigned

group permissions to the catalog folders.

. Worked with BI Office plug-in to export analysis to Excel format.

. Implemented Usage Tracking for better administration and auditing

purposes.

. Worked with BI Publisher 11g for document composition and delivery.

Environment: OBIEE 10g, OBIEE 11g, XHTML, OBIEE+, Windows Server 2008,

Informatica 8.6.1, Weblogic Server, CSS, JavaScript, PL/SQL

AXA Equitable, NJ

Jul'10 - Jun'11

Sr. OBIEE Developer

Retirement GatewaySM provides the flexibility that accommodates clients'

desires to provide customized plans for their employees. In addition to the

traditional 401(k) plan, Retirement GatewaySM supports Safe Harbor 401(k)

and age-weighted/new comparability 401(k) plans, as well as profit-sharing,

money purchase and defined benefit plans. The platform provides extensive

online reporting capabilities and access plan reports, forms and other

information.

Responsibilities:

. Installing and Configuring OBIEE 10.1.3.4. Including the security

levels at group level.

. Worked on the OBIEE Dashboards and reports based on the requirements

and specifications given by Business analysts.

. Implemented Physical Meta Data from Various Data sources into the

Physical Layer by defining the connection pool settings

. Designed Star schema for fact & dimensional tables and created alias

for the dimensional tables when necessary. Defined the Foreign keys

and Complex joins between various Dimension and Fact Tables at BMM

layer.

. Modeled the Logical Layer based on the Business requirements in the

Business Mapping and Modeling Layer and Developed the necessary Star

Schemas.

. Worked with HTML, CSS and JavaScript to customize the dashboard look

and feel.

. Worked on various Oracle Business Intelligence application modules (BI

Apps).

. Created Aggregates, Hierarchies, Calculation wizard in the Logical

Layer.

. Worked on the Time Series Wizard and implemented time comparison

measures.

. Extensively worked on global filters for use in exercising dashboard

wide control over requests that are embedded into a dashboard page.

. Created complex reports by using Set operations and direct database

request.

. 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. Customized

reports with CSS, JavaScript as needed.

. Worked for performance tuning by finding out the bottlenecks in

Reports.

. Involved in Migration in Development, Testing and Production

environment

. Involved in Unit/Integration testing and documentation.

. Developed security matrix for dashboards/Answers users based on

Individual responsibilities and LDAP Authentication type.

. Customized/Created presentation layer catalog folders, to show

different views of the business model to different users and assigned

group permissions to the catalog folders.

. Worked with BI Office plug-in to export analysis to Excel format.

Environment: OBIEE 10g, XHTML, Oracle BI Applications, OBIEE+, Windows

Server 2008, Informatica 7.1, BI Apps, Siebel Analytics 7.8, OC4J Server,

CSS, JavaScript, PL/SQL

conEdison, NJ

Jan'09 -Mar'10

OBIEE Developer

conEdison provides a wide range of energy-related products and services to

its customers. conEdison uses Oracle Business Intelligence Applications for

business analytics and reporting. The project involves customizing the

existing BI apps to suite the business requirements and implementing the

data loads workflows through DAC.

Responsibilities:

. Designed, implemented and Customized Metadata and Dashboards/Reports

using the Oracle BI Analytics platform (OBIEE+).

. Imported Schema from Data warehouse and created OBIEE. Designed

Dimensional Hierarchies, Aggregate Navigation as per requirements.

. Implemented Dashboards and reports using Level Based Measures,

Security Management

. Implemented OBIEE delivers, created Proactive agents and configured

Interactive dashboards to alert the Business users as per the

requirements.

. Created various custom requirements for BI apps for GL, HR, and AP

etc.

. Worked on security for users and groups based on the individual and

group responsibilities.

. Worked on Analytics Web Catalog to set up groups, access privileges

and query privileges.

. Designed templates and created reports using BI Publisher. Developed

dimensional hierarchies based on the business requirement of an

attribute.

. Worked on Aggregates, Hierarchies, Calculation wizard in the Logical

Layer.

. Used and configured iBots alerts for reports to be delivered by email.

. Created custom Ad-hoc queries using Seibel Answers and assigned them

to dashboards and reports

. Maintaining the Full and Incremental loads through DAC on different

environments like Development and Test environment.

. Involved in extracting data from Transaction System (OLTP) into

Staging Area and Identifying Facts and Dimensions tables.

. Worked in Performance Tuning at sources, targets and sessions

performance of data load and queries.

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

query privileges.

. Designing mapping templates to specify high level approach. Designed

and developed UNIX scripts for creating, dropping tables used for

scheduling the jobs.

. Designed and Developed PL/SQL Procedures and UNIX Shell Scripts, Data

Import/Export and Conversions.

. Created Test Cases and Test Scripts. Involved in Unit testing and

documentation.

Environment: OBIEE 10.1.3.2, Siebel Analytics 7.8.5, Informatica Power

Center 7.1, Erwin, Oracle 10g, Oracle R12 TOAD, DAC, MS SQL Server 2005,

UNIX, Oracle SQL, BI Publisher, LINUX, Oracle Apps

Dell Petrot Sys, VA

Feb'08-Dec'08

OBIEE Developer

Dell Petrot systems had taken new data warehousing initiative and OBIEE was

chosen as the reporting platform. The project involved creating a

centralized Enterprise Data Warehouse and creating reports for HR/Call

center subject Area.

Responsibilities:

. Involved in Migration of Analytics Application in Dev, Test and UAT

Environments.

. Defined Connection pool settings and imported the Physical Meta Data

from Various Data marts into the Physical Layer for Call Center

Subject Area.

. Worked on Aggregates, Hierarchies, Calculation wizard in the Logical

Layer.

. Created Simple and Complex joins in various OBIEE Layers in addition

to defined the Primary, Foreign keys

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

. Managed security privileges for each subject areas and dashboards

according to user requirements.

. Customized/Created presentation layer catalog folders, to show

different views of the business model to different users and assigned

group permissions to the catalog folders.

. Created various narrative views, pivot views, chart views of the data

returned by the request.

. Embedded content such as links/images and HTML objects to create

Intelligence dashboards.

. Implemented drill-down, guided navigation and Dashboard prompts in

making interactive and effective dashboards and reports

. Used the Catalog manager and maintained the Analytics web catalog to

manage Dashboards, Answers.

Environment: OBIEE 10.1.3.2, Siebel Call Center, Siebel Tools, DB2,

Informatica 7.1, PeopleSoft, Oracle 9i, Windows 2k

Citrix, FL Nov'06-

Jan'08

Siebel Analytics Developer

Citrix Systems provides server and desktop virtualization, networking, SaaS

and cloud computing products and services. The project was about upgrading

the existing reports from Siebel Analytics to OBIEE.

Responsibilities:

Involved in migration and upgrading from Siebel Analytics to OBIEE.

Extensively used upgrade tools in the process.

Worked with Informatica for transformation and mapping in ETL process.

Designed and developed project document templates based on SDLC

methodology.

Designed and developed all Use Cases.

Helped the testing team documenting the system requirements and

testing system development

Designed and implemented basic SQL queries for QA testing and report /

data validation.

Set up definitions and process for test phases including Product test,

integration test, system test and user acceptance test (UAT).

As necessary, assisted with the process of identifying and

recommending vendors and assisted with the vendor relationships.

Biweekly status reporting with other team project managers involved in

this project.

Environment: Siebel Analytics, OBIEE 10.*, Informatica 7.1.4, Oracle 9i

(SQL, PL/SQL), UNIX, Windows XP

MindTree, Bangalore India

Jun'04-Sep'06

SQL Developer

MindTree is an international information technology (IT) consulting and

implementation company. I was working in the DBMS team for Oracle platform

and coordinating with the clients in their database requirements.

Responsibilities:

. Created various scripts to populate tables, drop tables, and various

constraints as per the requirements.

. Implemented business logic in stored procedures and triggers.

. Created views, primary keys, indexes, constraints, packages,

sequences, grants and synonyms.

. Created and optimized SQL queries, stored procedures to improved

performance. Created Techincal documentations and user manuals.

Environment: Oracle 8i, PL/SQL, Windows XP.

EDUCATION

Bachelors of Science in Computer Science, Andhra University AP

CGPA 3.8/4.0

Contact this candidate