having 3.5 yrs of teradata

Abhi kumar. P 91-812*******

********.*@*****.***

Summary Teradata Developer

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

• Currently working with Teradata (V2R5 & 12) and created and manipulated many scripts in BTEQ, FastLoad, MultiLoad, FastExport, and Tpump.

• Involved in the development of various transformation to load the data in slowly changing dimensions.

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

• Good knowledge in Teradata data warehouse architecture.

• Good Understanding in protection concepts like Fallback, RAIDs, and Journals

• Done performance tuning of the mappings.

• Knowledge in Teradata data warehouse architecture.

• Worked with collect statistics, join indexes etc.

Work Experience

• Working as a Software Engineer for Hexaware Technologies, Bangalore from July’10 to till date.

• Worked as a Software Engineer for Caterpillar India Private Ltd, Chennai from Dec’07 - Jun’10.

Academic Details

• Bachelor of Science from Acharya Nagarjuna University, Andhra Pradesh.

Technical Skills

Databases : Oracle 9i/8i, TERADATA V2R6, TD12.

Tools & Utilities : BTEQ, FASTLOAD, MULTILOAD, and Query Manager.

Web Scripts : VB Script, Java Script, HTML, DHTML

Operating stems : Windows 9x/2000/XP.

Professional profile

Current Project:

Project Name : Insurance Portal

Client : AMICA,USA

Duration : July’10 to Till Date

Team size : 05

Role : Team Member

Project Description:

This project has the facility to take insurance policy other than life insurance through Internet. This gives all the information about insurance, like policies, agents, offices, and glossary of insurance terminology, online services to some of the policies. Information regarding expiry, renewal, status inquiry, chatting with experts, asking questions which will be answered after one day if not possible by chatting.

Contribution:

• Created and manipulated BTEQ, Fast Load, and Mload Scripts.

• Having Knowledge in TPump, Fast Export.

• Implementing Performance Tuning at various levels.

• Used appropriate indexes such as PI, SI, JI, HI, e.t.c.

• Worked with Error handling by using ET, UV and WT tables.

• Did data reconciliation across source system.

• Creating Unit test cases and implemented unit test results.

• Answered Ad-hoc request of the client by using Function,Enalitical function e.t.c

• Worked extensively to the sql sub queries, joins, set operations and Functions.

• Having good knowledge in DWH, BI concepts.

#2-Project

Project Name : Modesto Bank

Client : Modesto Bank

Environment : Teradata12, Windows XP

Duration : May’09 to June’10

Team size : 05

Role : Team Member

Project Description:

The purpose of this document is to provide you, the stakeholder, with a clear understanding of the requirements identified for the effort. This document contains the detailed system requirements that have been identified, as well as all of the business requirements necessary to implement the identified solution for this effort.

• To increase efficiency and customer service through the development of a user-friendly, web-based banking information system, which will:

• Allow for maintenance of a centralized database for the managers of Modesto Bank

• Function through an interactive user-friendly website with entry, update, add, and delete options

• Deliver the most recent product information to all managers and officers of Modesto Bank via the internet

.

Contribution:

• Involved in writing scripts for loading data to target data warehouse for BTEQ, FastLoad and MultiLoad.

• Involved in the Analysis and design of mapping.

• Carrying out data reconciliation through queries in various source systems.

• Creating appropriate indexes dependent on table situation and requirements.

• Worked with ET, UV and WT tables and did performance tuning.

• Involved in unit testing Involved and Preparing test cases.

#1-Project

Project Name : Electronic Alerts System

Client : Exim Bank

Role : Teradata Developer

Environment : Teradata12, Windows XP

Duration : Jan’08 to Mar’09

Team size : 05

Role : Team Member

Project Description:

This E-Alerts System is basically is used to send alerts to the bank customers. It contains the list of services and alert modes (Email, Hand Phone, Fax) for each service there will be a certain types of alert modes. By using these alert modes, bank will send alert to the customers based on his previous alert mode selection

Contribution:

• Involved in writing scripts for loading data to target data warehouse for BTEQ, Fast Load and Multi Load.

• Involved in the Analysis and design of mapping.

• Carrying out data reconciliation through queries in various source systems.

• Creating appropriate indexes dependent on table situation and requirements.

• Worked with ET, UV and WT tables and did performance tuning.

• Involved in unit testing Involved and Preparing test cases.

• Creating appropriate indexes dependent on table situation and requirements.

• Developed Teradata macros to implement business requirement.

Contact this candidate