Geoffrey E. Gallaway
St. Louis, MO 63111
(314) [redacted]
geoffeg@geoffeg.org
# Summary
# Senior software engineer and team lead with over twenty five years of experience building enterprise software in a wide variety of industries.
- 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.
# Skills
Programming Languages
- JavaScript, TypeScript, Python, Coffeescript, Java, PHP, Clojure, Perl, C, Postscript, shell scripting
Operating Systems
- Mac OS, Linux, Solaris, Windows
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
# Employment History
# Bayer (via contract) - Senior Software Engineer - St. Louis, Missouri
January 2023 - December 2024
- 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.
# Reify Health - Team Lead & Staff Engineer - Remote (Boston, Massachusetts)
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.
# Ocelot Consulting - Cloud Engineer - St. Louis, Missouri
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.
# Bayer (formerly Monsanto) - Software Engineer - St. Louis, Missouri
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.
# Answers - Senior Software Engineer - St. Louis, Missouri
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.
# Education
- Studied Computer Information Science and Psychology at Ohio State University
- Clojure/West 2012, 2013
- MongoDB Conference, 2011, 2012, 2013, 2014
- O’Reilly Strata Conference 2011
- Strange Loop 2009, 2013, 2021
- Perl conference (YAPC) 2000, 2001 and 2002, 2006
- Various presentations at various user groups and conferences.
# Other Experience
- 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