SAS,R Excle,VBA, Tableau, Java

SHU TAN

Sacramento, CA *****

352-***-**** • **********@*****.***

EDUCATION

Master of Information Systems and Operations Management May 2015

University of Florida (Gainesville, FL)

Bachelor of Engineering in Computer Science June 2013

Science and Technology University of Changsha (Changsha, China)

EXPERIENCE

Database Analyst Intern May 2014-Aug 2014

Sporting Odyssey (Gainesville, FL)

Assisted in the improvement of ETL processes of database behind web trading platform of Sportody.com

Added over 600 sport providers basic information among 40 countries in Sport Odyssey database

Modified mass data of sport providers’ information and extract relevant data to create charts and updated business location in self-developed map system

Developed SDLC of Sportody mobile application and tested functions of our beta version

Utilized Search engine optimization to optimize Web site search rankings and improved functionality of company database

Network and System Intern and Financial Products Sales Intern May 2013-Aug 2013

Bank of China (Yinchuan, China)

Tested and debugged account management system. Helped staffs shooting errors in their system operation

Researched functionalities of popular security gateways applied in banks and did presentations

Introduced risks and benefits of our fund products to clients

PROJECTS

Determinants of Executive Compensation March 2015-May 2015

Identified and recommended all information team needs to better access models and potential behavior

Promoted the use of SAS JMP and STATA in team by developing and delivering presentations on variables affect executive compensation

Developed regression models to evaluate CEOs’ salary. Estimated and interpreted errors by statistical parameters

Official Hospital Compare Data Analysis Jan 2015-Feb 2015

Collected, inputted, verified, corrected, and analyzed data out of 15 Excel files from Medicare.gov

Conducted analysis using SAS and SQL to build charts describing hospital care levels in America

Pollution-Monitoring Data Analysis July 2014-Aug 2014

Leveraged R to process comma-separated-value (CSV) files containing pollution-monitoring data for fine particulate matter (PM) air pollution at 332 locations in the United States

Contracted independent analysis and designed an automatic report system base on the air pollution in the United States

Network Shopping Consumer Model Jun 2013-Sep 2013

Partnered with other two members to analyze current online shopping models, managed project schedules, and evaluation of possible new features for updated programs

Designed a program that imitates real online shopping process by Java, which includes login, purchasing, and feedback

Created a database, which contains personal customers information, products, and customers feedback

CERTIFICTES

SAS Certificated Base Programmer 2015

SKILLS

Programming Languages: Java, C, C#, VB

Data Mining Tools: SAS, R, XLMINER, STATA, Tableau

Database: SQL Server, Oracle, MS Access, MySQL

Language: English, Chinese

Contact this candidate