Data Analyst
Current● Composed complex SQL queries utilizing various features such as joins, aggregate functions, subqueries, and set operations to retrieve and manipulate data● Collaborated with cross-functional teams to develop a statistical forecasting model, accurately predicting sales for the next quarter within 10% of actual results● Developed a customized automated change tracking process using Python for the Marketing team, reducing errors and man-hours by approximately 70%● Engineered a self-sustainable reporting system for executives, eliminating the need to create new SQL queries in case of changes, resulting in a 90%time savings during report updates● Conducted in-depth analysis of marketing strategies and store enhancements using statistical methods such as A/B Testing, contributing to the development of a long-term strategic plan and influencing key decisions around sales and growth● Designed automated reports in Tableau and Power BI to track cost per carton, total expenses, various surcharges, and total transportation volume on a weekly, periodic, and quarterly basis at hub, region, and carrier levels● Developed a tool using MS VBA and Python to update courier rate changes directly into the database, facilitating the business team’s work with transportation rates● Created process mapping using MS Visio for combining the promotional marketing emailing processes across various business groups● Constructed a comprehensive database encompassing all Staples products and associated companies' products detailing SKU numbers, dimensions, weights, associated child or parent SKUs, rates, discounts, availability, locations, and other product-level information
