PD

Prathmesh Dubey

B.E. AI & Data Science student · Data Engineer / Backend Engineer

Thane, Maharashtra, India

@prathmesh23394044

0 followers

About

B.E. Artificial Intelligence & Data Science student with experience in data engineering, backend development, and analytics. Has built and optimized ETL/data pipelines, dashboards, and API-driven workflows across cloud and database tools.

Experience

  • Software Engineer
    Siemens · Airoli
    Dec 2025 – Present

    Built and debugged an end-to-end backend data pipeline spanning BMS, MongoDB, AWS Lambda, GraphQL, and backend services, processing live and historical sensor data for analytics. Root-caused a production occupancy data issue by tracing the pipeline from DynamoDB through AppSync/GraphQL to the downstream BMS; identified excessive per-AP authentication requests hitting the Desigo rate limit and causing silent failures. Implemented token caching, added GraphQL response validation, used Postman for API and end-to-end testing, resolved Lambda payload-limit and UTC/IST date-boundary issues, re-architected the FDD reporting pipeline for 17+ sites, and monitored AWS-based ingestion pipelines with CloudWatch.

  • Software Engineering Intern – Data & Analytics
    Siemens · Airoli
    May 2024 – Nov 2024

    Developed a Python/FastAPI data-cleaning tool for non-technical users and built a Streamlit RTU analysis workflow to monitor equipment efficiency. Designed Power BI dashboards and automated Excel reporting for electricity consumption and carbon-reduction initiatives.

  • Data Engineer Intern
    Action Against Hunger · Andheri
    May 2023 – Jul 2023

    Automated KPI reporting using modular SQL-based ETL workflows, reducing manual reporting effort by approximately 60–80%. Cleaned and transformed CommCare datasets to improve reliability for downstream analytics workflows, and developed Power BI dashboards with exploratory analysis in Excel to support operational reporting and decision-making.

Education

  • B.E.
    Vivekanand Education Society Institute of Technology
    Artificial Intelligence and Data Science · 2021 – 2025

Skills

1 to 2 years 1 to 2 years A year or two of steady use.
6 to 12 months 6 to 12 months Most of a year behind them.
3 to 6 months 3 to 6 months A few months of practice with it.

Tools / apps / platforms

1 to 2 years 1 to 2 years A year or two of steady use.
DuckDB MongoDB Postman Snowflake CloudWatch Microsoft Excel
6 to 12 months 6 to 12 months Most of a year behind them.
Microsoft Power BI
<3 months <3 months Just getting started - under three months. This is also what shows when a level has not been set.
S3 dbt Git GitHub Lambda Mlflow Tableau Databricks EventBridge GitHub Actions Microsoft SQL Server Amazon Web Services AWS

Projects

  • SQL, Snowpark, Streams, Tasks, Dynamic Tables, GitHub Actions, Snowflake CLI, Streamlit

    Built an end-to-end ELT and data warehousing pipeline on Snowflake with automated transformations, CI/CD deployment, data quality monitoring, observability workflows, and a Streamlit dashboard.

  • Python, FastAPI, ORM

    Built a backend application serving a logistic regression model to classify credit card transactions as fraudulent or legitimate in real time.

  • Azure Data Factory, Delta Lake, Databricks, PySpark, Power BI

    Designed and deployed an end-to-end ETL/ELT pipeline on Azure with Medallion Architecture and sales analytics dashboards.

Courses & certifications

  • Snowflake Data Engineering · Coursera & Snowflake Zero-to-agents badge & RAG Apps with Snowflake Coco (Snowflake CoCo)
  • AWS Academy Cloud Foundations · AWS Academy
  • Databricks for Data Engineering · Udemy

Explore the Broxer community

Online · instant AI help
Broxer