Business Analyst at SC3Sixty (formerly Enterprise Analytics & Insights) (2024-04 – Present)
Aligned systems and processes to deliver operational efficiencies in ordering and stock availability for major FMCG retailers
- Aligned systems and processes to deliver operational efficiencies in ordering and stock availability for major FMCG retailers including Woolworths and Coles
- Minimised out-of-stocks through daily DIFOT performance reporting with advance knowledge of expected stock levels across planning and insights teams
- Developed key reports including Forecast Alignment, Trend Graphs, Sales Tracker, and Calendar Check to support planning and performance visibility across client accounts
- Automated complex reporting workflows using VBA and Power Query, improving operational efficiency and data processing accuracy across multiple client systems
- Created a Monthly Performance Overview dashboard displaying historical DIFOT and OBSL% trends across multiple suppliers, enabling data-driven insights and proactive planning
- Automated the Woolworths Performance Overview report by capturing screenshots from multiple Excel files and distributing consolidated updates to ISPs, streamlining regular supplier communications
Data Analyst at SC3Sixty (formerly Enterprise Analytics & Insights) (2022-07 – 2024-04)
Built and maintained Power BI dashboards for Woolworths and Coles supplier performance tracking
- Built and maintained Power BI dashboards for Woolworths and Coles supplier performance tracking, covering DIFOT, OBSL Overview, Trend Analysis, and Supply Collab workflows across 10+ FMCG clients
- Developed VBA macros and Outlook email automation for supplier-specific reporting across clients including Bega, Barilla, Chobani, Kimberly Clark, and Monde Nissin
- Integrated Python scripts with SharePoint-hosted Excel files to automate data extraction and distribution of formatted supplier reports via Outlook and Word automation
Analytics Consultant (Internship) at McColl's Transport (2021-06 – 2021-10)
Developed cost analysis models and logistics dashboards for supply chain optimisation
- Developed a Cost-to-Serve model and redesigned delivery routes to identify cost reduction opportunities across supply chain operations
- Built interactive Power BI and Tableau dashboards to communicate logistics performance and optimisation opportunities to senior stakeholders
