SHUXIN (SHIRLEY) DONG

Address: **** ******* **., ***. *, Sun Prairie, WI, 53590

Phone: 414-***-**** Email: ac8foo@r.postjobfree.com

VISA STATUS

Authorized to work in the U.S. (Green Card)

CORE SKILLS

Database/Data Warehouse – MS SQL Server, Oracle, MySQL

Data Related Programming Languages – SQL, C#, DAX, M

Other Programming Languages – Java, C, C++, Visual Basic, ML, Scala, HTML, CSS, Javascript, JQuery

IDE & DB Tools – Microsoft Visual Studio, MS Visio, SSMS, SSRS, SSIS, Erwin, Google Analytics, Power BI, Tableau

Analytical Modeling – Quantitative methods, statistical models and optimization concepts

Modeling Software – EViews, Stata, SAS, ModelSim, SAP PROFESSIONAL EXPERIENCE

YOOZOO GAMES CO., LTD., Shanghai, China (June 2017 - August 2017) User Researcher Intern

• Collaborated with the Data Mining team to clean the data extracted from the primary source and secondary source.

• Created schema, views and stored tables in SQL Database.

• Utilized SQL to extract, compile and track data of over 30,000 game products and 1.1 billion user devices from Hadoop.

• Analyzed and generated market performance and prediction reports weekly, monthly and quarterly.

• Assisted in the administration of Hadoop and Hive including OOM problem solving, the cluster health monitoring and daily maintenance, which helped to decrease the running time by 12.3%.

• Coordinated with the management team to conduct new products screening and risk management. PROJECTS

ChronoTimer (Sring 2017)

University of Wisconsin - Milwaukee

• Developed a simulate sports timer in Java, allowing the user to monitor the games, track the racers and generate the result records manually or automatically.

• Exported the records to webpage using JQuery, JavaScript, HTML and CSS, and XML format.

• Implemented the ChronoTimer on ModelSim-Altera, supporting all connected devices and functionalities. Real Estate Price Modeling (Spring 2014)

University of Wisconsin - Milwaukee

• Cleaned and processed 30 years real estate price data using Stationarity test (ACF and PACF Graphs) and ADF test.

• Built primary Regression Model (ARIMA Model) on EViews to analyze and predict the real estate price in 5 years.

• Run Model Diagnostics (Q-Statistics Value and white noise) to test the Model fits and determine the Hypotheses acceptance.

EDUCATION

UNIVERSITY OF WISCONSIN - MILWAUKEE, Bachelor of Science – Computer Science (2018) UNIVERSITY OF WISCONSIN - MILWAUKEE, Master of Arts – Economics (2014) XIANDA ECONOMICS AND HUMANITIES COLLEGE OF SHANGHAI INTERNATIONAL STUDIES UNIVERSITY, Shanghai, China, Bachelor of Arts – Major: Finance (2013) FUDAN UNIVERSITY, Shanghai, China, Bachelor of Arts – Minor: Law (2012) OTHER EXPERIENCE

ARDISAM INC, Shanghai, China, Office Assistant (January - August, 2013) COMMERZBANK AG., Shanghai, China, Compliance Intern (June - August, 2012) CHINA CONSTRUCTION BANK, Shanghai, China, Mortgage Intern (June - August, 2011) PROFESSIONAL CERTIFICATION

Google Analytics for Power Users

Contact this candidate