Printable

Résumé.

A concise view of experience, education, and selected projects. Use print to save a PDF.

John Yuan

Software Engineer · Data & Full-Stack Systems

Profile

Software engineer building governed ETL workflows and full-stack financial applications with Python, SQL, React, Java, and Gradle.

Experience

Software Engineer · Wells Fargo

Feb 2026 – Present · Charlotte, NC

  • Build and maintain ETL workflows in Python and SQL, from extraction and transformation through loading into downstream tables and generated files.
  • Lead data-governance proofs of concept that classify, clean, and prepare trustworthy datasets for business partners.
  • Contribute across the React interface and Java services in a Gradle-built application, keeping data pipelines and product behavior aligned.

Software Engineering Intern · Wells Fargo

Jun 2025 – Aug 2025 · Charlotte, NC

  • Engineered four end-to-end Python ETL pipelines processing more than 400,000 entries each week from internal SQL databases.
  • Developed batch scripts that automated extraction, transformation, and loading into target tables and generated files.
  • Supported proofs of concept by cleaning, processing, and formatting data for business partners.

Software Engineering Intern — Truist Assist · Truist

Jun 2024 – Aug 2024

  • Consolidated shared code across AWS Lambda functions, eliminating more than 200 hours of cumulative developer wait time in the traditional CI/CD workflow.
  • Automated deletion of outdated DynamoDB records through CloudFormation for a workflow designed to handle more than 10,000 entries daily.
  • Contributed to sprint planning and delivery in an Agile product team.

Software Engineering Intern — Online Banking · Truist

Jun 2023 – Aug 2023

  • Developed AWS Lambda functions to format account data from internal APIs for analysis by an external vendor.
  • Automated extraction of recurrence, amount, merchant, and related fields from vendor responses.
  • Prepared structured data for digital insights including spending tracking and categorization.

Residential Computing Consultant Manager · Carolina Housing

Nov 2022 – May 2024 · Chapel Hill, NC

  • Led and mentored 25 employees supporting university housing technology and the Carolina Gaming Arena.
  • Managed scheduling, hiring, equipment maintenance, training, and operational policy.
  • Directed service-level practices that supported more than 6,000 residents.

Education

University of North Carolina at Chapel Hill

M.S. Computer Science

Projects

Akari Light Up

A desktop implementation of the logic puzzle with responsive state and rule validation. Java · JavaFX · MVC · Maven

Equipment Checkout

A full-stack inventory system for browsing, borrowing, returning, and administering club equipment. Angular · TypeScript · FastAPI · Python · SQLAlchemy

Registration System

A full-stack check-in application that records users, visits, and timestamps. Angular · TypeScript · RxJS · FastAPI · Python

UNC COMP Course Scheduler

A scheduling application that uses integer linear programming to assign courses, instructors, meeting times, and rooms. Python · Integer Linear Programming · SQLite · React · GitHub Actions

Skills

Python · Java · SQL · TypeScript · React · Angular · FastAPI · Gradle · ETL · Data governance · AWS Lambda · DynamoDB · CloudFormation · CI/CD

Esc
HomeOverviewWorkExperienceProjectsCase studiesAboutBackgroundRésuméPrint viewGitHub ↗CodeLinkedIn ↗Connect