Trevor Stam

Data Engineer

Seattle, WA

951-***-**** adkrfk@r.postjobfree.com linkedin.com/in/trevorstam github.com/trevorstam Data with a background in geographic information systems and economic research. Strong cross-functional project and international experience. Known for being analytical and collaborative. Passionate about developing customer-focused solutions, mapping, data and data visualization. TECHNICAL SKILLS

Languages: Javascript, Python, SQL, HTML, CSS, Sass, R Web Development:Node.js, Express, React/Redux, JQuery, EJS, Bootstrap Geospatial: ArcGIS, QGIS, Carto, Leaflet, Mapbox, Shapely, Geopandas Data Engineering:MS SQL server, PostgreSQL, MySQL, Pandas, Numpy,MongoDB Cloud (AWS):Lambda, Cloudwatch, S3, RDS, Redshift

Tools: Git, Github, Tableau, Illustrator, InDesign, Figma EXPERIENCE

Miller Spatial, June 2019 - Present Software Engineer

● Developed a web application(frontend and backend) for the economic development agency of a large county. Maintained and organized the data warehouse consisting of all parcel and land use information.

1. Migrated and rewrote backend from Python scripts hosted on ArcGIS Server to a Python Flask REST API

2. Re-designed the database schema and partitioned large datasets to optimize query performance

3. Wrote scripts to automate ETL operations, data quality validation and build financial reports using SQL Server, Pandas and Numpy

4. Troubleshoot client issues, ad hoc data inquiries and gather business requirements directly from client

● Contributed to a system that processes underground service alert (dig alert) emails and updates the status of work requests/orders in asset management systems and ArcGIS applications of municipal public works departments.

1. Extended email parser with extra categories to enhance adaptability to the system requirements of a diverse client base

2. Created Cloudwatch log parser in AWS Lambda to collect supplemental data when database instance is down or at limited capacity. Used boto3 AWS Python SDK and cron jobs to orchestrate Lambda functions. This feature recovers about 50 work order tickets for each hour of downtime

3. Conducted trial runs to test the system and eliminate errors before implementation Family Service Association, August 2017 - May 2018 GIS Analyst

● Conducted demographic and GIS analysis to locate low income residents of the Inland Empire with limited access to fresh produce using ArcGIS

● Prepared and cleaned data from various sources using R and MS Excel. Transformed data from flat files and JSON into spatial formats such as shapefiles and geodatabases

● Designed maps and spatial databases in ArcMap and ArcGIS Pro EDUCATION

Code Fellows, July 2018 - December 2018

Certificate - Advanced Software Development in Javascript University of California Riverside, June 2017 - September 2017 Coursework completed in ArcGIS, web mapping and cartographic design Utrecht University, the Netherlands, December 2008 Msc. Geography