Ran Duan

- Served as a Section Lead for CSE 247, overseeing studio sessions, guiding 100+ students through hands-on problem-solving, and mentoring 15 fellow TAs in grading, teaching, and fostering collaboration within the team. - Recognized as a top-performing TA for providing detailed responses to 92 student questions on Piazza. - Assisted students with Java code debugging, improving code quality, readability, and efficiency.

- Designed hands-on labs and projects for CSE 427: Cloud Computing With Big Data Applications, focusing on Docker, Kubernetes, and distributed systems using AWS services like EC2, S3, and IAM

- Mentored ACM’s executive team and supported leadership growth while helping guide the chapter’s direction and continuity.

- Led ACM’s executive board, overseeing operations and outreach for a 180+ member tech community. - Spearheaded DevFest WashU 2025, a campus-wide tech conference and hackathon featuring speakers from Google, Amazon, and YC startups, plus workshops, networking, and $1,500+ in prizes. - Planned and hosted a diverse range of events, including General Body Meetings, Boba Social mixers, Raspberry Pi prototyping workshops, and coordination for ICPC Regionals and Nationals participation.

- Engineered config-driven Databricks alert pipelines for duplicate detection and T-2 latency across 15+ Medallion tables using Python, SQL, and JSON, cutting manual monitoring time by 90% and improving scalability. - Enhanced synthetic data generation for 20+ core and hierarchy tables to align with updated enrichment logic for core transactional data, significantly boosting test coverage and reliability. - Produced comprehensive documentation for 20+ Medallion data pipelines—detailing logic, dependencies, lineage, audit tracking, and load processes—to streamline maintenance and accelerate onboarding. - Achieved 1st place out of 42 in the Intern Capture-the-Flag (CTF) cybersecurity competition with a perfect score.

Computational Imaging Group (CIG) Project: Diffusion Models for MRI-to-CT Image Translation with Uncertainty Quantification

- Successfully integrated One-Click Deployment feature, using XL Release technology to automate deployment processes for multiple Global Installments tech assets across STAGE to PROD environments. - Reduced deployment time and minimized manual errors, enhancing efficiency for BizOps and Dev teams. - Remediated 100% of direct dependency vulnerabilities for an API by updating to suggested dependency versions. - Secured 1st place out of 13 teams in the Intern Capture-the-Flag (CTF) competition, solving 94% of challenges.

- Built a responsive landing page and flashcard UI by transforming wireframes into modular React components. - Designed and implemented a user profile management backend in Java, with MongoDB Atlas for storage. - Conducted comprehensive API testing using Postman to ensure reliability and performance. - Led end-to-end (E2E) testing for KnoWhiz app from build to release; wrote and executed comprehensive test cases covering all major user flows and edge cases.

- Configured 100 PCs with custom Windows image & security updates, resulting in 100% deployment success rate. - Utilized Windows Deployment Services to automate the installation of custom operating system configurations. - Implemented a highly efficient electronics recycling process with secure drive wiping and laptop component disassembly, reducing processing time by 40%.