About Johnathan Oneal
Thank you for visiting my page. I'm pleased to share a bit about my background and current endeavors.
Professional Experience
Data Engineer
Lightkeeper LLC (Jul 2023 - Present). Contributing to portfolio analytics and reporting solutions for 150+ institutional clients representing over $500 billion in assets under management.
Adjunct Professor, Computer Science
Bunker Hill Community College (Aug 2025 - Present). Teaching courses in computer science focusing on real-world applications and hands-on learning.
Academic Background
Bachelor of Science in Mathematics, Summa Cum Laude
Varsity Football, Student Athlete Advisory Committee Team Representative, Tufts Financial Group, Tufts Trading Club, Library Supervisor, Eco Rep, Brooks Elementary School Read Program
Master of Science in Mathematics
Advanced coursework in mathematical analysis, statistics, and computational methods with applications to data science and machine learning. Grading for MATH 87: Mathematical Modeling, Math and Computer Science Tutor
La Jolla High School
ACT:36 SAT:1560. Football Team Captain, Recipient of the Gene Edwards Award (Athletics wide award for leadership), Defensive and Special Teams Player of the Year, Cum Laude Society, Volunteer Peer Tutor
Recognition & Awards
William Campbell Trophy Semi-Finalist
Recognition for exceptional athletic performance, community service, and academic achievement. Notable recipients include Peyton Manning, Tim Tebow, and Justin Herbert.
CoSIDA Academic All-District
Award recognizing the nation's top student-athletes for their combined performances on the field and in the classroom.
NESCAC All-Sportsmanship Team
Selection recognizing exemplary sportsmanship and leadership both on and off the field.
Four-time NESCAC All-Academic Team
Consecutive honors (2019-2022) recognizing academic excellence while competing at the collegiate level.
Moving Forward
The combination of academics, athletics, and leadership experiences has equipped me with a unique skill set. I look forward to leveraging these abilities in my professional career, continuing to solve complex problems.
I welcome opportunities for professional connection and intellectual exchange. Please feel free to reach out if you'd like to discuss data engineering, mathematics, or sports; especially the intersection of the three.
RESUME
Download PDF ResumeJohnathan O'Neal
Experience
Data Engineer Jul 2023 - Present
Lightkeeper LLC, Boston, MA
- Lightkeeper delivers portfolio analytics software to 150+ institutional clients representing over $500 billion in assets under management.
- Designed and implemented client-specific ETL pipelines from conception to production, ensuring data quality, process efficiency, and business logic integrity. Created centralized systems for FX allocation, basket lookthrough, net attribution, and carveout functionality.
- Engineered end-to-end solutions for multiple Jupyter web applications enhancing internal workflows, including CLI/API toolkit for client services, automated data validation, Zendesk analytics dashboard, log analysis tools, and earnings event tracking.
- Developed and deployed two AI solutions: a RAG chatbot using Llama CPP, Llama Index, Postgres with PGVector, and Gradio interface; and an embedding-based vector similarity search for undocumented code search and discovery.
- Designed comprehensive testing framework with advanced coverage analytics, implemented scalable pytest fixture ecosystem, and optimized data storage methodology, resulting in 10%+ increase in overall code coverage.
Education
Master of Science in Mathematics Dec 2021 - May 2023
Tufts University, Medford, MA
Bachelor of Science in Mathematics, Summa Cum Laude Sep 2018 - Dec 2021
Tufts University, Medford, MA
- Activities: Varsity Football, Student Athlete Advisory Committee Team Representative, Environmental Representative Program, Tufts Financial Group, Tufts Trading Club, Mathematical Modeling teaching assistant, mathematics and coding tutor, and library supervisor.
- William Campbell Trophy Semi-Finalist (Recognition for NCAA football player demonstrating exceptional athletic performance, community service, and academic achievement) - Notable recipients include Peyton Manning, Tim Tebow, and Justin Herbert.
- Earned multiple additional honors including CoSIDA Academic All-District recognition, NESCAC All-Sportsmanship Team selection, two-time Hampshire Honor Society member, and four-time NESCAC All Academic Team honoree.
Projects
Personal Website - HTML, CSS, JavaScript, Jekyll, GitHub Pages (website, source code)
- Constructed a comprehensive portfolio website utilizing GitHub Pages architecture.
- Implemented CI/CD pipelines for various data-driven applications including sports betting arbitrage detector, goal-tracking Telegram bot and heat map, Japanese language learning statistics dashboard, and a Basketball Prediction Bot.
DepotScan - Python, Django, GeoDjango, JavaScript, OpenStreetMap
- Developing industrial real estate application enabling custom parcel mapping functionality, with integrated public records automation for property data population.
- Creating intuitive user dashboard interface for personalized property notation and custom data override capabilities.
ByteSize Travel - Python, SQLite, OpenAI API, AWS Lambda, API Gateway, S3, CloudFront, SES (website, source code)
- Architected sophisticated ETL framework for extracting, transforming, and enhancing thousands of articles from Gmail and RSS sources, leveraging SQL-based selection criteria and multi-agent OpenAI system for content transformation.
- Constructed highly scalable serverless AWS infrastructure combining Lambda/API Gateway for secure subscription management, S3/CloudFront for global content delivery, IAM/Certificate Manager for security, and SES for reliable newsletter distribution.
Skills
- Programming: Python, SQL, C++, Git, JavaScript, HTML/CSS, Jupyter Notebooks
- Data & ML: ETL pipelines, Pandas, Vector Databases (PGVector), Scikit-Learn, PyTorch, LLM frameworks (Llama Index, LangChain)
- Frameworks: Django, AWS (Lambda, API Gateway, S3, CloudFront, SES), CI/CD, Agile, RESTful APIs, Testing (pytest)
- Ongoing Professional Development: Japanese (JLPT N3, ~900 Hours), The Odin Project, TryHackMe, AWS Cloud Practitioner