Mohit Pandey

Data Engineer | Data Analyst
New Delhi, IN.

About

Highly accomplished Data Engineer and Analyst with over 3 years of experience, specializing in transforming complex raw data into actionable business insights. Proven expertise in designing and automating robust ETL pipelines, developing scalable dashboards, and implementing workflow automation, which has consistently reduced manual processing time by up to 50% and accelerated decision-making. Adept at leveraging Python, SQL, Power BI, and Azure technologies to drive efficiency, ensure compliance, and deliver significant operational cost savings across diverse industries.

Work

cKinetics Consulting Pvt.ltd.
|

Data Engineer

New Delhi, Delhi, India

Summary

Currently leads the development of ETL pipelines and data models to provide critical insights for carbon market analysis and client compliance.

Highlights

Created robust ETL pipelines, integrating data from diverse sources including APIs, commit portals, and web scraping (Selenium) to power carbon market price analysis.

Developed client-specific trend sheets and sophisticated models for carbon market analysis, enhancing predictive capabilities for multiple clients.

Designed and implemented advanced Excel and Power BI tools to effectively track carbon market prices and compliance metrics across multiple clients.

Reduced end-to-end reporting cycle from 3 days to just 4 hours by implementing Python, Selenium, Power Automate, and Zapier workflows, significantly boosting efficiency and accelerating decision-making.

Anglo Eastern
|

Energy Analyst (Energy Efficiency)

New Delhi, Delhi, India

Summary

Analyzed energy efficiency data and developed reporting solutions to optimize vessel operations and ensure regulatory compliance for a global shipping fleet.

Highlights

Designed comprehensive Power BI dashboards to monitor vessel CO2 emissions, fuel consumption per nautical mile, and EU-MRV compliance, enabling data-driven decision-making.

Automated SEEMP II and EU-ETS monitoring plan reports using Python, reducing monthly reporting time by 40% and improving accuracy.

Integrated Python scripts with vessel databases to proactively flag outliers in bunker data, preventing $72K in potential regulatory penalties.

Analyzed fuel savings across 50+ ships, generating insights that contributed to optimized voyage planning and achieved 7% operational cost savings.

Hikar Tech Pvt, Ltd.
|

Data Analyst

New Delhi, Delhi, India

Summary

Collaborated with product and marketing teams to analyze user behavior, predict revenue, and enhance data quality to drive business growth.

Highlights

Collaborated with product and marketing teams to define key performance indicators (KPIs) such as churn rate, Average Order Value (AOV), and funnel drop-offs, aligning data initiatives with business goals.

Designed and implemented real-time user behavior dashboards, which reduced churn by 12% through actionable insights.

Developed predictive models to accurately forecast monthly revenue with 85% accuracy, supporting strategic planning and resource allocation.

Cleaned and validated large datasets using Python, reducing data quality issues by 30% and improving data reliability for downstream analysis.

Education

UPES Dehradun
Dehradun, Uttarakhand, India

MBA

Business Analytics

RGPV Bhopal
Bhopal, Madhya Pradesh, India

BE

Mechanical Engineering

Certificates

IBM Certified Data Analyst

Issued By

IBM

Python Certification

Issued By

Udemy

Prompt Engineering Certification

Issued By

Udemy

Excel Certification

Issued By

Udemy

Full Stack Development Training

Issued By

Newton School

Skills

Programming Languages

Python, JavaScript.

Database & Cloud Platforms

SQL, Azure Data Factory, Azure Synapse, Azure SQL Database, Azure Function, CI/CD Pipeline.

Big Data & Version Control

Spark, GitHub.

Data Analysis & Automation Tools

Excel, Power BI, Selenium, Zapier, Power Automate, Data Visualization.

Methodologies & Concepts

ELT Process, Data Analysis, Problem Solving, Predictive Modeling, ETL Pipelines, Reporting Automation, KPI Identification, Data Validation, Data Modeling.

Projects

Automated ETL Pipeline for Multi-Source Data Integration and Predictive Analytics for Energy Efficiency

Summary

Developed and implemented an automated data pipeline for multi-source data integration, predictive analytics, and energy efficiency, enhancing data processing capabilities and enabling data-driven insights.