• Improved the business operation efficiency via identifying key factors of employee productivity decrease by analyzing employee productivity data collected from over 3K employees in Excel using pivot table and V look-up functions; the final deliverable was highly recognized by management and was adopted in decision making.• Enhanced the client feedback system by revising the email template with more customization utilizing client’s data, boosted feedback reply rate by 40%.• Executed monthly productivity report, actively communicated and maintained the relationship with clients across multiple Asia countries, to assure the quality of the service delivered and proactively identify potential risks.

• Collected and clean data from 640 TV episodes of a job-hunting reality show with 30,000+ rows using advanced Excel skills.• Assisted in building social science database on enterprises’ hiring and candidates’ performance using Excel and Stata.• Conducted causal analysis using Stata to analyze the relationship between the degree of regional affluence and employment performance using data on a 10k scale.