Business Analysis Data Analysis Machine Learning

Jiawen (Anna) ZOU

********@*****.*** +1-917-***-****

Columbia EDUCATION University in the City of New York Sep 2024 to Dec 2025 (Expected) Master of Arts in Quatitative Methods in the Social Sciences (GPA: 4.1/4.0) New York, U.S. Courseworks: Quantitative Theory, Data Analysis, Machine Learning, Natural Language Processing, Data Structures, Data Visualisation London School of Economics and Political Science Sep 2023 to Sep 2024 Master of Science in Local Economic Development (GPA: 3.66/4.0) London, UK Courseworks: Economic Appraisal and Valuation, Applied Regression Analysis, Globalization and Regional Development The University of Edinburgh Sep 2019 to Jun 2023

Master of Arts with Honours in Economics (GPA: 3.68/4.0) Edinburgh, UK Courseworks: Decision Analytics, Data Science, Economics Statistics, Econometrics, Behavioral Economics, International Economics, Microeconomics, Macroeconomics, Calculus, Linear Algebra, Accountancy SKILLS

Technical: Proficient in Python, SQL, Excel, R, STATA Languages: English (fluent), Chinese (native)

INTERNSHIPS

Huatai Secutities Jun 2024 to Oct 2024

One of the top four investment banks in China

Intern, Internaitonal Relations Research Institute Shanghai, China/ Remote

● Independently completed data collection and visualization for all the reports produced by the team.

● Tracked and updated weekly report of U.S. macro indicators, 2024 U.S. presidential election polls and fundraising activities.

● Compiled international breaking news and in-depth posts, producing a report containing 40-60 news/ in-depth pieces daily. Capgemini Jul 2022 to Sep 2022

Intern, Business Analytics Shanghai, China

● Facilitated a commercial real estate digital transformation project to design the rental pricing mechanism for more than 1500 shops.

● Influenced in the design, distribution, and evaluation of surveys for leasing agents at the target real estate projects, completing three rounds of progressive surveys that incorporated open, scoring, and evaluative questions to gauge accurate feedback.

● Inquired and validated historical operating data using SQL, restructured datasets structure, and conducted data cleaning.

● Independently performed data analysis on sample properties using Python, to test the causal relationship between sales revenue and shop characteristics.

● Presented weekly progression to client company and stakeholders and set up periodic objectives. Jaya International Apr 2020 to Jun 2020

A manufacturer and exporter of China-made woodworking machinery established in 2006 Intern, Data Analysis Jinan, China

● Extracted corporate operating data from electronic transaction platform and cross-checked with sales staff records.

● Influenced pricing and go-to-market strategies strategy by developing actionable insights through key operating data dashboards.

● Launched key customer analysis including the trend, composition, and pattern of sales, to support inventory preparation. RESEARCH & PROJECTS

Review of Reviews (Using NLP techniques to generate meta information of any target restaurant) Dec 2024 Course Project for Natural Language Processing New York, U.S.

● Performed comprehensive text preprocessing, including tokenization, punctuation removal, and stop-word elimination.

● Conducted sentiment analysis on a 5-dimension scale to meta-evaluate restaurant attributes comprehensively.

● Developed a machine learning-based restaurant recommendation model, integrating TF-IDF vectorization and cosine similarity to match user’s latest review with relevant reviews in the database, enhancing personalization and accuracy. City Size and Gender Wage Gap: A Case of Urban China Jan 2024 to Aug 2024 MSc Dissertation London, UK

● Documented and visualized hourly wage of by gender and by city size, calculated and t-tested the difference by city size.

● Surveyed literature on urban agglomeration, urban labor productivity, gender division of labor, gender wage gap attributions.

● Examined how urban agglomeration mechanisms drived a gender-biased wage premium and contribute to narrower gender wage gaps in larger cities, corroborated through a backward decomposition analysis, and conducted robustness check. A Taxi Company’s 0 to 5 Years Old Car Replacement Policy Nov 2021 Course Project for Decision Analytics Edinburgh, UK

● Applied Markov Decision Process model to analyze the purchase cost, trade-in revenue, running cost, and accident rate of cars of different ages, taking into account the time value of money.

● Proposed the appropriate car replacement policy and insurance premiums for a taxi company based on the analysis above.

Contact this candidate