
The client is a leading life science and clinical research company today. It is also one of the trusted suppliers of analytical instruments, and provides clinical development solutions, specialty diagnostics, laboratory, pharmaceutical and biotechnology services.
Despite being one of the leaders in advanced clinical research, the client was using dated processes and technologies for managing their research documents. All the details of the published scientific documents like the name of the authors, portfolio, Oncomine assays, journal name, year of publication, were stored in Excel spreadsheets. This led to various inadequacies.
The CRUD (Create, Read, Update, Delete) processes were not properly defined. As such errors in uploading documents were not uncommon. The process was also time-consuming and hence, they were looking for a more efficient process
Since the data were primarily stored in Excel spreadsheets, the data was unstructured. This made it difficult and time-consuming to find the right documents. Since different team members were uploading the documents, it was challenging to maintain consistency.
Since the files were stored in Excel format, collaboration was limited. Different users could not work on the same file simultaneously. This compromised the productivity of the team, as a single document needed to be worked on for a prolonged period, delaying the overall process.
Security was also a major concern as most of the documents contained sensitive information. Managing access to Excel files and keeping them secure from modern security risks was challenging, to say the least.
Since the data were primarily stored in Excel spreadsheets, the data was unstructured. This made it difficult and time-consuming to find the right documents. Since different team members were uploading the documents, it was challenging to maintain consistency.
Since the files were stored in Excel format, collaboration was limited. Different users could not work on the same file simultaneously. This compromised the productivity of the team, as a single document needed to be worked on for a prolonged period, delaying the overall process.
Security was also a major concern as most of the documents contained sensitive information. Managing access to Excel files and keeping them secure from modern security risks was challenging, to say the least.
The client was looking for an innovative solution for their challenges and they needed a partner with expertise. Hence, they contacted Evolvous. After the initial discussion, we identified Microsoft SharePoint, Power Apps and Power Automate to form the foundation of a comprehensive document management system which will enhance the overall efficiency
Our first aim was to make the process of uploading scientific documents easier, without compromising on efficiency. Therefore, we designed and developed a web-based application based on Microsoft Power Apps. With the application’s help, the users can now add new documents, update, and view existing documents.
The app also made searching for documents easier. The user could apply different filters and find their desired document easily and quickly.
The entire process of uploading research documents contained several individual tasks which were repetitive in nature. Therefore, they delayed the process unnecessarily and led to errors. Our team leveraged the capabilities of Microsoft Power Automate to automatically execute the interconnected tasks.
We used cloud flow for automating the process, as it provided with the desired flexibility and scalability. With the help of the flow, we were able to automatically extract all the publication details into a consolidated CSV file and then send the CSV file as an email attachment to the individual who has requested the information. This significantly reduced the time and effort spent on making information requests and follow-ups.
Once the data was uploaded through the application, it was routed to the SharePoint Document Management System (DMS) that we have built for the client.
So, why did we choose SharePoint? This was because it helped us address three key issues faced by the team.
First, it brought the much-needed structure to the data. By utilizing SharePoint libraries and their in-built organization features, we arranged all the files in an efficient way, just as the client required.
Secondly, SharePoint also made it easier for users to collaborate on the document. Several users can now work simultaneously on a single file and seamlessly share the document with their team and/or across the organization.
SharePoint also offered excellent security features, which protected the confidentiality of the documents. We also helped the client set up user roles and granular access, which allowed only authorized personnel to access the file.
After our solution was successfully deployed, the client had access to a single unified platform where they can add, update, and view complete data. With improved searchability, finding the right document is not an issue anymore. Overall, this improved the way the organization managed their scientific documents and enhanced efficiency.

Lower Security Risks

Faster Threat Response

Users Impacted