Automated creation of Product Quality Reviews

The intelligent automation of the creation of product quality reviews for a leading manufacturer of high-quality Pharmaceuticals was a challenge lexoro gladly accepted. Quality assurance meant a very high time commitment for the client, often an entire team did this task full time with annual review required.

The challenge

The manual compilement of all relevant information from various systems for the PQR and own product quality reviews for each product group did mean a very high time expenditur. lexoros challenge: An intelligent automation of the data collection, filling and document generation of product quality reviews.

The problem

  • very high time expenditure
  • manual compilation of all relevant information from different systems
  • document generation of PQR for each product group


Our customer is a leading manufacturer of high-quality Pharmaceuticals and sells it’s products in around 120 countries worldwide. The product range includes generics, specialty Pharmaceuticals and prescription-free consumer healthcare products

The solution: Intelligent Automation of PQR with lexoro

To optimize the PQR, lexoro has automated the Data transfer processes through 100% error-free RPA technology. Thanks to the RPA and NLG technology implemented by lexoro, the client could benefit from time saving or automation level of about 70% and top experts can focus on other topics.

The process

Together with the customer, an automated database query was defined according to clearly defined search queries, search strategies and the databases to be searched (BfArM, FDA, MAUDE, ANSM and AEMPS). The crawler technology implemented by lexoro searches the databases, collects relevant data and information using RPA and automatically generates a standardized list of all hits for further use. A serial and very time-consuming database query has been transformed into an automated process that optimizes the monitoring of medical devices and guarantees significant time savings.

1Templates & Data Sources

Definition of the structure of the template, the tables and relevant data from associated data sources used for populating

2Copying data & information from in-house systems

Software robot automatically copies & collects relevant data from in-house systems (e.g., SAP, ELN, LIMS, etc.) or as document upload (Word, PDF, Excel, etc.)

3Populating the template or tables

Fully automatic populating of defined templates & tables with relevant data

4Generation of the PQR & Export

Final generation & export of templates with populated text sections & tables for further processing

The benefits for the customer

75% time savings in information retrieval, 50% in classification & evaluation
  • Enormous reduction of lead time for a process that always runs the same way
  • Automated database search with results & outcomes in real time
  • 100% error-free & robust Robotic Process Automation crawler technology
  • Relieve and empower employees by saving time – better analysis possible
  • Fast solution development according to your needs – directly measurable ROI

The savings potential achieved

4000 h / 300.000 €
Reduction in work performed per year. Total up to 3,5 FTE at 70% PQ

Have your savings potential calculated now!

Do you want to write your own success story with the help of intelligent automation? Contact our experts for RPA, NLP, NLG
and Machine Learning and learn how much you can save with the innovative automation of your workflows and processes.

Your contact person

Michael Fischbäck

Business Development Consultant

Downloads and further content on the use case


View mockup