Shrutika Pujari

Experience

• 

  The SAP Media

  Aug 2020 - Jan 2021

  Marketing Analytics Intern

  • Produced monthly analytical reports and dashboards using Tableau and Google Analytics to provide Key Performance Indicators (KPIs) to the stakeholders to optimize campaigns, improving reporting efficiency by 30%• Optimized email marketing campaigns by utilizing A/B testing, leading to a 4% increase in click-through-rates• Applied advanced Excel formulas and calculations, conditional formatting, VBA, Macros, XLOOKUP, VLOOKUP, pivot tables, filters, and solver to calculate and analyze conversion rates, click-through rates, and customer acquisition costs. Show less

• 

  DxSherpa Technologies | An EMERGYS Company

  Jul 2021 - Jul 2023

  Data Analyst

  • Conducted in-depth data analysis using Python and SQL to extract insights for marketing campaigns about ServiceNow CRM, ITOM, and ITSM software licenses, causing a 20% boost in conversion rates.• Collected comprehensive market research to understand consumer preferences and trends, providing valuable inputs for strategic data-driven marketing decisions, resulting in a 15% decrease in bounce rates.• Employed SQL to track and analyze customer journey data, identifying bottlenecks and optimizing conversion paths, contributing to a 20% increase in sales funnel throughput.• Implemented multi-channel attribution models to accurately measure the impact of various marketing channels on conversion rates, leading to better budget allocation and a 5% increase in overall marketing efficiency. Show less