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.
Amber Green provided a unique data and reporting solution using Orchard IMS and Business Objects. This enabled us to meet specific business needs for reporting on adjusted arrears data, along with many other calculated data items
As Orchard Housing has limited ability to audit data items, to measure the success of our Customer Census, we needed a system to capture snapshots of data from Orchard Housing (including bespoke items) and report on data completeness and quality over time. Amber Green delivered this for us using SQL Server and Business Objects