Prajwal Ambadkar

Prajwal Ambadkar

About

Detail

Azure Data Engineer @ ProArch | Microsoft Fabric | Lakehouse & OneLake | Databricks | Azure Synapse Analytics | Azure Data Factory | PySpark | SQL | Power BI
Maharashtra, India

Timeline


work
Job
school
Education
folder
Project

Résumé


Jobs verified_user 0% verified
  • ProArch
    Data Engineer
    ProArch
    Jun 2026 - Current (5 months)
    • Lead the migration of core ETL pipelines and Power BI reports from Azure Synapse Analytics to Microsoft Fabric, completing the end-to-end migration using Copy Data Activity, Dataflows Gen2, and Fabric Lakehouse.
    • Implemented a Medallion Architecture (Bronze, Silver, Gold) using Fabric Lakehouse, Delta Tables, and OneLake, enabling structured data transformation and centralized storage while reducing unnecessary data duplication across the analytics platform.
    • Migrated Power BI semantic models from Import mode to Direct Lake mode, enabling reports to query data directly from the Fabric Lakehouse and improving data freshness, reducing data duplication, and enhancing report performance.
    • Performed data validation, reconcili
  • ProArch
    Trainee Data Engineer
    ProArch
    Nov 2025 - May 2026 (7 months)
    • Built and monitored ETL pipelines using Azure Data Factory and Azure Synapse Analytics, supporting data integration and transformation for internal reporting.
    • Designed incremental data loading strategies for fact tables, reducing unnecessary full-table reprocessing and improving reliability for late-arriving data.
    • Maintained and enhanced Power BI dashboards and internal reporting systems to provide accurate business insights.
    • Supported secure CI/CD deployments using Azure Key Vault and Azure DevOps across the team's release process.
    • Worked with PySpark and SQL to support data transformation and analytics workflows on Azure Data Lake.
  • TeamLease Regtech Pvt Ltd
    SQL Intern
    TeamLease Regtech Pvt Ltd
    Apr 2025 - Aug 2025 (5 months)
    • Contributed to the development of RegAuto-Labour, a SaaS-based platform that automates labor law compliance for enterprises across India.
    • Built and enhanced backend modules using .NET Core (C#) to handle compliance workflows, reporting, and document management.
    • Designed and implemented RESTful APIs for seamless integration with enterprise applications and internal services.
    • Wrote and optimized SQL Server queries, stored procedures, and functions to support compliance tracking, reporting, and data analytics.
    • Implemented role-based authentication and authorization to ensure secure access to sensitive compliance data.
    • Worked with SSRS (SQL Server Reporting Services) to generate compliance reports for client
Education verified_user 0% verified
  • Centre for Development of Advanced Computing CDAC
    PG Diploma in Big Data Analytics (PG-DBDA
    Centre for Development of Advanced Computing CDAC
    Sep 2023 - Mar 2024 (7 months)
  • D Y Patil College of Engineering  DYPCOE   Akurdi Pune
    Bachelor of Engineering - BE, E&TC
    D Y Patil College of Engineering DYPCOE Akurdi Pune
    Jan 2018 - Jan 2022 (4 years 1 month)
Projects (professional or personal) verified_user 0% verified
  • A
    ANN-Based Customer Churn Prediction
    Developed a deep learning model using Artificial Neural Networks (ANN) with Keras & TensorFlow to predict customer churn. The project involved data preprocessing, feature engineering, model optimization, and deployment using Streamlit. Achieved high accuracy and extracted valuable insights to identify churn patterns.
  • S
    SQLite Chat Assistant
    Built an interactive chat assistant that processes natural language queries and converts them into SQL queries to fetch relevant data from an SQLite database. The assistant ensures error handling, meaningful responses, and a seamless user experience.

    Key Features :
    • Natural Language Processing: Translates user questions into SQL queries.
    • Database Integration: Supports an SQLite database with Employees and Departments tables.
    • Error Handling: Provides meaningful messages for invalid queries or missing results.
    • User-Friendly Interface: Built using Streamlit for an intuitive experience.
  • R
    RegAuto-Labour – Labor Compliance Automation Software
    Apr 2025 - Aug 2025 (5 months)
    • Contributed to the development of RegAuto-Labour, a SaaS-based platform that automates labor law compliance for enterprises across India.
    • Built and enhanced backend modules using .NET Core (C#) to handle compliance workflows, reporting, and document management.
    • Designed and implemented RESTful APIs for seamless integration with enterprise applications and internal services.
    • Wrote and optimized SQL Server queries, stored procedures, and functions to support compliance tracking, reporting, and data analytics.
    • Implemented role-based authentication and authorization to ensure secure access to sensitive compliance data.
    • Worked with SSRS (SQL Server Reporting Services) to generate compliance reports for client
This is a community-created genome.