Summary
Overview
Work History
Education
Skills
Websites
Certification
Languages
Personal Information
Consent
Timeline
Generic
Avik Dhar

Avik Dhar

Bengaluru

Summary

Dynamic data engineering professional with a proven track record at JP Morgan Chase, excelling in cloud data architecture and team leadership. Expert in Python and AWS, I developed robust data pipelines that significantly enhanced reporting capabilities, driving impactful analytics and decision-making for diverse teams. Passionate about optimizing performance and delivering results.

Overview

10
10
years of professional experience
1
1
Certification

Work History

AVP, Data Engineering

JP Morgan Chase
Bengaluru
09.2023 - Current
  • Worked on Data Platform for Merchant Services to ingest data from multiple sources like Kafka, MFTS etc and manage a data warehouse for various SCD types on Databricks hosted on AWS
  • Developed an Export functionality to move data from Databricks to Snowflake for Consumer teams to generate reports and use for analytics
  • Developed a custom extractor app in Java Spring Boot to read data from Kafka and store it in AWS S3
  • Developed multiple Glue, Lambda, EMR and Step Functions for improving and stabilising Data Platform
  • Provided leadership, direction, guidance, and support to team members on a daily basis.

Senior Data Engineer II

Rakuten India
Bengaluru
11.2021 - 09.2023
  • Led a team of 8 for development of multiple pipelines to handle Awareness/Interest/Purchase/Loyalty reports for Japans top ecommerce platform with more than 40% market share leveraging AWS Big data stack
  • Developed individual data warehouses for cart abandonment and page withdrawal analysis to feed Dashboarding teams and Data Science teams
  • CICD for Data Pipelines through Gitlab
  • Worked in Project management maintaining Jira boards and conducting scrum
  • Boosted ecommerce sales by 78 million JPY in first release quarter

Senior Data Engineer

Valuelabs Limited
Hyderabad
05.2021 - 11.2021
  • Analysed viewership of media content across US and helped in analytical warehouse building on Hive sourcing data from relational databases
  • Helped client in making customer centric reports to sell data to 3rd parties

Data Engineer

DBS Bank Asia Hub
Hyderabad
04.2020 - 05.2021
  • Worked in a high priority Regulatory reporting project for DBS Bank to replace existing RAMCO system and create Central Data Repositories based on functional roles
  • Designing Data Warehouses and Models for CDRs from scratch

Systems Engineer

Infosys Limited
Bhubaneswar
12.2014 - 04.2020
  • Worked as SQL developer and participated building data pipelines and writing optimised SQL for quick retrievals
  • Migration of legacy PowerBuilder code to Python

Education

B.Tech - ECE

Institute of Engineering and Management
Kolkata
01.2014

Higher Secondary -

South Point High School
Kolkata
01.2010

Secondary -

South Point High School
Kolkata
01.2008

Skills

  • Python
  • Pyspark
  • Hive
  • Hadoop
  • SQL
  • Data Warehousing
  • Data Modelling
  • ETL
  • Databricks
  • AWS
  • Snowflake
  • Data pipeline development
  • Cloud data architecture
  • Data warehousing
  • Team leadership
  • Performance optimization
  • Problem solving
  • Product Management
  • Dashboarding
  • Client Handling
  • Project Management

Certification

  • AWS Certified Solutions Architect Associate
  • AWS Certified Developer Associate

Languages

  • English
  • Hindi

Personal Information

  • Date of Birth: 08/26/92
  • Gender: Male
  • Nationality: Indian

Consent

I consent to the processing of my personal data for the purpose of recruitment for the position to which I am applying.

Timeline

AVP, Data Engineering

JP Morgan Chase
09.2023 - Current

Senior Data Engineer II

Rakuten India
11.2021 - 09.2023

Senior Data Engineer

Valuelabs Limited
05.2021 - 11.2021

Data Engineer

DBS Bank Asia Hub
04.2020 - 05.2021

Systems Engineer

Infosys Limited
12.2014 - 04.2020

B.Tech - ECE

Institute of Engineering and Management

Higher Secondary -

South Point High School

Secondary -

South Point High School

Similar Profiles

CREATE PROFILE
Avik Dhar