Ryan Do — Business Insights Analyst
Available for opportunities in Sydney & remote

Ryan Do

Business Insights Analyst  ·  Sydney, NSW

Turning complex business data into clear insights and practical decisions without confusion.

I am not just someone who knows Python or dashboards.

With over six years of experience across FMCG and education, I specialise in translating messy, high-volume data into clear commercial insight. My work has spanned national trade marketing operations at British American Tobacco, key account planning at PepsiCo, and teaching advanced data science methods to postgraduate students at the University of Technology Sydney.

I hold a Master of Business Analytics from UTS and am comfortable across the full analytical workflow, from writing SQL and Python to building Power BI dashboards and presenting findings to senior leadership. I'm drawn to problems where rigorous analysis can shift strategy, not just describe it.

Data Science Tutor & Marker
University of Technology Sydney
Aug 2024 – Present
Commercial & Business Analyst
PepsiCo
Aug 2021 – Jul 2022
Trade Marketing Analyst
British American Tobacco
Jun 2017 – Dec 2020
6+
Years of Industry Experience
500+
Postgraduate Students Taught
300K+
Retail Outlets Covered
69
Key Account Negotiations Supported

Selected Analytical Work

End-to-end projects across predictive modelling, geospatial analytics, and business intelligence.

PepsiCo

Client Health Score Model

Developed a predictive scoring model to proactively surface at-risk key accounts during COVID-19. Incorporated sales trend, engagement frequency, and contract tenure signals to enable targeted retention actions - resulting in 100% Key Account retention across the portfolio.

Python Scikit-learn Excel Power BI
View project →
British American Tobacco

Geospatial Route-to-Market Optimisation

Applied geospatial analytics to audit national territory allocation and identify distribution inefficiencies. Redesigned field routes using clustering and proximity analysis, delivering a 16% reduction in RTM costs across the national network.

Python GeoPandas Pandas Matplotlib
View project →
British American Tobacco

Sales Compliance Detector

Built an unsupervised anomaly detection pipeline combining K-Means clustering with statistical outlier flagging to identify non-compliant sales patterns across a 300,000-outlet network. Protected incentive payouts and strengthened reporting integrity.

Python K-Means Scikit-learn Power BI
View project →
Full Project Portfolio
See everything I've built
Professional work and personal data projects - models, visualisations, and analyses.

Tools & Capabilities

A practitioner across the full analytics stack - from raw data extraction to executive-ready insight.

BI & Reporting
Power BI DAX Tableau Advanced Excel Pivot Tables Scenario Analysis Data Storytelling
Programming & Querying
Python pandas NumPy Matplotlib scikit-learn SQL R SAS
Analytics Methods
Demand Forecasting Segmentation Clustering Anomaly Detection Geospatial Analysis Machine Learning ROI Modelling
Stakeholder & Communication
Executive Reporting Requirements Gathering Cross-functional Collaboration Mentoring Presentation Strategic Briefing

Let's Connect

If you’re working on something interesting in data, analytics, or strategy, I’d love to hear about it. Always happy to chat.