Breaking Games logoCurrently an Extern @Breaking Games
Gerardo Rivera portrait

Exploring tech roles through hands-on projects

I test career paths by doing project work, learning tools and workflows to decide what fits me best.

🟢 Open to work
View my workDownload resume

Work samples

Portfolio of hands-on projects, including an SQL and database architecture externship with Breaking Games, showing practical tasks and what I learned.

  • StreetSense
    StreetSense

    Revamped UI performance by 25% and reduced data entry errors by 45% through designing a React-based interface that allows users to log road hazards, such as potholes, on an interactive, community-driven app. Reduced data loss incidents by 15% by integrating a SQL database and leveraging the Gemini API to automate AI severity scoring and vehicle damage estimation for suspension and tires. Achieved 100% on-time delivery of a functional platform by collaborating in a team of four to develop a gamified leaderboard and an Admin Dashboard for officials to send critical road repairs. Improved user search efficiency by 20% implementing specific features such as CRUD functionality and processed record search parameters within a live, community-driven environment.

    TypeScriptJavaScriptPythonCSS/HTMLGoogle Gemini API
  • Research-RAG
    Research-RAG

    Engineered an AI research assistant using MongoDB Atlas to perform hybrid retrieval, fusing Vector Search and BM25 full-text search via Reciprocal Rank Fusion in a single pipeline. Established retrieval precision by implementing Google Gemini API with asymmetric task types and Matryoshka dimensionality truncation, reducing storage needs by 75%. Enhanced data accuracy by developing a section-aware PDF chunking algorithm to maintain semantic boundaries and a system prompt that enforces strict inline citation anchoring.

    ReactNode.jsMongoDB AtlasGoogle Gemini API

About me

I test career paths by doing project work, learning tools and workflows to decide what fits me best.

I am Gerardo Rivera, a recent graduate with some professional experience and a Bachelor’s degree. I am exploring different roles to learn how they feel day to day, using project-based work like an SQL and database architecture externship with Breaking Games to build practical skills and clarify my next career step.

Externships

SQL & Database Architecture Externship with Breaking Games

Breaking Games

Experience

Software Tester Engineer

Applause · May 2025 – Present

Education

Georgia State University

B.S. in Computer Science, GPA: 4.12 · Class of 2026

Skills

SQLDatabase architectureData modelingQuery optimizationSchema design
Back to works

StreetSense

Revamped UI performance by 25% and reduced data entry errors by 45% through designing a React-based interface that allows users to log road hazards, such as potholes, on an interactive, community-driven app. Reduced data loss incidents by 15% by integrating a SQL database and leveraging the Gemini API to automate AI severity scoring and vehicle damage estimation for suspension and tires. Achieved 100% on-time delivery of a functional platform by collaborating in a team of four to develop a gamified leaderboard and an Admin Dashboard for officials to send critical road repairs. Improved user search efficiency by 20% implementing specific features such as CRUD functionality and processed record search parameters within a live, community-driven environment.

TypeScriptJavaScriptPythonCSS/HTMLGoogle Gemini API
View all works
Back to works

Research-RAG

Engineered an AI research assistant using MongoDB Atlas to perform hybrid retrieval, fusing Vector Search and BM25 full-text search via Reciprocal Rank Fusion in a single pipeline. Established retrieval precision by implementing Google Gemini API with asymmetric task types and Matryoshka dimensionality truncation, reducing storage needs by 75%. Enhanced data accuracy by developing a section-aware PDF chunking algorithm to maintain semantic boundaries and a system prompt that enforces strict inline citation anchoring.

ReactNode.jsMongoDB AtlasGoogle Gemini API
View all works