Data Analyst Asset Manager

YUE PAN

** ******* ****, *** #**** • Jersey City, NJ 07310

***********@*****.*** • −

EDUCATION CUNY New York City, NY

The Graduate Center Class of 2023

Master of Science in Quantitative Methods in Social Science (Data Analytics Track)

• Cumulative GPA: 4.0

• Award: QMSS Research Assistanceship

• Courses: Data Analysis Methods, Business Analysis (Tableau), Principle of Database Management

(SQL), Interactive Data Visualization (HTML), Programming for Analytics (Python), Data mining for Business Analytics(R)

Baruch College Class of 2020

Bachelor of Arts in Psychology & Environmental Science

• Cumulative GPA 3.9/4.0

• Award: Wendy Heyman Public Interest Fellowship

• Courses: Research Methods in Psychology, Conservational Biology and Sustainability EXPERIENCES Brooklyn College New York City, NY

Fall 2021 - Now Data Analyst

• Appointed to be the sole data analyst in a 3-yrs research on "the stress buffering capacity of capitalization experiences" (research title) by CUNY

• Utilized R & SPSS to clean over 50 datasets (over 500 hours)

• Implemented contrast codes to enable OLS regression analysis using R to find statistically significant difference between "happy vs. sad vs. neutral" events (memory)

• Performed interaction analysis using R to find the effects of the memory of a "happy event" has over rejection at the present moment

• Monitored participants' skin conductance response at different junctures of the experiment

• Delivered key insights that "happy memories" do serve as a buffer against rejection experiences, validating the main research hypothesis

• Used R to visualize the dataset in terms various charts & graphs to create the deck Summer 2022 Jedidiah Publishing Inc. New York City, NY Data Analyst

• Managed the entire sales operation of jigsaw puzzle brand called Antelope Puzzle, including daily sales report of 40 different products using Python, daily ad campaign budgets

• Engaged in demand planning by forecasting sales trends, scheduling weekly fulfillments, & managing inventories using data mining techniques

• Visualized sales data using Python from online channels (Amazon, Etsy, & Shopify) to identify key consumer attributes based on age, gender, & location

• Delivered key insights using business analytics techniques on optimal consumer attributes to the product development team so they can develop the "best" product to our target customers

• Maintained daily search keyword analysis, which retains higher ROI keywords for ad campaign and eliminated low ROI ones

• Created weekly ad content over social media platforms like Instagram, Facebook, & Twitter Summer 2021 China Railway Construction Koi Beijing, CHINA Asset Manager

• Managed a portfolio of over 1000 real estate properties across China

• Collected over 1000 of financial statements for each property

• Performed Profit & Loss analysis for the properties

• Consolidated financial information using Excel

• Presented my findings via written reports and PowerPoint to senior leadership SKILLS • Google Data Analytics Professional Certificate

• Experienced in R, Python, SQL, Tableau, HTML & Microsoft Office Suites

• Proficient in English & Mandarin

Contact this candidate