Sign in

data analysis

Seattle, WA
October 23, 2018

Contact this candidate


Ruizhi (Claire) Hou

Seattle, Washington ***** 217-***-**** EDUCATION

University of Washington-Michael G. Foster School of Business Seattle, WA Master of Science in Information Systems Expected June 2019 University of Illinois at Urbana-Champaign Urbana, IL Master of Science in Accountancy & CPA Candidate with GPA 3.51/4.00 May 2018 Jinan University Guangzhou, China

Bachelor of Arts, Majored in English Translation and Interpreting with GPA 3.80/4.00 June 2017 Bachelor of Economics, Double Majored in Financial Engineering with GPA 3.80/4.00 June 2017 INTERNSHIP

Deloitte & Touche LLP Shenzhen, China

Tax Intern, Business and Tax Advisory November 2016 – January 2017

• Communicated with clients via email and in-person visit to effectively understand the clients’ needs and requirements on tax, creating tax saving strategies accordingly and helping clients implement tax plan

• Assisted with drafting related tax work paper, analyzing and predicting the impact of replacing Business Tax with Value Added Tax for a property management company by using PivotTable and R Morgan Stanley Huaxin Fund Management Co., Ltd. Shenzhen, China Compliance Intern, Compliance Department August 2016 – October 2016

• Developed VBA tools to check stock positions in 40 portfolios and identified the abnormal position, increasing the efficiency of compliance analysis by 30%

• Utilized SQL to retrieve data from database and Solver/Solver Table in Excel to calculate portfolios’ risk ratios, such as Sharpe Ratio, to estimate and rank the performance of portfolios for investors Nielsen Company Guangzhou, China

Statistical Consulting & Analysis Intern, Finance Team January 2016 – March 2016

• Manually checked and corrected errors in historical database which had 20,000+ records in total, helping reduce the missing information rate from 20% to <5% and remove 100+ duplicated records

• Applied lean six sigma to identify causes for 110+ private equity firms and finance companies who had low performance evaluation, improving their service quality by 20% and reducing the waste from 50% to 15%

• Utilized Python to analyze customer service performance of telecom business and visualize business strategy, providing clients precise marketing research and proposals to meet industry standard ACTIVITIES/LEADERSHIP

The University of Illinois Philharmonia Orchestra Urbana, IL Orchestra Leader/Member September 2017 – June 2018

• Organized daily rehearsal work, including team logistics and team building, and coordinated with different student union departments regarding various on-campus talent shows

• Actively participated in daily rehearsals and led 42 students to multiple championships and other rewards at both regional and nationwide professional competitions The 15th Youth Assembly at the United Nations New York, US Group Leader/Member August 2015

• Made a presentation about teenagers’ global responsibilities based on the Millennium Development Goals and discussed the future of NGOs with AIESEC leaders

• Collaborated with university students from different backgrounds to propose solutions to pressing social issues, ranking in 6th out of 50 in the Resolution Project Leadership Program Empirical Research on Influencing Factor of Financial Inclusion Zhuhai, China Assistant August 2015 – November 2015

• Built a fixed-effects model and developed linear regression analysis in R to analyze 7 influencing factors of financial inclusion, submitting analysis report to Zhuhai government as a part of citywide project SKILLS

• Technical: SAP, SQL, Python, R, Microsoft Office Suite

• Regression Analysis, Big Data Analytics, Data Mining, Data Visualization, Statistical Modeling

• Language: Mandarin Chinese (Native); English (Fluent); Cantonese (Basic); Japanese (Basic)

Contact this candidate