Yufan Yu

774-***-**** **** Crescent St. Apt ****

ac6ujb@r.postjobfree.com 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.

Contact this candidate