Automatização de testes com técnicas inteligentes para auditoria de controles

Detalhes bibliográficos
Autor(a) principal: Malta, Décio de Abreu
Data de Publicação: 2021
Tipo de documento: Dissertação
Idioma: por
Título da fonte: Biblioteca Digital de Teses e Dissertações do Mackenzie
Texto Completo: https://dspace.mackenzie.br/handle/10899/28601
Resumo: This research demonstrates the use of automation techniques for auditing tests on controls, where the strategies used to map and design tests performed by intelligent algorithms (robots) were explained. In this sense, the formats of tests and methods for automation that meet the principles and instructions of Internal Audit were evaluated. As a technology, the Python programming language and its various accessory libraries were used, focusing on the automation of activities (RPA – Robotic Process Automation) and manipulation of data as evaluation of algorithms applied to execute the routine and repetitive activities included in the test scripts to assess the effectiveness of process controls. In addition to automation, the evaluations considered the use of analytical bases and machine learning to select situations in which it was possible to identify exceptions that demonstrate whether the control is effective. The developed robots had as an approach to perform a collaborative test and proved to be an efficient tool to aggregate the internal audit activities.
id UPM_2733a2a3b4d8bdcb0cdcdc3d1522d75e
oai_identifier_str oai:dspace.mackenzie.br:10899/28601
network_acronym_str UPM
network_name_str Biblioteca Digital de Teses e Dissertações do Mackenzie
repository_id_str 10277
spelling 2021-12-18T21:44:20Z2021-12-18T21:44:20Z2021-02-05MALTA, Décio de Abreu. Automatização de testes com técnicas inteligentes para auditoria de controles. 2021. 90 f. Dissertação (Engenharia Elétrica e Computação) - Universidade Presbiteriana Mackenzie, São Paulo, 2021.https://dspace.mackenzie.br/handle/10899/28601This research demonstrates the use of automation techniques for auditing tests on controls, where the strategies used to map and design tests performed by intelligent algorithms (robots) were explained. In this sense, the formats of tests and methods for automation that meet the principles and instructions of Internal Audit were evaluated. As a technology, the Python programming language and its various accessory libraries were used, focusing on the automation of activities (RPA – Robotic Process Automation) and manipulation of data as evaluation of algorithms applied to execute the routine and repetitive activities included in the test scripts to assess the effectiveness of process controls. In addition to automation, the evaluations considered the use of analytical bases and machine learning to select situations in which it was possible to identify exceptions that demonstrate whether the control is effective. The developed robots had as an approach to perform a collaborative test and proved to be an efficient tool to aggregate the internal audit activities.Esse trabalho demonstra a utilização de técnicas de automatização para testes de auditoria em controles, onde foram explicitadas as estratégias utilizadas para mapear e desenhar testes executados por algoritmos inteligentes (robôs), seja de forma parcial ou em sua totalidade. Nesse sentido, foram avaliados os formatos dos testes e métodos para automatização que atendam aos princípios e instruções de Auditoria Interna. Como tecnologia, foi utilizada a linguagem de programação Python e suas diversas bibliotecas acessórias, tendo como foco a automatização de atividades (RPA – Robotic Process Automation) e manipulação de bases de dados, a partir desse ponto, foram avaliados e aplicados algoritmos para execução das atividades rotineiras e repetitivas que constam nos roteiros de testes para avaliação da eficácia dos controles dos processos. Além da automatização, as avaliações consideraram o uso de bases analíticas e aprendizado de máquina para selecionar as situações em que fosse possível identificar exceções que demonstram se o controle é eficaz. Os robôs desenvolvidos tiveram como abordagem efetuar um teste colaborativo e demonstrou ser uma ferramenta eficiente para agregar as atividades de auditoria interna.OutrosCia. de Saneamento Básico do Estado de São Paulo - SABESPapplication/pdfporUniversidade Presbiteriana MackenzieEngenharia ElétricaUPMBrasilEscola de Engenharia Mackenzie (EE)http://creativecommons.org/licenses/by-nc-nd/4.0/info:eu-repo/semantics/openAccessautomação de processos robóticostestesauditoriaautomatizaçãorobôaprendizado de máquinaCNPQ::CIENCIAS EXATAS E DA TERRA::CIENCIA DA COMPUTACAO::SISTEMAS DE COMPUTACAOAutomatização de testes com técnicas inteligentes para auditoria de controlesinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisSilveira, Ismar Francohttp://lattes.cnpq.br/3894359521286830Omar, Nizamhttp://lattes.cnpq.br/2067336430076971Bezerra, Luis Naito Mendeshttp://lattes.cnpq.br/2561707241770340http://lattes.cnpq.br/1681561647917008Malta, Décio de Abreurobotic process automationtestsauditautomationrobotMachine Learningreponame:Biblioteca Digital de Teses e Dissertações do Mackenzieinstname:Universidade Presbiteriana Mackenzie (MACKENZIE)instacron:MACKENZIEORIGINALDECIO DE ABREU MALTA -protegida.pdfDECIO DE ABREU MALTAapplication/pdf2725617https://dspace.mackenzie.br/bitstream/10899/28601/1/DECIO%20DE%20ABREU%20MALTA%20-protegida.pdf308f24ece6bba6c97fb1aa3e3a39ced1MD51CC-LICENSElicense_urlapplication/octet-stream49https://dspace.mackenzie.br/bitstream/10899/28601/2/license_url4afdbb8c545fd630ea7db775da747b2fMD52license_textapplication/octet-stream0https://dspace.mackenzie.br/bitstream/10899/28601/3/license_textd41d8cd98f00b204e9800998ecf8427eMD53license_rdfapplication/octet-stream0https://dspace.mackenzie.br/bitstream/10899/28601/4/license_rdfd41d8cd98f00b204e9800998ecf8427eMD54LICENSElicense.txttext/plain2108https://dspace.mackenzie.br/bitstream/10899/28601/5/license.txt1ca4f25d161e955cf4b7a4aa65b8e96eMD55TEXTDECIO DE ABREU MALTA -protegida.pdf.txtDECIO DE ABREU MALTA -protegida.pdf.txtExtracted texttext/plain124571https://dspace.mackenzie.br/bitstream/10899/28601/6/DECIO%20DE%20ABREU%20MALTA%20-protegida.pdf.txtb386e8b5ef696ac6d660520cf0ed7f17MD56THUMBNAILDECIO DE ABREU MALTA -protegida.pdf.jpgDECIO DE ABREU MALTA -protegida.pdf.jpgGenerated Thumbnailimage/jpeg1141https://dspace.mackenzie.br/bitstream/10899/28601/7/DECIO%20DE%20ABREU%20MALTA%20-protegida.pdf.jpg13da673feec766711bd234fc07663febMD5710899/286012021-12-19 03:02:32.698TElDRU7Dh0EgREUgRElTVFJJQlVJw4fDg08gTsODTy1FWENMVVNJVkEKCkNvbSBhIGFwcmVzZW50YcOnw6NvIGRlc3RhIGxpY2Vuw6dhLCB2b2PDqiAobyBhdXRvciAoZXMpIG91IG8gdGl0dWxhciBkb3MgZGlyZWl0b3MgZGUgYXV0b3IpIGNvbmNlZGUgw6AgVW5pdmVyc2lkYWRlIFByZXNiaXRlcmlhbmEgTWFja2VuemllIG8gZGlyZWl0byBuw6NvLWV4Y2x1c2l2byBkZSByZXByb2R1emlyLCAgdHJhZHV6aXIgKGNvbmZvcm1lIGRlZmluaWRvIGFiYWl4byksIGUvb3UgZGlzdHJpYnVpciBhIHN1YSB0ZXNlIG91IGRpc3NlcnRhw6fDo28gKGluY2x1aW5kbyBvIHJlc3VtbykgcG9yIHRvZG8gbyBtdW5kbyBubyBmb3JtYXRvIGltcHJlc3NvIGUgZWxldHLDtG5pY28gZSBlbSBxdWFscXVlciBtZWlvLCBpbmNsdWluZG8gb3MgZm9ybWF0b3Mgw6F1ZGlvIG91IHbDrWRlby4KClZvY8OqIGNvbmNvcmRhIHF1ZSBhIFVuaXZlcnNpZGFkZSBQcmVzYml0ZXJpYW5hIE1hY2tlbnppZSBwb2RlLCBzZW0gYWx0ZXJhciBvIGNvbnRlw7pkbywgdHJhbnNwb3IgYSBzdWEgdGVzZSBvdSBkaXNzZXJ0YcOnw6NvIHBhcmEgcXVhbHF1ZXIgbWVpbyBvdSBmb3JtYXRvIHBhcmEgZmlucyBkZSBwcmVzZXJ2YcOnw6NvLgoKVm9jw6ogdGFtYsOpbSBjb25jb3JkYSBxdWUgYSBVbml2ZXJzaWRhZGUgUHJlc2JpdGVyaWFuYSBNYWNrZW56aWUgcG9kZSBtYW50ZXIgbWFpcyBkZSB1bWEgY8OzcGlhIGEgc3VhIHRlc2Ugb3UgZGlzc2VydGHDp8OjbyBwYXJhIGZpbnMgZGUgc2VndXJhbsOnYSwgYmFjay11cCBlIHByZXNlcnZhw6fDo28uCgpWb2PDqiBkZWNsYXJhIHF1ZSBhIHN1YSB0ZXNlIG91IGRpc3NlcnRhw6fDo28gw6kgb3JpZ2luYWwgZSBxdWUgdm9jw6ogdGVtIG8gcG9kZXIgZGUgY29uY2VkZXIgb3MgZGlyZWl0b3MgY29udGlkb3MgbmVzdGEgbGljZW7Dp2EuIFZvY8OqIHRhbWLDqW0gZGVjbGFyYSBxdWUgbyBkZXDDs3NpdG8gZGEgc3VhIHRlc2Ugb3UgZGlzc2VydGHDp8OjbyBuw6NvLCBxdWUgc2VqYSBkZSBzZXUgY29uaGVjaW1lbnRvLCBpbmZyaW5nZSBkaXJlaXRvcyBhdXRvcmFpcyBkZSBuaW5ndcOpbS4KCkNhc28gYSBzdWEgdGVzZSBvdSBkaXNzZXJ0YcOnw6NvIGNvbnRlbmhhIG1hdGVyaWFsIHF1ZSB2b2PDqiBuw6NvIHBvc3N1aSBhIHRpdHVsYXJpZGFkZSBkb3MgZGlyZWl0b3MgYXV0b3JhaXMsIHZvY8OqIGRlY2xhcmEgcXVlIG9idGV2ZSBhIHBlcm1pc3PDo28gaXJyZXN0cml0YSBkbyBkZXRlbnRvciBkb3MgZGlyZWl0b3MgYXV0b3JhaXMgcGFyYSBjb25jZWRlciDDoCBVbml2ZXJzaWRhZGUgUHJlc2JpdGVyaWFuYSBNYWNrZW56aWUgb3MgZGlyZWl0b3MgYXByZXNlbnRhZG9zIG5lc3RhIGxpY2Vuw6dhLCBlIHF1ZSBlc3NlIG1hdGVyaWFsIGRlIHByb3ByaWVkYWRlIGRlIHRlcmNlaXJvcyBlc3TDoSBjbGFyYW1lbnRlIGlkZW50aWZpY2FkbyBlIHJlY29uaGVjaWRvIG5vIHRleHRvIG91IG5vIGNvbnRlw7pkbyBkYSB0ZXNlIG91IGRpc3NlcnRhw6fDo28gb3JhIGRlcG9zaXRhZGEuCgpDQVNPIEEgVEVTRSBPVSBESVNTRVJUQcOHw4NPIE9SQSBERVBPU0lUQURBIFRFTkhBIFNJRE8gUkVTVUxUQURPIERFIFVNIFBBVFJPQ8ONTklPIE9VIEFQT0lPIERFIFVNQSBBR8OKTkNJQSBERSBGT01FTlRPIE9VIE9VVFJPIE9SR0FOSVNNTyBRVUUgTsODTyBTRUpBIEEgVU5JVkVSU0lEQURFIFBSRVNCSVRFUklBTkEgTUFDS0VOWklFLCBWT0PDiiBERUNMQVJBIFFVRSBSRVNQRUlUT1UgVE9ET1MgRSBRVUFJU1FVRVIgRElSRUlUT1MgREUgUkVWSVPDg08gQ09NTyBUQU1Cw4lNIEFTIERFTUFJUyBPQlJJR0HDh8OVRVMgRVhJR0lEQVMgUE9SIENPTlRSQVRPIE9VIEFDT1JETy4KCkEgVW5pdmVyc2lkYWRlIFByZXNiaXRlcmlhbmEgTWFja2VuemllIHNlIGNvbXByb21ldGUgYSBpZGVudGlmaWNhciBjbGFyYW1lbnRlIG8gc2V1IG5vbWUgKHMpIG91IG8ocykgbm9tZShzKSBkbyhzKSBkZXRlbnRvcihlcykgZG9zIGRpcmVpdG9zIGF1dG9yYWlzIGRhIHRlc2Ugb3UgZGlzc2VydGHDp8OjbywgZSBuw6NvIGZhcsOhIHF1YWxxdWVyIGFsdGVyYcOnw6NvLCBhbMOpbSBkYXF1ZWxhcyBjb25jZWRpZGFzIHBvciBlc3RhIGxpY2Vuw6dhLgo=Biblioteca Digital de Teses e Dissertaçõeshttp://tede.mackenzie.br/jspui/PRI
dc.title.por.fl_str_mv Automatização de testes com técnicas inteligentes para auditoria de controles
title Automatização de testes com técnicas inteligentes para auditoria de controles
spellingShingle Automatização de testes com técnicas inteligentes para auditoria de controles
Malta, Décio de Abreu
automação de processos robóticos
testes
auditoria
automatização
robô
aprendizado de máquina
CNPQ::CIENCIAS EXATAS E DA TERRA::CIENCIA DA COMPUTACAO::SISTEMAS DE COMPUTACAO
title_short Automatização de testes com técnicas inteligentes para auditoria de controles
title_full Automatização de testes com técnicas inteligentes para auditoria de controles
title_fullStr Automatização de testes com técnicas inteligentes para auditoria de controles
title_full_unstemmed Automatização de testes com técnicas inteligentes para auditoria de controles
title_sort Automatização de testes com técnicas inteligentes para auditoria de controles
author Malta, Décio de Abreu
author_facet Malta, Décio de Abreu
author_role author
dc.contributor.advisor1.fl_str_mv Silveira, Ismar Franco
dc.contributor.advisor1Lattes.fl_str_mv http://lattes.cnpq.br/3894359521286830
dc.contributor.referee1.fl_str_mv Omar, Nizam
dc.contributor.referee1Lattes.fl_str_mv http://lattes.cnpq.br/2067336430076971
dc.contributor.referee2.fl_str_mv Bezerra, Luis Naito Mendes
dc.contributor.referee2Lattes.fl_str_mv http://lattes.cnpq.br/2561707241770340
dc.contributor.authorLattes.fl_str_mv http://lattes.cnpq.br/1681561647917008
dc.contributor.author.fl_str_mv Malta, Décio de Abreu
contributor_str_mv Silveira, Ismar Franco
Omar, Nizam
Bezerra, Luis Naito Mendes
dc.subject.por.fl_str_mv automação de processos robóticos
testes
auditoria
automatização
robô
aprendizado de máquina
topic automação de processos robóticos
testes
auditoria
automatização
robô
aprendizado de máquina
CNPQ::CIENCIAS EXATAS E DA TERRA::CIENCIA DA COMPUTACAO::SISTEMAS DE COMPUTACAO
dc.subject.cnpq.fl_str_mv CNPQ::CIENCIAS EXATAS E DA TERRA::CIENCIA DA COMPUTACAO::SISTEMAS DE COMPUTACAO
description This research demonstrates the use of automation techniques for auditing tests on controls, where the strategies used to map and design tests performed by intelligent algorithms (robots) were explained. In this sense, the formats of tests and methods for automation that meet the principles and instructions of Internal Audit were evaluated. As a technology, the Python programming language and its various accessory libraries were used, focusing on the automation of activities (RPA – Robotic Process Automation) and manipulation of data as evaluation of algorithms applied to execute the routine and repetitive activities included in the test scripts to assess the effectiveness of process controls. In addition to automation, the evaluations considered the use of analytical bases and machine learning to select situations in which it was possible to identify exceptions that demonstrate whether the control is effective. The developed robots had as an approach to perform a collaborative test and proved to be an efficient tool to aggregate the internal audit activities.
publishDate 2021
dc.date.accessioned.fl_str_mv 2021-12-18T21:44:20Z
dc.date.available.fl_str_mv 2021-12-18T21:44:20Z
dc.date.issued.fl_str_mv 2021-02-05
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
dc.type.driver.fl_str_mv info:eu-repo/semantics/masterThesis
format masterThesis
status_str publishedVersion
dc.identifier.citation.fl_str_mv MALTA, Décio de Abreu. Automatização de testes com técnicas inteligentes para auditoria de controles. 2021. 90 f. Dissertação (Engenharia Elétrica e Computação) - Universidade Presbiteriana Mackenzie, São Paulo, 2021.
dc.identifier.uri.fl_str_mv https://dspace.mackenzie.br/handle/10899/28601
identifier_str_mv MALTA, Décio de Abreu. Automatização de testes com técnicas inteligentes para auditoria de controles. 2021. 90 f. Dissertação (Engenharia Elétrica e Computação) - Universidade Presbiteriana Mackenzie, São Paulo, 2021.
url https://dspace.mackenzie.br/handle/10899/28601
dc.language.iso.fl_str_mv por
language por
dc.rights.driver.fl_str_mv http://creativecommons.org/licenses/by-nc-nd/4.0/
info:eu-repo/semantics/openAccess
rights_invalid_str_mv http://creativecommons.org/licenses/by-nc-nd/4.0/
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.publisher.none.fl_str_mv Universidade Presbiteriana Mackenzie
dc.publisher.program.fl_str_mv Engenharia Elétrica
dc.publisher.initials.fl_str_mv UPM
dc.publisher.country.fl_str_mv Brasil
dc.publisher.department.fl_str_mv Escola de Engenharia Mackenzie (EE)
publisher.none.fl_str_mv Universidade Presbiteriana Mackenzie
dc.source.none.fl_str_mv reponame:Biblioteca Digital de Teses e Dissertações do Mackenzie
instname:Universidade Presbiteriana Mackenzie (MACKENZIE)
instacron:MACKENZIE
instname_str Universidade Presbiteriana Mackenzie (MACKENZIE)
instacron_str MACKENZIE
institution MACKENZIE
reponame_str Biblioteca Digital de Teses e Dissertações do Mackenzie
collection Biblioteca Digital de Teses e Dissertações do Mackenzie
bitstream.url.fl_str_mv https://dspace.mackenzie.br/bitstream/10899/28601/1/DECIO%20DE%20ABREU%20MALTA%20-protegida.pdf
https://dspace.mackenzie.br/bitstream/10899/28601/2/license_url
https://dspace.mackenzie.br/bitstream/10899/28601/3/license_text
https://dspace.mackenzie.br/bitstream/10899/28601/4/license_rdf
https://dspace.mackenzie.br/bitstream/10899/28601/5/license.txt
https://dspace.mackenzie.br/bitstream/10899/28601/6/DECIO%20DE%20ABREU%20MALTA%20-protegida.pdf.txt
https://dspace.mackenzie.br/bitstream/10899/28601/7/DECIO%20DE%20ABREU%20MALTA%20-protegida.pdf.jpg
bitstream.checksum.fl_str_mv 308f24ece6bba6c97fb1aa3e3a39ced1
4afdbb8c545fd630ea7db775da747b2f
d41d8cd98f00b204e9800998ecf8427e
d41d8cd98f00b204e9800998ecf8427e
1ca4f25d161e955cf4b7a4aa65b8e96e
b386e8b5ef696ac6d660520cf0ed7f17
13da673feec766711bd234fc07663feb
bitstream.checksumAlgorithm.fl_str_mv MD5
MD5
MD5
MD5
MD5
MD5
MD5
repository.name.fl_str_mv
repository.mail.fl_str_mv
_version_ 1757177236060897280