Johnathan Liu

Current Address: **** ******* **., ******, ** 97403 ac9edo@r.postjobfree.com

Permanent Address: 2223 Sevillano Ct., Livermore, CA 94550 925-***-**** Highly motivated Economics student seeking job opportunities. I am interested in leveraging my accounting, Python programming, MySQL, and analytical skills to positively contribute to an organization’s objectives while gaining valuable industry experience.

EDUCATION

University of Oregon

• Bachelor of Science, Economics (2014 - 2019 expected)

• Bachelor of Science, Biology (Minor)

Granada High School

• Honor Roll

• Recipient of Honor Chords

RELEVEANT COURSES TAKEN

Granada High School University of Oregon

Economics Calculus I Crime Economics

AP Statistics Calculus II Public Economics taxation Probability and Statistics Issues Economic Growth & Development Intro Econ Analysis Microeconomics Money and Banking Intro Econ Analysis Macroeconomics

International Econ Issues

Intermediate Microeconomics Theory

Intermediate Macroeconomics Theory

Econometrics

Urban and Regional Economics

Issues Labor Economics

Python and MySQL

WORK AND VOLUNTEER EXPERIENCES

Intern at Matthew Wu CPA – accounting and IT (2017 - present):

• Researched on IRS tax codes for Increased Research Credit application

• Assisted in documentation process for claiming Research Credit for a start-up technology client

• Responsible for project management and development of two user applications: o Gather, define, prioritize, schedule review, and document requirements on user interface, data format, backend interface, and test/verification use cases o Developed Python scripts with xlrd and glob packages to automate monthly accounting procedures and create CSV files to feed online interface that transformed the error prone manual process to automation o Developed MySQL database interfaces using SQL join, view, and filter queries to collect analytics and data for report generation

o Continued to support user enhancement in 2019

Financial analysis and managing personal and family portfolio (June 2014 - present):

• Actively managing portfolio of stocks and practicing fundamental and technical analysis using public records

• Plotting comparative analysis of company’s current and past financial statements and competitive analysis of companies using their earning and operating profit margin reports with Stata and Excel

• Utilize EDGAR database from https://www.sec.gov to search 10K, 10Q, and other filings for data analysis

• Top investment includes: AAPL (+250%), FB (+130%), NFLX (+150%) Financial researcher and Open Source projects (2017 – present)

• Installed and maintained MySQL server on personal MAC and imported various test databases for report generations

• Work in progress on a personal Securities Master Database (https://www.quantstart.com/articles/Securities- Master-Database-with-MySQL-and-Python) using MySQL, Python, and Yahoo Finance APIs to get daily market/stock data

Extended Student Services (ESS) at Emma Smith Elementary School (3 years):

• Tutored Math, Science and English

• Supervised indoor and outdoor activities

• Made snacks for students

• Utilized multi-tasking ability

National Rebuilding Day

Joined the Rebuilding Together Peninsula in various projects around the bay area to improve the lives and homes of low- income homeowners.

The Hike for Hope

Participated in memorial hike fundraising event to help support the vital work of Hope Hospice Race to the Flag Pole

Racing to the flagpole to benefit Livermore Granada Boosters Scholarship program Buenas Vidas Thrift Store

Cleaned facility and organized inventories

Private Tutor (3 years)

Worked with elementary and junior high school students on Math and Science Technical and Language Skills

Technical:

• Microsoft Office: Word, Excel, Excel Formulas, Power Point

• Stata, Python, SQL, MySQL, Yahoo Finance APIs, Pandas Language:

• Mandarin (basic)

• Spanish (basic)

INTEREST AND ACTIVITIES

Certificate of Merit

Successful completion of Piano Level 5 with M.T.A.C. adjudicated evaluation in performance, technique, sight-reading, theory, and ear training.

Varsity Tennis (4 years)

Participated in daily practices and competed against other schools in both singles and doubles matches Photography

Reference available upon request

Contact this candidate