Shreeya Ambre

Built and optimized advanced SQL queries (Snowflake) using CTEs, joins, and window functions to extract, filter, and transform marketing funnel data from large datasets, improving MQL-to-SQL conversions by automating lead scoring workflows. Generated and executed A/B and multivariate tests for email templates, subject lines, and landing pages, generating statistically valid insights that increased click-through rates and form submission conversion across segments. Designed and maintained scalable Power BI dashboards with advanced DAX formulas to monitor KPIs related to funnel progression, campaign efficiency, and revenue attribution. Conducted competitor spend benchmarking and share-of-voice analysis to identify strategic whitespace opportunities across paid channels. Delivered insight reports with performance narratives focused on MQL velocity, funnel progression, retention trends, and campaign ROI to cross-functional stakeholders during quarterly business reviews.

Analyzed performance across Google Ads, LinkedIn Ads, Meta Ads, and email campaigns using Google Analytics to uncover channel-specific drop-offs and optimization opportunities. Built multi-stage email nurture programs in Salesforce Pardot and Marketo Engage, resulting in a 15% lift in email engagement and higher lead nurturing effectiveness. Developed regression-based forecasting models with Python to predict Customer Acquisition Cost (CAC) and Lifetime Value (LTV), improving marketing ROI visibility. Implemented multi-touch attribution and last-touch attribution frameworks to analyze cross-channel performance and allocate spend effectively. Led market intelligence and competitor benchmarking using NielsenIQ, identifying emerging trends and high-value customer segments for GTM planning. Maintained Tableau dashboards to provide visibility into cross-channel performance, user acquisition, and engagement behaviors. Led the development of scalable campaign infrastructure aligning with CRM