-- data_engineer · pune, india

Python. SQL.
Power BI.

I build the layer between raw sources and trusted analytics: SQL models, Python ETL, and Power BI reports that operations teams actually use. 2+ years on manufacturing and energy pipelines - batch, streaming, and the dashboards on top.

SQL Server PostgreSQL Kafka SSIS

-- about

Engineering the data layer, not just reading it

I'm a Data Engineer based in Pune. Most of my work sits between messy source systems and the clean models analysts depend on. I design the pipelines, the warehouse, and the reports - primarily in SQL, Python, and Power BI.

At Centre for Industry 4.0 (C4i4) Lab, I've built star-schema warehouses, real-time IoT streams, and analytics for energy and shop-floor operations. Comfortable with databases like SQL Server, PostgreSQL, ETL tools like SSIS, Kafka, pySpark, and GCP when the pipeline needs them.

When I'm not in a query window, I trek, play chess, read, and swim.

Current role

Data Engineer

C4i4 Lab · Jul 2024 – Present

Education

MCA

Savitribai Phule Pune University

Experience

2+ years

+ internships in data & databases

Languages

English · Hindi

Marathi (native) · Japanese (basic)

-- skills

What I work with

01 · sql

Databases & SQL

SQL ServerPostgreSQLMySQLDuckDBMongoDB

02 · python

Pipelines & Python

PythonPandasSSISETL / ELTFlaskn8n

03 · power bi

BI & visualization

Power BIDAXPower Query / MDirectQueryRLSDeneb / Vega

04 · stream

Real-time streaming

Apache KafkaMQTTIoT pipelinesPySpark

05 · model

Data modeling

Star schemaSnowflake schemaData warehousingMedallian Data Architecture

06 · cloud

Cloud & platform

Google Cloud PlatformDatabricksDockerGitPower BI Service

-- projects

Featured work

Energy Analytics Platform

End-to-end analytics combining batch and streaming. KPI monitoring across stations, anomaly detection, consumption vs production, and short-term forecasting for renewable operations.

PythonSQL ServerKafkaPower BI

IoT Streaming Pipeline

MQTT → Kafka → SQL Server → Power BI. Low-latency industrial ingestion for live monitoring and dashboarding, built to hold high-volume sensor telemetry.

MQTTKafkaPostgreSQLPython

Foundry Andon Boards

Shop-floor visibility: process KPIs, real-time dashboards, and ML-assisted image quality checks so production issues surface as they happen.

Power BIPythonSQL ServerReal-time

Digital Twin & CBM

Digital twin for industrial compressors with synthetic data, live dashboards, and KPI drilldowns for equipment health and anomaly detection.

PythonPower BIPostgreSQLAnomaly detectionML

Warranty Claims Analytics & AI

Pipeline, historical trends, ML forecasting, and an LLM chatbot for automated insights. Deployed end-to-end in production.

PythonPostgreSQLforecastingML

Real-Time River Monitoring & Flood Risk Platform

Near-real-time pipeline streaming river observations from France's Hub'Eau API through Kafka into TimescaleDB. Idempotent upserts, offset commits after successful writes, and an audit log of every delivery. Ongoing: Spark, cloud lake, and API/dashboard layers.

PythonKafkaTimescaleDBSQLDocker

-- experience

Career

Jul 2024
Present

Data Engineer

Centre for Industry 4.0 (C4i4) Lab

Designed star-schema warehouses and dimensional models for energy and operations analytics
Built ETL/ELT in SQL, Python, and SSIS across sensors, APIs, ERP, SharePoint, and files
Architected real-time IoT: MQTT → Kafka → SQL Server → Power BI for monitoring and anomaly detection
Published Power BI reports with DAX, Power Query, DirectQuery, RLS, and workspace governance
Shipped shop-floor Andon boards and energy optimization views used by operations teams
Ran Power BI and data engineering workshops for client stakeholders, including Tata Motors

Jan 2024
Jul 2024

Data Science Intern

Indi4 Consult Pvt Ltd

Built Power BI dashboards with Deneb/Vega custom visuals for BRSR sustainability reporting
Analyzed multi-source datasets for stakeholder reporting
Supported modeling, transformation, and reporting in Power BI and SQL

Aug 2023
Dec 2023

Database Intern

Pune Municipal Corporation · IT Dept