Shaurya Sarswat

Provided actionable data insights for over 15 monthly advertisement pitches, directly contributing to the development of high-impact pitch decks and strategic recommendations for advertisers.

Delivered daily campaign performance insights by extracting and summarizing key metrics from BigQuery datasets exceeding 4 million rows, enabling rapid, data-driven decision-making.

Optimized core queries for the BLS Dashboard, achieving a 70% reduction in process threshold for critical analytics and KPI measurements, significantly improving data retrieval efficiency.

Developed comprehensive corpus reports for Mfilterit, cataloging over 40,000 content IDs to ensure precise and consistent brand-safe content valuation.

Spearheaded Salesforce migration by meticulously analyzing 100+ table schemas and constructing robust backup views, ensuring zero-downtime transition and high data quality assurance.

Collaborated with AdOps and Sales teams to develop and maintain audience targeting queries, successfully supporting campaigns that engaged over 5 million users monthly.

Owned end-to-end channel attribution reporting, utilizing Metabase, PostgreSQL, and Excel to analyze large datasets, which directly contributed to a 10% month-over-month revenue increase.

Collaborated cross-functionally with internal and external partners to monitor key business metrics, fostering alignment and achieving a 15% increase in lead generation.

Automated reporting processes and developed real-time dashboards in Metabase and Tableau, increasing onboarding SOP completion from 30% to 57% and ensuring seamless tracking of process metrics.

Authored Product Requirement Documents (PRDs) for high-impact tech implementations, including automating lead assignment workflows, reducing lead wait time by 80%, and content automation initiatives that boosted lead lifecycle SOP step completion by 21%.

Applied A/B testing methodologies to evaluate and optimize onboarding workflows and training modules, identifying high-performing variants and significantly improving conversion and engagement metrics.

Partnered with Field Sales leadership to lead the quality assurance process, leveraging performance analytics for data-informed training, which resulted in a 10% month-over-month revenue increase.

Enhanced lead quality by reducing false leads from 17% to 9% (August to October) and simultaneously increasing lead volume by 15% (November) through continuous process optimization.