I led a team to create a data pipeline in Google Cloud Platform that uses a Python Cloud Function to automatically extract battery test planning data from the API of Wrike (project management software). The pipeline then cleans and processes the data, and publishes the processed data to Google BigQuery tables.

My team used these tables as an SQL data source to set up Tableau dashboards to enable senior management to visualise easily and forecast the upcoming resource requirements for our test facilities. The creation of this data pipeline and dashboards allows management teams to access live data and has saved my team over ten hours per week that was previously spent manually creating weekly charts.

I regularly update the data pipeline and many of the Tableau dashboards to ensure that the data is processed efficiently and presented in the most effective manner.

Date: July 2021 - Present