Mandy Gu Email & Phone Number

San Francisco Bay Area

Engaged professionally with this highly successful aircraft type club worldwide with 70% of Cirrus type members, to help them enhance member experience Creatively designed a content scoring model through the use of Natural Language Processing technique (LDA topic modeling) in Python, as well as taking into consideration the authority of an author and the recency of the forum post, to deliver the most relevant results to site users Aggregated 250G data from SQL Server and external sources through the use of APIs and web-scraping Migrated database to AWS, triggered a pipeline by Lambda to do data cleaning and implemented re-ranking model on SageMaker Developed a well-structured dashboard with relevant metrics (such as Daily Active User and Page Views) by Tableau to help administrators track site performance Partnered closely with our MSBA Industry Partner (MIP), who is a founding member of COPA, planned our deliverables and always kept him informed with updated work by a weekly internal meeting

Shanghai City, China

Implemented sentiment analysis of Shanghai Stock Exchange firms by Python (pandas, keras, scikit-learn) Conducted unsupervised sentiment analysis by innovatively outlining rules of assigning headlines with sentiments Leveraged Natural Language Processing techniques (stemming, tokenization, Bag of Words) to carry out a supervised model based on Multinomial Logistic Regression and reached a 72% accuracy rate Further improved the result by incorporating word2vec into Long short-term memory model and achieved an accuracy rate of 79%

Shanghai, China

Logically made working papers by Excel (VLOOKUP, pivot table) and generated audit reports Checked audit reports in terms of format and numbers to see if it was matched with working paper

Master Of Science - Ms, Business Analytics, 3.67

Bachelor'S Degree, Finance, 3.84

Activities and Societies: Member of School Badminton Team