Circle Image

Gabriel Hall

Systems Architect

A systems architect of considerable range, Gabriel Hall — Chicago-born, Los Angeles-raised, and New York-educated. Drawing from a wealth of knowledge in technology and culture, I live at the intersection of both to create

I have all sorts of hobbies like photography, motorcycles, astronomy, reading, gardening, cooking what I grow, and woodwork. I try to introduce technology every step of the way.

I'm always reachable at gabriel@westla.dev


EDUCATION



CERTIFICATION


Microsoft Certified: Azure Data Engineer Associate [Cert ID: 989747016]
MSDN - Administering MS SQL Server 2012 (70-462)


SKILLS


Leadership: Developer Supervisor, Professional Development Leadership Training, Recurring Committee Leader

Languages:
TSQL  ●   C#  ●   VB.NET  ●   Powershell  ●   JS  ●   VBA  ●   Groovy  ●   Python  ●   JAVA  ●   bash  ●   perl  ●   Classic ASP  ●  

Platforms: Microsoft Azure, Amazon Web Services, Windows Servers

Databases: SQL Server 2005-2022, Azure SQL, SQLite, DynamoDB, Access, Mongo, JSON, XML

Business Intelligence: SQL Reporting Svcs (SSRS), Power BI, Tableau, ChartJS

Development Tools: Visual Studio, Git, Jenkins, SSIS, Azure, JIRA/Confluence, Cron, Postman, React, MaterialUI


PROFESSIONAL SUMMARY

End to end system developer with 10+ years IT experience in all positions from support and data analysis to design and cost monitoring to code implementation and testing. Emphasizing backend dev and integration.
  • Experienced administering and coding in all versions of SQL Server
  • Experienced migrating and integrating data from Excel, JSON, XML, and CSVs between fileshares, web services, and databases (ETL)
  • Experienced automating deployment and testing with continuous integration and continuous delivery platforms
  • Experienced translating software requirements into technical spec


EXPERIENCE

UCLA, Office of Research Administration (ORA/ORIS) - Los Angeles CA

ARCHITECTURE TEAM
MAR 2015 - PRESENT
Office for Research Information Systems (ORIS) provides IT and business analysis services to the departments within UCLA's ORA and maintains critical research enterprise systems utilized campus-wide.
  • Design, creation, and maintenance of a centralized automatic notification email system;
    wrapped UCLA SMTP and Twilio Sendgrid for use across research admin applications
  • Design, creation, and maintenance of data ETLs and migrations for SQL server using SSIS
  • Designed and maintained SSRS Reports and tools
  • Query Tuning, Data Sanitizing, Data ETL monitoring for backend systems
  • Installation, configuration, setup and scripting for a Jenkins Build Server
  • Automated Web Test and Unit Test development
  • Committee member for ORCA EDI, Campuswide Github Initiative, Dept Level Flexwork
  • Technologies: MS Azure, ASP.NET, MVC, Git, SQL 2K8R2-2016, SSMS, SSRS, SSIS, SSAS
  • Accolades and Distinctions: UCLA Star Awd, ORA Excellence Awd, UCLA PDP Alum

Purposer - San Diego, CA

SYS ARCHITECT AND LEAD ENGINEER
MAY 2020 - JUN 2022
Purposer is a startup in the development phase for an ecommerce platform with purpose driven and altruistic shopping.

UCLA Health, MyLife Research Project - Los Angeles CA

DATA ARCHITECT/TECHNOLOGY ADVISOR
AUG 2016 - AUG 2018
The MyLife project is designed to mobilize and train our nation's future physicians to transform chronic disease prevention and management using wearable device data.

Simetra Systems - El Segundo CA

DEVELOPER/ JR SQL DEVELOPER
AUG 2013 - MAR 2015
Simetra Systems is a computer consulting company specializing in database programming and design, Access, SQL, ASP, and many other technologies.

Law Office of Andrews & Thornton - Irvine CA

LEGAL ASST/DATA QUALITY
DEC 2011 - AUG 2013
The law firm of Andrews & Thornton focuses its practice on the areas of serious injury cases resulting from dietary supplements and pharmaceuticals.

Columbia University Information Technology - New York NY

HELP DESK COMPUTER SUPPORT
SEPT 2009 - SEPT 2011
Help desk support is the first line of technical support for the university.