Sales Data

Over * years of professional IT experience as BI/Data Warehouse Analyst and

as Functional/Tech lead for BI projects in various domains like Sales,

Manufacturing, Finance and Marketing. Experience includes data

architecture, data modeling, working on ETL processes, Business

Intelligence (BI) technologies and on different databases like Oracle, MS-

SQL Server, Teradata. Design, Development and Implementation of Data Marts

with ETL & OLAP tools using strong relational & multi-dimensional database

modeling skills. Extensive experience in using BI reporting tools like

OBIEE (Siebel Analytics) and ETL tools like Informatica.

EXPERTISE:

> Lead DW/BI development teams delivering the projects on time as per

Business reporting needs on different domains like Manufacturing,

Marketing, Finance and Sales.

> Extensively worked on providing decision support systems for executives,

managers and different Global business partners (GBPs) in the

organization.

> Assisted the project manager in creating project plans, work breakdown,

timelines, risk assessments and deliverables.

> Experience in creating project plans, technical and functional design

documents and ETL data mappings by translating the business user project

needs.

> Worked on all phases of data warehouse development lifecycle (SDLC) and

agile methodology including requirements gathering, design, development,

testing, implementation and support.

> Expert in Impact Analysis, Application Design, Data Mapping, Interface

analysis and ETL design.

> Participated in Logical Data Modeling (LDM) and Physical Data Modeling

(PDM) sessions to design the database tables as per business and

reporting requirements in third Normal Form (3NF)

> Experience in implementing full life cycle Datamarts with Star and

snowflake schemas and designed the tables considering Slowly Changing

Dimensions and dimensional modeling techniques.

> Extensive knowledge in physical and logical data modeling using ERwin

data modeling tool.

> Installing and configuring Oracle Business Intelligence tool (OBIEE) and

have hands on experience with OBIEE 11.1.7/ 10.1.3 and Siebel Analytics

7.8.4, 7.7 and 7.5.3.

> Worked extensively on OBIEE Answers, dashboards, Delivers using BI

Presentation Services and extensively worked on earlier versions of OBIEE

i.e Siebel Analytics Answers and Siebel Delivers etc;

> Analyzed, Designed and developed multiple end to end BI Tasks such as

repository (rpd) development, OBIEE dashboards and reports.

> Extensively worked in Extraction, Transformation and Loading (ETL) of

data from multiple sources in DWH using Informatica tool and have hands

on experience with Informatica 9.5/9.1/8.6.1.

> Extensively worked on Informatica PowerCenter components from 6.1 to 9.5

like Repository Manager, Mapping Designer, Server Manager, Workflow

Manager and Workflow Monitor, Re-Usable transformations, mapplet

designer, performance tuning, error handling, and Informatica best

practices.

> Experience in performance tuning after identifying the bottlenecks in ETL

process at various components like sources, mappings, targets and

sessions using database tuning, partitioning, aggregate tables(MT

tables), load strategies, commit intervals.

> Extensive Knowledge in deployment process using Kintana SCM, PVCS

(version control) and running the batch jobs using Dollar Universe, TIDAL

software and knowledge of shell scripting.

> Experience working with Teradata utilities like MLOAD, Fast Load, TPump

and BTEQ.

> Experience in Agile Product Life Cycle Management (PLM) Datamart and

configuring the ODI tool to extract the data from Agile PLM data source.

> Experience in troubleshooting, root cause analysis, providing the long

term fixes and knowledge of using Mercury Quality Center.

> Strong experience in writing complex SQL Queries, PL/SQL stored

procedures, triggers, packages and creating tables, indexes and views.

> Interacted with cross functional teams and other teams like Quality

Assurance (QA), Release Management, Production Ops and all other teams

who are involved in System Development Life Cycle.

> Actively involved in providing training to end users and also have good

knowledge on on-site/off-shore model.

> Excellent problem solving skills with a strong technical background and

result oriented team player with excellent communication and

interpersonal skills.

Education: Master of Science (M.S.) in Electrical and Computer Engineering

TECHNICAL SKILLS

Reporting Tools: OBIEE 11.1.1.7/10.1.3, BI Publisher, Siebel Analytics

7.8.4,7.7.1.2/7.5.3, Agile PLM Datamart, Tableau

ETL Tools: Informatica PowerCenter 9.5.1/8.6.1/8.1.1/7.1.2/6.1,

PowerMart 6.2/5.1, Infdormatica

DAC, Oracle, Data Integrator-ODI

10.3,

Database: Oracle(11g,10g,9i), Teradata 14/13/V2R6,MS-

SQLServer(2007/2005),MS-

Access

Database Utilities: Teradata MLOAD, FastLoad, TPump, BTEQ, Fast export,

TOAD 10.5/9.0/7.1, SQL

Loader

Database Skills: SQL Optimization in SQL Server, Stored Procedures,

Database Triggers, and Packages, Database design,

Normalization

Data Modeling Tools: AllFusion ERwin DM 4.1.4/3.5.2, Microsoft Visio

Testing tools: Mercury Quality Center, Mercury Quick Test

Professional

Languages: SQL, PL/SQL, C, C++, JavaScript, UNIX Shell Scripting

Technologies: HTML, DHTML

Web Servers: Tomcat 4.1.1, Microsoft IIS, Apache Server 2.0

Operating Systems: Windows 7/XP/NT/2000, Red Hat Linux, UNIX (Solaris,

HP-UX, IBM AIX)

Other Tools: Dollar Universe, Tidal, Kintana SCM, PVCS (version

control), Golden Gate

Sr. OBIEE Consultant/Lead Feb' 14

- Till Date

Good Technology, Sunnyvale, CA

Good Technology through their products and apps like Good for Enterprise

(GFE), Good Connect, Good Dynamics delivers comprehensive secure mobility

solution. The company focuses on security of the data as well as the

devices. As a Sr. OBIEE Consultant led the BI team and worked on Good Tech

Revenue Reporting dashboard and worked on replacing Actuate reports into BI

Publisher and OBIEE dashboard.

Good Technology has engaged KPI Partners Inc. to assist with a recovery and

continuation of their OBI system and underlying data warehouse efforts.

Implemented reporting content related to Revenue Analysis, Carrier Billing

and Customer Care. The goal of this effort is to decommission Actuate by

moving the solution to OBI.

> Handling team with 4 ETL and OBIEE Developers.

> Participated in all project phases including Design, Coding, Testing and

Production

deployment with documentation.

> Involved in gathering business requirements and created Data Model

Reference Guide (DMR)

and mapping documents.

> Responsible for creating analysis documents, estimates, project

specifications

> Responsible for assigning tasks to onsite and offshore team members and

reviewing work done periodically during the week

> Worked in BI Apps environment with Finance, Order Management modules.

> Designed and worked on Revenue Reporting dashboard which gives revenue

metrics based on Geo, Channel and Industries.

> Extensively worked on OBIEE rpd and reporting UI by following best design

practices to achieve standards.

> Worked on MUD (Multi User) environment and extensively worked on OBIEE-

BM layer to build additional measures which will give more flexibility to

business users for more analysis

> Involved in assessing the effort to replace Actuate reports to OBIEE and

BI Publisher reports.

> Worked on BI Publisher list reports and have experience building reports

and layouts using rtf templates.

> Extensively worked on BI Publisher layouts parameters, triggers and

worked on delivering & scheduling the reports.

BI Analyst/Data (ETL) Analyst

Jun' 09 - Jan' 14

EDW-GBS team, CISCO Systems, Milpitas, CA

As Sr. BI/Data Analyst worked on various Data Warehouse/BI applications

providing solutions for the Global Business Service group covering

marketing analytics, opportunity analytics, metrics for sales users, new

product implementation (NPI) yields and usage metrics. Designed and

developed several Datamarts for Marketing IT through ETL Process and

developed multiple BI dashboards and reports using OBIEE.

Application -- Customer Intelligence Center (CIC)

CIC offers through its intelligent dashboard design offers the ability for

users to drill millions of data to extract business insights and

intelligence for strategic and tactical decision making. The dashboard

supports innumerable capabilities pertaining to the functional

organizations like Marketing, Sales and Finance.

Additionally CIC Opportunity Analytics dashboard offers a wide range of

information for sales territory managers to identify their top accounts,

cross-sell/up-sell and new opportunities across all products and propensity

to buy across all customers.

Responsibilities:

> Created data models, built Informatica ETL processes including

dimensional data modeling primarily star schema, performed data migration

and executing large projects with quality.

> Designed Marketing performance metrics covering targets, responses, leads

and associated derived measures by analyzing marketing investments across

campaigns & programs in marketing ODS.

> Involved in data analysis for Product Hierarchy from TG to BU to PF to

PID and come up with ETL design to load the hierarchical tables.

> Designed and prepared the technical specification document (TSD) and ETL

design documents and share with integration and development teams.

> Design the required dimension and fact tables which satisfy the OBIEE

reporting requirements by coordinating with BI development and other ETL

development teams.

> Exclusively worked with Informatica and Teradata teams to come up with

control tables for smooth execution of ETLs

> Extensively worked on evaluating the ETL work done by development team by

analyzing the data flow, Informatica mappings, workflows and recommending

best practice methods for better performance.

> Developed parameter file templates and used variables and parameters in

the ETL mappings for more flexibility and developed shell scripts to

automate the process

> Designed and developed complex ETL Informatica mappings using various

transformations and developed pre and post session tasks to manage the

indexes for better performance at ETL runtime.

> Worked with Enterprise Release Management team (ERMO) for the project

scope and release dates and also involved in coordinating with

development, QA, performance and Ops team to explain the project details.

> Designed OBIEE rpd design considering the star schema models and

developed OBIEE dashboards and reports using BI Answers.

> Extensively worked on analyzing and building the data model for Marketing

Campaigns, Leads, Targets and Responses coming from sales force.

> Involved in administering permissions and privileges to groups and users

for Dashboard visibility based on their role and responsibility.

> Involved in Unit, Integration, System and Business Validation Testing of

generated reports and supported user acceptance testing team.

> Involved in design and code reviews and documenting the standards, best

practices and Informatica procedures.

> Lead onsite and offshore teams in implementing solutions under the Global

Business Delivery model.

CDFC and Usage Analytics Project

Customer Digital Footprint Cisco(CDFC) project will assist sales team by

providing deeper visibility into their customer's cisco.com activities,

possible purchasing behavior, opportunity confirmation and advance

knowledge of customer interests based on scores and alerts provided by

Visual Science team.

Usage Analytics is a common platform where it shows the usage of all OBIEE

application dashboards at one place where the higher management can see the

adoption rate and usage metrics.

Responsibilities:

> Coordinated with main stakeholders to comprehend project requirements and

prepared their detail definition for implementation.

> Designed and developed ETL mappings with truncate and incremental logic

to pull the records and archiving the records over the period because of

huge growing volume of data on daily basis.

> Extensively worked on creating the aggregate tables based on the logic to

calculate score for each customer.

> Developed the OBIEE rpd as per the design and worked in BMM Layer for

additional measures.

> Coordinated with other cross-functional teams to get their OBIEE usage

and modeled the tables to gather and store in one common table.

> Configured Business Model Layer/Logical layer by creating facts and

dimensions. Have created hierarchies to enable drill down in reports.

> Involved in piloting the Usage Analytics project and presented the

estimates and feasibility of the dashboard and then designed to implement

on Production

Sr ETL Developer/BI developer Oct' 06

- Jan'09

IT Manufacturing, Cisco Systems, San Jose, CA

Global Supply Chain Management (CVCM team)

Under Quality Management System (QMS) project, the Quality IT team

developed business reports across all organizations under Product Life-

Cycle Solution (PLS) such as Failure Analysis operations, FA sites, Quality

Engineering, Customer advocacy and Manufacturing. Agile, Informatica 8.1

and OBIEE have been used to meet the end-to end business requirements.

Environment: Oracle Business Intelligence tool (OBIEE)/Siebel Analytics

10.1.3/7.8.4, Informatica Power Center 8.1/7.1.4, Oracle 10g/9i, UNIX,

WinNT, Telelogic System Architect, Agile PLM, TOAD 9.0/7.6

As an OBIEE/Informatica developer under Segregation of Yields (NPI)

dashboard project, we built a new dashboard which provides First Pass Yield

(FPY) metrics which in turn creates visibility to manufacturing FPY for

Pilot build and Early Production Yields before the First Customer Shipped

(FCS) Date. This implementation enables users to monitor and drive

continuous improvement for FPY and reduce time it takes to bring FPY to

TTQV.

> Analyzed business requirements and translate them into Functional and

Technical Design documents.

> Designed and developed the Datamart and report metrics to provide a

unified view of the Failure Analysis of the Cisco products.

> Involved in data analysis and reviewing the Kimball Matrix to identify

the dimensions, facts, measures and hierarchies.

> Created complex derived measures and level based metrics in the BMM

layer.

> Configured Business Model Layer/Logical layer by creating facts and

dimensions. Have created hierarchies to enable drill down in reports.

> Defined Foreign keys in the Physical layer and the complex joins in the

BMM layer of the repository.

> Worked on creating the dimension level hierarchies for the dimensions and

specified level based measures.

> Extensively worked on using the initialization (init) blocks and

variables.

> Worked on building the Siebel dashboards, pages and reports as per the

business requirements.

> Developed different kinds of report views like pivots, charts and tabular

and also worked on the Guided Navigation.

> Worked on the new features in OBIEE like presentation variables in the

reports

> Enforced object-level and data-level security to different users and

groups.

> Extensively worked on creating the Informatica mappings, workflows to

build the data warehouse tables needed for reporting.

> Analyzed and transformed the Agile source data tables into 3NF form using

the ETL techniques.

> Involved on working with database views, MVs, PL/SQL queries and defined

the process for loading the data into staging tables.

Agile PLM Datamart using Oracle Data Integrator (ODI)

Worked on POC project on Agile PLM Datamart which stores all relevant data

available in the PPM, PC and PQM modules of the Agile PLM

> Involved in delivering the normalized schema database that captures the

business object data of Common, PC, PPM and PQM objects and their related

data.

> Worked on the Agile Datamart which supports incremental extraction for

Cover Page, Page 2 and Page 3 data of business objects at transactional

side.

> Worked on the Agile PLM Datamart packages pre-built ETL that leverages

Oracle Data Integrator (ODI) technology.

> Worked on the ODI operator which can schedule and run the scenarios that

extract, load and transform (ELT) the Agile PLM Transactional data into

the Agile PLM Datamart.

Manufacturing & Engineering Quality Unit - ETL/Siebel Analytics Development

The Quality team in the Manufacturing Department has implemented Repair

Data Enablement (RDE) Operational Metrics project which enable creation of

new repair record types allowing easy retrieval of performance data. This

implementation will benefit the CRM performance comparisons and early

identification of quality and training issues. Informatica 7.1.4 and Siebel

Analytics 7.8.4 have been used to implement and build the ad-hoc

environment for the required metrics.

> Involved in Data Analysis and reviewing the Kimball matrix to identify

the Dimensions, Facts, Measures and Hierarchies.

> Involved on working with database Views, Materialized Views, SQL queries

and Defined the process for loading the data (staging).

> Developed and maintained technical documentation from source to target

load process and ETL Informatica development process.

> Created mappings using various Transformations in Informatica like

Aggregator, Expression, Filter, Router, Joiner, Lookup, Update strategy,

Source Qualifier, Sequence generator.

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

sequential and concurrent Sessions.

> Expertise in multi-user environment in Siebel Analytics where the check-

in and check out process have been extensively used.

> Expertise in deploying the analytics rpd and catalogs and migrating from

one environment to another.

> Created connection pools, physical tables, schema folders and catalog

folders in the physical layer of the Siebel Analytics repository.

> Provided the ad-hoc environment to the business users and trained them to

create the reports.

> Created indexes and tuned the SQL queries to improve the performance of

Informatica sessions.

Supplier DPMO Project

The project enables DPMO reporting for Supplier using the Autotest

traceability data and repair data for Cisco components. It will have the

ability to measure, analyze and improve the individual supplier quality for

particular class codes.

> Worked on the Auto-test source data to pull the data from MS SQL Server

to the Oracle Staging tables.

> Worked on Informatica mappings to build all the dimension, fact and

aggregate tables.

> Defined and created the required tables, columns, logical tables in the

rpd using Siebel Analytics Administration Tool to configure the rpd and

worked on Siebel Answers for creating the reports.

> Set up page and global Filters in requests for customized reporting and

Performed Custom formatting with html tags in dashboard.

> Created Analytics Reports incorporating Charts and Pivot tables using

Siebel Answers.

Informatica/Siebel Analytics Application Developer

Jul '05 - Oct '06

AT&T / IBM, Middletown, NJ

AT&T, world's largest telecommunications company has recently implemented

Work Flow Support (WFS) to support the process of Sales Forecasting. Under

their eCRM project it has analytical processing team (OLAP) to allow the

users to create and view reports and also analyze the effectiveness of all

the customized supporting sales. Worked in Global Sales Enablement project

which deals with standard and non standard opportunities created by sales

department. Also involved in some of the other features namely Sales Target

(sales target for individual persons), Automation (reports on automation of

submitting Sales Order Requests, Service Availability & Credit Check) and

Contract Analytic (reports on contracting) modules to enhance the sales

team goals.

Environment: Siebel eCommunications and Sales Analytics 7.5.3, Informatica

Power Center 6.1.2, Oracle 9i, UNIX, WinNT, Erwin 4.0, TOAD 6.5.

> Worked closely with the Sales, Marketing teams and participated in the

sessions which involve gathering the business requirements.

> Interacted with system/function engineering team to design the Facts and

Dimensions to configure the metadata.

> Designed RPD based on business requirements by following best design

practices to achieve standards.

> Enforced object-level and data-level security to different users and

groups.

> Identified the granularity level of the data required, facts, dimensions

and Hierarchies of the business model.

> Analyzed the data elements for Forecast and Quota Facts and their

corresponding dimensions.

> Configured Physical layer by importing tables, creating tables and

changing/adding the required physical joins/keys.

> Managed security privileges of each subject area and dashboards according

to user requirements.

> Involved in web catalog (webcat) migration between different environments

using Siebel Catalog Manager.

> Performed end-user training to develop ad-hoc reports using Siebel

Answers.

> Worked on creating Dashboards and placed the respective reports under

each dashboard as per business requirement mockups.

> Designed and Developed ETL routines using Informatica PowerCenter within

the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Source

Qualifier, and Stored Procedures.

> Worked on SDE and SIL mappings in Informatica PowerCenter.

> Worked on migrating ETL repositories and rpds from one environment to

other.

> Prepared and executed the DDLs and DMLs as per the requirements and

created indexes for the purpose of Siebel Answer user's ad-hocing.

> Developed the ETL mappings and configured the sessions as per design

documents to populate the Data Warehouse.

> Scheduling and Monitoring Informatica sessions in Workflow Manager.

References: Available upon request.

Contact this candidate