Andres Jaramillo

Experience

• 

  Excelsure Insurance Services

  Jan 2018 - Feb 2020

  Data Operations Engineer

  • Managed data entry process for an insurance company, ensuring accuracy and completeness of all data entered.• Developed automated solutions to streamline the data entry process, resulting in improved efficiency and reduced errors.• Provided technical support to end-users, troubleshooting and resolving any data entry-related issues.

• 

  Open Source

  Jan 2020 - Jan 2022

  • React Router to expedite the content delivery of a SPA through dynamic, client side routing that renders persisting views with seamless transitions without making calls to the server.• Implemented Socket IO for its ability to provide a low overhead communication channel between the server and client as well as for linking end-users with a constant bidirectional stream of data.• Designed a Node.js/Express server with middleware pattern to enable users to update, change, and delete their settings.• Constructed a NoSQL db for flexible, persistent data storage to allow for optimal data-transfer and horizontal scaling. Show less • Constructed a UI using React hooks for a seamless browsing experience on a single page web application.• Created a Node.js/Express server to construct RESTful API with modularized middleware and async database connections that allows for user authentication, session tracking and data storage.• Configured a PostgreSQL database to create a secure data store for persistence of data across sessions.• Integrated Google OAuth to ensure encryption, uniformity, and ease of scaling while preserving user state sessions by separating user information from server databases with the third-party API. Show less

  • Capable Human | Cognitive games that measure your scores with others

    Jan 2022 - Jan 2022

  • Coders Only | App for programmers to connect

    Jan 2021 - Jan 2022

  • App Tracker | Web app to manage your job applications

    Jan 2020 - Jan 2021
• 

  QuiL (Open Source)

  Sept 2022 - Jan 2023

  Software Engineer

  • Developed a tool that generates GraphQL resolvers and schemas for PostgreSQL databases, and provides a visualization tool to help developers understand their database more effectively.• Utilized Nextjs 13 to leverage its file system based routing and built-in TypeScript support for enhanced performance.• Applied TypeScript to enhance maintainability and increase the scalability of the codebase through the use of static typing.• Architected the frontend with React using reusable components to promote a consistent and clean codebase, and utilized React hooks to make the state accessible across the app to change the display mode and limit path changes.• Utilized Tailwind CSS for a better engineering experience and consistent user interface.• Incorporated a PostgreSQL database in order to maintain ACID compliance of sensitive user information.• Applied OAuth service by utilizing Github’s API to construct a custom endpoint that provides a convenient and reliable signup and login, minimizing interaction with sensitive information while tokenizing (JSON Web Token) user requests. • Implemented GraphQL schema types and resolvers to provide the necessary data while maintaining minimal requests.• Integrated React Flow’s dynamic, node-based components to allow users to interact and visualize their database Schemas.• Wrote unit tests in Cypress to verify application behavior by mocking user interactions, allowing us to test the app in a controlled environment and ensure it was functioning correctly. Show less

• 

  Dynamic Benchmarking

  Feb 2023 - now

  Lead Developer