BUSINESS INTELLIGENCE TECHNOLOGIES AND ECM-SYSTEM FOR A MULTI-INDUSTRY CORPORATION

A global multi-industry corporation comprising assets in power engineering, machine engineering, and construction. It includes over 350 enterprises and organizations employing a total of about 250.000 people.
download pdf

Domain:
Construction and Engineering

Budget:
$2.000.000 +
Team:
13 developers, 4 QA engineers, 2 Team Leads, a Project Manager

Duration:
4 years

download pdf

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.
However, the achievements reached after the transition to paperless document circulation appeared to be a short time-out before taking inevitable steps on the way to further transformation. There were still critical issues to deal with: the amount of time spent on working with documents continued to be huge and the analysis of staff productivity left a lot to be desired. Being a corporation with more than 200.000 employees, the customer had substantial difficulties in controlling their staff performance. The assignments were not always carried out on time. In the case of a small company, where flaws can be easily detected and fixed, it’s not disastrous at all. But for a huge one, with a number of interconnections, any delay or lack of coordination may entail giant losses and deadline shifts. Under these circumstances, automated reporting and a holistic, in-depth analysis of unit and staff performance are not just optional though favorable attributes but necessary conditions for future development.

Task

*instinctools team was supposed to improve 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.)

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

Key features

C09C7B0B-CC9C-49D8-8F09-8501116012C3

upgraded UI/UX design

CECCA036-B49C-4ED0-BFC3-38E935283BB2

the possibility to “slice and dice” big data

74B3C73D-5536-4104-AB5D-3EE82A07BB86

historical data preservation

Access Control List integration

Benefits

  • The customer’s got an illustrative view of current - and past - work processes
  • Reports have become more informative
  • It’s become possible to rapidly direct attention to what is really important for the time being
  • The time for flaw detection has been decreased
  • Thanks to ACL integration, reports are now available to a wide range of employees according to their access rights, which fosters the proper distribution of responsibilities
  • End-to-end control principle provides the executives with the ability to control the fulfillment of their instructions at every stage and level of the organizational hierarchy
  • Data export in different formats permits to do post-processing in third-party applications, thereby making data analysis even more thorough.

Technologies

  • ECM Documentum
  • JasperReports
  • Oracle Database
  • Propriate SW (Spring, Java)

Do you have a similar project idea?

Anna Vasilevskaya
Anna Vasilevskaya Account Executive

Get In Touch

Drop us a line about your project at contact@instinctools.com or via the contact form below, and we will contact you within a few business days. All submitted information will be kept confidential.

    Full Name
    Company
    E-mail
    Phone
    Describe Your Idea

    I consent to the collection, storage and processing of the data which I provided in the contact form. This data should be deleted after processing of my request is complete.

    yes

    Please, check in the box to let us use the entered data