Andrew Herbert Email & Phone Number

Saffron Walden, GB

London, England, United Kingdom

Marylebone, Greater London, United Kingdom

• I performed research and analysis of Key Data Elements to improve and maintain data quality for risk and regulatory reporting.
• By publishing the steps needed to create a golden Key Data Element field.
• Identifying ownership and definition of the field.
• Investigating data sources and the merge mapping priorities used.
• Proposing exception rules to improve and measure data quality.
• By manipulating large data sets in Excel and Alteryx to analyse output of the proposed rules.

Marylebone, Greater London, United Kingdom

• I supported projects for the Fixed Income Referential team.
• By reviewing internal SharePoint product request tool’s needs.
• Analysis of multiple Issuer and guarantor data from Bloomberg and monitoring remediation of data.
• Supporting the reverse engineering of an internal trading system being the source of golden depository data and becoming a recipient.
• Improved Key Performance Indicators by reviewing tasks and creating transparency across business user groups.

Marylebone, Greater London, United Kingdom

• I managed the product control and creation teams.
• I introduced daily whiteboard meetings to enhance team communication and inclusion.
• By using a team skills matrix I was able to identify training to develop personnel and improve team efficiency.
• I identified the daily critical tasks and implemented them into a multi-tier control tool which enabled accountability and sign off of tasks.
• I was responsible for raising, prioritising and reporting progress for enhancements and bugs in our golden depository system.
• I took an active role in the stakeholder meetings that determined the Key Data Elements for Risk Data aggregation and reporting based on the BCBS239 directive; this was used as our base for Data Quality.

Marylebone, Greater London, United Kingdom

• I was responsible for managing all of the daily tasks undertaken by the product team.
• I administered the personnel shift rota, overtime, holiday, training, fair distribution of daily tasks and annual appraisals.
• I ensured accurate and timely product creation, reconciliations, and updates adhered to all internal procedures.
• I reviewed new business requirements and ensured regular ongoing procedural updates.
• I was the team’s representative with the Business Analysts regarding the creation and development of an internal global golden source instrument depository.
• I was responsible for the migration, user acceptance testing and implementation of Calypso sourcing its data from our global golden source instrument depository.

Marylebone, Greater London, United Kingdom

• I joined as a senior static data clerk supporting the client and product daily business needs.
• I created and transferred broker and client data into our in-house systems.
• Performed due diligence and money laundering checks for new counterparts.
• Created and maintained all product data across multiple asset types.
• During my time on the department I used my experience to train and coach new members of the team.
• I performed the task of collating and applying the different methods of re-denomination and re-conventioning of the European legacy bonds into Euro.

Bishopsgate

I was able to participate in varied number of roles here gaining a great understanding of the industry.My roles included International Dividends, Foreign Currency Funding, Valuations, Client Administration, Cash Management and Reference Data.These roles emphasised the importance of reconciliations; controls; accuracy;attention to detail; problem solving.