Madhavi

703-***-**** Ext:****

acg3ln@r.postjobfree.com

SUMMARY:

Around 10+ years of experience in full life cycle includes Design

Analysis, Application Development, Implementation, Maintenance and

Documentation of Data Warehouse, Data mart and Business Intelligence

using OBIEE.

Expertise in implementing and practicing best practices in OBIEE

environment.

Experience in implementation of Data Warehouse, BI solutions and a

strong understanding of Data Warehouse Concepts, ETL, OLAP, OLTP, Star

Schema, Data Modeling using Normalization, Business Process Analysis,

Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical

Data Modeling.

Proficient in Installation and configuration and Administration of

OBIEE 10.1.3.x /11.1.1.7.1 and related components.

Experience in development and production support environments, setting

up single-sign on, LDAP authentication.

Expertise in providing end-to-end business intelligence solution by

configuring metadata and building Analytics Repository, dimensional

modeling design, building business models using Siebel Analytics/

Oracle Business Intelligence (OBI) EE.

Extensive experience in designing and maintaining complex reports in

canned and ad-hoc environment.

Experience configuring Interactive Dashboards with drill-down

capabilities using global and local Filters, Siebel Security Setup

(groups, data access/query privileges), Metadata Objects and Web

Catalog Objects (Dashboard, Pages, Folders, Reports, Filters, Prompts).

Experience in administrative duties like Setting up permissions and

privileges to the requests, dashboards, prompts and Setting up users

and groups.

Experience in technical assistance, resolving issues, training end

users in OBIEE.

Experience in Designer, Desktop Intelligence, Web Intelligence, Crystal

Reports.

Expertise in Universe designing, developing and generating complex, ad-

hoc, complex reports by linking data from multiple data providers and

functionalities like Combined Queries.

Experience in working closely with IT development team on various complex

projects.

Excellent Verbal and Written communication skills; Self Motivated and

good team player, adaptive to changes and challenges, detail oriented

ability to multi-task in a fast-paced environment.

EDUCATION

Bachelor of Technology in Computer Science Information Technology

TECHNICAL SKILLS

BI Tools OBIEE 11.1.1.7.1,

BI Publisher, Business Objects XIR2, Designer,

Reporter,

Performance Management, Crystal reports

ETL Tools Informatica Power

center 8.x, 9.x

DBMS/RDBMS Oracle 11g/10g/9i, DB2,

Teradata, MS Access

GUI Tools Toad, SQL Developer,

SQL Loader

Web Technologies HTML, DHTML, XML

Operating Systems Windows 7/2003/2008/XP

PROFESSIONAL EXPERIENCE

PEPSICO Inc.

Sr OBIEE Consultant

Oct 2011 -

Current

PepsiCo is mainly focused on convenient foods and beverages and it

seeks to produce financial rewards to investors as they provide

opportunities for growth and enrichment to their employees, their

business partners and the communities in which they operate.

Responsibilities:

Primary Lead role with support, development, maintenance of several

projects, point of contact person onsite for users and other BIS teams.

Meeting with Business Users/Partners to discuss requirements for new

reports and enhancements on existing reports.

Documenting the requirements and distribution of the documents for sign-

off before proceeding with development and also documenting the ongoing

reporting work for future reference.

Played a key role in setting up project plans/schedules and EMP/PLM

documentation for seeking e-approvals.

Installing all components required for development like Oracle Client,

Rapid Sql, OBIEE, Crystal Reports, BIP & Siebel Tools.

Extensively navigating and accessing Siebel Application in all

environments for data validation, generating sample xml files for BIP

Reports etc.

Created several BIP Reports by creating rtf templates and uploading to

BIP server and attaching report to list view and detail views in Siebel

Application.

Worked extensively with stored procedures with parameters, automated

the process with session variables on Dashboard reports/prompts in

OBIEE

Created few new Subject Areas and worked on several enhancement

requirements in existing Subject Areas in repository/rpd.

Automated the monitoring process for Agents by customizing dashboard

reports using Usage Tracking SA.

Created several new reports and recreated existing

reports/dashboards/triggers/delivers/segments in OBIEE

with data sources such as Oracle, DB2, Teradata, Excel.

Created new Crystal reports and modified existing reports with data

sources such as Oracle, DB2 and Sybase.

Created several repository variables, automated Metadata and created a

dashboard for report and application metadata enabling users to search

for columns or reports or dashboards etc.

Submitting TSRs in DEV/FIT/Prod for Autosys job to automate Metadata in

OBIEE 10g.

Performed several administrative tasks like recycling the services on

DEV, FIT servers and also migrating the rpd, catalogs, individual

reports, filters, prompts, Marketing triggers, segments etc. from DEV

to FIT.

Setting up permissions for Marketing Server Groups, managing Marketing

jobs and Marketing defaults.

Created several target levels, segmentation catalogs, list catalogs,

qualified list items.

Created segments, list formats, campaign load formats using Segment

Designer.

Set up delivers or ibots to deliver the files to Business Users Web

Servers and emails to users with attachments.

Involved in testing alias names of several physical server replacements

to virtual server replacements for Autosys jobs and delivers.

Involved in testing Office 2010 compatibility for BI Publisher Add in,

Adobe 9, MS Power Point, IE 8 compatibility with OBIEE and also

development testing on Windows 7.

Provide training to users on usage of new consolidated SA, powerful

features like "Combine with Similar Request", creating segments from

reports etc. and also support the application.

After report writing, conducting tests on the reports like data

validation and format validation.

Writing test scripts and adding to test labs for users to execute and

sign-off upon successful completion.

Followed ROI process to create defects according to Severity, priority

of Business process

Worked on Ticket Trend Reporting, weekly status reports, create and

close production support tickets

Trained new contractors offshore and onsite on environment and best

practices, conducted several KT sessions

Environment: OBIEE 10.1.3.4.1/11.1.1.7.1, BI Publisher, Crystal Reports

2008, Job Monitor, Siebel Tools 8.1.1.5, Siebel Call Center 8.1.1.5, MS

Office, Rapid Sql 7.6.3, PL/SQL, Oracle 11g, IBM DB2,Teradata

13.11,Sybase, Informatica 9.1, HP Quality Center 10.0, Autosys, Borland

Star Team, SM 7,Caliber,PEPNET,PPM,Sharepoint

State of Georgia DHS, Georgia

Sr OBIEE Consultant

Jan 2011 - June 2011

The Georgia Department of Human Resources, in partnership with local

communities, will assist individuals and families in achieving safe,

healthy, independent and self-sufficient lives. The scope of this

project is to provide the Department of Human Services (DHS) Division

of Child Support Services (DCSS) a DHS Data Warehouse which will

provide reliable information to DCSS executives, managers, agency

analysts, clients, providers, and other federal and state agencies.

Responsibilities:

Reviewed Business Requirements Document, System Technical Specification

Document, ER Diagram, Design Document Deliverable and ETL Design

Specification document.

Involved in several meetings with Business users, Business Analysts,

Managers for understanding requirements and discussing next action

plans.

Involved in monitoring the saw logs as users are being logged out of

the system while accessing the dashboards randomly and raised a SR with

Oracle.

Involved in load balance testing while IBM team has monitored the

Databases for load balance on two nodes.

Involved in troubleshooting several data issues, documenting the

discrepancies and resolving the issues.

Worked on identifying data issues, mapping issues in existing reports

or mapping logic on Data warehouse, documented, came up with solutions

and discussed with Deloitte team to get approval for fixing the issues.

Worked with DBAs, ETL Developers, and Application Architects in fixing

the duplicate data issue etc.

Worked with end users, BAs in understanding the requirements and mapped

Business Elements to Data Elements as part of new report requirements.

After creating new reports, unit tested the reports and migrated rpd,

catalog from DEV to UAT and fixed issues came across during UAT.

Applying conditional formatting to the reports, making necessary

changes, monitoring the query response time, view session logs and

analyzing the queries.

After successful completion of UAT process, migrated rpd and catalog to

Production.

Compared the data between DB2 and DW as part of existing Prod DW

reports maintenance.

After deletion of duplicates, checked all the interdependent tables for

trace of any duplicates in Toad.

Conducted a knowledge transfer session with the team regarding the best

practices and accessing, modifying the dashboards or reports.

Environment: OBIEE 10.1.3.4.1,Informatica Power Center 9.0.1, Business

Objects XIR2, Linux 5.3,IBM Mainframe Z/OS 11,Adobe Robo Help 7,ER

Studio Data Architect 8.5, Oracle 11gR2.0.1, Toad, SQL Developer,

Putty, WinSCP

Quintiles, North Carolina

Sr OBIEE Consultant

May 2010 - Dec 2010

Quintiles Transnational helps to improve healthcare worldwide by

providing a broad range of professional services, information and

partnering solutions to the pharmaceutical, biotechnology and

healthcare industries.

They seek unendingly to bring their customers' products and services to

market ever sooner and to play a creative role in their achievement of

earlier and greater commercial success.

Responsibilities:

Worked with BA Leads to document the requirements as per the report

numbers into FDDs.

Developed mockup reports in Adobe Dream Weaver so as to show Business

Architects & End Users.

Installed all components required for development like Oracle Client,

Toad, Sql Developer, OBIEE & Siebel Tools.

Worked with Offshore team located in India, had daily scrum calls where

in we discussed issues concerns and progress of development of reports

with Managers.

Navigated through the Siebel Application and mapped Siebel Columns to

Data store columns depending upon list of EBCs.

After ERD has been reviewed, involved in rpd design process

corresponding to our Subject Areas.

Developed reports after rpd is done on Dev Server in 3 Subject Areas,

main features in reports include navigation between reports, column

selectors, report selectors, guided navigation.

Documented unit test cases for all reports and made a Unit Test Case

Template.

Prepared SDS Documentation Template for all reports after successful

completion of report development and testing.

After report development is done, tested the reports with Siebel Dev

Application & Data store, inserted data in Siebel application required

for reports and tested the report if it's showing in the report.

After successful development & testing of reports on dev server,

reports are migrated to test environment and tested the reports with

Siebel Test Application & Data store.

Worked in Integrated environment of Siebel Application where in users

have access to dashboards

Fixed Bugs & issues raised by testing team in QC, after the issues are

fixed, added comments in QC to close the tickets.

Environment: OBIEE 10.1.3.4.1, Adobe Dream weaver CS5, Siebel Tools

8.1, Siebel CTMS 8.1, MS Office, SQL Developer, PL/SQL, SQL * Plus,

Oracle 11g, Toad, HP Quality Center

Verizon Communications Inc, Texas

OBIEE Consultant

Sep 2009 - Mar 2010

Verizon Communications Inc operates America's most reliable wireless

network, serving more than 91 million customers nationwide. Verizon

also provides converged communications, information and entertainment

services over America's most advanced fiber-optic network, and delivers

innovative, seamless business solutions to customers around the world.

Responsibilities:

Interacted with the existing team to go with an action plan for design,

implementation and maintenance of the project, reviewed design

documents and data dictionary.

Developed reports using BI Publisher using RTF templates and integrated

into OBIEE Dashboards.

Configured report-level properties and runtime properties for several

BI Publisher reports.

Configured jdbc connections for several databases in Dev, Test and Prod

environments.

Extensively used pivot tables and conditional formatting as to meet

existing report layouts in BO/Crystal.

Involved in several administrative roles like setting up users and

roles and permissions, managing catalogs.

Monitored Saw log for Server crashes or any errors and acted

accordingly, Purged Cache entries from time to time in Answers and rpd,

refreshed metadata after every minor change in rpd online.

Developed reports, dashboards as part of migration from BO/Crystal to

OBIEE and deployed in UAT and Production.

Created several dimensional hierarchies, initialization blocks,

repository variables, session variables and presentation variables and

request variables.

Used Stack Chart, Bar Chart, view selectors, Column Selectors, static

text, narrative views, guided navigations, and links for several

summary and detailed dashboards.

Used Catalog Manager to manage requests, dashboards, prompts and

folders in setting up permissions and privileges.

Purged Cache entries in rpd and cleared all sessions manually when

needed while development, disabled cache in UAT environment.

Provided dynamic cascading prompts as per client's new requirements on

organizational hierarchy.

Environment: OBIEE 10.1.3.4, Catalog Manager, BI Publisher, Business

Objects XIR2, Crystal Reports XI, MS Office, SQL Developer, PL/SQL, SQL

* Plus, Oracle 11i/10g, Toad, ODI

AT & T Services Inc, Ohio

OBIEE Consultant

June 2008 - Aug 2009

AT & T is recognized as one of the leading worldwide providers of IP-

based communications services to businesses. They also have the

nation's fastest 3G network and the largest international coverage of

any U.S. wireless carrier. It's making huge advances in the

entertainment and communications industry.

Responsibilities:

Involved in gathering technical requirements and preparation of

Requirement Specifications documents from various end users.

Monitored each and every dashboard loading time and defaulted prompts to

show less data when report loads initially and took several performance

tuning measures for good performance.

Involved in design and development of repository (Creating / Modifying

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

of repository migration.

Created connection pools, physical tables, defined joins and

implemented authorizations in the physical layer of the repository.

Implemented Comprehensive Security Model, by creating User Roles and

Web Groups, and setting up External Tables and LDAP Servers.

Created new universe and also modified existing universe for creating

WebI reports.

Created Crystal Reports using Standard, Summary, Cross Tabs, SQL,

Command Objects, Selection Criteria, grouping, sub reports.

Environment: OBIEE 10.1.3.3, Web Catalog, BI Publisher, Informatica

Power Center 8.1/7.1, DAC, Business Objects XIR2,Crystal Reports XI, MS

Office, SQL Developer, PL/SQL, SQL * Plus, Oracle 11i/10g, Toad, SQL

Server 2000/2005

Deloitte, PA

OBIEE Developer

Dec 2007 - May 2008

"Deloitte" is the brand under which tens of thousands of dedicated

professionals in independent firms throughout the world collaborate to

provide audit, consulting, financial advisory, risk management,

and tax services to selected clients. The Life Sciences and Health Care

global industry practice at Deloitte member firms worldwide are helping

our clients meet the challenges and face the opportunities that are

shaping today's industry.

Responsibilities:

Worked with management professionals, analysts as well as other

business teams on requirement gathering.

Worked on repository development, configured metadata objects (Subject

Area, Table, and Column) and web catalog objects (Dashboards, Folders,

Reports).

Identified Facts and Dimensions according to the design specification.

Developed analytical repository using Siebel Analytics Admin Tool

(importing database object into physical layers, defining logical

objects that includes Dimensions & facts in BMM layer and presentation

catalog in Presentation Layer).

Modified Dynamic Session Variables used for Data Visibility, Configured

Security at the repository level, Catalog level & the Siebel

Application level.

Created measures in Administration tool for the requirements using

expression builder and calculation wizard and also created hierarchies

and level-based measures for drilldown detail within Analytics Reports.

Used BI Publisher for report delivery in many popular pre-packaged

application suites, like the Oracle e-Business Suite.

Created Rich Text Format (RTF) templates to generate BI Publisher

Reports and embedded them on Oracle Intelligence Dashboard.

Environment: OBIEE 10.1.3.3, Informatica Power Center 7.1, Business

Objects XIR2, Crystal Reports XI, DAC, Oracle BI Apps 7.9.4, BI

Publisher, DAC,SQL Server 2000, SQL * Plus, Oracle 9i, Toad, XML, UNIX,

Windows Server 2003

Acumen Solutions, VA

Siebel Analytics Developer

Sep 2005 - Nov 2007

Acumen Solutions investigates each customer touch point, focusing on

the direct sales, contact center, and self service experiences, to

ensure that you meet or exceed your customers' expectations. It

develops metrics to track customer experience, provide feedback to all

customer channels, and create customer insight programs to support the

cross-sell/up-sell opportunities.

Responsibilities:

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

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

Business requirements.

Configured Siebel Analytics Repository like implementation of physical

data model as per requirements, importing the tables and having the

physical joins/keys required and changed the physical joins/key on the

existing tables.

Developed Star Schemas and Created Custom Star Schema as per the

Business Requirements.

Created dimension hierarchies and assigned levels and custom

aggregation rules for each level.

Suggested and implemented Siebel recommended Performance & tuning

practices to improve Siebel Analytics server performance by

implementing Query Caching, using aggregate tables, tuning &

reorganizing database indexes and configuring NQSConfig.INI files

performance parameters.

Created Dashboards by embedding Reports and providing intuitive

drilldowns, interactive flash-based drillable charts and links to

exploit the full benefit of Analytics.

Customized Dashboards, Administered permissions and privileges for

Dashboard visibility and modifications to users.

Environment: Siebel Analytics 7.x/8.x, Informatica 7.x, Business

Objects XIR1, SQL Server 2000, Oracle 8i, Windows NT

D & H Distribution Co, PA

Siebel Analytics Consultant

Oct 2003 - Aug 2005

D&H is an Employee Owned national wholesale distributor of computer,

video game, and consumer electronics products. Clients include small

and large resellers and retailers, system builders, and college

bookstores. Suppliers include Hewlett-Packard, Intel, and Microsoft.

Responsibilities:

Involved in gathering functional requirements from system users and

converted them to business requirement documents.

Used Metadata Design Principles to design Repository based on business

requirements and followed Best Practices.

Customized and developed the SA BMM layer by creating new logical

columns, aggregate columns, hierarchies etc.

Specified aggregate levels for each source and created dimension

sources for each level of aggregates.

Developed many Reports / Dashboards with different Analytics Views

(Drill-Down, Pivot Table, Chart, Column Selector, Page and Dashboard

Prompts).

Environment: Siebel Analytics 7.x, Informatica 6.x/5.x,Oracle 8i, UNIX,

Windows 98

TCS, Hyderabad, India

PL/SQL Developer

May 2002 - Sep 2003

At TCS, it means achieving real business results that allow you to

transform, and not just maintain, your operations. TCS is uniquely able

to help clients solve these business challenges. TCS serves large and

fast growing organizations who share a common set of objectives. TCS'

success and reputation is built on ensuring certainty of outcome for

these client objectives.

Responsibilities:

SQL Loader was used to convert the data from the Excel to oracle

tables.

Oracle Reports were deployed in PDF format over the Intranet available

for other users.

Analyzed, developed and maintained Oracle Forms and Reports.

Prepare detailed statistical reports in MS Access and MS Excel to track

progress of weekly, monthly and quarterly customers and sales growth.

PL/SQL was extensively utilized for coding and writing complex database

triggers, stored procedures and packages.

Sub-queries and joins were extensively used in stored procedures.

Environment: Oracle 8i, Oracle Developer 2000, PL/SQL, SQL*Plus, SQL

Loader, MS Excel, Windows 95

Contact this candidate