Andrew Carpin

Experience

• 

  Seychelles Fishing Authority

  Oct 1984 - Oct 1990

  System Administrator

  Provided IT solution and technical support.

• 

  Healey & Baker Charter Surveyors

  Apr 1991 - Apr 1993

  Database Administrator

  - Supported and updated a property database. - Developed series of reporting system for business intelligence purposes.- Provided business intelligence to the surveyors to canvass for business.

• 

  Lambert Smith Hampton

  Apr 1993 - May 1995

  IT Manager

  Maintained and supported the company's IT system nationwide.

• 

  Seychelles Fishing Authority

  Jun 1995 - Jun 2000

  IT Manager

  - Managed the IT team and budget.- Responsible for developing database applications for monitoring the fishing industry.- Attend scientific fisheries meetings/conferences locally and overseas. (MRAG https://mrag.co.uk/team)- Work with local stakeholders to collect & process macro-economic data from the fishing industry.

• 

  FEBA Radio (Seychelles)

  Jun 2000 - Feb 2003

  IT Manager

  - Managed IT team and budget.- Provide 1st line IT support for the organisation.- Responsible for procuring and purchasing IT equipment.- Responsible for repairing and refurbishing IT equipment.

• 

  Mayfair Trust Group Limited

  Mar 2003 - now

  • Application Development Consultant

    Mar 2003 - now

  • IT Manager

    Mar 2003 - Jul 2004
• 

  East Sussex County Council

  Mar 2006 - Aug 2011

  Data/GIS Management Technician

  - Managing and editing spatial data for an Oracle base Highway Asset Management database. - Developed business intelligence reports using Oracle Discoverer 10.2g and Oracle SQL Developer.

• 

  Self-employed

  Sept 2012 - Nov 2019

  Data system Engineer Consultant

  - Contracted to develop business intelligence reports using Oracle SQL Developer and Oracle Discoverer 10g business intelligence reporting software.- Developed application which collates historical data to defend third party claims.- Maintain and update the highway digital network using ESRI ArcGIS, QGIS and Ordinance Survey Master map.- Produce analytical maps for highway maintenance schemes.- Developed application for maintaining highways asset inventory using Microsoft SQL Server.- Historical data migration and integration using SSIS and ETL process. Using T-SQL and PL/SQL to maintain and query the database. Show less

• 

  Quadrant Subscription Services (a part of Air Business Group)

  Jan 2020 - Aug 2022

  Analyst Programmer SQL

  Working as an SQL developer and data extraction using SSIS and ETL.