Data Analyst Assistant

GUANGYU (CASPER) SUN

** * ******* *** **** ***, Clayton, MO 63105

319-***-**** www.linkedin.com/in/Casper-sun *******.***@*****.*** EDUCATION

WASHINGTON UNIVERSITY IN ST LOUIS, OLIN BUSINESS SCHOOL, ST. LOUIS, MO December 2020 Master of Science in Business Analytics, GPA: 3.84/4.00

• Degree qualifies for a STEM designation; eligible for 36 months of OPT (12 months OPT+ 24 months of extension) UNIVERSITY OF IOWA, IOWA CITY, IA May 2018

Bachelor of Business Administration in Business Analytics and Information Systems, GPA: 3.68/4.00 Bachelor of Business Administration in Finance, 3.78/4.00

• University of Iowa Dean’s List, (Spring 2017, Fall 2017, Spring 2018) PROFESSIONAL SKILLS

• SQL

• Tableau

• Hadoop/Spark

• Microsoft Office

• R

• VBA Spreadsheet Programming

• Python NumPy /Pandas…

• STATA

• Machine Learning

• CFA Level II Candidate

• Monte Carlo Simulation

• Business Communication

EXPERIENCE

Teaching Assistant, WASHINGTON UNIVERSITY IN ST LOUIS, St. Louis, MO August 2019 – Present

• Enhanced classroom experience for 40+ students by helping professor in all areas of education in SQL Database Management course

• Assisted professor in teaching course by holding weekly office hours, providing assistance on an individual, small group, or class basis, and offering feedback to students to improve their programming technique and efficiency

• Tutored more than 200+ students in E/R models, SQL Programming, database normalization and advanced SQL queries Computer Vision: Count the Paperclips, St. Louis, MO February 2020 – May 2020 Deep Learning Project Leader (Third Place in the Kaggle Competition)

• Processed images into various formats such as the original image, grayscale image and a copy three times the original image, to demonstrate the different neural network effects

• Improved the accuracy of the model by inverting the limited training images horizontally and vertically to obtain more training images

• Established four layers of CNN and MaxPooling with 64 filters of size 3*3 to achieve the dimensionality reduction effect; the DNN network was built on this basis

• Used the early stop and the check points parameter to avoid overfitting the model

• Reduced MSE by connecting four different DNN models with an ensemble approach INTCO MEDICAL, ONTARIO, CA July 2018 – December 2018 Operating Data Analyst

• Managed and developed sales database for 20 client companies; cleaned and organized data by SQL; generated daily operational reports for the rest of the company by processing data and transferring files

• Compared transporting price data collected from freight forwards from various locations, used Excel to optimize the use of freight forwards and reduced up to 1.5% of land transportation costs

• Analyzed data from the monthly Intco Medical glove business and actual pricing statistics to identify profitable revenue growth opportunities and insights; evaluated short-term sales trends and made recommendations to help company make strategic sales decisions

ACTIVITIES/INTERESTS

• Graduate Teaching Assistant for Big Data – Washington University

• Interests: Saxophone, Basketball, Cooking, Working Out, Traveling and Reading

Contact this candidate