Saurabh Kumar

Experience

• 

  Saddacampus

  Dec 2017 - Jan 2018

  Frontend Developer Intern

  Developed the front end of the website using HTML, CSS, and JavaScript.

• 

  Institute Of Chemical Technology

  May 2019 - Jul 2019

  Summer Research Intern

  Synthesis of Tio2 nanoparticles by sol-gel method and used it for Isomerization of alpha-pinene. This research was published in "Chemical Engineering and Processing - Process Intensification" Journal with the Topic name "Ultrasound-assisted improved synthesis of TiO2 catalyst and subsequent evaluation for isomerization of alpha-pinene"Published Paper Link: https://www.sciencedirect.com/science/article/abs/pii/S0255270121002865

• 

  Oil and Natural Gas Corporation Ltd

  Dec 2019 - Dec 2019

  Drilling Engineer Intern

  Learnt theoretical and practical aspects of directional drilling, cementing, fishing and drilling fluids.

• 

  AskEOR

  Aug 2020 - Sept 2020

  Reservoir Engineer Intern

  Project focuses on development of an analytical model for water flooding in four sandstone reservoirs having oil of different viscosities. And then optimize EOR techniques were analysed for each case.

• 

  INeuron.ai

  Jul 2021 - Sept 2021

  Data Scientist Intern

  Build a classification methodology to predict the forest cover type- Raw data collected from DataStax Astra Cluster- First validated the raw data containing more than 500 features, then after data preprocessing data was clustered- Multiple models were trained on each cluster and then the best model for each cluster was finalized- Modular programming was done for each step including data validation, preprocessing, clustering, model training, and logging- Deployed the application on Heroku Show less

• 

  Cubastion Consulting

  Jul 2021 - Jun 2022

  Associate Consultant - Data Engineer

  Part of a small team of developers and Data Analysts to create the CRM application and ETL pipelines for client DICV (Daimler India Commercial Vehicles).-> Communicated with clients, grasped their business needs, and proposed effective solutions, documenting these requirements for clear understanding-> Developed and improved functionalities within the business flows using Siebel Tools, and server scripts, and crafted complex SQL queries for thorough validation-> Responded promptly to urgent client requests, giving top priority to addressing their queries and resolving issues to ensure client satisfaction-> Conducted training sessions for hundreds of client dealers on the Siebel CRM platform, guiding them in understanding the newly developed functionalities and optimizing their use Show less

• 

  EssilorLuxottica

  Jul 2022 - Feb 2024

  Data Engineer

  Part of a small team of data engineers and data scientists to develop a Customer-360 platform for GrandVision a part of EssilorLuxottica, a leading eyewear industry player-> Engineered an efficient and scalable ETL batch data pipeline on Google Cloud Platform (GCP) utilizing GCS, Dataproc (PySpark), BigQuery, Cloud Functions, and Cloud Composer-> Built several other ETL and ingestion pipelines processing data from the marketing cloud and messagebird service-> Streamlined ETL workflows through the creation of generalized Python scripts automating complex SQL query generation, enhancing the efficiency of data pipeline development-> Implemented Slack alerts within the data pipeline, enhancing real-time monitoring capabilities and reducing response time to pipeline issues to a few minutes-> Developed a comprehensive monitoring dashboard to track the failures, and volume of data being transferred between systems for all the active ETL pipelines Show less

• 

  Thoughtworks

  Feb 2024 - now

  Data Engineer

  Part of a team building a digital ecosystem platform for one of the leading banks of the UAE government, this platform will enable fintech and MSMEs to offer, discover and consume each other’s services.- Designed and deployed a robust data platform on Azure Cloud, integrating various services such as Databricks, Azure Storage, Event Hub, Airbyte, Firebase Analytics and Key Vault.- Developed an ingestion pipeline using Airbyte to load Firebase analytics events data reports into Databricks lakehouse, enabling PowerBI dashboard creation for analyzing user interactions.- Designed and implemented an ETL pipeline with Pyspark streaming to efficiently load and validate events data from Azure EventHub to the Databricks lakehouse for further analysis.- Leveraged Terraform (IaC) to efficiently manage and scale the platform infrastructure on Azure cloud.- Implemented CICD pipelines on Gitlab for seamless deployment and updates of Databricks and Airbyte jobs. Show less