While managing the Oracle DBA team Richard set up an analysis platform forCommonwealth Bank’s core banking applications using SQL Server cubes to get insights from the Oracle RAC cluster. The database processes over two Billion records and provides sub 5 second ad hoc query time. Case study video 1 and Case study video 2. Case study document. Richard’s OraclePerformance cubecould be used to help manage any Oracle database/cluster.
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 high performance Itanium servers. Case study paper. 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.
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, close to real-time. 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.
In 1998, Richard worked with ASB Bank to formulate a new business strategy that enabled them to exploit their vast Oracle 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 engaged Richard to create a monitoring and trending tool for 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 updating, close to real-time and continuously available. This revolutionised their business, as they can now confirm orders on-line and dynamically adjust manufacturing based on contracted demand. Full case study, and as reported in ComputerWorld.
Richard’s clients have been, without exception, more than satisfied with his contribution. Here are a few unsolicited feedback items.
Yousseff Bardouh, Macquarie Bank “Richard … demonstrated his experience and deep knowledge of the environment with the Microsoft BI stack (SSIS, SSRS, SSAS) and delivered on complex business problems without issues with a very satisfied group of business stakeholders.“
Alek Zdziarski, MobileMessenger, “Richard is the full Datawarehousing and BI deal. He has superb breadth and depth on his subject. He took us from two times data warehouse failures to successful design and implementation in three months.”
Kelvin Lim, CommBank, “There is no better man for any BI or DBMS work. Richard has a unique ability to construct, articulate and then quantify his thoughts with data. Richard was originally brought in for a specific deep DB issue, however he certainly surpassed all expectations by continuing to help, own and improve so many other areas of our business. His ability to influence technicians through to executives has certainly had a huge positive impact on our workplace. ”
Ben Wang, CommBank “There is no better man for any BI or DBMS work. Richard has a unique ability to construct, articulate and then quantify his thoughts with data. Richard was originally brought in for a specific deep DB issue, however he certainly surpassed all expectations by continuing to help, own and improve so many other areas of our business. His ability to influence technicians through to executives has certainly had a huge positive impact on our workplace.”
Matthew Pauliukevicius, Australian Government Department of Employment "Thank you for providing us with your vast expertise on Monday and Tuesday. I know George and David were extremely pleased with the advice you provided."
Keith Roscarel, Channel Nine, “It was a pleasure having worked with Richard. He successfully delivered a comprehensive Business Intelligence solution as well performing ongoing essential efficiency improvements within our key transactional systems.”
Sue Abishara, InsuranceLine, “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“
Robert Reid, New Zealand Treasury, “”Richard up-skilled our team in MS SQL server extremely quickly. I drew on what he taught me for years afterwards. He not only has a superb understanding of database technology but he also understands business requirements very quickly, and he's a very effective teacher. An all-round great guy to work with.”