Customer References

Richard set up an analysis platform for Commonwealth Bank’s core banking applications using SQL Server 2005 and Itanium 64-bit Windows servers.  The database processes over two Billion records and provides sub 5 second ad hoc query time. Case study video 1.  Case study document.  Richard has also created the OraclePerformance Cube to manage a 6 node RAC cluster. Case study video 2.

Richard helped DEWR perform an early (beta) migration to SQL Server 2005.  DEWR used the relational capabilities of SQL Server and Analysis Services, Integration Services and Reporting services.  All of these services were on Itanium 64-bit Windows servers.  Case study (writeup).  Case study video.

In 2004, Richard worked with Channel Nine to create a data warehouse and business intelligence solution incorporating sales, price sensitivity, fill rates, viewer ratings and demographics.   This case study demonstrates Richard Lees combination of business and technical skills.

Here is an example of Richard’s technical strength.  One of Richard’s widely used innovations is Web/proxy Analysis.  It provides powerful OLAP analysis of web sites and is used by many organisations around the world.  The International Rugby Board used Richard’s tool for the Rugby World Cup 2003.  This project provided continuous ad hoc analysis of the half Billion hits to the RWC web site, as it was happening.  Case study.

In 2003, Richard helped ComputerFleet and their BI partner (Angry Koala) come up with a revised business strategy that involved a bespoke Data Mining application using Decision Trees to predict inertia of their leased assets.  Case study.

Richard worked with ASB Bank to formulate a new business strategy that enabled them to exploit their 1 terabyte data warehouse by providing nationwide business intelligence tools to branch staff.  Richard was the technical lead and strategic innovator in this multi-disciplined team and provided the ASB bank with skills to ensure the continued success of the data warehouse.  Case study and video

The New Zealand Defence Force employed Richard to create ad hoc ability to query all internal and external email movements. Case study

Richard helped New Zealand’s largest company, Fonterra, build a Supply Chain Management system that was continually updated, close to real-time and continuously available.  Full case study, and as reported in ComputerWorld.

Sue Abishara, InsuranceLine, Sept 2007  “Thank you for ALL your help last week.. Our business stakeholders are struggling, no, failing to control their excitement. ... the assistance you provided in 2 hours last week completely SAVED our client data migration. Our initial migration was taking 300hours! You managed to streamline the process to complete in 1 HOUR!! So awesome“