Blog Archives

Our recent projects

Everything Everywhere

EE required specialist knowledge to create a series of reporting solutions for the launch of the 4G network and EE brand. Engaged to analyse data and develop reporting solutions using SAP, Business Objects, VBA and SQL

Posted in Uncategorized | Comments Off

Frutarom UK

Frutarom required data from its global operations (daily) to facilitate consolidated reporting. Engaged to develop a robust batch solution to automate this process. Engaged with key stake-holders; assessed business/ data requirements; designed data extraction using Transact SQL; created DTS / … Continue reading

Posted in Uncategorized | Comments Off

GE Capital

Engaged to optimise financial database design and improve performance. Assignment included engaging with stakeholders to understand business requirements; defining application / data requirements; designing data extraction using native SQL to Ingres data warehouse and building Access forms to simplify UI … Continue reading

Posted in Uncategorized | Comments Off

GE Capital

Engaged to lead multiple changes / enhancements of car sales database following major business and regulatory changes. Project included redesigning VAT processing from hard to soft-coded; defining complex business rules for 3 VAT rate changes; automating auction house receipt data; … Continue reading

Posted in Uncategorized | Comments Off

GE Capital

Engaged to develop a reporting tool to help GE’s finance team produce statutory accounts reports. Engaged with finance users and stakeholders to scope requirements; designed / architected solution; built tool using Access 2010 (acquiring data from Oracle data warehouse); and … Continue reading

Posted in Uncategorized | Comments Off

NHS

Engaged to lead data migration project for Newcastle, North Tyneside and Northumberland Mental Health NHS Trust. Project involved migration of data from 8 existing standalone child health and psychology systems (Access 2000 and SQL6.5 systems) to a new ASP.NET / … Continue reading

Posted in Uncategorized | Comments Off

Scotia Gas

Scotia Gas (formerly National Grid Transco) needed to replace Lotus Approach systems with Microsoft technologies. Engaged to develop a new solution and consolidate / migrate data from multiple Approach databases into Microsoft Access 2000. Engaged with business users; analysed Approach datasets; … Continue reading

Posted in Uncategorized | Comments Off