Feb 06, 2022
No image
BI Technologies and ECM-System For An Enterprise
Completed

BI Technologies and ECM-System For An Enterprise

$100,000+
more 1 year
Germany
10+
view project
Service categories
Service Lines
Big Data
Software Development
Domain focus
Other

Challenge

About 150.000 documents of different kinds are created annually within our customer’s concern. As a rule, their life cycle includes alignment, approval, execution, archiving, and storage. Undergoing the aforementioned procedures in the paper-based management system naturally results in huge piles of waste paper, lost documents and a long search for them, numerous copies, delays in sending and receiving the papers, personnel mistakes, etc. All these problems stimulated our customer to implement an electronic document management system.

Solution

Working on the project, our team: reworked the system of report building, optimizing it and making it faster; added the mechanisms of deferred reporting, that allow to run reports as a background task while continuing other work, and dynamic reporting, wherein visualization changes along with data; introduced on-demand reporting and the system of report processing for particularly large and heavy uploads without preliminary preparation; worked out a view-based data model for Oracle DB (including dynamic and materialized views); created a system of templates (including dynamic ones) for data visualization; refined the customer’s internal system, turning it into more intuitive and user-friendly.

Results

*instinctools team improved the already implemented document workflow software, providing the customer with an unblurred vision of work processes and the possibility to analyze personnel performance according to specific cross-sections (e.g. divisions, positions, areas of expertise, etc.).