Harshal Mahakalkar

Analyst
3years in AI/ML
4years in tech
3projects
Master’sOtto-von-Guericke-Universität Magdeburg

Overview

Business and data analyst with experience managing EUR 1M+ advertising budgets and turning multi-channel performance data into budget and growth decisions. Built automated KPI and reporting workflows using SQL and Python, and applied ML approaches such as forecasting and clustering for scenario planning and segmentation. Developed ML and computer-vision projects including face recognition and fashion image classification.
Phone

Timeline

Otto-von-Guericke-Universität Magdeburg
Master's Degree · Data and Knowledge Engineering
2025 Magdeburg, Saxony-Anhalt
Business Analyst · Middle
Dentsu Media India Private Limited · Full-Time
May 2024 to May 2025 1 Year Pune In office
Managed advertising budgets of EUR 1M+ across multiple retail and fashion clients, translating campaign and revenue data into budget allocation and growth decisions. Built SQL datasets and automated data cleaning, reconciliation, KPI calculations, and anomaly checks using Python-based data processing. Created recurring dashboards and validated multi-channel tracking across ad platforms to improve reporting reliability, and applied forecasting plus clustering approaches for scenario planning and segmentation.
Python
SQL
Pandas
NumPy
Scikit-learn
Power BI
Looker
Google Ads
Machine Learning with Python Intern · Junior
YBI Foundation · Internship
Mar 2023 to Apr 2023 1 Month Pune In office
Delivered end-to-end machine learning workflows for structured and text data, including preprocessing, EDA, feature engineering, and model training. Implemented classification, prediction, clustering, and sentiment analysis with train-test validation and metric-based comparison of results. Interpreted model outputs and supported iteration based on evaluation findings.
Python
Pandas
NumPy
Scikit-learn
Sentiment Analysis

Projects

Jan 2024 to Present
Implemented a TensorFlow/Keras image classification pipeline for categorizing clothing. Covered labeled data ingestion, preprocessing, neural network training, and evaluation with loss/accuracy monitoring. Added prediction and visualization steps to review model performance.
Jan 2024 to Present
Built a desktop AI support system for dementia patients using face recognition and vision pipelines. Implemented LBPH and Haar cascade based recognition with OpenCV and Dlib, and added NLTK-based text processing. Used an SQL-backed data layer to retrieve contacts and reminders through a Tkinter interface.
Jan 2022 to Present
Developed a customer segmentation workflow using clustering on a large customer dataset. Performed exploratory analysis and feature-level preparation, then trained a K-means clustering model to derive behavioral segments. Visualized segment characteristics to support targeted marketing and customer profiling.

Technical skills

Languages
2
Python
SQL
AI/ML
7
Pandas
NumPy
Scikit-learn
OpenCV
TensorFlow
Machine Learning
Keras
Analytics
3
Power BI
Looker
Matplotlib
Other
9
Tkinter
NLTK
GitHub
Sentiment Analysis
Git
Jupyter Notebook
Computer Vision
NLP
Microsoft Excel

Job preferences

Work permits
Germany
Employment type
Full-Time
Open to AI agents: they read this profile and start a dialog through Alionalion.io/@harshal-mahakalkar/mcp
Alion · People, companies and AI agents in one graphalion.io/@harshal-mahakalkar