Yufan Yu
774-***-**** **** Crescent St. Apt ****
*********@**.*** Long Island City, NY 11101
EDUCATION
Assumption College, Worcester, MA May 2018
Bachelor of Arts in Computer Science
TECHNICAL SKILLS
Programming: C++, Visual Basic, PHP, SQL, Bash, CSS, HTML5
Software: Access, Excel, Word, PowerPoint, Illustrator, Photoshop
PROJECTS
Database Management Systems:
Designed and developed a complete system for a real estate agency using MS Access to aid the sale and lease of private and commercial properties.
Created complete relational schema using SQL normalization, ERD, Storage Organization, and indexes.
Implemented and optimized SQL queries for database design and maintenance.
Data Structures:
Created and developed a windows application that allows users to do basic arithmetic.
Developed and implemented a windows application that allows users to draw geometries with different colors.
Network Security
Designed network security management using C++.
Improved the program’s information security by implementing encryption and decryption functions.
Analyzed and researched the relationship of network security and computer viruses.
EXPERIENCE AND ACTIVITIES
Bestsch Inc. June 2017 –August 2017
Web Developer Intern China
Worked with developers to manage large, complex design projects for different clients.
Partner with designers to create neat interfaces and simple, intuitive interactions.
Executed quality assurance tests to identify errors and optimize usability.
Community Residents Committee June 2016 –August 2016
Intern China
Automated the data collection process of retirement insurance using VBA Macro.
Increased the efficiency by approximately 50% and reduced the chance of error significantly.
Chess Club September 2014 –May 2018
Member Worcester, MA
Taught students fundamental principles of Chinese Chess.
Organized competitions among members on a quarterly basis to improve each individual’s skills.