Sr OBIEE developer

Murali Vaturi

Email id: *********@*****.***

Contact No: 858-***-****

Summary:

Over 10 years of extensive hands-on experience in Design, Development, Implementation, Analysis of Oracle/Siebel

Analytics, Admin tool, Dashboards, Configuring Dashboard, BI Delivers Configuring security at metadata and

Report level, Metadata tools and User interface designs, including 3 full life cycle implementations.

Core competencies include data modeling, design and development of ETL Data mart, Development/Administration

of DAC, Informatica and OBIEE repositories, and building OBIEE Dashboards/Reports.

Extensive experience in Siebel Answers, Delivers, iBots, and Siebel Intelligent Dashboards with Siebel Analytics

stand-alone/integrated implementation.

Expertise in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an

OBI Metadata Repository using Oracle BI Admin Tool.

Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules,

Time Series, Cache Management.

Experienced in Installation, Configuration, and Administration of OBIEE and Informatica Power Center/Power

Mart on Client/Server environment.

Worked on OBI Publisher importing data from multiple data sources and delivered Reports, common dashboards,

metadata, security, calculation, caching, and intelligent request generation services.

Experience in using Data warehouse Administration Console (DAC) to schedule and run full and Incremental ETL

loads, to schedule the Informatica jobs, and to customize Execution Plans.

Configured Answers (ad-hoc querying, reports), Interactive Dashboards with drill-down capabilities

(charts/tables/graphs), Delivers/iBots (alerts) and administered Web Catalog Objects (pages, folders).

Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP

authentication setup and configuration of Multiuser Development Environment (MUDE).

Extensively used the four basic Informatica Power Center tools - Repository Manager, Designer, Workflow Manager

and Workflow Monitor.

Proficient in defining key metrics, dimensions, hierarchies, attributes and building Star and Snow flake schema.

Expert in writing complex SQL queries, creating different PL/SQL Objects, Fine Tuning the code, and also in using

SQL*Loader for loading data into Data Warehouse/Data Mart.

Excellent communication, analytical, and team working skills

Experience with OBIEE/Siebel Analytics in both front and back-end development.

Technical Skills:

Installation, Upgrade, Administration and configuration of

OBIEE Infrastructure

v10g (10.1.3.2/10.1.3.3/101.3.4/11g) of OBIEE Components.

Installation, Upgrade, Administration and configuration of 7.9 Procurement, Sales &

Oracle BI Applications

Service, Supply Chain and Financials.

Installation, Upgrade, Configuration of Call Center, Sales, Service, and marketing of v.

Siebel Analytics

7.8, 7.7, 7.5.

SQL, PL/SQL, Pro*C, Java, C, C++, HTML, ASP.NET, JavaScript, UNIX Shell Script,

Languages

Perl, Visual Basic 5.0/6.0

Informatica Power Center 6.2/7.1.2/7.1.4, 8.1.1/8.6.1, Erwin, ODI

ETL Tools

Oracle 8i, 9i, 10g, MS–Access, MS SQL Server 6/7, DB/2, Hyperion Essbase

Databases

HP Quality Center, Win Runner 7.0

Testing Tools

Microsoft Windows Family, Unix/Linux

OS

Professional Experience:

Apr’13 – Dec’14

BART, Oakland, CA

EBS Apps - OBIA / HR Analytics / Financial – Sales Analytics / Asset Management

RPD Integration of People Soft data into Financial Analytics, ETL Informatica, DAC.

RPD development of HR – Labor Hours, Absence module reports.

Integration of Maximo (EAM) with Oracle Apps - OOTB.

Developed new Reports (Drilldown, Aggregation) to meet client requirements.

Build new Dashboards/ Reports from the developed Subject Areas.

Build ETL to extract data from PS source systems for new report development.

Maintaining daily DAC loads for HR and Financial Analytics.

Page 1

Murali Vaturi

Email id: *********@*****.***

Contact No: 858-***-****

Sep’12 – Mar’13

Hitachi Data Systems, Santa Clara, CA

EBS Apps - OBIA / Financial – Sales Analytics

RPD Integration of Hyperion Data into Financial Analytics and EMT SA, ETL Informatica, DAC Scheduler.

Build new Dashboards/ Reports from the developed Subject Areas.

Maintaining daily DAC loads.

Data modeling to integrate data from different source systems. Building customized hierarch ies and designing

Ad-hoc reports.

Security modeling for new developed Subject Areas.

Upgrade project from OBIEE 10g to 11g.

Oct' 11 – July 12

Inspirage, Bellevue, WA

EBS Apps - OBIEE / APCC, OBIEE Supply Chain Analytics .

Inspirage a Oracle Platinum Partner, is a premier full service consulting firm specializing in the implementation of Oracle

Advanced Planning & Demantra Demand Management applications.

GE - Home Appliances

Served as a Principle Consultant/Lead APCC Developer in the Value Chain Planning Application Architecture team with the

focus on the Supply Chain application technologies. Implemented APPCC and customizations to OOTB RPD and designed new

Dashboards leveraging standard Oracle applications technology to drive simplification and reusability.

Hands on experience with VCP supported applications, which include multiple Oracle ERP systems (Oracle EBS 11.5.10.2, R12,

Demantra, Real Time S&OP, and APCC).

Land 'O' Lakes, Inc

Served as Lead Principle Consultant to Implement APCC - OOTB solution. Conducted meetings with business team to analyze

Business requirements. Worked on Integrating APCC with SNO and Demantra Data. Build new hierarchies based on Demantra

hierarchies in APCC. Customized RPD to integrate the new data. Customized Dashboards and built new ad-hoc reports.

Supported Unit Testing, Systems Integration Testing, Performance Testing and fix reports in support of these testing processes.

O'Rielly, Sebastapol, CA Oct' 11 - Feb' 12

EBS Apps- Financials - Lead

Business Requirements Mapping for AP,GL,AR, INV, OM modules.

Designing Oracle Applications Financial and Operating structure of client organizations - Multi-Org Setup.

Logged, viewed, accessed, monitored, followed up, and closed Service Requests (SR) online - Oracle MetaLink.

Setup of Account Receivables, Inventory, Advanced Pricing, Ord er Management and Advanced Collections.

Data migration from legacy systems - ADI and Open Interfaces.

Reports performance improvement in the modules AP, AR, GL, INV, and OM.

Strong Technical experience in OBIA (Oracle BI Apps) and OBIEE.

Experience with OBIA Data model/OBIA Architecture/Informatica/DAC/Integrating OBIA with external systems .

Experience with configuring Financial Analytics, including ETL/DAC/RPD/OBIEE 10g.

Performed trouble-shooting and quickly resolved OBIA Financial Analytics implementation .

Demonstrated expertise in Oracle BI Server, Repository, Answers, Interactive Dashboard, Publisher, Scheduler, etc.

Experience in installation, server configuration, security setup and administration of OBIEE .

Ability to lead a project, designing and implementing physical, logical, and presentation metadata layers and

generating reports and dashboards using various OBIEE components

Worked with business and technology users to define and gather reporting and analytics requirements .

Design and develop ETL interfaces between multiple OLTP and OLAP systems using Informatica.

Install, Create, maintain and troubleshoot DAC.

Performed Deployment and migration activities and production support.

Assist and train QA analysts to test ETL interfaces and BI applications.

Managed Oracle Service Contract Administrator Workbench on the EBS Applications.

Page 2

Murali Vaturi

Email id: *********@*****.***

Contact No: 858-***-****

Jan’11 – June’11

Jenny Craig, Carlsbad, CA

Senior OBIEE developer + DAC + ETL developer

Jenny Craig, Inc. is a weight loss, weight management, and nutrition company founded by Jenny Craig and Sidney Craig now

headquartered in Carlsbad, California. Jenny Craig was started in Melbourne, Australia in 1983 and began operations in the

United States in 1985. The company became a part of Nestlé Nutrition in 2006. They have around 650 Centers. Project involved

Real time and Analytic reports for Sales Performance, Adjustments, and Rebates on Program etc. Integrated Jenny Craig At

Home Call Center Application with the Jenny Craig Centers combining them into one huge Database.

Responsibilities:

Participated in complete life cycle of the project from project initiation, to development, to production support and

maintenance.

Implemented Call Center Analytics using OTB reports and repository.

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

modifying it according to the business requirements.

Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Co mpound layouts to design the

dashboards.

Worked on Oracle Service Contract Administrator Workbench.

Created Security (LDAP) 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.

Used OBIEE Delivers to automate iBot queries, obtain weekly reports and to send alerts to related managers and

secured team members.

Using the Migration Assistant, quickly migrated current Discoverer environment & reports to OBIEE repositories in a

cost effective manner.

Used DAC for both incremental and full loads.

DAC server installation/configuration on Linux, Client on Windows. Created the task groups, connections,

execution plan for all the ETL mapping runs.

Good knowledge in order to cash (O2C) and procure to pay (P2P) business flows.

Defined Hierarchies and created Measures.

Worked on Oracle EBS sources like Oracle 11g, JD Edwards for getting the financial data.

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

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.

Informatica upgrade from 7.x to 8.x version Upgraded the existing mappings and migrated to the new environment.

Created and updated DevTrack for recording and bug tracking purpo se.

Involved in Analysis, Requirements gathering, SRS (Software Requirement Specifications) & HLDD (High Level

Design Document) & LLDD (Low Level Design Document).

Involved in analyzing existing logical and physical Data modeling using Erwin.

Responsible for creating & running SQL scripts for DDL, DML operations on Oracle DB.

Involved in data migration to import legacy data from one system to the other.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, Informatica Power Center 7.2, Informatica

Power Center 7.6, 8.61, Linux installation/config of DAC 10.x and Informatica 8.6 servers, EBS, Erwin, Data Warehouse

Administration Console (DAC), Oracle BI Publisher, Oracle BI Discoverer Administrator, 11g, Oracle Delivers, Windows

XP, UNIX/LINUX, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Doosan – Bob Cat, Fargo, North Dakota July'09 – Dec’10

Data Warehouse Project (Forecast Implementation) /Upgrade 7.1.0 /8.6

Senior OBIEE developer + ETL developer + DAC

Bobcat Company is a business of Doosan Infracore International, a US -based subsidiary of Doosan Infracore. They deal in

manufacture of heavy earth moving equipments. This company was bought over by Doosan and our job wa s to integrate both the

systems. I mainly focused on developing DW database for enabling RPD to generate reports and dashboards for their Forecast

system. GRETL North America Business Intelligence Automation project provides reliable and consist reporting capability for

Page 3

Murali Vaturi

Email id: *********@*****.***

Contact No: 858-***-****

GRETL economic and product forecast data. GRETL source data is extracted into analytical database using Informatica and

displayed using OBIEE dashboard and answers reporting tools.

Responsibilities:

My responsibilities included project planning, change management and implementation of various procedures to

comply with company standards and direct the developers towards the project milestones.

Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer,

Business Layer and Presentation Layer of OBIEE

Used Informatica as an ETL tool to extract data from source systems like SAP BW, People Soft, Flat File and SQL

Server to Load into different Target system like SQL Server, Flat File and Hyperion Planni ng, using Power Center

Connect for SAP BW and Data Integration Management.

Involved in upgrading the Informatica Power Center 7.1.0 to Informatica Power Center 8.1.1

Responsible for reporting the existing mappings from 7.1.0 to 8.1.1.

Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style

Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Presentation server.

Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly

reports.

Implemented security by creating roles & web groups, checks with External tables and LDAP.

Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to deb ug 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.

Worked on developing a Detail technical design document for GRETL Business Intelligence Automation for ETL

process.

Develop a ETL mapping and Load data tables for Proof of Concept (Existing Home Sales, New Home Sales, Housing

Starts)

Configured source ( GRETL ) and target ( ANALYTD ) servers and the Informatica services

Conducted meetings and discussion to understand the coding standard and naming convention of companies existing

Informatica environment.

Implemented Forecast Subject Area in OBIEE.

Environment: OBIEE 10.1.3.3, Siebel Analytics 7.x, Informatica 8.1/7.1, DAC 7.8, Oracle BI Applications 7.9.3, Oracle 9i,

Oracle Reports 6i, PL/SQL Procedures, Hyperion Essbase, SQL*Plus, TOAD, Windows 2000, UNIX Shell Scripting, Perl, HP

QC 9.2, BI Publisher, OBI Apps 7.9.5.1.1, Power Center 8.1.1, Oracle BI Discoverer Administrator 11g

Nov'08 – Feb’09

Office Depot, Boca Raton, FL

Siebel Analytics/Oracle BI + ETL

Office Depot is one of the leading Office supplies in United States. It provides variety of Officesupplies products including

furniture and technology items. My role was to integrate information from Legacy systems across different databases and flat

files to get a holistic view of its from Legacy systems across different databases and flat files to get a holistic view of its business.

to accomplish this task the company integrated relational and non-relational data across different business units into enterprise

Data Warehouse, where managers across the company can access a single repository for customer and sales information and

perform ad-hoc analysis and generate analytic reports.

Responsibilities:

Worked closely with Business Analysts in understanding the Analytics requirements and created Business Models for

generating Reports as per the requirements.

Designed Technical documents for the conversion programs and Interfaces from Functional documents.

Created and administered the three Layers in Analytics Repository (.rpd) using Oracle BI Administration Tool.

Developed many Reports/Dashboards with different Analytics Views 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 developed Accounting and Collection Time Series Object (Oracle BI Time-Series Functions) to

provide customized prompts appropriately to avoid excessive data.

Page 4

Murali Vaturi

Email id: *********@*****.***

Contact No: 858-***-****

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.

Environment: Oracle Business Intelligence 10.1.3.3.2, Informatica Power Center 7.7.1, Data Warehouse Administration

Console (DAC), Oracle Apps 11i (11.5.10), Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/Linux Shell Scripting,

Perl, Oracle 10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Jun’06 – Nov’07

Freescale Semi Ltd, Chicago, IL

Siebel Analytics Consultant + ETL developer.

Consumer Sales, Supply chain reporting project built using their Stand alone Siebel An alytics to report effective sales of various

consumer products globally. It enabled them to report the consumer sales trends and to take effective business decisions.

Responsibilities:

Lead offshore OBIEE team and actively interacted with them to go throu gh the functional requirements, Design

reviews and Development Requirements in OBIEE.

Enhanced and designed the reports in OBIEE for Various Horizon and Snapshot date dimensions in STAR design.

Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.

Highly interacted with Solution Architect to implement the OBIEE application for State of Demand, State of Supply

and Information to run the business.

Analyzed the structure and the granularity level of the EDW (Enterp rise Data Warehouse) for the advanced

implementation of the WRITEBACK feature of OBIEE.

Successfully implemented the code in DEV and deployed in SIT and UAT

Debugged and tested in final Test and deployed in Production.

Enhance the procedure to solve issues for Motorola L3 support

Designed and Developed the RPD and reports by using the column selector, pivot table view selector.

Implemented Supply Chain Subject Area in OBIEE.

Involved in business requirements analysis and achieved the functionality by design ing the hierarchy and the OBIEE

security.

Created and Developed the Groups in RPD and implemented Dashboard and Report -level security.

Implemented the row level security in OBIEE having the interface of the ORACLE Apex tool.

Implemented the IBOTS for the Forecast Accuracy release and assigned the groups in OBIEE front end.

Developed complex mappings by extensively using the Informatica transformations

Customized new and existing ETL plans in DAC by importing Sessions and Workflows.

Environment: Siebel Analytics 7.1.3, Informatica Power Center 6.2, Data Warehouse Administration Console (DAC), Oracle BI

Publisher, Oracle Delivers, Windows XP, UNIX/LINUX, Oracle 9i, SQL, PL/SQL.

Jul’02 - Jun’06

Motorola Libertyville, IL

INFORMATICA + Siebel Analytics Consultant

The Siebel Analytics project provides sales and order Analytics solution to enhance decision making process regardin g their

products and customers. The system will allow users to perform data analysis and track their products and customer details.

Responsibilities:

Interacted with business representatives for requirement analysis and to define business and functional specifications.

Worked in data warehouse designing dealing with workflow manager, warehouse designer, and mapplet designer

for complex ETL processes.

Involved in Analysis, Requirements gathering, SRS (Software Requirement Specifications) & HLDD (High Level

Design Document) & LLDD (Low Level Design Document).

Designed and implemented ETL using Informatica from source ERP

Page 5

Murali Vaturi

Email id: *********@*****.***

Contact No: 858-***-****

Worked on Informatica Power Center 7.1.1 tool - Source Analyzer, Data warehousing designer, mapping designer,

mapplet, and transformations.

Expressions, source qualifier, aggregators, filters, sequence Generator, etc.

Responsible for creating Ad hoc reports for business users.

Experience of using 3rd party scheduler tool like Autosys.

SQL Statement, Database Triggers, Stored Procedures and Views using SQL Server 2000.

Created/Modified Metadata repository (.rpd) and Configured Metadata Objects using Siebel Analytics Server Admin

tool.

Configured measures in the Business Model Layer and mapped to multiple logical source tables.

Developed Mappings and Workflows using various Transformations (Update Strategy, Router, Expression, and

Aggregator).

Environment: Siebel Analytics 7.1.3, Informatica Power Center 6.2, Oracle 9i, Windows.

Education Background:

M.S in Computer Science & Engineering.

Page 6

Contact this candidate