Manager Data

GURU TEJA

Email ID: **********@*****.***

Mobile # 248-***-****

Summary:

. Over 7+ years of experience in IT industry comprising of OBIEE (Siebel

Analytics) using OBIEE 10.x/11.x, Oracle 8i/9i/10g/11g and Informatica

8.x/7.x.

. Hands on Experience in Data Modeling using ER Model, Dimensional Data

Modeling, converting Snow-Flake Schema to Star Schema, Physical &

Logical Data Modeling.

. Experienced in building OBIEE Repository consisting of three layers

(Physical Layer, Business Model & Mapping and Presentation Layer) and

developing Dimensional Hierarchies, Level Based Measures, Aggregation,

Integration Variables, Initialization blocks Configuration, and adding

multiple sources to business model objects (mLTS).

. Proficient in using the Time-Series functions to support historical

time comparison analysis and creating requests, adding filters,

creating prompts and creating pivot tables using OBI.

. Expert in developing Subject Areas, and applying security (group,

access / query privileges) at object and data level in Administration

Tool. Hands on experience in customizing reports,

filters and charts in Oracle Answers.

. Experienced in designing customized interactive dashboards in OBIEE

using drill down, guided navigation, prompts, filters, and variables.

. Created and scheduled iBots using delivers to send alerts, run

reports, and deliver reports to the users. Experienced in supporting

performance tuning and process tuning at all levels.

. Executed OBIEE administrative tasks such as OBIEE server

installation, migration and user maintenance.

. Experience in migrating the Web catalog developments by using the

Catalog Manager and Repository developments to Production from the

Test environment.

. Experienced in BI Publisher, BI Answers and BI

delivers(OBIEE10g/OBIEE11g)

. In depth knowledge of Software Development Life Cycle (SDLC) and its

various phases such as Requirement gathering, Analysis /

Design, Development, Testing and Implementation / Release Management.

. Extensively worked in setting up a Multi-User Development Environment

(MUDE) and using OBI Answers to run queries to test and validate

repository.

. Extensive knowledge in Debugging, Optimizing and Performance Tuning of

Oracle BI/Siebel Analytics Dashboards/Reports by implementing

Aggregate Navigation, Cache Management and Materialized Views.

. Configured the NQSCONFIG.INI file for usage tracking using direct

insertion.

. Experienced in writing, testing and implementation of Stored

Procedures and Packages at database level using PL/SQL, Creating user

defined functions, triggers, cursors, views, indexes, and Database

design Methodologies.

. Expertise in Design, Development, Implementation, Administration and

Support of ETL processes for Data Marts and large scale Data

Warehouses using Informatica Power Center 8.x, 7.x.

. Experience in loading huge amount of data into data warehouse using

ETL tool Informatica. Development of mappings in Informatica to load

data from various sources using different transformations like Look up

(connected and unconnected), Router, Joiner, Update Strategy,

Aggregate, Expression, Filter, Source Qualifier, etc.

. Extensively tested the mappings by running the queries against Source

and Target tables and by using break points in the debugger.

. Worked with DAC to configure, monitor and schedule ETL routines.

Experienced in deploying Informatica workflows to the DAC and created

dependency and dependent Hierarchical tasks.

. Knowledge in extracting data from Oracle, OLTP, flat files and

integration and loading data to OLAP systems.

. Expertise in analyzing business issues and providing possible

reporting solutions to end users.

. Multi-platform experience on UNIX / Linux and Windows Server.

. Excellent problem solving skills with strong technical background

having the ability to meet deadlines, work under pressure, quickly

master new technologies and skills and ability to work effectively in

a team environment.

. Flexible and versatile to adapt to any new environment with a strong

desire to keep pace with latest technologies.

Technical Summary:

. Reporting Tools : OBIEE11.x/OBIEE10.x,Seibel Analytics 7.8.2/3,BI

Apps

. ETL Tools : Informatica Power Center 8.6/8.1/7.1, DAC,

. Scheduling Tools : DAC

. Databases : Oracle 8i, 9i, 10g, 11g, Teradata, and

Microsoft SQL Server.

. Query Languages : SQL/PL-SQL for Oracle/MSSQL Server/ Teradata

. Programming : C++, Java, and UNIX Shell Scripting.

. Operating Systems : Windows Server 2003/2005/2008, Windows

2000/Xp/Vista/7, UNIX, Linux.

. Web Technologies : XML, HTML/XHTML

. Data Modeling : Microsoft Visio, TOAD

. Domain : Banking, Insurance, Financial

Management, Health Care, Retail, Pharmaceuticals.

Sherwin Williams, Cleveland OH

Nov 2012 - Till

Date

OBIEE\ETL Developer

The company primarily engages in the manufacture, distribution, and sale of

paints, coatings and related products to professional, industrial,

commercial, and retail customers primarily in North and South America and

Europe. The company is mostly known through its Sherwin-Williams Paints

line. As BI Consultant, I administrated OBIEE platform. Based on user

requirements, some fit-gaps were identified and customized to load the user

required data and debugged various issues in all the three OBI Components

and custom dashboards were developed.

Responsibilities:

. Partnered with Business Analysts in understanding the analytics

requirements and creating the business models for generating reports

as per the business requirements.

. Based on user requirements, identified various fit-gaps on existing

Oracle analytics warehouse and developed solutions to meet Finance

team requirements and loaded the user required data into the OBAW

. Worked on repository Physical Data Layer, Business Model and Mapping

Layer and Presentation Layer using OBIEE Administration Tool.

. Setup MUDE Environment for Development of RPD for Developers.

. Managed the migrations of the webcatlog and RPD among different

Environments

. Developed many Dimensions and Time Series Objects with Security

settings for analyzing.

. Used the expression builder utility to create new logical columns in

the BMM layer and created various calculation measures.

. Created Dimensional Hierarchy for Dimensions, Level based Measures and

Aggregate navigation in BMM layer.

. Created indexes, materialized views, Aggregate Tables and Configuring

Nqsconfig.ini parameters etc

. Created groups in the repository and added users to the groups and

granted privileges explicitly and through group inheritance.

. Configured Repository and session variables to get dynamic reports and

dashboards.

. Developed different brand level Reports, Filters, and Prompts using

Oracle BI Answers and improve its performance by tuning long running

sql.

. Implemented dynamic dashboard prompts to zoom into particular segments

of the business in a performance-optimized manner.

. Developed and debugged many Dashboards using different Analytics Views

(Pivot Table, Chart, and Column Selector), Dynamic / Interactive

Dashboards with drill-down capabilities, charts, tabular using global

and local Filters.

. Implemented dynamic dashboard prompts to zoom into particular segments

of the business in a performance-optimized manner.

. Developed reports using BI Apps (Financial Analytics) repository, BI

Answers and Dashboards.

. Added new Dimensions and Columns to the Subject Areas to full fill the

Additional Requirements of the Business Analysts.

. Analyzed reporting requirements for dashboard reports and ad-hoc

reports.

. Took back-up of DAC, BI & Informatica repositories and BI Web

catalogs

. Monitored and Scheduled ETL along with reducing application

configuration and development time by using DAC.

. Built multiple execution plans in DAC for weekly and daily loads.

. Built custom analyze scripts for DAC to reduce the time for table

analysis.

. Performed extensive debugging on existing ETL routines and repository

(.rpd) layers.

. Experience in integrating OBIEE with EBS.

. Implemented User, Object and Data security in the integrated

environment (EBS and OBIEE).

. Expert in Unit, System and Integration Testing and Performed Data

Validation for all the ETL's and reports generated from Informatica

and OBI/Siebel Analytics.

Environment: BI Apps 7.9.6, OBIEE 11.1.1.6, Oracle EBS, Windows 2008

Server, DAC, Red-Hat Linux, Informatica 9.0.1

CalPERS

Jan

2012 - Nov 2012

Northern Highland Consulting,

Sacramento, CA

OBIEE Developer

CalPERS (California Public Employees Retirement System) are an agency that

manages pension and health benefits for more than 1.6 million California

public employees, retirees, and their families. CalPERS are known for its

shareholder activism .stocks placed on its "Focus List" may perform better

than other stocks, which has given rise to the term "CalPERS effect".

Outside the U.S., CalPERS has been called "a recognized global leader in

the investment industry", and "one of America's most powerful shareholder

bodies".

Responsibilities:

. Involved in meetings with users, BA's, and data analysts, and examined

the business, functional and technical design documentation.

. Involved in building star and snowflake schemas in the repository as

well as using the foreign key link in the physical layer and the new

complex joint key in the Business Model and Mapping layer.

. Configured the OBIEE repository (Physical, BMM and Presentation

layer).

. Worked with the repository and session variables. Created

Initialization blocks to provide Object level security for the users.

. Created Time Series measures Year ago, Month Ago, Year-to-date

measures using AGO and To Date functions.

. Involved in merging RPD for deployment.

. Built customized reports in OBIEE answers and integrated them into the

Dashboards according to the Business requirements.

. Developed many Reports using different Analytics Views (Pivot Table,

Chart, and Column Selector), Dynamic / Interactive Dashboards with

drill-down capabilities, charts, tabular using global and local

Filters that were following HIPAA standard regulations.

. Used complex expressions to Calculate, Group, Filter, and Format the

contents of the report according to the requirement.

. Modified ETL mappings Using Informatica Power Center Designer

. Scheduled Summary Reports, Ad Hoc reports for viewing purposes by the

managers for the analysis purpose. Created Drilldown-Reports for the

clients.

. Setting up LDAP authentication to enable Single Sign on for Users in

Development environment leveraging Analytics Repository.

. Created and integrated User Defined Functions and Stored Procedures

for reporting purpose.

. Was involved in performing data validation for the reports generated

using OBIEE.

. Responsible for Handling both initial EBS load and daily incremental

EBS load

. Dealt with the performance issues by Tuning the queries for the

reports which are running at significantly higher time periods

. Migrated the approved developments (Web cat, .rpd) from the Test

environment to the Production environment using the catalog manager

. Participated in the walkthroughs of the data models, ETL

specifications, identification of dimensional attributes, Facts and

Star Schema to fulfill requirements.

. Configured DAC and Monitored the Production DAC loads every day

. Used DAC to schedule and run the full incremental ETL loads and to

schedule the informatica jobs in Oracle Business Analytic Warehouse.

Environment: Windows XP, Windows Server 2008, MS SQL Server, ODBC, Oracle

11g/10g, OBIEE 11.1.1.3, Informatica 8.x, DAC.

Nordstrom - Seattle, WA

Nov 2010 - Dec 2011

BI Consultant

Nordstrom, Inc. is a leading fashion specialty retailer offering compelling

clothing, shoes and accessories for men, women and children. One of the

nation's largest upscale apparel and shoe retailers, Nordstrom sells

clothes, shoes, and accessories through more than 117 Nordstrom department

stores about 110 off-price outlet stores (Nordstrom Rack) in more than

31 states and online. My primary role was to set up the financial

environment by performing mapping and generating OBIEE dashboards and

reports.

Responsibilities:

. Worked closely with functional, marketing, sales, finance, and other

business groups to identify, analyze business requirements and

developed detail technical requirement based on business requirements.

. Co-ordinate with the off shore team and taking care of all the

deliverables

. Install and Configure OBIEE for BI Apps for different subject areas.

. Configure the connection pool settings according to the requirements.

. Work in End to End construction of the BI model from repository to

reports development

. Integrate OBIEE with LDAP for Authentication.

. Involve in several administrative roles including setting up users and

roles and permissions, managing catalogs.

. Manage/Administered OBIEE web catalog using Catalog Manager

. Create several dimensional hierarchies.

. Create new Repository Variables, Session variables and Initialization

blocks to configure security, data access and authorization on

Repository and Catalog objects.

. Provide dynamic cascading prompts as per client's new requirements on

organizational hierarchy and configure drill downs for various types

of Hierarchies.

. Created Answers reports using various analytics views like Table,

Pivot tables, Charts, Column Selectors, View Selectors, Narrative, and

Static text.

. Developed ad-hoc reports by writing physical SQL queries in the front-

end.

. Created ibots (Agents) for several reports to be delivered to the

users and to automate the data load process.

. Worked on enabling write-back feature on the reports.

. Created new Dashboards according to best practices by using Columns,

Sections and Guided Navigation.

Involved in developing Informatica Mappings to build key interfaces using

various transformations for loading data into Data Warehouse.

Extensively worked in the Performance tuning of the programs, ETL

Procedures and processes.

Created workflows to schedule and trigger mappings.

Environment: Oracle BI Apps 7.9.6, Oracle BI Publisher 10g, OBIEE 10g,

Oracle, XML, Informatica Power Center 7x/8.x, PL/SQL, SQL*Plus.

Gentech Pharmaceuticals FL

Dec 2008 - Oct 2010

BI Developer

Gentech Pharmaceuticals has been primarily known as a Research and

Development company. It has been involved in producing designer

pharmacological alternatives without the side effects. As a Siebel

Analytics developer, involved in developing BI solution for strategic

analysis by sales, marketing, and pricing to provide marketing and campaign

management capability, an ability to measure effectiveness across all

products and provide single data set for analysis and tracking of results

to the managers.

Responsibilities:

. Working with business users for gathering business requirements and

Identify various KPI's, and Analytics Report requirements.

. Experience on OBIEE 11g Administration using Web logic Administration

console and Oracle Enterprise Manager Fusion Middleware Control.

. Used OBIEE 11.1.1.6.0 Administration tool to develop and enhance meta-

data.

. Configured Physical layer, Business Model Layer and Presentation Layer

of the Repository.

. Renamed the components as per business terminology.

. Implemented Dimensional Hierarchies, Aggregate navigation, and other

various features to meet the business requirements.

. Created Repository, system and non-system session variable and

initialization blocks for various reporting needs.

. Configured Logical Layer, Created Logical tables/dimensions, columns,

Created Logical Joins/keys, Set levels to support Drill-down and

Aggregation navigation.

. Implemented Time Comparison and Calculation measures in the business

model using Time series Wizard.

. Created role based dashboards, pages, reports with various views i.e.

table, pivot, charts, narrator, column selector, ticker etc. and

various report prompts.

. Configured iBots to deliver Analytics content based on schedule,

automated iBot queries to obtain daily and weekly reports.

. Trouble shooting the issues related to repository models and report

development.

. Generated various Analytics Reports using global and local filters as

per client requirements.

. Managed security privileges for each subject area and dashboards

according to user requirements.

. Designed and developed global reporting solution in support of the ETL

initiative, developed and maintained documentation to support the team

and business.

. Checked the source, target and mapping bottlenecks to tune the ETL

process performance.

. Used Informatica Mapping Designer to create/update mapping using

different transformations like Filter, Expression etc. which are

required to move data into data warehouse.

Environment: OBIEE 10g, Informatica 8.6, Oracle 10g, Oracle Enterprise

Linux, Windows Server 2003, Windows XP.

HDFC Bank Cards Division, New Delhi India

April 2006 - Nov 2008

Siebel Analytics Developer

The Housing Development Finance Corporation Limited (HDFC) was amongst the

first to receive an 'in principle' approval from the Reserve Bank of India

(RBI) to set up a bank in the private sector, as part of the RBI's

liberalization of the Indian Banking Industry in 1994. It was incorporated

in August 1994 in the name of 'HDFC Bank Limited'. The purpose of the

project is to migrate data from the databases to the Warehouse built on

Oracle database and develop a decision analysis system using Siebel

Analytics/OBIEE to produce customized dashboards and reports.

Responsibilities:

. Worked closely with Business Analysts in understanding the Analytics

requirements and created Business Models for generating Reports as per

the requirements.

. Extensive experience in RPD, Web catalog administration as well as

server configuration.

. Installing Oracle BI Analytics and configuring the connection

parameters with SQL Server, Oracle 10g.

. Used TOAD for Oracle and SQL navigator to connect to databases in

Oracle.

. Create/Modify Metadata repository (.rpd) as per the data requirements

by using Oracle BI Analytics Server Admin tool.

. Independently Designed and developed subject areas in the RPD.

. Created Snowflakes and Star Schema to perform data modeling for

proposed architecture.

. Created the Business Model and Mapping Layer (design of hierarchies,

dimensions, and aggregates).

. Created Repository Users/ Groups and Web Groups and assigned

permissions to the user groups to define security in the repository.

. Gathered and analyzed reporting requirements for the claims and

payment departments.

. Created and customized various Reports and Dashboards for various user

groups.

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

Ticker and Narrative).

. Generated the highly-formatted, pixel-perfect enterprise reports using

Oracle BI publisher.

. Involved in migration of RPD and Catalog from Development to Test

environment.

. Developed and scheduled iBots for delivering personalized reports to

users on time.

. Trained End Users to Build Ad Hoc Reports using OBIEE.

Environment: Siebel Analytics 7.7, Informatica 7.x, Oracle 9i, PL/SQL, TOAD

and Windows.

Educational Qualification:

Bachelors of Science,

JNTU, India.

Contact this candidate