StellantisDesign, build & roll-out of end-to-end Competitor Analysis tool (Clutch Competitive).16 Markets, 20 Brands, 2,900 Models, 1,000+ External & Local Agency UsersReporting includes dashboards to provide a clear & immediate view on KPIs such as:o SOV / SOM / AI /CPU - by Brand, by Competitor, By Market o Media Mix Forecast - by Brand, by Competitor, by Market o SOV / SOM / AI / CPU Trend - by Month, by Brand, By Marketo Media Spend versus Registrations - by Month, by Brand, by Competitors, by Marketo Forecast SOV / SOM / AI - by Brand by Market o LEV / NON-LEV SOV / SOM - by Brand, by (Selected) Competitors, by Market Introduced & enforced standardisation in media planning processes, rituals and ways of working across 54 markets globally.Designed, built & implemented Publicis Proprietary Upload Portal enabling media planners to self-validate plans via our automated QA checkers and validators, thereby ensuring only planned data that meets our quality benchmark of 100% passes into our databases.Accelerated our vision for creating a data democracy within Starcom via the creation of an online self-service Media Investment Reporting Tool. Tool enables Client & Agency to build bespoke reports based on the latest data, thereby moving teams away from legacy, manual reporting processes and towards increased effectiveness & efficiency via automated, scalable & sustainable online solutions.Promotes transparency, veracity, variety & velocity in planned data via the design, implementation & advocacy of custom built Data & Tech solutions. Solutions have been designed bespoke to Publicis with the overarching goal of providing control, transparency & crystal clear clarity over our data & data practices for both Client & Agency alike.

Marketing strategy and digital initiatives ideation, roadmap and roll-out. Managing a team of business and data analysts to build out Commercial Analytics capabilities and B2C & B2B reporting.Instilling ROI mindsets into wider business. Strategic ProjectsDesign of an in-house attribution framework.Value to business: Marketing budget optimisation, impact analysis on the interdependencies between, and relative importance of, marketing channels, ability to predict LTV over time.Creation of 3yr Overarching Marketing Strategy & supporting business case. Value to business: Reducing Kiwi’s dependency on B2B2C partners by narrowing the gap to the end-consumer. Cementing Kiwi’s USP via investigation of partnerships with data providers.Value to business: By using Kiwi consumer data in partnership with other data providers, Kiwi is uniquely positioned to aggregate and analyse passenger flow and demand, enhancing forecasting and predictive modelling techniques used within airport and terminal operations.Subscription scheme modelling as an alternative to customer loyalty scheme.Value to business: Boosting brand value and customer engagement and retention via the creation of an online Kiwi community.Creation of Composite Share of Market metric.Value to business: Share of Market and Share of Consideration to Share of Market ratio as key indicators in quantifying brand potential / ability to grow.Commercial & Operationso Creation and maintenance of daily, weekly & monthly marketing, CX and B2B dashboards.o Creation and iteration of customer segmentation analysis.o Multi-channel campaign tracking via dashboards.o Design and implementation of sales pipelines and B2B forecasting process

Developed and led business strategy and media planning processes globally.Part of core Senior Leadership team tasked with preparing Beamly for partner investment.Designed, built and implemented an in-house media planning solution (KatCh), developing ways of working in parallel, to allow media buyers & activators confidence in plan calculations and data scientists & engineers confidence in the resulting data's quality and completeness.KatCh - an in-house framework comprising media planning tool-kits and sets of processes and rituals to control work-flow and to enable continued, consistent & flawless execution via standardisation and automation.KatCh promotes excellence in decision-making, costs actualisation and reporting via its 'right first time' methodology. KatCh supports all brands, clients & markets.

• Overall responsibility for the management of all Financial Planning and Analysis.• Conducts business case analysis for new initiatives and opportunities.• The “go to” for COO and CEO in terms of interpreting financial information and preparing presentations to wider business, including Executive and Board level stakeholders.• Dealing with complex forecasts and budgets, including inception and execution of rolling forecasts.• Constant review and improvement of forecasting, reporting cycle processes and systems.• Development and implementation of all reports and analytics to drive desired end-results.• Assessment of initiatives against targets.

Streamlined all master data management operations including the accuracy, timeliness and relevance of centralised data – establishing and maintaining high data quality standards.Developed and implemented MDM strategy and associated processes in close collaboration with CFO and Senior Management to ensure master data is optimised to support business demands.Partnered with key stakeholders and users to understand current and future business needs, identifying business process changes and opportunities for improvement.

Creation of a fully automated model, deploying Monte Carlo simulation reasoning (1,250, 000+ iterations per run) to target investments and manage risk in order to optimise returns and outline a variety of best-case scenarios.Creation of a price optimisation tool to balance investments, thereby optimising revenue.

Use of advanced Excel and VBA techniques to manipulate financial data including P&Ls, balance sheets and financial statements, creating formats and files more suitable for data solutions tools.Conception of composite macros to pull time sheet and salary data from a variety of files, re-format into combined, flat files adding variance and cost analysis. Design, implementation and completion of tracker models, using VBA, which allow various finance departments to pool forecasted revenue and income from a variety of sources, adding basic variance analysis.Creation of Business Directors’ snapshots using VBA. Development of macro-enhanced tools enabling Business Directors to view their weekly position in terms of outstanding timesheets, debtors and unbilled clients. Includes week on week variance analysis.Conception and maintenance of client models, using macros, to automate the creation of multiple models (on a weekly basis) for individual line managers/ countries to be created and filed overnight.Design of month end procedure overhaul, using a mixture of Excel and VBA techniques.Involvement in Excel workshops intended to upskill staff. Main tasks involve designing solutions via Excel models to improve accuracy and efficiency of media staff’s work.A variety of smaller tools created on an ad-hoc basic.