John Chilton
Database Architect at Barbour- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
French Elementary proficiency
-
German Elementary proficiency
-
Spanish Elementary proficiency
-
Geordie Native or bilingual proficiency
Topline Score
Bio
Experience
-
Barbour
-
United Kingdom
-
Retail Apparel and Fashion
-
400 - 500 Employee
-
Database Architect
-
Jun 2020 - Present
-
-
-
Durham Constabulary
-
Durham, England, United Kingdom
-
Senior Developer
-
Jun 2019 - Jul 2020
Senior Developer working on Systems Integration, Interfaces, Data Warehousing, Reporting and data extracts for the Police Force in County Durham. XML interfaces, Excel and CSV imports and exports, Lynx ETL software, SQL Server 2012/2016 databases and T-SQL scripting. Recent experience and training on the Microsoft Power Platform and work on a Data Warehouse utilising SQL Server 2016 DB and MS Power BI. Maintaining and developing multiple Interfaces to Organisations and Systems such as Home Office Data Hub, Police National Database (PND) and NFLMS (National Firearms Licensing System). Working primarily with MS SQL Server Integration Services and SQL Server 2012/2016 and ensuring timely and accurate data is delivered securely to customers externally and internally.
-
-
-
Funk! Kombucha
-
United Kingdom
-
Food and Beverage Services
-
Chief Funkster
-
Feb 2018 - Jun 2020
KOMBUCHA is a fermented, sparkling tea. Brewed in Sunderland, in the North East of England, we make small batch Kombucha which is grafted, crafted, fermented, ethical and sustainable. It's also Vegan and just a little bit fünky! KOMBUCHA is a fermented, sparkling tea. Brewed in Sunderland, in the North East of England, we make small batch Kombucha which is grafted, crafted, fermented, ethical and sustainable. It's also Vegan and just a little bit fünky!
-
-
-
Hop It Brewing Co.
-
North East England
-
Founder
-
Oct 2018 - Sep 2019
Dedicated to quality, sustainability and craft. Dedicated to quality, sustainability and craft.
-
-
-
Greggs
-
Food & Beverages
-
700 & Above Employee
-
Business Analyst
-
Apr 2018 - Sep 2018
-
-
-
-
Director
-
Apr 2017 - Aug 2018
Naturally Gluten-Free Beer. Brewed from naturally GF grains - malted rice, malted millet and quinoa. ALT BREW No. 1 - Bavarian Style Pilsner ALT BREW No. 2 - English Pale Ale ALT BREW No. 3 - Dark Roast Stout Keg Only Ltd. Edition Alt Brew 49er - California Common Beer and Cider Marketing Awards 2017 - Highly Commended in 'Best Targeting of Alternative Markets' 2017 FreeFromFood Silver Award for ALT BREW No.1 2018 FreeFromFood GOLD award for ALT BREW No.3 Dark Roast Stout 2018 FreeFromFood Silver award for ALT BREW No.2 English Pale Ale Insider Media's 2017 'Made in the North East' award - Shortlisted in Food and Drink Category
-
-
-
Formica Group Europe
-
United Kingdom
-
Wholesale Building Materials
-
200 - 300 Employee
-
Solution Delivery Analyst
-
Apr 2013 - Mar 2017
From April 2013 I was employed as Solutions Delivery Analyst with Formica Group, a division of Fletcher Building (NZ), the world’s largest manufacturer of high pressure laminate and decorative surfaces. I worked in a small development Team and was responsible for the support and development of the ERP System and applications across Europe and North America, primarily in relation to Warehousing and Distribution. I travelled extensively and supported the implementation of ERP systems and process improvements across manufacturing sites and warehouses in Valencia, Valmont (France), Perstorp (Sweden) and Kolho (Finland) as well as facilities in North America (Cincinnati and Indianapolis). I also travelled to Ahmedabad (India) in August 2013 to support a BPCS ERP implementation at Formica Group India’s manufacturing site and warehouse. I was part of the team that successfully implemented Infor's ERP system across North America (USA, Canada and Mexico) throughout 2013-2014 and these systems were then rolled out across European sites in January 2016. In addition to supporting Infor LX and Infor SCE (Supply Chain Execution) and other integrated systems on the IBM iSeries I developed solutions on the Document Management Enterprise Solution – Intellichief. I was the global Formica Systems team expert in the Warehouse Management System Infor SCE as well Loftware Enterprise labelling solution.
-
-
-
County Durham and Darlington Fire and Rescue Service
-
United Kingdom
-
Public Safety
-
100 - 200 Employee
-
Information Delivery Manager
-
Oct 2011 - Apr 2013
As Information Delivery Manager with CDDFRS I was responsible for a team of 3 working within the ICT Section. The Information Delivery Team developed and maintained Microsoft Sharepoint 2010, the Fire Service’s Intranet and document management solution. The Service website was also developed by the Team utilising the Open Source content management platform Drupal 6; also providing support, development of multi-media solutions and facilitation of Incident Command Training exercises to assist the Fire Service Training section. We were also responsible for delivery of Mapping and Risk information to Mobile Data Terminals on Fire Appliances and Stations and developed procedures and processes for monitoring this function. I also conducted the planning and implementation of software upgrades to a number of systems in the Service such as Actuate’s BIRT Performance Scorecard software and Civica’s CFRMIS (Community Fire Risk Management Information System). I developed Standards and Best practice documentation in relation to the development of Data Mart’s within the Fire Service utilising SQL Server 2008R2 and Transact-SQL stored procedures. I developed and tested ETL (Extract Transform and Load) processes and advanced reporting for the Service via SQL Reporting Services.
-
-
-
Style Group Brands
-
United Kingdom
-
Retail
-
100 - 200 Employee
-
Senior Business Systems Analyst
-
Mar 2007 - Sep 2011
I was employed as Senior Business Systems Analyst at Jacques Vert PLC, a major multi-branded fashion retailer, with specific responsibility for Retail and eCommerce Systems development and support. Required to perform a variety of functions - business analysis and systems design through to application and integration development, testing, documentation and systems support. I was primarily responsible for the purchase and implementation of Seeburgers’s B2B platform in 2008 for all systems integration projects within JV. I developed integration interfaces and processes with a new web platform (Salmon SAFE7 in 2010) as well as external Partners such as Debennhams.com/JLP/HOF and other host Stores and external Suppliers. I designed and developed mappings and interfaces utilising XML, CSV, traditional EDI and various bespoke formats as well as developing T-SQL storeprocedures, processes and SQL Agent jobs for integration to JV’s core ERP and other back-end systems. I facilitated requirements gathering workshops and documented 'As Is/To Be' processes and Gap Analysis in MS Visio.
-
-
-
-
Business Systems Analyst
-
Aug 2002 - Mar 2007
I was responsible for the Business Intelligence platform and Warehouse barcode scanning systems for DCC , a £22M turnover Company with approx. 180 employees. I wrote and maintained T-SQL scripts relating to the ETL (extract/transform/load) process and administered and performance tuned SQL Server 2000/2005 databases. I also specified, designed and maintained end user reports and Key Performance Indicators using Microstrategy Business Intelligence. Intermec hand held devices were implemented along with middleware and Agility Systems Merlin product which ‘maps’ data into the Oracle JD Edwards World ERP system on the IBM iSeries (AS400). The project was implemented successfully (Picking, Packing, Goods Receipt, Stock Transfer and Cycle Counting) on time and to budget and brought process improvements to the Warehouse and Goods-In areas as well as cost savings in a number of areas and in particular the removal of the necessity for bi-annual stocktake. I joined DCC initially to implement a Business Intelligence solution for a major client. The solution incorporated a web-based customer front-end, ETL scripts (to interface with DCC’s Oracle JD Edwards ERP system), SQL Server 2000 Database and Microstrategy Business Intelligence software. I was trained in Microstrategy’s Business Intelligence software, SQL Server 2000 administration and Transactional SQL and after design, programming and testing, the software was rolled out to the initial Customer within 6 months. I was also part of the project team that successfully implemented TXT Demand Management software.
-
-
-
Agility Systems
-
Software Development
-
1 - 100 Employee
-
Technical Consultant
-
Aug 2000 - Jul 2002
My position with Agility, a software house specialising in data capture and ERP systems integration, required strong project management skills with responsibility for concurrent small to medium sized projects with budgets ranging from £10k to £500k and timescales of a few weeks to several months. A typical project involved managing the purchase of hardware, installation and user training as well as the development of software, from initial requirements analysis and specification through to development, testing and implementation. As well as managing complex technical projects I was required to conduct Customer training in the Company’s core products as well as performing requirements analysis and system design, technical and functional specification, documentation and development in RPG/400 and CLP on the IBM iSeries (AS400).
-
-
-
Paragon UK
-
Sunderland
-
Information Services Team Leader
-
Sep 1994 - Aug 2000
I was employed as IS Team Leader at Paragon UK, a £20M turnover pan-European business forms manufacturer and form solutions provider, with responsibility for all computer hardware, software and telephone systems and also Disaster Recovery. I had budgetary responsibility for I.S as well as responsibility for purchasing equipment and Services and relationships with third party suppliers. I managed a team of five covering IBM iSeries (AS400) support and development, Network and PC support, a Help desk function and Oracle JD Edwards implementation and development. I scoped, budgeted and project managed the replacement of network servers with a fault tolerant solution which utilised new hardware from Dell & Cisco and software (Vinca Co-Standby Server) which mirrored data between two servers. Citrix Metaframe and Microsoft’s NT Terminal Server were implemented as a solution for an ageing and non-Y2K compliant population of PCs which were running Windows 3.11 and older versions of MS Office. Oracle JD Edwards World Financial and Raw Materials/Purchasing modules were implemented in 1999 and I was Project Manager for the UK team with responsibility for project planning, user training, documentation, implementation and upgrades.
-
-
-
Newcastle Building Society
-
Financial Services
-
500 - 600 Employee
-
Senior Analyst Programmer
-
Oct 1990 - Aug 1994
-
-
Education
-
Brewlab Ltd.
Practical Certificate in Brewing, Brewing -
University of Sunderland
Master of Science (MSc), Computer Based Information Systems -
University of Brighton
BA (Hons.) Combined Studies - Geography, Physical/Human Geography -
Boldon Comprehensive
-
Seaham Northlea Comprehensive
-
Brewlab Ltd.
Certificate in Practical Brewing, Brewing -
Brewlab, Sunderland
Certificate in Practical Brewing, Brewing