Hi , my name is

John Swindell.

Technical Lead | CS Student

Computer Science candidate architecting scalable data pipelines and automation systems. I translate complex requirements into production-grade infrastructure, with a focus on advancing in AI, ETL, and Cloud Architecture.

Download Resume

About Me

I’m a Technical Lead and Senior CS student who loves building scalable architecture from the ground up. I focus on systems that handle complexity, whether that’s processing 250k+ daily crypto records or automating onboarding for a 30-person engineering cohort.

Currently, I lead infrastructure at Tekly Studio, managing the GCP and Python ETL pipelines behind our quantitative research. I believe in a fail-fast approach and that good architecture is what separates a script from a system. I operate on Agile principles and am currently diving deeper into DevSecOps.

Core Technologies:

Python (Pandas, NumPy, Google API)
Google Cloud Platform (GCS, Cloud Run)
Docker & Containerization
Machine Learning (CatBoost, Scikit-Learn)
Git & GitHub
SQL / NoSQL / TiDB
CI/CD & GitHub Actions
Technical Writing & Documentation
MS365 Office Suite
Adobe Creative Suite

Professional Experience

Technical Lead - Tekly Studio

Dec 2025 - Present

Selected to lead the Spring ‘26 engineering cohort and oversee critical data infrastructure following a successful tenure at Crypt0nest (a Tekly Studio partner).

Architected a Zero-Touch Onboarding Pipeline: Designed and deployed an event-driven automation system using Python, Airtable, DocuSign, and GitHub Actions. The system handles the entire lifecycle for 30+ engineers, from contract generation to infrastructure provisioning, reducing administrative overhead by 90%.
Headless LMS Implementation: Engineered a custom Learning Management System using the Google Drive and Docs APIs to dynamically generate curriculum materials and enforce role-based access control (RBAC) based on intern tracks.
Infrastructure Leadership: Managing the maintenance and scaling of the core ETL pipeline, ensuring high availability for downstream quantitative research teams.
Cloud Architecture: Overseeing GCP resource allocation and Docker container orchestration while maintaining comprehensive architectural documentation for executive stakeholders.

Data Engineering Lead Intern - Crypt0nest.io

Jun 2024 - Sept 2025

Spearheaded the development of a survivorship-bias-free data pipeline for a Tekly Studio partner to support quantitative trading research.

ETL Architecture: Designed and implemented a scalable ETL framework that ingests, cleans, and transforms raw multi-source data (CoinGecko, DeFiLlama) into optimized Parquet datasets.
Cost Optimization: Engineered a two-tier caching strategy that reduced external API load by 90% while significantly increasing data throughput and availability.
Data Quality: Architected a Silver Layer validation framework to enforce schema integrity and data quality across 250k+ daily records.
Robust Ingestion: Developed resilient Python parsers to handle complex, nested JSON schemas and rate-limited API endpoints.

Google Search Quality Rater - RWS Group Ltd.

October 2023 - January 2024

Worked on training and optimizing search algorithms on evolving search patterns and user behavior trends.
Maintained and ensured high levels of accuracy and consistency in evaluating search engine algorithm outputs.
Provided insights to improve search engine optimization strategies, content quality, and overall user experience.

Senior Server Administrator - Repulsion Ltd.

October 2021 - October 2023

Promoted to Senior Server Administrator in the first year for demonstrating technical expertise and leadership.
Managed and optimized 16 servers across multiple regions, improving performance and reducing downtime.
Utilized Linux and Pterodactyl to maintain server infrastructure, troubleshooting issues and optimizing code.
Acted as a key liaison for customer issues, ensuring satisfaction through problem resolution and communication.

Server Administrator - Rustynation LLC.

August 2020 - October 2021

Developed and maintained server infrastructure, including player data analysis using Arkan and Battlemetrics.
Conducted quality assurance tests on server performance and user interactions, identifying and resolving issues.
Composed public announcements and events for community engagement via Discord and website updates.

Education

Expected: May 2026

Bachelor of Science in Computer Science

Southern New Hampshire University

GPA: 3.97 / 4.0

SNHU President’s List: 2024 - 2026

Relevant Coursework:

Applied Statistics for STEM (Python, Pandas, NumPy, SciPy): Leveraged Python libraries to analyze complex datasets and derive actionable insights.
Object Oriented Programming (Java): Engineered modular and reusable software components by applying core OOP principles (encapsulation, inheritance, polymorphism).
Data Structures and Algorithms: Implemented and analyzed various data structures and algorithms to optimize solutions for complex computational problems.
Foundation in C++ Programming: Built efficient applications in C++, gaining experience in memory management and performance optimization.
Operating Systems: Explored core OS concepts like process scheduling, memory management, and concurrency to understand system-level interactions.
Software Engineering Principles: Collaboratively developed a software project using agile methodologies, managing the full development lifecycle from requirements to a functional prototype.

Projects

Python GitHub Actions Platform Engineering DocuSign API Airtable API OpenAI API

Automated Onboarding Pipeline & Headless LMS

Architected a zero-touch hiring pipeline using Python micro-services to scale an internship cohort of 30+ engineers. The system orchestrates Airtable, DocuSign, and GitHub Actions to automate the entire lifecycle, from contract generation and signature verification to infrastructure provisioning, reducing administrative overhead by 90%.

Read Architecture Breakdown

Python Machine Learning CatBoost QuantStats Walk-Forward Validation

ML-Driven Quant Research Model

A backtesting framework utilizing CatBoost and Anchored Walk-Forward Validation. Engineered to detect overfitting and validate potential alpha quickly via rigorous risk diagnostics (Sharpe, Sortino, Volatility Targeting)

Read Case Study

Python Google Cloud Platform Docker

Automated Crypto Data Pipeline

A containerized ETL pipeline architected on GCP to solve lookahead bias. Orchestrates multi-source ingestion (Market, On-Chain, Social) with strict Bronze/Silver quality gates and Point-in-Time feature engineering.

Read Architecture Breakdown

Python SQL MySQL Database Design Automation TiDB Cloud ERD

Portfolio SQL Schema & Python Automation

Comprehensive project showcasing the development of a relational SQL database (MySQL) for managing portfolio data. This includes Python scripts enabling automated database initialization, CRUD operations, sophisticated data querying, and reliable connectivity with a TiDB Cloud database for cloud-based persistence and access.

View on GitHub

Python Asyncio BeautifulSoup Discord.py

Async Discord Monitor

Real-time inventory tracker built on a non-blocking asyncio architecture. Features a custom offline testing harness for safe DOM parsing and maintains a persistent WebSocket connection for zero-latency alerts.

Read About This Project

Web Development HTML Tailwind CSS CSS JavaScript

Created Main Club Website

Developed and maintain the primary public-facing website for Coding United. This site serves as a central information point, integrated with all club GitHub resources, and built with HTML, Tailwind CSS, and JavaScript for a modern, responsive experience.

View Club Website

HTML CSS JavaScript UI/UX Design Educational Tool Web Development AI / LLM Gemini API Cloudflare Workers

Computer Science Student Career Skill Explorer

Developed a web tool for CS students and club members to explore career paths and self-assess skills. Users complete checklists, and upon generating a summary, a Cloudflare Worker securely calls the Gemini API giving a personalized rundown of their current strengths, areas for further development, and career path alignments.

View Skill Explorer

Python Docker Developer Tools Technical Writing Git

Developer Onboarding Templates (Python & Docker)

Designed and implemented standardized, well-documented starter templates for Python (with venv/PyCharm guidance) and Docker. These templates streamline project initiation for Coding United members, promote best practices, and lower the barrier to entry for new coders.

View Docker Template

GitHub Documentation Community Building Markdown Leadership

Coding United - GitHub Ecosystem & Resource Hub

Led the collaborative initiative to structure and build out Coding United's GitHub organization. This involved creating a central 'Club Hub' guide for member onboarding and information, an 'Awesome Resources' list for community learning, establishing documentation standards (Code of Conduct, Contributing Guidelines), and designing the main organization profile to enhance engagement and resource accessibility.

View Club Hub

Leadership, Contributions & Honors

Contact Me

If you’d like to get in touch, my business email is below.