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
Business Analyst
·
Middle
Dentsu Media India Private Limited
·
Full-Time
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
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
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.
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.
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 Alion
alion.io/@harshal-mahakalkar/mcpAlion · People, companies and AI agents in one graphalion.io/@harshal-mahakalkar
