Data Analyst

Wenting Mo

*******.**@*****.***

**** ******** ***** *******, ** 76542 254-***-**** Status: U.S. Citizen EDUCATION

The University of Texas at Austin Aug 2013 - Dec 2017 Bachelor of Science in Mathematics - Actuarial Science

• Minor in Computer Science (Elements of Computing Certificate) EXPERIENCE

Accounting & Reporting Analyst (Intern), Linda Liu CPA Corp. - Austin, Texas Oct 2016 - May 2017

• Streamlined data analysis & automated reporting workflow that resulted in 50% efficiency gain

• Developed & QA/QC a standard database for bookkeeping and account management

• Managed & successfully delivered ad-hoc data & reporting request to key stakeholders

• Achieved the highest completion percentage in financial and tax preparation services among the intern team Client Relations & Marketing Analyst (Intern), Career Assistance Inc.- Austin, Texas July 2015 - Oct 2015

• Analyzed a data set consisting of 10,000+ data points to identify improvement opportunities

• Led a small project team that successfully developed & executed a customer relationship study

• Interpreted study data with recommendations to enhance marketing strategies for clients ACADEMIC PROJECTS

CS329E Elements of Data Visualization, United Nations Environment Data Visualization Oct 2015 - Dec 2015

• Researched and queried more than 1,000 data observations from United Nations Database

• Using ETL (R) & SQL to clean, manipulate, and filter data for rendering, visualization (Tableau), and data analysis

• Applied innovative analytical approaches to draw correlations for better understanding of global environmental study COMMUNITY INVOLVEMENT/LEADERSHIP

Board of Director Member, Chinese Students & Scholars Association - Austin, Texas Apr 2015 - Present

• Supervised and organized every internal or cultural events and activities for 3 years

• Select, support, and review performance of organization’s executives Vice President; Chinese Students & Scholars Association - Austin, Texas Apr 2014 - Apr 2015

• Directed more than 10 social events which hosted an audience up to 500 people

• Achieved lowest turnover rate in organization history with efficient management

• Introduced and guided new students with academic and cultural questions Student Mentor, OneClass - Online Student Service - Austin, Texas May 2015 - May 2017

• Offered consulting service and support students regarding their assistance need Data Translator (Chinese to English), TripAdvisor - Austin, Texas May 2013 - Present SKILLS

• Proficient in Microsoft Word, Excel, PowerPoint, entry-level experience with Visio

• Intermediate in Python, SQL, R, Tableau, SAS, Google Analytics

• Fluent in Mandarin, intermediate in Cantonese

HONORS AND AWARDS

• Texas Top 10 Percent Scholarship Award

• University Interscholastic League Scholar Award

• President’s Volunteer Service Award

Contact this candidate