Auckland, New Zealand · Customer & business analytics

Pavithra Bamunu

Fourteen years across multi-site retail in New Zealand and Asia: category P&L, demand forecasting, and leading teams of up to 120. At Samsung Electronics I grew a television category from $8.9M to a $16.8M peak against a shrinking core segment. Then I rebuilt here, with a First Class Honours Master's in Business Analytics and a Duty Manager's view of a supermarket floor. I build the tools as well as the analysis: the work below runs.

Python · R · SQLTableau · Power BIForecastingCategory P&LCRISP-DM
01

The record

14
years in multi-site retail, New Zealand and Asia
$16.8M
category peak at Samsung, grown from $8.9M
606
Auckland catchments segmented, 516,585 households
140+
automated tests in Shelly, a system that runs
02

Selected work

Working system · v2.5 · Python, R, SQL, JavaScript Shelly, an analytics agent for four businesses One brain running a neighbourhood store, a medical importer, a 3PL warehouse and a head-office tower with a clinic and a hotel, all on synthetic data. A week of POS, stock and waste becomes what happened, what's wrong and what to do today. Forecasts are checked honestly against days they never saw, departments agree one plan for one sign-off, every agent works inside a limit the owner sets, and you can just ask it a question, typed or spoken. CRISP-DM pipelineExcel with live formulasevent bus + SQLite modelsynthetic data only
68agents in 8 departments
66skills across the businesses
140+automated tests
4businesses, one brain
Case study · commercial analytics · 5 minutes Was the promo worth it? 317 grocery promotions scored against what each line would have sold anyway. Shoppers bought 47% more, but only 5% of promos paid their way: two years cost $10,154 of margin, mostly the discount on units that would have sold at full price. Then how deep to discount, how much a supplier must fund, and what sells together. baseline modellingcannibalisation and dipprice responsebasket liftCRISP-DM, step by step Interactive study · 2026 Catchment Mission Fit Do store formats match the shoppers who live around them? 606 Auckland catchments segmented by the shopping mission their households imply, laid over the public store network. Twenty-two come back mismatched, and one expected finding turns out to be wrong. K-means · PCA · bootstrapCensus 2023 · HES · OSMpublic data only Dashboard Catchment Command The same model laid out conventionally: map, segment profiles, distance matrix, a flagged shortlist and a live sensitivity model, all on one screen for a reader with four minutes. 606 catchments · 146 storescolour-vision checked The working Tool output, end to end The Python, R, SQL and Excel results behind the study, including a query set with no data to run against, executed against a documented schema to prove it is valid rather than pretending otherwise. scripts and console outputfour data defects, all disclosed
03

What the catchment study found

606
catchments analysed
516,585
households covered
22
format-to-mission mismatches
27×
a bigger lever than the one it set out to find

Fifteen inner-city catchments have 51.9% of households without a motor vehicle, and eight of those have no convenience-format store within a walkable kilometre while a competitor sits closer. The more useful finding came from the co-operative's published accounts: at a 3.17% margin the recapture opportunity is worth about $0.46m, while allocating $254m of annual capital 5% better is worth around $12.7m. The catchment gaps are not the prize; they are the evidence that the method finds things.

04

Trajectory

Asia · Samsung ElectronicsProduct management and B2B enterprise sales

Grew a television category from $8.9M to a $16.8M peak against a contracting core segment.

Asia · Ceylon Business Appliances · Orel CorporationSenior management, multi-site retail

Category P&L, demand forecasting, and direct leadership of teams of up to 120.

Auckland · UnitecMaster of Applied Business (Business Analytics), First Class Honours

Alongside an MBA (International Business) and an Executive Master of Project Management.

Auckland · Four Square Eden TerraceDuty Manager

Licensed Duty Manager: the operator's view of the trade the data describes.

05

Files and method

Every figure traces to a named script and a named source file. The catchment pipeline (scripts, intermediate data, outputs, logs and the written study) re-runs end to end and is available on request. Shelly is public on GitHub and runs from a clean clone.

Data boundary. I work in a Foodstuffs banner store. No employer data of any kind appears in this work, in raw, aggregated or anonymised form. The catchment study uses public sources only; Shelly ships with synthetic demo data.

Open to analytics roles in Auckland

Let's talk about your data.

Customer analytics, category and commercial analysis, forecasting, or building the tool your team keeps asking for.