Foster Construction: Comprehensive Data Solutions

Foster Construction is a commercial construction company in Waikato/BoP with over 200 staff. As their data lead from mid 2020 until the end of 2022, I ran many projects:

- Built 16 data pipelines from a range of APIs and databases to centralize all company data in one data warehouse.

- Made well-documented data models in SQL for all data pipelines and sources.

- Extensive reports in Power BI for business users, from operational staff to top management.

- Built a range of integrations in Python to connect core business systems together using the unified data model I had built earlier.

- Developed several custom web apps to replace complex and time-consuming manual processes. These used the core data model and a mix of full-stack technologies.

- Created an internal health and safety site attendance web and native app to streamline site inductions and replace a paper-based sign-in and induction process