GIS Database Engineer Geo-Data Geospatial Data Management Software
Resume:
Reily Love
*** ** **** ****** *******, WA 98115
***********@*****.*** https://linkedin.com/in/reilylove/ SUMMARY
Seasoned GeoData Engineer, who worked for Esri early in career, with extensive experience developing scalable data pipelines and managing cloud and on-premise infrastructure. Over 15 years of expertise in Python, ETL/ELT, and spatial database (SQL Server +Spatial, Oracle Spatial, and Postgres PostGIS) technologies supported by proven success in architecting data solutions and software for high-volume analytics and machine learning applications. Notable achievements include developing complex spatial and real-time data integrations in AWS environments, ensuring robust, automated, and high-quality data delivery.
TECHNICAL SKILLS
• GIS Software / Database: ArcGIS (All), FME, SQL Server (+Spatial), Postgres/PostGIS, Redshift, SQL, QGIS, Open Street Map(OSM), Google Maps
• Programming & Development Tools: Python, Scala/Spark, Java, JSON/GeoJSON, JavaScript, C# / VB.NET, HTML/HTML5, Visual Studio, PyCharm, Git/Bitbucket
• Infrastructure: AWS (CLI, RDS, EC2, S3, Lambda), LINUX (Ubuntu, RHEL, Amazon), Windows (Server, 11, 10), MacOS, Docker, VMWare, Terraform, Cloud Platforms
• Data Engineering: Data Engineering, ETL/ELT, Data Integration, Apache Airflow, NoSQL Databases, REST API Development, DynamoDB
EXPERIENCE
Cadmus Group / Ventera Sep 2024 - Present
GIS Database Engineer
Tech Used: Postgres/PostGIS, Python, Docker, EC2, S3, SNS/SQS, Lambda, QGIS, ArcGIS, FME
• Collaborated with over 100 USDA and contract engineers to modernized and refactor the hardware and software which supports the Natural Resources Conservation Service Web Soil Survey data inventory and associated applications. Utilized SQL Server (+ Spatial), Postgres/PostGIS databases, FME, Python, and Docker to build and maintain cloud-based data pipelines on AWS (EC2, S3, Lambda) to support dynamic geospatial applications.
• Engineered and optimized complex back-end spatial queries using Postgres and PostGIS for effective data ingestion and analysis of soil, water, and other USDA proprietary datasets.
• Implemented and maintained scalable open-source ETL pipelines in an AWS environment with Python, Postgres, Lambda, S3, SNS/SQS, Jenkins, and Bitbucket.
Woven by Toyota / Carmera Apr 2019 - Jun 2023
Senior Geo-Data Engineer / Manager
Tech Used: Postgres/PostGIS, QGIS, ArcGIS, Python, RDS, DynamoDB, EC2, S3, CircleCI, Docker, Terraform, OSM
• Directed and mentored a team of eight GIS Analysts in agile, high-definition mapping projects, fostering collaboration and process automation.
• Optimized and implemented large-scale data pipelines on AWS using Python, S3, Lambda, Terraform, CircleCI, and GitHub to support autonomous vehicle HD map development.
• Established and enforced PostgreSQL/PostGIS best practices for database design, security, and efficient spatial data storage.
• Applied object-oriented programming principles in Python to drive robust software development and seamless data integration.
• Leveraged AWS cloud resources and containerization with Docker to design scalable, automated data processing workflows. Amazon Jun 2014 - Mar 2019
Geo-Data Engineer
Tech Used: Postgres/PostGIS, Python, RDS, EC2, S3, SNS/SQS, Redshift, Lambda, DynamoDB, QGIS, ArcGIS, OSM
• Real Estate Physical Stores: Design and implement real estate and demographic spatial data pipelines supporting machine learning
(ML) optimization models for existing physical stores (Bookstore, Whole Foods, 4 Star, Go) and site selection models for new store locations. Developed these pipelines using python, AWS Lambda, SNS/SQS, and S3 to perform demographic data acquisition through automating downloads from the US Census Bureau, Esri's Business Analyst Online, INRIX pedestrian and vehicular traffic, scraping websites, etc. to create spatially enabled Postgres and Redshift data warehouses to support ML models and integrated geocoding and reverse geocoding services.
• Sustainability: Develop and manage complex ETL data pipelines for continually updated inventory and analysis of Amazon's global operations for carbon reporting. Design spatial data warehouses for Postgres and Redshift to support Life Cycle Assessment (LCA) environmental impact and ML models which drive strategies to reduce ecological stress through increased efficiencies. These processes provided the global transportation component used to calculate Amazon's first Carbon Footprint.
• Maps: Developed global digital map tile database to support consumer products and Amazon delivery applications for phones, tablets, and other devices in addition to providing spatial analysis and logistics support for deliveries throughout the world. Leverage extensive experience with large spatial databases to develop a global logistics entity store of conflated vendor transportation data (Nokia/HERE, Ordnance Survey, MapMyIndia, etc.), OSM, and internal data based on ML models.
Reily Love
909 NE 72nd Street Seattle, WA 98115
***********@*****.*** https://linkedin.com/in/reilylove/ EXPERIENCE (continued)
Cayman Islands Lands and Survey Department Nov 2012 - May 2014 GIS Software Engineer
Tech Used: ArcGIS Enterprise, ArcGIS Desktop, SQL, C#, Python, HTML5, JavaScript, SSRS/SSIS, SQL Server, VMWare
• Conversion of legacy Web Map Portal and development of new Mobile GIS applications based on ArcGIS v10 Enterprise and Desktop products:
• Software development using C#, Python, SQL, and JavaScript.
• Developed MS Build scripts for continuous integration and deployment of applications.
• Architected new Development, Test, and Production server environments using VMWare vCenter.
• Implemented GIT source code repository for all legacy and new development which included training personnel how best practices using this technology.
Plum Creek (Weyerhaeuser) Feb 2007 – Nov 2012
Senior GIS Developer
Tech Used: ArcGIS Enterprise and Desktop, ArcObjects, C#, Python, HTML, JavaScript, SQL Server, SSRS/SSIS
• Develop enterprise applications to support Plum Creek’s land management:
• Citrix based, ArcGIS Desktop editing extension and automated map creation for over 20,000 parcels.
• Web map portal for query and viewing land parcel data using ArcGIS Server and Silverlight.
• GIS Web Services for spatial overlay analysis and on demand PDF map creation using ArcGIS Server.
• Consolidated spatial data editing spanning three databases into one, shared ArcSDE database which enforces topological constraints, versioning, tracking, and replication to the read-only Land Systems data warehouse.
• Conversion of ArcObjects based GIS Data Services to SQL Spatial queries using the SQL Server 2008 Spatial data type, stored procedures, and table functions. Automated necessary geoprocessing operations using python. Other Experiences: Seattle Public Utilities, Seattle Department of Transportation, Rand McNally, King County, Microsoft, Verizon Wireless, Esri
EDUCATION
University of California, Berkeley
Doctoral Student, Environmental Planning
• GPA: 3.7
University of South Carolina
Master of Science, Geography (GIS & Remote Sensing)
• GPA: 3.8
Clark University, Worcester, Massachusetts
Bachelor of Arts, Computer Science
• GPA: 3.6
Contact this candidate