|
|
digitalKnowledge Solutions |
|
 |
We answer your complex business problems by developing
solutions that combine people, processes, and technology to
drive positive results.
Learn More |
|
|
|
|
Enhancing Reporting Capabilities for a Worldwide Banking Solutions Provider |
[Read Full Case Study]
|
Client |
Indianapolis-based provider of software and
integrated services to banks, credit unions, and
financial services companies. For more than two
decades, the organization has developed leading-edge
commercial loan origination and relationship management
solutions that address the fundamental business process
needs of its 1,100 customers. |
|
Challenge |
To maintain and continue to grow its client base,
management needed to extend the reporting capabilities
of its current business process and relationship
management application. Clients only had access to
basic, operational reports and despite having the
capability to write their own ad-hoc reports, the
complex nature of the underlying data structure made
this task nearly impossible. With the impending release
of the next version of the application, executive
management determined these capabilities were critical
to future product success. |
|
Solution |
Working together with key stakeholders and subject
matter experts, digitalKnowledge led the organization
through detailed assessment, design, build, and test
phases. The solution encompassed the development
of a streamlined and simplified data structure, multiple
ETL data movement routines, and a semantic layer to
further hide the complexities of the database schema and
enable end users to build custom ad-hoc reports. The
final solution leverages a combination of SQL Server
2000, Data Transformation Services (data movement), and
the BusinessObjects® XI Enterprise suite of tools
including Crystal Reports® XI. |
|
Results |
The Reporting Framework solution has significantly
reduced the underlying design complexities of the transactional
database and the data access layer further improves its
ease of use. Initial application benchmarking showed that query
performance has significantly improved and the universe
provided the needed simplification, organization, and
data access to
enable end users to create their own ad hoc reports. By leveraging
the new reporting functionality, external clients have
improved access to customer relationship data. The
extensibility provided by the new reports has enhanced
their degree of certainty, enabling them to make more
informed business decisions. |
[Go to Top]
|
|
