Shravani Chavan

India

@chavanshravani32

Personal Information

chavashravani369@gmail.com
+91-9769876286
Mumbai

Badges

Sql

Certifications

Work Experience

  • 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.

Education

  • Annasaheb Dange College of Engineering and Technology, Ashta, Dist. Sangli

    Bachelors of Technology Computer Science Engineering•  June 2019 - April 2023

  • SGM College Karad, Satara

    HSC•  July 2017 - May 2019

Links

chavanshravani32 has not updated links details yet.

Skills

Power BI
Advanced Excel
Power Automate
Looker Studio
Microsoft Fabric
Redshift
SQL
ETL
Lambda
IAM
API Gateway
Python
SQL Database
ETL Pipelines
Data Warehouse
AWS redshift S3 Buckets
Data Buckets
IAM Roles
Dashboards
AWS Lambda
REST API's
HTTP API's