Back to Developers
Dipak Bhalerao

Dipak Bhalerao

Data Analyst

Mumbai(Malad)
80
Profile Score

About

Detail-oriented Data Analyst with experience in Excel, Power BI, and data management, along with strong understanding of SQL for data analysis. Experienced in working with large datasets, building dashboards, automating MIS reports, and supporting operational decision-making. Comfortable working with ERP systems and SQL to ensure accurate, consistent, and reliable data. Passionate about turning raw data into clear, actionable insights that help teams work more efficiently.

Skills & Expertise (16)

Advanced Excel Advanced
8.0/10
1
Years Exp
Power BI Intermediate
6.2/10
1
Years Exp
Python Intermediate
5.5/10
1
Years Exp
SQL Intermediate
5.5/10
1
Years Exp
PivotTables VLOOKUP Power Query MIS reports KPI Dashboards Report Automation Pandas EDA ERP Data Cleaning Data Validation Jira

Work Experience

Data Analyst Intern

AiVariant pvt ltd.

Oct 2023 - Mar 2024

Gathered data from spreadsheets, databases, and external sources to build analysis-ready datasets. Cleaned and preprocessed data by handling missing values, duplicates, and formatting errors using Excel and Python (Pandas). Conducted exploratory data analysis (EDA) to identify trends and patterns; created charts and summary reports. Followed strict data privacy and compliance guidelines.

Delivery Consultant

BGPS Management Solutions Pvt Ltd

Aug 2023 - Sep 2023

Coordinated deliveries and ensured smooth completion of customer transactions. Handled logistics, customer communication, and issue resolution to maintain service satisfaction.

Data Analyst

Datamatics global services

Apr 2024 - Present

Managed airline catering material data, ensuring accurate tracking of requisitions, consumption, and inventory levels to maintain stock accuracy and reduce material wastage. Worked with data from client databases and Excel reports to analyze food catering and material movement data for operational insights. Performed data cleaning, validation, and transformation on large datasets related to meal counts, flight schedules, and inventory using Excel (PivotTables, LOOKUP functions, Power Query). Automated recurring MIS reports using Excel, reducing manual effort and improving reporting accuracy. Supported ERP operations on SACS (replica of SAP), ensuring accurate data flow across material movement, planning, and billing modules. Collaborated with Sourcing, Logistics, and Billing teams to reconcile material records, validate vendor invoices, and support procurement processes.

Education

Master of Business Administration - Sinhgad Institute of Management & Computer Application

- 2021 · Afghanistan

Bachelor of Business Management - INSTITUTE OF MANAGEMENT & RESEARCH

- 2019 · Afghanistan

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceMar 2026

Skills (16)

Advanced Excel Power BI Python SQL PivotTables VLOOKUP Power Query MIS reports KPI Dashboards Report Automation +6 more