Shravani Chavan

Associate Data Analyst

Knya Enterprises•  April 2023 - Present•  Mumbai

2+ years of experience in data analysis, ETL, visualization and delivering strategic insights for business growth. Improved ROAS by 27% and reduced CAC by 22% within three months by analyzing Meta ad campaign performance and providing data-driven insights to guide media spending decisions. Built a Z-score-based report to identify statistically significant anomalies in website performance, sales and post sales performance. Developed and implemented webhook APIs to integrate financial data from Cashfree and Razorpay, enabling real-time reporting through dynamic dashboards in Power BI and Looker Studio. Designed and built end-to-end data warehousing solutions using Amazon Redshift, with ELT pipelines extracting data from sources including Google Analytics 4, Unicommerce, Clickpost, and Shopify. Increased average order value (AOV) by 7% within one week by segmenting customer cohorts and implementing targeted marketing strategies based on historical behavior. Saved two hours of manual reporting daily for the retail team by creating an automated retail performance dashboard using SQL and AWS Redshift Query Editor. Created executive-level reports and dashboards that enabled cross-functional alignment across marketing, finance, customer service and retail departments, leading to a 15% increase in operational efficiency. Identified internal linking opportunities to improve SEO and crawler optimization, resulting in a 9% increase in organic revenue in one month. Increased personalized orders by 3% in one week by recommending changes to product page layouts and content based on user interaction data. Built a new revenue channel from the ground up, including standard operating procedure development, reporting infrastructure, and team hiring; the channel contributed 8% of net revenue in its first month.