WILLIAM COCODIA

An Artistic adventurous Hardworking and dedicated GIS/Database Administrator with years of experience in the public and private sectors. Coordinating Charity events in my spare time
Enjoy Lawn-Tennis (A licensed Tennis Coach), travelling, video and sound editing

Passionate about contributing to the growth and development of children in deprived and developing areas

GIS LEAD/DB ADMIN/LLPG CUSTODIAN LEWISHAM COUNCIL Apr 2019 – Date

Managing a team to support all departments in the council with GIS and LLPG section of their projects

Managing databases both Spatial and Non Spatial

Managing users access to spatial databases

Linking relevant information across varied databases and present in Webmap views and outputs

Integrating data across teams

Migrating Servers and Databases To Azure Cloud

Exploring ways to cut cost across services via GIS and LLPG tools and datasets

GIS PLANNING OFFICER/DB ADMIN LEWISHAM COUNCIL Aug 2015 – Apr2019

Working with PostgreSQL, PostGIS, QGIS, SQL Server Mgt Studio, Access, Excel, Mapthat GIS Web App, ArcGIS, Oracle client, LLPG, FME, MapInfo, Acolaid, K2 Asset Mgt System, Sharepoint, WMS, WFS

Managing the council’s GIS Working with the Asset Management and Regeneration Team to improve and migrate data management user applications, enhancing the use of GIS within the council, creating and managing an easily accessible database of GIS layers, managing the Intranet GIS system, managing users of k2 and Confirm Applications. 

Working on Planning Applications from a GIS perspective for large scale projects, reviewing spatial analysis of New developments considering environmental economic, character and safety

Understanding Planning Obligation and Planning Policy impacts

Building relationships with developers and Planners

Producing Planning data in 2d and 3d Mapping Outputs

Relating with vendors and reviewing other possible Asset Management and GIS solutions

GI Application implementation for customers and users

Providing Training and GIS Customer support

Enhancing relations between the team and other departments, representing the team at GI conferences and symposia

PROGRAM MANAGER – HOOD TENNIS (Charity Spare Time)

Manage and coordinate events at Hood tennis charity. 

Relating with coaches, clients, parent and those to be involved in project delivery

arranging programs, discussing with trustees

Managing funds and assisting with fund raising

GIS DATABASE ANALYST RMSI (Security Cleared)  Aberystwyth  Jan 2015 – May 2015

Working on Citrix Xena desktop System with Access, Excel, Objective8, Productivity Suite for OS Data Conversion, ArcGIS, ArcToolbox, Python toolbox, QGIS, SQL Server Management Studio, Remote Connection Desktop and JIRA Agile.

Working on EU funded projects with the Welsh Government. Working on 3 separate but linked Network Environments, each hosting designated softwares to suit specific projects. 

Carrying out data transformation using OSTN02 Transformation method, working on the Rural Payments and Land Management Project in Wales. Running and enhancing existing python scripts and SQL queries as well as creating new ones for routine GIS processes. GIS Data production for field work, loading data onto Tablets and Hand Helds. Extensive data analysis, 3D and Spatial analysis with terrain models, cartography and map production, database management of varied file formats, extracting and converting data as required to produce desired results, software installation and updates.

GIS ANALYST  KESINGTON/CHELSEA COUNCIL  Jan 2014 – Dec2014

Working with Access, Excel, ArcGIS, MapInfo, QGIS, PostGIS, OSM, LLPG, Acolaid, Python, ArcEngine, ArcServer and Atlas GI web Service including Articulate Storyline, MS Project, Powerpoint and MS Word

Working within the GIS (PLAT) team for all the departments of the council producing required maps, 

Working with the contingency planning team to use live hazard information to produce a mapped output for a contingency plan noting Ambulance and hospital locations 

Using ONS Data to analyse percentage deprivation based on LSOA

Reviewing ArcGIS license and Ordnance Survey License. Installing softwares as required

Updating LLPG records, Councl Tax (CT), Electoral Register (ER), LPI, BLPU Class, Non Domestic Rates (5600ND) and determining Parent and Child Properties

Maintaining large databases and varied file formats, extracting and converting data as required to produce desired results. Installing required GIS Application for customers

Implement QGIS as a GI Solution to customers

Making training videos, Providing Training both live and online  and GIS Customer support

Publishing on ArGIS Server, Managing databases and carrying out varied spatial analysis

Enhancing relations between the team and other departments, representing the team at GI conferences and symposia.

YBSM PARTNERS   Oct 2012 – Jan 2014

1. GIS Parks Project Officer  Hackney Council    Jul 2013 – Jan 2014
2. GI/Planning/Regeneration Officer Haringey Council   Oct 2012 -  May 2013

GIS Surveyor/Analyst  - Hammersmith Council  Oct 2008 – Jul2012 

GI Analyst - 1st Communications Ltd London Jul 2008 – Sept 2008

Working on a Telecom project collating, updating and editing database for cable routes and pylon locations

Working with Google Maps and Google Earth, Cors Maps, OS products and MapInfo. Converting from OSGB36 to WGS 84 Capturing data from different file formats, brought in from different sources into Smallworld GIS.  

Surface Data Specialist - ENVIRONMENT AGENCY GEOMATICS, BATH UK (Oct. 2007 – Jun 2008)

 Working within a small team of GIS Technicians within the Geomatics group’s Production Team to process and quality control LIDAR elevation data to produce high quality GIS ready LIDAR elevation products, used for Flood Risk Mapping, CAD Design, environment and site location analysis/mapping

• Satellite Imagery Analysis using tools in ArcView 3.3, ArcGIS and ERDAS (DTM/DSM/DEM) carry out analysis on various forms of satellite imagery, data from Optical Remote Sensing, bathymetric survey and ground based GPS

• Surface analysis carried out Lidar and SAR Data for various parts in the UK. Updating Lidar images (shapefiles and grids) to be used by the agency and for sale. Carrying out filtration of raw Lidar data to provide desired surface requests. 

MSc, GEOGRAPHICAL INFORMATION SYSTEMS -  (2006-2007) 

Glamorgan University

Information Technology, Geography

B.Tech, COMPUTER ENGINEERING - (1994-1999) 

Rivers State University of Science and Technology Port-Harcourt Nigeria

Information Technology

Diploma Marketing Research  STONEBRIDGE COLLEGE UK

Diploma Project Management STONEBRIDGE COLLEGE UK