David Gotts Email & Phone Number

Auckland, New Zealand

• Design and set commercially viable and competitive pricing constructs, strategies and build economic business cases applying modelled quantitative evidence aligned to the strategic direction of the company.• Business case propositions include restructuring mobile proposition and investment strategies for One NZ’s network, applying cost-benefit analysis considering price elasticities, base risk assessments and unintended consequences, manipulating data from Qlik Sense and PowerBI and modelling in MS Excel to show Key Performance Indicators (KPI).• Condense analysis into MS PowerPoint presentations, clearly and concisely story telling complex information to senior leadership team up to Director level to advise on viability, highlighting major risks and sensitives.• Sit in agile squad and manage stakeholders across a wide variety of teams including Finance Business partners, Product and Propositions and Data & Analytics • Built companywide One NZ Returns template, a necessary document which calculates KPIs for all project funding.

Auckland, New Zealand

• Responsibility for pricing Vodafone NZ’s Business mobile, fixed and ICT products.• Within Pricing Chapter, supported Business Experience agile squad in building competitive pricing constructs including as a Service and leasing propositions.• Led and drove projects propositions through to Leadership team approval for funding e.g., pricing One NZ’s Connected Business. • Client facing, reviewing franchisees' performances and setting their commissions and bonuses.• Effectively coached and mentored pricing analysts and new members of team to build a successful and high-profile team.

Auckland, New Zealand

• Undertook in depth financial analysis and built models in MS Excel to satisfy pricing requirements for new and existing products displaying metrics such as margin, net present value and payback period• Presented analytical output to Business leaders for pricing/ product approval, recommending commercially viable and competitive pricing solutions in business cases. • Demonstrated flexibility and adaptability in working on a diverse range of products, taking on product knowledge quickly to understand the proposal. High level of speed and accuracy required to meet deadlines. • Analytical work incorporated scenarios and sensitivities, risk and perceived customer responses. An example was building a complex model to a tight deadline following competitor price and data movements on mobile, which required live reporting to key stakeholders. • Lead Pricing support and analyst for rationalisation project of decommissioning older products and platforms. Provided financial and risk analysis for business case used to successfully bid for many $m of capital from Vodafone Group. Required liaising with technology division to gain understanding of feasibility and costs of new Telco products.

Auckland, New Zealand

• Modelled and developed 2016 standard prices for Vector’s electricity distribution networks in MS Excel to provide better commercial outcomes while satisfying regulation requirements. Provided written, quantitative analysis and graphical presentation of price changes for official pricing review and methodology disclosures that are published on Vector’s website.• Developed regulatory price compliance models to ensure new prices comply with the relevant regulations, which required full understanding of legislative documents from Commerce Commission. Ensured all information is transparent for auditors. Provide written and analytical contributions to Vector’s Annual Compliance Statement for 2015 pricing year. • Provided analytical input to other public information disclosures, ad-hoc work and monthly budget forecasts using MS Excel and Access and disseminating customer data extracted from Gentrack billing system and Business Objects software platform using MS Access.

London, United Kingdom

• Analysed county and international (Test, One Day International) cricket matches for summer 2014 for English Cricket Board (ECB) live at grounds, recording events using in-house developed software. Role incorporated being official ECB Official Data Scorer. Scores and events recorded went live to online and print media (including ESPN cricinfo) and other partners, requiring immediate and accurate recording of all events.• Role required liaising and forming good relationships with match officials such as teams' official scorers.

London, United Kingdom

• Built and developed sophisticated mathematical and statistical models in SPSS and MS Excel to report on school accountability, including evaluating school examination performance given pupils' prior ability (Value Added) and selecting groups of schools for cross-location learning and information sharing (Similar Schools). • Presented and explained projections and modelled results on various policy scenarios at meetings with senior educational policy colleagues, political special advisors and quasi-governmental bodies to advise MPs on British Educational policy. • Accurately and timely published official statistical reports for online public viewing, and responded to queries on these raised by the public. Drafted answers to Parliamentary Questions for MPs to reply to opposition and interested parties. • Included 5 month placement at University of New South Wales, Australia in 2011 as a Finance Research Analyst, designing and building a MS Excel model that used macros to forecast future scholarship award costs accruing to the university from post-graduate courses. Also acquired knowledge of university funding and UNSW Finance reporting tools to provide ad-hoc data analysis.

London, United Kingdom

• Investigated and cleared cash and stock reconciliation breaks for hedge funds, dealing with dividends, trades, FXs and majorly contracts for difference (CFDs) using SOPHIS.• Liaised with intermediary banks and presented CFD break reports to prime broker and settlements teams in order for successful resolutions.

London, United Kingdom

• Processed cash transactions (SWIFT payments) and FX deals for high-profile clients to settlement deadlines in a fast-moving environment using Hiport. • Investigated and cleared cash reconciliation breaks liaising with intermediary banks.

Akita, Japan

• Planned lessons and taught in junior high schools alongside a Japanese teacher. Exchange component involved talks and presentations on English culture in the community, plus presentations at JET conferences.

London, United Kingdom

• Built models deriving individuals’ bonuses, and analysed how wage and promotion trends affected the overall wage bill for the firm.

London, United Kingdom

• Aided development of automated trading system for a hedge fund researching the effect of corporate actions on stock returns using Bloomberg, Reuters and Datastream.

Master'S Degree, Economics, Pass With Distinction

2002: MSc Economics- Pass with Distinction (distinction achieved in both examinable and dissertation parts of course). Gained rigorous.

Bachelor'S Degree, Economics, First Class Honours

BSc Economics-First Class Honours. Core subjects were theoretical and applied microeconomics, macroeconomics and econometrics plus options.