Geoffrey E. Gallaway

6227 Minnesota Ave.
St. Louis, MO 63111
(314) [redacted]
geoffeg@geoffeg.org

# Summary

Knowledgeable in agile methodologies and engineering practices.
Experienced with understanding and driving client requirements to produce reliable and scalable solutions focused on business needs.
Familiarity with various compliance and regulatory frameworks, including HIPAA, Part 11 and GXP.

Programming Languages

JavaScript, TypeScript, Python, Coffeescript, Java, PHP, Clojure, Perl, C, Postscript, shell scripting

Operating Systems

Technologies and Systems

PostgreSQL, Kubernetes, Docker, git, AWS (Amazon Connect, DynamoDB, IAM, CloudFormation, EMR, EC2, Lambda, S3, etc), Apache, Tomcat, MongoDB, Hadoop, MySQL, Subversion, Oracle, MS SQL Server

January 2023 - Present

Helped a team bootstrap a project to track vital information about Bayer’s crop science products. Designed an auditing database that kept a write-only ledger of all database activities for compliance and auditing reasons.
Full stack maintenance and feature development of more than a dozen React and Node.JS applications that allowed internal users to be more efficient by eliminating reliance on an older, difficult to use legacy database.

January 2021 - December 2022

Designed and implemented an auditable, immutable medical fact system in PostgreSQL. The system allowed users to store medical facts and ontological references about candidates and patients in a way that was easy to understand and use while still complying with regulatory and compliance requirements.
Led a team that developed a patient discovery and matching system that recommended existing patients for new clinical trials based on the medical information stored in various services (including the database mentioned above).
Led a team of all remote developers and designers in multiple countries. Duties included agile coaching, sprint planning, team ceremonies, interviewing, and mentoring.

June 2019 - January 2021

Architected and assisted with the design and deployment of a call center solution for a Fortune 500 healthcare company which operates dozens of call centers throughout the US. Built on Amazon Connect, Amazon’s IVR solution, the project requirements included multi-region availability and failover, strict HIPAA and PII restrictions and helping to educate and train employees in how to use AWS tools and write Javascript and Go.
Worked with a team to start development of a next-generation freight planning and optimization solution utilizing PostgreSQL, Kubernetes, NodeJS and various Azure services. I assisted in development of the REST API, porting existing customer data into the new system and building an automated machine learning pipeline for the data science team.

January 2017 - June 2019

Worked with a team to develop a modern replacement database, API and Vue-based site for all of Monsanto’s genetic sequence data. This included a REST API written in Node.JS connecting to PostgreSQL and Neo4J databases. I took the lead on converting some non-queryable data from a complex, normalized data structure to Postgres’s JSONB storage type. This significantly reduced API response times, simplified queries and reduced code complexity.
Developed a new, customer-facing web application using TypeScript, React, Redux, TypeORM, Amazon RDS, Aurora, Lambda, CloudFormation and a partial microservices architecture. Took the lead in automating a majority of the development infrastructure using Docker for unit tests, Jenkins pipelines for continuous integration and serverless for deployment.
In my 10% time I developed an API to allow an internal drone team to determine if a flight plan would intersect FAA controlled airspace. This consisted of importing a high-resolution digital terrain model and the FAA’s airspace shapefiles into PostgreSQL and using PostGIS to determine if a series of waypoints and the lines between them would enter controlled airspace.

July 2010 - November 2016

Forked and maintained custom rule management system based on JBoss Drools to allow business to make accurate routing decisions for every HTTP request. Custom requirements included faster decision response times and rule and package management capabilities.
Initiated company-wide project to evaluate various NoSQL databases culminating in the selection of MongoDB. Implemented real-time traffic stats platform using MongoDB to allow immediate reactions to changing traffic and business requirements which protected company resources and secured corporate IP.
Launched web service API layer written in Clojure to parallelize access to multiple databases resulting in faster page load times, improved search engine rankings, reduced web server load and cleaner, more straightforward front-end code.
Developed platform for central storage and processing of user profiles providing improved customer insights, intent and privacy. Raw data from each web server is fed into HDFS and processed with Hadoop before being loaded into MongoDB for online access via Clojure web service APIs.
Lead developer on ResellerRatings, a merchant review and feedback site written in PHP using Kohana, MySQL, SOLR and MongoDB. Worked with various groups to transition site to new data centers and significantly improve site response times. Mentored new and junior developers, bringing them quickly up to speed on a system with over 20 years of technical debt and history.

Maintain, administer and manage multiple personal domains for email and web hosting.
Commercial Pilot, Airplane Single-Engine Land, Instrument Rated
Amateur Radio License, General Class