1. Design & development of the SQL Server database to create a data warehouse for use within PowerBI dashboards and Excel Reports. The database assets include tables and views spanning several years of data to answer most ad hoc queries.

2. Development of a data pipeline from multiple data sources including TrakCare (via ODBC), Titanium (via manual extracts) and Medical Director/Pracsoft. This data pipeline with SSIS packages and batch processes updates an SQL Server database on a nightly basis.

3. Development of Pivot tables in Excel making use of PowerQuery and data from SQL Server datasets.

4. Development of a series of Management Dashboards for Funds in PowerBI and Excel.

5. Development of an Invoicing interface between TrakCare and Business Central for NDIS, Home Care Packages & Other miscellaneous billing, based on MS-Access as a front-end application making use of SQL Server datasets.