Automation in the Banking Sector: Process Automation for Hedge Accounting

Detalhes bibliográficos
Autor(a) principal: Silva, Tomás Côrte-Real Ferreira da
Data de Publicação: 2024
Tipo de documento: Dissertação
Idioma: eng
Título da fonte: Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
Texto Completo: http://hdl.handle.net/10362/175186
Resumo: Dissertation presented as the partial requirement for obtaining a Master's degree in Data Science and Advanced Analytics, specialization in Business Analytics
id RCAP_4fa6465474d024e371ff8cf46cc5cd90
oai_identifier_str oai:run.unl.pt:10362/175186
network_acronym_str RCAP
network_name_str Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
repository_id_str https://opendoar.ac.uk/repository/7160
spelling Automation in the Banking Sector: Process Automation for Hedge AccountingHedge AccountingMS ExcelPython Automation PipelineProcess ImprovementSDG 4 - Quality educationSDG 8 - Decent work and economic growthSDG 17 - Partnerships for the goalsDomínio/Área Científica::Ciências Naturais::Ciências da Computação e da InformaçãoDissertation presented as the partial requirement for obtaining a Master's degree in Data Science and Advanced Analytics, specialization in Business AnalyticsThis work revolves around the development of a tool made for the calculation of Hedge Ratio. This initiative came from a national bank, and it was our duty as KPMG workers to deliver a high standard tool. We spent 4 months in this bank developing this tool and using as baseline an older existing tool built in excel. The existing resource had a slow running time, the application crashed, and it had structural errors creating circular dependency. So, we created a solution, which we called the proposed tool, built in python and with an improvement ratio of over 20000% compared to the existing tool. This project built into 6 different modules of calculations proved, the inevitability of this digital transformation era. We rapidly understood that there is a market for automation in the finance sector due to the large data quantity that is being produced and due to the poor knowledge of the average worker in data structures and data engineering. With all this being said, our tool, not only shows how fast python can be compared to excel when handling complicated calculations, but also shows the need for investment in this area and creation for more tools like this one and creation for more packages and APIs connected to this line of work.Caldeira, João Carlos Palmela PinheiroRUNSilva, Tomás Côrte-Real Ferreira da2024-11-14T08:58:01Z2024-11-042024-11-04T00:00:00Zinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisapplication/pdfhttp://hdl.handle.net/10362/175186TID:203777220enginfo:eu-repo/semantics/openAccessreponame:Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)instname:FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologiainstacron:RCAAP2025-01-13T01:43:01Zoai:run.unl.pt:10362/175186Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireinfo@rcaap.ptopendoar:https://opendoar.ac.uk/repository/71602025-05-28T19:14:11.948725Repositórios Científicos de Acesso Aberto de Portugal (RCAAP) - FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologiafalse
dc.title.none.fl_str_mv Automation in the Banking Sector: Process Automation for Hedge Accounting
title Automation in the Banking Sector: Process Automation for Hedge Accounting
spellingShingle Automation in the Banking Sector: Process Automation for Hedge Accounting
Silva, Tomás Côrte-Real Ferreira da
Hedge Accounting
MS Excel
Python Automation Pipeline
Process Improvement
SDG 4 - Quality education
SDG 8 - Decent work and economic growth
SDG 17 - Partnerships for the goals
Domínio/Área Científica::Ciências Naturais::Ciências da Computação e da Informação
title_short Automation in the Banking Sector: Process Automation for Hedge Accounting
title_full Automation in the Banking Sector: Process Automation for Hedge Accounting
title_fullStr Automation in the Banking Sector: Process Automation for Hedge Accounting
title_full_unstemmed Automation in the Banking Sector: Process Automation for Hedge Accounting
title_sort Automation in the Banking Sector: Process Automation for Hedge Accounting
author Silva, Tomás Côrte-Real Ferreira da
author_facet Silva, Tomás Côrte-Real Ferreira da
author_role author
dc.contributor.none.fl_str_mv Caldeira, João Carlos Palmela Pinheiro
RUN
dc.contributor.author.fl_str_mv Silva, Tomás Côrte-Real Ferreira da
dc.subject.por.fl_str_mv Hedge Accounting
MS Excel
Python Automation Pipeline
Process Improvement
SDG 4 - Quality education
SDG 8 - Decent work and economic growth
SDG 17 - Partnerships for the goals
Domínio/Área Científica::Ciências Naturais::Ciências da Computação e da Informação
topic Hedge Accounting
MS Excel
Python Automation Pipeline
Process Improvement
SDG 4 - Quality education
SDG 8 - Decent work and economic growth
SDG 17 - Partnerships for the goals
Domínio/Área Científica::Ciências Naturais::Ciências da Computação e da Informação
description Dissertation presented as the partial requirement for obtaining a Master's degree in Data Science and Advanced Analytics, specialization in Business Analytics
publishDate 2024
dc.date.none.fl_str_mv 2024-11-14T08:58:01Z
2024-11-04
2024-11-04T00:00:00Z
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.uri.fl_str_mv http://hdl.handle.net/10362/175186
TID:203777220
url http://hdl.handle.net/10362/175186
identifier_str_mv TID:203777220
dc.language.iso.fl_str_mv eng
language eng
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.source.none.fl_str_mv reponame:Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
instname:FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologia
instacron:RCAAP
instname_str FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologia
instacron_str RCAAP
institution RCAAP
reponame_str Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
collection Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
repository.name.fl_str_mv Repositórios Científicos de Acesso Aberto de Portugal (RCAAP) - FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologia
repository.mail.fl_str_mv info@rcaap.pt
_version_ 1833597962029105152

Registros relacionados