Data Analyst Business Intelligence
Resume:
Telu Ramalingeswara Swamy
Sr ETL DWH(Abinitio) Developer and Data Analyst
Email: ************@*****.**.**
Contact Number USA: +1-409-***-****
Experience Summary:
• Around 13 Years of experience in development, design, architecture, testing, Business and Data analysis and implementation with major focus on Data Warehousing, Database Applications and Business intelligence solutions using tools AbInitio, Bigdata Hadoop, Teradata, Linux,Oracle and Hive.
• Strong expertise in Data Warehousing, Business Intelligence, Performance management, Requirements Analysis.
• Having strong knowledge on EDW concepts and very good data analytical skills
• Experience in Ab Initio parallel and serial flow batch graphs, conditional components, other components like reformat, normalize, and join, lookup and graphs processing ASCII and EBCDIC layouts.
• Developing highly efficient ETL system in DATAWAREHOUSING which boosts data processing speed and system performance.
• Well versed with various Ab Initio components such as Round Robin, Join, Rollup, Partition De-partition, Dedup sorted, Scan.
• Good knowledge with Ab Initio tool, application tuning, and debugging strategies.
• Expertise knowledge improving Performance and Troubleshooting of the Ab-Initio graphs and monitoring AB-Initio run time statistics.
• Expertise in Abinitio Performance tuning.
• Experience in AWS S3 and having GCP cloud Engineer Certification
• Experience in L2 and L3 support environment, worked on Priority base tickets (P1,P2and P3)
• Good knowledge in Relational Database Design and Development using Teradata.
• Excellent Experience on different components of Abinitio like Architecture, GDE, Co Operating System, EME, Technical Repository Management tool, Parallelism, DML, transforms, M Utilities, air commands, Variables, Partitioning and Performance Improvement techniques.
• Profound knowledge of Teradata database/utilities (Mload, Fload, Tpump),Unix Korn shell scripts and wrapper scripts for high volume data warehouse instance.
• Hands on experience with scheduling tool Autosys.
• Experience in Abinitio Environment and EME Management, including capacity planning.
• Hands on experience with Testing Life Cycle (Unit Testing, Regression Testing etc.)
• Achieves recognition with good communication skills, maintain excellent interpersonal relations, hardworking and results oriented as an individual and in a collaborative team oriented environment.
Education:
• Bachelor Of Technology (2011) from JNT University – India Technical Skills:
Expertise area : Abinitio (GDE 1.1.4/2.1.6/3.2.5/3.3.2/4.1.3.1), Data Profiler, BRE, Bigdata Hadoop, architect, Business and Data Analyst Database : Teradata 16.10, 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.
Career Profile:
Company Role Location From To
TCS Sr. ETL
Developer/Designer/Business
and Data Analyst
Hyderabad-
India, Irving-
USA
Sep 2011 Till Date
2023- Till date Tata Consultancy Services
Title CITI KYC and Customer HUB
Period Jan 2023 to Till date
Client Name Citi Bank North America, USA.
Position Abinitio Sr Developer, Data Analyst
Responsibilities: Design Flow, Requirement Gathering, Impact Analysis, Design, Development, Unit testing, Code Migration, Deployment, Resolving Production issues. Retail CITI KYC data analysis
Project
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. Operating System Windows Vista/XP, Unix.
Languages SQL, Unix/Linux and Shell Scripting.
Special Software Abinitio, Oracle
Project Location Irving-TX
2017-2022 Tata Consultancy Services
Title Commercial banking-Profitability(CCB)
Period Apr 2017 to Dec 2022
Client Name Citi Bank North America, USA.
Position Abinitio Sr Developer, ETL architect, Business and data Analyst
Responsibilities: 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 Project
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. Operating System Windows Vista/XP, Unix.
Languages SQL, Unix Shell Scripting.
Special Software Abinitio, Teradata,Oracle, Hadoop-Hive, Python Project Location Irving-TX
2014-2017 Tata Consultancy Services
Title G2C(Go to Common)
Period May 2014 to Mar 2017
Client Name Citi Bank North America, USA.
Position ETL (Abinitio) Developer
Responsibilities: Requirement Gathering, Impact Analysis, Design, Development, Unit testing, Code Migration, Deployment,Resolving Production issues .
Project
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. Operating System Windows Vista/XP, Unix.
Languages SQL, Unix Shell Scripting.
Special Software Abinitio, Teradata.
Project Location Irving-TX
2012-2014 Tata Consultancy Services
Title RAINBOW USA NEXTGEN DW, AML and GENESIS
Period July 2012 to Apr 2014
Client Name Citi Bank North America, USA.
Position ETL (Abinitio) Developer
Responsibilities: Requirement Gathering, Impact Analysis, Design, Development, Unit testing, Code Migration, Deployment.
Project
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. Operating System Windows Vista/XP, Unix.
Languages SQL, Unix Shell Scripting.
Special Software Abinitio, Teradata.
Project Location Hyderabad, India.
2011-2012 Tata Consultancy Services
Title Abinitio Developer and Abinitio Upgrade
Period Dec 2011 to June 2012
Client Name Citi Bank North America, USA.
Position ETL (Abinitio) Developer
Responsibilities: Requirement Gathering, Impact Analysis, Design, Development, Unit testing, Code Migration, Deployment
Project
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 code in QA and UAT environments. Certification Google Cloud Associate Cloud Engineer Operating System Windows Vista, UNIX, Linux.
Languages SQL, UNIX Shell Scripting, Linux Shell Scripting Special Software Abinitio, Teradata. Bigdata-Hadoop, Pyhton Project Location Hyderabad, India. And Irving TX(USA)
Contact this candidate