×
Julian West

Julian West

Full-Stack Developer, Data Engineer

5131 Red Poll Drive, Greensboro, North Carolina, US, 27405-9794
(336) 929-8960

Background


About

About

I build things others enjoy. I leverage technology to solve problems, to proffer results, to accomplish missions faster, better, cheaper. I get the right data to the right people at the right time, every time.

Work Experience

Work Experience

  • Data Engineer, Software EngineerHologram, Inc.

    Nov, 2020 - Feb, 20232 years 3 months

    Performed backend (API) and data engineering (data warehouse, streaming data, ELT/ETL) on platform team; created 200+ data models and associated business intelligence queries and dashboards.

    • Translated service agreements; created 12 robust custom billing models (40% total revenue)—identified underbilling errors; recouped $160K+/yr.

    • Redesigned cell tower location data pipeline; munged three different location services–increased location-matching from 40% to 98%.

    • Architeched IoT device geolocation streaming API; leveraged Redis, Node.js, GraphQL, and Mapbox—enabled efficient ad-hoc owner/device/location-based queries and plotted realtime session data.

    • Built time-series database infrastructure; migrated, transformed usage data from data warehouse—enabled anomaly-detection and better monetization via data science.

    • Replaced manual data entry with external API; built ELT tools, modeled/tested data, created discrepancy alerting—assured accurate logistics data, eliminated customer activation delays/outages/troubleshooting time, saved 20+ labor hrs/wk.

    • Overhauled manual data entry pipeline: superseded high-maintenance SaaS with open source software; added input validation—eliminated recurring interrupt work; assured data integrity.

    • Pipelined semistructured customer-reported outage data from workflow API to data warehouse; validated/correlated inputs against existing device data—generated outage history reports; afforded trend analysis, reduced troubleshooting time, provided data science training dataset.

  • Owner, Application Engineer, Web Developer, Customer SupportTechalchemy LLC

    Aug, 1999 - Dec, 20056 years 5 months

    Authored world’s first Windows filename management app--garnered Editor’s Choice awards.

    • Designed/Built lauded UI/UX, iterated based on customer feedback for features and performance

    • Created product sales/support website--SEO first page on top search sites, 7K+ sales

    • Architected distributed backend; automated order processing and licensing--eliminated 6 labor-hours/week; reduced 1-day turnaround to 10 minutes

  • QA Chief, Data Team Lead, Network/Computer TechnicianUnited States Air Force

    Oct, 1988 - Jul, 201021 years 9 months

    Consistently implemented/integrated cutting-edge technologies to solve business problems/enhance mission effectiveness.

    • Developed, operated AF’s first VoIP system--provided 300 users enhanced phone service; fabricated integrated voicemail/mail server--delivered voicemail to email; produced IP networking, server administration training program to enable utilization of six buildings converted from aircraft hangars--averted delays

    • Hacked VoIP server software to route calls to both, military and civilian voice networks; proposed changes to software developers—added military to vendor’s customer-base

    • Forged deployable comms suite upgrade with backbone network and VoIP technologies--increased bandwidth 700%, reduced footprint 50%, extended life-span 5 years, saved $300K

    • Tackled multiple inefficient QA programs: unified military, federal, and contractor processes--restored compliance with 18 standards; saved 2K labor-hours and $80K/year

    • Erected collaborative workspace website to replace 10 incongruent tracking tools--provided a reliable snapshot of 23 projects; brought 102 stalled jobs into view; saved 26 labor-hrs/wk

Projects Experience

Projects Experience

  • ModemMon, Personal

    Jul, 2017 - Aug, 20172 months

    Cable modem performance logger

    • Scraped modem's status page, structured/logged time-based performance metrics with weather data.

    • Identified two causes of intermittent outages: water ingress during heavy rain and faulty node hardware during clear hot days.

  • Care Coordination App, Non-Profit

    Oct, 2020 - Oct, 20203 days

    3-Day Hackathon

    • Implemented/Tested admin/user authentication/access controls using Django middleware and JSON Web Tokens.

    • Designed database schema/migration; developed object relational mapping for unstructured data.

    • Created web forms with input validation--ensured complete, accurate data.

Skills

Skills

  • Databases

    Amazon Redshift

    Metabase

    MySQL

    PostgreSQL

    Redis

    Timescale

  • Frameworks

    Django

    React

  • Languages

    CSS

    HTML

    Java

    JavaScript

    Jinja

    PHP

    Python

    Regular expressions

    SQL

    Shell

  • Libraries

    Bootstrap

    jQuery

    Pandas

  • Platforms

    DOS/Windows

    Linux/Unix

    macOS

    Node.js

    Windows Server

  • Protocols

    AJAX

    GraphQL

    HTTP

    JWT

    RESTful Web Services

  • Services

    Amazon Web Services

    GitHub

    GitLab

    Looker

    Stitch

  • Testing

    CI/CD

    Chai

    Jest

    Mocha

    Test-Driven Development

    UnitTest

  • Tools

    Airflow

    Data Build Tool (dbt)

    Git

    Meltano

Education

Education

  • Full-Stack Software Engineering, Full-Time Remote Bootcamp, Code Platoon

    May, 2020 - Aug, 2020

    Bootstrap

    CSS

    Django

    Git

    HTML

    HTTP

    JWT

    JavaScript

    Python

    REST API

    React

    SQL

  • Information Technology, Business Management, Remote Certificate Program, University College of Syracuse University

    Jan, 2015 - Jan, 2016

    Business Analysis

    Certified ScrumMaster

    Cisco Certified Design Associate

    Cisco Network Technician

    Corporate Communication

    Human Resources

    ITIL Fundamentals

    Information Systems Security Professional

    Microsoft Office

    Oracle Certified Java Programmer

    Oracle Database

    Project Management

    Six Sigma Black Belt

    Software Quality Assurance

    System Security Certified Practicioner

    Web Design

    Windows Server

  • Electronic Systems Technology, Associate Applied Science, Community College of the Air Force

    Oct, 2002 - Mar, 2004

    Electronics Principles

    Quality Management

Awards

Awards

  • Air Force Commendation Medal

    Awarded on:

    Spearheaded organization’s first training/operations standardization/evaluation program over 150 technicians at 13 worldwide locations—sustained 99.5% uptime of global access to 180 satellites/$42B assets despite 40% manning deficit.

  • Air Force Commendation Medal

    Awarded on:

    Invented secure telephone-to-radar interface--expanded the reach of operations centers which provided global vision to commanders, strengthened time-critical decisionmaking, and improved Identify-Friend-or-Foe capability--prevented loss; preserved lives.

  • Air Force Achievement Medal

    Awarded on:

    Designed integrated communications-computer systems using Voice-over-IP and real-time chat for the Air Force Chief of Staff’s $60M next-gen air operations centers.

  • Air Force Achievement Medal

    Awarded on:

    MacGyvered solution in response to catastrophic network failure at a deployed location: rummaged for parts, improvised network gateway/proxy server from scratch, replaced proprietary “black box” solution that caught fire--spares unavailable. Restored service for 1,800 essential personnel--enforced no-fly zones.

Volunteer Work

Volunteer Work

  • Teaching Assistant, Code Platoon

    May, 2020 - Aug, 2020

    Mentored 80+ students

    • Taught computer science (object-oriented and functional programming, data structures, algorithms) concepts and applications one-on-one and in groups.

  • DevOps, Animal Rescue

    Jul, 2006 - Jun, 2007

    Replaced manual, unstructured, fragmented processes with centralized, accessible web services.

    • Implemented open source multi-user volunteer management system web app: consolidated volunteer data collection and storage; automated mailings--increased volunteer engagement 25%.

    • Furnished sign-in kiosks: validated contact information and availability; tracked volunteer hours--accurate automated reports recouped 8 labor-hrs/wk, increased grant funding 10%.

  • Systems Analyst, Non-Profit Private School

    Oct, 2002 - Dec, 2004

    Designed enterprise network—hardware and software—led cross-functional team to implement it.

    • Refurbished 130 donated PCs; installed 17K feet of network cabling, ten network devices; built Internet/extranet servers; trained staff.

    • Provided secure web, email, VPN, content-filtering/monitoring, storage, backup, systems management--brought technology and web-powered learning systems to 350 students.

Interests

Interests

  • Philosophy

    LogicReligionTheology
  • Chess

    LessonsPuzzles
  • Outdoors

    BikingCampingHikingJeeping
  • DIY

    Appliance RepairComputer BuildingVehicle MaintenanceVehicle Modification