Project Data

KEERTHIREDDY DEVIREDDY

Mobile: 919-***-****

E-mail :********.***@*****.***

SUMMARY:

>

> Around 3.5 years of expertise in leading the ETL projects through all

phases of SDLC right from requirements elicitation till production

support

> Proficiency in designing and implementing Optimized, high quality and

robust ETLS to meet the business requirements

> In depth understanding of Enterprise Data Warehouse Architecture,

concepts of data warehouse modeling approaches Ralph's dimensional

modeling and Inmon's normalized data model and good exposure to the

Data Vault modeling, a database modeling method

> Extensive experience in working with Informatica power center along

with relational databases Oracle, Teradata and heterogeneous data

sources including FLAT files, Excels and XML

> Hands on experience with Informatica Cloud and other ETL tools like

Business Objects Data Services and Open Source ETL tool Pentaho

> Good understanding of Teradata Architecture

> Strong in analyzing and writing complex queries using SQL in Oracle

and Teradata

> Expertise in Job scheduling tool $U(Dollar Universe) and exposure to

DAC

> Expertise in deployment tool HP-Kintana for the migration of ETLS to

higher environments

> Good exposure to UNIX Shell scripts, Linux Scripts and necessary test

plans required to ensure the successful execution of data loads

> Well versed with performance tuning for ETLS and SQLs in Teradata

> Extensive experience in implementing projects using Agile(kanban) and

waterfall methodologies

> Expertise in detail oriented documentations and converting the

Business requirements into technical design documents

> Well recognized for the high quality deliverables

> Good at gaining functional knowledge. Worked as SME for few modules in

Revenue Management

> Strong analytical, debugging and problem solving skills to undertake

challenging jobs

> Excellent communication skills and abilities to interact with various

cross functional teams including business teams to ensure the

successful delivery of the projects

> Quick adaptability to new, emerging technologies with abilities to

work as a good independent player and a very good team player as well

EDUCATION:

.

. Have undergone extensive training on Software technologies at Infosys

Limited for 6 months.

TECHNICAL SKILLS:

.

. RDBMS Tools : Toad, SQL Assistant, SQL Developer

. RDBMS : Oracle9i/10g/11g/R12, Teradata

. Version Control Tools : PVCS

. Deployment Tool : Kintana

. Job Scheduling Tools : Dollar Universe, DAC

. Scripting Languages : Unix Shell Script, Linux Scripting

PROFESSIONAL EXPERIENCE:

Redhat Inc, Raleigh, NC

Jan'14 to till date

Enterprise Maintenance Project

Enterprise Maintenance project is about the maintenance of the Enterprise

Data warehouse of Redhat and the associated Business Intelligence code that

already exists in production for various towers like finance, Engineering,

Operations etc. This project aims at solving the issues of customers in an

agile environment and enabling the business intelligence to the highest

degree in order to enable our customers attain highest accuracy in the

decision making and add value to the business at Redhat.

Responsibilities:

o Interaction with business team for the elicitation of requirements

o Source system Analysis

o Impact Analysis

o Designing ETLs as per the business requirements

o Development of ETLs

o Implementation of Change Data Capture (CDC) for slowly changing

dimensions (SCD type1,type2 and type3)

o preparation of unit test case documents

o Unit testing at various levels of the ETLs

o Scheduling ETLs in the job scheduling tool DAC

o Testing the Scheduled jobs

o Code Reviews

o Root Cause Analysis and resolution of the issues in Production

o Resolve performance bottlenecks by optimizing the mappings, sessions

and workflows

Environment: Informatica, BODS, Pentaho, Infomatica Cloud, Oracle, Linux,

BO, EDW, BAW, Data Vault, DAC.

Technology Lead and Developer

CISCO, San Jose, CA

July'13 to Dec'13

NOSTG Project

NOSTG stands for network operating systems technology group. The NOSTG data

integration enables NOSTG Operations Dashboard to present key metrics and

supporting details of the Business Processes under NOSTG Leadership.

Defined in partnership with the NOSTG Staff, these metrics were developed

to provide visibility into the efficiency and effectiveness of the business

while identifying opportunities for improvement.

Responsibilities:

o Interaction with business team for the elicitation of requirements

o Source system Analysis

o Coordination with offshore and cross functional teams

o High level and Detail level Designing

o Designing ETLs as per the business requirements

o Development and Review of ETLs

o Preparation of unit test case documents

o Unit testing at various levels of the ETLs

o Resolution of performance bottlenecks by optimizing the ETLs using

Push down optimization (PDO) and session partitioning

o Development of scheduling jobs in the job scheduling tool $U

o Testing the Scheduling jobs

o Documentation: Technical specification documents

o Creation of packages in the tool Kintana to migrate the code from one

environment to other

o To ensure successful delivery of the project within the defined

timelines

o Release Management

Environment: Informatica, Oracle, Teradata, Unix, PVCS, Kintana, Dollar

Universe

Technology Lead and Developer

CISCO, San Jose, CA

June'12 to July'13

Integration-EDOS

Cisco acquired Scientific-Atlanta (now known as SPVTG) in 2006; SPVTG was

fulfilling orders and creating enablement files for those orders through

its SAP, PEXP and PIMS systems. Also, at the time of the acquisition, all

of SPVTG's products were being manufactured by their company-owned

manufacturing plant in Juarez, MX. Over the years, the manufacture of

SPVTG products has expanded to include a number of non-Cisco owned

plants/repair centers and the collection of manufacturing data, order

fulfillment and enablement has grown to be a hybrid of many systems,

including SAP, SAP XI, Oracle, HVP, PEXP, and PIMS.

As a part of the SPVTG Acquisition integration program, Cisco is

planning to integrate Scientific Atlanta's current capabilities to support

Enablement Data File generation and distribution via Cisco Core systems.

Enablement Data integration legacy data needs to be migrated from various

systems into Cisco Core Systems.

Responsibilities:

o Source system Analysis

o Coordination with offshore and cross functional teams

o High level and Detail level Designing

o Designing ETLs as per the business requirements

o Development and Review of ETLs

o Preparation of unit test case documents

o Unit testing at various levels of the ETLs

o Resolve performance bottlenecks by optimizing the mappings, sessions

and workflows

o Development of scheduling jobs in the job scheduling tool $U

o Testing the Scheduling jobs

o Documentation: Technical specification documents

o Creation of packages in the tool Kintana to migrate the code from one

environment to other

o To ensure successful delivery of the project within the defined

timelines

o Release Management

Environment: Informatica, Oracle, UNIX, PVCS, Kintana, Dollar Universe

Technology Lead and Developer

CISCO, San Jose, CA

Sep'10 to June'12

NBSO No Touch

This project is intended as a first step towards establishing the full BI

end state vision which includes all BI reporting to use Teradata as its

foundation and to no longer use the SSO DM.

The following FY12 No Touch 360 deliverables were dependent upon

establishing a BI foundation in Teradata:

. 360 Customer/Partner/Sales Multi-Dimensional Business View

. Interactive Platform To Deliver Install Base Visibility

. Identify Opportunity Leads (Architecture, Refresh, Unattached,

Uncovered, Renewal)

. Performance Management Capabilities to Track Conversion Rates to

Drive Growth.

. To Implement existing SSO DM foundational processing that is necessary

for 360 applications

. Additional requirements beyond existing SSO DM capabilities required

for 360/No Touch

Responsibilities:

o Source system Analysis

o Coordination with offshore and cross functional teams

o High level and Detail level Designing

o Designing ETLs as per the business requirements

o Development and Review of ETLs

o Preparation of unit test case documents

o Unit testing at various levels of the ETLs

o Resolve performance bottlenecks by optimizing the mappings, sessions

and workflows

o Development of scheduling jobs in the job scheduling tool $U

o Testing the Scheduling jobs

o Documentation: Technical specification documents

o Creation of packages in the tool Kintana to migrate the code from one

environment to other

o To ensure successful delivery of the project within the defined

timelines

o Release Management

Environment: Informatica, Teradata, Oracle, UNIX, PVCS, Kintana, Dollar

Universe

Developer

CISCO, San Jose, CA

Jan'08 to Sep'10

BIDS - NGCCRM

NGCCRM stands for Next Generation Commitment Compliance Revenue Management.

This project deals with Revenue data .The next generation CCRM is designed

with the goal of eliminating these gaps, reduce costs and improve

efficiency by delivering the following:

Eliminate manual work by providing a powerful system with new features and

capabilities

. Integration of CCRM data with downstream such as EDW (Teradata).

. Introduction of forecasting capabilities

. Reducing the time lag of hold processing.

EDW TD to extract CCRM and RAE related data for downstream reporting.

. CCRM - Admin

. CCRM - Hold Management

. CCRM - Profile Management

. Revenue Accounting Engine (RAE)

Create subscription view for the downstream applications like COGS, etc.

All reporting will be done based on the view created on EDW TD

Responsibilities:

o Acted as SME for few modules

o Source system Analysis

o Coordination with offshore and cross functional teams

o High level and Detail level Designing

o Designing ETLs as per the business requirements

o Development and Review of ETLs

o Preparation of unit test case documents

o Unit testing at various levels of the ETLs

o Resolve performance bottlenecks by optimizing the mappings, sessions

and workflows

o Development of scheduling jobs in the job scheduling tool $U

o Testing the Scheduling jobs

o Documentation: Technical specification documents

o Creation of packages in the tool Kintana to migrate the code from one

environment to other

o To ensure successful delivery of the project within the defined

timelines

Environment: Informatica, Teradata, Oracle, Unix, PVCS, Kintana, Dollar

Universe

CERTIFICATIONS AT INFOSYS:

6 STAR Infoscion Certification

[pic]

Contact this candidate