A Professional Services Company

The Challenge

Our client’s audit data requests were delayed due to disparate data with no connections. They needed to search contract data and supporting documents across multiple source applications, but the current applications did not provide this functionality. Therefore, all the searching and combining was manual and very labor-intensive. They looked to 2nd Watch to provide streamlined data discovery for contract data and collateral documents.

The Solution

2nd Watch worked with the client to understand their manual process and the variety of data sources, and our team recommended integrating the data from multiple disparate data sources into a single data warehouse. We developed a data hub and data warehouse, leveraging our ETL framework that automates the creation of SSIS ETL packages and dramatically decreases development time with improved quality.

2nd Watch also developed a data discovery application to slice, dice, and search contract data across applications. The front-end search capabilities were enabled by QlikView associative search.

The Outcome

The new data integration and data discovery solution reduced the data gathering and research time by 97%, enabling their employees to more easily find the collateral needed to support audits and increasing the productivity of the client business team. The solution provides:

• Quick response to auditor request for documentation
• Flexible data discovery capabilities that allow business users to link
  data across multiple systems and facets, which is not possible
  manually
• An extensible platform to accommodate additional data sources in the
  future
• Strong return on investment with a payback period of less than two
  years
• 2nd Watch built the solution in multiple releases based on source
  systems to achieve fast results and allow the benefits of the initial
  release to fund subsequent releases