Case Studies

Here are some highlights of the projects performed in the last few years:

Fletcher Building Steel Group; Dimond (Roofing):
Major Projects have included:

  • Cognos 7.2 based business intelligence reporting systems based on the ‘BPCS’ ERP system using SQL Server 2000 and Cognos DecisionStream covering a diverse range of requirements.
  • KPI identification for periodic management reporting
  • PDF Customer Pricebook production (with extensive graphics) managed in a Sharepoint 2000 intranet site
  • Cognos Planner enhancement and integration with BPCS Actuals and with Cognos Reporting for Budget information.

Fletcher Building Concrete Group; Golden Bay Cement:
Major Projects have included:

  • Data Warehouse Rebuild using SQL Server 2005 Integration Services and based on the JDE ERP system
  • SQL Server 2005 Analysis Services Rebuild
  • Sales and Dashboard Reporting
  • Custom Training Courses covering Cognos 8.2 Report, Analysis and Query Studios
  • System Management, Support and Development Mentoring

Future Work includes:

  • Weighbridge System Integration to JDE
  • Continuing to develop the Cognos 8.2 environment to enable the retirement of several diverse reporting systems

Fletcher Building Steel Group; Easysteel (Steel Merchants):
Major Projects have included

  • Cognos 7.1 based business intelligence reporting systems based on the ‘BPCS’ ERP system using SQL Server 2000 and Cognos DecisionStream. Highlights include:
  • Manufacturing Exception Detection, Freight Recovery Analysis, Inventory History, Stock Trend Exceptions, General Ledger Analysis, System Management and Support

Future Work includes:

  • Management of Cognos and MS SQL Server Upgrades for Dimond and Easysteel and the Integration of Easysteel Data Warehouse with Cyclone Wire information

Reproduced with the kind permission of the clients mentioned.