JAKE LAKE


Team Goblin consulting clients

Team Goblin is my independent consultancy for select web and data engagements.


Data & Platform

Health plan data platform

For Linkwell Health
  • Co-designed a medallion architecture (bronze / silver / gold plus a pre-aggregated reporting layer for fast dashboards) on Azure Databricks and Delta Lake
  • Built ~12 production PySpark pipelines (50+ jobs): per-client ETL, event-driven ingestion over Azure Service Bus, conversion-data pipelines, backfills
  • Daily feeds from under 100 rows to 5M+ rows; a latency-critical pipeline driving live text messages runs in ~2 minutes against a 5-minute SLA
  • Fed member audiences into Braze for SMS and outreach, and handled Braze webhooks in real time
  • Terraform / Terragrunt infrastructure and GitHub Actions CI/CD built from scratch

Databricks, PySpark, Delta Lake, Spark SQL, Azure, Service Bus, Braze, Terraform, Terragrunt, GitHub Actions, Python

Automated reporting ETL

For Hybrent
  • Created an automated process for ELT/ETL of data to be used in daily/weekly/monthly reporting
  • Allowed data to be generated via Slack commands
  • Mentored and consulted development teams on how and why to use git for source code management

PHP, MySQL, Slack integrations, DevOps, CRON, Jenkins, Bash, CI/CD, DynamoDB, RDS, S3, Redis, git, CentOS

Lead sourcing pipeline and CRM migration

For BlueArch
  • Helped source 35,000 new potential clients
  • Migrated existing clients and new leads to a brand new custom CRM
  • Advised on next steps with CRM to automagically identify updates on clients and when to reach out to them

Python, Postgres, DevOps, Linux, Web scraping, CRM, JSON, git, Dashboards, HTML, CSS, PDF, ETL/ELT

Cloud reliability and DevOps

For MustHaveMenus
  • Coordinated DevOps efforts across different cloud architectures to increase scalability, improve uptime and performance, streamline builds, and decrease costs
  • Added monitoring, load balancing, and fixed some underlying storage issues for the system

DevOps, HAProxy, Zabbix, Bash, Linux, Tables, Graphs, RDS


Federal & Public Sector

OPM.gov and OPM One rebuild

With Oddball, for OPM
  • Rebuilt OPM.gov (1M+ monthly users) and the OPM One intranet on Drupal 10 + USWDS
  • Owned theming, custom modules, and the search.gov integration in Acquia Cloud IDE
  • Consolidated ~3,000 legacy pages into ~300
  • Section 508 / WCAG throughout
  • Brought to launch-ready on schedule; the program was cancelled before go-live in the 2025 federal contract cuts

Drupal 10, USWDS, Section 508, WCAG, PHP, Twig, SASS, JS, search.gov, Acquia Cloud IDE, Drush, Composer, git, Agile/Scrum

Medicare.gov notifications

With Oddball, for CMS
  • Integrated the GovDelivery API for email and SMS reminders
  • Built the preferences application in React / TypeScript and Go
  • Ingested streaming event data through queues and AWS Lambda into the system that drove the notification sends

GovDelivery API, React, TypeScript, Go, LaunchDarkly, AWS Lambda, Queues, Streaming data, REST APIs, Section 508, WCAG, git, Agile/Scrum

Drupal 7 to 8 module ports and Maestro DAM

With ECS Federal (client: DHS)
  • Ported a myriad of Drupal 7 modules to Drupal 8
  • Worked on Maestro DAM

Drupal 7/8, Maestro DAM, PHP, Events, CRON, Queues, Batches, cURL, FTP, CDN, Grid/Flex, Media Queries, SASS, Drush

FCC daily briefings, ReliefWeb redesign, USDA school lunch planner

With Seabourne, for the FCC, ReliefWeb, and HealthE
  • Engineered an automated import/parse process to simplify and digitize all of the FCC's daily briefings
  • Supervised the development of a redesign implementation for ReliefWeb that allowed their users to consume information easily - delivered on time and on budget
  • Implemented a standardized meal nutrient calculator for a USDA certified school lunch planning web application

Drupal 6/7, Headless Drupal, PHP, REST API consumption, Creating a REST API, JS, HTML, CSS, git, Caching, TDD, Zend Framework, MySQL, AWS, Solution Architect, UI/UX, Virtual Machines, Compass


Commerce & Product

Checkout engine and SSO

For The Shade Store
  • Designed and implemented a Single Sign On (SSO) integration for internal applications interfacing with OneLogin (with Namely as the source of truth) to simplify user accounts and password management
  • Crafted a BrainTree payment engine solution that could be easily dropped in anywhere to standardize the checkout process across all points of sale available which led to an increase in sales and reduction in administration time

PHP, CodeIgniter, Symfony, HTML, CSS, Bootstrap, Solution Architect, JS, JSON, Security, REST APIs, Payment Gateways

Client portal, SSO, and marketing site

For Intelligent Medical Objects
  • Developed a custom oAuth Single Sign On integration for Drupal 7 and 8 sites that simplified user sign up and sign in processes
  • Created and maintained multiple client facing web applications that attracted thousands of customers monthly to help keep them informed of updates
  • Defined internal process on generating quarterly changefiles to communicate with clients
  • Redesigned main marketing website to be KPI centric and drive not only traffic but also interaction which led to increased sales and client communication
  • Created credentialed client self-serve web application with content catered to each client that decreased customer support calls/emails and increased customer satisfaction
  • Contributed to HackIllinois team by crafting event specific microsites and by attending the event and interacting with hackers through hidden Easter eggs in the sites that when found led to prizes which increased awareness of company at the event

SSO, PHP, MySQL, Drupal 7/8, Solution Architect, oAuth, JIRA, Agile, Scrum, JS, jQuery, REST API consumption, Python, TDD, HTML, Bootstrap, Design, MVP, KPIs, A/B Testing, CI/CD, AWS, Google Analytics, RDS, S3, Localization, Revisions, Versioning, Workflows, Drush

NBC Summer Olympics Layout Manager

With Seabourne, for NBC
  • Redeveloped the Layout Manager module in Drupal 7 for NBC to use on their Summer Olympics website

Drupal 7, PHP, Custom modules, JS, HTML, CSS, Caching, git

Online course store in 6 weeks

For IPC
  • Developed a Drupal 8 web store for online courses/training on an extreme turn around (6 weeks)

PHP, Drupal 8, Acquia BLT, VMs, MySQL, Groups, TWIG, APIs, Custom Entities, Rules, Workflows


Drupal Consulting

Alteryx Help site

For Alteryx
  • Migrated Help site from Drupal 8 to Drupal 9
  • Added new interfaces, data management, translation and localization and other features to Drupal site, Grid/Flex, Media Queries

Drupal 8/9, Views, Core APIs, PHP, JS, HTML, SASS, Acquia, Localization, Revisions, Versioning, Workflows, Rules, Drush, composer, git, bash

Seven sites into one

For PolyOne / Avient
  • Refactored seven legacy sites into a single Drupal 7 site
  • Added social media integration via API
  • Built several custom WYSIWYG plugins for CKEditor
  • Won a Kapost award for site creativity and efficiency

Drupal 7, PHP, CSS, HTML, JS, Custom modules, Custom theming, REST APIs, Compass

Healthcare site refresh and Drupal 8 migration

For Philips Healthcare
  • Updated Philips Healthcare site to match new corporate look and feel
  • Made site easier to navigate and more intuitive along with adding new technologies
  • Migrated from Drupal 7 to Drupal 8

Drupal 7/8, PHP, MySQL, JS, HTML, SASS

concrete5 to Drupal 8 migration

For Ameren
  • Migrated a concrete 5 website to Drupal 8
  • Splashed on a new responsive interface that was clean and catchy
  • Fixed quite a few bugs they had been having to deal with from their old site

Drupal 8, HTML, CSS, JS, PHP, MySQL, AWS

Job search performance and UX

For Engineering People
  • Fixed site slowness due to Drupal database complexity
  • Updated UI/UX for a low cost high impact design
  • Added and fixed search functionality for job seekers on the site

PHP, Drupal 7, HTML, SASS, JS, MySQL, SOLR

© JAKE LAKE · SENIOR ENGINEER: DATA PLATFORMS & WEB