YIFAN WANG

**** **** ******** ****, ********* G**1, FORT COLLINS, COLORADO 80526

970-***-****

acwzy5@r.postjobfree.com

JOB TITLE

AREAS OF FOCUS: SOFTWARE DEVELOPMENT - WEBSITE DESIGN - DATABASE ADMINISTRATION

QUALIFICATIONS PROFILE

Dedicated, innovative, and highly organized individual, offering comprehensive knowledge of software

development, website development, and database administration; seeking an entry-level position to utilize

and enhance skills acquired from strong academic foundation. Known as an effective team player, with the

capability to collaborate with team to meet organizational goals. Expert at utilizing mathematical and

statistical aptitudes in facilitating operations research. Technically competent in identifying issues

and gathering data to ensure quality performance and timely completion of assigned projects. Articulate

communicator, with strong fluency in verbal and written Mandarin Chinese.

EDUCATION

MASTER’S DEGREE IN COMPUTER INFORMATION SYSTEM, Aug 2016

Colorado State University - Fort Collins, CO

GPA: 3.77

BACHELOR’S DEGREE IN COMPUTER SCIENCE, July 2014

North China Electric Power University - Beijing, China

CORE COMPETENCIES

- Skills in problem solving, decision making, and business opportunity identification

- Familiarity with different information technology curriculum such as object-oriented and web-

based software; object model describing classes; and objects relationships, attributes, and technical

operations

- Capability of identifying patterns and relationships among key variables by implementing data

mining, data exploration, and large data amount modeling

- Knowledgeable of database analysis, design, and administration; data and business modeling; data

sublanguages; query facilities; and distributed database systems

ACADEMIC PROJECTS

Project Name: Data Mining and Analytics Project (2015)

Objective: Identification of different type crimes in San Francisco based on location, date, and day

Role: Analytical Models Designer

Description

- Evaluated data provided by Police Department’s CompStat database of crimes in San Francisco

utilizing SAS Enterprise Miner

- Made use of analytical models, including decision tree, regression, neural network, and

descriptive statistic to assess the relationship between type of crimes occurrence and time or area

Project Name: Visual Basic Programming Project, Theme Park Management System (2015)

Objective: Establishment of a system in VB.net, to implement functionality in theme park management

Role: UI designer, programmer, and tester

Description

- Took charge of designing the user interface

- Keenly reviewed the customer needs and requirement based on the provided use case diagram and

class diagram

Project Name: UML Business Modeling Project, Denver International Airport (DIA) Parking Lot Enforcement

Solution (2015)

Objective: Establishment of an innovative solution to enhance parking service utilizing various UML

diagram

Role: Current situation analyzer and report writer

Description

- Applied keen attention to detail in assessing the weakness of current DIA parking lot management

system

Project Name: Network-Relevant Project, SSH (Keys, Scp, Remote Command Execution) (2016)

Objective: Expert setup of the network connection

Role: (Individual Project)

Description

- Devised several remote virtual machines while implementing the remote Linux command by setting

the paired keys

Project Name: Database Management Project, Analyzing Vehicles Sales Data and Create Stored Procedure to

Improve Data Security (2016)

Objective: Vehicles sales data query, management, and analysis provided by a public database; and

utilization of stored procedure to prevent potential data injection

Role: (Individual Project)

Description

- Prevented potential injection attack by building the stored procedure

- Formulated database SQL queries in response to end-user questions/requests through Microsoft SQL

Server and Transact-SQL (T-SQL)

Project Name: Web Design Project, Develop a Ski Gear Online Sale Website based on ASP and PHP Project

(2016)

Objective: Design of two websites to enable users to purchase or rent ski gear online utilizing PHP and

ASP

Role: Database Connection

Description

- Maintain active communication with database to save, update, and search data needed by users

PROFESSIONAL TRAINING

English Professional Training Program - INTO Colorado State University

ACTIVITIES

Minister of Liaison, Department of the Students’ Union

North China Electric Power University - Beijing, China

TECHNICAL SKILLS

MICROSOFT OFFICE SUITE: Excel - Word -PowerPoint

PROGRAMMING LANGUAGES: Visual Basic - Java - PowerShell Script - ASP - PHP - HTML - SQL query

SOFTWARE: SAS Enterprise/Guide - Visual Studio - Lumira - NetBeans - Eclipse - MySQL

DATA-RELEVANT/BUSINESS MODELING SKILLS: Data Statistic - Data Visualization - Database management -

Unified Modeling Language (UML) Modeling

OPERATING SYSTEMS Linux - Microsoft - Mac OS X

Contact this candidate