Gavin Mcphee Email and Phone Number
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.
Collingwood Business Solutions Limited
View- Website:
- collingwood.eu.com
- Employees:
- 26
-
Senior Data EngineerCollingwood Business Solutions Limited Jan 2018 - PresentNorth Shields, England, United KingdomRunning 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 -
Data EngineerCollingwood Business Solutions Limited Apr 2015 - Jan 2018North Shields, England, United KingdomDesigned 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 -
Sql Server Business Intelligence Developer / Data AnalystCollingwood Business Solutions Limited Sep 2012 - Apr 2015North Shields, England, United KingdomProviding 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.
-
Business Intelligence Co-OrdinatorFox Head Europe Limited Aug 2010 - Sep 2012Newcastle Upon Tyne, United KingdomOperating 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
-
Data AnalystNational Grid Feb 2007 - Jul 2010Newcastle Upon Tyne, United KingdomOperated 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. -
Mi & Technical Support AssistantNational Grid Feb 2006 - Feb 2007Newcastle Upon Tyne, United KingdomAs 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. -
Web Application DeveloperNational Grid Jan 2005 - Feb 2006Newcastle Upon Tyne, United KingdomAs 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 -
Crystal Reports DeveloperNational Grid Mar 2004 - Feb 2005Newcastle Upon Tyne, United KingdomAs part of a Crystal ReportsTM team, operated report development & production service to strict deadlines based on business specification in relation to corporate expenses. -
Administrative AssistantNational Grid Aug 2002 - Mar 2004Newcastle Upon Tyne, United KingdomProduce routine and ad-hoc management information relating to mobile & fuel card usage. Managed system accesses on behalf of creditor payments manager. -
Administrative OfficerDefra May 2001 - Sep 2001Newcastle Upon Tyne, United KingdomAs 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
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?
-
1aecom.com
-
-
-
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial