Swapnil Sonawane

About Swapnil Sonawane

Experienced Data Analyst with a track record of providing meaningful insights, enhancing database efficiency, and streamlining data-driven decision-making processes.• Capable of managing complicated data sets using tools such as SQL Server, Excel, Power BI, Tableau, and Python to improve operational efficiency and promote corporate success.• Throughout my career with top organizations such as Amazon, Cisco, and Sage, I have polished my skills in data wrangling, analysis, and visualization, resulting in major improvements in key company KPIs, customer satisfaction, and profitability.• Managed and optimized SQL Server databases, achieving up to a 35% reduction in query execution time and a 25% improvement in query response time.• Developed and maintained interactive Power BI and Tableau dashboards, leading to a 30% reduction in manual reporting and a 20% improvement in decision-making efficiency.• Executed advanced SQL analyses on product, demographic, and sales data, generating insights that led to a 20% increase in customer retention and a 10% rise in profit margins• Engineered customer segmentation frameworks, boosting acquisition efficiency by 35% and improving marketing campaign ROI by 50%.• Conducted exploratory data analysis (EDA) and implemented data cleansing using SQL, Python (NumPy, Pandas, Matplotlib, Seaborn), and Excel, enhancing data accuracy by up to 40%.• Deployed automated solutions for email campaigns and B2B data extraction, increasing client acquisition by 40% and reducing manual• Workloads.Implemented data quality rules, resulting in a 30% reduction in data errors and improved customer satisfaction.

Experience

1. Data Analyst

   Amazon

   Feb 2022 — Present · GB

   Managed and enhanced SQL Server databases, ensuring data integrity, query optimization, and performance monitoring, resulting in a 25% improvement in query response time.• Created and implemented database schemas, tables, and views, leading to a 30% increase in data retrieval efficiency and effective data modeling and organization.• Executed comprehensive SQL Server analyses on product, demographic, and sales data; generated actionable insights enhancing strategic decision-making, leading to a 20% rise in customer retention and a 10% increase in profit margins.• Engineered detailed customer segmentation frameworks using SQL Server and behavioral insights; boosted customer acquisition efficiency by 35% and increased marketing campaign ROI by 50%.• Implemented SQL Server database improvements and performance tuning, leading to a 35% decrease in query execution time.• Analyzed client activity and engagement metrics with Excel-based exploratory data analysis (EDA) and data purification, resulting in a 40% improvement in the accuracy of analytics and reporting.• Developed and maintained interactive Power BI dashboards, resulting in a 30%reduction in manual reporting time, increasing report utilization.• Conducted advanced data analysis and integrated data primarily from SQL Server into Power BI, leading to a 15% improvement in operational efficiency and increased data-driven decision-making.• Excelled in administrative tasks, managing data entry, inventory management, and delivering top-tier customer service. Thrived in fast-paced, leveraging expertise in Office 365 and Microsoft Power BI to bolster team efficiency and elevate customer satisfaction to new heights, improving overall operational performance by 25%.• Designed and operationalized data visualization dashboards using Tableau, presenting key business metrics and trends to stakeholders, ensuring a 30% improvement in decision-making processes.

Education

• Swansea University / Prifysgol Abertawe

  Master of Science - MS, Management (Business Analytics)

  2022 — 2023

• Savitribai Phule Pune University

  Bachelor of Engineering - BE, Mechanical Engineering