Andrew K Hide Email & Phone Number

London

London

London, United Kingdom

London, United Kingdom

• Daily production of NAV's for Emerging and Frontier Investment trusts.• Reviewing NAV's produced by colleagues.• NAVs, financial statements and other information over RNS and CISX.• Daily Reconciliation of cash positions• Production of monthly accounts to be sent to directors (Balance sheet, Income Statement, Trades, Holdings, Performance)• Production of statutory yearly/half yearly accounts for quoted closed-end investment companies • Calculation and invoicing of Management Fees• Administering the payment of invoices, trade settlements manually via Fax and automatically via Omgeo, corporate actions and proxy voting• Liaising with Auditors, Board of Directors and Fund Managers• Involved in a take on of a new client reconciling between two different accounting systems• Additionally I have developed numerous formula and macros to increase and automation of the key spreadsheets to reduce the amount of manual entry and to increase efficiency.

London, United Kingdom

• Client Administrator for Segregated Index linked/Bonds Funds • Daily monitoring of Income and trades within funds • Production of monthly accounting reports to be sent to external clients • Production of periodic Investment reports (NAV, Performance, Holdings and Market Commentary) • Calculation and invoicing of Management/Performance Fees • Administering client inflows and outflows • Assisting with testing of new systems and other adhoc queries (internal & external)

Chelmsford, United Kingdom

I was brought on a temporary basis to clear a backlog of clients reports for a third party administrator of Unit Trust Funds. This included creating the P&L, Balance Sheet, Trial Balance and Monthly cash flows. After being there for 3 weeks I had cleared the backlog of a number of months including correcting previous errors and started to assist with a further backlog from the Dublin office.

London, United Kingdom

While working at Hermes I had two main areas which I was responsible for. The first being the daily estimation and valuation of the Tactical Asset Allocation at a scheme level for the BT and Hermes Pension Schemes. The second area was the production of monthly reporting and fund valuation of the Hermes Focus Funds. Scheme Reporting and Valuation • Daily valuation estimation of BTPS/HGPS at Scheme level. • Estimated via spreadsheets, benchmarking indices and adjusting for allocations • Ensuring all daily price feeds were correct and in line with market movement • A large importance on accuracy as scheme valued was in excess of ₤30bn and these figures were used to make investment decisions. • Weekly estimation of Cash flow of scheme and reconciliation of cash movement • Monthly collection of fund valuations from internal and external sources • Benchmarking of figures between actual and estimations, investigating any material differences. • Production of Monthly and Quarterly reports for Trustees and Yearly budgeting of scheme cash flow Focus Fund Reporting (Equities, Bonds, Options and Futures) • Monthly, quarterly valuation reports and monthly flash valuations • investigating and resolving any differences that are raised by the Fund Manager • weekly and monthly liquidity adjustments, reconciliations and cashflow • Paying Invoices and calculation of Management Fees • Investment and Drawdown calculations Other activities during my time at Hermes • IMA Reporting • Testing and Implementation of new reports and systems • Maintenance, development and modification of spreadsheets to improve efficiencies• Assisting in closing of Funds and assisting Auditors when required • Extensive creation of Procedures for use by Business Analysis • Training of other departments and Business Analysis during the implementation of a new system and outsourcing project performed by Hermes

Basildon