Summary
Overview
Work History
Education
Skills
Certification
Training
Timeline
Generic
Kedarnath Bajolgi

Kedarnath Bajolgi

Data Engineer
Bengaluru

Summary

Seasoned Data Analytics Engineer with a 8 plus -year track record in implementing advanced data engineering solutions within Azure cloud environments. Proficient in Python, Spark, R, SQL Server, and a wide array of Azure services such as Azure Data Factory, Azure Databricks, Azure Data Lake, Azure Event Hub, Power BI, Azure SQL Database, Azure Synapse Analytics, Function App and Azure Cosmos DB. Managed large-scale data processing projects, achieving a notable 50% increase in reporting efficiency through optimized data pipeline architecture. Developed a platform for automated data onboarding serving over 50 clients and successfully secured data science projects from FMCG and waste management companies. Experienced in AWS S3 bucket provisioning and integration with Salesforce CDP.

Overview

8
8
years of professional experience
2
2
years of post-secondary education
4
4
Certifications
4
4
Languages

Work History

Data Engineer

Shell India Market Private Limited
03.2022 - Current
  • A@Shell Migration :- I actively contributed to architecture planning, conducting gap analysis activities that effectively bridged all gaps in the new A@S Shell environment. I introduced functional account concepts for error notification in pipelines, significantly reducing rework time and saving on resource utilization cost.
  • GFN Master Data : I effectively integrated new changes into the complex GFN sales and fee item pipeline, earning high praise from both subject matter experts (SMEs) and the team lead.
  • Salesforce CDP Integration :- Designed and implemented a robust solution architecture to integrate the Salesforce CDP system with the Azure environment. Technologies employed included Azure Data Factory, AWS S3 Bucket, Azure Databricks, Azure Data Lake, and Azure Synapse. This solution received appreciation from the Salesforce team for its effectiveness and efficiency.
  • Sales Bonus Report :- I developed a robust data model leveraging Azure Databricks, Azure Data Lake, and Azure Data Factory. Introducing Delta Lake warehouse led to a significant improvement in performance. Additionally, I implemented a Paginated Report using Report Builder and created a Power BI Dashboard. This comprehensive solution received commendation from the sales manager.
  • Developed extensive ETL pipeline using Azure Data Factory (for Thailand Price Reconciliation) leading to a workflow efficiency.
  • CFGW System :- I introduced email alert notifications for missing card velocity, eliminating manual effort and saving 10 hours per week in operational costs.
  • South Africa Data Onboarding :- Implemented an Azure Data Factory pipeline to seamlessly ingest data from the GSAP system into the Shell Fleet Hub platform, earning positive feedback from stakeholders.
  • India Data Onboarding : - Built an end-to-end ingestion pipeline to load data from the Yalamanchi source system into Shell Fleet Hub. This involved performing comprehensive data mapping and implementing curation logic specifically tailored for India account data.
  • Salesforce Service Cloud :- Effectively integrated the Salesforce system with the Shell Fleet Hub system and implemented a complete end-to-end data ingestion pipeline. Incorporating essential business logic to meet reporting requirements. As a result, this solution enabled the marketing team to discover new business opportunities based on acquired leads.
  • Insite : Built an end-to-end ingestion pipeline to load data from the multiple source system such as TDH and MAPT source system into Shell Mobility Data Hub. Implemented SQL stored procedure to improve the performance and long running queries.
  • Emerald : Designed and implemented an end data flow architecture and workflows. which helped to migrate the RTSP system to MTSP system.

Lead Analyst

Ernst and Young
01.2020 - 01.2022
  • I engineered a robust data ingestion framework utilizing Azure Databricks, Data Factory, Python, and Data Lake Storage. This framework seamlessly onboarded over 50 clients with minimal adjustments, resulting in reduced resource utilization and cost savings for the organization.
  • Leveraged advanced SQL queries to meticulously analyze customer data, resulting in a substantial increase in actionable insights.
  • Integrated Power BI dashboards to visually represent analytics, greatly enhancing reporting capabilities for stakeholders.
  • I automated routine data processing tasks, resulting in a team-wide savings of approximately 10 hours per week.

Software Engineer

Acuvate software Private Limited
03.2017 - 12.2019
  • Development of a centralized revenue management system for FMCG clients, integrating Azure Data Factory, Azure SQL, Azure Blob Storage, Azure ML, and R Language. This initiative was praised by the Data Analytics Practice Head for its transformative impact on operational efficiency and strategic decision-making.
  • Implemented data transformation workflows utilizing Azure Data Factory, deployed machine learning models, and generated comprehensive reports in Power BI, resulting in significant cost savings by optimizing resource utilization.
  • My presentation on a robust data science and analytics solution resulted in securing data science projects from both FMCG company and a waste management firm.
  • I collaborated closely with cross-functional teams to harness the power of data analytics, identifying and capitalizing on key business opportunities.

Education

Master of Technology - Computer Science And Engineering

New Horizon College of Engineering
Bengaluru
05.2013 - 06.2015

Skills

MS SQL

Python

PySpark

Spark SQL

Azure Databricks

Azure Data Factory

Azure Data Lake

Azure SQL DB

Azure Synapse Analytics

Azure Event Hub

undefined

Certification

Azure Data Engineer Associate (DP-203)

Training

  • AWS Data warehousing
  • AWS Solution Architecting
  • AWS Container Services
  • GitHub Copilot

Timeline

Data Engineer

Shell India Market Private Limited
03.2022 - Current

Lead Analyst

Ernst and Young
01.2020 - 01.2022

Software Engineer

Acuvate software Private Limited
03.2017 - 12.2019

Master of Technology - Computer Science And Engineering

New Horizon College of Engineering
05.2013 - 06.2015

Similar Profiles

CREATE PROFILE
Kedarnath BajolgiData Engineer