Virtual Colour Systems Information

Data and Software Engineering Consultancy. Formed in 1997 as an IT consultancy to help support my doctoral research in colour science (specifically physical colour order systems): hence the name Virtual Colour Systems (the latest iteration of this research - coded in C# and Blazor - is accessible thought the Virtual Colour Atlas link). The ability to work in both the traditional world of coding (procedural and OO thinking) and data engineering (sets and functional languages: SQL, MDX and DAX) provides a unique hybrid skillset allowing for the design and development of end-to-end systems that employ disparate technologies. Weir is an example of this thinking: write the IBM Turbo Integrator ETL jobs to extract data from the TM1 cubes and the WPF, C# and Javascript application that securely presented the data in dashboards on iPads and Microsoft Surface devices. Glasgow Caledonian University was transferring data from an in-house student IT system to a packaged solution that involved extensive SQL and SSIS skills for the core data. The student images however were held in a non-standard format that the original provider stated could not converted, however using coding skills the images were byte analysed and code was developed that extracted the raw data (image, colour depth, width, height) and re-constructed it as a jpg. Performance tuning. VCS has performance tuned applications, databases, cubes and ETL jobs. Scottish Widows in-house application was modified to run 11 times faster. The Azure process (database -> DataFactory -> cubes -> PowerBI) at ScotRail that took 3 hours and 45 minutes was redeveloped to complete in less than 15 minutes. A Standard Aberdeen SSIS job was recoded in C# from 52 minutes down to 2 minutes. The databases load at Cigna that took nearly 2 hours had the SQL re-worked and subsequently loaded in 8 minutes.