Information Systems @ UTEP

Hi, I’m Sofía — I design data‑driven systems and user‑friendly dashboards.

I’m a BBA student concentrating in Information Systems at The University of Texas at El Paso. I enjoy building reliable databases, clean APIs, and visualizations that help people make better decisions.

El Paso, TX Expected May 2026 Data • UX • Automation

Email LinkedIn GitHub

Skills

Technical & Professional

SQL • MySQL • PostgreSQL • ERD • Normalization

Python (pandas, NumPy) • Jupyter • API basics

Tableau • Power BI • Data storytelling

HTML • CSS • JavaScript • REST concepts

Git • GitHub • Agile teamwork • Documentation

Excel (VLOOKUP/XLOOKUP, PivotTables) • CSV/JSON

Cloud basics: AWS & Azure fundamentals

BPMN • Process mapping • Requirements

Communication • Presentation • Leadership

Projects

Selected Work

A few recent projects from coursework, hackathons, and side work. Filter by focus area.

Database

Vecino Shop Inventory DB

Conceptual/Logical design and implementation of a convenience‑store database with triggers for stock levels and supplier reorders.

MySQLERDTriggers

Schema SQL

Analytics

AI & Data Viz Challenge Dashboard

Interactive sales & operations dashboard highlighting anomalies with simple ML‑assisted forecasts to support decisions.

TableauPythonCSV

Live Code

Web

Student Services Request App

Simple CRUD web app for tracking student requests and routing approvals via an API. Focus on clean forms and validation.

HTMLJSREST

Demo Code

AI

Optimism from Text (Mini Study)

Prototype to score short posts for optimism using a lexicon + embeddings approach; evaluates against hand‑labeled data.

PythonBERTpandas

Report Code

Viz

El Paso Mobility Insights

Exploratory analysis of public transit data with route performance KPIs and rider heatmaps for city planning ideas.

Power BIGeoOpen Data

Live Case Study

Database

MySQL Triggers Cookbook

Reference set of production‑ready triggers for auditing, soft deletes, and derived metrics with examples and tests.

MySQLTesting

Docs Code

Experience

Internships & Roles

IT Intern — BorderTech Solutions

Jun 2025 – Aug 2025 · El Paso, TX

Built a MySQL data model for inventory; reduced report generation time by 40% with optimized queries.
Automated weekly CSV imports with Python, cutting manual work by ~3 hrs/week.

Teaching Assistant — CIS Database Management

Jan 2025 – May 2025 · UTEP

Held lab hours on SQL and ER modeling; authored quick‑start guides used by 60+ students.

Leadership

Clubs & Community

Association of Information Technology Professionals (AITP)

Vice President (2024–2025). Organized tech talks, résumé reviews, and Git/GitHub workshops.

BIAS (Business & Information Analytics Society)

Project Lead for Data Viz Challenge; mentored first‑year students on dashboards and storytelling.

Coursework

Relevant Classes

A selection of courses aligned with analytics, systems, and software foundations.

Database Management

ERD, normalization, SQL, stored procedures & triggers.

Business Analytics

Exploratory data analysis, hypothesis testing, storytelling.

Systems Analysis & Design

Requirements, BPMN, user stories, prototyping.

Programming for Business

Python basics, data wrangling, APIs.

Data Visualization

Tableau/Power BI dashboards, design principles.

Cloud Fundamentals

Cloud concepts, IAM, storage, serverless basics.

Certifications

Credentials

Google Data Analytics (Coursera)

2025

AWS Certified Cloud Practitioner (in progress)

Target: 2026

Tableau Desktop Specialist

2024

Contact

Let’s connect

Open to internships in data, analytics, or IS for Summer 2026. I’d love to hear about opportunities and projects.

Email

sofia.martinez@example.com

Email Me Book a time