Nikhil Mandekar

Senior Data Analyst | Python | SQL | Statistical Modelling | Hypothesis Testing | Tableau | Salesforce Marketing Cloud Intelligence - Datorama · Mumbai, Maharashtra, India

4 years of experience building analytics infrastructure that replaces manual effort with automated, decision-ready insight. At Omnicom Global Solutions, I engineer end-to-end data pipelines, automated validation frameworks, and real-time reporting systems that serve global clients across 5+ markets. My work spans the full analytics lifecycle from raw ingestion and data quality enforcement to statistical modelling, hypothesis testing, and executive-level reporting. Core stack: Python (Pandas, SciPy, Scikit-learn, Seaborn), SQL, Amazon S3, Tableau, Salesforce Marketing Cloud Intelligence (Datorama), Google Colab. Currently pursuing a Post-Graduation in Data Science & Machine Learning at Woolf University, England in collaboration with Scaler deepening expertise in machine learning, statistical modelling, and applied data science. https://github.com/NikhilMandekar

Experience

Senior Analyst

Omnicom Global Solutions · Apr 2026 – Present

Not yet confirmed

• • Promoted to Senior Analyst, taking ownership of analytics infrastructure across 5+ global markets and leading the transition from manual reporting to fully automated insight delivery.
• • Engineered a fully automated data validation pipeline in Python - performing SQL-based cross-partner file comparisons on data ingested from Amazon S3, compiling results in Google Colab, and triggering live Tableau dashboard refreshes via Google Drive - eliminating 2+ hours of daily manual QA.
• • Redesigned data ingestion and transformation logic in Datorama, delivering 25% faster dashboard refresh cycles and improving data consistency by 30% through schema validation and constraint enforcement at ingestion.

Analyst

Omnicom Global Solutions · Oct 2023 – Present

Not yet confirmed

• • Automated 15+ recurring analytical reporting workflows using Python (Pandas), eliminating ~90% of manual effort and reclaiming ~20 analyst-hours/week for statistical analysis and strategic decision support.
• • Collaborated with cross-functional marketing and analytics teams to design KPI-aligned data models, building a scalable and auditable reporting infrastructure across global client accounts.

Analyst

Merkle · Jun 2021 – Oct 2023

Not yet confirmed

• • Consolidated 8+ fragmented data sources into a unified analytics layer using Python and SQL, improving reporting efficiency by 50% and enabling cross-channel performance benchmarking.
• • Designed data-harmonisation logic and automated Datorama refresh pipelines, reducing manual data preparation effort by 80% and delivering analysis-ready datasets that informed multi-million dollar budget decisions.
• • Produced data dictionaries, transformation maps, and lineage documentation that reduced new analyst onboarding time by an estimated 35% and standardised analytical practices across the team.

T

Data analyst intern

Trainity · May 2021 – Jul 2021

Not yet confirmed

G

Quality Engineer

GEW RADIATORS INDIA PRIVATE LIMITED · Aug 2019 – Aug 2020

Not yet confirmed