Sign In
RichardLees Web Site
Skip navigation links
Richard Lees
About Richard Lees
EasternMining Services
Customer References
Data Mining
Perfmon Cube
Web/Proxy Analysis
OraclePerformance Cube
Useful Links
Downloads
Lees Family Page
Search
Business Intelligence
BI Demonstrations
Live Data Mining Demonstration
SQL Dashboard
Perfmon Dashboard
Excel Services Demonstration (New Zealand Census)
Australian BI Partners
BI for Mobile Devices
BI Blogs
  
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“ 

 
MobileMessengerAlek Zdziarski, CIO MobileMessenger, Dec 2008 "It is rare to find someone who talks as knowledgably as you do and is still doing the deep technical work as well.  Its been a very fruitful relationship, and I really believe we would be miles away from a working datawarehouse and cube without your help."