Manager Data

Summary

. Over * years of Experience in gathering Business Requirements, GAP

Analysis, Data Modeling, Design, Development, Testing,

Implementation and Documentation of various functionalities of

OBIEE/Siebel Analytics, Data Warehouse/Data Marts.

. Strong Expertise in working with cross functional business teams to

help understand, define BI Requirements and to deliver projects

within committed time frames

. Experienced in interacting with Business Users, Data Architects and

developers in analyzing business requirements and translating

requirements into functional and technical design specifications

. Extensive knowledge of Quote to Order and Order to Cash business

processes

. Good understanding of AP,AR modules in Oracle Applications

. Strong expertise in defining and developing Financial Analytics

reports on core Finance related business metrics like cost and

revenue for Executive reporting needs

. Strong expertise in Siebel CRM application for Quote and Order Life

cycle management to support quote approval, complex pricing and

credit and payment verification

. Experienced in working on various Oracle Prebuilt BI solutions such

as Oracle Sales Analytics, Oracle Financial Analytics and Order

Supply Chain and Management Analytics.

. Expertise in complete Life Cycle,End to End Implementation of

Enterprise Business Data Warehouse using Oracle BI Enterprise

Edition(OBIEE)

. Very strong experience in developing OBIEE/Siebel Analytics

Repository (.rpd) at three layers (Physical Layer, Business Model &

Presentation Layer), Time Series Objects, Interactive Dashboards

with drill-down capabilities using global & local Filters, Security

Setup (groups, access / query/report privileges), configured

Analytics Metadata objects (Subject Area, Table, Column), Web

Catalog Objects (Dashboard, Pages, Folders, Reports)

. Proven skills in complete lifecycle of Design, Development and

Implementation of Business Intelligence with Star and Snow Flake

schemas using Kimball and Inmon Methodology using OBIEE, Siebel

Analytics 7.x and Informatica 7.x/6.x

. Experienced in Data Analysis, Identification of

Dimensions,Facts,Measures and Hierarchies

. Extensive Experience in providing end to end BI solution by

Dimensional modeling design, Logical/Physical models,

building/configuring RPD, Answers, Delivers/iBots, Creating reports/

Dashboards, Cache Management and setting up Security using LDAP

Authentication and Basic RPD Authentication.

. Extensive Experience in Data Warehousing development using ETL tools

such as Informatica Power Center / Power Mart 7.x/ 6.x /5.x

. Expertise in Oracle PL/SQL and database Performance Tuning by

implementing Parallel Execution, Table Partition, materialized views

with query rewriting, creating appropriate indexes, usage of hints,

re-building indexes and also used the Explain Plan and SQL Tracing

. Project management experience, project proposals, presentation and

documentation

. Expertise in Six Sigma Methodology and successful implementation in

Projects

. Expertise in business planning, analysis & software designing skills

with ability to transform business users' input into software

requirements and specifications

. Excellent Written and Verbal Skills; Results oriented and Self-

Starter looking for challenges; Ability to rapidly learn and apply

new technologies and improve processes; Self-motivated and results-

oriented with solid work ethic

Education

Bachelor of Engineering in Information Technology

Technical Skills

Reporting OBIEE 10.1.3.4/Siebel Analytics 7.x,Presentation

Tools Services/Siebel Analytics Web, Siebel Answers, Dashboards

Data Informatica Power Center/Power Mart 6.2/7 .x, SQL*Loader

Warehouse

Tool

Relational Oracle 8i/9i/10g/11i,SQL Server 7.0/2000,PeopleSoft Version

Databases/ERP 8.5,Oracle Applications 11i

Database SQL,SQL*Plus, PL/SQL,UNIX Shell Scripts

Languages

Web ASP, XML, Java Script, HTML,DHTML

Technologies

Programming C,C++, XML, UML

OS Expertise Windows 95/98/NT/2000, Unix, Sun Solaris, IBM AIX, HP Unix

Experience Profile

Sr. Business Intelligence Analyst

Netapp Inc, CA

Sep 2008 - Present

The eBI project which was designed using Oracle Business Intelligence

(BI) Suite Enterprise Edition (EE) provides robust analytical capabilities

with a near zero downtime enterprise data warehouse using Netapp storage

solutions. This new eBI solution transformed how Netapp uses information

and achieved many of the industry's long standing BI goals including hourly

data refresh, functional, role based analytics in one intuitive,

intelligent eBI application, multiple ways of viewing data and provides

agile analytical business solutions.

Responsibilities:

. Worked closely with various Business users across different theatres

of Netapp in understanding their business requirements and reporting

needs for Sales, Marketting and Finance operations.

. Responsible for authoring Business Requirements Document and

designing functional and technical specifications.

. Performed GAP Analysis between the 'AS-IS' process and 'TO-BE'

process

. Worked closely with various cross functional teams within IT in

helping them understand the BI requirements and propose technical

design.

. Worked with Data Architects in analyzing various data sources like

Oracle ERP, PeopleSoft 8.5 (HCM) and Siebel CRM necessary to

implement the reporting requirements

. Played a key role in defining analytic metrics which drive the

business forward

. Participated during various levels of SLDC to ensure correct

business functionality, requirements, and industry standards are

addressed within the BI applications environment by using existing

and leading practice methodologies and tools

. Responsible for leading small project teams to deploy new reporting

functionality within the enterprise data warehouse.

. Played a key person in the development of Sales Analytics, Finance

Analytics and Partner Analytics using OBIEE Answers

. Managed security privileges for each subject area and dashboards

according to user requirements to implement object level and data

level security

. Configured Intelligence dashboards by adding included and embedded

content such as links/images, HTML objects and folders.

. Involved in testing activities to ensure accuracy and validity of

data and reports

. Responsible for conducting various review sessions with functional

owners and end-user representatives.

. Involved in developing components for the User Acceptance Test Plan

and executing components of the User Acceptance Process

. Provided training to business power users on OBIEE tools and helped

them understand the reporting functionality in context to business

process execution.

. Involved in Managing UAT with end users including coordination and

user acceptance signoff

. Involved in the preparation of user documentation and training

documentation

. Provided end-user assistance to troubleshoot data issue

. Involved in Root Cause Analysis of issues and day-to-day production

support.

Environment: OBIEE 10.1.3.4., Informatica Power Center 7.x, Oracle 9i/10g

Senior BI Analyst

Washington Mutual, CA

March 2007 - Aug 2008

Washington Mutual is a leading banking, insurance, mortgage, and

consumer finance solutions provider. The project aimed to analyze and

predict customer and market trends and to help provide tailored solutions

for customers and also analyze the performance reports for the bank. It

enabled organization to develop and influence more intelligent business

decisions, improve overall profitability, introduce new performance based

KPI's for Budgeting, marketing, and forecasting. The Data Warehouse

incorporated financial information from various data sources into one

central repository providing the organization a cross-enterprise

consolidated view of the information. Siebel Analytics was used to analyze

information on revenue, cost, profitability, volumes, productivity and

revenue generated by region, market segment.

Responsibilities:

. Involved in requirements gathering, designing functional and technical

specifications for reporting needs.

. Worked with functional and technical project leads, marketing, sales,

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

Business requirements.

. Worked extensively on Siebel applications (Siebel Answers, Delivers,

and Dashboards).

. Played a key person in the development of Financial Analytics

dashboards providing timely information on cost, revenue at levels of

detail such as by product, geography, region and customer to a broader

range of business users.

. Created different types of Customized Reports (Drilldown, Aggregation)

to meet client requirements.

. Built Business model and established relationships & Foreign Keys

(Physical & Logical) between tables.

. Involved in modifications of physical, business and presentation

layers of metadata repository using Siebel Analytics Administration

Tool.

. Identified the aggregate levels for each source and created dimension

sources for each level of aggregates.

. Developed different kinds of Reports (pivots, charts, tabular) using

global and local Filters.

. Managed day-to-day rpd, Scheduler & iBots.

. Managed security privileges for each subject area and dashboards

according to user requirements.

. Developed UNIX and PL/SQL scripts for pre & post session processes to

automate daily loads.

. Performed unit, data integrity testing and supported end users during

various test cycles.

. Provided 24x7 production support for applications.

Environment: Siebel Analytics 7.5, Informatica Power Center 7.1.4, Oracle

9i, SQL, PL/SQL, Unix, Windows XP, Erwin, Autosys

Sr. Siebel Analytics / Informatica Consultant

HP, Texas

Feb 2006 - March 2007

Responsibilities:

. Involved in gathering the requirements, performing scope analysis

and identifying gaps

. Developed Siebel Analytics Repository (RPD) per user requirements

and available information in DW

. Analyzed and validated the business model in Siebel Administration

Tool by performing consistency check, validating logical source

tables, logical columns, and also validating repository level

calculations done in the business model layer

. Implemented Security for various users and groups using External

Table Authentication

. Implemented dynamic dashboard prompts to zoom into particular

segments of the business in a performance-optimized manner

. Responsible for creation of pivot table requests and bar/column

charts allowing manager to analyze the business from different

perspectives provided optimized Analytics request using column

selector/view selector, multi-select page prompts

. Created and used Siebel Delivers and iBots extensively

. Developed and debugged Dashboards/ reports visibility with respect

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

. Developed Informatica mappings with re-usable transformations and

mapplets using various transformations

. Extensively involved in performance tuning of the Informatica ETL

mappings like increasing the caching size, overriding the existing

SQL

. Developed / modified mappings per gaps identified

. Used Toad to debug the SQL query to identify duplicate rows in the

warehouse tables, and to debug SQL query issued during report

execution

. Coordinated the Analytics RPD and Web Catalog objects migration from

Dev environment to QA environment and to the Production environment

Environment: Siebel Analytics 7.x, Informatica 6.2, Oracle 9i, Sun Solaris

Sr. Siebel Analytics Consultant

Wachovia, NC

Feb 2004 - Jan 2006

The Siebel Analytics BI Platform Solutions was implemented for

providing interactive Dashboard access to strategic business information

from the company-wide data warehouse analytical information assets in

retail finance at Wachovia, a nation-wide leading financial services

company.

Responsibilities:

. Worked with functional and technical project leads, marketing, sales,

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

Business requirements.

. Identified and worked with various application areas in identifying,

analyzing, and documenting various information sources solutions to meet

the business requirements.

. Worked extensively on Siebel applications (Siebel Answers, Delivers, and

Dashboards).

. Created Dashboards by embedding reports and providing intuitive

drilldowns and links to exploit the full benefit of Analytics.

. Involved in design and development of repository (Creating / Modifying

objects in Physical, Business and Presentation layer) and the process of

repository migration.

. Development of interactive flash-based drillable charts such as bar-

charts, pie-charts, radars, bubble-charts, etc using the integrated Corda

PopChart Server.

. Implementation of Siebel Delivers using iBots for delivery of reports

through email, hand-held devices and mobile phones.

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

authentication systems such as LDAP, OS, Database and Database table

authentication using Session Variable features, as well as Dashboard /

Report-level security.

. Analytics Application Response-time Performance management using

optimization efforts such as aggregate navigation, indexes and Oracle

materialized views.

. Implementation of criteria filters to narrow-down the result set from

the analytics requests.

. Developed/Bench-Marked performance tuning strategies with business

model-level calculations versus Data warehouse level pre-computations and

aggregations.

. Used Workflow Manager for Creating, Validating, Testing and running the

sequential and concurrent Sessions and scheduled them to run at specified

time with required frequency. Used Workflow Monitor to monitor the

performance of the Jobs.

. Developed and executed test plans and played an active role in product

rollouts.

. Life-cycle support for migration efforts from development to QA to

production analytics.

. Involvement with ETL (Extract-Transform-Load) development team to

communicate the specification for the required dimensional, aggregate and

indexed data tables.

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

Environment: Siebel Analytics 7.x, Informatica PowerCenter 6.x/7.x, Oracle

9i/10g, Sun Solaris

Informatica Consultant

BellSouth, GA

June 2002 - Feb 2004

Bellsouth Broadband and Internet Services (BBIS) Datamart is implemented to

analyze the usage metrics and also to measure performance of customer

operations.

Responsibilities:

. Designed, developed and documented multiple interfaces using the

Informatica Power Center.

. Developed many complex Informatica mappings and mapplets to build key

interfaces using transformations & reusable transformations (Source

Qualifier, Joiner transformation, Update Strategy, Lookup transformation,

Rank Transformations, Expressions, Aggregator) for loading the data into

Data Warehouse.

. Optimal utilization of object-reusability features like reusable

transformations, mapplets, copying objects from other repositories, using

variable/parameters for simplifying complex mappings.

. Performance Tuning of Informatica data warehouse loads, including

Informatica Server Manager and PL/SQL procedures.

. Designed and Developed many Shell Scripts for pulling data from remote

machines, session using Cron, Backup/Migration of metadata from version,

development and production, FTP, untar & sending files to source

directory, managing sessions files in the server directory.

Environment: Informatica Power Center 5.x/6.x, Oracle 8i/9i, HP UNIX

ETL Analyst/Developer

Client: GE Power Systems, USA

Organization: Satyam Computer Services Ltd

Jan 2001-June 2002

This project is aimed at developing an Integrated Data Mart for the

Headcount across GE Power Systems, for which the source comes from the

Oracle HR system and the business owner would be the Human Resources.

Description:

. Involved in creating the physical & logical design using the Erwin

diagrams

. Creation of Database Objects (Tables, Indexes, Stored Procedure,

Functions, Users, Privileges grants, Roles etc) for Data Mart.

. Created Process Flow Diagram document.

. Designed Sources to Targets mapping from primarily Flat files to

Oracle using Informatica PowerCenter.

. Various kinds of the transformations were used to implement simple and

complex business logic. Transformations used are: Stored Procedure,

connected & unconnected lookups, Router, Expressions, Source

Qualifier, Aggregators, Filters, Sequence Generator, etc.

. Created and Configured sessions to transport the data to target

warehouse Oracle tables using Workflow Manager.

. During development, used Workflow Manager to schedule and run sessions

as well as to check session logs and other session related activities.

. Troubleshoot problems by checking sessions and error logs.

. Created post-session and pre-session stored procedures and email-

notifications.

. Generated Unit Test Plans and related documents.

. Involved in unit testing entire process flow.

Environment: Informatica Power Center 6.2, Oracle 8, Erwin 4.1, Toad,

PL/SQL etc

Contact this candidate