Jerry Liao

Data Analyst & Programmer

Hi i’m Jerry

Former stock analyst turned data analyst and programmer

Certificates
– Google Data Analytics
– Harvard CS50T: Technology
– Harvard CS50X: Computer Science
– Harvard CS50P: Python
– Economics & Finance (Double Major) from The University of Melbourne

I am passionate about leveraging data and technology to solve complex problems and continuously expanding my skill set in these areas.

Languages & Softwares

Python
R
JavaScript
C
SQL
CSS
HTML
HTML
Jupyter
Fabric
Tableau

Data Analysis

Market Research Case Study

This case study analyses the pricing methods for discounted games on the Nintendo platform and compares them with its competitor, Steam.

The study utilises web scraping tools, statistical programming languages, and data visualisations to derive actionable insights and recommendations aimed at enhancing pricing efficacy and user experience.

Tableau Data Visualisation

Statistical Forecasting and Modelling

This analysis utilises time series instruments to make forecasts. It then combines economic and financial theories to employ various quantifiable and practical variables to build regression models that measure variations in investor sentiment.

By applying a range of statistical techniques, the model quantifies irrational bullish or bearish market behaviours.

Business Operations Dashboard

In this project, I leveraged cloud data management platforms to pull and store data, which was then used to develop comprehensive dashboards for identifying operational issues and recommending actionable insights.

The result is an interactive, user-friendly dashboard that highlights key performance indicators, enabling data-driven decision-making with clear, insightful visualisations presented to stakeholders.

Excel

This Excel file is designed to create interactive dashboards using functions, pivot tables, and VBA, allowing users to analyse and calculate data dynamically.

Software Development

Full-Stack Web Application

Mopic utilises APIs and AJAX to fetch and display dynamic data, enhancing user interaction with a seamless experience.

It adheres to best practices, such as securely encrypting user credentials in the database, ensuring robust security measures are implemented.

Python Object-Oriented Application

This Python program showcases good coding practices to solve real-life problems.

The code is clear and easily modifiable, featuring command-line arguments with default values and descriptive help texts. It includes robust error handling for user-friendliness and outputs graphs for easy result interpretation for stakeholders.

Web Scraping

This web scraping tool is designed for comprehensive data collection and analysis, offering up-to-date information sourced from three distinct online platforms.

Seamlessly integrating data from multiple sources, it consolidates diverse datasets into a unified format for streamlined analysis

C Memory Management

This C calculator project serves as a practical exercise in efficient memory allocation, linked list management, and memory deallocation.

It aims to demonstrate these concepts through a simple yet effective approach to tackling real-world problems.

Hobbies

I enjoy exploring creative activities and experimenting with different fields, even if I might not necessarily excel at them.
My persistent nature ensures I don’t give up easily, embracing the process and learning from each experience.

Scroll to Top