Manager Sales

Hariprasad Yarlagadda

Summary

. IT Professional with 5+ years of experience in gathering Business

Requirements, with prime focus on Analysis, design and development of

business intelligent solutions using OBIEE/Seibel Analytics and

Informatica.

. 3+ years of experience in OBIEE 10.1.3.x and over 2 years of experience

in Informatica power center 7.x.

. Experienced in Installing and Configuring OBIEE 10.1.3.x.

. Extensively used OBIEE Administration tool for Developing/customizing the

Physical layer, Business layer, Presentation layer and modifying it

according to the business requirements.

. Created Dimensional Hierarchies, level based measures and Time series

measures in Business Model Layer.

. Experience in accomplishing aggregate navigation and most economical

source in Business Model and Mapping Layer using Aggregate Persistence

Wizard.

. Created Presentation catalogs, Folders in Presentation Layer.

. Set-up Multiuser development (MUD) environment using the BI

Administration Tool.

. Developed Reports with different views using BI Answers.

. Extensive experience in building Interactive Dashboards with drill-down &

drill-across capabilities, using global & local Filters, Contextual

Navigation, Guided Analytics, Business Rules with User Identity & Roles,

Profiles & Personalization.

. Excellent experience in implementing the Oracle BI / Siebel Security

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

Catalog Objects (Dashboard, Pages, Reports).

. Configured IBots to deliver Analytics content based on schedule and

business criteria.

. Extensively created reports and templates using BI Publisher and bursted

to file locations and emails.

. Very good in Debugging, Optimizing and Performance Tuning of Oracle BI /

Siebel Analytical Dashboards / Reports.

. Extensively used Informatica client tools like Source Analyzer,

Warehouse designer, Mapping Designer, Mapplet Designer, Transformation

Developer, Repository Manager and Workflow Manager.

. Worked extensively on different types of transformations like Source

qualifier, expression, Aggregator, Router, filter, update strategy,

lookup, Normalizer, and sequence generator.

. Created sessions, worklets and workflows for carrying out test loads.

. Extensively used SQL and PL/SQL to write Stored Procedures, Functions,

and Triggers.

. Excellent problem solving skills, exhibited a consistent performance and

ability to work as a team member or as an individual.

Technical Skills

Reporting Tool : Oracle BIEE 10.1.3.4/10.1.3.2/3.1, BI

Publisher

Databases : Oracle10g/9i/8i, DB2, MS

Access2000/7.0, MS SQL Server2000

Languages : C, C+, Java, VB Script, Java Script

ETL Tools : Informatica (Power Center

8.1/7.1/6.2)

Query Tools : SQL, PL/SQL, SQL Loader, SQL

developer, TOAD

Operating systems : Windows 98/2000/NT/XP/Server 2003/Vista,

UNIX, LINUX.

Education

. Bachelor of Technology from JNTU, India

1

2

Experience

Cox Communications, Atlanta, GA July

2009 - Till Date

Sr. OBIEE developer

Cox communications provides digital cable television and telecommunications

services in the United States. Cox implemented "Communication Analytics"

for continuous improvement in the network. The aim of the project was to

continuously analyze and keep track of Sales Revenue, Profitability and

Service issues that are carried out across all systems. It involved

development of Reports and Dashboards for various users like Sales

Managers, Network Analysts etc.

Responsibilities:

. Participated in gathering business requirements and worked extensively

with Business Analysts in understanding the Analytical requirements.

. Involved in the installation and configuration of OBIEE 10.1.3.4.

. Extensively used OBIEE Administration Tool for developing Physical

layer, BMM and Presentation layers of the repository (.rpd).

. Created connection pools, physical tables (Alias, Opaque), and

defined joins in the physical layer of the repository.

. Created dimension hierarchies, level based measures, Time series

measures and Calculation wizard in BMM layer based on requirements.

. Performed Repository Testing and Validation before exposing Business

Models in the Presentation Layer.

. Created Presentation catalogs in the Presentation layer.

. Developed Reports (Service Availability, Detail Residential, etc

with different Views (Charts, Pivot Table, View selector, Ticker, and

etc

. Implemented object level security for both repository objects and web

objects by creating users and groups in repository and web catalog

groups in the Presentation Services.

. Created Interactive Dashboards (Communication Scorecard, Non-paid

Disconnects) using global filters and with drill-down capabilities

appropriately to avoid excessive data.

. Created Dashboard Prompts at dashboard and page levels to filter the

data.

. Extensively implemented Performance tuning by aggregate navigation and

cache management.

. Configured IBots to deliver Analytics content based on schedule and

business criteria.

. Configured and Scheduled BI Publisher for bursting reports and

templates to file locations and emails.

. Performed Unit testing, integration testing to verify the report

functionality and debugged dashboard reports to verify data matches as

expected.

. Conducted user training to familiarize them to the new application and

to use this application for effective decision-making, planning.

Environment: OBIEE 10.1.3.4, Oracle 10g, Informatica 8/7.1, Windows Server

2005.

Millennium Pharmaceuticals, Cambridge, MA

August 2008 - June 2009

OBIEE Consultant

Millennium Pharmaceuticals applied world-class recombinant technology to

the discovery and development of innovative new therapies in a broad

spectrum of diseases. The project "Drug Sales Tracking System (DSTS)" was

initiated to restructure the business process by analyzing the gain/loss

revenue and to take effective business decisions.

Responsibilities:

. Created a multi-user developer (MUD) environment to enable multiple

developers to work on one repository.

. Worked on Oracle BI EE Administration tool for customizing the

Physical layer, Business layer, Presentation layer and modifying it

according to the business requirements.

. Created Connection pools, imported physical tables and defined joins

in the Physical Layer.

. Created Dimension hierarchies and level based measures to drill down

to the most detailed level of data.

. Used the expression builder to create new logical columns and

calculation measures.

. Created presentation catalogs and organized tables and columns in

presentation layer as per the requirements.

. Extensively created variables and initialization blocks in the

repository to implement security at various levels.

. Worked Extensively on OBIEE Answers to create Reports (Product

Profitability, Revenue Ratio, etc as per the client requirements.

. Created dashboards (General Ledger, Profitability) with global

filters, prompts, aggregate navigation, and with drill-down

capabilities.

. 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 summary and detail reports.

. Used OBIEE Delivers to Schedule IBots queries, to obtain weekly

reports and to send alerts to related users (Revenue Manager, etc

. Implemented different caching techniques to improve the performance.

Environment: OBIEE 10.1.3.2, Informatica Power Center 7.1, Windows Server

2003.

COSTCO WHOLESALE, Sterling, VA December

2007 - July 2008

OBIEE / ETL Consultant

Costco Wholesale Corporation operates an international chain of membership

warehouses, mainly under quality and name typically found at conventional

wholesale sources. The project "Sales Analysis" is about providing various

analytical and decision support reports like Sales by region and Sales by

category and period. These reports were used by Senior Management as a

means of tracking various sales related activities.

Responsibilities:

. Customized the existing repository in the 3 layers (Physical, Business

Model & Mapping, Presentation layer) based on the new business

requirements.

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

measures using Ago and To Date functions.

. Implemented object level security for both repository objects and web

objects by creating users and groups in repository and web catalog

groups in the Presentation Services.

. Developed Reports using different Views (Pivot Table, Chart, and

Narrative view, etc

. Created Interactive Dashboards with drill-down capabilities, filters

and Dashboard and Page Prompts.

. Involved in setting up IBots to run reports at scheduled time using BI

Delivers.

. Worked extensively with the Oracle BI Publisher in creating highly

formatted reports using different data sources. (OBI Answers and

Database).

. Created Source definitions from Flat Files, xml files, excel files,

Oracle DB, Imported Target definitions and created reusable

Transformations, mapplets in Shared folder.

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

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

. Involved in optimizing the performance at various levels (Mapping

Level, Session Level and Database Level).

Environment: OBIEE 10.1.3.x, Informatica 6.1, Oracle 8i/9i, SQL, LINUX.

MICROLAND, Bangalore, INDIA March 2006 -

November 2007

ETL Developer

"Central Data Warehouse" is a Data Warehouse project that is carried out

for Microland's Europe Client (Deutsche Telecom) that provides seamless

mobility products and solutions across broadband, embedded systems and

wireless networks. The system analyzes the products and sales. The system

also provides the previous data/history to speculate the trends seasonally

and by region.

Responsibilities:

. Involved in gathering business user requirements.

. Extracted the data from Flat files and loaded the data into Oracle

using Informatica Power center.

. Created shortcuts for source and target and also created Reusable

Transformations in Shared Folder.

. Extensively used Informatica client tools - Source Analyzer, Warehouse

designer, Mapping Designer, Mapplet Designer, Transformation

Developer, Informatica Repository Manager and Workflow Manager.

. Worked on the Informatica Admin Console when the issues were not

solved at the session/workflow level.

. Worked extensively on different types of transformations like Source

qualifier, expression,

. Router, filter, update strategy, Connected and Un-connected lookup

and Normalizer.

. Created sessions, work lets and workflows for carrying out test loads.

. Created the Deployment groups to move the workflows from one

environment to the other.

. Designed/created the plan for the Master workflows that are to be

scheduled to run on daily and monthly basis.

. Performed the performance evaluation of the ETLs for full load

cycle.

. Checked Sessions and error logs to troubleshoot problems and also used

debugger for complex problem troubleshooting.

. Identified and fixed bottlenecks and tuned the complex Informatica

mappings for better performance.

. Created test cases for carrying out unit testing and part of

functional testing.

Environment: Informatica Power Mart 6.1, Oracle8i, UNIX, Windows 2000.

State Life Insurance Corp, Hyderabad, INDIA May

2005 - February 2006

ETL Developer

State Life Insurance is the nation's largest publicly traded health

benefits companies offering a diversified portfolio of health insurance

products and related services. The aim of the project "Suraksha" is to

monitor and maintains all kinds of insurance claims in different aspects.

It validates and registers the claims and then processes accordingly. This

also handles customer transactions with the company. This keeps track of

the transaction history.

Responsibilities:

. Collected user requirements and worked on the project plan to

implement ETL Solutions per specifications from the Business user.

. Involved in developing reports for claims auditing.

. Designed and constructed the ETL program/object specifications to meet

system and architecture requirements.

. Participated in data modeling tasks to ensure Informatica can

efficiently manipulate data models.

. Develop and Implement ETL processes using Informatica client tools -

Designer, Workflow Manger and Workflow Monitor.

. Created Mappings using Mapping Designer to load the data from various

sources using different transformations like Aggregator, Expression,

Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier,

Normalizer, Stored Procedure and Update Strategy.

. Documented each of the mappings that were created.

. Involved in writing Stored Procedures.

. Involved in performance monitoring by eliminating bottle necks at

different levels.

. Involved in Unit testing, Integration testing and User Acceptance

testing to check whether the data is loading into target, which was

extracted from different source systems according to the user

requirements.

. Ensure the stable operation of ETL processes in the production

environment to agreed service levels.

Environment: Oracle 8i, Informatica 6.1, SQL, PL/SQL, SQL*Loader, Developer

2000, Windows 98.

Contact this candidate