Sr Developer & Analyst

KV kishore Mobile : +91-997*******

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

Professional Summary

• Having 2+ years of experience in development of Data warehousing solutions using Teradata.

• Knowledge in Teradata data warehouse architecture.

• Extensively worked with Teradata SQL Assistant.

• Currently Working with Teradata12 Utilities like BTEQ, FastLoad, MultiLoad,fast export.

• Creating and modifying scripts like Fload, Mload, and Fastexport.

• Familiar with SQL extensively by using Joins, Sub Queries, Set Operations, and OLAP Functions.

• Worked error handling with the help of ET, UV and WT tables. And worked with collect statistics, join indexes etc.

• Knowledge in UNIX.

Educational Qualification:

• B Tech (computer science& engineering) from JNTU Kakinada in 2009.

Work experience:

• Organization : Valtech Pvt Ltd.

• Date : July 2009 to Till Date

Technical Skills:

Database Teradata12

Application Utilities BTEQ, FastLoad, MultiLoad, FastExport.

Query Languages SQL.

Operating System Windows, UNIX

Programming Languages C++,Java

Projects Handled:

#2-Project (Oraganization: Valtech)

Project Name : Sales Analysis System.

Client : East West Chain of Stores, South Africa.

Environment : Teradata12,Windows XP.

Role : Teradata Developer.

Duration : Aug 2010 to till date.

Description :

EWC has 100 Grocery stores spread over in South Africa. Each store has a full complement of departments including Grocery, Frozen Foods, dairy, meat etc.This project helps middle level management and store to improve the over all sales of the products by analyzing the history of products data with current data. In this project data from various online transaction processing(OLTP) applications and other sources is selectivity extracted, related, transformed and loaded into Teradata Warehouse using BTEQ, MULTILOAD, FASTLOAD, FAST EXPORT .

Responsibilities:

• Performed major role for understanding the business requirements.

• Creating appropriate indexes dependent on table situation and requirements.

• Got Familiar with Teradata tools and utilities like Fastload, Multiload and Fast Export. Understood the purpose of each utility under different scenarios and requirements.

• Involved in writing the scripts for loading of data from several flat files using Teradata BTEQ, Fast Load and Multiload utilities.

• Developed Teradata macro’s to implement Business Logic.

• Involved in Error Handling.

• Involved in UNIT testing and preparing test cases.

#1-Project (Oraganization: Valtech)

Project Name : Write Off and Profit Analysis.

Client : USA Mobility Inc, RICHMOND,VA, USA

Environment : TeradataV2R6,UNIX.

Role : Teradata Developer .

Duration : May 2009 to Aug 2010.

Description :

USA mobility Inc head quartered in Alexdria, Virginia is the nation 2nd largest

Wireless messaging provider offering paging product other wireless services to business and individual subscribers.This project is to develop analytical reporting system on top of data warehousing.

Responsibilities:

• Undergone intensive training in Teradata Relational Database Management System.

• Worked on Promoting the changes.

• Familiar with concepts involving different types of indexes, joins for optimizing performance of Teradata

• Extensively worked in data Extraction, Transformation and Loading from source

to target system using BTEQ, Fastload and Multiload.

• Developed BTEQ scripts to add the logic to get the related data from the source DB.

• Involved in Ensuring timely and defect free delivery.

Contact this candidate