SAI VIJAY

OBIEE ARCHITECT

651-***-****

acdkko@r.postjobfree.com

PROFESSIONAL SUMMARY

. Result Oriented IT professional with around 9 years of progressive

experience in the IT field and 7 years' experience in Oracle Business

Intelligence projects that span the full life cycle implementation of

Oracle Business Intelligence/Siebel Analytics, Informatica and Data

Warehousing.

. Expertise in Developing Oracle Business Intelligence Solutions, gathering

Business Requirements and implementing them using BI Tools such as Siebel

Analytics/OBIEE.

. Expertise in providing end-to-end business intelligence solutions using

OBIEE.

. Extensive experience in OBIEE Answers, OBIEE Intelligent Dashboards, BI

Publisher, OBIEE Administration Tool, Delivers and iBots with OBIEE

Applications.

. Experience in installation and configuration of OBIEE, DAC and

administering permissions, privileges to users based on their groups and

responsibilities.

. Extensive experience in OBIEE/Siebel Analytics, Oracle BI applications

and Informatica.

. Worked on upgrading OBIEE 10g to 11g.

. Upgraded the Informatica repository from version 8 to 9.

. Expertise in handling all phases of Software Development Life Cycle

(SDLC) of the BI Projects.

. Sound knowledge of database architecture for OLTP and OLAP applications,

Data Analysis, ETL processes in developing data marts and Enterprise Data

Warehouse.

. Practical understanding of the Data modeling (Dimensional & Relational)

concepts like Star-Schema modeling, Snowflakes modeling, fact and

dimension tables modeling of data.

. Expertise in design and development of three layers (Physical, Business

model and Presentation) of an OBI Metadata Repository using Oracle BI

Administration tool.

. Configured Answers (ad-hoc querying, reports), Interactive Dashboards

with drill-down capabilities (charts/tables/graphs), Delivers/iBots

(alerts) administered Web Catalog Objects (pages, folders).

. Involved in Business Model development with Dimensions, Hierarchies,

Measures, Aggregation Rules, Time Series and Cache Management.

. Participated in Security Setup at both Object and Data levels, which

involved creation of users/groups, LDAP authentication setup Single- Sign-

On of OBIEE.

. Actively involved in using Repository, Session variables and

Initialization blocks.

. Customized Oracle BI Applications and modified prebuilt solutions

according to the requirements.

. Extensively used the four basic Informatica Power Center client tools -

Repository Manager, Designer, Workflow Manager and Workflow Monitor

. Actively involved in Installing, configuring and customizing DAC

(execution plans, subject areas, tables, and task) and monitoring ETL

process using DAC & Informatica workflow manager.

. Proficient in working on production, development & test environments in

different RDBMS in Oracle 8i/9i,10g,11g, SQL Server, IBM DB2 8.2 and

strong troubleshooting skills

. Worked on Installation and up gradation of OBIEE 10.1.3.4.1 to

11.1.1.6.0.

. Strong experience in back-end programming with Oracle PL/SQL and SQL.

. Soft skills include excellent communication, ability to understand and

analyze the client requirements and have the ability to work in a team as

well as independently.

TECHNICAL SKILLS

Reporting Tools OBIEE 11g, OBIEE 10.1.3.X, Siebel Analytics 7.5, 7.7, 7.8.X,Oracle BI Apps 7.9.X

ETL Tools Informatica, DAC.

Languages/Utili C, SQL, PL/SQL

ties

Operating Windows 95/98/NT/XP/Vista, Server 2003/2007, Unix

Systems

Other Tools SQL Plus, SQL *Loader, TOAD.

EDUCATIONAL QUALIFICATIONS

. Masters in Engineering, Texas, USA.

PROFESSIONAL EXPERIENCE

MEDICA, Minnetonka, MN

Jan 12-

Present

OBIEE/BI Publisher Architect.

Medica provides popular health plans and #1 rated service to business and

government employers, to labor unions, and to individuals of all ages -

from recent graduates to Medicare beneficiaries.

Responsibilities:

. Interacted with the business users for gathering the Reports/ Dashboards

requirements and to define business and functional specifications.

. Involved from scratch to building the reports for Phoenix IFB Project as

part of health care reform.

. Designed and developed the OBIEE Metadata Repository (.rpd) using Oracle

Business Intelligence Admin tool by importing the required objects

(Dimensions, Facts & Aggregates) with integrity constraints into Physical

Layer using connection pool, developing Dimensions (Drill-Down

Hierarchies) & Logical & Facts / Measures objects in Business Model

Layer, and creating the Presentation catalogs in Presentation Layer.

. Developed reports using BI Dashboard and Answers, views & charts.

. Configured metadata objects (Subject Area, Table, and Column) and Web

Catalog Objects (Dashboard, Pages, Folders, and Reports).

. Developed many Analytical and Operational reports using different

Analytics Views (Pivot Table, Chart, Column Selector, and Narrative

View), Dynamic / Interactive Dashboards with drill-down capabilities,

charts, tabular using global and local Filters. Extensively used iBots.

. Analyzed the Health-Rules Application Data and created reports and BI

Publisher Templates for IFB business unit.

. Converted Crystal reports in to OBIEE Reports.

. Converted SAS Reports in to OBIEE Reports.

. Created several BI word Templates for Provider validations.

Environment: OBIEE 11.1.1.6.5, BI Publisher, Oracle 11g, SQL Developer,

AQT,SQL, PL/SQL, Toad 10.1,UNIX.

Imation Corporation, Oakdale, MN

Sep 10-Dec 12

BI Apps Architect

The company Imation is a 1996 spin off of 3M and is headquartered

in Oakdale, Minnesota. The company has been involved in the development of

many technological improvements in data storage, such as the introduction

of the first magnetic tape in 1947, the first quarter inch tape cartridge

for data storage (QIC) in 1984. As a BI Apps Consultant, I administrated

Informatica, DAC and OBIEE.Based on user requirements, some fit-gaps were

identified and customized to load the user required data and debugged

various issues.

Responsibilities

. OBI Apps, DAC and Informatica.

. Interacted with the business users for gathering the Reports/ Dashboards

requirements and to define business and functional specifications.

. Responsible for setting up the environment including installation of

OBIEE, BI Apps and Informatica.

. Worked in a multi user development environment

. Designed and developed the OBIEE Metadata Repository (.rpd) using Oracle

Business Intelligence Admin tool by importing the required objects

(Dimensions, Facts & Aggregates) with integrity constraints into Physical

Layer using connection pool, developing Dimensions (Drill-Down

Hierarchies) & Logical & Facts / Measures objects in Business Model

Layer, and creating the Presentation catalogs in Presentation Layer.

. Managed presentation catalog groups and users settings to web group

folders.

. Developed reports using BI Dashboard and Answers, views & charts, created

filters to obtain weekly sales reports and send alerts to top management.

. Configured metadata objects (Subject Area, Table, and Column) and Web

Catalog Objects (Dashboard, Pages, Folders, and Reports).

. Developed many Analytical and Operational reports using different

Analytics Views (Pivot Table, Chart, Column Selector, and Narrative

View), Dynamic / Interactive Dashboards with drill-down capabilities,

charts, tabular using global and local Filters. Extensively used iBots.

. Development of many complex Informatica mappings and mapplets to build

key interfaces using transformations and reusable transformation units

(Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for

loading data into Data Warehouse.

. Performed Data Validation of data in the reports, Fixed all the errors

and warnings in the repository and web catalog.

. Worked on upgrading OBIEE 10 g to 11g.

. Created custom Reports in Usage tracking reports User Acceleration.

. Worked on Migration of OBIEE 10g to 11g and deployments of web app for

customizations.

. Worked closely with Oracle in resolving the bugs related to product.

. Worked extensively in Oracle BI Security, Web Object Security and Data

Level Security.

. Effectively managed migration of RPD and presentation catalog changes

across environments through catalog manager

. Modified Pre-built OBI Applications dashboards, Answers, Repository for

Sales, Finance, Supply Chain and Order Management Analytics

. Monitored the informatica jobs, which will load the data from OLTP to

OLAP.

. Upgraded the Informatica repository to Informatica 8 to 9.

. Worked closely with Users, Developers and Administrators to resolve

ongoing Production Problems by reviewing design changes made to

production systems and made corresponding changes to Siebel Analytics

Repository.

. Performed the Performance Tuning of Dashboards/Reports and made required

changes to repository and database.

. Performed Unit, Integration and Regression testing to validate reports

and mappings.

. Created the RPD, Reports and Dashboards for source JDA (Forecasting)

against OLTP with several BI functionalities to support forecast

reporting. And thus avoided development time and efforts.

. Integrated the custom EPAATS source with BI for reporting.

Environment: OBIEE 10.1.3.4.1,OBIEE 11.1.1.6.0, BI Apps 7.9.6, DAC

10.1.3.4.1, Informatica PC 8.6.1, Oracle 10g, SQL Developer, SQL, PL/SQL,

Toad 10.1,UNIX.

Verizon Communication, Dallas, TX

Jan 09-Aug 10 Informatica,

OBIEE Developer

Verizon Communications is a Communication giant which operates

internationally. This Business Intelligence application was intended to

develop a data warehouse and a reporting system, which effectively reports

customer behaviour for marketing campaigns, analyze sales from the website

and epos, it also monitors and reports order mgt issues at the sales call

centre and customer service. This improves decision making for financial,

marketing management, customer service teams.

Responsibilities:

. Oracle Business Intelligence (OBIEE), Informatica & DAC

. Interacted with business representatives for requirement analysis and to

define business and functional specifications

. Actively interacted with project managers & team members to discuss

timely deliverables, project status & documented technical specifications

from functional specifications in reporting point of view.

. Involved in gathering the requirements, performing scope analysis and

identifying gaps.

. Developed OBIEE Repository as per user requirements and available

information in Data Warehouse.

. Interacted with Business Users for gathering the Reports / Dashboards

requirements and to define business and functional specifications.

. Designed and developed the Metadata Repository (.rpd) using OBIEE Server

Admin tool by importing the required objects from the database using

connection pool.

. Developed many Reports / Dashboards with different Views (Drill-Down,

Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with

Filters) using OBIEE Presentation services.

. Configured iBots to deliver Analytics content based on schedule,

automated iBots queries to obtain daily and weekly reports.

. Implemented OBIEE Security, both Object level and Row level by creating

roles & web groups, checks with external tables and LDAP.

. Implemented data level security by Creating Users and Groups with

required Privileges and limited the Access to Subject Areas and

Dashboards

. Involved in the Cache management, to improve the overall system

performance

. Developed and debugged Dashboards/reports visibility with respect to

user's responsibility and web groups in an integrated environment.

. Involved in performance tuning of the Informatica ETL mappings like

increasing the caching size, overriding the existing SQL.

. Used Informatica Workflow manager and Workflow monitor for Workflow

sessions and database connection management and workflow monitoring.

. Create Update and tested customization DAC ETL execution plans.

. Identified and solved numerous technical and operational problems in the

Data mart design and ETL implementations.

Environment : OBIEE 10.1.3.4.1, Informatica Power Center 8.6.1,DAC, Oracle

10g, Oracle BI Apps 7.9.X, Toad, DB2,Flat files, Windows 2003 Server.

Pride Mobility Exeter, PA

Oct

07-Dec 08 OBIEE, Informatica Developer

Pride mobility Products Corp. is presently the world's leaders in

designing, developing and the manufacture of top quality mobility products,

including power lift chairs and mobility scooters, power scooters. The

company mission and vision statement clearly shows their strong desire to

remain world leaders in design, development and also the manufacture of the

highest quality, best performing mobility products. The Supply chain

project was intended to develop a data warehouse and a reporting system,

which effectively reports customer behavior for marketing campaigns,

analyze sales from the website, it also monitors and reports order

management issues at the sales call centre and customer service.

Responsibilities:

. Oracle Business Intelligence, Informatica & DAC

. Gathered and analyzed reporting requirements for the sales and marketing

departments

. Interacted with operations and billings subject matter experts (SME) &

business analysts in gathering and analyzing the report requirements for

the sales managers.

. Involved in the business user meetings and subject area layouts.

. Involved in developing and documenting technical specifications from

business requirements

. Configured metadata objects (Subject Area, Table, and Column) and Web

Catalog Objects (Dashboard, Pages, Folders, and Reports).

. Worked on Answers to build Interactive Dashboards with drill-down

capabilities

. Created reports and providing intuitive drilldowns and links to exploit

the full benefit of Analytics.

. Assisted in creation of pivot table request allowing manager to analyze

the business from different perspectives using column selector.

. Implemented dynamic dashboard prompts to zoom into particular segments of

the business in a performance-optimized manner.

. Configured iBots to deliver Analytics content based on schedule,

automated iBot queries to obtain weekly reports, delivery of reports

through email, hand-held devices and mobile phones.

. Implemented Security through external database table authentication and

authorization through session system variables, Initialization blocks and

groups.

. Involved in Data and Dimensional modeling creating Facts, Dimensions and

Measures

. Used Informatica Power Center tools for analysis, design, mapping and

workflow.

. Performed extraction, transformation, and loading (ETL) for data

warehouses by consolidating data from heterogeneous data sources.

. Worked closely with Users, Developers and Administrators to resolve

ongoing Production Problems by reviewing design changes made to

production systems and made corresponding changes to OBIEE Repository.

Environment: OBIEE 10.1.3.4,10.3.3.x, Informatica Power Center

8.6/8.5.1/8.1.1, Oracle 10g, Oracle BI Apps 7.9.X, DAC,MS SQL Server 2005,

DB2 Flat files, Toad, Windows NT.

Infosys, India

Jan 05-Sep07 SQL, BI Developer

Responsibilities

. Siebel Analytics, OBIEE, Informatica

. Interacted with functional & technical leads, SME's, marketing, finance,

and other business groups to identify, analyze, and document business

requirements.

. Designed and implemented custom business intelligence solutions (Metadata

and Dashboards/Reports) using the OBIEE platform

. Developed Metadata Repository (.rpd) with multiple business layers using

complex joins, presentation catalogs with access validations and external

table security repository and repository migration in BI Server.

. Designed and developed many Dashboards/Reports that are Dynamic &

Interactive with intuitive drilldowns, drill-across & flash-based

drillable charts (bar-charts, pie-charts, radars, and bubble-charts), and

local & global filters and cache monitor using Siebel Analytical Web.

. Used Smart View import, manipulate, distribute and share data in

Microsoft Excel, Word and PowerPoint interfaces, there by accessing data

from Relational or Multi-Dimensional sources.

. Configured iBots to deliver Analytics content based on scheduler,

automated iBot queries to obtain daily and weekly reports.

. Performed the Security management for users, groups and web-groups using

the various authentication systems.

. Enhance performance by requesting Aggregate tables, Indexes and managing

Cache after Benchmarking performance tuning strategies with business

model-level calculations versus database level pre-computations and

aggregations.

[pic]

Contact this candidate