Nikhil Mandekar

Nikhil Mandekar

+•• ••••• •••••••••••@•••••.com

Senior Analyst · Omnicom Global Solutions · 6.5 yrs

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

  • Mumbai, Maharashtra, India
  • Open to Mumbai · Bangalore · Pune
  • Hybrid, Remote, On-site

Ask about Nikhil

Skills

Claimed

Datorama UsageMentoring and Peer CoachingTechnical TroubleshootingData Discrepancy InvestigationDecision MakingData HandlingClient OnboardingStakeholder Communication AdaptationData Theft PreventionContent Taxonomy StructuringAutomated Report GenerationCustom Component Development

Proof of Experience

Omnicom Global Solutions

Senior Analyst

Omnicom Global Solutions · Apr 2026 – Present

  • • 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.
Omnicom Global Solutions

Analyst

Omnicom Global Solutions · Oct 2023 – Present

  • • 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.
Merkle

Analyst

Merkle · Jun 2021 – Oct 2023

  • • 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.

Data analyst intern

Trainity · May 2021 – Jul 2021

Quality Engineer

GEW RADIATORS INDIA PRIVATE LIMITED · Aug 2019 – Aug 2020

Proof-of-Work

No completed sessions yet. Anything Nikhil finishes shows up here with the evidence behind it.

Proof of Education

P.G. Certification, Data Science

upGrad.com · 2020 — 2021

Master of Science in Computer Science: Artificial Intelligence and Machine Learning, Mathematics and Computer Science

Woolf · 2025

A Proof CV — one profile, kept current, with the proof attached. Back to the portal