Ramalingeswara Swamy Telu
Irving,TX
Summary
Accomplished professional with over 14 years of experience in development, design, architecture, testing, and business and data analysis, specializing in Data Warehousing, Database Applications, and Business Intelligence solutions. Expertise in tools such as Ab Initio, Big Data Hadoop, Teradata, Linux, Oracle, and Hive, with a proven track record of developing efficient ETL systems that enhance data processing speed and system performance. In-depth knowledge of EDW concepts and exceptional data analytical skills, complemented by hands-on experience in performance tuning and troubleshooting within Ab Initio environments. Recognized for strong communication abilities and a collaborative approach to teamwork, consistently delivering results in high-pressure settings.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Sr. ETL Developer/Designer/Business and Data Analyst
Tata Consultancy Services
12.2022 - Current
- CITI KYC and Customer HUB
- Design Flow, Requirement Gathering, Impact Analysis, Design, Development, Unit testing, Code Migration, Deployment, Resolving Production issues. Retail CITI KYC data analysis
- Developing Retail CHUB applications related processes to load EDW from GCIF and other sources and sharing the data with CITI KYC. Data analysis to eliminate data anomalies and resolving data related issues in PROD.
- Carried out the following activities:
- Initial requirement analysis and Impact analysis.
- Design Abinitio flows and review with Business
- Creation of mappings using different types of transformations.
- Development & Enhancement of the project
- Implementation of the application changes
- Resolving the QA & Testing issues/Problems with in the time.
- Involved in System test plan creation based on the requirement and design document
- Involved in preparation of unit test plans and unit testing.
- Tracking the Test Plan/Test Specification vs. Requirements
- Coordination with System Testing team.
- Preparation of training materials
- Documentation and preparation of manuals.
- Supporting QA and UAT testing process.
- Migrating and deploying the ETL code in QA and UAT environments.
Abinitio Sr Developer, ETL architect, Business and data Analyst
Tata Consultancy Services
04.2017 - 12.2022
- Commercial banking-Profitability(CCB)
- Design Flow, Requirement Gathering, Impact Analysis, Design, Development, Unit testing, Code Migration, Deployment, Resolving Production issues. Acted as SME and Business analyst on migrating all CCB related applications to Big data platform
- In this project we load datamart for commercial banking with all commercial data related revenues.
- Carried out the following activities:
- Initial requirement analysis and Impact analysis.
- Design Abinitio and Python flows and review with Business
- Creation of mappings using different types of transformations.
- Development & Enhancement of the project
- Implementation of the application changes
- Resolving the QA & Testing issues/Problems with in the time.
- Involved in System test plan creation based on the requirement and design document
- Involved in preparation of unit test plans and unit testing.
- Tracking the Test Plan/Test Specification vs. Requirements
- Coordination with System Testing team.
- Preparation of training materials
- Documentation and preparation of manuals.
- Supporting QA and UAT testing process.
- Migrating and deploying the ETL code in QA and UAT environments.
- Migrating All ETL CCB applications to Big data Platform in ICG.
ETL (Abinitio) Developer
Tata Consultancy Services
05.2014 - 03.2017
- G2C(Go to Common)
- Requirement Gathering, Impact Analysis, Design, Development, Unit testing, Code Migration, Deployment, Resolving Production issues.
- In this project NEXTGEN and GENESIS data models are going to merge with global data model and we are using agile methodology.
- Carried out the following activities:
- Initial requirement analysis and Impact analysis.
- Creation of mappings using different types of transformations.
- Development & Enhancement of the project
- Implementation of the application changes
- Resolving the QA & Testing issues/Problems with in the time.
- Involved in System test plan creation based on the requirement and design document
- Involved in preparation of unit test plans and unit testing.
- Tracking the Test Plan/Test Specification vs. Requirements
- Coordination with System Testing team.
- Preparation of training materials
- Documentation and preparation of manuals.
- Supporting QA and UAT testing process.
- Migrating and deploying the ETL code in QA and UAT environments.
ETL (Abinitio) Developer
Tata Consultancy Services
07.2012 - 04.2014
- RAINBOW USA NEXTGEN DW, AML and GENESIS
- Requirement Gathering, Impact Analysis, Design, Development, Unit testing, Code Migration, Deployment.
- This project is to develop a Next Generation Datawarehouse, named as NEXTGEN DATAWAREHOUSE and AML that hosts all the CITI account and customer details in the CBNA. The environment will be populated with customer transaction, demographic and behavioral data in one environment that will give a structured, relational holistic perspective of the customers and their activities enabling to perform intense data mining and modelling. GENESIS is a Advanced programme that which uses NEXTGEN as source and newly developed in Citi Bank North America, USA.
- Carried out the following activities:
- Initial requirement analysis and Impact analysis.
- Creation of mappings using different types of transformations.
- Development & Enhancement of the project
- Implementation of the application changes
- Resolving the QA & Testing issues/Problems with in the time.
- Involved in System test plan creation based on the requirement and design document
- Involved in preparation of unit test plans and unit testing.
- Tracking the Test Plan/Test Specification vs. Requirements
- Coordination with System Testing team.
- Preparation of training materials
- Documentation and preparation of manuals.
- Supporting QA and UAT testing process.
- Migrating and deploying the ETL code in QA and UAT environments.
ETL (Abinitio) Developer
Tata Consultancy Services
12.2011 - 06.2012
- Abinitio Developer and Abinitio Upgrade
- Requirement Gathering, Impact Analysis, Design, Development, Unit testing, Code Migration, Deployment
- This project is to upgrade all the CBNA applications developed in AbInitio 114 to AbInitio 311 and also includes the migration of back end platform UNIX to LINUX. The major applications include NEXTGEN, R2 DW & DM, R4, E360, CITIPLANNER, Fraud Data mart. The majority of project work includes testing all the existing functionalities of AbInitio 114 in AbInitio 311 and correspondingly testing the UNIX functionalities in Linux and to make necessary changes on need basis to ensure not to disturb the existing application functionalities.
- Carried out the following activities:
- Initial requirement analysis and Impact analysis.
- Identifying the functionality differences between the versions and to provide an alternative solution.
- Executing each process in both the versions and performing data validations.
- Implementation of the application changes
- Resolving the QA & Testing issues/Problems with in the time.
- Involved in System test plan creation based on the requirement and design document
- Involved in preparation of unit test plans and unit testing.
- Tracking the Test Plan/Test Specification vs. Requirements
- Coordination with System Testing team.
- Preparation of training materials
- Documentation and preparation of manuals.
- Supporting QA and UAT testing process.
- Migrating and deploying the ETL code in QA and UAT environments.
Education
Bachelor Of Technology -
JNT University
India01.2011
Skills
- Expertise area: Abinitio (GDE 114/216/325/332/4131), Data Profiler, BRE, Bigdata Hadoop, architect, Business and Data Analyst
- Database: Teradata 1610, Oracle, Hive
- Scheduling tools: Auto Sys
- Operating System: Linux, Windows 7/XP/NT
- Scripting Languages: Unix/Linux Shell scripting, Python
- DB Tools: Teradata SQL Assistant
Certification
Google Cloud Associate Cloud Engineer
Languages
SQL,Python, Unix/Linux and Shell Scripting
Professional Working
Timeline
Sr. ETL Developer/Designer/Business and Data Analyst
Tata Consultancy Services
12.2022 - Current
Abinitio Sr Developer, ETL architect, Business and data Analyst
Tata Consultancy Services
04.2017 - 12.2022
ETL (Abinitio) Developer
Tata Consultancy Services
05.2014 - 03.2017
ETL (Abinitio) Developer
Tata Consultancy Services
07.2012 - 04.2014
ETL (Abinitio) Developer
Tata Consultancy Services
12.2011 - 06.2012
Bachelor Of Technology -
JNT University