Summary
Overview
Work History
Education
Skills
Accomplishments
Projects
Timeline
Generic

DEEPANSHU SINGH

Summary

Data Engineer with 2 years of experience at Bajaj Finserv Health, specializing in constructing ETL pipelines using Azure Data Factory (ADF), Azure Synapse, Azure Kubernetes Service (AKS), and Airflow. Successfully reduced storage costs by 50%, improved collection efficiency by 20%, and decreased agent intervention by 40%. Proficient in developing data reports in Power BI and conducting data analysis, including building models and cohorts that increased sales by 1%.

Overview

3
3
years of professional experience

Work History

Data Engineer

Bajaj Finserv Health
Pune
07.2022 - Current
  • Designed an Azure Kubernetes Service (AKS) Cron Job, automating the timely mailing of data metrics to business users 24*7 hours
  • Implemented an ETL process for archiving and retaining raw data in the data lake, significantly reducing storage costs by 50%
  • Performed aggregation and analysis of call center data to enhance the efficiency of agents and developed lead cohorts for agents, resulting in a 1% increase in sales
  • Created metrics to identify and resolve gaps in the payments process, ensuring error-free transactions and EMIs and established key metrics to enhance and oversee agent efficiency in the collection of bounce and EMI payments hence increasing the collection from 35% to 55%.
  • Implemented an efficient ETL process for seamless integration of Payment Gateways data into the data lake, achieving in reducing the workload of 2-3 hours of agents and improving data accuracy.
  • Performance metrics to streamline and elevate doctor and lab appointment confirmation processes, achieving heightened efficiency and minimizing agent workload hence bringing down the agent intervention down by 40%.
  • Designed a optimized process to perform OCR on handwritten or printed docs and then extract the data using LLM and Lang chain to fetch key insights for the customer. It could process ~100 docs per minutes.
  • Developed an automated cognitive system that leverages OCR and NER for intent recognition, enabling the automatic closure of 35%-40% of customer service cases.

Intern

Bajaj Finserv Health
01.2022 - 06.2022
  • Monitoring and improvisation of the ETL process to reduce the time of merge process by 50%
  • Optimization of the delta in data lake to reduce the query time in synapse by more than 90%
  • Comprehensive metrics for calculating product-specific revenue hence saving the 2.5 hours of daily manual work

Education

B.Tech - Electronics and Communication Engineering

SRMIST
Chennai
05.2022

12th - PCM with CS

Army Public School
05.2018

10th -

Army Public School
04.2016

Skills

  • Python
  • SQL
  • Spark
  • MySQL
  • TSQL
  • DAX
  • TRINO
  • SOQL
  • Azure Kubernetes (AKS)
  • Microsoft Power BI
  • Azure Databricks
  • ADF
  • Airflow
  • Excel
  • Synapse
  • DBeaver
  • SFDC

Accomplishments

  • Improved the collection of the bounce by more than 50%.
  • Achieved a 40% reduction in call agent's tasks.
  • 1st in Off-Grid Power Plant Hackathon.
  • Awarded a college scholarship, resulting in a 30% reduction in tuition fees.

Projects

Automated Waste Segregation, Hardware and Software, To segregate the waste based on their physical properties (metal, organic and inorganic). Voice Assistant, Software, It helps to navigate in the windows using voice commands.

Timeline

Data Engineer

Bajaj Finserv Health
07.2022 - Current

Intern

Bajaj Finserv Health
01.2022 - 06.2022

B.Tech - Electronics and Communication Engineering

SRMIST

12th - PCM with CS

Army Public School

10th -

Army Public School
DEEPANSHU SINGH