• Undergraduate Research Assistant at the Data to Insights (D2I) lab• Organized millions of research catalog data from OpenAlex and MUP into a PostgreSQL database, serving as the primary data source for the CollabNext project• Enhanced query performance by 90%, reducing runtime from seconds to milliseconds, by utilizing the PostgreSQL EXPLAIN ANALYZE feature and optimizing table structures with indices and materialized views

• Designed, implemented, and deployed a Spring Boot email server on AWS EC2 to manage virtual email addresses for users and enabled internal staff to query and forward key information—such as verification codes and links—from application emails, streamlining the application process and reducing manual effort for users applying to hundreds of jobs• Developed an automated email processing pipeline using AWS SES, S3, and Lambda to extract and store critical information (e.g., sender company, verification links/codes) in DynamoDB for efficient data access and application follow-up communication

• Created a social media server with Spring Boot by setting entity models, API routes, and service methods, as well as user authentication with Firebase• Generated database schemas and applying them to the cloud-hosting CockroachDB through Hibernate ORM• Used stored procedures, batch deletes, and updates in the native query to support larger traffic•Wrote unit and integration tests with JUnit and Mockito

• Collaborated with an IBM research team to achieve compliance-as-code automation in the Compliance Trestle open-source project, resulting in 1000+ LOCs, 10+ closed issues, 15k monthly downloads• Identified and resolved bugs with Python to improve the project’s stability• Refactored the project’s webpage and CLI documentation• Updated existing demos to the latest Trestle version and added new demos to address additional use cases• Independently implemented Tekton pipelines to replace existing GitHub Action pipelines for a sub-project, addressing internal restrictions and ensuring the project's pipeline remained operational