Summary
Overview
Work History
Education
Skills
Certification
Extracurricular Activities
Projects
POSITION OF RESPONSIBILITY
Accomplishments
Timeline
Generic

Sourav Lohia

New Delhi

Summary

Proactive and versatile professional with a dedication to quickly adapting to new challenges. Strong problem-solving abilities and a proven track record of fostering strong relationships with clients and team members. Focused on supporting team success and achieving positive results.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Tech Lead - Data Engineer

BluePi Consulting
Gurugram
10.2024 - Current

Data Engineer (Assistant Manager)

Mankind Pharma
New Delhi
01.2024 - 09.2024
  • Developed analytics products enhancing business decision-making processes
  • Designed WhatsApp-based nudges for 20,000 field force members
  • Optimize existing queries built by different vendors to improve performance.
  • Achieved a 60% reduction in processing time by transitioning SQL data warehouse to Azure Databricks.
  • Implemented OCR automation for agreements and PDFs
  • Directed workflow for over 10 staff members.
  • Azure Data factory, Azure data bricks, Pyspark, SQL, ETL,ADLS.

Data Engineering Analyst

Accenture Technology Centres India-Cloud first/Data & Al
Gurugram
04.2021 - 01.2024
  • Worked on multiple modules of Unilever Markets such as finance, Media, DSR, etc
  • Created end to end data pipelines from ingestion of huge data till frontend report generation on power BI, tools used Azure Cloud, ADLS, ADF, ADB, Power BI
  • Ingested data and performed various data transformation including cleaning, data quality, Time Calculation from various market sources using a combination of SQL, Scala on a big data platform such as ADB on Azure
  • Wrote logic for Various KPIs to increase efficiency of the market and eventually take financial decision to save millions
  • SQL DW to ADB migration
  • Helped in reducing GCF
  • ADLS GEN1 to GEN2 migration
  • Project: Unilever, UK

Education

B.Tech - Engineering Physics Major Electronics

Delhi Technological University
07-2020

XII -

Kendriya Vidyalaya Arjangarh
Delhi
07-2016

X -

Kendriya Vidyalaya Arrjangarh
Delhi
05-2014

Skills

  • AWS, Azure Cloud, Azure Data factory, Azure Databricks
  • ADLS, SQL, Spark,PySpark, Scala, Machine Learning, Statistics,
  • Big Query, Power BI, Snowflake, ETL pipelines,
  • Data quality, Python, Data Engineering and problem Solving

Certification

Azure AZ 900, DP 900, Databricks Data Engineer Associate certification

Extracurricular Activities

Social innovation challenge – Hyper Island Participated in social innovation challenge hosted by hyper island in partnership with Accenture and worked on UN SDGs, prepared my report on how next pandemic can be stopped? 

Consulting Intensive – Case study challenge-Hosted by Accenture S&C worked in team of five member across multiple domains to solve case study on improving customer experience of The European bank.

Projects

Stock price prediction using LSTM and ARIMA, An Undergraduate major project done under the guidance of Dr. Richa Sharma (Applied physics department DTU) built two models ANN LSTM and ARIMA to compare dynamic movement of stock price of GOOGLE FB and APPLE, Scripted in R, LSTM model worked with overall accuracy of 94.5 as compared to ARIMA.

POSITION OF RESPONSIBILITY

  • DTU Student Association Aug 2017 - Apr 2018
  • Worked with a team of five member and analyzed the problem with the sports infrastructure.
  • Corporate executive DTU-AUV Aug 2017 – Dec 2017
  • Autonomous underwater vehicle tech team of DTU, getting sponsorship and funding's for our team also setup a new laboratory for our team

Accomplishments

  • Employee of the month for the month of April 2024 at Mankind Pharma.

Timeline

Tech Lead - Data Engineer

BluePi Consulting
10.2024 - Current

Data Engineer (Assistant Manager)

Mankind Pharma
01.2024 - 09.2024

Data Engineering Analyst

Accenture Technology Centres India-Cloud first/Data & Al
04.2021 - 01.2024

B.Tech - Engineering Physics Major Electronics

Delhi Technological University

XII -

Kendriya Vidyalaya Arjangarh

X -

Kendriya Vidyalaya Arrjangarh
Sourav Lohia