About Amber Green Consulting

We are specialists in social housing business systems and data

What We Do

Amber Green provides data visualisation, transformation and bespoke solutions to social housing organisations. Transforming the huge amounts of data held in housing management, finance and other systems into meaningful information helps improve service delivery and customer experience. Data is delivered in accessible visual forms including interactive charts, tables and maps.

We use tools including Business Objects, Microsoft SSRS and Power BI to produce reports and dashboards, and where required build datamarts or data solutions to deliver required information.

Microsoft Power BI is an exciting tool enabling development of highly interactive and accessible browser-based reports and dashboards.

We also offer Business Objects universe development and customisation, as well as system implementation and system administration services.

Who We Are

Mark Duffill is the director of Amber Green Consulting and has over 25 years' experience in housing IT in the social and voluntary sectors. He has recently worked for four years with Orchard Information Systems on the design and development of their latest generation data and reporting architecture - the Information Management System (IMS) and data marts.

He also works with Manifest-IT Ltd, Chartered Institute of Housing and HGO Consultancy Ltd.

Mark also has extensive business experience in the housing sector, having previously held Head of IT positions at:

  • Stonham Housing Association
  • National Housing Federation
  • Shelter
  • Cornwall Supporting People
  • Carrick Housing Ltd
  • Cornwall Housing Ltd

Amber Green’s associate consultant, Jack Young has undertaken programming work for Amber Green’s projects since 2010. Jack is a talented ASP.NET and SQL programmer. He graduated from Trinity College, Cambridge in 2008 with a First Class Honours Degree in Natural Sciences, and prior to this reached the top 5 in the UK at the British Informatics Olympiad. Jack programmed the web-based user interface on our KPI Generator product, and is currently developing websites. Jack is a qualified Maths teacher and has also worked at OFSTED, using SQL and Tableau for statistical analysis and data visualisation.