Yaxin Guo Email & Phone Number

Shanghai City, China

• Conducted statistical analysis of financial advisors’ sales performance using Python and SQL • Identified factors influencing financial advisors’ performance through trend analysis, group comparative analysis • Provided business insight via data visualization using Python graphic packages such as matplotlib, seaborn, and pyecharts• Established entity relationships of corporations using Python based Neo4j to discover potential company’s financial risks

Waltham, Ma

• Processed brainwave data using Julia software to create a robust single linkage hierarchical clustering model and tested clustering attribution of data, uploaded to Github

Shenzhen, Guangdong, China

• Managed and cleaned data related to different financial products using SQL• Analyzed customer loss rate, and identifying motives through customer app data over 2 years• Communicated with customers and collected customers’ financial products purchase preferences• Identified purchase preferences for financial products, such as purchase decision factors, using SQL and customer surveys

• Collected and managed web visitors’ clickstream data using SQL • Analyzed an experiment that identified to clients’ reactions to receiving follow-up emails • Discovered the relationship between education and key words, providing insights for identifying target customers

Waltham, Ma

• Co-created TeamUp, with an application designed to promote social connection and communication between students, professors, and employers using HTML, CSS, and JavaScript• Led development for functions of user profiles, including uploading pictures, sending messages, and public forum functionality

Copenhagen Area, Capital Region, Denmark

• Designed studies by incorporating local culture, and invited local citizens as participants (random sample)• Conducted two studies to test hypothesis that priming affects Danish consumer preferences, while controlling potential confounds • Evaluated relationship between consumer preferences and national pride; concluded positive correlation

Shenzhen, Guangdong, China

• Participated in marketing strategy weekly meetings and financial product launch events; presented products to clients; documented discussion points for internal use

M.S. In Commerce, Business/Commerce, General

Education record

Bachelor Of Arts - Ba, Economics

Activities and Societies: Brandeis Chinese Culture Connection Waltham Group