Data Analysis

Yinuo Zhou

917-***-**** 丨 ******@********.*** 丨Linkedin Profile

EDUCATION

COLUMBIA UNIVERSITY – Master of Public Administration May 2024

Concentration: Data Analysis & Quantitative Analysis

Course: Data Analysis for Policy Research Using R; Using Big Data to Develop Public Policy; Text Analysis in Python; Building AI Tools; AI & Conflict Prevention

SUN YAT-SEN UNIVERSITY – Bachelor of Law in International Politics Jun 2022

GPA 4.0/4.0 (top 10%) Award: 2019 Contemporary Mathematical Contest in Modeling (3rd Prize)

THE UNIVERSITY OF CHICAGO – Data and Policy Summer Scholar Program Aug 2021-Oct 2021

UNIVERSITY OF CALIFORNIA, BERKELEY – Exchange Program Jan 2020 - May 2020

EXPERIENCE

COMMUNITIES SPEAK New York City, USA

Data Specialist Jun 2023 – Present

Develop codes for data analysis, producing 9 reports on NYC resident conditions, guiding policies in: education, healthcare, etc.

Create R scripts that cut data preprocessing time by 50%, ensuring accuracy and completeness for downstream analysis

Lead operations to expand the project to 5 cities, overseeing data collection, analysis, and framework development

Deploy 2 Qualtrics surveys, increasing audience response by 40% and collecting data from over 4000 participants

DENTSU Shanghai, China Search Engine Optimization Intern Mar 2022 – Jun 2022

Coordinated 3 search engine optimization (SEO) marketing campaigns for Shiseido Travel Retail on 4 different platforms.

Boosted organic traffic by 60% on Red (social media & e-commerce platform) through keyword management using Excel

Directed ad monitoring for 3 campaigns, creating 12 weekly and 3 post-campaign visualization reports with Tableau

NEW YORK UNIVERSITY Remote

Database Development Assistant Apr 2021 – Sep 2021

Collected raw data from over 1200 government webpages and archives using web scraping, API integration, and manual entry

Created database of historical data on administrative division changes in 31 Chinese provinces from 1981 to 2019

RELEVANT PROJECTS

COP28 Navigator: An AI Policy Tool Mar 2024

GitHub link: https://github.com/yinuoooooz/cop28navigator

Integrated OpenAI's API and GPT-4 model with Python to design educational platform for United Nations Climate Change Conference

Transforms multimedia data into dynamic database, powering a Q&A system on environmental policies and boosting user engagement

Reintegrating Afghanistan Refugees during Conflict Aug 2021

GitHub link: https://github.com/yinuoooooz/afghan-refugee

Used R to analyze economic factors faced by Afghan refugees returning from Pakistan, based on UNHCR data, creating policy memo

Developed visualizations with R to effectively present demographic data, facilitating a clearer understanding of key trends and patterns

SKILLS

Skills: Python, R, STATA, SQL, Machine Learning, Microsoft Suite, Photoshop, Google Analytics, Tableau, MySQL, Power BI

Languages: English (fluent), Mandarin (fluent), Cantonese (intermediate), French (elementary)

VOLUNTEER WORK

Treasurer – Columbia SIPA’s Ethical Fashion Working Group 2023 – 2024

Project Assistant – Gay & Lesbian Campus Association of China 2019 – 2020

Contact this candidate