Project Type: Data Management
Industry: Financial Services
Business Challenge
Utilizing a data warehouse to store various financial data, our client manages a tremendous amount of unstructured information, causing slow system response times. Looking to extend their capacity, they asked Sprinterra to recommend and implement a solution that could handle a significant amount of data with added reporting capabilities.
Solution
The Sprinterra team created an ETL process using Pentaho Kettle, which allows data to be pulled from seven different independent sources under defined rules, then prepares it for further processing. OLAP-cubes were also added, decreasing the time it took to process requests, thus reducing system latency. Sprinterra also developed reports capable of compiling data from multiple sources in one easy to view document.
Benefits
- Increased performance
- Reduced system response time
- Enhanced reporting capabilities
- User-friendly reports
- Increased efficiency while handling high reporting volumes
Technologies
- Soap UI
- Java
- Selenium
- Groove