Weilun Su

Technical Skills: Python (NumPy, Pandas), R, Tableau, SQL, Stata, MS Office (Excel, Word, and PowerPoint, Outlook), Google Analytics

Global AI New York, NY Data Analyst Intern (Fall Internship – Onsite) 11/2021 – 01/2022 • Supported Data Analytics Projects - such as;

o SDG; used Python to analyze Stock Index data from 2013-2020 as a risk factor framework to evaluate how different risk types impact the valuation and price returns of stocks.

o Stock Data Analytics (covering JPM’s historical time series data from Yahoo/Google for the S&P500 stocks); used daily frequency and built a data table (timestamp; ticker; ticker name; daily closing price; daily volume) in SQL.

• Performed tasks such as data extraction, cleaning, filtering, normalization, as well as analysis with machine learning.
Boston Consulting Group (BCG) Remote Summer Intern (Financial Data Analytics) Summer 2021

Assigned to Health-Care Project; Analyzed financial reports of significant competitors in the healthcare industry of the Chinese market, cost and investment calculations, and local policies regarding private and public hospitals within market shares (using Excel, & Tableau for visualization).

Examined critical financial aspects of the healthcare industry to evaluate factors driving results, and assessed impact of current business processes on consumers and stakeholders – in addition to evaluating potential areas for client market expansion strategies (data was gathered via Bloomberg & Yahoo Finance web sources, as well as provided internally by BCG).

Assigned to Energy Project; Evaluated Chinese energy-industry data, leveraging information to forecast costs relating to hardware, software, and consulting; applied honed problem-solving skills to analyze and investigate overseas investment and development of energy resources of Chinese private enterprises.

She Grows ItTM (SGI) | DC-based Consulting Firm Remote Data Analyst Intern Winter 2020

Supported a project centered on US African-market investment; used Excel to collect an compile various financial data regarding to payments, agriculture-related trading, and more; tracked and reported any block trade and suspicious transaction activity to Senior Manager by Excel documentation.

Collected data on consumption of African products by American customers and conduct data analysis to study customer preferences and purchasing behavior (data was collected from Kroger, Panda Express, and Chick-fil-A).

University of Kentucky

Technology Assistant - Student Employee (Paid)

Columbia University NewYork, NY M.A in Quantitative Methods in the Social Sciences (STEM - Data Science Focus) | GPA: 4.0 09/2021 - 05/2022 Relevant Courses: Data Analysis (Python, R, SQL), Natural Language Processing (Python), Advanced Machine Learning (Python), Machine Learning (Python), Modern Data Structures, Data Visualization (R, Tableau), Applied Data Science for Social Science (R), Social Venture Incubator, SQL (course)

University of Kentucky Lexington, KY

B.A in Economics and Foreign Language and International Economics (Double Major) | GPA: 3.5 08/2018 - 05/2021

Relevant Courses: Statistical Reasoning (Python), Policy Analysis (Python, Excel), Advanced Calculus, Economic Development, International Trading • Dean’s List (2018, 2020), Arts & Science College Student Scholarship & International Student Ambassador Scholarship Recipient