David González · Project portfolio

Organizing information into clear, usable systems.

Business Administration and Information Management graduate focused on records, data support, documentation, and database fundamentals.

View selected work Connect on LinkedIn

Selected academic and independent work in information systems and database developmentOpen to entry-level opportunities in information management, records, and data support

Portfolio approach

Focused work. Clear evidence.

This portfolio brings together selected academic and independent projects that demonstrate practical preparation in information systems, SQL, records, and structured data workflows.

Each case study defines the project objective, the work completed, and the capability it demonstrates. Materials are prepared for clear professional review; original academic records and fictional demonstration data remain appropriately separated.

Selected project work

Project work with practical context.

Each case study outlines the objective, the work completed, and visible evidence or downloadable materials for professional review.

Systems analysis · academic case study

Learning Management System Analysis

A structured analysis of a learning-management scenario, focused on the people, workflows, privacy considerations, and information relationships required to support a course environment.

Objective: Turn a broad learning-management scenario into a clear set of user needs and information workflows.
My work: Mapped roles, activities, privacy considerations, feasibility, and data relationships in an academic case study.
What it shows: Shows how I organize an ambiguous business scenario into a structured, explainable system view.

Requirements analysisUse casesDocumentation

Visible evidence

Academic use-case map

Reconstructed from academic source material

Academic scenarioLearning management systemRoles, actions, and information flow

Sign inAuthenticate accessLearner · Instructor

View course resourcesReadings, rubrics, mediaLearner

Submit course workValidation, versioning, receiptLearner

Participate in discussionPublish, reply, moderateLearner · Instructor

Connect repositoriesExternal file and meeting servicesExternal service

Manage courses and usersRoles, permissions, accessAdministrator · Instructor

Evaluate and gradeRubrics, comments, evidenceInstructor · Administrator

Project scope: requirements, user roles, workflows, feasibility, privacy, and information relationships.

Presentation note: source material has been translated and anonymized to provide a concise, professional case-study view.

Read the case study

Database development · academic coursework

SQL Query Portfolio

A series of academic SQL exercises using a sample customer-and-orders schema to retrieve, connect, calculate, and organize structured data.

Objective: Retrieve useful information from related customer, order, product, and line-item records.
My work: Wrote academic queries using joins, filters, grouping, aggregate logic, HAVING, and a common table expression.
What it shows: Shows foundational relational-database thinking and careful work with record relationships.

SQLRelational databasesData validation

Visible evidence

Selected query pattern

Adapted from academic customer-orders exercises

customer_orders.sqlSQL

SELECT
  c.Customer_ContactName,
  co.CustomerOrder_OrderID,
  co.CustomerOrder_OrderDate,
  p.Product_ProductName,
  od.OrderDet_Quantity * od.OrderDet_UnitPrice AS line_total
FROM Customer c
JOIN CustomerOrder co
  ON c.Customer_CustomerID = co.CustomerOrder_CustomerID
JOIN OrderDet od
  ON co.CustomerOrder_OrderID = od.OrderDet_OrderID
JOIN Product p
  ON od.OrderDet_ProductID = p.Product_ProductID
ORDER BY co.CustomerOrder_OrderDate DESC;

This excerpt is drawn from academic database coursework using a sample schema. It illustrates foundational SQL logic, relational thinking, and structured data organization.

Read the SQL case study Download SQL project files

Desktop application · academic project

VB.NET Contact Manager

A Windows Forms contact-management application that organizes structured records, validates required fields, prevents duplicate IDs, supports record changes, and exports records to CSV.

Objective: Create a simple desktop workflow for entering, reviewing, updating, and exporting contact records.
My work: Built validation, duplicate-ID checking, record selection, add/update/delete actions, and CSV export in VB.NET.
What it shows: Shows practical attention to data quality, record handling, and clear user workflows.

VB.NETMicrosoft Visual StudioData validation

Visible evidence

Record-management workflow

Interface reconstruction · fictional sample data

Full name Jordan LeeRecord ID CT-104Phone 555-0104Address Sample recordCategory General

Record ID	Name	Phone	Category
CT-101	Sample Record A	555-0101	General
CT-102	Sample Record B	555-0102	General
CT-104	Jordan Lee	555-0104	General

1. Enter record→2. Validate required fields→3. Check unique ID→4. Add or update record→5. Export CSV

The original academic application used a Windows Forms interface, a read-only data grid, required-field validation, duplicate-ID checking, record selection, update/delete actions, and CSV export. This professional reconstruction uses fictional sample data.

Read the technical brief Download selected VB.NET code

Independent portfolio project · synthetic data

Records Intake & Data Quality Review

An independently created workflow that uses documentation and repeatable SQL checks to review fictional intake records for completeness, duplicate identifiers, retention readiness, and controlled workflow status.

Objective: Create a clear, documented process for reviewing incoming records before controlled processing.
My work: Designed the field model and review rules; built a synthetic SQLite dataset, SQL exception checks, results register, and project documentation.
What it shows: Shows how I connect records administration, data quality, documentation, and SQL in a practical workflow.

SQLData validationRecords administration

Visible evidence

Controlled intake review

Independent project · synthetic data only

Records intake reviewDocumented controls · repeatable checks

12sample records

6flagged conditions

5quality checks

Review controls

CompletenessRequired date, classification, and retention fields.
Duplicate identifiersPotential record-ID conflicts are visible before indexing.
Controlled statusOnly approved workflow values can pass the readiness review.

Exception register excerpt

RecordIssueAction

REC-2003Missing classificationComplete before indexing

REC-2009Potential duplicate IDCompare source rows

REC-2010Invalid workflow statusSet approved status

This independent portfolio project uses a fictional dataset. It documents the field model, quality rules, SQL checks, and resulting exception register without representing client, employer, or confidential records.

Read the case study Download project files

Foundation

Built for careful, structured work.

The technical work is supported by business, legal, and analytical preparation—useful wherever accuracy, confidentiality, and clear follow-through matter.

Information systems

Bachelor of Business Administration in Information Systems & Database Administration, with academic work in systems analysis, database development, and applications.

Records & confidentiality

Legal-records and administrative experience reinforced by Criminal Justice studies, document review, information tracking, and careful file handling.

Clear communication

Bilingual English/Spanish communication paired with concise documentation, report writing, and structured follow-up.

Working principles

The details are the work.

Accuracy — review information carefully and correct issues early.

Confidentiality — handle sensitive records with discretion.

Clarity — document steps, decisions, and follow-up in plain language.