Illustrative Revenue-Growth-Management Analysis

Trade Promotion ROI — Colgate-Palmolive Australia portfolio

A single-source-of-truth view that reconciles scan, shipment and trade-spend data across Oral Care, Personal Care, Home Care and Pet Nutrition — then turns promotion economics into one decision: where the trade dollars work, and where they leak.

🧪 Independent analytics work sample by Michael Park. Uses Colgate-Palmolive's real, public product names for realism. All figures are synthetic and illustrative — not actual company data. Not affiliated with, authorised by, or endorsed by Colgate-Palmolive.

Across 100 promotions, $568k of gross profit is recoverable — by shifting spend out of the 52% of trade dollars sitting in ROI-negative promotions.

1.09

Blended ROI now

1.26

ROI after reallocation

Recoverable GP

Promotions analysed

+16% ROI uplift opportunity

📥

Drop a dataset to run it live Drag in a sample dataset — or your own data in the same schema — and every KPI, chart and table recomputes here in the browser. Nothing is uploaded anywhere.

📊

Awaiting your data

This dashboard computes everything from the dataset you provide — nothing is pre-loaded. Drop a file on the panel above to run the analysis live in your browser.

Curriculum Vitae — Michael Park

Michael (Hyojin) Park

Commercial Analytics Manager | Revenue, Pricing & Promotion Analytics | AI-Augmented Business Intelligence

BEng · GradCertE · MIEAust · CargoWise Certified Professional

PROFESSIONAL SUMMARY

Commercial analytics leader with 24 years turning complex commercial and operational data into executive decisions. I lead commercial intelligence for the Oceania region at Röhlig Logistics, partnering directly with the CCO and CEO on KPI governance, pricing and margin analysis, business cases, and the AI-assisted analytical infrastructure behind executive decisions. My craft is building a trusted single source of truth from multi-source data (SAP Analytics Cloud), translating analytics into commercial action, and enabling stakeholders to adopt it. Consumer-pricing roots in multi-country retail — price-change and margin-group scenario modelling, age-based repricing — give me the foundations of revenue growth management. Over the past 18 months I have layered modern AI and LLM tooling onto two decades of commercial judgement, shipping production-grade reporting automation and ROI analytics that compress multi-day cycles into same-day decisions.

KEY SKILLS

Commercial business partnering & client management — data-driven narratives and decision support for C-level, commercial and client stakeholders
Pricing & promotion analytics — price and margin scenario modelling, post-period ROI, profit and variance analysis
Single source of truth — SAP Analytics Cloud data-quality governance; multi-source data consolidation
Revenue & margin analysis — ROI and cost-benefit, cost-driver, variance, budgeting, forecasting, structured problem-solving and business case development
BI & data visualisation — SAP Analytics Cloud, advanced Excel, HTML/JS dashboards; adaptable to Power BI, Tableau and DOMO
AI-assisted analytics & automation — designing and deploying production-grade reporting and workflow automation with LLM-based workflows
Stakeholder enablement & data literacy — training, adoption, SOPs and executive intelligence briefings
Technical — statistical analysis & data interpretation, SQL and Python data tooling; bilingual English / Korean

PROFESSIONAL EXPERIENCE

Röhlig Australia Pty. Ltd. — Moorebank, NSW

Commercial Analyst — Oceania (operating at senior manager level) Oct 2021 – Present

Lead commercial intelligence for the Oceania region (AU, NZ, SE Asia), partnering directly with the CCO and CEO on KPI governance, pricing and margin analysis, business cases and AI-assisted analytics.

Built and own a multi-client commercial analytics platform consolidating six data sources per client into one trusted view — volume, trade lane, spend, KPIs, customs and CO₂ — turning multi-day reporting into same-day executive insight.
Designed AI/LLM-assisted reporting, workflow automation and daily executive intelligence briefings consumed at C-level before the morning starts, synthesising market, competitor and pipeline data into decisions.
Established a Negative Profit Reporting framework and shipment/PO variance analytics to surface margin leakage and trigger commercial corrective action across branches.
Led budgeting and financial planning across 8 branches (5 AU, 3 NZ), with cost-driver, variance and feasibility analysis of commercial opportunities.
Designed a BDM commission calculator and structured Quarterly Business Reviews, delivering data-driven performance, cost and growth insights to leadership and clients.
Act as SAP Analytics Cloud data-quality lead for Oceania — owning the trusted data foundation behind regional reporting.

Yusen Logistics (Australia) Pty Ltd — Horsley Park, NSW

Business Process Analyst — International Forwarding Division Jan 2021 – Oct 2021

Delivered A$1.2M identified savings through a Negative Profit billing process review.
Built monthly budget review tracking Revenue, GOP and NOP (Budget vs. Actual); weekly KPI frameworks; and volume trend & forecast analysis (M-1, M0, M+1).
Led customer implementations as the conduit between business development and operations across the supply chain.

Summit Global Logistics — Silverwater, NSW

Logistics Analyst — Customer Service Sep 2017 – Jan 2021

Built weekly KPI dashboards tracking operational, financial and service-level performance; managed end-to-end client order processing and customer issue resolution; produced weekly market-rate intelligence bulletins.

Fast Future Brands Ltd — Lane Cove West, NSW

Lead Business Analyst — Retail & Logistics Analysis Jan 2015 – Aug 2017

Pricing & margin analytics: price-change scenario modelling by margin group and stock level, and sales-age / stock-on-hand-age analysis driving short-term repricing and stock-transfer decisions across the retail network.
Commercial analysis: re-engineered the annual retail budget; analysed roster hours and wages against occupancy benchmarks; established lease governance.
Inventory & distribution: stocktake methodology, negative-value investigation restoring inventory accuracy, and courier-delivery error detection across the distribution network.
Logistics: overhauled inbound logistics from China, India and Bangladesh into AU/NZ/SG with forwarder benchmarking and lead-time analysis.

EARLIER EXPERIENCE

Lead Sourcing & Logistics Analyst, Fast Future Brands (2012–2015) — sourcing and retail-development project control.
Project Manager, CJ Land Pty Ltd (2010–2012) — building project scheduling, risk and cost control.
Transportation analytics & engineering, Korea (2000–2010) — metropolitan traffic demand modelling (EMME/2 four-stage prediction), Value Engineering and Life-Cycle-Cost analysis; quantitative-modelling foundations for partnering with data-science teams.

EDUCATION & CERTIFICATIONS

Graduate Certificate in Engineering (Civil) — University of Technology Sydney, 2015
Bachelor of Transportation Engineering — Hanyang University, Korea, 2001
MIEAust — Engineers Australia (2016); CargoWise Certified Professional & Specialist — WiseTech Global (2023)

TECHNICAL SKILLS & LANGUAGES

Analytics & BI: SAP Analytics Cloud, advanced Excel, SQL, Python, statistical analysis & data interpretation, HTML/JS data tooling, AI/LLM analytics & automation workflows; adaptable to Power BI / Tableau / DOMO
Languages: English, Korean (bilingual)

Connect on LinkedIn →

Cover Letter — Commercial Analytics Manager

Michael (Hyojin) Park

Supply Chain & Commercial Analytics Leader

17 June 2026

Hiring Manager

Colgate-Palmolive

Sydney, New South Wales

Re: Application for Commercial Analytics Manager

Dear Hiring Manager,

I am writing to express my interest in the Commercial Analytics Manager role at Colgate-Palmolive. As you would expect from any strong analytics hire, I will be direct about both the fit and the gap, because I think you will appreciate the honesty.

The analytical core of this role — partnering with commercial stakeholders, building a trusted single source of truth, pricing and promotion analysis, and translating technical output into executive decisions — describes the work I do today at Röhlig Logistics, where I lead commercial intelligence for the Oceania region and partner directly with the CCO and CEO. Over the past 18 months I have designed and deployed AI-assisted analytics that consolidate multi-source data into same-day executive insight: a multi-client analytics platform spanning volume, trade-lane, spend, KPI and margin data; a negative-profit and variance framework that surfaces margin leakage and triggers commercial action; and daily executive intelligence briefings the leadership team acts on before the morning starts. Earlier, at Fast Future Brands, I owned pricing and margin analytics across a multi-country retail business — price-change scenario modelling by margin group and sales-age analysis driving short-term repricing — so consumer pricing and promotion dynamics are not new to me.

What I would bring beyond the analytics craft is an AI operating model most analysts do not have. Colgate-Palmolive has named data, analytics and AI a pillar of its 2030 strategy and pointed to agentic AI as the next frontier for revenue growth management — and applying exactly those capabilities to commercial problems is what I do daily. I do not simply read about AI in analytics; I build and ship it.

The honest gap is industry and vocabulary. My recent background is freight and commercial analytics rather than FMCG, and I have not run revenue-growth-management or marketing-mix-modelling programmes by those names. What I bring instead is the discipline the role is actually built on — the description is clear that this is the bridge between the advanced data-science team and commercial decision-makers, not a model-building seat — together with genuine quantitative grounding (four-stage demand modelling earlier in my engineering career), consumer-pricing roots, and a track record of learning complex domains quickly, as I did with CargoWise. I am confident I would close the FMCG-specific gap fast.

I am based locally in Sydney and would welcome the opportunity to discuss the role. I have also prepared a short, practical demonstration of how I would approach your trade-promotion analytics, which I would be glad to walk through. Thank you for considering my application.

Kind regards,

Michael Park