Automation of Data warehouse and BNS processing control

Thesis Automation of Data warehouse and BNS processing control deals with design and implementation of automated solution for company Inekon Systems for monitoring notification emails from ETL processing at customers with implemented managment information system BNS. Main objective is to create complex solution which does not only meet all the functionalities of the current manual control but will also inform forward all informations about potential errors to responsible resolver. For optimal error resolution, a new environment has been created where users can note and monitor progress of error resolution from errors found during monitoring. Newly transformed data has been used to create new data dictionary containing all elements and their relationships from newly created solution. Another goal of this thesis was to create several reports and using those reports for brief analysis about optimizing the use of human resources. The fulfillment of main goals was divided into five main chapters, in which it necessary to analyze needs of Inekon Systems as a client, propose a architecture of final solution that will satisfy those needs, implement individuals components of the architecture, subsequently test their functionality and fulfilment of the requirments set in assignment and validate this solution with ordering party. Final part of this thesis is a validation which successfully compared funcionality of the created solution with defined requirments and additional improvements to the individual solution components are proposed.