Home People Moves Data warehouse helps IT manager gain elevation to CIO

Data warehouse helps IT manager gain elevation to CIO

Underlining the importance of big data in the corporate world, the creation of a data warehouse for a publicly listed dental company has played a major role in the firm's IT manager gaining promotion as its first chief information officer.

David Williams, who has been in the IT profession for 25 years and has been a contributor to iTWire for a long time, was elevated to the post of CIO at Pacific Smiles Group, which has 70 dental centres with plans for 12 more in the next financial year.

Williams (below, right) has worked as a sysadmin, developer, business analyst and filled many other roles before joining Pacific Smiles — a company started by three dentists in Newcastle a decade ago — in November 2015. 

He said that at the time he joined, there were 55 centres and a lot of disparate data floating around, but it was not easily accessible as a whole.

"Further, the back office functions were challenged by the scale at which the company was growing," Williams said. "These are issues I have tackled since arrival, with the implementation of a data warehouse and various other automations.

david williams"We are currently building a business intelligence platform on top of the data warehouse with much greater, far more timely, visualisations, dashboards, etc. to come."

Asked about the technology used to create the data warehouse, Williams said as the company’s primary patient management system was Windows-based, the solution was a combination of a custom C# application and an Azure SQL Server staging database.

"This data is being transformed into Azure Data Warehouse, then Power BI sits on top to deliver dashboards and visualisations," he added.

Announcing Williams' promotion, Pacific Smiles chief executive John Gibbs said: "In his relatively short time with Pacific Smiles, David has revolutionised our data and technology systems, saving hours of time from routine procedures and providing access to information that was previously hidden. 

"He has advanced major, company-transforming projects such as the data warehouse which will ultimately provide more timely and accurate information to staff and dentists throughout the whole organisation."

Williams held the post of CIO before this, having served in that role with Bluestone Global, a public company that went bust.


Australia is a cyber espionage hot spot.

As we automate, script and move to the cloud, more and more businesses are reliant on infrastructure that has the high potential to be exposed to risk.

It only takes one awry email to expose an accounts’ payable process, and for cyber attackers to cost a business thousands of dollars.

In the free white paper ‘6 Steps to Improve your Business Cyber Security’ you’ll learn some simple steps you should be taking to prevent devastating and malicious cyber attacks from destroying your business.

Cyber security can no longer be ignored, in this white paper you’ll learn:

· How does business security get breached?
· What can it cost to get it wrong?
· 6 actionable tips



Ransomware is a type of malware that blocks access to your files and systems until you pay a ransom.

The first example of ransomware happened on September 5, 2013, when Cryptolocker was unleashed.

It quickly affected many systems with hackers requiring users to pay money for the decryption keys.

Find out how one company used backup and cloud storage software to protect their company’s PCs and recovered all of their systems after a ransomware strike.


Sam Varghese

website statistics

A professional journalist with decades of experience, Sam for nine years used DOS and then Windows, which led him to start experimenting with GNU/Linux in 1998. Since then he has written widely about the use of both free and open source software, and the people behind the code. His personal blog is titled Irregular Expression.


Popular News