Summary
Overview
Work History
Education
Skills
Projects
Certification
Timeline
Generic

MOHIN PATEL

Mumbai

Summary

Results-driven Business Analyst with a proven track record at Autoplant Systems India Pvt. Ltd., leveraging Python and Power BI to enhance supply chain performance. Skilled in strategic planning and communication, I developed dashboards that improved asset utilization and informed decision-making, leading to significant operational efficiencies.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Business Analyst

Autoplant Systems India Pvt. Ltd.
Navi Mumbai
11.2024 - Current
  • Analyzed logistics data to identify trends and inefficiencies using Power BI trip report dashboards, enabling strategic decision-making.
  • Developed device uptime dashboards for monitoring equipment usage and detecting inactive devices, improving asset utilization.
  • Collaborated with cross-functional teams to optimize resource allocation and enhance supply chain performance.

Business Analyst

Sciative Solutions
Navi Mumbai
09.2023 - 11.2024
  • Spearheaded revenue optimization projects for eight bus operators through large dataset analysis using Python, SQL, and Advanced Excel.
  • Developed data-driven pricing strategies to enhance profitability and support strategic decision-making.
  • Delivered real-time insights via Power BI to facilitate informed business choices.

Data Analyst Intern

Godrej Infotech
Mumbai
02.2023 - 06.2023
  • Collected and cleaned data from diverse sources to ensure accuracy for analysis.
  • Conducted statistical analysis with Python and Excel, revealing key trends and patterns.
  • Designed interactive dashboards using Power BI and Matplotlib to provide actionable insights.

Education

Bachelor of Engineering - BE - Computer Science

Alamuri Ratnamala Institute of Engineering And Technology
Mumbai
05.2023

HSC - Computer Science

Sree Narayana Junior College
Mumbai
02.2019

SSC - School

Chembur Karnatak High School
Mumbai
03.2017

Skills

  • Python and Pandas
  • NumPy and SQL
  • Power BI and Advanced Excel
  • Data analysis and Problem-solving
  • Flexible and adaptable
  • Multitasking skills
  • Communication excellence
  • Strategic planning
  • Problem solving

Projects

1. Trip Monitoring and Optimization Dashboard

  • Utilized Python for cleaning and transforming transporter-wise logistics data, and advanced Excel for preliminary analysis
  • Designed a Power BI dashboard to monitor trip frequency, profitability, and route trends, enabling stakeholders to make data-driven decisions that increased trip volume and operational efficiency.

2. Device uptime and utilization analysis

  • Cleaned and processed IoT device data using Python to identify downtime patterns and underutilized assets
  • Built a Power BI dashboard with key KPIs and visuals to track device uptime and flag inactive or damaged units, significantly improving asset utilization and maintenance planning

Certification

  • Data Science Internship, TCR Innovation - January 2022 to March 2022
  • Data Analyst Program, Godrej Infotech - February 2023 to June 2023
  • Python Masterclass, Udemy - August 2023

Timeline

Business Analyst

Autoplant Systems India Pvt. Ltd.
11.2024 - Current

Business Analyst

Sciative Solutions
09.2023 - 11.2024

Data Analyst Intern

Godrej Infotech
02.2023 - 06.2023

Bachelor of Engineering - BE - Computer Science

Alamuri Ratnamala Institute of Engineering And Technology

HSC - Computer Science

Sree Narayana Junior College

SSC - School

Chembur Karnatak High School

Similar Profiles

CREATE PROFILE
MOHIN PATEL