San Jose, California, United States
Front-End Web Application: Developed an application with JavaScript and React to support the ingestion, maintenance, and audit of wires for a given satellite. Included a generic excel-like grid UI and OAuth integration for login authentication and security. Various features were added to the application including upload and download options and advanced query capabilities. Improved productivity, user experience, and data management by 100%.
Backend Server: Supported the development of an HTTP Server with endpoints following RESTful API principles. This included functionality to communicate with an Oracle database through the JDBC API. Enhanced user productivity as it supported handling requests for multiple wiring ingestions or changes through a single endpoint. Thereby significantly improving throughput along with providing services for requesting reports.
Concurrency/Async: Enhanced back-end functionalities using concurrency features. This included, support for multiple database queries to obtain results from a given request and support for running a background service for long running reports.
Database/Domain Modeling: Gathered requirements for spacecraft wiring design from engineers and supported the implementation of database tables and logical dependencies.
Reports: Created complex SQL queries to pull data and transform it to support specific output formats including, pdf, csv, and excel.