Bhavya Sangoi

Media Analyst at McDonald’s

Planned and executed paid social campaigns across Meta Ads, Google Ads, and Amazon Ads, using audience segmentation and creative testing to improve CTR by 20% and reduce CPA by $2.50 across key demographics. Analyzed cross-channel e-commerce data with SQL, Tableau, and Excel to identify underperforming SKUs and gaps, contributing to a 15% ROAS improvement and 12% margin growth QoQ. Implemented on-page SEO practices on campaign landing pages, increasing organic visibility by 18% and CTR by 22%. Analyzed media and traffic trends using Veraset location data to link promotions with in-store footfall, driving a 23% footfall increase during promotions. Enhanced end-to-end customer journeys using HubSpot and Salesforce Marketing Cloud, resulting in a 22% increase in targeted engagement. Built and maintained dynamic Tableau dashboards tracking weekly KPIs across regions, reducing manual reporting by 5+ hours per week. Collaborated with creative and product teams to integrate UI/UX principles i

Data Consultant at WelcomeTech

Designed and executed A/B tests using SQL and Python to measure marketing effectiveness, delivering data-driven insights that increased retail brand awareness by 30% and improved lower-funnel conversions by 25% over a quarter. Set up and maintained conversion tracking using Google Tag Manager, GA4, and Floodlight, ensuring data integrity above 99%. Implemented multi-touch attribution and clustering models using Python and BigQuery to delineate the customer journey, boosting ROI accuracy by 30% and decreasing wasted ad spend by reallocating funds to higher-performing channels and segments. Developed and deployed HTML/CSS updates for 20+ landing pages, improving page load speed by 15% and enabling 30% faster campaign launches while maintaining brand consistency. Researched and reported competitive pricing strategies through audits and tools, contributing to a 12% sales lift during seasonal campaigns. Leveraged GA4 and UTM tagging to track user engagement and conversion funnels, deliverin

Data Analyst at iRecord

Performed Exploratory Data Analysis (EDA) and predictive analysis using Python to identify churn drivers and build ML models, achieving over 85% prediction accuracy. Conducted statistical analysis on 200+ financial assets to optimize portfolio performance, resulting in a $50K yield improvement through informed reallocation. Created and presented an interactive Power BI dashboard for a team of 5, using Power Automate and Schedule Flow for weekly dashboard updates, accelerating decision-making and stakeholder understanding.

Media Analyst at McDonald's

Planned and executed paid social campaigns across Meta, Google, and Amazon Ads, leveraging audience segmentation and creative testing to improve CTR by 20% and lower CPA by $2.50 across key demographics. Analyzed cross-channel e-commerce data using SQL, Tableau, and Excel to identify underperforming SKUs and gaps, driving a 15% ROAS improvement and 12% margin growth QoQ. Implemented on-page SEO on campaign landing pages (meta tags, keyword optimization, internal linking) increasing organic visibility by 18% and CTR by 22%. Mapped media and traffic trends with Veraset data, contributing to a 23% footfall increase during promotions. Enhanced end-to-end customer journeys using HubSpot and Salesforce Marketing Cloud, boosting targeted engagement by 22%. Built executive Tableau dashboards tracking weekly KPIs across regions, saving 5+ hours/week. Collaborated with creative/product teams to apply UI/UX improvements on landing pages, reducing bounce rate by 12% and improving engagement on mob

Data Consultant at WelcomeTech

Designed and executed A/B tests using SQL and Python to measure marketing effectiveness, delivering insights that increased retail brand awareness by 30% and improved lower-funnel conversions by 25% quarterly. Set up and maintained conversion tracking with GTM, GA4, and Floodlight, ensuring >99% data integrity across campaigns. Implemented multi-touch attribution and clustering models using Python and BigQuery to map the customer journey, improving ROI accuracy by 30% and reducing wasted spend by reallocating funds to higher-performing channels. Developed and deployed HTML/CSS updates for 20+ landing pages, improving page load speed by 15% and enabling 30% faster launches while preserving brand consistency. Researched competitive pricing strategies to recalibrate SKUs during seasonal campaigns, yielding a 12% sales lift. Leveraged GA4 and UTM tagging to track engagement and funnels, delivering insights that contributed to a 15% ROI increase.

Data Analyst at iRecord

Performed Exploratory Data Analysis (EDA) and predictive modeling with Python to identify churn drivers and achieve 85% prediction accuracy. Applied statistical analysis on 200+ financial assets to optimize portfolio performance, yielding a $50K uplift. Created and presented an interactive Power BI dashboard with a team of five, enabling weekly updates via Power Automate and Schedule Flow and accelerating decision-making.

Media Analyst at McDonald’s

Planned and executed paid social campaigns across Meta Ads, Google Ads & Amazon Ads, leveraging audience segmentation and creative testing in Salesforce CRM to improve CTR by 20% and lower CPA by $2.50 across key demographics. Developed data-driven site personalization strategies using Adobe Target, resulting in a 12% increase in homepage click-through rate and improved user engagement across key customer segments.

Data Consultant at WelcomeTech

Designed and executed A/B and multivariate tests using SFMC, SQL and Python to measure marketing effectiveness, delivering data-driven insights that improved unaided brand awareness by 30% and lower funnel conversions by 25% over quarter. Built and automated multi-step customer journeys using Marketo and Salesforce Marketing Cloud’s Journey Builder, resulting in a 25% increase in customer engagement and a 30% reduction in manual campaign deployment time. Collaborated with CDP and analytics teams to map over 500K user touchpoints across mobile, email, and web, enabling unified customer journey orchestration (MTA) and contributing to a 22% increase in multi-channel engagement and a 15% lift in conversion rates. Presented campaign performance recaps and strategic recommendations to senior leadership on a biweekly basis.

Data Analyst at iRecord

Performed Exploratory Data Analysis (EDA) and predictive analysis using Python to identify churn drivers and build machine learning models, achieving over 85% prediction accuracy. Automated and presented interactive Power BI dashboards with a team of 5, using Power Automate and Schedule Flow for weekly updates. Collaborated with the marketing and CRM teams to analyze media-driven customer behavior, helping boost customer retention rate by 15% through targeted data-driven content strategies over two quarters.

Media Analyst at McDonald’s

Planned and executed paid social campaigns across Meta Ads, Google Ads and Amazon Ads using audience segmentation and creative testing in Salesforce CRM; improved CTR by 20% and lowered CPA by $2.50 across key demographics; developed data-driven site personalization with Adobe Target, increasing homepage CTR by 12% and engagement; correlated media trends with in-store traffic using Veraset and Excel, boosting footfall by 23% during promotion weeks; used SQL and Python for segmentation modeling (RFM, predictive scoring) and control group analysis, improving retention by 17% and campaign ROI by 22% across Email, SMS and Direct Mail; evaluated brand KPIs across regions with SQL and Tableau to identify underperforming channels and optimize ad spend, contributing to a 15% ROAS lift.

Data Consultant at WelcomeTech

Designed and executed A/B tests and multivariate tests using SFMC, SQL and Python to measure marketing effectiveness; improved unaided brand awareness by 30% and lower funnel conversions by 25% quarter over quarter; analyzed CRM campaigns across Email, SMS and Direct Mail, uncovering insights that led to a 15% boost in email engagement; built and automated multi-step customer journeys using Marketo and Salesforce Marketing Cloud Journey Builder; 25% increase in customer engagement and a 30% reduction in manual campaign deployment time; mapped over 500K user touchpoints across mobile, email and web enabling unified customer journey orchestration (MTA); 22% increase in multi-channel engagement and a 15% lift in conversions; presented campaign performance recaps to senior leadership biweekly, influencing roadmap, budgets.