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