Ross Johnstone Email & Phone Number

Cambridge, Gb

London, England, Gb

Led extensive intelligence and data provision across the world’s #1 premium medical logistics company, covering day-to-day tactical decisions and long-term strategy for executive team, operations, finance, sales & marketing, and global functions. · Directly managed a team of eight and supervised three support roles. Oversaw and guided BI work for a broader analyst pool. Steered senior stakeholders’ data-driven decision making, prioritising competing data and analytic needs to provide reporting, analysis, and strategic insight, over multiple projects, within timeline and capacity constraints.· Primary contact between business and wider data teams (Engineering, MDM, PMO, IT, etc.). Directed data engineering daily to effectively achieve output availability and standards, ensure BI needs are facilitated, resolve issues, and manage cross functional change. · With enterprise IT, drove the wider tech strategy at World Courier to transform enterprise capabilities. Led projects to upgrade BI/ visualisation and workflow management tools. Product manager for online self-service reporting suite and dashboarding softwares. Coordinated cross company data warehousing, optimised ETL processes.· Subject matter expert on large scale capital projects across the business. Defined requirements to external vendors and recommended improvements on data collection and provision, process design and risk.· Supervised a wide range of quantitative activities and BI tasks, contributing excellent analytical, problem solving, conceptual, and interpretive skills. Tableau, Power BI, Qlik Sense; database management & onboarding, SQL, Alteryx; Excel and VBA, SAP, BOBJ; Confluence.

Windsor, Berkshire, Gb

· Spearheaded mass mobile phone user location analyses as a novel approach to site prioritisation and network planning. Secured funding, sourced and contracted with external data partners.· Led annual target-setting process for 1000+ hotels, forming the basis of all regional reporting and evaluation.· Sentiment/ text analysis of internal and public guest reviews. Competitor bench-marking, gap analysis.· Geo-spatial demand modelling of new openings and revenue cannibalisation.· Holistic brand performance assessments, trading reviews. Provide clear and responsive insight in leadership team meetings for global heads and country MDs. · Evaluated effectiveness and cost-benefit analysis of loyalty initiatives and pilot schemes. · Revamped workforce optimisation reporting process and outputs, integrating role-level hotel action plans into HR analytics for the first time.

Windsor, Berkshire, Gb

· Fronted new function at Head Office, working daily with team in Americas. Business partner for Finance, Group functions, and EMEAA region to deliver competitor intelligence, forecasting, and benchmarking.· Led project to prepare large sections of annual Board strategy review. Iterative development with CEO and Chief of Staff.· Profiled competitors in depth, investigated regulatory changes, compiled economic indicators and forecasts, and represented IHG at external events.

Windsor, Berkshire, Gb

Wide-ranging analytical role that I shaped into subsequent position.· Proposed, designed, and implemented new group commercial market share measures and executive metrics. Enabled reporting and strategic assessment of market positions. Awarded “Global Star” prize by CFO.· Group planning cycle and budget process, supported corporate strategy and transformation programme. Incentive and RemCo analysis, drafted board papers.· Business modelling and scenario analysis. Go-to resource for broader modelling, data manipulation, and visualisation.

London , Gb

Newly created internal consultant role in dedicated team developing strategy and providing decision support for Finance MD: · Led team of 6 to identify and evaluate all available revenue driving and cost saving opportunities across core services with aim to deliver ~£1BN net benefit over 5 years. Reporting directly to Commissioner and other MDs.· Coordinated financial analyses in response to Mayoral/ GLA policy development on air quality issues and road user charging. Strategic input on multiple working groups.· Steered TfL-wide preparation for governmental Comprehensive Spending Review 2015 through core working group, analysing £3.5bn annual expenditure for CFO across Transport services, Commercial income, Pricing, Assets, Regulation, etc.· Finance SME for Commercial function in contract development, tendering and supplier negotiations, and business case development for >£100M of asset and services procurement.· Performed business-wide complex modelling function. Identification and interrogation of operational cost drivers.

New York, Ny, Us

Extensive experience gained in devising and delivering strategic plans, operational improvements and commercial insights to globally recognised companies on multiple board-level assignments. · Promoted into a supervising role accountable for consultants and varied client teams· Multiple industry and internal assignments including utilities, health, consumer services, travel, telecoms, commodity trading, and knowledge management.