Summary
Overview
Work History
Education
Skills
Websites
Timeline
a4
Trevor Seymour

Trevor Seymour

Reading,WBK

Summary

I have been a Data Analyst for a number of years, building dynamic reports, dashboards and data models across a variety of sectors. I have vast experience of using Power BI, Power Query, Power Pivot, Excel and SQL. I enjoy working with data of all types, and enjoy the challenge of cleansing, utilising, and presenting data to draw valuable insights. I revel in examining and presenting data, and drawing conclusions from it.

A portfolio of my projects and articles can be found by visiting https://sportsanddatainsights.co.uk/

Overview

27
27
years of professional experience

Work History

Business Analyst

Paradigm Housing
High Wycombe
05.2024 - Current

• Developing in-house Power BI reports across the business with a particular focus on Finance, helping the group track targets and KPI's
• Building SQL queries and creating relevant views in SSMS to extract data
• Delivered key business reporting using Paginated Power BI Report Builder
• Assisting with the migration of data to a new platform with Power BI report building and enhanced functionality
• Training colleagues on how to utilise Power BI for their individual needs

Data Analyst/Customer Program Manager

Microsoft
Reading
11.2022 - 05.2024
  • Intuitive data dashboard generation and maintenance using POWER BI
  • Data extraction and manipulation from Microsoft Azure and Cloud based systems
  • Extensive report generation and consolidation using EXCEL, POWER QUERY and POWER PIVOT
  • Working and connecting with various teams for ad-hoc data requests and solutions
  • Building and developing pricing and forecasting models

Data Analyst

The Superyacht Group
07.2018 - 10.2022
  • Extensively analysing, and visualising various datasets using EXCEL, POWER BI and TABLEAU for the Editorial team to produce industry leading articles
  • Working closely with clients producing bespoke consultancy reports with strategic recommendations and conclusions based on my data analysis and visualisations
  • Producing forecasts related to the Superyacht industry, including migration traffic and superyacht sales
  • Updating, maintaining and cleansing various in-house datasets
  • Conducting online surveys (TYPEFORM, SURVEY MONKEY) and telephone interviews to produce and supplement insight based on quantitative data and qualitative interview transcriptions
  • Producing various forecasts of the superyacht industry and wealth fluctuations based on datasets I personally manage and analyse
  • Visualising data for regular social media campaigns and online articles
  • Writing articles as part of our consultancy proposition, as well as online articles on the industry

Database Analyst

University of Surrey
05.2018 - Current
  • General database administration and analysis for the Faculty of Health and Medical Sciences

Data Analyst/Sports Trader

Sporting Index
04.2008 - 03.2018
  • Extensively analysing multiple sources of data to compile odds for all UK football, particularly English Premier League, Championship and England Internationals.
  • Routinely extract, compile and track data for high-level analysis
  • Working with the in-house modelling team to develop and improve our trading models in Excel and HTML
  • Trading football games for the leagues mentioned above, both for Sporting Index and its wholesale partners, managing liabilities and monitoring the market accordingly.
  • Updating, maintaining and cleansing football and cricket datasets for further analysis
  • Monitoring client betting patterns for hot business and react accordingly.
  • Working closely with junior members of the team to improve their Excel skills

Customer Services Executive

Vans International
01.2004 - 04.2008
  • Sales Support – worked closely with Sales Managers, as well as the National Key Account Manager, and UK Country Manager, updating them as to the status of orders, and helped to meet monthly and quarterly sales forecasts.
  • Customer Support – advising stores on latest trends and providing regular information about the latest products.
  • Order Book Management – ensured all allocated stores, including some Key Accounts received orders in a timely manner.

Key Account Manager

Net Searchers International Ltd (Register.com)
05.2001 - 05.2002
  • Upselling – sold new products and services to existing Key Accounts via telephone, e-mail, and presentations
  • Accounts include Abbey National, easyGroup and Formula One.
  • Order Fulfilment – liaised with the Fulfilment Team regarding the status of orders and tasks I have submitted, and ensured they were completed to a high standard.
  • Met Sales Targets – regularly hit my monthly and quarterly commission-based sales targets, as well as department sales targets.

Account Manager

NetNames Ltd
10.1997 - 04.2001
  • Upselling – sold new products and services to existing accounts via telephone, e-mail and face-to-face meetings
  • Accounts include Shell, DeBeers and Reuters.
  • Team Leader – ensured that my team were motivated, focused and fully aware of the tasks needed to hit our sales targets.
  • Receiving client queries by telephone and email, and updating the CRM as required

Administration Assistant

Lloyds of London
  • Auditing, data entry, general admin

Education

GNVQ Media, Communication and Production (Advanced) -

01.1997

A/S Level Law -

01.1997

8 GCSEs including Mathematics (Advanced Level) -

01.1995

Skills

  • Data Modeling
  • Data Validation
  • Advanced Excel
  • Report Generation
  • Big Data Analytics
  • Data Cleaning
  • Database Management
  • Statistical Analysis

Timeline

Business Analyst

Paradigm Housing
05.2024 - Current

Data Analyst/Customer Program Manager

Microsoft
11.2022 - 05.2024

Data Analyst

The Superyacht Group
07.2018 - 10.2022

Database Analyst

University of Surrey
05.2018 - Current

Data Analyst/Sports Trader

Sporting Index
04.2008 - 03.2018

Customer Services Executive

Vans International
01.2004 - 04.2008

Key Account Manager

Net Searchers International Ltd (Register.com)
05.2001 - 05.2002

Account Manager

NetNames Ltd
10.1997 - 04.2001

GNVQ Media, Communication and Production (Advanced) -

A/S Level Law -

8 GCSEs including Mathematics (Advanced Level) -

Administration Assistant

Lloyds of London
Trevor Seymour