Outcomes management system for researchers

Client and challenge

The department of St. Petersburg Institute for Informatics and Automation of the Russian Academy of Sciences (SPIIRAS) asked for the application, which could automate the import of the outcomes of academic research and also automate the generation of reports. These reports are recurrently requested by the educational authorities and also used in applications for participation in grants. Such a report could contain a specific set of outcomes of academic research (such as participation in scientific conferences, or publications in SCOPUS-indexed journals, etc.), the template of the report could have different forms and should be built in different formats.

Technologies and solutions

As a full-stack developer and architecture of the project, I developed the structure of the project and the data model for the document database. I implemented the authentication, the major features such as adding and importing *.xls files (and further mapping of the fields) with publications outcomes to the system and also modifying and removing them. Data filtering and batch data manipulation were also implemented and added to the system. The importing of the outcomes from elibrary service was also implemented. The application was optimized for tablet and phone usage. Conducted training and mentoring of interns-developers.

Results

The implemented application allowed the scientific laboratory to automate the submission of reports and applications for grants, and to reduce the administrative burden. The application solved the problem of collecting, processing and updating information about academic outcomes. Several laboratory students involved in the project successfully graduated from the University with the qualification papers based on the basis of the project.

Screenshots

The main view and data filtering
The main view and data filtering
Outcomes data editing
Outcomes data editing
Data validation
Data validation
Mapping of the imported document to the DB fields
Mapping of the imported document to the DB fields
Data editing before adding to the DB
Data editing before adding to the DB
Report export tuning
Report export tuning
List of reports for download
List of reports for download