Data-Driven Campaign & Marketing Analyst

Sharvani Sri Audari

508-***-**** USA *************@*****.*** LinkedIn

Summary

Campaign and Marketing Management professional with 3+ years of experience in digital campaign execution, marketing analytics, and performance optimization across large-scale advertising ecosystems and lifecycle marketing programs. Skilled in SQL, Python, Excel, and BI tools to analyze campaign performance, customer behavior, and engagement metrics to drive data-informed decisions. Experienced in A/B testing, attribution, segmentation, and dashboard reporting, with strong expertise in optimizing campaign efficiency, improving conversion outcomes, and enabling scalable marketing operations through data-driven insights.

Technical Skill

• Data Analysis, Programming & Statistics: SQL, Python, R, Excel (Pivot Tables, Power Query, Power Pivot, VBA, Macros, XLOOKUP), data cleaning, data transformation, statistical analysis, hypothesis testing, regression analysis, trend analysis, forecasting, and exploratory data analysis (EDA).

• Data Visualization & Business Intelligence: Tableau, Power BI, Looker Studio, Excel dashboards, DAX, KPI reporting, interactive dashboard development, data storytelling, performance reporting, and executive-level insights generation.

• Marketing, Product & Customer Analytics: A/B testing, multivariate testing, Bayesian experimentation, funnel analysis, cohort analysis, marketing attribution, ROI optimization, CAC, CLV, churn analysis, RFM segmentation, customer segmentation, behavioral analytics, cross- sell/upsell modeling, SKU analysis, and Google Analytics.

• Data Engineering, Automation & Campaign Operations: Data integration, CRM data management, reporting automation, Alteryx, marketing data pipelines, campaign trafficking (DV360, CM360), Jira-based workflow management, QA testing, Agile/Scrum collaboration, stakeholder coordination, and performance optimization.

Professional Experience

Associate Campaign & Marketing Manager, Affirm 08/2025 – Present Remote, USA

• Performed end-to-end digital campaign plan across Affirm checkout and lifecycle journeys, using segmentation, cohort insights, funnel analytics, SQL, and Python to optimize targeting, engagement & conversion performance across 2.3M users, achieving 4% conversion rate improvement.

• Managed performance marketing and growth campaigns in collaboration with Product, Risk, and Data Science teams to design targeting strategies, optimize acquisition funnels, campaign planning, execution, and optimization processes, improving forecasting accuracy by 21%.

• Designed & completed multivariate and Bayesian A/B testing campaigns across checkout flows, onboarding journeys, and credit line upgrades, using audience segmentation, uplift modeling, and experimentation frameworks to maximize conversion and engagement outcomes, achieving 18% conversion uplift.

• Built a real-time campaign performance dashboards using Power BI, SQL, and Excel, tracking KPIs across customer engagement, conversion rates, and retention metrics to enable data-driven decision-making and stakeholder reporting efficiency, improving reporting speed by 22%.

• Implemented lifecycle marketing and CRM-driven campaign optimization across user journeys, implementing segmentation, attribution modeling, and automated reporting pipelines using SQL and Python to improve retention, CLV, and multi-channel campaign ROI performance. Campaign Manager / Media Operations, Annalect, Omnicom Media Group 01/2021 – 11/2023 Hyderabad, India

• Executed Automotive Digital Advertising Campaign Management across Display & Video 360 and Campaign Manager 360, collaborating with marketing, analytics, and operations teams through requirement gathering sessions to define KPIs, execution strategies, and delivery timelines across global client accounts efficiently.

• Built interactive Tableau dashboards and advanced Excel reports using pivot tables, VLOOKUP, formulas, and data modeling techniques to track KPIs, improving reporting efficiency and increasing stakeholder visibility into campaign performance metrics by 18%.

• Managed campaign trafficking and execution using Display & Video 360 and Campaign Manager 360, including placement setup, audience targeting, creative configurations, troubleshooting delivery issues, ensuring accurate ad serving, and reducing execution errors by 12%.

• Conducted campaign performance analysis using Google Analytics, applying segmentation, funnel analysis, cohort tracking, and attribution modeling techniques to identify user behaviour trends, optimize media spend, and improve click-through rate by 9% for automotive campaigns.

• Performed data analysis using Excel and Tableau, applying trend analysis, variance analysis, and KPI benchmarking methods to evaluate campaign efficiency, improve reporting accuracy, and support optimization decisions across multiple advertising accounts effectively.

• Collaborated with cross-functional marketing, analytics, and operations teams during requirement gathering, sprint planning, and QA reviews, streamlining workflows, improving campaign turnaround efficiency, and reducing setup time by 15% across global advertising projects.

• Used Jira-based QA tracking, workflow management, and documentation systems, ensuring defect resolution, prioritization, reporting accuracy, and operational excellence, resulting in 22% faster ticket resolution and improved campaign quality assurance processes overall consistently. Education

Master of Science (M.S.), Data Analytics 08/2024 – 05/2026 Clark University, Worcester, Massachusetts, United States Master of Business Administration (MBA) 06/2021 – 07/2023 CMR Technical Campus, Hyderabad, India

Bachelor of Business Administration (BBA) 06/2018 – 09/2021 Avinash College of Commerce, Hyderabad, India

Projects

Customer Churn and Revenue Analysis

• Analyzed customer transaction and engagement datasets using SQL and Python to identify churn drivers, segment customers by behavior, build dashboards, and apply predictive analytics to improve retention and optimize revenue growth strategic insights. Airline On-Time Performance Analytics

• Cleaned and transformed large-scale airline operational datasets using Python and SQL, developed interactive Tableau dashboards analyzing delays, KPIs, and trends, and used geospatial and time-series analysis to improve decision-making for operational efficiency insights. Comprehensive Analysis of Global Air Pollution and Its Health Impacts

• Performed exploratory data analysis on global air quality and health datasets using Python, identifying pollution trends across 50+ countries and integrating mortality and emissions data to assess environmental health impacts and risks insights.

Contact this candidate