Summary
Overview
Work History
Education
Skills
Languages
Date Of Birth
Disclaimer
Timeline
Generic

Sai Gangadhar Reddy C

Chennai

Summary

ETL DataStage Developer with 5.11 years of experience at RNTBCI & Cognizant, specializing in DataStage and SQL. Demonstrated expertise in optimizing ETL processes and addressing intricate data challenges, showcasing exceptional problem-solving capabilities. Proficient in performance tuning and incident management, guaranteeing superior data delivery in high-pressure environments.

Overview

6
6
years of professional experience

Work History

ETL Datastage Developer

Cognizant
10.2023 - Current
  • Company Overview: Unum Data RPO -Cognizant Data
  • Unum RPO -Cognizant Data is a project which deals with Finance -Broker Compensation /Policy and Claims information. The Project majorly works on the premium allocation process for broker compensation and different clients.
  • Work on the ETL/Datastage Enhancements and developments in the project.
  • Data Comparison and Data Quality Check between the source systems & target systems and the downstreams.
  • Work on the premium allocation process for different clients.
  • Fixing the abended jobs and working on the audit fixes, Problem tickets for different jobs failing regularly, handling the incidents.
  • Unum Data RPO -Cognizant Data

ETL Datastage Developer

Cognizant
05.2023 - 09.2023
  • Company Overview: AIG - Project Renaissance -Claims TPA
  • Project Renaissance -Claims TPA is a project which deals with Policy and Claims information. The Project currently working on the migration of data from PCG DWH to outbound systems (MGA & Sedhwick). There are multiple sources from which the data is loaded to DWH via ETL Code.
  • Analyze the existing ETL jobs for mapping various sources to the Data Ware house columns.
  • Data Comparison and Data Quality Check between the source systems & DWH.
  • Finding out missing claims data using SQL.
  • Working on End to End mapping of the Columns for all the source systems.
  • AIG - Project Renaissance -Claims TPA

ETL Datastage Developer

Renault Nissan Technology and Business Centre India
Chengalpattu
08.2019 - 04.2023
  • Having 4.7 years of experience in Vehicle Information Domain as Data warehousing (SQL, Oracle, Linux, UNIX, Teradata, ETL) & in Finance/Policy/Claims data projects.
  • Experience in Data stage using components like Data stage Designer, Data stage Director and Data stage Administrator.
  • Developed parallel jobs using different stages like Sequential file, Dataset, Transformer, Aggregator, Lookup, Join, Sort, Copy, Pivot Enterprise, Merge, Funnel, Change Capture, sequence activity stages and Filter.
  • Highly experienced in working in a strict validated environment which involves development of new modules, unit/system testing, documentation and deployment activities.
  • Designed Documents like ETL mapping Documents, Design Specification documents, Test Case documents.
  • Strong in data base management concepts.

Education

Bachelor of Engineering - Electronics and Communications

Sathyabama University
Chennai
04.2019

Intermediate -

Narayana Junior College
Kadapa
04.2015

S.S.C -

Vijetha High School
Hyderabad
04.2013

Skills

  • ETL DataStage development
  • SQL proficiency
  • Linux/Unix scripting
  • Teradata expertise
  • Performance tuning
  • Problem solving
  • Data warehousing
  • Agile methodology
  • Incident management
  • Job scheduler knowledge (Control-M and Autosys)
  • SQL query optimization

Languages

  • English
  • Telugu
  • Tamil
  • Hindi

Date Of Birth

10/16/97

Disclaimer

I hereby solemnly declare that all the statements made in the application are true and correct to the best of my knowledge.

Timeline

ETL Datastage Developer

Cognizant
10.2023 - Current

ETL Datastage Developer

Cognizant
05.2023 - 09.2023

ETL Datastage Developer

Renault Nissan Technology and Business Centre India
08.2019 - 04.2023

Bachelor of Engineering - Electronics and Communications

Sathyabama University

Intermediate -

Narayana Junior College

S.S.C -

Vijetha High School
Sai Gangadhar Reddy C