Kansas City, MO

Hi, I'm Katie.
Curious, Creative, Conscientious.

I'm an aspiring QA Analyst and technology professional with experience building websites, working with SQL, Excel, and software projects. I enjoy solving problems and creating user-friendly applications.

View Projects Download Resume

Core Stack

SQL
Python
QA Testing
Git
MySQL
JavaScript

About Me

From the warehouse floor to the QA queue.

I recently completed my Associate degree in Computer Information Science. Before transitioning into technology, I spent many years in warehouse operations, where I developed strong attention to detail, process improvement skills, and experience training others. I'm now focused on building software quality, data analysis, and web development skills, and I bring that same operational rigor to every test case, query, and page I ship.

I studied music at Truman State before my path led me into tech, so I've always thought in terms of practice, iteration, and getting the details right. Those habits translate directly into QA work.

At a glance

A.A.S., Computer Information Science · Johnson County Community College, 2026 · GPA: 3.77
Certificate, CIS: Software Developer · Johnson County Community College, 2026
B.A. Music · Truman State University, December 2013
13+ years in quality-focused, fast-paced operations environments
Software Testing · UAT · Test Cases · Defect Documentation
SQL · MySQL · GitLab · HTML/CSS/JavaScript · Excel

CliftonStrengths

How I naturally work.

My top five CliftonStrengths (Gallup) themes. Two of them map directly onto QA work: diagnosing what's wrong and helping people improve.

Restorative

Drawn to problems: good at spotting what's broken and working through it methodically until it's fixed.

Developer

Notices small signs of progress in people and gets energy from helping others grow and improve.

Adaptability

Comfortable going with the flow and adjusting as things change, rather than needing a fixed plan.

Ideation

Energized by ideas: quick to spot connections between things that don't obviously relate.

Intellection

Thinks things through deliberately and enjoys reflective, in-depth conversation.

View certificate ↗

Projects

Work that's actually live.

Three shipped websites: designed, developed, deployed, and maintained end to end, including hosting and domain management.

Status: Deployed Capstone Project · May 2026

Indian Creek Cycle Rentals

A full bike-rental site built with a development team: browsing, trail guides, reviews, and booking flows for a family bike rental business.

SQL
GitLab
HTML/CSS/JS
QA Testing
Hosting & Domain Mgmt

Case study → Live site ↗ GitLab ↗ GitHub ↗

Status: Deployed Personal Site · June 2026

Marc Garcia Trumpet

A responsive site for a St. Louis trumpet performer, recording artist, and clinician. Designed, built, and maintained solo, including hosting and domain configuration.

HTML/CSS/JS
Audio Embeds
Responsive Design
Hosting & Domain Mgmt

Case study → Live site ↗ GitLab ↗ GitHub ↗

Status: Deployed Personal Site

Intentional Thoughts

A personal site built to share celebrations with family: a lightweight, ongoing project with new sections added as the family's story does.

HTML/CSS
Hosting & Domain Mgmt

Case study → Live site ↗ GitLab ↗ GitHub ↗

SQL Portfolio

Querying, checked twice.

A normalized MySQL database built to compare pet product prices, delivery times, and availability across nine retailers, designed, populated, and queried from the ground up.

Status: Complete Personal Project · July 2026

Shopping Tracker Database

A relational database comparing pet product prices across nine retailers (Walmart, Petco, Chewy, Amazon, and more). Built three normalized tables linked by primary and foreign keys, populated them with real product and pricing data, then wrote queries ranging from basic filtering to window functions, CTEs, and views to answer questions like which store is cheapest for a given product and which retailers offer the fastest delivery.

MySQL
Joins
Subqueries
CASE
Window Functions
CTEs
Views

Case study → GitLab ↗ GitHub ↗

BASIC

Basic Queries

SELECT, WHERE, ORDER BY, and LIMIT: filtering products by category and food type, searching by keyword, and sorting results.

INTERMEDIATE

Intermediate Queries

INNER JOIN across all three tables plus COUNT, AVG, MIN, MAX, GROUP BY, and HAVING: average price per store, product counts by category, and stores with the fastest average delivery.

ADVANCED

Advanced Queries

Subqueries, CASE statements, a ROW_NUMBER() CTE to find the cheapest store per product, RANK() to rank stores by average price, and a reusable ProductPriceComparison view.

Excel & Power BI

Dashboards and data, made readable.

Seven Power BI reports built on the Shopping Tracker Database, using the same pricing data from the SQL project, turned into visual comparisons a non-technical stakeholder can scan at a glance.

In Progress · July 2026

Pet Shopping Tracker · Power BI Dashboard

Connected Power BI directly to the Shopping Tracker Database schema and built seven focused reports: average price by brand, category, product, and store; product counts by category and by store; and a sortable cheapest-store-by-product matrix.

Power BI Desktop
Power Query
DAX
Data Modeling
Data Visualization

Case study → GitLab ↗ GitHub ↗

PRICE

Pricing Analysis

Average price broken down by brand, category, and individual product, showing where the expensive brands and categories actually are.

STORE

Store Comparison

Average price per store and product counts per store: which retailers run cheap, and which carry the widest selection.

MATRIX

Cheapest Store by Product

A sortable table matching every product to its lowest recorded price, store, and estimated delivery time.

QA Portfolio

The evidence behind "it works."

Revisiting the Indian Creek Cycle Rentals capstone from a tester's perspective: structured test cases, exploratory sessions, documented defects, and regression tracking.

Fixes Verified · July 2026

Indian Creek Cycles · QA Testing

An independent QA pass on Indian Creek Cycle Rentals, covering both the public site and the admin features: 19 manual test cases, plus exploratory testing that surfaced six defects, from a revenue total on the admin dashboard that didn't match its own breakdown page, to navigation that breaks at high browser zoom. All six were fixed and passed regression testing.

Manual Testing
Test Cases
Bug Reports
Exploratory Testing
Regression Testing

Case study → GitLab ↗ GitHub ↗

PLAN

Test Plan

Scope, testing approach, environments, and success criteria for the admin dashboard, bike/reservation management, accessories, reviews, and role-based permissions.

Test Cases

19 manual test cases spanning smoke, functional, negative, responsive, accessibility, visual, and regression testing, tracked in a structured spreadsheet.

BUG

Bug Reports

Six defects documented with severity, steps to reproduce, expected vs. actual results, and suggested fixes, from a dashboard metric miscount to accessibility issues at high browser zoom and with keyboard-only navigation. All six fixed and verified.

EXP

Exploratory & Regression

An exploratory session charter plus targeted accessibility testing that surfaced six defects total, and a completed regression cycle: 21/21 test cases passing, all six defects closed.

Certifications

Credentialed and current.

A.A.S., Computer Information Systems

Johnson County Community College

May 2026

Associate of Applied Science degree.

View certificate ↗

Certificate, CIS: Software Developer

Johnson County Community College

May 2026

Computer Information Systems · Software Developer track.

View certificate ↗

Excel 2019 Essential Training

LinkedIn Learning · NASBA CPE

July 2026

4.00 CPE credits · Field of study: Computer Software & Applications

View certificate ↗

SQL Essential Training

LinkedIn Learning · NASBA CPE

July 2026

7.80 CPE credits · Field of study: Computer Software & Applications

View certificate ↗

Intro to Career Skills in Data Analytics

LinkedIn Learning

July 2026

2 hrs 21 min · Skills: Data Analytics, Tech Career Skills

View certificate ↗

B.A. Music, Cum Laude

Truman State University

December 2012

Foundational training in discipline, practice, and performance under pressure.

View certificate ↗

Resume

The full picture.

Download a copy, or read the online version below.

Download Resume (PDF)

Professional Summary

Computer Information Systems graduate with a 3.77 GPA, a Software Developer Certificate, and hands-on experience building, testing, deploying, and supporting web applications. Strongest in SQL, with additional experience in relational database design, Django, JavaScript, Git workflows, Linux/Unix, and software testing. Brings 13+ years of quality-focused operations and leadership experience in training, inventory analysis, root-cause investigation, documentation, and cross-functional problem-solving.

Technical Skills

Languages

SQL
Python
Java
JavaScript
PHP
C++
HTML
CSS

Frameworks and Databases

Django
Spring Framework
React
Bootstrap
MySQL
SQLite

Tools and Platforms

Git
GitHub
GitLab
Docker
VS Code
DBeaver
MySQL Workbench
Linux/Unix
Bash
SSH
PythonAnywhere
Netlify
Cloudflare

Software Quality and Analysis

Manual Testing
Functional Testing
Exploratory Testing
Regression Testing
UAT
Test Case Development
Defect Documentation
Debugging
Agile
SDLC
Systems Analysis
UML
Requirements Gathering
REST APIs

Additional

Cisco Packet Tracer
AI-assisted development (ChatGPT, Codex, Claude)

Projects

Indian Creek Cycle Rentals · Capstone Project

May 2026 · indiancreekcycles.com

Collaborated with a development team to design, build, test, deploy, and support a Django bicycle-rental application using Python, SQLite, HTML, CSS, JavaScript, and GitLab.
Created manual test cases and defect reports; performed functional, exploratory, regression, and cross-device testing; verified fixes; and supported SQL data, hosting, domain configuration, and application updates.

KatieGarcia.dev · Developer Portfolio

2026

Built and deployed a portfolio presenting software projects, technical skills, and SQL work using Git-based version control, a custom domain, and cloud hosting.

MarcGarciaTrumpet.com · Client Website

June 2026

Designed, developed, and deployed a responsive website for a professional trumpet performer and educator; continue to manage hosting, domain configuration, updates, and functional testing.

Shopping Tracker Database · SQL, MySQL, DBeaver

July 2026

Designed a normalized relational database with primary and foreign keys, joins, queries, and CRUD operations to organize and retrieve shopping data.

Education

Associate Degree, Computer Information Science

Johnson County Community College, May 2026 · GPA: 3.77

Certificate · Computer Information Systems: Software Developer

Johnson County Community College, May 2026

Relevant Coursework: Systems Analysis & Design, Database Management, Java Programming, Object-Oriented Programming, PHP/MySQL Web Development, Unix/Linux, JavaScript, Big Data Architecture, Software Testing, Capstone Project

Bachelor of Arts in Music

Truman State University, December 2013 · GPA: 3.65

Professional Experience

Walmart Distribution Center · Harrisonville, MO

Warehouse Associate · Trainer · Strays & Damages · Loader · Order Filler · 2023–2026

Maintained quality and accuracy standards in a high-volume distribution environment.
Processed strays and damages while maintaining accurate documentation.
Trained associates on operational procedures and equipment operation.
Worked across multiple operational functions while maintaining quality and safety standards.

ALDI Distribution Center · Olathe, KS

Shift Supervisor · Inventory Specialist · 2022–2023

Investigated inventory discrepancies through audits and system reviews.
Coordinated inventory activities and maintained accurate inventory records.
Researched inventory-related issues and worked with team members to resolve discrepancies.

Shift Supervisor, Produce Department · Quality Control Produce · 2016–2022

Coordinated daily produce operations while maintaining quality, safety, and inventory standards.
Ordered inventory using demand forecasts and inventory data.
Created daily operational reports while communicating with suppliers, drivers, corporate teams, and internal departments.
Investigated product defects and made acceptance or rejection decisions based on established quality standards.
Managed product placement based on inventory levels, temperature requirements, and product compatibility.

Contact

Let's talk.

linkedin.com/in/katiegarcia89

GitLab

gitlab.com/katiegarcia

GitHub

github.com/katiegarcia89

Katie.Garcia.C@gmail.com