Callan Roff
Data Analyst | Melbourne, VIC, Australia | He/Him
Summary
Data Analyst with 3.5 years' experience in retail operations and merchandising, helping identify opportunities and deliver multi-million dollar initiatives through predictive models, RFID-driven insights and process automation. Skilled translating big, complex data into meaningful and stakeholder-friendly insights. Strong foundation in mathematics and statistics, with strong coding skills in Python and SQL, and deployment experience on AWS and Azure.
Experience
Data Analyst (Operations) - Kmart Group
Melbourne, AU | Jul 2023 - Present
- Contributed to the development of RFID-based and machine learning algorithms that diagnose causes of low inventory accuracy, improving accuracy by 5% and unlocking $24M in incremental sales.
- Built and deployed an automated alert system for operations management, driving an additional 0.5% business-wide inventory accuracy uplift ($3M/year).
- Built a replenishment tracking algorithm, helping to drive a 30% productivity improvement for the process and ~$15M in additional sales.
- Led analytics for digital replenishment enhancements, identifying a $10M opportunity in lost sales reduction and designing an MVP algorithm for product-wise replenishment tasks.
- Designed a manifest accuracy algorithm using RFID data to highlight supplier shipment errors.
Data Scientist (Graduate) - Kmart Group
Melbourne, AU | Feb 2022 - Jul 2023
- Built a transaction-based predictive labour model for service desks, identifying and driving $4M in efficiency gains.
- Created a stocktake loss prediction model (85% accuracy), aiding the Loss Prevention team.
- Maintained an apparel recommendation engine to help identify substitutable products and optimise product ranges.
- Ran A/B tests and models on customer behaviour and product transaction correlations to inform product placement strategies.
- Presented insights across operational, planning, and merchandising stakeholders to drive alignment and action.
Education
MSc, Statistics - University of New South Wales (2020 - 2022)
Graduated with Distinction | WAM: 84
BSc, Mathematics - University of New England (2017 - 2020)
GPA: 6.4 / 7
Skills
General:
- Retail Operations
- Problem Solving
- Stakeholder Management
- Machine Learning & Business Analytics
- ETL & Cloud Computing
- Web Development
Technical:
- Python, R, SQL (Postgres, MySQL)
- Snowflake, Azure, AWS, Docker
- Git/GitHub, Flask, HTML/CSS
- Power BI, Excel, PowerPoint
Personal Projects
- Melbourne // Naarm Gigs: An application that scrapes and aggregates local music events, stores data in Azure Blob Storage, and is scheduled to run daily using Azure Container Registry and Azure Container Apps. Integrates OpenAI and Spotify APIs to extract artist names from event titles and provide links to their Spotify pages. Aggregated events are displayed on a published Flask web application: melbourne-gigs.com.au
- New Album to Playlist Recommender: Alerts Spotify user of new albums via SMS through Twilio API service. Recommends user playlists for new tracks by comparing aggregated audio features sourced from Spotify API using Euclidean distances.
- Personal Website/Blog/Resume: A flask application used to showcase my skills, interests, hobbies and project portfolio: callanroff.com