Summary

Overview

Work History

Education

Skills

Accomplishments

Interest

Timeline

Nandan Hegde

Bengaluru,KA

Summary

seeking employment that will allow me to develop my skills, offer room for advancement, and allow me to effectively use the knowledge and abilities I've acquired through education and experience to benefit the organization.

Overview

years of professional experience

years of post-secondary education

Languages

Work History

Data Engineer

retisio

Bengaluru, Karnataka

09.2021 - Current

creating the new data pipe line and maintaining the existing data pipe line
Automated ETL processes across billions of rows of data, which reduced manual workload by 25% monthly
Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and data security guidelines.
Designed the data pipeline architecture for a new product that quickly scaled from 0 to 500,000 daily active users.
Ingested data from data sources using a combination of SQL, Google Analytics API using Python to create data views to be used in BI tools.
Designed and built statistical analysis models on large data sets that helped increase online sales up to 5% per product.
Validated warehouse data structure and accuracy.

Associate Data Engineer

TE Connectivity India Pvt. Ltd

Bangalore, Karnataka

03.2019 - Current

Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls
Collected, cleansed, and provided modeling and analyses of structured and unstructured data used for business initiatives which resulted in $1M annual savings.
Worked with client to understand business needs and translate those business needs into actionable reports in Cub.js.
Used Spark in Python to distribute data processing on large streaming datasets, improving ingestion and speed by 45%
Prepared written summaries to accompany results and maintain documentation

Education

Pre University - Science(PCMCs)

GMH Pre University College

06.2012 - 03.2014

Bachelor of Engineering Technology - Mechanical Engineering

Shree Devi Institute of Technology

08.2014 - 07.2018

Skills

Python

undefined

Accomplishments

Project: analytical dashboard.

Tools: Cub.js, pyspark, Airflow, big query,PostgreSQL, Apache Kafka.

Description: Businesses use dashboards as an analysis tool to analyse and assess the effectiveness of their plans using high-quality KPIs. We used data mining, legal SQL data analysis, and metrics analysis in this project. using Cube.js, BigQuery, and PostgreSQL, we also created executive KPI reports, funnel reports, and drill-down reports.

Project: ARC Recommendation Engine.

Tools: python, spark,Apache Kafka,Airflow,PostgreSQL,GCP(dataproc,big query,gcs buckets)

Description: Built an ETL in this project that ingested transactional and event data from a web app with 100,000 daily active users, saving over $85,000 annually in external vendor costs. This project will be using numerical ratings of similar items between the active user and other system users to evaluate how similar their profiles are, and then use that information to predict recommendations of unseen items to the active user.

Project: Retisio data pipelines.

Tools: python, spark,Apache Kafka,Airflow,Hive,PostgreSQL,GCP(dataproc,big query,gcs buckets,gcs composer)

Description: Built an ETL that ingested transactional and event data from a web application and maintained data pipeline uptime of 99.8% while ingesting streaming and transactional data across 6 different primary data sources using Spark, big query, gcs buckets, and Python,Apache Kafka, Airflow, and also automated ETL processes across billions of rows of data, which reduced manual workload by 25%.