I have provided solutions to 235 companies and organisations in the UK, Ireland and Australia since 1990.
Here are some of the more recent ones in Australia.
Australian Medical Association Since April 2006 I have maintained and developed several of the Western Australian branch of the AMA’s SQL Server databases. In terms of the number of invoiced pieces of work done, they are now my best customer of all time.
ATI-Mirage I started giving training courses for ATI-Mirage in April 2010. Since then I’ve given over 170 courses for them, mainly on Microsoft Excel, Access and Project. They are currently my 3rd best customer of all time.
Jandakot Airport Since March 2012 I have been developing and maintaining the Jandakot Airport databases. I standardised the user interface of their access databases and then upsized them all to SQL Server.
Foster Care Association In March 2017 I imported highly unstructured data from SharePoint (eugh!) into a proper call log relational database along with tools to clean the data. I then extended it into a standard membership database for the WA branch of the Foster Care Association.
In 2009 I started work on a database for Adoption Jigsaw, a charity that help put adoptees in touch with their real parents and vice versa. As you might imagine, it contains quite complex search algorithms. At the end of 2019 I started work on a new database to keep track of people’s DNA records.
For over three years, from September 2004 until January 2008, I was employed as a part-time database administrator / developer at Perth Airport. This involved building and maintaining various Microsoft Access front-end databases to a SQL Server back-end.
And here are some of the not so recent ones that I have done most work for over the years.
It’s amazing to think that even 20 years after I last did any work for the British Council, they still remain my No 2 customer in terms of revenue. Almost from the start as a self-employed contractor they used me as a trainer and database developer. Almost of this work was in London.
One of my first regular jobs in Australia was to give Access and Excel courses for a software training company called “New Horizons”. In fact if one subtracts the date of the first invoice from the last, I’ve worked for them longer than anyone else – over 14 and a half years. They changed their name to TrainSmart a few years ago and no longer do the Microsoft classroom training I used to do with them.
My 7th best customer of all time (in terms of revenue) is still currently Microsoft. From March 1993 until August 1996 I did 56 pieces of work training SQL Server, Access and FoxPro. I also wrote course materials for the later two database products.
My big break was to join the PC database company Ashton Tate as a SQL Server and dBase IV trainer in 1988. After a restructuring, they kindly gave me the opportunity to go self-employed whilst semi-guaranteeing regular training work with them for six months. This is the perfect way to become an independent consultant and the work they gave me for the two years after starting up Customised Training Solution (the name of my business in the UK) is still 9th best on my all time list in terms of the number of invoices raised.
Having learned Ashton Tate/Microsoft’s version of SQL Server on the PC platform, it was a logical step to work for the company that designed the database in the first place. I gave the first of 29 courses for Sybase UK in Wokingham in August 1990 and my last about two years later. Whilst working for them I had to learn a bit of UNIX and its lovely, friendly commands such as “grep”, “awk” and “ls”.
One of the databases I built which I am most proud of was a competency management system built for FMG (Fortescue Metals Group). From June 2009 until September 2010 I took their original system (a single Microsoft Excel workbook with a matrix of staff, competencies and hyperlinks to scanned certificates) into a proper relational database (in Access) and then upsized it to SQL Server. “CrewMaster”, as it was called, included a nightly job that automatically reminded people when they were due to renew a competency that was about to go out of date.
I also regularly gave training courses for some companies in the UK and Australia that no longer operate. Notably, AZLAN, was one of Microsoft’s leading Training Providers for years. I gave 64, mainly SQL Server, courses for them from 1993 until 2001. In Australia I gave courses for Sigma training, Alphawest and Mobile Mouse.