Portfolio

Work Samples | Sebastian De La Vega

Afghan Financial Wellness Program – Particpant and Rental Assistance Heat Map (FY2025)

An interactive Folium heat map that visualizes the Afghan Support Program across Texas at the ZIP-code level. Users can toggle layers for Total Households, Total Participants, Total Rental Assistance distributed, and Financial Wellness Course attendance, with quantile-based shading and dynamic legends for clear comparisons. A ZIP search, one-click city jumps (Austin, Dallas, Fort Worth, Houston, San Antonio), and hover tooltips showcase month-over-month trends (July–September) and key metrics per ZIP. The tool helps program teams quickly spot hotspots, track growth, and guide outreach and resource allocation with data.

Tools Used: Power BI, Python, HTML/CSS, ArcGIS
View Project: AAFWS Heat Map

Refugee Medical Assistance Texas Enrollment Heat Map (FY2019–FY2024)

An interactive time-lapse heat map built using Python, Folium, and GeoJSON to visualize refugee healthcare enrollment trends across Texas from Fiscal Year 2019 to 2024. Each fiscal year is represented as a separate map layer, allowing users to toggle and compare changes in enrollment across time. The tooltips provide detailed zip code-level information, including total enrollment counts, a breakdown by country of origin, and year-over-year fluctuations, offering insights into shifting demographic patterns in major metro areas like Dallas-Fort Worth, Houston, Austin, and San Antonio.

Tools Used: Power BI, Python, HTML/CSS, ArcGIS
View Project: TX RMA Enrollment Heat Map

FY2025 Q1 Texas RMA Enrollment Report

This quarterly report presents a comprehensive analysis of Refugee Medical Assistance (RMA) enrollment trends in Texas during the first quarter of Fiscal Year 2025. It includes enrollment summaries by service provider, city, and country of origin, along with comparative insights and data visualizations to support program planning and performance monitoring.

Format: PDF Report
View Report: Q1 Enrollment Report (FY2025)

RMA Application Redesign

This project involved a comprehensive redesign of the Refugee Medical Assistance (RMA) online application used by case managers across the nation. I led the UX and interface overhaul with a focus on efficiency, accessibility, and clarity. These enhancements were designed to support faster, more accurate application processing and reduce training burdens for new caseworkers.

Key improvements include:

  • Reordered application fields to match real-world case flow and reduce navigation time
  • Created tooltip guidance (information icons) embedded throughout the interface to provide real-time support and reduce input errors
  • Reworded eligibility questions to improve comprehension and reduce ambiguity
  • Embedded conditional logic that dynamically reveals or hides follow-up questions based on applicant responses

👉 View Interactive Mockup

Tools used: HTML, CSS, and JavaScript. Designed with accessibility and responsiveness in mind, with future compatibility for React or framework-based integration.

Navigating Public Assistance for Refugee Clients

This training deck was authored to standardize onboarding and guidance for resettlement case managers across Texas who assist refugee clients with public benefits applications. The deck outlines HHSC program requirements for SNAP, TANF, and Medicaid, with a focus on eligibility criteria, required documentation, income/resource verification, and appeal procedures. Designed for clarity and consistency, it incorporates visual aids, real-world examples, and policy-aligned content to improve caseworker accuracy and client outcomes statewide.


Tools used: PowerPoint, Adobe Acrobat, HHSC policy manuals
📎 View training deck