Andy McLennan

Andy mclennan

bookmark on deepenrich
location of Andy McLennanGlasgow, Scotland, United Kingdom
Followers of Andy McLennan1000 followers
  • Timeline

  • About me

    Project Manager - Corporate Data Services (CDS)

  • Education

    • Glasgow caledonian university

      1996 - 2000
      Ba(hons) business economics 2:1

      Degree Class:- Second Class Upper Division (2:I)Completed 3rd year of degree course in Winnipeg, Canada.

  • Experience

    • Scottishpower

      Sept 2000 - Oct 2006

      - Supporting the Sales & Marketing Director and first line reports with all aspects of operational planning, forecasting, performance reporting and analysis.- Delivering accurate and timely information on key metrics (e.g. sales, registrations, losses and customer numbers) in budgets, forecasts and weekly reports in line or above stakeholders’ expectations.- Effectively monitoring and reviewing metrics and ensure that all reporting meets customer requirements.- Leadership, organisational and people management skills in overseeing team of three. Motivating and guiding them in a bid to attain the best possible results and outputs from the team.Key achievements:- Delivery of vital metrics to Sales & Marketing Director which was pivotal in the support of his decision-making as well as bringing awareness of marked shifts and significant trends in energy utility market. - Critical role in Forecast, Budget and longer term Business Planning process through the provision of detailed projections and scenario analyses of extensive variables. Show less I moved to the Retail side of the business in order to enhance my knowledge of the vertically integrated business and to understand the complexities of pricing products in the marketplace. During a period of increasing utility prices, the importance of accurately managing price changes with a value in excess of GBP 500m was paramount. Principal responsibility was for the maintenance of all pricing information and comparisons, market positioning analysis and pricing models for the domestic electricity and gas markets. Show less

      • Sales & Performance Manager

        Sept 2005 - Oct 2006
      • Senior Pricing Analyst

        Sept 2004 - Sept 2005
      • Business Analyst

        Sept 2000 - Sept 2004
    • Viacom

      Feb 2007 - Jan 2008
      Senior analyst, digital pricing, inventory & delivery – digital ad operations

      - Optimally monetise MTV Networks online media and exceed MTV Networks goals for digital gross profit by the accurate forecasting of inventory availability and marketplace demand.- Establish pricing of ad products and sponsorship packages through close liaison with sales teams to both grow existing client relationships and develop new ones.- Work closely with website teams on budget, forecasting and revenue/pipeline monitoring in addition to fostering strategies to increase or decrease inventory availability.- Identify opportunities and implement solutions that augment the effectiveness/efficiency of the department.Key achievements:- Displayed aptitude to diversify skillset from UK utility field to a rapidly emerging area of the media industry- Quickly gained firm understanding of the intricacies and complexities of digital ad operations- Created more effective, more detailed projection models in order to assist forecasting and the reporting of inventory across the Music and Youth sites e.g. the creation of a sell through report for all MTVN- Assisted department Vice President in the implementation of sales rate cards across the Music and Youth sites. Show less

    • Time inc.

      Feb 2008 - Apr 2013

      - Leading business development and project management over various facets of digital media (sponsored links, programmatic selling, video ad serving, data management, mobile, tablet) across Time Inc. digital brands.- Strategically piloting Time Inc. in the programmatic arena and continuing the development of the company’s approach through testing, learning and knowledge building. - Communicating findings to senior and executive management teams and defining further paths to success.- Undertaking detailed evaluation of vendors and extensive scenario analysis to determine the right partner(s) in the respective field.- Enhanced awareness of legal and information security perspectives when brokering deals. Management and coordination of these perspectives during negotiations with prospective clients.Key achievements: - Successful management of annual net revenues of $11m across two major projects.- Navigated Time Inc. through programmatic selling whilst acknowledging brand and corporate requirements. - Concisely presented analysis, conclusions and vendor selection for $6m per year project to company’s CEO.- Brokered Time Inc.’s first significant programmatic deal with global food processing giant, Kellogg’s.- Thrived in the oftentimes tough, demanding working environment that exists in New York. Show less - Promoting the Inventory Analytics function across the company and highlighting the value of IA across Time Inc. e.g. Ad Operations, Finance, Sales Development, Sales, Audience Development etc.- Conceptualising, building and providing suitable models detailing key performance metrics and forecasts to assist Sales Development and better inform Sales decisions to positively impact Time Inc. Digital profit.- Management of the remnant network portfolio that attains significant revenue across the Time Inc. properties.- Development and maintenance of audience targeting relationships with external vendors.Key achievements:- Enhance digital knowledge with another media giant and played a major part in the inception of a new team- Developed insightful forecasting models that are updated weekly and distributed across the Time Inc. properties.- Successfully managed remnant portfolio of 15 remnant networks before consolidating to an ad optimisation platform garnering enhanced revenues and huge efficiencies and time savings across ad operations and finance.- Effective on boarding, management and internal promotion of audience targeting relationships to brands. Show less

      • Director of Programmatic Solutions & Yield (DIGITAL)

        Feb 2012 - Apr 2013
      • Manager/Senior Manager, Inventory Analytics, Digital Ad Operations

        Feb 2008 - Jan 2012
    • .

      Jun 2013 - Jun 2014
      Dad

      This role was the most difficult, but by far the most rewarding job of my career. Extremely grateful for the time I got to spend with my daughter, but now need to take the next step in my career and revert back to part time Dad. The job seeker part was not as pleasurable, but I learned a lot and made some really solid connections along the way.

    • Stv group plc

      Jun 2014 - Jun 2022
      Product manager (data)

      - Leading a team comprising Data Scientist, Data Engineer and Data Analysts to ingest requisite data in an efficient manner to enable high quality and timely reporting against business requirements.- Ensuring that data capture across the suite of digital platforms meet the business needs with the ultimate objective of gaining customer insights and implementing solutions as a direct result.- Development and ongoing management of a powerful data lake to provide a single customer view.- Interface between Product Development and business stakeholders (Marketing, Commercial, Operations) to deliver robust outputs. - Interrogating data to inform quality improvements, content initiatives, marketing strategies etc.- Collaboration with Digital UX/Design to inform the best next actions in the product life cycle.Key achievements: - Adoption and understanding of the Agile methodology of Product Development.- Successfully project managed the overhaul of legacy data architecture to transition to a cloud based data lake. - Integration of a data visualisation tool to bring the data to life and better inform business initiatives.- Significant improvement of customer registration across STV digital products meeting the core objectives (i) improved UX (ii) improving customer insights (iii) legal/compliance adherence. - Delivery of enhanced ad targeting revenues and promotion of extrapolating value from data. Show less

    • Barclays

      Jul 2022 - now
      Project manager
  • Licenses & Certifications