Sateesh T

Email: ab9woz@r.postjobfree.com: 720-***-****

SUMMARY

* ***** ** ********** ** Information Technology.Including Business Requirement Gatherings,

•

Analysis, Design, Data Modeling, Development, Testing and Implementation of Data

warehouse/Business Intelligence using OBIEE 10.x/11g and SQL server 2005/2008

Extensive experience in implementing Business Intelligence and Data Warehousing solutions

•

for various clients across diverse business segments.

Strong understanding of dimensional Modeling, star and snowflake Schemas and ETL

•

processes that is the key to data Consistency and integrity.

Experience on OBIEE 11g Administration using Weblogic Administration console and Oracle

•

Enterprise Manager Fusion Middleware Control.

Experience in installing, configuring and administering the different versions of OBIEE and

•

Web Logic Server on windows environments.

Expert in developing Oracle BI Repository (.rpd)which consists of: Physical Layer, Business

•

Model and Mapping Layer, Presentation Layer.

Expert in developing Interactive Dashboards, Reports with drill-down capabilities using page

•

and dashboard prompts and other Web Catalog Objects such as Filters, Folders, iBots & BI

Publisher reports.

Expert in setting up and managing security in OBIEE 11g, 10g.

•

Implemented Data Level Security, Object Level Security and LDAP authentication.

•

Integrated OBIEE 11g with HTTP Server

•

Experience in setting up Multi User Development (MUD) environment.

•

Expertise in tuning performance by utilizing aggregate tables, materialized views etc

•

Experience in Administering the OBIEE environment including Installation, Configuration and

•

Setting up Authentication mechanism.

Profound Knowledge of Software Development Life Cycle and Software Testing Life Cycle.

•

A self-starter with excellent technical & communication skills and having radical and tactical

•

problem solving approaches.

Excellent problem solving and inter-personal skills with strong technical background.

•

Quick learner, able to work with conflicting priorities, excellent team player with the ability to

•

meet deadlines under pressure.

Technical Skills:

Business Intelligence: OBIEE Suite10.x/11g (Administration, Answers, Dashboards, Oracle BI

Publisher, BI Delivers, Web catalog Administration, Analytics Server administration), Oracle

Business Intelligence Applications (OBIA) 7.9.X

Databases: MSSQL server 2000/2005/2008, MS Access, Teradata

ETL Tools:Informatica power center 7.x/8.x/9.x, MSSIS, DAC

Data modeling: Dimensional Modeling, Star-Schema, Snow flake Modeling, Erwin 3.X

Languages: SQL, PL/SQL, C, C++ Web Technologies HTML, XML, JavaScript

Operating Systems: Windows 8, Windows vista, Win 95/98/2000/XP Windows server 2003.

WORK EXPERIENCE

OBIEE Developer

Virtela, Greenwood Village, COJune 2012 to Present

Virtela's comprehensive suite of managed services allows companies to connect their offices

globally, secure the network and applications, make applications run faster, and offload

management of their IT infrastructure.The company had to implement financial, procurement and

HR modules of BI applications to help better organize and quick decision-making. Virtela is

upgrading the existing OBI applications from its current version to the new OBIEE 11g and

developing new functionality in addition to the existing one.

Responsibilities:

• As a Developer, my role has provided me a wider scope in the life cycle of the project from

Creating and Analyzing the Business Requirements, Gathering New Business Requirements

from the respective Stakeholders.

• Participated in complete life cycle of the project from project initiation, to development, to

production support and maintenance.

• Worked on OBIEE Administration tool for customizing the Physical layer, Business layer,

Presentation layer and modifying it according to the business requirements.

• To create RPD, connection pools, import physical tables and define joins in the Physical

Layer.

• Developed and customized some of the existing Dimensions (Drill-Down Hierarchies) &

Logical objects in Business Model Layer, and creating the Presentation catalogs in

Presentation Layer.

• Created Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design

the dashboards.

Created Security settings in Oracle Administration Tool to set up groups, access privileges

•

and query privileges and also managed security for groups in BI Answers.

Developed Dashboards for each of metrics by embedding reports and providing intuitive drill-

•

downs and links to exploit the full benefit of Analytics in providing reports.

Created & saved several BI Publisher reports by selecting an Answers request as Data

•

Source.

Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table

•

execution path by making use of hints, Creation/Re-building of Indices and Cache

Management.

Worked on Oracle 11g, SQL Server 2008 for getting the financial data.

•

Created comprehensive and easy-to-understand Documentation (Functional Specifications,

•

Technical Specifications and Mapping Documents) of the complete implementation of the

Customer Sales Business modules (Reports, Dashboards, Security and Star schema)

Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the

•

Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, Oracle BI Publisher,

Oracle Delivers, Windows XP, SQL server 2008 and Microsoft SharePoint.

OBIEE Developer

Cummins Inc, Columbus, IN June 2011 to May 2012

Cummins Inc. is a global corporation of complementary business units that design, manufacture,

distribute and service Engines and related Technologies, including Fuel systems, controls, air

handling, filtration, emission solutions and electrical business systems. The project was to gather

employees' details and maintain the staff information in one database. We also have maintained

personal record of the employees and generating the reports monthly, quarterly, half year and

yearly basis.

Responsibilities:

• Involved in user requirement and requirement specification from users.

• Documenting business requirements, functional specifications and test requirements.

• Involved in RPD Development, Oracle BI Server and Oracle BI Answers.

• Identified and Designed Star schema for fact & dimensional tables and created alias for the

dimensional tables when necessary.

• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle

BI Server Administration Tool.

• Specified Dimensional hierarchy, Aggregate levels for the dimensions and involved in

Configuration of Web Catalog Security and Cache Management.

• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.

• Used Filters and provided customized prompts to avoid excessive data showing up in the

reports.

• Identified Financial Analytics facts, dimensions & star schema models of workforce profile

subject area.

• Used catalog manager to migrate custom dashboards, requests, filter and prompts to

Integration & Prod environments.

Environment: OBIEE 10.1.3.4.1/11g, SQL server 2005/2008, Oracle BI Publisher, Windows XP,

WSr.

OBIEE Consultant

Unilever Best Foods, NJ January 2010 to May 2011

Unilever is a consumer goods company with world famous brands. The company wanted all its

data to be globally adequate for the entire decision making. Oracle Consumer goods were being

implemented which needed some configurations to the custom RPD and Catalog.

Responsibilities:

Gathered the requirement, Designed, Developed and Tested Physical Layer, Business

•

Layer and Presentation Layer of OBIEE • Worked on Custom built sources within the

Company to get understanding on the Data which in turn provides the insight on

Requirement

Worked on High Level Design Solution required for creating OBIEE Metadata Layer (RPD)

•

Worked on OBIEE Administration Tool End - to - End, which includes importing data,

•

creating connection pools to multiple data sources, developed Physical Layer, Business

Model and Mapping Layer and Presentation Layers.

Setup Multi User Development Environment (MUDE) in OBIEE

•

Worked on RPD, Creating Level based Hierarchies, Level Based Measures, and time

•

series measures, Creating Aliases, Creating Logical Table Sources, Created Initialization

Blocks and Variables, Data Level Security, User Level Security

Worked on OBIEE Analytics Module which includes developing the Reports and

•

Dashboards for Requirements provided by the Stake Holders.

Created complex Analysis reports in OBIEE using the Answers Module • Created

•

Dashboards, Dashboard Prompts, Navigational Reports, Guided Navigation Reports,

Automated iBot Queries, Customized BI Publisher Reports

Developed Mappings and Workflows and executed them on multiple sources using various

•

Transformations and loaded the data into targets. ‘

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4/11g, Data

Warehouse Administration Console (DAC), Oracle BI Publisher, Oracle Delivers, Windows XP,

SQL Server 2005.

OBIEE Consultant

HSBC Bank - Kolkata, West Bengal December 2008 to January 2010

OBIEE Platform Solutions was implemented for providing interactive Dashboard access to

strategic business information on services, finance and top of the house from the company-wide

data warehouse analytical information in mortgage at HSBC Bank, a leading financial services

company.

Responsibilities:

Worked closely with Business Analysts in understanding the Analytics requirements and

•

created Business Models for generating Reports as per the requirements

Responsible for creating Proof of Concept (POC) with Oracle data sources.

•

Created and Administered the Physical Layer, Business Model and Mapping Layer and

•

Presentation Layer in Analytics Repository (.rpd) using Oracle BI Administration Tool.

Developed many Reports/Dashboards with different Analytics Views (Drill-Down & Drill-

•

Across, Pivot Table, Chart, View Selector, and Column Selector, with global & local Filters

using Oracle BI/Siebel Analytics Web

Extensively used Repository Variables, Session Variables and Initialization Blocks for

•

Configuring the Data and user Security

Created Filters and provided customized prompts appropriately to avoid excessive data.

•

Developed Accounting and Collection Time Series Object (Oracle BI Time-Series

•

Functions) for comparing the Billings, Collections and Adjustments.

Created Users, Groups and giving the permissions in Siebel Analytics Administration Tool

•

and verifying the Permissions of the users in Siebel Analytics web

Enforced Row Level Security for Managers to View the Reports pertaining to their Region

•

Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance

•

Gains.

Performed Tuning of Dashboards/Reports by aggregate navigation, and cache

•

management.

Worked on OBI Delivers and configured iBots to deliver Analytics content based on a

•

schedule.

Worked extensively on Oracle BI Publisher and provided the capability to download the

•

reports in the user defined formats

Responsible for unit testing, integration testing of the reports generated using Siebel

•

analytics.

Environment: Oracle Business Intelligence 10.1.3.3, Oracle Delivers, Windows XP, SQL Server

2005, MS Access and MS Excel.

Database Developer

Hewlett-Packard, India February 2006 to November 2008

HP- Compaq is a technology company which operates internationally. This Business Intelligence

application was intended to develop a data warehouse and a reporting system, which effectively

reports customer behavior for marketing campaigns, analyze sales from the website and epos, it

also monitors and reports order management issues at the sales call center and customer service.

This improves decision making for financial, marketing management, customer service teams.

Responsibilities:

Analyze data model and requirements from an Application Architecture Repository and

•

Framework standpoint.

Developed custom reports/Ad-hoc queries using Oracle analytics and assigned them to

•

application specific dashboards.

Created and Administered the Physical Layer, Business Model and Mapping Layer and

•

Presentation Layer in Analytics Repository (.rpd) using Oracle BI Administration Tool.

Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance

•

Gains.

Used windowing functions in Oracle to analyze data and generate reports.

•

Developed different kinds of reports (pivots, charts, tables).

•

Created groups and added users to the groups and granted privileges explicitly and

•

through group inheritance.

Environment:Oracle Business Intelligence 10.1.3.2, SQL server 2005, Windows NT 2000/XP.

EDUCATION

Bachelor of Science (4 years degree)–Osmania University, India

Contact this candidate