logo

Powered by
Codebasics Bootcamp

Hello, I am

Sagar Soni.

1

SQL Project

About Me

I’m a Data Engineering professional with 4+ years of experience in data analytics, focused on building scalable, reliable, and efficient data pipelines that transform raw data into meaningful business insights.

My technical skills include SQL, Python, PySpark, Apache Spark, Azure Databricks, Microsoft Fabric, and ETL/ELT pipelines, with a focus on data transformation, data quality, data warehousing, and Medallion Architecture (Bronze, Silver, and Gold).

I build real-world data pipelines, including:

- Designing pipelines to ingest, clean, transform, and process data.
- Implementing Bronze, Silver, and Gold layers using modern lakehouse architectures.
- Working with Delta Lake, incremental data processing, and data optimization.
- Building data workflows using Azure Data Factory, Azure Databricks, and Microsoft Fabric.

My goal is to build reliable data solutions that improve efficiency, enable better decision-making.

Building Reliable Data Pipelines That Drive Business Growth.

Key Skills

Python

SQL

PySpark

Databrick

Microsoft Fabric

dbt

Apache Airflow

Apache kafka

Apache Spark

Azure

Data Warehouse

Delta Lake

ADLS Gen2

ELT/ETL

Data Modeling

Git

Azure Data factory

My Experience

    𝗔𝗧𝗟𝗜𝗤 𝗧𝗘𝗖𝗛𝗡𝗢𝗟𝗢𝗚𝗜𝗘𝗦

    𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 𝗜𝗻𝘁𝗲𝗿𝗻 | Sep 2026 – Present

    • Engineered 5+ batch ETL pipelines using Azure Data Factory, ADLS Gen2, Azure Databricks, and PySpark.

    • Implemented Bronze, Silver, and Gold data layers using Medallion Architecture and Delta Lake.

    • Developed 20+ dbt models, including fact and dimension models, with data quality tests.

    • Integrated curated datasets with Microsoft Fabric and Power BI for analytics and reporting.

    • Automated dbt validation workflows using GitHub Actions.


    𝗖𝗔𝗦𝗘𝗣𝗢𝗜𝗡𝗧 𝗣𝗩𝗧. 𝗟𝗧𝗗.

    𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 & 𝗠𝗜𝗦 | Mar 2026 – Jul 2026

    • Processed and transformed 500K+ business records using SQL, Python, Advanced Excel, and Power Query.

    • Developed 5+ interactive Power BI dashboards for KPI monitoring and business performance analysis.

    • Automated 3+ recurring reporting workflows using Python scripts, Excel formulas, and AI-assisted tools.

    • Delivered accurate reports and actionable business insights to support data-driven decision-making.


    𝗘𝗠𝗜𝗡𝗘𝗡𝗧 𝗣𝗔𝗣𝗘𝗥 𝗜𝗡𝗗𝗨𝗦𝗧𝗥𝗜𝗘𝗦 𝗟𝗟𝗣

    𝗠𝗜𝗦 & 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 | Jan 2024 – Mar 2026

    • Processed and analysed 2M+ business records for reporting and operational performance tracking.

    • Extracted, cleaned, validated, and transformed datasets using SQL, Python, Advanced Excel, and Power Query.

    • Maintained 65+ reports and dashboards supporting 5+ business teams.

    • Streamlined operational and reporting workflows using Google Apps Script and Google Workspace tools.

    • Developed interactive Looker Studio dashboards and automated recurring reports using advanced spreadsheet functions and AI tools such as ChatGPT and Gemini.


    𝗛𝗔𝗦𝗛𝗧𝗔𝗚 𝗜𝗡𝗙𝗢𝗦𝗬𝗦𝗧𝗘𝗠

    𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 | Jan 2022 – Dec 2023

    • Queried and analysed 200K+ business records using SQL, Python, and Advanced Excel.

    • Developed 10+ Power BI dashboards and recurring reports for KPI monitoring and business analysis.

    • Streamlined recurring reporting using advanced Excel functions, including LOOKUPs, IF, SUMIF, COUNTIF, and FILTER.

    • Supported 3+ business teams by maintaining structured datasets and delivering accurate, timely reports.

    Awards & Certificate

    img

    Excel: Mother of Business Intelligence

    img

    Get Job Ready: Power BI Data Analytics for All Levels 4.0

    img

    SQL Beginner to Advanced For Data Professionals

    img

    Python: Beginner to Advanced For Data Professionals

    img

    Project: Build E-commerce Data Pipeline using Spark & Databricks

    img

    Kafka and Flink Fundamentals

    img

    Certified Data Engineer

    Let's Connect

    Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.