Gavin Mcphee

Gavin Mcphee Email and Phone Number

Data engineer specialising in insurance based analytics @ Collingwood Business Solutions Limited
north shields, north tyneside, united kingdom
Gavin Mcphee's Location
Newcastle Upon Tyne, England, United Kingdom, United Kingdom
About Gavin Mcphee

Professional data engineer with experience of providing complete end to end business intelligence solutions from concept to final delivery including requirement gathering from stakeholders ensuring all aspects of the business needs are captured, analysed and prioritised, designing and implementing ETL process, dimensional data modeling to measure business processes and there effectiveness and report designing with easy to understand kpi's and measurements all complete within strict deadlines and budgets.

Gavin Mcphee's Current Company Details
Collingwood Business Solutions Limited

Collingwood Business Solutions Limited

View
Data engineer specialising in insurance based analytics
north shields, north tyneside, united kingdom
Employees:
26
Gavin Mcphee Work Experience Details
  • Collingwood Business Solutions Limited
    Senior Data Engineer
    Collingwood Business Solutions Limited Jan 2018 - Present
    North Shields, England, United Kingdom
    Running the day to day operation of a small engineering team who's responsibility is the design, implementation, maintenance and accuracy of an insurance based architecture producing data used for financial, underwriting, actuarial, reinsurance and solvency reporting
  • Collingwood Business Solutions Limited
    Data Engineer
    Collingwood Business Solutions Limited Apr 2015 - Jan 2018
    North Shields, England, United Kingdom
    Designed and implemented a data warehouse using Ralph Kimbell methodologies for operational KPI reporting from a number of in house built source system and third party applications including Mitel telephony system using MS SQL stack
  • Collingwood Business Solutions Limited
    Sql Server Business Intelligence Developer / Data Analyst
    Collingwood Business Solutions Limited Sep 2012 - Apr 2015
    North Shields, England, United Kingdom
    Providing business intelligence solutions using Microsoft SQL Server 2012 & 2014 BI stack for a IT service provider who specifically deal with a client base within the insurance industry.
  • Fox Head Europe Limited
    Business Intelligence Co-Ordinator
    Fox Head Europe Limited Aug 2010 - Sep 2012
    Newcastle Upon Tyne, United Kingdom
    Operating a European wide business intelligence development and production service for aninternational extreme sports apparel and performance gear company.The role involved the implementation and maintenance of a data structure built up of QVD file using incremental loads in the ETL process to capture the latest information available from multiple data sources including SAP Business One, MS SQL Server, Excel And Text Files.The development and maintenance of all reporting aspects of the companies needs by buildingstar/snowflake schemas or using dimensional modling in the development of dashboards with point in time reporting displaying KPI metrics, graphs and tabled data by composing mathematical formulas and using set analysis
  • National Grid
    Data Analyst
    National Grid Feb 2007 - Jul 2010
    Newcastle Upon Tyne, United Kingdom
    Operated a nation wide development and production service of management Information base on procurement and accounts payable data for all lines of business focusing on improving the end to end process efficiency by collecting and collating appropriate data from the individual data marts, presenting the required statistics in an easy to read dashboard report using relevant graphs and tables.
  • National Grid
    Mi & Technical Support Assistant
    National Grid Feb 2006 - Feb 2007
    Newcastle Upon Tyne, United Kingdom
    As part of a small team providing update management information relating to company creditor payment actives based on consolidated invoices.Managed the national supply chain management and shared services content management intranets site as well as Managing the Transactional Services website whilst developing and implementing improvements.
  • National Grid
    Web Application Developer
    National Grid Jan 2005 - Feb 2006
    Newcastle Upon Tyne, United Kingdom
    As part of a dynamic team of developers, the responsibilities under taken were the design, layout and coding of the Transactional Services Web Site, developing secure bespoke add-on application for each individual departmental section based on there specification using ASP classic, HTML, CSS and javascript
  • National Grid
    Crystal Reports Developer
    National Grid Mar 2004 - Feb 2005
    Newcastle Upon Tyne, United Kingdom
    As part of a Crystal ReportsTM team, operated report development & production service to strict deadlines based on business specification in relation to corporate expenses.
  • National Grid
    Administrative Assistant
    National Grid Aug 2002 - Mar 2004
    Newcastle Upon Tyne, United Kingdom
    Produce routine and ad-hoc management information relating to mobile & fuel card usage. Managed system accesses on behalf of creditor payments manager.
  • Defra
    Administrative Officer
    Defra May 2001 - Sep 2001
    Newcastle Upon Tyne, United Kingdom
    As a member of a small team in a rapidly changing environment, assisted with establishing office protocol and team’s processes, streamlined processes to facilitate a fast turn around of information to meet service level agreements.

Gavin Mcphee Education Details

  • Astley Community High School
    Astley Community High School

Frequently Asked Questions about Gavin Mcphee

What company does Gavin Mcphee work for?

Gavin Mcphee works for Collingwood Business Solutions Limited

What is Gavin Mcphee's role at the current company?

Gavin Mcphee's current role is Data engineer specialising in insurance based analytics.

What schools did Gavin Mcphee attend?

Gavin Mcphee attended Astley Community High School.

Who are Gavin Mcphee's colleagues?

Gavin Mcphee's colleagues are Becky Hall, Mark Waite, Tess Clarke, Robert Welland, Leeza T., Millie Mccallum, Scott Moorhead.

Not the Gavin Mcphee you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.