Nelson Ahrens, Gisp Email & Phone Number

Chadds Ford, Pennsylvania, United States

Responsibilities:Note: many of the three- and four-letter abbreviations below are airport designators (e.g. DFW, ATL, PHL).• Produces and maintains geographic data and graphics for airport-related GIS projects.• Performs complex data conversions from AutoCAD to GIS using FME.• Performs complex spatial analyses (e.g. Predictive Modeling)• Provide detailed documentation and training for client deliverables (e.g. FME conversion for PAE).• Airfield asset creation such as signs, lighting, runways, taxiways, and buildings (done for MCI, and MKC)• Dashboard creation (e.g. Pavement Condition Index (PCI) for CRAA)Sample Projects• Created a program that runs in AutoCAD to facilitate lease area creation (used for SLC, GSP and PHL).• PHL, Civil 3D CAD drawings converted to GIS with FME.• DFW Digital Twins • Cad layer standards overhaul applying National CAD Standards and FAA 18B for new layers. • Conversion of 28 ALP, CAD drawings into one GIS FGDB (FAA 18B compliant) using FME.• PAE analog data to enterprise GIS: • Research of hundreds of PDFs and AutoCAD drawings. • Conversion of all CAD utility drawings to GIS using FME. • Land lease areas created from metes-and-bounds

Charlotte, North Carolina Area

• Create and maintain features in Mecklenburg County’s street centerline database • Created ArcGIS Online web application to track status of subdivision development• Coordinate centerline changes with all data stakeholders (i.e. Police, Fire, Medic, and CDOT). • Troubleshoot orphan addresses and overlapping address ranges• QC with ESRI’s Data Reviewer extension • Convert CAD from preliminary plan drawings into centerline and parcel features in GIS• Analyze land deeds from the Register of Deeds for accuracy.• Enter deeds into the County's Land Records database • Conducts research on legal descriptions, property ownership Land deed processing • Updated to the census address database (added over 9,000 new census addresses for the 2020 census)

Charlotte Douglas International Airport

• Unload trucks and load airplane containers• Directly load 757• Provide escort• Facilitate airplane fueling

York, Sc

Assisted the GIS Administrator in the creation and maintenance of GIS web pages used by county employees and the public. Involved in many aspects of GIS automation, GIS/IT maintenance, and map creation. General responsibilities and accomplishments includes:• Web development as well as customization of Geocortex Essentials (third party GIS web software - COTS) • Created the 'Easy Search' ASP.Net web application – the county’s main portal to GIS searches and applications (from Fall 2009 to Spring 2015)• Created and maintained targeted, ArcGIS Server websites for county employees to maintain their data • Provide customer support to county employees and the public with regards to use of GIS web pages • SSRS report creation and maintenance for CityWorks. Reports include inspection reports for Environmental Compliance, Engineering - Water division, Engineering - Transportation division, • Won Best Report Writing Award from Cityworks at their 2012 conference (report competition)• Created automated (emailed), SSRS reports using SQL database triggers activated by the creation of Cityworks WorkOrders (in the office or on mobile devices)• Assisted in the administration of the Cityworks database (domain of users and user permissions)• Maintain GIS servers with regular updates and restarts. • Install, and troubleshoot ArcGIS software for all desktop users.• Maps for court exhibits for the Solicitors’ department• Maps and map templates for the Voter Registration and Elections’ department• Political boundary maps

Los Angeles, California, United States

• Managed the workflow analysis and system design team for the proposed enterprise GIS system

Charlotte, North Carolina Area

GIS MANAGEMENT: • Created and maintained the GIS database• Install, configure and maintain ArcIMS, ArcGIS Server, and ArcMap• Created and maintained GIS data of existing and proposed infrastructure including cadastral, airfield pavement, buildings, roads, wetlands, security fence and doors, intermodal development, and zoning• Represent the Airport to other city departments, for public hearings, and the FAA GIS Web Pages and Web Development:Enterprise GIS web applications created and customized using ArcIMS, and ArcGIS Server• Terminal Wireless System• Airfield Pavement History • ALP• Wetlands• Airfield Signage • Terminal Building Security Access• Airport Property and Master Plan Land• Airfield LightingGIS Map Documents:• 2008, FAA approved ALP (complete 17 page document developed completely in GIS)• Wetlands Permit Application for proposed 3rd parallel runway EIS• Airfield Signage and Marking – FAA approved for 2008 airfield inspection Other map documents frequently produced:• Noise Contours• Airport Property• Part 77 Airspace • Lease Agreements• Road Relocation Projects• Proposed Intermodal Site• Airport Property Rezoning • City Counsel Presentations• Eminent Domain Litigation• Airport Certification Manual• Proposed 3rd Parallel Runway GIS Analyses:• Part 77 Airspace modeling and 7460 analyses (3D Analyst)• Noise Overlay District analysis and exhibit for City Council and County Commissioners• Runway impact on wetlands for E.I.S.• Development of airspace height restriction raster/web page (3D Analyst and raster math)CAD Management:• Installed, configured, and maintained AutoCad• Developed digital specifications for internal and external QA/QC• Prepared long range and annual, needs analysis and budget for hardware and software• Created cadastral database consisting of all airport and vicinity parcels (30,000 parcels)

Charlotte, North Carolina Area

• Produced complete residential working drawings• Coordinated CAD (AutoCAD) drawings with architects, engineers, field superintendents, and vendors• Optimized CAD system by writing LISP routines, batch files, and abbreviated commands.

Charlotte, North Carolina Area

Engineering Experience:• Designed facade wall anchors and masonry lintels requiring application of A.I.S.C. steel formulas (A.S.D./L.R.F.D.), A.C.I. formulas for concrete strength, and product test results• Calculated formulas in S.I. and imperial units• Represented company to clients and testing consultantsCAD Skills:• Purchased, configured, implemented, and maintained CAD system hardware and software• Produced manufacturing drawings, conceptual drawings, sales brochures, technical instructions, and a Q.A. manual• Created CAD software package for customers and composed documentation

Bachelor'S Degree, Civil Engineering Technology/Technician

Associate Of Arts And Sciences - Aas, Geographic Information Science And Cartography

Associate Of Arts And Sciences - Aas, Information Technology