Estate Analyst Accounting Assistant

ALEX LI

***********@*****.*** 818-***-**** Studio City, CA 91604 LinkedIn GitHub

QUALIFICATION SUMMARY

Tech-savvy and passionate professional with ability to scrutinize and analyze raw data to conclude valuable results. Capacity for extracting and interpreting complex data sets to determine trends and opportunities. Able to prepare reports for management and design data visualization graphs. Enthusiastic to expand skills and knowledge through continuous learning of new technologies and techniques. Adept at collaborating with team members and management to meet desired results.

TECHNICAL PROFICIENCIES

Excel, VBA, Python, Pandas, Matplotlib, SQL, SQLAlchemy, Python, HTML, CSS Bootstrap, MongoDB, JavaScript, GeoJSON

PROFESSIONAL EXPERIENCE

Real Estate Analyst Assistant, US National Capital LLC. 2022

Helped analyze real estate value of various properties in European and North American countries for development and investment purposes for the company.

Accounting Assistant, Four Points Hotel by Sheraton Anaheim 2019

Performed a variety of tasks such as maintaining financial records, organizing invoices for payment and processing, managing bookkeeping in compliance with best accounting practices.

Provided exceptional support to financial department, accounting manager, and assistants as required.

EDUCATION & CREDENTIALS

Certificate in Google Data Analytics (Foundations: Data, Data, Everywhere), Coursera Jan 2023

Learned knowledge of key data analytical tools (data visualization, spreadsheets, and SQL). Explored real-life entry-level analysis problems.

USC Viterbi Data Analytics Bootcamp, University of Southern California Dec 2021 – Jun 2022

Acquired knowledge of real-time data analysis and visualization using industry-standard technologies. Developed understanding of statistics and mathematical methodologies and data acquisition and interpretation. Learned about storytelling with data, dashboard building, mapping, and importance of communicating relationships within dataset.

Bachelor of Arts in Music, University of Southern California 2021

KEY PROJECTS

Group Project 1 (4 contributors)

Role: Graphing Language: Matplotlib GitHub

Analyzed apartments’ regional prices in CA and calculated the correlation between apartment prices and CA regions.

Utilized graphs to illustrate visuals such as region vs price, price/sq. ft, number of bedroom and, units in each CA area.

Project 2, The-Movie-Biz (4 contributors)

Role: Coding Languages: Pandas, PostgreSQL, SQLAlchemy GitHub

Analyzed critic reviews and box office collections of movies from 2001 to 2019 to determine the correlation between receiving Oscar nominations.

Filtered and concatenated datasets to analyze relation between Metascore and box office revenue of each film.

Project 3 - Billboard’s Top 25 Throughout the Years (4 contributors)

Role: Coding Languages: JavaScript, Python, HTML GitHub

Evaluated instances of top 25 artists from 2014 to 2021. Utilized Flask to link pgAdmin/PostgreSQL and JavaScript to allow data to be saved as Json and read by HTML.

Organized data to be used reactively by HTML with JavaScript by utilizing d3 functions. Ensured effective presentation of data by using Plotly and Bootstrap.

Contact this candidate