Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Ganga P Chandran

Data Engineer
Thiruvananthapuram

Summary

Dynamic data engineer with a proven track record of working on scalable data pipelines for large datasets. Proficient in Python and SQL programming, optimizing database performance. Experienced in leveraging AWS services for cloud solutions, data transformation, ETL pipelines, and data warehousing. Skilled in analyzing complex data, identifying issues, and drawing sound conclusions. Committed to continuous learning and implementing best practices for innovative solutions. Strong written and oral communication skills, with a proactive approach to contributing beyond basic responsibilities.

Overview

1823
1823
years of professional experience
6
6
years of post-secondary education
2
2
Languages

Work History

DATA ENGINEER

IBS Software
Thiruvananthapuram, Kerala
09.202 - Current
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and pipeline stability
  • Maintained data pipeline while ingesting streaming and transactional data across various data sources using Redshift, S3, and Python
  • Worked with client to understand business needs and translate those business needs into actionable documents to create the base of ETL processes
  • Designed and optimized PostgreSQL databases for storing financial data, improving query performance
  • Evaluated SVN for version control of data processing scripts ensuring 100% code consistency and traceability
  • Adopted parquet as a default storage format, reducing storage cost by 22% and speeding up data retrieval time by 3 minutes.
  • Collaborated in the implementation of AWS IAM policies, enhancing security measures and reducing unauthorized access incidents
  • Designed and implemented effective database solutions and models to store and retrieve data
  • Prepared documentation and analytic reports, delivering summarized results, analysis, and conclusions to stakeholders
  • Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls

Education

B.Tech - Computer Science

APJ Abdul Kalam Technological University
Kottayam, India
07.2018 - 07.2022

Class XI-XII -

MES Indian School
Qatar
03.2016 - 03.2018

Skills

Python Programming

Projects

Blue Lake, Airline [ANA - All Nippon Airways] - Japan, Migration to New Technology. Blue Lake is a data infrastructure that combines a data lake and data warehouse that makes the most of cloud technology and services while leveraging existing systems to achieve high flexibility, robustness, and economy., Collecting data from different sources depends on business systems and databases and gets cleansed, mapped, and transformed into a quality data set loaded to Redshift based on the schema level., Moreover, push the cleansed data to Targeted Databases., With the help of AWS services, creating each job for transforming data using PySpark in AWS Glue., Calling the glue job using shell scripts, and loading data to Redshift are the main operations present in Bluelake.

Timeline

B.Tech - Computer Science

APJ Abdul Kalam Technological University
07.2018 - 07.2022

Class XI-XII -

MES Indian School
03.2016 - 03.2018

DATA ENGINEER

IBS Software
09.202 - Current
Ganga P ChandranData Engineer