Allison Le Email and Phone Number

• Engineered a database analytics developer tool that allows users to make informed architectural decisions by comparing the size and performance metrics of different schemas and queries, creating a true ‘sandbox’ experience for developers who are looking to create a SQL database from scratch or to optimize existing ones using mock data or creating schemas at various scales.• Adopted Electron’s architecture to produce a standalone React, Node.js, and Chromium application, making the application deployable across platforms (Mac, Windows, and Linux) while taking advantage of its powerful development performance platform, data persistence, and automatic update functionality.• Applied React Hooks (Context API) to manage complex, shared state between components, taking advantage of organized and readable state management and life-cycle features while preventing unnecessary renders to improve performance.• Integrated TypeScript to enforce strict type-checking and provide a richer development environment by enabling IDEs to decrease run-time errors throughout the application, making the application and codebase more reliable and able to handle cross-team code integration for long term dependability. • Harnessed PostgreSQL’s relational database structure in order to design, test, and modify databases based on inputted queries, optimizing the efficiency in runtime for SQL queries in order to obtain large amounts of data and to keep track of this data using queries. • Architected Material-UI’s style components to facilitate ease of integration when working with existing React components, providing pre-styled components in order to create an aesthetically pleasing application.• Integrated Jest, Enzyme, and Supertest to write unit and integrated tests, verifying proper rendering and functionality of React components while ensuring modular and maintainable code, and protecting against regression bugs, edge-cases, and side effects.

• Incorporated React Router to enable dynamic, client-side page routing, creating a cohesive user experience and enhancing performance by reducing server calls in the single-page application.• Utilized the Node.js and Express framework to establish a server that utilizes the middleware design pattern, allowing flexible routing during HTTP requests, and ensuring accurate and layered error-handling for rapid programming and server-side development.

• Deployed authentication using HTTP tokens to serve client requests, ensure account privacy, and maintain session information, making the application stateful to efficiently track and personalize the state of the user and bolstering security on the client-side.• Implemented PostgreSQL database to store data between individual users, maintaining ACID compliance to ensure data integrity during transactions and guaranteeing security by providing encryption for database connection and for data transport.• Integrated Chart.js to provide a responsive UI experience through visualizations, allowing users to see real-time updates on their data transaction and giving future developers the ability to customize the data across various datasets.