David Abbott Email & Phone Number

Perth, Western Australia, Australia

Perth, Western Australia, Australia

I am currently developing an enterprise data management solution utilising cloud technology (Azure) for the Communicable Disease Control Directorate as the Department of Health Western Australia. This will enable Public Health professionals focus on delivering expertise in their clinical domains. By alleviating the burden of data management involved in sourcing, extracting and collating data (needed to inform tactical and strategic decision), this aids in focussing human capitol on high value activities. I am leading my team in collaborating with SMEs through substantial business process redesign needed to implement automated and efficient ETL processes that encodes business knowledge and domain expertise in transparent and uniform logic. In documenting this logic using language that is understood by all key stakeholders, I am able to establish consensus and build trust in the reliability and accuracy of the businesses data.In addition to data wrangling, I am introducing integration and linkage of disparate dataset and development of sematic models in order to unlock greater value from these data assets. By ameliorating data boundaries, this enables consistent reporting across business streams while improving availability, data governance and flexibility.I have also introduced source control (via GIT) and managed deployment (via CICD) to ensure improved quality of code and the ability for the team to collaborate more effectively on complex tasks.Management/Leadership:• Recruitment• Role Design• Strategic planning• Solution DesignTechnologies:• Azure Event Hub• Azure synapse Analytics• Azure Data Lake• Azure DevOps• Snowflake

Perth, Western Australia, Australia

Joining BHP under contract with the Standardised Works team, my remit was to collate data from the organisation’s AWS managed PostgreSQL back-end for ingestion into Snowflake. From this warehoused enterprise data, I am developed conformed data entities that form the foundation of a semantic data model. The data model is wired to existing Power BI reports in order to eliminate the collections of CSV files that currently drive these reports. This business improvement enables near-real-time reporting, consolidates and reconciles duplicate datasets, improves data governance and empower citizen data scientists to develop their own needs-based reporting solutions. While this role enabled me to deploy well-honed skills, it has also necessitated the acquisitions of a range of new skills. Within Standardised Work, I am embedded with a DevOps team and have assimilated CI/CD practices with delivery of my data enrichment activities. I also co-ordinate with data engineering specialists to facilitate the extraction and transport of real time data.Management/Leadership:• Stakeholder Engagement• Consultation and Advisory Expertise• Cross functional team coordination• Agile deliveryTechnologies:• Docker• GitLab• PostreSQL• Snowflake• Jira

Perth, Western Australia, Australia

Working for the Global Materials (assets and supply chain) division, I have been contracted to develop the organisation’s Microsoft Power Platform capability. After assessing an array of existing Power BI reports and well as a prototype reporting solution, I created the data architecture to consolidate numerous overlapping datasets. This has involved developing a star schema, data pipelines and processes to orchestrate the data management. As part of my validation I identified logical errors in several existing reports and to overcome these, I worked with SMEs to develop the methodology so the data could be present in its proper context. Through this collaboration I established trust with the data consumer which fostered confidence in the data, governance protocols and contributed to developing a better understand the client needs. This allows me to deliver artefacts that better meets the operational and strategic needs of the business and reduced the risk of data silos spawned by uncontrolled ad hoc reports. As a result of my work, I have improved the quality, introduced time intelligence capability and established a flexible and intuitive data resource. To meet the evolving needs of the organisation.They keys skills I am applying in the role include:• Stakeholder engagement• Requirement solicitation• Data Modelling• Data Engineering• User Interaction and Experience design• DocumentationThe core technologies include:• Power Query M• DAX• Power BI Reports• Paginated Reports• Power Apps• Power BI Dataflows• Power BI data models• Power Automate• Oracle SQL

Perth, Western Australia, Australia

Engaged as a techno-functional expert for the City's ERP implementation (TechOne), I mediated between the product, the vendor, business stakeholders and the project team to deliver a fit for purpose solution.I facilitated cross functional workshops between multiple units to address integration challenges between the products respective modules.I worked across functional areas including:• Finance, • Payroll, • Contracts,• Supply Chain Management,• Assets, • Works and • Property and Rates• GISThe key skills I utilised included:• Soft o Project management, o Stakeholder engagement, o Requirement solicitation• Hard o System configuration, o System administration, o Data quality analysis, o Business process analysis, o Report development

Perth, Western Australia, Australia

In this role I established the Business Intelligence Unit for the Business Performance department of PathWest Laboratory Medicine. To support the organisation’s BI capability, I implemented an Enterprise Architecture primarily (EA) based on the Microsoft BI Stack. Collating data from disparate sources including pathology, patient administration, human resource and general ledger data, I developed case matching routines to establish end to end linkage across information system boundaries. By utilising an N-Tier Architecture I was able to ensure the uniform application of business logic, simplified access and governance protocols, eliminate silos and data islands while ensuring data reconciled across the agency (SSoT). By performing these value adding activities, I was able to ameliorate organisational boundaries, transform operational data into strategic assets and empower business users to make informed and proactive decisions based on real time data. In order to understand the needs of the business, I worked with a variety of stakeholders from executive management to cross functional clinical teams to develop effective solutions to real world challenges.Through this role I demonstrate a high degree of expertise in: • SSMS(T-SQL) • SSAS • SSIS • SSRS • TableauI also developed significant experience with: • Oracle (PLSQL) • PowerShell • Power BI • MDX & DAX • DMXTo fortify my soft skills, I undertook post graduate studies in leadership and management. This helped me to establish a demonstrated record of negotiating favourable outcomes by working collaboratively and constructively with internal and external stakeholders. I also enjoyed the opportunity to exploit new technologies, innovate solutions to business challenges and to transfer my knowledge within my team.

Perth, Western Australia, Australia

Supporting the information needs for this large area health service, I developed and maintained performance reports for business managers and the executive team. This included Case mix data, validation of coded episodes and management of multidimensional datasets.I also provided Ad Hoc data in response to parliamentary questions and to support clinical research programs. This required a solid understanding of ICD, MDC and DRG standards, high levels of accuracy and the ability to manage and prioritise competing demands. These challenges enables me to showcase my data modelling abilities and further develop my time management and workflow skills.The tools I mastered through this role included:• Cognos PowerPlay• SAS• 3M Grouper• Oracle PLSQL

Perth, Western Australia, Australia

In this position I was tasked with to developing the organisation's Patient Management System. This role enabled me to employ my systems analysis toolset to identify and document comprehensive system requirements. In addition to encoding these details into a feature rich and intuitive IS, I also embarked on my professional development journey which provided me with a focus on embedding strategic management as a vector of all my subsequent work.

Master'S Degree, Health Economics And Management

Dissertation in Full Cost Accounting

Master'S Degree, Health Administration, Policy And Leadership

Master Of Science - Ms, Information Technology

Majoring in Strategic Management