London, England, United Kingdom
Enhanced team projects with focus on efficiencies and improvements, e.g performed integrity checks to validate performance accounting data was adequate in Eagle before NT Pace could be replaced; certified a share class reporting app designed to replace the manual production of individual reports; Built a 3 point controller template, tasked to identify accounting related issues before performance reporting sequel cycle will commence; In addition to project related work, around 50% of my time was spent on BAU performance and attribution reporting and analysis.
- Worked on team projects and initiatives with a focus on efficiencies and automation, e.g replaced daily SPAR based performance reporting with a MStar add-ins format; Sharepoint set-up project and Custom Benchmark overhaul. - Created improved Performance and Risk reporting packs using MStar Presentation Studio and FactSet PA. - Contributed to the team BAU deliverables and ad hoc performance related reports and analysis for all asset classes, financial instruments and fund types.
Working with Blackrock to analyse if the capabilities in Aladdin can replace current reporting processes in Performance Attribution, Fee Functionality, Alternative Currency, Annualisation methodology, Carve Outs, Turnover ratios; -Benchmark mapping exercise to confirm Aladdin’s ability to replace B-One and Factset as main reporting source; - Evaluate and assess the current Classification structures and analysed options for the future state support; -Worked on the functional requirement and technical design for integration of River & Mercantile into SIML performance application; - Data scraped Aladdin Explore daily returns for look-through and non-look through portfolios, and validate Cloud Attribution reports;
- Extract Equity performance attribution results from existing reports, perform integrity checks, transform the data to a format suitable for loading to the strategic platform; - Work with FactSet and existing third-party suppliers to resolve data errors uncovered in the validation process, and apply corrections to the data set as required; - Validate that the data has been correctly loaded to the target platform; - Maintain controls on the status of the data loads, including creating MI for senior stakeholders - Support the existing VBA macro suite and develop it further where required.