Gavin Mcphee Email & Phone Number

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

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

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.

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

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.

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.

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

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.

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.

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.