Looking for a job

MOHIT MOHAN

@mohitmohan

Message

Data analyst skilled in SQL, Power BI, and Excel driving actionable business insights.

India

Message

What I'm looking for

I seek analytics roles where I can build dashboards, perform EDA and root-cause analysis, and drive operational improvements in collaborative teams.

I am a data analyst with over five years of hands-on experience turning large operational datasets into clear, actionable insights using SQL, Excel, and Power BI. I focus on data cleaning, exploratory data analysis, KPI tracking, and dashboarding to support measurable business improvements.

In recent roles I directed development of production-validation devices, designed automated Excel and Power BI dashboards, and performed root-cause analyses that reduced defect rates and improved key production metrics. I combine technical proficiency (SQL, Python, DAX) with a practical understanding of manufacturing and product engineering workflows.

I pursue solutions that reduce manual effort and accelerate decision-making—delivering automated reporting, trend analyses, and performance tracking that drive efficiency and quality across operations.

Experience

Work history, roles, and key accomplishments

Analyst - Quality Assurance

Imagine Marketing India Ltd. - Boat Lifestyle

Sep 2023 - Dec 2023 (3 months)

Directed development of 6 PVT devices for TWS earbud models, reducing production testing time by 15% and implemented automated Excel dashboards that cut manual reporting effort by 30%. Queried production data with SQL to identify defect trends and reduce defect rate by 8%.

SQL Power BI Excel Dashboarding Data Cleaning EDA KPI Tracking Root Cause Analysis Project Management Stakeholder Management

Analyst - Product Engineering

Oppo Mobiles India

Aug 2020 - May 2023 (2 years 9 months)

Conducted root cause analysis of structural and cosmetic smartphone issues, reducing defect rate by 8% and designed automated Excel KPI dashboards that helped increase OTPR by 15%.

Root Cause Analysis Excel SQL Dashboarding KPI Tracking Power BI EDA Data Cleaning Project Management Stakeholder Management

Assistant Engineer - Design

Adroit Instruments

May 2019 - Jul 2020 (1 year 2 months)

Developed 3D models of plastic injection molding components in SolidWorks from 2D drawings and prototypes, improving design accuracy and efficiency by 40% and reducing lead times by 15% through CAD modifications.

Solidworks CAD Injection Molding Process Improvement Prototype Translation Project Management

Field Service Coordinator

Johnson Controls - Hitachi Airconditioning (I) Ltd.

Jan 2018 - Sep 2018 (8 months)

Cleaned and transformed technician service datasets using advanced Excel functions and built performance dashboards to track AMC renewals and service response metrics.

Excel Pivot Tables Index Match Power Query Dashboarding Data Cleaning Stakeholder Management