Business Intelligence Analyst and Business System Analyst

National Institute for Health Innovation

Our client is a research group - FoodLab NZ. They aim to research customer purchase behaviours in online supermarkets and in-store, in order to lead Kiwi to purchase healthier food and affect policy. REDCap Survey platform, an online shopping system and a VR supermarket system are involved.

​

I lead a team of 5 to create an environment for non-technical researchers to sense data and realize more possibilities in data analytics. 

​

• Design and implement data pipeline and data warehouse to support regular/real-time reporting, map datasets into a coherent interlinked structure and extend data schema for XR client in SSMS

• Create multiple analytics such as automatic reporting including Power BI real-time dashboards

• Design and implement a data pipeline incorporating the data generated from the integrated web-based systems and Extended Reality (XR) space to analyse customer consumption behaviour and public health with SSMS, Python, R

• Gather and discover requirements, analyse system problems

​

I get used to challenging myself and always think about how to work smarter. So, I build an automatic test bot by UiPath to reduce repetition. My bots have different personalities and they are designed in a modular way. Our client is interested to implement them into the other projects.