Mahesh Hadapad
Bangalore
Summary
Data analyst with 6 years Experience and Results-driven Data Analyst with proven expertise and adept in Python ,MySQL, Power Bi. Skilled in transforming complex datasets into actionable insights through effective data cleaning and visualization in Power BI using Power Query and DAX Functional Logics. Recognized for enhancing workow automation and delivering client-focused solutions, while fostering strong relationships to understand business needs.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Data Analyst
Omnicom Global Solutions(Annalect India)
Bangalore
02.2023 - 04.2025
- Processed and validated large datasets from multiple social media platforms to ensure compliance and data accuracy. Cleaned and transformed data using Python, MySQL, SSMS for analytics and reporting.
- Analyzed complex datasets to identify trends, patterns, and actionable insights and Developed automation workflows using Python and MySQL to improve processing speed and accuracy.
- Designed the CDMO Taxonomy Compliance Dashboard to measure compliance scores across divisions, brands, and categories using Power BI Tool.
Data Analyst
Curiosearch Private Limited
Bangalore
12.2021 - 02.2023
- Provided end-to-end data solutions by understanding client requirements, analyzing historical data, and delivering actionable insights and business forecasts.
- Evaluated, cleaned ,transformed and analyzed e-commerce sales transaction datasets using Python and pandas.
- Created summary reports using Excel and Google Sheets when required.
- Strong experience writing SQL queries in SSMS and MySQL.
Senior Software Engineer
Mindtree
Bangalore
09.2021 - 11.2021
- Able to write complex MySQL queries like window functions, Join.
- Learned Python Data Processing and cleaning very well.
- Practiced designing of dashboard very well using Power BI.
Data Analyst
Curiosearch Private Limited
Bangalore
03.2021 - 08.2021
- Provided end-to-end data solutions by understanding client requirements, analyzing historical data, and delivering actionable insights and business forecasts.
- Evaluated, cleaned ,transformed and analyzed e-commerce sales transaction datasets using Python and pandas.
- Created summary reports using Excel and Google Sheets when required.
- Strong experience writing SQL queries in SSMS and MySQL.
Software Engineer
Iolite Technologies Private Limited
Bangalore
02.2019 - 02.2021
- Handled 1M+ records from MySQL and wrote complex SQL queries for data processing and reporting.
- Generated various client-specific reports using the BIRT Reporting tool.
- Gathered requirements, designed report structures, and built optimized SQL queries to meet client formats in BIRT.
- Developed parameterized, consolidated, and tabulated reports—including student attendance and annual marksheets—using BIRT, SQL, and Google Sheets.
Education
Bachelor of Engineering - Electrical, Electronics And Communications Engineering
KLE College Of Engineering And Technology
Chikodi, Belagavi01.2018
PUC -
Govt College For Boys
Vijaypura01.2013
SSLC -
Govt High School
Buranapur, Vijaypura01.2011
Skills
- Python
- MySQL
- Power BI
- Excel
- Pandas
- Numpy
- Statistics
- VS Code
- SSMS(MS SQL Server)
- Spyder
Certification
- Data Science with Python, IBM Simplilearn, 03/25/22
- MySQL Certificate, Hacker Rank
Languages
- Kannada
- English
- Hindi
Projects And Dashboards
- Knowledge Pro
- Blibli E-Commerce Product Recommendations
- CDMO Taxonomy Compliance
- Trend Analytics Dashboard
- Sales Analysis Dashboard
- CDMO Taxonomy Compliance Dashboards
- Sales Transaction Dashboards
Websites And Social Links - Linked In
https://www.linkedin.com/in/mahesh-hadapad-77a899176
Timeline
Data Analyst
Omnicom Global Solutions(Annalect India)
02.2023 - 04.2025
Data Analyst
Curiosearch Private Limited
12.2021 - 02.2023
Senior Software Engineer
Mindtree
09.2021 - 11.2021
Data Analyst
Curiosearch Private Limited
03.2021 - 08.2021
Software Engineer
Iolite Technologies Private Limited
02.2019 - 02.2021
Bachelor of Engineering - Electrical, Electronics And Communications Engineering
KLE College Of Engineering And Technology
PUC -
Govt College For Boys
SSLC -
Govt High School