- Utilized advanced Excel functions, pivot tables, and macros to clean, validate, and organize large datasets from sales, inventory, and customer records, ensuring data accuracy and improving reporting efficiency.- Developed automated Excel dashboards to visualize key metrics like sales performance and inventory levels, providing real-time insights that contributed to a 12% increase in sales conversions.- Conducted data analysis using Python for statistical modeling and predictive analytics, identifying trends in customer behavior that helped reduce customer churn by 10% through targeted retention strategies.- Extracted and processed large datasets from internal databases using SQL, then integrated the data into Excel for further analysis, which improved forecast accuracy by 20%, leading to better demand planning.- Automated recurring reporting tasks using Excel, Python scripts, and SQL queries, reducing manual effort by 30% and significantly improving data accuracy across departments.- Optimized inventory management through predictive analysis, reducing holding costs by 15% while maintaining product availability, contributing to overall profitability.- Analyzed sales data to identify and phase out underperforming product lines, shifting focus to higher-margin products and increasing profit margins by 8%.