Multinational pharmaceutical and healthcare company.
Scientist has a biological sample inventory report with several data collection file (DCT) templates in MS Excel format and registered in different inventory systems.
Data are separated in different DCT according to type of samples. VBA macro perform few checks i.e. dictionary-controlled values, missing mandatory data/ However due to the diverse data and complex level of detail, there is a need to find a more reliable, robust and accurate solution to perform data quality checks.
*Python *AWS *REST API *EventBridge