Current areas of work
Data engineering, governance, and full-stack development
Python and SQL ETL processes alongside a React and Java application built with Gradle.
Software Engineer · Wells Fargo
John Yuan.
Software engineer working in data engineering, data governance, and full-stack development with Python, SQL, React, and Java.
Selected work
Featured projects.
Two projects covering constrained optimization and language-model research.
Software
UNC COMP Course Scheduler
A scheduling application that uses integer linear programming to assign courses, instructors, meeting times, and rooms.
View case study ↗Research
LLM Fingerprinting & Digital Watermarking
Research on identifying the source model of AI-generated text from model-specific linguistic patterns.
View case study ↗Experience
Professional experience.
Feb 2026 — PresentCurrent
Wells Fargo
Software Engineer
Building governed data workflows and a full-stack platform for Commercial and Corporate Investment Banking.
Jun 2025 — Aug 2025
Wells Fargo
Software Engineering Intern
Automated high-volume data workflows for Commercial and Corporate Investment Banking.
Jun 2024 — Aug 2024
Truist
Software Engineering Intern — Truist Assist
Improved the delivery pipeline and data lifecycle behind an online banking virtual assistant.
Additional work
More projects.
01
Angular · TypeScript · FastAPI
Equipment Checkout
A full-stack inventory system for browsing, borrowing, returning, and administering club equipment.
02
Angular · TypeScript · RxJS
Registration System
A full-stack check-in application that records users, visits, and timestamps.
03
Java · JavaFX · MVC
Akari Light Up
A desktop implementation of the logic puzzle with responsive state and rule validation.
Technical skills
Skills and technologies.
Languages, frameworks, data tools, and cloud services I have used.
Languages
- Python
- Java
- SQL
- TypeScript
- JavaScript
Data
- ETL
- Data governance
- SQL Server
- Data quality
- Batch processing
Frontend
- React
- Angular
- HTML
- CSS
- RxJS
Backend & build
- FastAPI
- Java services
- Gradle
- Maven
- REST APIs
Cloud & delivery
- AWS Lambda
- DynamoDB
- CloudFormation
- CI/CD
- Agile