Hello I'm Ethan Bonsall
Full-Stack Developer | Data Engineer
UNC Chapel Hill | 3.8 GPA | Computer Science | Data Science
Hello I'm Ethan Bonsall
Full-Stack Developer | Data Engineer
UNC Chapel Hill | 3.8 GPA | Computer Science | Data Science
Experience
Data Science Intern
Marsh McLennan Agency • Raleigh, NC (hybrid)
- Developed a full-stack prototype analytics dashboard using React, TypeScript, Node.js, and FastAPI to help internal teams better understand patient data. Built user-facing features, cleaned and transformed data, implemented optimistic updates and caching, optimized database performance with precomputed tables, and reduced perceived load times through background data loading.
- Skills: React, TypeScript, Node.js, FastAPI, Data Cleaning, Caching
Data Engineer
The University of North Carolina at Chapel Hill • Brain Computer Interface Lab
- Built RTL verification infrastructure using SystemVerilog, SVUnit, and UVM-style testbenches to validate processor modules and ensure functional correctness across core hardware components.
- Developed automated simulation and regression workflows with Questa and Python scripting, improving test coverage, debugging efficiency, and overall verification reliability.
- Implemented reproducible data processing and verification workflows with Pandas and version-controlled datasets, ensuring consistency, traceability, and usability of collected data across experiments.
- Skills: SystemVerilog, SVUnit, UVM, Questa, Python, Pandas
Software Engineer Intern
Sheetz
- Migrated loyalty data pipelines from legacy streaming tables to Delta Live Tables in Databricks, enabling the Ignite loyalty platform.
- Updated Python services to integrate the Sheetz mobile app with the new Ignite loyalty backend.
- Built CI/CD automation with GitLab and ServiceNow to create incident tickets when pipeline or data quality checks failed.
- Developed Python automation to audit 2,000+ database tables for metadata compliance and improve data governance.
- Reduced Databricks job costs by 15% by analyzing pipeline utilization with SQL and Python and identifying unused jobs.
- Created Power BI dashboards and SQL reports to monitor pipeline health and data quality.
- Skills: Python, SQL, Databricks, Git, GitLab, Power BI
Freelance Web Developer
Self Employed
- Designed, developed, and deployed custom full-stack web applications using Next.js, React, TypeScript, PostgreSQL, and Tailwind CSS.
- Built responsive, SEO-optimized websites with features including appointment scheduling, content management, e-commerce, and interactive 3D experiences.
- Collaborated with clients and healthcare professionals to deliver tailored solutions, including a HIPAA-compliant application that automated pediatric nutrient calculations.
- Managed projects from requirements gathering through deployment and ongoing maintenance.
- Skills: Next.js, React, TypeScript, PostgreSQL, Tailwind CSS
Projects
Magic Hour Portraits
A full-stack website built for a photography business. The frontend is developed with Next.js and Tailwind CSS, and deployed via Vercel. The backend is powered by Supabase, serving as both the database and API layer, enabling seamless data retrieval and submission
Pediatric Blue Book
A web app for dietitians to calculate patient nutrient needs and create formula recipes that meet those requirements. Built with Next.js and TypeScript, using Supabase to manage user profiles, saved recipes, nutrient data, and weight benchmarks.
Chad GPT
A chatbot developed for the UNC Computer Science website, built with Angular. Integrates ChatGPT to interpret user input and convert it into API requests, enabling users to check class availability, reserve study rooms, and schedule time with TAs.
Bonsai Property Care
A full-stack website built for a property care business. The frontend is developed with Next.js and Tailwind CSS, and deployed via Vercel. The backend is powered by Supabase, serving as both the database and API layer, enabling seamless data retrieval and submission
Postprofundus
A designer and lifestyle website built for a client, featuring immersive 3D renderings and a fully integrated online shop for apparel purchases. The frontend is developed with Next.js, React, Three.js, and TypeScript, delivering an interactive, performance-optimized experience.
AuditTrail
An open-source Python library for creating tamper-proof audit logs of API activity. Built as plug-and-play middleware for FastAPI, it cryptographically chains log entries, encrypts payloads at rest, and provides CLI verification tools, compliance reporting, and optional enterprise-grade security features.
Main Frame
A retro-styled interactive dashboard featuring a themed login experience, todo chart, and shared goals table. Built with React, TypeScript, and Tailwind CSS, it blends playful 'hacking' aesthetics with real user-driven functionality.
Study Buddy
An all-in-one study platform similar to Discord but designed for school, featuring shared notes, live collaborative documents, study channels, and virtual study rooms. Built with Next.js, Supabase, and Supabase Realtime for real-time collaboration. Contact me if you’d like to see a demo.
Ethan's Birthday
A birthday celebration website with RSVP submissions, photo uploads, and a shared Spotify playlist. Built with a Next.js frontend styled with Tailwind, and a Supabase backend integrating the Spotify API. Supabase for database and file storage.
Beautiful Together
A website built for the animal sanctuary Beautiful Together, React frontend and Supabase backend. Includes a Tinder-like interface to streamline pet adoption. Contributed to preferences, pet ranking system, and design of animal profile cards.
Not Wordle
A Wordle clone built with React and styled using Tailwind CSS.
Education
University of North Carolina at Chapel Hill
Bachelor of Science in Computer Science & Data Science
Coursework
Skills & Technologies
Programming Languages
Java
Python
JavaScript
TypeScript
C++
SQLFrameworks & Libraries
React
Next.js
Angular
Supabase
TensorFlow
Express.js
PostgreSQL
PandasTools & Others
Tableau
CSS
HTML