Patrick Jiang

Agile and motivated graduate seeking business/data analyst opportunities .

Kia Ora World

I am Patrick Jiang, a recent graduate and look for entry-level data/business analyst opportunities. Python, R, SQL, Tableau, Access, Visio, and more... I am always curious about new technologies and I am thrilled to kick-start my career in the ICT industry and contribute to the success of the business with my skills.

Technical Skills

  • Conduct statistical analysis with R Studio
  • Manipulate data frame and leanse data with R with dplyr and tidyr
  • Basic knowledge of Python with Anaconda and Pandas
  • Visualise data with ggplot2 in R Studio
  • Visualise data with Tableau and Microsoft Excel
  • Diagramming with Microsoft Visio
  • Currently self-learning visualising data with Python with Matplotlib and Seaborn
  • Manipulate data, write ETL statements and cleanse data with MySQL
  • Data modelling with Microsoft Access
  • UI/UX wireframing design and prototyping for website and app.
  • Microsoft PowerPoint design
  • Understanding of SDLC, Agile methodology, and DevOps principles
  • Understanding for data analytics and business intelligence
  • Knowledge of systems analysis and process modelling and data modelling
  • Conduct qualitative and quantitative research
  • Machine learning fundamentals
  • Project management
  • More learning on progress

Find more about me on my LinkedIn

Data Manupilation and Cleansing in SQL

This is a part of the course project from Data Management course at the University of Canterbury. In this project, I wrote a series of SQL statements correcting the problems with the datasets, and eventually transformed the data into one integrated database where redundancy is eliminated

R Project: Mental Health and Environment

This group project aims predicting mental health data in New Zealand from environmental factors including air quality, rainfall, temperature, and earthquakes. Several machine learning models have been used such as random forest, time series, and ridge regression. The project was programmed with R Studio.

Location

Christchurch, 8041, New Zealand

Phone

02108803472

Email

jianweijk@outlook.com

Social