
• Provide support to the project team with assisting the team leader to complete the task of data
collecting, data extracting, data transforming and data loading using R.


Uiversity of South Australia

Data analyst

RStudio

Contract - Data analyst

Graduate Diploma in Data Science

University of South Australia

Canberra (Bruce)

Bachelor of Science

University of Canberra

I am Yifei Yan. I graduated from University of South Australia with program of Graduate Diploma in Data Science. I completed Bachelor of Science with majors: statistics, mathematics and biology in University of Canberra. I have acquired experience about data analysis during I was working on my project in University of South Australia. I am committed to providing the finest level of computer skills and statistical analysis on real-world research. I also have acquired the following skills and knowledge:

• Familiar with R packages in tidyverse such as readr, stringr, dplyr and 
   ggplot2 to reading/manipulating/cleaning/analysing/plotting data. 

• Proficient in R with experience in using regular expression pattern to 
   extract data from any text through searching and replacing strings. 

• Skills in R with dealing with big data through packages including 
   ffbase, biganalytics and bigmemory. 

• Solid knowledge in ad hoc analyses of data through creating data 
   visualisation report using R Shiny Flexdashboard, Power BI and DAX in 
   order to sharing with end users. 

• Advanced skill in Microsoft SQL Server programming to manipulate, 
   join, filter and aggregate data. 

• Advanced skills in MS Excel for both data analysis and visualization 
  (data validation, Query Editor, Dynamic Pivot Table, Array Formula, 
  Dynamic Array Functions, Lookup Function, Index Match Function, and 
  Interactive Dashboards). 

• Proficient in Power Query with experience in working with multiple 
   excel datasets, ETL, data cleaning, data formatting and data merging. 

• Basic skills in Python with libraries such as, NumPy, Pandas and 
   Matplotlib. 

• Familiar with SAS (SAS Enterprise Miner, SAS Enterprise Guide, SAS 
   Visual Analytics) with experience in data summary, data analysis, data 
   visualization and data modelling. 

I work as a retail store person to provide service to customers including checkout, cash registers, receiving payments, issuing receipts and returning change due.

Yifei Yan / Contract - Data analyst

Data analyst

Uiversity of South Australia

Progress

Skills