Business Intelligence Analyst
CurrentDeveloped and implemented automated reporting systems using Google Apps Script and Google Sheets, resulting in a 80% reduction in manual reporting time and improved data accuracy.Analyzed sales data from multiple sources (Salido, WooCommerce, Homebase) to identify key trends and provide insights for optimizing pricing strategies and menu development.Created a dynamic COGS tracking system in Google Sheets, enabling real-time cost analysis and facilitating data-driven decision-making for pricing and inventory management.Automated the weekly order assembly process by developing a custom Google Sheet that integrates with the WooCommerce API, improving order fulfillment efficiency and reducing errors.Generated and presented quarterly and annual financial reports with detailed analysis and visualizations, providing stakeholders with a clear understanding of financial performance at both macro and micro levels.Continuously identified opportunities to automate and streamline administrative and operational tasks, leveraging technology to improve efficiency and reduce manual effort.