[Virtual Presenter] Welcome everyone! We are here today to discuss the advancements in the equity sector that our company has enabled. We will explore how we have created advanced portfolio data look-through faster processes and the ability to test new funds asset classes and tests. These changes have reduced Q&A resolution time allowing for a more efficient and effective workflow. Let's get started!.
[Audio] We will now discuss the project recap and timeline presented by Isabel followed by Fabrizio's presentation on the equity sector showcase and next steps. The project focused on creating an equity sector showcase that allowed for the customisation of asset classes and scalability of data via advanced portfolio data look-through and faster processes. This enabled the testing of new funds asset classes and tests while reducing resolution times for Q&A. Moving on to Isabel's presentation on the project recap and timeline..
[Audio] We have accomplished our aim of constructing a totally customisable equity sector demonstration with augmented scalability of data facilitating for elaborated portfolio data look-through and accelerated processes. This has empowered us to produce new IA asset categories originate new sector assessments pre-test new funds and decelerate Q&A resolution times. By decoupling the IA methodology from the Morningstar methodology plus added fixed income data more openness and more jurisdiction of the IA methodology we have put down the foundations for more effective testing and asset managing..
Timeline. sept, 23 - Expanded POC capabilities by incorporating equity and specialist sectors - Sucessfully showcased Equity & Other Sectors to IA - Enviroment Set Up: Data Loadad to DATA lake Stg May, 22 Solution Concept Overview presented to IA May, 22 June, 22 July, 22 - Sucessfully showcased Fl Sectors to IA - Project Scheduled for 2023 Q4 - Concept of the methodology & data solutions approved - Data, Methodology, Confidentiality Requirements defined August, 22 Now Jan, 24 - Enviroment Set Up: Data Loaded to Lake House Stg & Prod - Functional / Performancre End to End Testing & Sign-off Equity & Other sectors - Error Hadling / Review Tests / Execute Tests - Proof of Concept Feasible Hypothesis Signed Off • Sucessfully showcased to IA ( Fixed Income Sectors) • Preliminary Sizing Analysis ( Data operations, methodology, Fixed Income, EDP Portfolio, EDP Content & Tech, Data Lake) Oct/ Nov/Dec 23 - EnviromentSet Up - Phython Coding - Integration testing to validate the functionality of the code. 29 Feb, 23 Sign - Off Feb, 24 - Functional / Performancre End to End Testlng & Sign-off Fixed Income sectors - Error Hadling / Review Tests / Execute Tests.
[Audio] Our team tested 24 sectors and validated the results against the current solution. We conducted an audit of the entire solution to review the logics created several years ago. Taking the opportunity we compared different sources as well and leveraged on A-P-T--- to use notional value for derivatives. This enabled us to generate over 70 data points for each portfolio resulting in around 5 million records and 340 million nodes. After thorough analysis and testing only 1% of the portfolios saw a change in their status from ‘fail’ to ‘pass’..
[Audio] Reaching the final step of the process we must look to expand and continue testing of our asset classes and scalability of data. We have already tested our new funds asset classes and tests across 24 equity sectors and now propose to replicate this approach for the remaining sectors. Our aim is to move all these new sectors into the production environment and run across them in parallel for the next 3 to 4 months. This will allow us to evaluate their consistency and compare them to our legacy solution. If results are favorable we will discontinue the legacy solution and solely use the new one. Appreciate your listening and continued interest..