AeroLeads people directory · profile
John Cann Email & Phone Number
Data Specialist
at
Verisk – insurance solutions
1 work email found
@thenbs.com
LinkedIn matched
✓ Verified August 2026
4 data sources
Profile completeness 100%
Current company
Role
Data Specialist
Location
Newcastle Upon Tyne, England, United Kingdom
Who is John Cann? Overview
A concise factual answer block for searchers comparing this professional profile.
Quick answer
John Cann is listed as Data Specialist at Verisk – insurance solutions, based in Newcastle Upon Tyne, England, United Kingdom. AeroLeads shows a work email signal at thenbs.com and a matched LinkedIn profile for John Cann.
John Cann previously worked as Senior CRM Specialist at NBS at Nbs and Senior Database Developer at Nbs. John Cann holds Ma, Materials Science from University Of Cambridge.
Company email context
Email format at Verisk – insurance solutions
This section adds company-level context without repeating John Cann's masked contact details.
{first}.{last}@thenbs.com
86% confidence
AeroLeads found 1 current-domain work email signal for John Cann. Compare company email patterns before reaching out.
Profile bio
About John Cann
• A Database Developer/Database Administrator with 20 years’ experience in SQL Server database design and development. This includes being administrator and a member of the software development team for an online software product using a SQL Server back end; also the design and development and administration of an in house hosted CRM system.• Highly experienced in using Microsoft SSIS to design ETL processes for loading and transforming data from other sources into SQL Server and from SQL Server out to other destinations. • Highly experienced in optimisation of SQL Server queries and stored procedures by efficient query design, use of indexes and use of temporary tables/table variables in procedures• Highly experienced in reporting on SQL Server data, mainly using SQL Server queries delivered with Microsoft Excel. Also experience in SSRS, Crystal Reports, ThoughtSpot, SAP BusinessObjects. • Experience in working closely with end users of CRM systems and Reporting to determine their needs and to deliver appropriate solutions• Experienced in SQL Server replication• Microsoft® Certified IT Professional: Database Developer on SQL Server 2005, passed in April 2011• AWS Certified Cloud Practitioner, passed in April 2022.• Salesforce Certified Administrator, July 2020, Salesforce Certified Platform Developer I, August 2020 (No longer current)
Listed skills include Database Design, Microsoft Sql Server, Vb.Net, and Asp.Net.
Current workplace
John Cann's current company
Company context helps verify the profile and gives searchers a useful next step.
5 roles
John Cann work experience
A career timeline built from the work history available for this profile.
Data Specialist
• Database Developer working as part of a Software Development team on two major Anti-Fraud products for Verisk in the UK, Fraudstar Intel and Fraudstar Analytics. These products have complicated data import/export requirements including mapping data structures from other systems into Verisk systems. Import/export is achieved using SSIS packages and SQL server queries/stored procedures. In addition Fraudstar Analytics implements rules which find potential Fraud by applying the rules against externally provided data sets and the internal data.• The Data Specialist is responsible for maintaining existing SSIS packages and the SQL Server jobs that run them; also developing new SSIS packages for new sets of data. Also administrating the SQL Server instance.• Responsible for maintaining existing rules and developing new rules.• The Data Specialist also works on new and existing SQL Server stored procedures and functions which are part of the Fraudstar code base, much of the functionality of the software being implemented as SQL Server stored procedures.• Analysis of the contents of new and existing data sets; analysis of how these map to Fraudstar data structures.• Analysis of rules for detecting Fraud – finding matches within Fraudstar data and between Fraudstar data and external data sets.• Reporting – reporting on data in the Fraudstar products using SSRS and also Excel.
Senior Crm Specialist At Nbs
Administration and development of the NBS CRM System (Pivotal CRM running on SQL Server).Work on the new project to replace Pivotal CRM with Salesforce, mapping Pivotal data structures to Salesforce and developing SSIS packages to move Pivotal data to Salesforce, ongoing synchronisation of the data that remained in Pivotal with Salesforce.Work to set up advanced reporting on NetSuite data via the NetSuite ODBC connector, SQL Server and Excel.Wrote an integration program that copied new accounts from Pivotal into NetSuite using the NetSuite API and C# in Visual Studio.Developed a process to store Salesforce data in SQL Server for backup and advanced reporting ability.Completed online courses on the administration and development of Salesforce.
Nov 2017 - Jul 2020
Senior Database Developer
Administration and Development of Pivotal CRM on SQL ServerIntensive use of SSIS to perform ETL operations. Use of Visual Studio to write the SSIS packages and deployment to SQL Server to be scheduled as jobs. ETL operations included archiving of data from Pivotal for reporting on trends, import of remote data from partners via FTP into SQL Server for use in our CIS product and export of data to other partners.Developed reporting for end users of Pivotal and directors of the company, using Crystal Reports and using MS SQL Server queries, delivered by Excel.CIS Access database was moved to a SQL Server backend with an Access front endSolved performance issues with SQL Server.Developed SQL Server functionality using queries, views, functions and stored proceduresAchieved Microsoft® Certified IT Professional: Database Developer on SQL Server 2005Worked with an external partner to integrate data from Pivotal into Sage Line 500 using a basic .csv export import method.Developed the “Publication Index” website based on a SQL Server back end and a C# ASP.Net front end. This project also featured SQL Server Replication which I became experienced in.
Jul 2005 - Nov 2017
Information Specialist
Jul 1994 - Jun 2005
1 education record
John Cann education
FAQ
Frequently asked questions about John Cann
Quick answers generated from the profile data available on this page.
What company does John Cann work for?
John Cann works for Verisk – insurance solutions.
What is John Cann's role at Verisk – insurance solutions?
John Cann is listed as Data Specialist at Verisk – insurance solutions.
What is John Cann's email address?
AeroLeads has found 1 work email signal at @thenbs.com for John Cann at Verisk – insurance solutions.
Where is John Cann based?
John Cann is based in Newcastle Upon Tyne, England, United Kingdom while working with Verisk – insurance solutions.
What companies has John Cann worked for?
John Cann has worked for Verisk – Insurance Solutions and Nbs.
How can I contact John Cann?
You can use AeroLeads to view verified contact signals for John Cann at Verisk – insurance solutions, including work email, phone, and LinkedIn data when available.
What schools did John Cann attend?
John Cann holds Ma, Materials Science from University Of Cambridge.
What skills is John Cann known for?
John Cann is listed with skills including Database Design, Microsoft Sql Server, Vb.Net, and Asp.Net.
Find 750M verified contacts
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trialPeople with similar names
Check these profiles if this is not the John Cann you were looking for.
View similar profiles
