Microsoft License Statement
We built the very first License Entitlement Report for Microsoft in 1999. Later we re-wrote this as the Microsoft License Statement ("MLS"), although it long retained its friendly name the "Claret Report". We developed matching algorithms to determine entitlement based on historical purchases and product upgrade rules. By 2010 Microsoft Redmond had caught up - with help from us - and released their corporate version of MLS which is now fully integrated into the central licensing systems.
BA's Cabin Crew Forecasting process was overhauled with our help. In common with many organisations Excel spreadsheets ruled the roost. The increasing number was becoming unmanageable. We reviewed the entire process, designed a centralised approach then built a new automated Excel solution connected to a central Oracle database. We received rave reviews in the BA Manpower Planning magazine for the "Matador" project implementation.
A company wide infrastructure refresh became a concern for the prime project sponsors. We were asked to come in to put the project back on the right path. A roll-out was due to be completed by June that year. We found that the IT team had no comprehension of the timescales, thinking they were running a Pilot study. We took some strong action by restructuring the team, appointing a new Project Manager, setting an aggressive deadline for the next phase and enlisting some 3rd party resource. The deadline was met without further issue.
Autodesk wanted to reach many more small customers than was possible with a traditional telesales approach. We developed a process based on our SASS ® campaign tool that provides a significant increase in Return on Investment in this market. Over 100,000 customers went through the process around the globe in several local languages.
On of the biggest problems Microsoft faced in managing licensing contracts was understanding customer organisational structures. Many organisations consist of multiple subsidiaries and affiliates. Microsoft did not have a clear maps of these and therefore did not accurately understand their license entitlement. To overcome this we built our Advanced Profiling Tool - APT. This imported and matched organisational and contract information from sources such as D&B and internal sales systems. This is a complex area involving pattern recognition of names, emails, addresses accounting for data entry errors and language differences. We built this far more quickly and accurately than Microsoft could.
We have helped resolve countless cases of "spreadsheet hell" - operations that have evolved to use a great many creaking spreadsheets to run the business. Contrary to expectation this happens a lot in large organisations even with good IT support. People like spreadsheets so they share them and enhance them. Before long business critical data is held in many of them and no on understands how they work anymore. We regularly turn these nightmares into a structured data solution. This will use existing central databases, or we create a new corporate database resource. The front end may remain Excel, after all Excel has great presentation and formulaic tools, or we create an internal website.