A Professional Services Company
Centralized Data Hub for Improved Data Discovery.
Our client needed to search contract data and supporting documents across multiple source applications, but the current applications didn’t make this possible, causing the search to be manual and time-consuming.
2nd Watch built a custom data hub for improved data discovery.
The new data integration and data discovery solution reduced the data gathering and research time dramatically and increased productivity of the team.
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.
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 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
- An extensible platform to accommodate additional data sources in the
- Strong return on investment with a payback period of less than two
- 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