Aaron Stephenson Email & Phone Number

Madison, Wi, Us

Reston, Va, Us

• As a full-stack developer I design and develop every piece of each web application, including: - servers (Linux and Windows) - databases (PostgreSQL, MySQL/MariaDB) - web services (Python (Django, Flask)) - web and mobile clients (Javascript (Angular, Ionic))• As a solutions architect I design, deploy, and maintain scalable, highly-available, and fault tolerant systems in the cloud (AWS) and/or in a traditional internal data center (VMware) to meet the specific needs of a project or program: - EC2 - RDS - S3 - VPC - Lambda - Route53• Recent applications include: - several laboratory information management systems, such as environmental mercury research - a decision support and data management system for flood insurance eligibility - an information sharing and reporting system for wildlife morbidity and mortality events, for use by thousands of public and privileged users - interactive maps for dissemination and discovery of scientific datasets• Additionally, I serve as the system administrator for our entire team's IT infrastructure, including servers, networks, databases, DNS, user and directory services, and tech support and troubleshooting• I also advise developers on the design and usage of cloud services (IaaS, PaaS, SaaS), enterprise databases, and Geographic Information Systems (GIS) mapping and geoprocessing web services

Madison, Wi, Us

• Managed the North Temperate Lakes Long Term Ecological Research program’s several databases• Wrote stored procedures and other scripts to manage and manipulate data• Performed quality assurance and control on all datasets, and wrote metadata when necessary• Assisted NTL LTER researchers with data queries, and designed databases for their research projects• Maintained several websites on multiple frameworks, scripted new functionality, and added content• Administered several servers, including upgrades, backups, software maintenance, and troubleshooting• Consulted with programmers to design new tools for data entry and editing for NTL LTER crews• Served as GIS specialist for NTL LTER: managed spatial data; administered GIS software, servers, and services; and assisted NTL LTER researchers, staff, and students with GIS questions• Participated in LTER network activities, including working groups that created new software and services

Madison, Wi, Us

• Conducted requirements gathering and analysis, system design, and opportunities analyses with clients• Performed "fit" analysis between COTS packages and client requirements, or designed custom solutions• Designed and implemented databases, maintenance scripts, and reports using SQL, Python, and XML• Programed web mapping applications using HTML+CSS, JavaScript, and PHP• Managed project teams, and coordinated and supervised subcontractors• Implemented COTS and custom solutions to meet designs• Facilitated testing of new solutions• Developed user and technical documentation and conducted client education/training of solutions

Camp Hill, Pa, Us

• Conducted geospatial work on government and private sector GIS applications, including spatial analysis and cartography for water systems, transportation systems, land use, and other environmental projects, including remote sensing digital image processing and interpretation• Wrote scripts to customize and automate geoprocessing tasks using Python• Mapped floodplains and constructed models for FEMA Flood Insurance Studies

Madison, Wi, Us

• Procured geodetic control data from disparate sources and converted into a PostgreSQL+PostGIS database

Madison, Wi, Us

• Designed, implemented, populated, and maintained a site inventory database for the National Park Service

Sun Prairie, Wi, Us

• Authored maps, converted and corrected CAD data to GIS, address geocoded street centerlines for E911, created and maintained numerous thematic data layers, modeled storm water sewers for network analysis

• Collected highway infrastructure data with a GPS receiver, presented updates to county board committees, and created maps as needed

• Researched land records for parcel mapping, surveyed PLSS corner monuments using GPS and conventional methods, and created maps as needed

M.S., Environmental Monitoring: Remote Sensing And Spatial Information Management

B.S., Geography, And Cartography And Geographic Information Systems

Certificate, Internet Development