Aug 2018 – Jun 2022 · 3 yrs 10 mos · Brighton, United Kingdom

• I am responsible for client and agency data engineering strategy and implementation. This involves
• Working with key stakeholders to understand current processes, systems, issues and objectives
• Defining and agreeing appropriate solution roadmaps (using ERDs, dimensional modelling etc)
• Enabling near real time automatic data ingestion into Google BigQuery using Airbyte on Kubernetes (off the shelf and custom connectors) and Data Virtuality Pipes
• Using DBT for SQL code development, version control, deployment, test, documentation
• GCP tertiary services for SQL scheduling, permission management, audit, error management, billing etc
• Development of python docker based ML data apps for forecasting, segmentation etc.
• Data sources I am actively working with currently include:
• Web analytics - GA360, GA4, GAUA, Google Cloud Console, Google Ads, Search360
• Social - Twitter, Falcon.io
• CRM - Hubspot / Synergist / ZOHO
• Examples of recent successful projects include:
• Building a data warehouse for a client in the property sector across eight source systems to power live dashboards which help visualise performance across channels in an engaging insightful way.
• Migrating a complex manually intensive untrusted internal data warehouse for a blue chip health organisation, into an automated cloud solution - achieving a trusted source of truth, for advanced dash boarding and analysis
• Replacing multiple high cost stove pipe reporting solutions across a global finance company with a single highly efficient, scalable and flexible data warehouse.
• Implementing agency wide client performance data warehouse ingesting across over 600 pipes daily and transforming data into views which reduce error and time in client reporting

Jan 2018 – Sep 2021 · 3 yrs 8 mos · Worthing, West Sussex, United Kingdom

• Deliver competitive advantage by leveraging cloud data platforms to make sense of the "data tsunami" within a business.
• Consult on and deliver solutions around:
• Automated campaign and BI performance reporting
• Opportunity prediction
• Data integration
• Google analytics tracking
• Data analysis
• Spreadsheet modelling and automation

Jun 2017 – Jan 2018 · 7 mos · Brighton, United Kingdom

• Deliver business efficiency and new insight to clients through building automated data pipelines, designing self learning big data models and developing high value data visualisation solutions.
• Automated data pipelines
• Setting up Google Analytics tracking through Google Tag Manager.
• Writing docker based python scripts to run on google container engine to automatically pull campaign data from disparate campaign management system apis into Google Big Query.
• Self learning big data models
• Create complex SQL based views within Google Big Query to present flexible integrated data models across numerous source tables.
• Applied machine learning algorithms to develop model which successfully prioritises millions of Cvs against thousands for job applications for leading recruitment service provider.
• Data visualisation
• Develop custom high value omni channel client dashboards based around Power BI (extensive use of M language and DAX) and Google Data Studio.

May 2014 – Mar 2017 · 2 yrs 10 mos

• Sourcing, development and provision of new "big data" tools and processes to ensure the business continues to increase delivered value across client base.
• Leveraging Google Big Query to analyse all time client campaign data to identify opportunities for client growth.
• Automated near realtime integration of granular project performance data (mavenlink) with forecast client performance (salesforce) and realised financial performance (sage) to provide business with an ongoing holistic view of historic and financial operating profit at client / team / individual level, with which to improve ongoing efficiency/productivity across business. Central to this solution was Google Big Query.
• Development of PPC/RTB campaign management and reporting tools based on excel / google sheets integrated seamlessly with core campaign management platforms (Adwords/YBN/Doubleclick) to aide productivity and efficacy of campaign managers value.

May 2012 – Apr 2014 · 1 yr 11 mos

• Responsible for the strategy and efficient day to day management of assigned US based major client accounts, focusing on gross profit growth.
• Exploring opportunities and facilitating campaigns through all available marketing channels (e.g. paid search, SEO, display, email and social media) with particular emphasis on innovative initiatives.

May 2011 – Apr 2012 · 11 mos · Southampton, United Kingdom

• As Senior Media Manager within the agency Lawton Communications Group based in Southampton, I have been responsible for the successful, set up, management and growth of large performance oriented, paid search and online display accounts primarily within the travel and finance sectors. This role spanned the following activities:
• Detailed analysis and understanding of client digital landscape and development of successful digital strategies
• Integration of paid search and display with social, SEO and affiliate channels
• Development of annual and monthly media plans
• Pitching winning digital strategies to new businesses
• Campaign set ups (including adserving and tracking using Mediaplex, Atlas, TradeDoubler and DC Storm)
• Campaign measurement and optimisation
• Development of pragmatic optimisation methodology
• Use of advanced datamining tools, for complex multi-variate analysis and prediction of campaign performance and opportunities
• Identification of tactical growth opportunities
• Digital attribution analysis and modelling
• Analysis and assessment of current adserving and tracking platforms.
• Booking media
• Weekly and monthly reporting
• Weekly client calls
• Monthly review meetings with clients
• Quarterly agency meetings
• Invoicing
• Key client activity includes: Red Funnel, Vanquis, Liverpool Victoria, Gap, Denplan, Coopervision

Jul 2007 – May 2011 · 3 yrs 10 mos

• As of 4 April 2011 I was only 1 of 21 people in the UK who were Google Individually Qualified for each of Google Search, Reporting & Analysis, Display and also Analytics (refer to http://google.starttest.com/).
• With over twenty years senior marketing experience in the online services, software and telecomunications industries, I help businesses get the web to deliver the business results they want. I provide business oriented, online marketing expertise and services primarily to businesses on the UK south coast that do not generally have access to the internet marketing skills needed to make a real difference online.
• Online marketing consultancy
• E-business reviews – market, competitor, traffic, conversion & administration issues
• Client workshops
• Development and implementation of E-business plans
• Typical delivered ROI in excess of 500%

Jun 2004 – Jun 2007 · 3 yrs

• Developed and managed the InfoSpace European marketing plan for web search products and successfully coordinated and tracked £2m annual marketing spend to deliver annual revenue growth in excess of 200%.
• Successfully identified, recruited and managed supporting agencies as part of integrated plan
• Built and implemented effective branding strategy
• Managed and optimized high volume paid search and online display advertising campaigns
• Successfully conceived unique online loyalty programme
• Relaunched consumer search product
• Conceived planned and coordinated “quarterly media dinners” to entertain + network key b2b prospects
• Successfully developed and managed pan European event calendar participation spanning sponsorship, stands, and seminars.
• Coordinated the successful development of full set of sales collateral including website and related training.

Jan 2002 – Jan 2004 · 2 yrs

• Controlled a marketing budget of over £100k to successfully manage the market research, strategic planning, product positioning, sales collateral, PR, direct marketing and education of sales channels.
• Redefined product strategy to increase margins on sales by 20%.
• Implemented lead generation programme, which identified over 100 new prospects.
• Coordinated the profiling of all major competitors.
• Initiated and managed a major re-branding project to clarify positioning with market.
• Coordinated successful market research initiative, to drive major product development programme for next generation service delivery product.

Jan 1998 – Jan 2002 · 4 yrs

• Established and managed the product marketing processes with two direct reports to expand accessible market by over 300% and deliver 30% more value from existing customers.
• Drove the division’s overall business strategy for two consecutive years.
• Worked from Kuala Lumpur office for three months creating and implementing market strategy for AsiaPac region, which resulted in a 30% increase in installed base in region.
• Maintained and evolved market and competitor analyses on intranet.
• Developed and implemented market entry strategies for mobile service quality management solutions, which achieved 20% penetration over eighteen months.

Jan 1995 – Jan 1998 · 3 yrs

• Managed a budget of £1.5m with full P&L responsibility. Managed the full marketing mix, from concept through to product withdrawal for intelligent network products.
• Identified trend for more open, scalable and “out of the box” solutions. This led to new product initiatives which expanded customer base by 40%.
• Managed the withdrawal of the in-house management platform and replacement with an “open standards” Siemens platform.
• Developed economic model for predicting margins by product market. This was then adopted as a core tool in the development of business cases across the business.

Jan 1993 – Jan 1995 · 2 yrs

• On-site strategic marketing support to Virgin (then Nynex) and Torch Communications.
• Created and communicated NTL marketing strategy for Centrex services which then achieved 15% penetration within first 12 months.
• Instrumental in TORCH achieving target time to market for their VPN services.

Jan 1988 – Jan 1991 · 3 yrs

• • Successfully project managed major programmes with budgets in excess of £1m.