Data Project
Resume:
Nagendra Babu Ramisetty
Technical Lead – ETL (Teradata / Informatica/ SSIS)
Richardson, TX 75081
*.**********@*****.*** – +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