Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
background-images

Yiming Shi

Melbourne,VIC

Summary

Analytical professional prepared for this role with extensive experience in data analysis and interpretation. Known for delivering actionable insights and driving process improvements that align with business goals. Highly collaborative team player with focus on achieving results and adapting to changing needs. Skilled in statistical analysis, data visualization, and project management.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Deals Desk Analyst

Trafigura
03.2020 - 08.2024
  • Collaborated with trading teams to analyse trade finance arbitrage across FX swaps and interest rate spreads, identifying profitable funding strategies that enhanced book performance and reduced financing cost.
  • Built interactive Excel dashboards to visualize key P&L drivers in trade finance structures, enabling traders and desk head to act on insights and contributing to a 55% YoY increase in net profit.
  • Redesigned the P&L framework by separating FX swap gains from interest spread income, clarifying reporting structure and enhancing transparency for month-end reconciliation.
  • Coordinated with trading and accounting teams to align on valuation logic, streamlining the resolution of issues and improving strategy evaluation.
  • Independently produced daily P&L reports for Blister Copper and Nickel Pig Iron (NPI) trades, capturing performance across physical deals, futures hedges, and forex exposures, and enabling traders to make timely, data-informed decisions.
  • Monitored daily positions and exposures across futures and forex markets, assisting traders in managing risks and locking in profits for Blister Copper and NPI books.

IT Consulting Intern (A&IM)

Deloitte
08.2019 - 12.2019
  • Analyzed and documented the end-to-end business processes of the Demo Car Online Enhancement project, aligning process logic with system requirements to facilitate system design and stakeholder communication.
  • Collaborated with clients and developers to assess the feasibility of feature enhancements, balancing business requirements with system constraints.
  • Delivered 10+ BRDs and URDs and defined 10+ functional modules by translating business requirements into system logic, proactively resolved stakeholder issues through 30+ focused discussions.

Education

Master of Arts - Statistics (STEM)

Columbia University
New York, NY, US
02.2020

Bachelor of Science - Statistics & Economics (Double Majors STEM)

University of Illinois At Urbana-Champaign
Champaign, IL, US
05.2017

Economics

China Agricultural University (CAU)
Beijing, China
06.2015

Skills

  • Programming & Analytics: R, SQL, SAS
  • Data Visualisation & Reporting: Power BI, FineBI, MS Excel
  • Presentation & Communication: MS PowerPoint

Certification

SAS Certified Base Programmer for SAS 9

Languages

English
Chinese (Mandarin)

Timeline

Deals Desk Analyst

Trafigura
03.2020 - 08.2024

IT Consulting Intern (A&IM)

Deloitte
08.2019 - 12.2019

Master of Arts - Statistics (STEM)

Columbia University

Bachelor of Science - Statistics & Economics (Double Majors STEM)

University of Illinois At Urbana-Champaign

Economics

China Agricultural University (CAU)
Yiming Shi