My Portfolio - About Me

Senior Manager - Pricing and Strategic Analytics 2024-Current

Led a team of pricing managers and analysts, fostering their professional development and maximizing team performance
Developed and implemented a K-means clustering model to identify and analyse cross-border selling activities
Calculated elasticities to determine viability of price increases
Designed and implemented a Tableau dashboard for daily price anomaly detection, enabling proactive identification and resolution of pricing discrepancies

Director 2023-2024

Launched my own Analytics consulting business at https://www.rmanalytics.com.au/
Successfully handled Analytics projects for 4 clients, focusing on areas such as Pricing, Sales Force Effectiveness, and Omni-Channel strategy.
Guest speaker for AI topics

Industry Mentor (Business Analytics with SQL and Python) 2023-2025

Senior Manager – Advanced Analytics 2022-2023

Saved the company over $100k in consulting fees by confidentially producing cost-saving analyses to help support Directors in their decision-making process.
Used spatial analytics to determine high potential customers by matching high sales at pharmacies with health professional’s ‘sphere of influence’.
Determined new high potential areas through the acquisition of unique web data via web scraping with Python.
Assisted the Digital Team by writing HTML, CSS, AMPscript for an important digital campaign.
Created a prototype which sends an SMS internally when new data was added to a SFMC data extension utilising a Python script.
Analysed weather patterns to determine seasonality of a particular market for a launch product.
Created a library of different SQL queries to help speed up the work of other internal analytics professionals.

APAC Commercial Excellence Analytics and Automation Manager 2020-2021

Created a Python Programming module that automatically detects duplicated accounts in Salesforce (CRM) across Asia Pacific - 120 hours of labour saving.
Created an Alteryx Workflow and Einstein Analytics Dashboard which allows reps to access their sales performance and projected incentive payments daily via their mobile, tablet or laptop leading to a 1 head count saving. This was part of a Global project, and I was first to deliver across all countries.

ANZ Commercial Excellence Analytics and Automation Manager 2020

Promoted and offered a permanent position after 3 months in the previous role due to quickly fixing data related issues.
Created a Python module that automates distributor sales reports – 240 hours of labour per year saving.
Led the segmentation modelling for customers using sales, market share and the sales team input.
Provided a case study which influenced a restructure of the sales team.

SFE Analyst 2019

Cleaned and re-mapped all territories across Australia and New Zealand for 2 franchises in Salesforce (CRM).
Contributed to target setting and pricing analysis.

Traffic and Revenue Analyst (6-month contract) 2019

Analysed traffic patterns and toll revenue for the CFO and the Australian Securities Exchange (ASX).
Co-developed Tableau dashboard with SQL back-end to automate daily traffic and revenue reporting.
Automated data checks for a website with Python programming to satisfy ACCC requirements.

Sales Force Effectiveness Analyst 2017 – 2019

Drove insights for Head of Sales and Marketing by utilising financial data, CRM data (Salesforce) and Government data - displaying the insights with PowerBi. This included case studies for increasing head count, greater segment focus, mapping customer journeys etc.
Won New Employee of the Year.
Received a global award for a sales effectiveness excel model ‘Time Allocation Tool’.

Sales Intelligence Manager 2016

Promoted to a specialised role which brought more Data Analytics and Insights to the sales field force side of the business.
Revived a CRM database that had not been maintained for the previous 3 years. Established policies and a more logical primary key to help improve data extracts and consistency of reporting.
Extracted large data sets and created dashboards to help understand sales potential within areas. Combined this sales data with demographic data to help develop more robust sales strategies for the sales field force.

Special Project – Sales Execution 2016

Invited to be a project lead for a global project to improve Australia’s sales execution. I worked with an internal consulting team to map all the current routines and processes for the commercial side of the business and helped develop new routines for National Account Managers.
The team successfully rolled out the new routines and reporting structures to help better position our sales team to sell.
Created a comprehensive library which covered all data metrics from different data sources available to the business (Quantium, Nielsen Home Scan / Scan, Stay in Front, Aztec and QuickTurn).

Revenue Management Analyst (Commercial Finance) 2015–2016

Provided with intensive training from McKinsey Consulting on how to maximise profitability and optimise pricing using analytics within a business. This included monthly presentations to the ANZ CEO and CFO - producing insights developed from integrating shopping and financial data together to help make strategic decisions for the business.
Overcoming initial resistance from stakeholders who preferred opinions/intuition over data, to being part of a team who drove most commercial decisions for the business.
Provided several innovative solutions which has created large positive financial impacts, including:
Optimising promotions with pricing strategies and discovering new market segments.
3-Months International Secondment (China, Singapore, Tokyo)
A stretch assignment allocated to me in late 2015. I was asked to help optimise a process so that a project could be delivered successfully when it normally had a history of poor performance.
Region (APAC) moved from bottom ranking in 2014 to the number 1 ranking in the World for project delivery in 2015.

Boehringer Ingelheim & Commonwealth Bank – Sales