– It All Starts Here

David Ager

Herndon, VA, USA

Multi-skilled, driven, creative and passionate data analyst with a specialism in geospatial data analysis / Geographical Information Systems (GIS). Has strong experience and aptitude for GIS analysis and data modelling (ESRI, FME, MapInfo, QGIS, Tableau Public, Flood Modeller), database management (SQL, Access, SQL Server) and web development and coding skills (inc. Javascript, Python, GeoJson, Google Analytics and HTML/CSS) within in the conservation, engineering and environment industries.

Strong passion and interest in all things geospatial and data visualization, as well as personal growth in coding and the power of maps and visuals to drive knowledge and positive impacts. Also a rare breed who loves Excel spreadsheets.

Capable of analyzing a wide range of subject areas with a meticulous eye for detail. Looking to secure an analytical position to contribute and develop his skills set.



Personal Website:


SQL - 8 years

In Esri platforms and creating and amending SQL scripts, in Microsoft SQL Server 2016

GIS - 9 years

At university, all jobs and during personal time. Including Esri (ArcGIS Pro, ArcMap, SDE,
ArcGIS Online, Survey123, Collector, StoryMaps) , QGIS, GRASS.
Includes GIS data management in Enterprise environments, and Raster, Spatial Network and 3D Analysis toolboxes

FME/ETL - 2 years

Particularly FME Desktop 2016 which I used to process and create workflows for routine GIS processing at Environment Agency. Completed introductory and intermediate training courses for FME in June 2019.

Graphic Design - 4 years

For Cartographic and web element designs, including use of Inkscape; Adobe Photoshop; Adobe Illustrator

Python - 5 years

Used in work setting, particularly for creating and amending GIS processing tools and scripts.
Also undertaken online courses and personal projects using tools like Jupyter Notebooks. Experience in ArcPy, Numpy, Matplotlib, Pandas, Jupyter Notebooks

R - 2 years

Earned two data science certificates from HarvardX and have experimented in own time with various projects. Experience in R Studio, dplyr, rspatial, ggplot2 libraries

Javascript - 3 years

Self taught and utilized in personal projects for many web mapping tools - includes Mapbox GLJS API, LeafletJS, ArcGIS API for Javascript

Microsoft Excel - 15 years approx

Includes VBA tools, VLookup, PivotTables - training course completed in using VBA tools for Excel

HTML/CSS - 7 years

Includes module at university and configuration of GeoCortex Browser at National Trust

Tableau Public - 2 years

Power BI - 1 year

Flood Modeller - 1 year

Google Analytics - 2 years

SharePoint - 1 year

WordPress - 3 years

Work Experience:

August 2017 - January 2020

Environment Agency, UK Government (Bath, United Kingdom)
FCRM Officer (Mapping and Analytics)

• Played key role in processing, validating and updating GIS open data products for external industry usage, with
national significance to river, coastal, reservoir and flood mitigation management - providing supporting
evidence for UK government targets to reduce properties at flood risk
• Successfully processed, communicated and validated quarterly updates of Flood Map products - (Flood Zones
2 and 3, Recorded Flood Outlines and Areas Benefiting from Defences) - assisting area teams with interim
checks, then facilitating the external release of data
• Promoted the quality control and up-to-date coverage of Flood Alerts and Flood Warnings for Flood Incident
Management team, using ArcPro to analyze address point data (OS AddressBase Premium) of residents at flood
risk, on a quarterly basis
• Applied my attention to detail to check accuracy of and update Main + Detailed River Networks,
communicating with area teams to successfully produce accurate river status and asset maps for public
• Utilized FME and ESRI ArcGISPro 2.1, ArcMap 10.3, ArcInfo Workstation to run toolboxes, Python scripts and
workbenches to validate and translate geometry and topology, to ensure OGC compliance of data products
• Took initiative and responsibility to produce toolboxes and Python scripts to ensure consistent processing,
managing and updating of Flood Model outline data, used in an internal 'Flood Slider' web tool
• Furthered my SQL, SQL Server and GIS skills in ArcMap, SDE, ArcPro and Microsoft SQL Server 2012 to
update, analyse and review data outputs and key figures as part of National Flood Risk Assessment (NaFRA),
Communities at Risk (CoR) and State of the Nation
• Promoted the work of our team internally using striking visualisation and infographics work
• Consistently completed ad-hoc GIS mapping and data queries in a timely, efficient and accurate manner,
underpinned by strong customer service skills
• Undertaken internal training in GDPR and UK/EU Data Protection

May 2016 - August 2017

CH2M (Swindon, United Kingdom)
Software Technician (Flood Modeller)

• Organised, produced and presented weekly and quarterly web data analytics output from Google Analytics and Google Data Studio into Microsoft Excel using pivot tables and data graphics to inform sales and marketing meetings
• Performed customer facing tasks to ensure software is distributed and maintained in working order, utilising problem solving skills to resolve customer issues.
• Collated customer feedback to help identify new requirements.
• Planned and undertake software testing and develop documentation.
• Managed databases that underpin our mobile and web apps, e.g. Flood Alert.
• Managed the web servers that host our web apps.
• Involved in the development process for new software tools and enhancements of our current tools.
• GIS and web mapping
• Produced 2D Flood Model analysis for project in Corozal region in Belize and presented output in static map and video formats, to empower and inform flood defence planning in the region.
• Performed data validation and verification of bathymetry data.
• Collaborated and worked effectively and efficiently with colleagues in external offices nationally and internationally to promote Flood Modeller support and sales

May 2014 - February 2016

National Trust for Places of Historic Interest or Natural Beauty (Swindon, UK)
GIS Assistant (Conservation Information)

Consistently completed successful cartographic output for clients quickly and innovatively to meet and exceed short and long term deadlines over a range of map scales, clients and subject areas.

Provided timely, insightful, accurate and appropriate business-dependent GIS analysis for internal and external clients, displaying an ability to time manage and work effectively under pressure

Maintained, updated and managed data efficiently, ensuring accuracy and usability for future and external users, including writing up data documentation

Collaborating and producing important cartographic and analytical work for external organisations, as well honing my team working skills to promote high output throughout the team

Furthered my knowledge of GIS, computing (Python/HTML/SQL), land legislation, environmental designations and metadata standardisations into work situations, displaying my high adaptability and a constant drive to self-improve including undertaking GIS Training and learning computing skills in out of office hours

Displayed high adaptability to new subject areas, tools and skills sets, including the range of tools in ArcToolbox, and Model Builder to produce risk models

Contributed successfully to building elements for a new GIS Web Browser including using services, ArcGIS Online, HTML and GeoCortex Essentials

Produced GIS and Cartographic high standard output for clients in a timely manner. Used Python and Model Builder to create from scratch, data analysis, documentation and output for Land Choices and Land Condition Assessment Projects.

Combined different variables and many datasets to produce an assessment of agricultural risk, as well as coded models of which other users could manipulate variables. This created data and mapping in order to guide agricultural decision making at a property level.

September 2013 - May 2014

National Trust for Places of Historic Interest or Natural Beauty (Swindon, UK)
Species Records Intern (voluntary)

Managing, inputting and validating species records from biological survey reports. Also involved GIS analysis and map creation for several projects and clients, as well as a statistical analysis report into effectiveness of land use reversion scheme in Pembrokeshire, Wales.

Involved using Excel, Word, GIS, report creation, data analysis, investigative, interpersonal and team working skills, as well an eye for detail and accuracy.


Data Camp: Data Science Toolbox Part 1 + 2

Esri Inc. E-Learning: Spatial Data Science


Data Science: R Basics
Data Science: Data Visualization

Esri Inc. E-Learning:
Going Places with Spatial Analysis
Earth Imagery at Work
Do It Yourself Geo Apps
Python for Everyone
Network Analysis Using ArcGIS
Introduction to Surface Modeling
Basics of JavaScript Web Apps

New College, Swindon, UK:
Excel Masterclass - Automating Your Spreadsheet

GIS247 (GISP Accredited)
Mastering ArcGIS 10.1


September 2009 - June 2013

University of Reading (Reading, United Kingdom)
BSc Geography (Human and Physical)
1st Class Honours
GPA: 3.72 (on US 4.0 grading scale)

Including: GIS & Digital Cartography (85%), Geographical Techniques (85%)


June 2019 - present

Data Visualization Contributor - Emerging Cricket

Providing data visualization and web mapping skills when required for sports journalist articles.

May 2015 - present

Volunteer GIS Digitizer - Humanitarian Open Street Map

Contributed GIS skills in free time from home to digitize settlements and buildings as part of 2015 Nepal Earthquake rescue mission, using Open Street Map

Further assisted with digitization of buildings in Maarba district of Damascus in March 2016, as well as road and settlement infrastructure digitization in Buzi, Mozambique as part of Cyclone Idai rescue mission. I also took part in a ‘mapathon’ in Reading, digitizing and assisting others to map a region of Malawi.

November 2012 - August 2013

Peer Supporter - University of Reading

Involved developing counselling and listening skills to help notice and support students through a diversity of personal or academic issues. Also involved delegation and organization of Peer Support promotional events.

David Ager

Posted 2021-04-23 under Analyst, Cartography, Consultant, Contract & Freelance, Forestry, Geography, Geospatial, Government, Information Technology, Other, Planning, Programming, Research, Sales & Marketing, Software Development, Specialist, Support, Technician, Training, Web & Internet