Organisations of all sizes are sitting on mountains of data, but often it is inaccessible or suffering poor performance.
Data, and more importantly, turning data into actionable insights and meaningful information, is one of my great passions, and I can help you with this.
- Helping an organisation uncover its SQL Server disk-related performance issues.
- Implementing quality open-source tools for SQL Server performance monitoring.
- Migrating vast amounts of data into a single database and database schema for Bluestone Global Limited, a company which had grown large via the aggressive acquisition and merger of numerous businesses. When I entered the company one line-of-business application was in use but all historic data remained in the original applications creating enormous efficiency burdens and requiring the costs and efforts of licensing and platforms to hang around. I eliminated all the legacy applications bringing historic data into a single repository.
- Consulting to a range of recruitment and labour-hire organisations to migrate from AXiOM by Dialog Information Technology to FastTrack 360, extracting and re-organising data and documents to suit the FastTrack structures.
- Creating a data warehouse and unlocking the vast amount of data for Pacific Smiles Group, a public ASX-listed national health organisation had. My work gave it access to new ways of measuring utilisation, the ability to change future performance, accelerating financial reporting, enhancing marketing effectiveness, and much, much more.
Unlocking access to data
In the latter case when I entered Pacific Smiles there were 55 separate instances of the core Dental 4 Windows (D4W) application across 55 locations, with 55 individual Sybase databases. The Finance team spent four days each month remotely logging into 55 centres, running 55 copies of their main application, generating reports and extracting information and aggregating it at head office. This was similarly repeated by the Operations team for performance metrics, by Marketing for customer information and so on. In fact, the Chief Financial Officer and I calculated 490 hours – or 3.3 FTEs – were being spent on manually gathering data for routine and standard reporting. If the CEO wished to zoom in on something specific, such as future utilisation, he had to make the decision to pull someone out of the business for a day simply to gather this data.
I established a good relationship with the software vendor but even so it was their policy – not uncommonly – not to provide any assistance or detail on the database structure.
This did not deter me; I identified the dba user account credentials, made an ODBC connection and explored the tables, fields and data. I produced a series of utilities and reports:
- a general-purpose utility to execute any arbitrary SQL query across the entire fleet of databases, returning the results in a single Excel spreadsheet, formatting fields as text, date/time, integer and decimal appropriately. This by itself dramatically cut down reporting time and freeing people to genuinely dig into their data, not simply spend all their time collecting it
- a mechanism to automatically identify visits by patients who belonged to a specific member loyalty scheme, and to calculate their reward entitlements according to compliance requirements
- a daily report to all centre managers detailing their patient re-bookings, along with month-to-date and year-to-date stats. This was a vital KPI for the business at that time, but was previously not measurable. My work helped make it a focus, along with supporting the centre managers by continually displaying their personal results, and those of the group as a whole.
There were more, but these items had a huge impact by themselves. The company ultimately implemented a data warehouse, the work of an internal team and an external supplier, Empired, but it was my work that gave access to the databases, identified the fields and business logic, and gave full access into the organisation’s wealth of data for the very first time.
And much, much more …
I have many other stories, but the upshot is I come with both a deep love for data and a proven track record in bringing success to organisations large and small.
I’d be pleased to speak with you about your data challenges, whatever they may be.
- Do you have delays in getting information out of your applications?
- Do you have a difficult relationship with your application vendor?
- Do you have older databases/applications you are locked out of?
I can help. I enjoy it, and I’ve done it before. Let me know.