Dhruv Siddhapura

About Dhruv Siddhapura

Data Analyst & Engineer | SQL · Python · Power BI · AWS Redshift · Airflow · Azure DevOps · GCP Big query | FinTech · Banking · AdTechI build data infrastructure that makes insights actually reach the people who need them — at the right time, in the right form.Over 3.5 years across Kotak Mahindra Bank and Media.net, I\'ve owned end-to-end data work: from designing production ETL pipelines on AWS Redshift and Airflow, to building Power BI dashboards used in C-suite reporting, to writing the Python automation that eliminated 40% of manual reporting workload on an AdTech platform.A few things I\'m proud of: Led A/B testing methodology that drove a 20% revenue uplift on ad campaign data at Media.net Built Airflow + Redshift pipelines with >99% accuracy, serving downstream BI models at Kotak Introduced Hive-based data integration with 50+ spam signal filters across publisher traffic datasets Designed cohort-based behavioural models for user churn and reactivation in bankingMy stack:SQL (Advanced) · Python (pandas, scikit-learn) · Power BI (Advanced DAX) · AWS (Redshift, S3, EMR) · GCP (BigQuery, Composer) · Airflow · Azure Data Factory · Tableau · Hive · Snowflake (basic) · DBT (basic)Domains: FinTech · Banking · AdTech · CRM analytics · Campaign reporting · User behaviour analysis d••••••••@gmail.com

Experience

1. Data Analyst

   Kotak Mahindra Bank

   Dec 2024 — Present · Mumbai, IN

   Kotak Mahindra Bank is one of India\'s largest private sector banks, serving 40M+ customers across retail banking, corporate finance, and wealth management. In this role I own data engineering and analytics for the digital banking and mobile app vertical — building the infrastructure that keeps product teams informed and fast. Engineered production ETL pipelines using Airflow, AWS Redshift, and S3, consolidating 10+ data sources into a unified analytics layer — supporting complex, multi-team reporting use cases Automated 200+ KPI reporting workflows via CI/CD (Azure DevOps), cutting report turnaround from 5 hours to 30 minutes — a ~90% efficiency gain Built a data validation and monitoring framework with automated alerting, achieving >99% data accuracy and enabling reliable historical tracking across all downstream models Designed an end-to-end mobile app migration funnel tracking the full user journey: SIM binding → OTP verification → registration/login — providing clear visibility into drop-off points at each step Conducted deep-dive RCA on install, SIM binding, and registration metrics, resolving identity mapping gaps in the absence of direct integration keys and significantly improving tracking reliability Developed interactive Power BI dashboards (advanced DAX) covering digital engagement metrics, banner impressions and CTR analysis, payment behaviour tracking, and app performance indicators — enabling faster decisions for product and leadership teams Built cohort-based user segmentation models (new, churned, reactivated) to support retention planning and customer lifecycle strategy Partnered with product, engineering, and business stakeholders to translate data findings into executive-level insights, influencing customer migration and growth initiativesStack: AWS Redshift · S3 · Apache Airflow · Azure DevOps (CI/CD) · Python · SQL · Power BI (Advanced DAX) · PostgreSQL · ETL · Data Warehousing

Education

• Shri T. P. Bhatia College Of Science

  HSC, Science

  2015 — 2017

• KJ Somaiya College of Engineering, Vidyavihar

  Bachelor of Technology - BTech, Mechanical Engineering

  2017 — 2021