Chenyi Jiang

adwi2r@r.postjobfree.com 929-***-**** New York, NY

EDUCATION

Columbia University in the City of New York New York, NY MA in Statistics (STEM)-GPA: 4.0/4.0 Sep 2022–Dec 2023 Relevant Courses: Applied Data Science with Python, Machine Learning, Time-series Analysis, Sample Surveys Xi’an Jiao-tong Liverpool University Suzhou, China BS in Financial Mathematics-GPA: 3.92/4.0 Sep 2018–Jul 2022 WORK EXPERIENCE

XAG Co., Ltd. (Agricultural Drone Manufacturer Unicorn) Guangzhou, China Marketing Analyst Intern Jun 2022–Aug 2022

Performed media research to enter Vietnamese market; proposed marketing strategy on Facebook, Instagram, YouTube and Tik Tok, and targeted and established contact with 10+ traditional media outlets

Automated tracking of sales leads utilizing Google Analytics and “Search Ads buying” through Google Ads

Brainstormed ideas for Chinese and international integrated marketing programs; created overseas press releases and CSR user stories

CnosDB Tech Limited (Software Company with Time-series Database Catering to IOT Firms) Beijing, China Operation Data Analyst Intern Oct 2021–May 2022

Conducted competitor analysis in Python via crawling, cleaning, visualizing and analyzing competitor LinkedIn, Stack Overflow and Twitter social media data, to help guide internal marketing campaigns

Built an Excel dashboard to automate collection and display of weekly key operational metrics

Livestreamed the writing of SQL-based queries in time-series database PwC Information Technologies Co., Ltd Shanghai, China Business Analyst Intern Jun 2021–Sep 2021

Gathered business requirements from clients and translated them into User Stories and UI mock-ups in DevOps; coordinated with developers to build a content management platform for sales teams

Documented user permissions structures and built flowcharts illustrating connectivity design between different PwC IT systems; presented to stakeholders in India, America and China

Designed and implemented functional testing; collaborated with developers to fix 50+ bugs SQH Tech Limited (Financial Data Analytics Consultancy) Beijing, China Financial Data Analyst intern Jan 2021–May 2021

Cleaned 200k+ pieces of Asset-Backed Securities related data in Python and utilized VBA to build Excel templates for data auto-population and verification; improved the efficiency of the data pipeline by 20%

Researched ESG Rating methodologies in the Chinese stock market, collected relevant ESG data samples and completed a 10-page report summarizing ESG rating processes PROJECT

2021 Mathematical Contest in Modeling - Topic: The Influence of Music Feb 2021

Built a multi-dimensional music similarity evaluation model by measuring a combination of the global and partial feature vectors, and controlling the fashion trend factor, based on Euclidean and Cosine distance

Implemented the model in Python with 100k+ pieces of metadata to recognize the key features of different music genres; visualized the results to interpret feature changes over time and interactions between genres RELEVANT SKILLS & INTERESTS

Programming & Software: Python, SQL, Power BI, Excel VBA, R, Latex, Microsoft Office

Foreign Languages: Mandarin (native), Cantonese (native)

Interests: Songwriting (Hip-hop), Double Keyboard, Running, Reading, Board Games, Travelling

Other: ACCA (Association of Chartered Certified Accountants) (11 out of 13 without fails)