Johnathan Liu
Current Address: **** ******* **., ******, ** 97403 ***************@*****.***
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