Software Engineer
Pittsburgh, Pennsylvania, United States
Collaborated with a team to develop a Spring Boot web application that performs ETL operations on JSON record logs and loads them into a SQL database utilizing Flyway for database migration.Designed and implemented 5 API routes in the backend to facilitate seamless communication between the database and frontend using Java and java.sql for query generation and result set retrieval.Managed and processed JSON files of 100,000 objects, displaying 1,000 transformed records on the web page post-query.Wrote Python scripts with SQLAlchemy to split fields, enhancing the searchability of the final database.Utilized Flyway for database migration, Gradle for project management, PostgreSQL for SQL database schema, AngularJS for the frontend interface, and Spring Boot for hosting the web application.Ensured smooth integration of revised code into the development pipeline by following appropriate Git procedures.