Yunhua Sun

* ******* *******, ******, ** ***** 815-***-**** aceaj8@r.postjobfree.com

SUMMARY

• M.S. in Management Information Systems with strong data analysis background

• Solid Understanding of SQL Server and most major relational databases

• Outstanding interpersonal and communication skills along with strong work ethic

• Strong problem solving skills and attention to detail

EDUCATION

M.S. Management Information Systems (MIS) GPA: 3.9/4.0 Aug. 2014

Northern Illinois University, College of Business, DeKalb, Illinois

• Certificate in Business Analytics using SAP (SAP University Alliances)

B.S. Tourism Business Management, Jun. 2011

Institute for Tourism Studies, Macau

EXPERIENCE

Teaching Assistant, OM&IS Dep. NIU Jun. 2013-Present

• Lead discussion on topics including database design and SQL queries for the classes of 70 students.

• Planned and developed various teaching strategies such as charts, and graphs to help students understood

content and engaged in class discussion.

• Organized monthly discussion for better teaching and coordination feedback.

• Developed new methods to improve work efficiency in grade recording system.

Statistical Assistant, Asian American Center Mar. 2013-Jul.2013

• Communicated with client for project requirements and interpreted verbal descriptions into surveys to attain reliable

data for future analysis.

• Performed data analysis: identified student insight and top trends in student enrollment.

• Analyzed and interpreted data, and report results in the form of graphs, charts, and tables.

• Provided recommendations of determining the best practices for recruiting, program planning, collaborative efforts

and staff modelling.

Marketing Researcher, The Last Resort, Nepal Feb. 2010-May.2010

• Conducted market research on outdoor tourism to assess customer preference, and determined company’s

position in the marketplace.

• Forecasted marketing trends, and provided actionable recommendations based on industry best practices resulting

in a 10% increase in volume of sales.

• Negotiated sales agreements with travel agencies and airlines.

• Helped develop advertising brochures, sales plans, and product promotions.

ACADEMIC PROJECTS

E-commerce site (Individual project) Jan. 2014-May.2014

• Developed a database driven web application which provided user registration, login, file uploading, shopping cart,

email confirmation, and managerial report functions.

• Hand-coded PHP and JavaScript from scratch and did cross-browser testing for the website.

• Provided secure access to web application servers by preventing SQL injection, and configuring MySQL user

privileges levels.

IT Audit project sponsored by Health Care Service Corporation Jan. 2014-May. 2014

• Applied COSO and COBIT framework to manage IT risk for a case study.

• Developed audit test plan, conducted the audit, and provided recommendation for NIU’s Data Center.

Web application for Perpetual Amity Furnishings and Travels Inc. (Team project) Sep.2013-Dec.2013

URL: www.perpetualamity.org

• Developed a web application using MS Visual Studio and SQL Server that enabled users to submit an inquiry, order

services and sign up for promotional emails.

• Solved inventory management problems, and provided automatic reporting functions for internal user.

• Designed user-friendly interfaces to improve overall user satisfaction.

• Delivered real-time updates to users.

TECHINCAL SKILLS

• Programming Language: Visual Studio and ASP.NET, PHP, AJAX, JavaScript, and CSS

• Systems Analysis: Process Modeling, Data Modeling, SDLC, and Agile Scrum

• SAP systems: SAP ERP configuration, SAP (FI/CO, MM, and SD modules), Crystal Report, and Dashboard.

• Statistical: SPSS Statistics, and Excel Analysis ToolPak

• Database: Structure Query Language (SQL), Database design, most major relational databases management

including MS SQL Server and MS Access, MySQL

Contact this candidate