Publicação
Automation in the Banking Sector: Process Automation for Hedge Accounting
| Resumo: | This 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. |
|---|---|
| Autores principais: | Silva, Tomás Côrte-Real Ferreira da |
| Assunto: | 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 |
| Ano: | 2024 |
| País: | Portugal |
| Tipo de documento: | dissertação de mestrado |
| Tipo de acesso: | acesso aberto |
| Instituição associada: | Universidade Nova de Lisboa |
| Idioma: | inglês |
| Origem: | Repositório Institucional da UNL |
| _version_ | 1868983766176759808 |
|---|---|
| author | Silva, Tomás Côrte-Real Ferreira da |
| author_facet | Silva, Tomás Côrte-Real Ferreira da |
| author_role | author |
| contributor_name_str_mv | Caldeira, João Carlos Palmela Pinheiro RUN |
| country_str | PT |
| creators_json_txt | [{\"Person.name\":\"Silva, Tomás Côrte-Real Ferreira da\"}] |
| datacite.contributors.contributor.contributorName.fl_str_mv | Caldeira, João Carlos Palmela Pinheiro RUN |
| datacite.creators.creator.creatorName.fl_str_mv | Silva, Tomás Côrte-Real Ferreira da |
| datacite.date.Accepted.fl_str_mv | 2024-11-04T00:00:00Z |
| datacite.date.available.fl_str_mv | 2024-11-14T08:58:01Z |
| datacite.date.embargoed.fl_str_mv | 2024-11-14T08:58:01Z |
| datacite.rights.fl_str_mv | http://purl.org/coar/access_right/c_abf2 |
| datacite.subjects.subject.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 |
| datacite.titles.title.fl_str_mv | Automation in the Banking Sector: Process Automation for Hedge Accounting |
| dc.contributor.none.fl_str_mv | Caldeira, João Carlos Palmela Pinheiro RUN |
| dc.creator.none.fl_str_mv | Silva, Tomás Côrte-Real Ferreira da |
| dc.date.Accepted.fl_str_mv | 2024-11-04T00:00:00Z |
| dc.date.available.fl_str_mv | 2024-11-14T08:58:01Z |
| dc.date.embargoed.fl_str_mv | 2024-11-14T08:58:01Z |
| dc.format.none.fl_str_mv | application/pdf |
| dc.identifier.none.fl_str_mv | http://hdl.handle.net/10362/175186 |
| dc.language.none.fl_str_mv | eng |
| dc.rights.cclincense.fl_str_mv | http://creativecommons.org/licenses/by/4.0/ |
| dc.rights.none.fl_str_mv | http://purl.org/coar/access_right/c_abf2 |
| dc.subject.none.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 |
| dc.title.fl_str_mv | Automation in the Banking Sector: Process Automation for Hedge Accounting |
| dc.type.none.fl_str_mv | http://purl.org/coar/resource_type/c_bdcc |
| description | This 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. |
| dirty | 0 |
| eu_rights_str_mv | openAccess |
| format | masterThesis |
| fulltext.url.fl_str_mv | https://run.unl.pt/bitstreams/049b93bd-b4a2-4761-866b-928fcf7782b9/download |
| id | run_4fa6465474d024e371ff8cf46cc5cd90 |
| identifier.url.fl_str_mv | http://hdl.handle.net/10362/175186 |
| inst_facet_str | urn:organizationAcronym:unl{{{_:::_}}}Universidade Nova de Lisboa |
| instacron_str | unl |
| institution | Universidade Nova de Lisboa |
| instname_str | Universidade Nova de Lisboa |
| language | eng |
| network_acronym_str | run |
| network_name_str | Repositório Institucional da UNL |
| oai_identifier_str | oai:run.unl.pt:10362/175186 |
| organization_str_mv | urn:organizationAcronym:unl |
| person_str_mv | Silva, Tomás Côrte-Real Ferreira da |
| publishDate | 2024 |
| repo_facet_str | urn:repositoryAcronym:run{{{_:::_}}}Repositório Institucional da UNL |
| reponame_str | Repositório Institucional da UNL |
| repository_id_str | urn:repositoryAcronym:run |
| service_str_mv | urn:repositoryAcronym:run |
| spelling | engpt_PTThis 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.application/pdfpt_PTAutomation in the Banking Sector: Process Automation for Hedge AccountingSilva, Tomás Côrte-Real Ferreira daCaldeira, João Carlos Palmela PinheiroHostingInstitutionOrganizationalRUNe-mailmailto:run@unl.ptrun@unl.ptURNurn:tid:2037772202024-11-14T08:58:01Z2024-11-042024-11-04T00:00:00ZHandlehttp://hdl.handle.net/10362/175186http://purl.org/coar/access_right/c_abf2open accessHedge AccountingMS ExcelPython Automation PipelineProcess ImprovementSDG 4 - Quality educationSDG 8 - Decent work and economic growthSDG 17 - Partnerships for the goals983948 bytesliteraturehttp://purl.org/coar/resource_type/c_bdccmaster thesis2024-11-04http://creativecommons.org/licenses/by/4.0/http://purl.org/coar/access_right/c_abf2application/pdffulltexthttps://run.unl.pt/bitstreams/049b93bd-b4a2-4761-866b-928fcf7782b9/download |
| 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 |
| status | SINGLETON |
| subject.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 |
| title | 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_short | Automation in the Banking Sector: Process Automation for Hedge Accounting |
| title_sort | Automation in the Banking Sector: Process Automation for Hedge Accounting |
| 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 |
| topic_facet | 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 |
| url | http://hdl.handle.net/10362/175186 |
| visible | 1 |