Automatização de testes com técnicas inteligentes para auditoria de controles
Autor(a) principal: | |
---|---|
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 |