Teradata Developer

 

Avinash Rai                                                                                                                                                                                       Contact: +91-9990380770|8860001191
Analyst/Teradata SME, Bank of America                                                                                                     Email:    avinash.ims.mca@gmail.com

 

Profile and Experience:
I have 6.6 years of experience in data warehousing which includes Requirement Analysis, design, development, implementation and performance tuning of EDW, ODS, Datamarts and ETL in Teradata, specializing in Banking domain.
 
Primary Area of Expertise:

• Rich experience in Performance Tuning of Teradata EDW which includes SQL tuning, Application tuning, performance tuning of ETL Batches, Tactical Queries, Index and stats optimization.
• Leading team on performance optimization, application design/redesign, code reviews, testing ,deployment and post implementation warranty.
• Setting up processes for Stats collection, Code review, RFC and code migration.
• Experience in migration projects from Oracle to Teradata and Teradata to Vertica.
• Data warehousing solution for Banking.

 
Skill Sets:
Operating SystemsWindows XP/7, UNIX

TeradataTeradata SQL, Teradata Utilities (BTEQ, FASTLOAD, MLOAD, FASTEXPORT, TPUMP, Teradata SQL Assistant, Teradata Stored Procedures.
Performance Tuning

RDBMS
Teradata 13.10, 12, Vertica

ETL Tools and  Scripting Languages
Shell Scripting

Other Tools and Utilities
Shell Scripting, SSH Tectia, Putty, Autosys, Vertica Architecture, Vertica SQL

 
Project experience:
Project Name
CRH (Customer Relationship Hub)

Client     
Bank of America

Company
BA Continuum India Pvt Ltd

Period
July 2014 – Present

Industry
Banking

Project Type
DWH Designing, Migration from Teradata to Vertica

Project Description
In 2013 bank changed its strategy and decided to move its customer data mart to Vertica platform. Previously the customer data is spread among various data marts, which will be consolidated and moved to the new Vertica platform.

Environment
Teradata 13.10 (BTEQ, MLOAD, Fast Export, Fast Load), UNIX (Shell Scripting, Autosys), Vertica, Autosys, Mainframes, Hadoop

 
Objective and Key Result Areas:
Working as SME for VAPs where the roles and responsibilities are:

• High Level and Low level design and development of VAPs. VAPs are key part of CDM. They process the data available in CDM, apply business rules and send it to downstream. I worked on various VAPs, majorly ABT (Asset Based Trigger), RMS (Recovery Management System), EDDS (Expedited Data Delivery System), OCA etc.
• Leading the project and handling Estimate, Impact Analysis, coding and testing, PROD parallel validation, Validating data between Vertica and Teradata.
• Performance tuning of Teradata SQLs and comparing them with Vertica.

 
Project Name
NextGen - Pre Russia Rainbow Implementation

Client     
Citibank

Company
Wipro Technologies

Period
April 2011 - Nov 2011

Industry
Banking

Project Type
Development Project

Project Description
This project is a Database migration project, in which oracle is replaced with Teradata. It also includes the loading the data through Datastage, testing the source files to check whether they satisfy the required schema or not.

Environment
Teradata 13.10 (BTEQ, MLOAD, Fast Export, Fast Load, Teradata Stored Procedure), UNIX (Shell Scripting, Autosys), Autosys

 
Objective and Key Result Areas:

• Migration of Oracle procedures to Teradata procedures.
• Creation/Modification of DDL and DML Scripts and coding Bteq scripts, modification of Jobs.
• Performed Unit testing of scripts.

 
 
 
 
 
Project Name
CLA-ERP-SYNERGY Integration

Client     
NCR Corporation

Company
NCR Corporation

Period
July 2010 - Jan 2011

Project Type
Development Project

Project Description
The purpose is to have all orderable Product IDs in Synergy and CLA countries compliant with GSDB. This will enable a common Product ID structure across countries from various systems, thus facilitating product and financial reporting and analysis using EDW

Environment
Teradata (BTEQ, MLOAD, Fast Export, Fast Load), UNIX (Shell Scripting)

Objective and Key Result Areas:

• Detail Design for the changes needed to provide Industry Reporting Capability.
• Creation/Modification of DDL and DML Scripts and coding Bteq scripts, modification of Jobs.
• Performed Unit/CIT/UAT testing of scripts. As a leader took responsibility to design/develop some part of this project.

 
Project Name
Industry Reporting Phase -3: Portfolio Reporting

Client     
NCR Corporation

Company
NCR Corporation

Period
Nov 2009 - Jun 2010

Project Type
Development Project

Project Description
This project has been taken to provide capability of reporting based on portfolio of the sales team, this capability was not in the existing system. Several Teradata jobs are involved in this project, several base tables and denorm tables needs to be updated. There are several existing Business Object Universes which needs to be updated to provide Portfolio Reporting.

Environment
Teradata (BTEQ, MLOAD, Fast Export, Fast Load), UNIX (Shell Scripting)

Objective and Key Result Areas:

• Detail Design for the changes needed for provide Geography Reporting Capability.
• Designing and developing various load scripts using Multiload scripts for new tables used to store region code and multiple country codes.
• Creation/Modification of DDL and DML Scripts and coding Bteq scripts, modification of Jobs                
• Auditing the overall load and reporting any rejects/issues.
• Performing Unit/CIT/UAT testing of scripts.

 
Project Name
Enterprise Services - Service Request

Client     
NCR Corporation

Company
NCR Corporation

Period
May 2009 - Nov 2009

Project Type
Development Project

Project Description
The Service Request enables the resolution of service requests. It permits customer support agents to manage and resolve requests for service from the time the customer contacts the organization or logs a service request on the Web until the problem is resolved.

Environment
Teradata (BTEQ, MLOAD, Fast Export, Fast Load), UNIX (Shell Scripting)

Objective and Key Result Areas:

• CIT testing of SR datasets.
• Design various load scripts using Multiload scripts for new tables used to store data for the tables of the SR application.
• Developed the code for the UNIX scripts
• Involved in the testing of the final artifacts

Career History:
Company
Date
Position

Bank of America
Feb 2015 – Present
Analyst

Bank of America
Nov 2011 – Jan 2015
Sr. Software Engineer

Wipro Technologies                                                                                               
Jan 2011 – Nov 2011
Software Engineer

NCR Corporation India Pvt Ltd
Aug 2009 - Jan 2011
Software Engineer

NCR Corporation India Pvt Ltd
Jan 2009- July 2009
Intern

 
AWARDS AND RECOGNITION
 

• Promoted to Analyst within 3 years.
• Got the best rating in team for four continuous appraisal cycles.
• Received Silver Award in BA Continuum twice while working in CDM/CRH Team.
• Received Appreciations from Line of Business on the various projects deployed under CDM/CRH.
• Won the first prize in the puzzle competition held at inter college level a IMS Ghaziabad.

 
 
Personal Details:
Date of Birth
March 14, 1985

Sex         
Male

Language Known 
English, Hindi

 
Declaration:
 
I hereby declare that the information furnished above is true to best of my knowledge.
 
Date:                                                                                                                                                                                                          Yours Sincerely
                                                                                                                                                                                                                                     (Avinash Rai)