John Anderson

Experience

• 

  ForRent.com®

  Jun 2017 - Jan 2018

  • QA Automation Engineer

    Sept 2017 - Jan 2018

  • Software QA Intern

    Jun 2017 - Aug 2017
• 

  CoStar Group

  Feb 2018 - Oct 2019

  QA Automation Engineer
• 

  Emprise Corporation

  Oct 2019 - Feb 2021

  Software Development Engineer
• 

  Highgate Training Systems

  Feb 2021 - Aug 2021

  Senior Software Development Engineer

  Same effective role as the Senior SDE role for Yorktown (contract is a joint venture between Yorktown and Highgate, same team and project across all of these roles). This role ended when the whole development department was moved from Highgate to Yorktown.

• 

  Yorktown Systems Group

  Sept 2021 - now

  Senior Software Development Engineer

  Develop time sensitive solutions to immediate system and field needs. Improved recurring process performance by 29,000% via architectural changes and algorithmic improvements, reducing process runtime by over eight hours per run. Created new API to deprecate old system in a rolling refactor which allowed for massive improvements in development team throughput on new work. Implemented keyset pagination within JPA to be used across all paged endpoints with result sets which could reach multiple billions, which massively improved search and paging performance due to not utilizing stored scrolls or offsets. Implemented a DTO layer to allow JPA entities to be divorced from API-client communications, as well as to implement unit testing of all object mappings to improve system stability and data integrity.Improved data integrity by repairing legacy data in accordance with business logic, implemented constraints to enforce it at the database layer in the future, and implemented mapping logic or defaults in the mapping layer to conform data to expectations before insertion to the database.Improved Lucene indexing performance by implementing selective indexing.Improved Lucene indexing performance and search relevance by divorcing the full text search entities from the database entities, and enforced eventual consistency via Spring event listeners. Show less