# John Wagner > Software Engineer Location: Los Angeles, California, United States Profile: https://flows.cv/johnwagner Experienced JavaScript engineer and open-source contributor. Currently developing full-stack applications with React, Node, Express, PostgreSQL, and MongoDB. Most recently contributed to SeeQR, an open-source PostgreSQL prototyping tool. ## Work Experience ### Senior Software Engineer @ Weekend Health Jan 2022 – Present | San Francisco Bay Area ### Software Engineer @ SeeQR Jan 2022 – Jan 2022 • Pairs with a locally hosted PostgreSQL server to deliver integrated database functionality with DB importing and in-app updating, as well as runtime metric analysis, allowing users to copy and refactor their schemas while they perform tests. • Built with TypeScript, utilizing custom types and interfaces, to ensure the predictability of data and static typing throughout the application as well as to improve the developer experience. • Utilized Electron to create an offline sandbox application that deploys to Mac/Windows/Linux, and provides an environment for users to finely tune their SQL database design through an intuitive GUI. • Implemented Node’s FS and Path modules to allow users to store stateful query data locally, allowing for persistent data across multiple sessions. • Leveraged React.js’s intuitive infrastructure and data flow, alongside React Hooks to create modular and reusable stateful components. • Integrated Material-UI React components alongside styled-components to create a pleasant and uniform UI-UX. • Developed under tech accelerator OS Labs (opensourcelabs.io). ### FlashCatch @ Open Source Jan 2021 – Jan 2022 | San Francisco Bay Area • Application to incentivize studying via gamification. • Utilized data queried from the Pokemon API to provide users with rewards for reviewing and creating custom flashcards. • Implemented an ACID-compliant SQL database to store relational user data, as well as a NoSQL MongoDB to archive non-relational data retrieved from the Pokemon API. • Built using React to utilize modular and reusable components, maintaining dryness throughout the codebase and simplifying the process of creating an application with many moving parts. • Integrated Redux architecture to provide a top-level source of state as well as to prevent excessive prop drilling, allowing components to subscribe to state as needed. • Incorporated the Redux Thunk library into reducer functions to allow for API calls and asynchronicity within the Redux environment. ### Frollic @ Open Source Jan 2021 – Jan 2021 • Application to help differently-abled users find businesses that offer accommodations. • Leverages the Yelp API to provide meaningful data to differently-abled users, providing functionality for users to log provided accommodations, as well as the ability to filter search results based on the accommodations that a user requires. • Implemented a PostgreSQL database, normalized to the third form, to store persistent user data and prioritize access speeds, minimizing latency and guaranteeing scalability. • Engineered Node/Express server to create a RESTful API to manage incoming data and provide users with responses. • Integrated React architecture in combination with Redux data flow to manage and protect various forms of data as they are added to the state from application DB and API calls. • Implemented authentication functionality to allow users to create and store their accommodation preferences within their account. • Utilized the crypto-js library to fully encrypt user data before storing to ensure safety and privacy for users. • Created a suite of tests for front-end and back-end to follow the TDD workflow as well as ensure the functionality of the application prior to further development. ## Education ### Bachelor's degree San Francisco State University ## Contact & Social - LinkedIn: https://linkedin.com/in/jwagner988 --- Source: https://flows.cv/johnwagner JSON Resume: https://flows.cv/johnwagner/resume.json Last updated: 2026-03-29