PROJECTS AND ACHIEVEMENTS
Challenging projects for unique businesses across different industries deserve bespoke solutions
Read some of our success stories to see how leading organisations have benefitted from combining our external experience and expertise with their in-house knowledge.
Exception based interactive dashboard
Agile implementation of an availability tracker to improve inefficient stock allocations. We used a prototype to liaise between business stakeholders, data stewards and technical teams. We designed, developed and implemented a dashboard solution based on our findings and feedback.
Migration of customer data and preparation for GDPR
Preparation and support for the migration of customer related data to a cloud provider. We assessed data quality before advising on and executing data cleansing. The solution utilises third party APIs for verification of customer data at point of entry. The concept of golden records further reduced duplicates of customer profiles.
for a luxury retailer
Data quality analysis with regard to the completeness, accuracy, duplication, consistency and referential integrity of data, as well as identification of gaps, irregularities and dependencies that could lead to problems during upcoming migration. We generated SQL scripts during data migration phase along with recommendations to maintain good data quality going forward.
Optimisation of SAS data provision
Reporting platform for a Customer Relationship Manager
Portfolio Manager cockpit dashboard
We optimised ETL processes for an international insurance company achieving a 90% reduction in ETL processing times.
Adjustment of the behaviour score to the local platform within the context of the IFRS9. The challenge was to readapt the previous existing scoring system to the new requirements of the IFRS 9 standards.
Design, development and implementation of exception-based reporting solutions for the management of project portfolio risk. During the data discovery phase we combined data from various sources into a central data lake. We then used Spotfire for data exploration and based on our findings designed, built and implemented dashboards to replace inefficient reporting suites.
SAS credit scoring
Conceptual design, implementation and operation of an international credit scoring framework, including model validation, default processing and risk reporting.
SAS systems architecture
Developing a system architecture – including an authorisation hierarchy – and its subsequent implementation at numerous large banks for the use of SAS platforms internationally. Following implementation we continue to offer user support and update the design and implementation of the system.
SAS portfolio analysis
Design and development of a framework to monitor the service quality.
The client’s inhouse product was replaced by the SAS Solution ITRM.
Design, development and implentation of a BI solution for portfolio level risk management. We created the framework and the data model, implemented the data processing and supported the roll-out.
LPS project at Santander
Numerous tasks were carried out surrounding the implementation of the IFRS9 standards, including a gap analysis between IAS39 and IFRS9 calculation methodologies for the parameters. Once implemented, the calculations of the parameters were validated and tested.
Analysis and evaluation of passenger tracking data. Combining data from various sources with different characteristics to form an optimal and thorough understanding of passenger journeys, bottlenecks and waiting times. We advised on staff schedules and dynamic passenger routing to reduce overcrowding at specific locations.