REINSURANCE TECHNICAL ACCOUNTANT ANALYST / EXCEL-VBA AUTOMATION
at Swiss Re
September 2016 - September 2018
Autonomous and complete management of a portfolio of clients’ accounts, including: - Accounting of reinsurance financial accounts; - Analysis of accounting documents and verification of discrepancies related to contractual conditions; - Direct contact with the client to solve accounting issues, and proceed to financial reconciliation; My greatest contribution was given by my Excel/VBA expertise and ability to figure out original solutions to greatly improve the efficiency of the processes. I envisioned, designed and built tools to automatize the previously manual extraction of the figures to book from several clients’ complex documents, matching of client’s references to ours, data correctness checks, export to our accounting system, allowing huge saving of time and capacity, with no investment by the company. I also took care of developing VBA-macros and Excel troubleshooting at unit-level. I also designed and held ad hoc advanced Excel training.
at University of Milano-Bicocca
2011 - 2015 (4 years) Lombardia
Knowledge and keywords