John Traylor Email & Phone Number

Los Angeles, Ca, Us

Initially reporting directly to our CTO, I built Python-based data pipelines using a combination of AWS Lambdas, Athena (Presto & Trino), Postgres, Redshift, Pandas, and Jenkins CI/CD, eventually moving to a larger engineering team, working with AWS Managed Workflows for Apache Airflow (MWAA), Apache Iceberg, and Docker in order to lower operating costs via AWS Fargate. I also developed a variety of DevOps tooling during this time, heavily utilizing the GSheets API, Playwright browser scraping, and Python to quickly publish, and automatically update, bespoke team-oriented dashboards and data entry tools which might have otherwise required large development efforts to accomplish. After having the opportunity to expand my knowledge of AWS infrastructure, I am now much more confident about choosing the right AWS tools and services, depending on project scope, scale, and goals.

San Francisco, Ca, Us

I started at Binc as the only Data Engineer on staff, acting as (interim) lead of architecture and engineering, maintaining this status for the duration of my employment. In late 2018, my first task was to build out an in-house Python ETL for Greenhouse (ATS) having feature parity with Greenhouse's expensive BI Connector for Redshift. After completing this ETL project in 3 months, I then overhauled the previous Spreadsheet/Zapier/MySQL-based project tracking system with this Greenhouse/Redshift equivalent, migrating all previous project data to the Greenhouse API via Python scripts I built, while finally making Greenhouse data available for real-time visualization in Looker using Redshift Views and LookML. After I completed this data migration in Apr 2019, I went on to design and develop additional Python ETLs and Redshift schemas, focusing primarily on the BambooHR API in order to make real-time, business logic aware updates possible between our HR system and Redshift data warehouse - a process which previously required maintaining two competing datasets in parallel manually with no source of truth. Later in 2019, we decided to migrate away from Greenhouse to Monday.com, which required me to develop a comprehensive usage protocol for the MondayUI, in addition to a new ETL for the Monday (GraphQL) API, along with all the relevant backwards-compatible Redshift schemas, views, and LookML needed to maintain all Looker dashboards and reports already built. I was then able to migrate most of our Greenhouse data to Monday.com via their API (so the data would be available in the UI, and not just our data warehouse), however, several API endpoints required for complete data migration were not available. In early 2020, I solved this by developing a migration script using Python Puppeteer (pyppeteer) which circumvented these API limitations, achieving full data migration via headless browser automation.

Huntington Beach, California, Us

I was initially responsible for maintaining antiquated Excel-based business intelligence charts, reports, and unformatted data, but quickly worked to design a comprehensive, low-cost accounting and project data pipeline using AutoIT + Python, visualized via Google Data Studio analytics dashboards, and the amazingly helpful Google Sheets QUERY function. Within three months, I was able to develop custom software which allows for easier and faster data transformation, data warehousing, data visualization, and QuickBooks data integrity checking, with the primary goal of providing the features of an expensive business intelligence + data warehousing solution at a fraction of the operating cost. Additionally, I made improvements to other accounting data processes by developing specific Google Apps Scripts to help save employees' time and minimize human error.

Ocean Springs, Ms, Us

I joined this startup company after hearing about the quickie cap invention. I was responsible for handling all website administration and additional design responsibilities, as well as product data integration with other services and optimization of all quality control processes associated with our retail packaged product. In early 2018, I decided to pursue a more dedicated data engineering position.

Los Angeles, Ca, Us

I moved from the Support team to the Development team in order to design customized ETL software (and relevant database schemas for each API source) required to track certain business statistics in near real-time on Grafana+InfluxDB, as well as generate historical reports on PeriscopeData+Amazon Redshift data warehousing (as well as PostgreSQL). Shortly after our company was acquired, our Los Angeles office was closed, but I look forward to developing additional ETL solutions for any platform exposing an API - or, at the very least, a scrapable data surface in the absence of an API.

Los Angeles, Ca, Us

I worked to ensure every customer received the best possible service for CDN integration. Working at MaxCDN Support gave me a great opportunity to begin learning about new distributed architectures and data storage systems.

I was hired by Louisiana High School Correspondence Courses after they acquired the high school correspondence course credit program that was previously offered by LSU DOCE. I built a customized Drupal-based website with an administrative back-end to replace all tedious paper-based business operations and to serve as a web portal for enrolled students.

I worked at Koos to provide general PC/Apple workstation support and to assist my manager with IT infrastructure maintenance, upgrades, and improving internal IT strategies. I designed and deployed a foundational array of automation and replication software while also establishing a scripted strategy to almost completely automate the management of our most critical IT systems, regardless of project feasibility at that time given the circumstances of other pending projects with higher priority.

Baton Rouge, La, Us

I began working at LSU DOCE as a student worker during my senior year at Baton Rouge Magnet High School. I helped to provide computer maintenance and technical support for 40+ departmental workstations and laptops, 30 testing lab workstations, and 40+ HP various-model inkjet printers. I worked with a team of student worker technicians to maintain images for desktops/laptops, resolve employee trouble tickets, repair printers, and utilize remote desktop technology for minor computer issues.

A business associate contracted me to create document processing and synchronization software for use in nationally distributed workstations. My automation software streamlined the weekly form processing workflow and essentially eliminated human error from the tedious editing and server synchronization stages. I was also the only technical support agent for the software as it was being rolled out and updated with new features.

Baton Rouge, La, Us

In order to get more retail and private business experience, I began working here part-time as the sole desktop and laptop repair technician. I diagnosed computer issues with customers, both in-shop and on-site, and replaced broken parts in laptops and desktop computers and worked to resolve any general PC software/hardware issue. I also assisted with various in-house HTML/.Net design and Wordpress/Drupal CMS projects as needed.

Bachelor’S Degree, Bachelor Of Computer Science, College Of Engineering

High School