Customer & SKU Profitability Analysis | Excel FP&A
Developed an Excel-based profitability analysis tool for a fictional FMCG business, providing detailed financial insights across customers, product categories and individual SKUs.
The model combines budget versus actual reporting with interactive filtering to help identify profitability drivers and areas requiring commercial attention.
Key features:
Customer, category and SKU-level financial analysis
Revenue, gross profit and gross margin reporting
Budget versus actual performance comparisons
Gross margin variance analysis in basis points
Dynamic customer and category filters
Business value: Enables finance and commercial teams to identify underperforming products, understand customer profitability and make more informed pricing and portfolio decisions.
Independent portfolio demonstration using fictional data. Part of the Northstar Consumer Products financial analysis project.
0
15
Revenue Variance Analysis | Price, Volume & Mix (PVM)
Developed an Excel-based revenue variance analysis model for a fictional FMCG business to identify the underlying drivers of budget versus actual sales performance.
The analysis separates revenue movements into price, volume and product mix impacts, providing greater visibility into commercial performance.
Key features:
Price, Volume & Mix variance calculations
Budget versus actual revenue reconciliation
Interactive customer and category analysis
Variance bridge visualisation
Identification of key revenue performance drivers
Business value: Helps commercial and finance teams understand why revenue changes, identify pricing and volume opportunities, and support more informed business decisions.
Independent portfolio demonstration using fictional data. Part of the Northstar Consumer Products financial analysis project.
0
16
Northstar Consumer Products | FP&A Dashboard & Profitability Analysis
Developed an interactive Excel financial model for a fictional FMCG business, combining budget vs actual reporting, Price–Volume–Mix (PVM) analysis and customer-level profitability insights.
The dashboard helps demonstrate how businesses can identify revenue drivers, monitor gross margins and make better commercial decisions.
Tools: Microsoft Excel, Financial Modelling, FP&A and Variance Analysis.
Independent portfolio project using fictional business data.
Speculative ad brief for DefendUAS. Shifting the needle from basic product animation to high-stakes military storytelling.
Visually contrasting a gritty, hyper-realistic urban terrain with sharp, tactical holographic wireframes to show exactly how a distributed mesh network reclaims the decision window. Using a scene-by-scene strategy in Melius, starting with a master script that fed into storyboards and hero keyframes for total visual continuity across the cinematic clips. This workflow allowed me to lock the moody tactical aesthetic before generating the final video scenes, deep-voice narration, and orchestral score. Everything is laid out from left to right, showing the journey from concept to final assets. The project screenshots/canvas video are in the comments.
1
3
738
This project involved a comprehensive archival reconstruction aimed at distilling the legacy of Harvey Mackay into a series of high-impact sizzle reels. The workflow required a deep immersion into a diverse repository of assets, including magazine prints, book covers, and raw footage reels, to identify the most resonant narrative moments. The technical approach balanced traditional restoration with cutting-edge synthesis: colour correcting legacy footage and applying an intentional analogue aesthetic, while strategically integrating VEO 3.1 and Grok Imagine to bridge visual gaps. By layering refined sound design and exploratory revisions across four distinct durations, the final deliverables translate a vast professional history into a modern, energetic visual identity that both informs and excites.