Data Engineer / Data Analyst

Mahadev Palav

Data Engineer | Data Analyst | Power BI Developer

Building scalable data pipelines, dashboards, and AI-driven insights using Python, SQL, and Power BI.

Profile

What I Do

Core Services

Build ETL Pipelines

Design scalable ETL workflows to transform raw data into analytics-ready datasets.

Analyze Data

Perform statistical and business analysis to uncover trends and support decision-making.

Create Dashboards

Build interactive Power BI dashboards with clear KPIs and business storytelling.

Apply ML Models

Apply machine learning models to generate predictions and AI-driven insights.

About

About Me

My name is Mahadev Palav. I am from Sindhudurg, Maharashtra, and completed my schooling there up to the 12th grade. I have completed my B.Sc. in Computer Science (Honours) and MCA in Mumbai. I have skills in Python, SQL, Power BI, and Databricks, with knowledge of data processing, pipelines, and visualization. I also have an understanding of Machine Learning and AI. I am seeking Data Analyst and Data Engineer roles to apply my skills and grow in the data domain.

Profile:MCA Graduate
Domain:Data Engineering & Analytics
Education:B.Sc CS (Hons), MCA
Tools/Libraries:Python, SQL, Power BI, Databricks
Location:Bhandup, Mumbai

Skills

Technical Stack

SQL

Python (Pandas, NumPy)

Power BI

Data Visualization

PySpark

Databricks

ETL Pipelines

Machine Learning

Education

Academic Background

2023-2025

Master of Computer Application

Hiray Institute of Computer Application, Mumbai

CGPA: 8.60

2020-2023

B.Sc Computer Science (Hons)

S K Somaiya College, Mumbai

CGPA: 8.38

2018-2020

HSC

D.T. Mahavidyalaya, Sindhudurg, Kudal, Maharashtra

Percentage: 69.69%

2017-2018

SSC

Shivaji English School, Pandur Titha, Kudal, Maharashtra

Percentage: 90.20%

Projects

Featured Projects

E-commerce Data Pipeline

Databricks, PySpark, ML

  • Designed Medallion Architecture (Bronze, Silver).
  • Built FP-Growth recommendation and Random Forest churn model.
  • Integrated AI chatbot and Streamlit interface for data querying.

Blinkit Dashboard

Power BI, DAX

  • Created KPI dashboards for sales and category performance.
  • Performed data cleaning and transformation for accurate reporting.
  • Generated insights to support business decisions.

Hospital Management System

Flask, SQL

  • Developed secure CRUD modules with authentication.
  • Implemented backend workflows and role-based access logic.
  • Improved operational efficiency with centralized records.

LLM-Based Data Analytics Chatbot

Python, Streamlit, Pandas, SQLite, LangChain, Google Gemini API

  • Built an AI-powered chatbot for analytics through natural language queries.
  • Implemented automatic SQL generation and safe SQL execution.
  • Enabled CSV upload and interactive data visualization in Streamlit.
  • Used Google Gemini with LangChain for intelligent query handling.

Experience

Work Experience

Python Developer Intern

ExcelR

  • Worked on Python automation and ETL tasks.
  • Supported ML model experimentation and evaluation.
  • Collaborated on reporting and data quality improvements.

Software Developer

Aurify Systems

  • Built backend modules and integrated APIs.
  • Optimized database queries and improved reliability.
  • Contributed to deployment and production support.

Contact

Get In Touch

Mahadev Palav

Bhandup, Mumbai

mahadevpalav3112@gmail.com

+91 9325532435

LinkedIn Profile

github.com/mahadevpalav