// Data Engineer  ·  GIS Programmer  ·  AI-Assisted Developer  ·  Texas A&M University

Jimmy
Barnett

Building production-grade data pipelines and spatial analytics systems that drive real decisions

Data Engineer and GIS Programmer with a background spanning Python automation, ETL/ELT pipeline development, SQL databases, geospatial analysis, full-stack dashboard delivery, and LLM-assisted software development. Track record of leading cross-functional teams, coordinating complex stakeholder projects, and delivering production tools across engineering, federal research, and infrastructure domains — including independently built AI-assisted data pipelines and NLP analytics systems.

View Projects ↓ Get in Touch GitHub ↗

// Core Technology Stack

Python SQL ETL / ELT Pandas GeoPandas ArcGIS Pro ArcPy Streamlit Plotly SQLite MySQL Oracle SQL Git / GitHub JavaScript Ollama R
5+
Years Engineering
10+
Languages & Tools
DHS
Federal Research
3+
US Regions Served

// Capabilities

Technical Skills

🐍
Data Engineering & Pipeline Development
Python ETL / ELT Pipeline Design Data Modeling Workflow Automation Batch Data Processing Data Transformation Data Integration Scripting and Scheduling
🗄️
Databases & Structured Data Systems
SQL MySQL Oracle SQL Oracle Spatial Data Functions SQLite Geodatabases (ESRI) Spatial Queries Database Design
📐
Geospatial Analysis & Remote Sensing
ArcGIS Pro ArcMap ArcPy Scripting ArcCatalog ENVI Software LiDAR Processing Photogrammetry Multispectral Imagery Analysis Hyperspectral Data Processing Satellite Image Processing Georeferencing Spatial Joins and Overlay Analysis
📊
Data Analysis & Visualization
Pandas GeoPandas Statistical Analysis Spatial Analysis R Programming Streamlit Dashboard Development Plotly Interactive Charts NLP Sentiment Analysis Microsoft Excel Google Workspace Data Reporting and Presentation
🌐
Web Development & Systems Engineering
JavaScript HTML5 and CSS3 PHP AutoLISP and LISP Scripting ESRI JavaScript API Web Mapping Application Development Git and GitHub Version Control Linux and Unix Systems Windows Server Administration Computer Networking MDM and Automated Deployment Systems
🏗️
Civil Engineering & Spatial Data Integration
AutoCAD Civil 3D AutoCAD Automation Scripting Plan Set Production Grading and Utility Design Roadway and Storm System Design Construction Drawing Datasets Permitting Coordination Geospatial Data Integration into Design Workflows
🤝
Leadership, Project Management & Stakeholder Coordination
Cross-Functional Team Leadership Stakeholder Management Project Coordination Client Relationship Management Technical Communication and Reporting Permitting Process Coordination Subcontractor Management Federal Research Coordination
📡
APIs, Data Ingestion & Automation Tools
REST API Integration X (Twitter) API v2 Social Data Ingestion Automated Report Generation Shell Scripting IT Workflow Automation Invoice and Database Automation Deployment Server Configuration
🤖
AI-Assisted Development & LLM Integration
LLM-Assisted Software Development Ollama — Local LLM Deployment Claude AI (Anthropic) ChatGPT (OpenAI) Data Pipeline Architecture Web Scraping and Automated Ingestion End-to-End Pipeline Design without Frameworks Modular Software Design Applied AI Integration into Data Workflows

// Work History

Professional Experience

Dynamic Engineering Consultants Design Engineer 2023 – Present
📍 Allen, TX
  • Lead development and management of data-driven infrastructure design workflows across multiple concurrent projects spanning commercial, industrial, and residential developments throughout Texas and multiple US regions.
  • Built Python and AutoLISP automation scripts that streamlined engineering drafting and data processing workflows, reducing manual effort and improving delivery speed on full plan set production from kickoff to permitting.
  • Integrated geospatial datasets from ArcGIS Pro into structured design outputs to support permitting, planning, and construction documentation, improving site analysis accuracy across all active projects.
  • Managed cross-functional teams of engineers, subcontractors, and governing body representatives, coordinating all stakeholder communication through detailed technical status reports and direct client engagement.
Kimley-Horn and Associates Civil Analyst 2022 – 2023
📍 Frisco, TX
  • Developed full construction drawing datasets for single-family, commercial, and industrial developments across multiple US states, including roadway, grading, utility, storm system, and erosion control specifications.
  • Automated repetitive drafting and data processing tasks using AutoLISP scripting inside AutoCAD, measurably improving team throughput and reducing production time on plan deliverables.
  • Utilized ArcGIS Pro and SQL-based data systems to analyze, validate, and integrate geospatial data into engineering decision-making workflows and construction documentation packages.
  • Generated data visualizations and analytical outputs to support engineering decisions and communicate site conditions to clients and stakeholders across multi-state development projects.
Texas A&M Stochastic Geomatics Laboratory Project Lead 2021
📍 College Station, TX  ·  Contracted under U.S. Department of Homeland Security — CBTS Center of Excellence
  • Led data research initiatives analyzing international cross-border supply chain risks caused by COVID-19, aggregating and transforming large international datasets into structured monthly analytical reports delivered directly to federal clients.
  • Developed a full-stack online platform to connect infrastructure stakeholders and supply chain partners, managing the complete development lifecycle from requirements definition through deployment.
  • Coordinated an international, multi-institutional research team, managing deliverable timelines, producing monthly project bulletins, and presenting progress to federal program officers.
  • Selected as a participant in the Department of Homeland Security Centers of Excellence Summit — Grand Challenge Tabletop Exercise, May 2021 — one of a small cohort of researchers chosen nationwide to contribute to a high-stakes federal scenario planning exercise focused on critical infrastructure and supply chain resilience.
Texas A&M University — Division of Marketing and Communications Information Technology Technician 2018 – 2021
📍 College Station, TX
  • Architected and deployed automated MDM and workstation deployment servers for Mac and Windows environments, supporting the division's complete endpoint fleet.
  • Authored Python and shell scripts to automate repetitive IT provisioning and maintenance workflows, significantly reducing per-device setup time and manual configuration overhead.
  • Secured and maintained all department machines on the private university network, including a successful pre-audit remediation effort that hardened legacy hardware and updated outdated software across the environment.

// Portfolio

Featured Projects

🐦

X (Twitter) Sentiment Analytics Pipeline

End-to-end social data pipeline built on the X API v2 that ingests tweets by keyword, runs NLP sentiment scoring, stores results in a SQLite database, and surfaces insights through an interactive Streamlit dashboard with rolling averages, volatility tiers, and timestamped CSV export.

Python Streamlit SQLite NLP Sentiment Analysis Plotly X API v2 ETL Pipeline
GitHub ↗
🛢️

Digital Oil Field Capstone — Geospatial Routing Platform

Geospatial routing and infrastructure analysis platform for oil field operations. Built with JavaScript and the ESRI JavaScript API, featuring interactive map layers, asset location tracking, spatial queries, and route optimization displayed in a full-stack web application.

JavaScript ESRI JavaScript API ArcGIS Online Spatial Routing HTML5 and CSS3
GitHub ↗
🔧

Custom ArcGIS Pro Buffer Analysis Toolbox

Custom ArcPy toolbox that extends ArcGIS Pro with an automated buffer analysis workflow. Accepts a CSV file and geodatabase as inputs and outputs buffered spatial geometries, eliminating manual GIS processing steps for recurring multi-layer analysis tasks.

ArcPy Python ArcGIS Pro Geodatabase Geospatial Automation
GitHub ↗
🗺️

Interactive Spatial Web Map Application

Full-stack spatial web application built with JavaScript and the ESRI JavaScript API. Features interactive map layers, data-driven symbology, spatial queries, and a filtering interface designed to improve spatial data accessibility for non-technical field users.

JavaScript ESRI JavaScript API ArcGIS Online HTML5 and CSS3 Spatial Data Visualization
GitHub ↗ ArcGIS Online ↗
🏛️

DHS CBTS — Cross-Border Supply Chain Risk Analytics Platform

Federal research platform contracted under the Department of Homeland Security Centers of Excellence CBTS program to assess COVID-19 impacts on international cross-border supply chains. Led aggregation and analysis of large international datasets, produced monthly analytical reports for federal clients, and developed a stakeholder connection web platform.

Federal Research Data Aggregation Analytical Reporting Web Development Team Leadership Supply Chain Analytics
Project Site ↗
⚙️

Engineering & IT Workflow Automation Library

Collection of Python, shell, and AutoLISP scripts built to automate real production workflows including MDM deployment server provisioning, automated invoice generation, batch database cleanup, and AutoCAD drafting acceleration scripts actively used in engineering environments.

Python Shell Scripting AutoLISP AutoCAD Automation Database Automation MDM Deployment
GitHub ↗

// Academic Background

Education

Bachelor of Science — Geographic Information Science and Technology
Concentration: Computation, Design and Analysis
Texas A&M University
College Station, TX  ·  Class of 2021
Research
DHS CoE
Program
GIS&T
// Honors, Activities & Recognition
⭐ DHS Centers of Excellence Summit — Grand Challenge Tabletop Exercise
Department of Homeland Security · May 2021 · Selected nationwide participant in federal critical infrastructure scenario planning exercise
National Merit Scholar Semi-Finalist
2015 · Top-tier standardized academic recognition
Association of Petroleum Surveying and Geomatics
Member · 2019 – 2021
Student Geosciences Council
Member · 2019 – 2021
Kappa Sigma — WebMaster, Recruitment & Driving Coordinator
Chapter leadership in digital operations, member recruitment, and safety coordination · 2017 – 2020
Wicked Woods — Fundraising Chair
Military veteran fundraising, Bryan / College Station area · 2019
Brothers Reaching Out — Event Organizer
Mental health and veteran advocacy, campus outreach programming · 2017 – 2019
Big Event — Volunteer Coordinator
Community service, home repair and landscaping for underserved residents · 2017 – 2019

Let's build
something together.

Open to Data Engineering, Analytics Engineering, GIS Developer, and Spatial Data roles. Available for full-time positions and contract engagements across Texas and remote.

Particularly interested in teams working at the intersection of data infrastructure and geospatial or civil infrastructure analytics.

✉
Email
JimmyCBarnett@gmail.com
 📞
Phone
(469) 469-4593
 ⌥
GitHub — Personal
github.com/trejimmy5562
 🎓
GitHub — Texas A&M University
github.tamu.edu/trejimmy5562
 🗺️
ArcGIS Online Portfolio
trejimmy5562_tamu on ArcGIS Online
© 2026 Jimmy Barnett  ·  College Station, TX Built with HTML & CSS  ·  Hosted on GitHub Pages