Dun & Bradstreet Supplier Risk Manager Case Study

About Dun & Bradstreet

Dun & Bradstreet (D&B) provides commercial data to businesses on credit history, business-to-business sales and marketing, counterparty risk exposure, supply chain management, lead scoring, and social identity matching. The company’s database contains information on more than 235 million companies across 200 countries worldwide. D&B has a long history that started in 1841.

Problem

D&B wanted a scalable, integrated web platform for D&B customers to manage their suppliers with supplier certification, financial monitoring, government control list monitoring, and live reports. Subscribers would need to create customer-specific reports, watch lists, and alert features. The platform would also need to support multiple fulfillment options in UI, FTP, email, and web services, It would have to integrate with supplier portals, BPMS for GCL data, and an ESB. And, it would also require a mobile app for customers on-the-go.

Particular challenges were:

  • Fast search based on custom attributes
  • A unique aggregated suppliers’ rating mechanism based on multiple data dimensions (suppliers’ ratings consisting of a set of individual metrics and an aggregate score)
  • Interactive data presentation
Solution

Exadel and D&B built a system that could provide a single score for suppliers based on multidimensional analytics. It includes the largest vendor and supplier database in the world with tens of millions of records, custom search, and drill-down multi-dimensional analytics.

Exadel marshaled together these technologies for the project: JavaServer Faces, JavaServer Pages, Spring, Hibernate, Oracle, MySQL Pentaho, Apache Solr, and olap4j. Here are examples of how Exadel used these technologies in creating the solution:

  • The integration of Apache Solr with MySQL and Oracle databases deployed as clusters to provide high scalability
  • An abstract layer built on top with olap4j (to avoid vendor lock-in) and with automatic recalculation of metrics based on data imported from external data sources
  • A configurable ad hoc dynamic report to display trends over time, drill down to details, and filter by dimensions and metrics
Results

Exadel was able to build a system to present accurate and useful ratings calculated by D&B’s algorithms incorporating fast search capabilities and interactive maps. (75% of users take advantage of the mobile app.) The deployment of this system has significantly promoted D&B’s position as a critical business information provider.

← back