Close

Adrian Ferrar

Geospatial

Analytics


View Resume

About Me

Geospatial professional with background in GIS, web development, & database/systems administration. Specialization in architecting and deploying geospatial solutions for a range of private, municipal, state, and federal stakeholders.


Experience


KPMG US

Senior GIS Specialist - System Admin

Senior GIS Specialist with KPMG's Advisory division. Working within the GIS team to deploy and maintain ArcGIS Enterprise and other GIS software while delivering high-quality client solutions. Expertises in creating data pipelines, migrating data from vendor platforms, and developing user-friendly GUIs.

  • Deployed Kubernetes-based version of ArcGIS Enterprise and currently maintain all four environment instances.
  • Produce and present numerous client deliverables, including analytical results, dynamic map visualizations, or systems/strategy consultation.
  • Develop data pipelines for seamless migration of data from vendor/public platforms to internal Postgres DB.
  • Implement user-friendly GUIs for efficient execution of data pipelines by other team members.
  • Produce custom web services for both internal/external consumption.
  • Develop rich web applications using combination of low-code and custom code methods.


NYC Department of City Planning

GIS Specialist

Served as a GIS Specialist in NYCDCP's Enterprise Data Management division managing agency's spatial data products through scripted automation and assisting in troubleshooting GIS/IT related issues.

  • Developed data pipelines for distribution of products within agency's internal data stores and across various external platforms (ArcGIS Online, Carto, DigitalOcean, FTP servers, etc)
    • Datasets include: LION, MapPLUTO, Digital City Map (DCM), Zoning Features, E-Designations, Mandatory Inclusionary Housing (MIH), Building Footprints, Digital Tax Map (DTM), and more.
  • Audited agency platforms for REST service maintenance and data quality compliance in accordance with open data mandates. Over 500+ internal and publicly facing datasets.
  • Upgraded agency’s ESRI infrastructure and developed recurring maintenance procedures to improve database render performance by 43%.
  • Developed internal SDE monitoring scripts to track and visualize and report SDE usage, by user, across agency.
  • Developed custom internal ESRI License Manager to allow users the option to view license availability and request access from other users.
  • Maintained updates to The Guide to Planning Resources (internal web platform for sharing data resources across divisions) through combination of Microsoft Sharepoint, ArcGIS Hub, ArcGIS Online, and Github platform management.


NYC Department of Transportation

College Aide

While working under Asset Management division, maintained various geodatabases with python scripts to automate recurring tasks in large datasets and contributed to the development of a citywide predictive street deterioration model. Maintained various Microsoft Access databases.

  • Increased office workflow efficiency through the development of scripted pipelines for updating street asset records in File Geodatabase and SDE server repositories.
  • Contributed to the development of a citywide predictive Street Deterioration Model using R, SQL, and Python.
  • Managed the analysis of historical commitments for all DOT bridge, street, and facility assets seeking to spatialize and evaluate funding patterns within various political boundaries.
  • Led the collection and digitization of all NYC street ownership records. Worked in collaboration with Department of City Planning and the respective City Borough President's Topography Departments.
  • Developed QA process for evaluating digitization metrics.


New York Restoration Project

AmeriCorps Environmental Steward

Served as an Evironmental Steward involved in fostering community environment and maintaining garden assets/responsibilities in areas of East New York and Brownsville, Brooklyn.

  • Participated in and planned outreach events, volunteer field projects, and provided technical support and training to community gardeners.


Atlas Environmental Lab

Environmental Lab Analyst

Served as laboratory researcher involved with examination of potential asbestos containing materials (ACMs).

  • Analyzed bulk and airborne filter samples using stereo, phase-contrast, and polarized-light microscopy and prepared paint, soil, dust wipe, and composited wipe samples for environmental lead analysis via AAS.


Telepathy

Programming Intern

Served as personal assistant of independent programmer. Aided in development of mobile applications.

  • Tested, debugged, and modified small-scale iOS and Android applications.

Education


Hunter College

Jan 2017 - May 2018

Master of Science in Geoinformatics

Experience in computational aspects of GIS with focuses in data pipeline creation, database modeling, web visualizations, and spatial statistics.


The City College of New York

Jan 2013 - May 2014

Bachelor of Science in Earth System Science

Experience modeling Earth systems. Focus in biogeology via research assistantship regarding clay/bacteria/bacteriophage interactions.

Projects

BECs Leaflet Map

A geovisualization of deli locations and breakfast sandwich prices in NYC. Utilizing a CartoDB backend.

View Project

Soundscape StoryMap/CessiumGlobe

A geovisualization of locational soundscapes to demonstrate the concepts of Geophony, Biophony, and Anthrophony as well as to highlight the work of world-renowned Soundscape Ecologist, Bernie Krause.

View Project

Google Maps Resume

A geospatial journey to learn a little bit more about my professional and academic experiences and to view some of my writing samples.

View Project

Herd Immunity Visualization

A modeled visualization of the concept of herd immunity and its effects on the transmission of disease through varying degrees of vaccinated populations.

View Project

Technical Skills

Contact Me