Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Pranali Ramteke

Summary

Results-driven Data Engineer with 3 years of experience in data engineering, ETL pipeline development, and business intelligence solutions. Expertise in Azure Data Factory (ADF), Azure Data Lake (ADLS), Databricks, SQL, and Power BI for constructing scalable data platforms and analytics solutions. Proven success in optimizing data workflows, implementing Medallion Architecture, and delivering impactful dashboards that enhance business decision-making. Committed to leveraging technical skills and innovative approaches to drive data-driven insights and support organizational goals.

Overview

4
4
years of professional experience
1
1
Certificate

Work History

Data Engineer

Kagool
10.2024 - Current
  • Ingested SAP data into Azure Data Lake Storage (ADLS) using Velocity , ensuring secure and scalable storage for enterprise data.
  • Designed and developed Azure Data Factory (ADF) pipelines to move data from ADLS to Azure SQL Database , enabling seamless data flow.
  • Implemented Medallion Architecture (Bronze, Silver, Gold layers) in Databricks using notebooks for transformations , improving data quality and standardization.
  • Created and optimized stored procedures to build external tables in Azure SQL Database and developed views for analytics consumption.
  • Delivered Power BI dashboards using SQL views, providing actionable insights to business teams and reducing manual reporting by 40% .
  • Automated end-to-end workflows, reducing data processing time by 30% and improving reporting efficiency.

Reporting Engineer

Kagool
08.2022 - Current
  • Developed 20+ interactive Power BI dashboards for sales, finance, and operations teams using DAX and advanced visualization techniques.
  • Implemented row-level security and optimized data models, reducing dashboard load time by 35% .
  • Connected Power BI to Azure SQL DB and ADLS , ensuring real-time and historical data availability.
  • Collaborated with data engineers to streamline data ingestion and modeling processes, improving overall reporting accuracy .
  • Automated scheduled data refresh and publishing, reducing manual effort by 50% .

API, Google Cloud and Analytics Intern, Algoix Lab

Algoix Lab
06.2021 - 09.2021
  • Conducted consumer data analysis on products to assist with promotional campaigns.
  • Utilized various professional statistical techniques and maintained large databases to collect and analyze data from partners and customers.
  • Analyzed data trends using statistical software for project insights.
  • Collaborated with team members to develop data visualization reports.
  • Conducted research on market trends to support strategic decisions.

Education

Master of Science - Statistics

Savitribai Phule Pune University
Pune, India
01.2021

Bachelor of Science - Statistics

Fergusson College
Pune, India
01.2018

Skills

  • Azure Data Factory
  • Databricks
  • SQL and databases
  • PowerBI
  • ETL development
  • Data modeling
  • Data pipeline design
  • Data warehousing
  • SQL programming
  • Analytical skills
  • DAX
  • Python
  • Spark framework
  • Data migration
  • Microsoft Azure

Certification

  • Azure AZ-900 Azure Fundamentals

Languages

English
Bilingual or Proficient (C2)
Marathi
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)

Timeline

Data Engineer

Kagool
10.2024 - Current

Reporting Engineer

Kagool
08.2022 - Current

API, Google Cloud and Analytics Intern, Algoix Lab

Algoix Lab
06.2021 - 09.2021

Master of Science - Statistics

Savitribai Phule Pune University

Bachelor of Science - Statistics

Fergusson College

Similar Profiles

CREATE PROFILE
Pranali Ramteke