Nagendra Babu Ramisetty

Technical Lead – ETL (Teradata / Informatica/ SSIS)

Richardson, TX 75081

acx6ey@r.postjobfree.com – +1-972-***-****

Summary -

Masters degree in computer applications with distinction

More than 4.6 years of Corporate Experience

Teradata 12 developer Certified Professional

Senior Data Integration Expert having Extensive Hands-on experience in system analysis, design, development and implementation of Data warehousing system using Teradata, Informatica and SSIS systems

Experience and understanding of Data Migration Projects.

Have Successfully Lead Data Integration projects which includes – Data Profiling, Source Extraction, and Bulk File Transfers, Data Modelling, Data Cleansing, transformation & loading of data warehouse/data mart tables.

Extensive Hands-on experience in writing Complex Teradata BTEQ scripts for transforming the Pharmacy Data.

Exposure to multiple ETL and ELT Technologies –Teradata, Informatica, SSIS.

Very Good Hands-on experience in Tivoli Workload Scheduler and Unix Scripts.

Hands-on experience in all phases of a Waterfall SDLC – Requirement gathering, High level & Low Level Design(HLD/LLD), Design Review presentation, Component Integration & System Integration testing (CIT/SIT), User Acceptance testing (UAT), Production Implementation and Warranty Support.

Have Experience in working with Massive data volumes - The biggest table worked on is a 8TB table, which has 900+ attributes and 8Billion + rows.

Good knowledge of Retail and Healthcare domains

Excellent Knowledge & Hands-on experience in Unix Shell Scripting

Worked extensively on data migration from Oracle to Teradata systems and application redesigning

Developed Teradata ELT Scripts and Semantic Jobs to develop semantic layer, consisting of Physical tables and views

Excellent knowledge and Hands-on experience in Defining, Design, Development and implementation of Standard Non Functional and Technical Rules.

Skills

Domain

Pharmacy / HealthCare

2+ Years

Retail / Dotcom

2 Years

Core project Acquired Skills

Last Used

Total Experience

Confidence Scale (Out of 10)

Data warehousing

Current

4.6 Years

8

Teradata 14.00

Current

4.6 Years

8

Teradata Utilities

Current

4.6 Years

8

Power center Informatica 9.5.1

Current

4.6 Years

8

Microsoft SSIS 2010/2012

Oct-14

1.5 Years

6

Microsoft SQL Server 2008/2012

Oct-14

1.5 Years

6

Data Modeling

Current

3 Years

7

UNIX AIX 6.1/ 7.1 / Linux

Current

4.6 Years

7

Tivoli Job Scheduling Maestro

Current

4.6 Years

8

Certifications

Teradata 12 Certified Professional

Dec 2013

Courses

Introduction to the Teradata Database

Teradata Education Network

Introduction to the Logical Data Modelling

Teradata Education Network

Teradata SQL

Teradata Education Network

Education

Master of Computer Applications (MCA)

Andhra University college of Engineering, Visakhapatnam, AP, India

Apr 2012

Work Experience

Technical Lead - ETL

June 2012 to Present

Accomplishments

Was Assigned the Role of Lead in Just nine months of Joining the Company - Since then, have consistently pitched in and played higher roles

Have been Rated Outstanding for Delivery consecutively for the last two years

Cross Trained a team of ten in Teradata and Enterprise data warehousing architecture

Have been the go to person for all DW Concepts and Implementation activities

Meeting Deadlines has become a consistent habit

Successfully implemented 35+ warehouse table and another 100+ landing tables

Completed the Organizational Competency Training and Exams in Data warehouse and integration with merit ratings

Have organized multiple team events in the organization successfully

Detailed Relevant Summary

1. CVS Pharmacy Benefit Management (Jan 2016 – Till date) Role – Technical Lead Team Size – 6

This Project involves Extraction of Member, Claims, and Provider data to the different states like.

Technical Skills

Informatica Power Center

Oracle 11g

Teradata 14.0

Data Modeling

UNIX Shell Scripting

Maestro Scheduling tools

Oracle toad

Responsibility:

Profiling of Source History Data

Analysis of Data submission guide provided by different states.

Setting up meetings with states and gathering the requirements.

Finalizing the requirements and performance by discussing with DBA’s.

Redesign of Application to make the best use of Teradata Platform

Creation of Logical and Physical Data Models of the module.

Creation of Design Documents and Walking through the Client Design review Board

Design, Development and Review of Informatica Jobs

Coordinating and supervising the team for ensuring proper data validations are done

Review of Unit Test, Component Integration and System Integration test cases

Coordinating with the QA and Business user for SIT and UAT

Analyzing the root cause of Defect and fixing them

Maintain Version control of Codes

Creation of Implementation Plans, Change Requests, Project Plans for Code Implementation in Pre-Prod and Prod environments

Transitioning the Application Knowledge to the Prod Support and Business users

Post Implementation Warranty Support

2. CVS Pharmacy Benefit Management (Oct 2014 – Dec 2015) Role – Technical Lead Team Size – 10

This Project involves high volume data migration and Gap filling between Teradata legacy and Teradata EDW

Technical Skills

Informatica Power Center

Oracle 11g

Teradata 14.0

Data Modeling

UNIX Shell Scripting

Maestro Scheduling tools

Oracle toad

Responsibility:

Profiling of Source History Data

Analysis of Legacy Application

Redesign of Application to make the best use of Teradata Platform

Creation of Logical and Physical Data Models of the module.

Creation of Design Documents and Walking through the Client Design review Board

Design, Development and Review of Informatica Jobs

Coordinating and supervising the team for ensuring proper data validations are done

Review of Unit Test, Component Integration and System Integration test cases

Coordinating with the QA and Business user for SIT and UAT

Analyzing the root cause of Defect and fixing them

Maintain Version control of Codes

Creation of Implementation Plans, Change Requests, Project Plans for Code Implementation in Pre-Prod and Prod environments

Transitioning the Application Knowledge to the Prod Support and Business users

Post Implementation Warranty Support

2. CVS Pharmacy Benefit Management (Jun 2014 – Oct 2014) Role – Technical Lead Team Size – 7

This Project involves deeper insights into member analytics for Client migrated to the enterprise adjudication platform from Older. By moving to a single adjudication, Caremark will be able to connect its customers with the very best capabilities and solutions offering on one platform for all the clients.

Technical Skills

Informatica Power Center

Oracle 11g

Teradata 14.0

Data Modeling

UNIX Shell Scripting

Maestro Scheduling tools

Oracle toad

Responsibility:

Profiling of Source History Data

Analysis of Legacy Application

Redesign of Application to make the best use of Teradata Platform

Creation of Logical and Physical Data Models of the module.

Creation of Design Documents and Walking through the Client Design review Board

Design, Development and Review of Informatica Jobs

Coordinating and supervising the team for ensuring proper data validations are done

Review of Unit Test, Component Integration and System Integration test cases

Coordinating with the QA and Business user for SIT and UAT

Analyzing the root cause of Defect and fixing them

Maintain Version control of Codes

Creation of Implementation Plans, Change Requests, Project Plans for Code Implementation in Pre-Prod and Prod environments

Transitioning the Application Knowledge to the Prod Support and Business users

Post Implementation Warranty Support

3. CVS Pharmacy Benefit Management (Jan 2014 – Jun 2014) Role – Technical Lead Team Size – 8

This Project involves Migration of FEP clients from Legacy system to the new data warehouse system.

Technical Skills

Informatica Power Center

Oracle 11g

Teradata 14.0

Data Modeling

UNIX Shell Scripting

Maestro Scheduling tools

Oracle toad

Responsibility:

Profiling of Source History Data

Analysis of Legacy Application

Redesign of Application to make the best use of Teradata Platform

Creation of Logical and Physical Data Models of the module.

Creation of Design Documents and Walking through the Client Design review Board

Design, Development and Review of Informatica Jobs

Coordinating and supervising the team for ensuring proper data validations are done

Review of Unit Test, Component Integration and System Integration test cases

Coordinating with the QA and Business user for SIT and UAT

Analyzing the root cause of Defect and fixing them

Maintain Version control of Codes

Creation of Implementation Plans, Change Requests, Project Plans for Code Implementation in Pre-Prod and Prod environments

Transitioning the Application Knowledge to the Prod Support and Business users

Post Implementation Warranty Support

4. BEST BUY Fort Re-Engineering (Jan 2013 to Jan 2014) Role – Senior Developer Team Size - 30

This Project was a migration project to migrate the sales data from Teradata EDW system to Sql Server PDW System. New Enhancements to meet business requirements were added to existing applications. Performance tuning of long running modules as another scope of this project.

Technical Skill

Teradata 13

UNIX Shell Scripting

SSIS 2012

Tivoli Workload Scheduler

MS Visio

Service Now - SAAS

Responsibilities

Analyze the vast existing application

Perform impact analysis for the implementing the enhancement in the application

Convert Business requirements into technical solution

Complete development, support, maintenance and implementation of the solution

Coordinate with the Business teams to ensure that solution is implemented as expected

Identify long running jobs and the root cause for the same

Performance tuning of the long running jobs

Physicalizing Semantic views into tables

Create Semantic views to Support adhoc business metrics

Maintain Version control of Codes

Creation of Implementation Plans, Change Requests, Project Plans for Code Implementation in Pre-Prod and Prod environments

5. BEST BUY CBG and RASC Support (Jun 2012 to Jan 2013) Role – Developer Team Size - 10

This Project was more of a maintenance project. New Enhancements to meet business requirements were added to existing applications. Performance tuning of long running modules as another scope of this project.

Technical Skill

Teradata 13

UNIX Shell Scripting

Informatica 9.1

Tivoli Workload Scheduler

MS Visio

Service Now - SAAS

Responsibilities

Analyze the vast existing application

Solving the different types of issues related to users and maintaining SLAs

Tuning the Queries which are taking long time to load.

Perform impact analysis for the implementing the enhancement in the application

Involved in Critical Support for Solving High priority Incidents.

Coordinating with the business users to help them out in solving the data issues.

Providing solutions using problem solving skills to analyze and fix the production related issues.

Convert Business requirements into technical solution

Complete development, support, maintenance and implementation of the solution

Coordinate with the Business teams to ensure that solution is implemented as expected

Identify long running jobs and the root cause for the same

Performance tuning of the long running jobs

Physicalizing Semantic views into tables

Create Semantic views to Support ad-hoc business metrics

Maintain Version control of Codes

Awards

Victory League Award

March 2015

Award in Organization for outstanding performance in claims migration data project.

Rock stars of TDL

October 2015

Award in recognition for the Successful Implementation of the TDL Program - The biggest Program implemented ever by the organization in CVS.

Stars Performer Award

August 2016

Award in recognition for the Successful Implementation of the State extract Program – for the state of MD, TN, AR, RI, NH, CT, OR, CO and MA in CVS.

Contact this candidate