A leading global developer and manufacturer of oil additives.
Spreadsheets were used to store data on the specifications met and approvals gained for a number of their products. There was a need within the business to structure this data and make key parts of it available to those on the ground who were marketing these products. We were charged with formalising a data structure and producing an application with advanced reporting capabilities that made this data accessible to other parts of the business.
A database with a web of complex relationships was designed and implemented using Microsoft SQL server and a web application was developed leveraging Silverlight and asp.net.
An application was written as a front-end to this database. Tools to allow data to be imported from different external sources as well as a custom report creator was developed to allow different types of users to obtain different views of the data.
Today this application draws together data from a number of different sources including spreadsheets and legacy databases to provide a powerful tool for information sharing across the business.
- SQL Server