Summary
Overview
Work history
Education
Skills
Affiliations
Timeline
Generic

Alexander Barnes

London,UK

Summary

Middle Office Analyst at a commodity trading firm with one year of experience supporting the metals desk within the Product Control function. Proven ability to deliver accurate, timely P&L reporting, attribution, and position reconciliations in fast-paced trading environments. Skilled in analysing P&L drivers, market trends, and macroeconomic factors impacting commodity markets. Proficient in Python, SQL, VBA, and advanced Excel—strong focus on leveraging technology and expanding experience in commodity markets.

Overview

2
2
years of professional experience

Work history

Middle Office Analyst

KOCH SUPPLY AND TRADING
London, UK
07.2024 - 06.2025
  • Deliver accurate daily P&L reporting; collaborate with traders to explain variances against expected figures.
  • Automated daily P&L reporting by replacing manual trader emails with centralized Power BI dashboard using Python, SQL, and VBA; reduced report delivery time by average of 2 hours while improving detail and visibility for traders.
  • Produce daily and monthly market commentary on house P&L drivers, highlighting macro and micro market factors influencing commodity prices.
  • Handle physical and derivative contracts for base and precious metals across LME, CME, and SHFE exchanges.
  • Prepare and analyze Capital Employed reports to monitor firm-wide capital usage; produce Capital Risk reports ensuring compliance with LME regulatory requirements.
  • Partner with cross-functional teams including front office, risk, operations, and finance to ensure precise trade capture and timely resolution of discrepancies.
  • Partner with cross-functional teams, including front office, risk, operations, and finance, to ensure precise trade capture and timely resolution of discrepancies.

Intern - Financial Analyst

ENAHGY GOLF
London, UK
12.2023 - 01.2024
  • Built a financial model including budgeting, forecasting, and scenario analysis for a start-up.

Education

BSc - Finance

Durham University
Durham
09.2019 - 07.2023

A-Levels - Mathematics (A), Economics (A), Physics (B)

David Game College
London
09.2017 - 07.2019

Chartered Financial Analyst - Level 1

CFA Institute
London
05.2024 -

Skills

  • Market Analysis
  • Data Analysis
  • Financial Modeling
  • Python
  • Excel proficiency
  • SQL
  • Bloomberg competency

Affiliations

  • Football, Golf, Pool, Food enthusiast

Timeline

Middle Office Analyst

KOCH SUPPLY AND TRADING
07.2024 - 06.2025

Chartered Financial Analyst - Level 1

CFA Institute
05.2024 -

Intern - Financial Analyst

ENAHGY GOLF
12.2023 - 01.2024

BSc - Finance

Durham University
09.2019 - 07.2023

A-Levels - Mathematics (A), Economics (A), Physics (B)

David Game College
09.2017 - 07.2019

Similar Profiles

Create profile
Alexander Barnes