Scarlett Liu

Bachelor's

Finance

Information Technology (IT)

Statistics

PELTAST PARTNERS

data analyst intern

• ▪ Analyzed Cryptocurrency industry’s performance using Pandas, Numpy and Beautiful Soup in Python, and constructed sensitivity table to calculate portfolio returns with various Crypto, S&P, HF and PE weights in portfolio • ▪ Built optimal portfolio’s performance projection till year 2023 using ARIMA Model and Bollinger Bands in Python • ▪ Gathered and analyzed data on Southeast Asia countries’ middle class annual family income from 2010 to 2019; • visualized data using Geo Heat Map in Tableau to help the client develop a food market penetration plan • ▪ Provided insights and created reports on Philippines aircraft incidents dataset for a Maintenance, Repair and • Operations (MRO) client to improve operations on the ground, observe most common accidents and related reasons