Denil John M S

About Denil John M S

I am a Data Analyst specializing in marketing analytics and data engineering projects, with experience delivering insights and building scalable solutions for global clients at Deloitte USI.In my current role, I support the Meta Ads team, where I analyze campaigns to answer stakeholder business questions,help identify targetable audience and optimize advertising strategies. I apply SQL, Python, A/B testing, waterfall analysis, overlap analysis, and contamination analysis to build targeted audience segments. My contributions improved campaign performance, driving higher engagement and more efficient targeting.Previously, I worked on Pfizer’s data migration projects, contributing to the transition of Redshift tables into Snowflake and validating Oracle to Salesforce migrations. I optimized stored procedures, created data models, and collaborated with testing teams to ensure data accuracy and faster query performance.With expertise across SQL, Python, Pandas, data modeling, and marketing analytics, I bridge the gap between data engineering and business strategy, enabling organizations to make informed, data-driven decisions.

Experience

1. Associate Analyst

   Deloitte

   Feb 2023 — Present · Bengaluru, IN

   Data Analytics for Meta Ads Team• Addressed stakeholder business questions to optimize advertising strategies for 34+ campaigns, focusing on audience engagement and relevance.• Applied SQL, Python, and A/B testing methodologies to extract, manipulate, and analyze campaign data, developing 34+ targeted audience segments in Salesforce Data Cloud.• Improved campaign performance by 27.5% providing actionable insights, contributing to enhanced engagement rates and more efficient targeting for future initiatives.• Conducted advanced marketing analytics including waterfall analysis, overlap analysis, and contamination analysis, delivering insights on audience behavior, campaign attribution, and cross-segment performance.Pfizer Data Migration – Redshift to Snowflake• Transitioned critical pharmaceutical datasets from Redshift to Snowflake while ensuring compatibility and performance.• Migrated 61 tables and optimized 23 stored procedures using SQL, created data models, and collaborated with thetesting team to maintain accuracy.• Achieved 95%+ data accuracy and improved database efficiency by 7.5%, enabling smoother analytics operations andfaster queries.Pfizer Data Migration – Oracle to Salesforce• Supported a large-scale migration project as part of the testing team, ensuring seamless data transfer from Oracle to Salesforce.• Executed SQL-based data validation to confirm data integrity and consistency across systems.• Contributed to a smooth transition by identifying discrepancies early, reducing migration errors, and supporting successful go-live.

Education

• Scaler

  Data Science and Machine Learning

  2025

• Bharata Mata College

  Bachelor's degree, Mathematics

  2019 — 2022

• St.Jospeh's EMHS,Thrikkakara

  High Secondary

• St.Joseph's EMHS,Thrikkakara

  SSLC