Guan Quan

Interactive Resume

Profile

Finance Undergraduate


Details

Tan Guan Quan
24 Years
NUS Business School
Singapore

Guan Quan

About Me

I am a Finance undergraduate in NUS Business School. Throughout my internships, I have acquired experience in various departments including Operations, Compliance, Risk Management, and Global Markets. I am also familiar with VBA, SQL, R Programming, Python, and TIBCO Spotfire.
I seek to combine my knowledge in Finance, Programming, and Analytics to deliver quality contribution to my team.

Experience

A Short History on Everything


Education

National University of Singapore

Aug 2015 - Present

Bachelor - Business Administration (Specialization: Finance) Relevant Coursework:
• Corporate Finance
• Financial Modelling
• Applied Portfolio Management
• Business Analytics: Data and Decision
• Analytics in Consulting
• Programming Methodology
Singapore

Stockholm School of Economics

Aug 2017 - Dec 2017

Student Exchange Program Relevant Coursework:
• Derivatives in Investment Management
Stockholm, Sweden

Innova Junior College

Jan 2011 - Dec 2012

GCE "A" Levels Awarded the "IJC Best Improved Award" in 2013
Selected for Hong Kong Economics Immersion Trip to:
• City University
• Hong Kong Exchange (HKEX)
• Hong Kong Monetary Authority (HKMA)
Singapore


Career

Macquarie Group

May 2018 - Present

Internship - Commodities Market Commodities and Global Markets (CGM)
• Oil and Gas
• Asia Supply and Demand Modelling
• Asia Refinery Turnaround Modelling
• Demand Forecasting for Refined Products
• Trade Flow Data and Macroeconomics News using Reuters
• Created Analytics Visualization Dashboard using TIBCO Spofire, ZEMA Database, Excel VBA, Python, and SQL
Marina One West Tower, Singapore | https://www.macquarie.com/sg/

HSBC Singapore

May 2017 - Aug 2017

Internship - Traded Credit Risk Management Wholesale Credit and Market Risk (WMR)
• Counterparty Risk
• Treasury Products, Derivatives
• Product Control, Counterparty Limits Exposure
• Settlements, ISDA / CSA, Credit Review, and Earmarking
HSBC Building, Singapore | https://www.hsbc.com.sg

DNB Bank Asia

May 2016 - Aug 2016

Internship - Compliance Department of Risk Management
• Know Your Customer (KYC)
• Anti-Money Laundering (AML)
• Due Dilligence
• Sanctions
AXA Tower, Singapore | https://www.dnb.no/en

Mizuho Bank: Singapore Branch

Feb 2015 - Jul 2015

Temporary Assistant - Trade Finance Department of Trade Finance
• Letter of Credit
• Import and Export Documents
• Banker's Guarantee
Asia Square Tower 2, Singapore | https://www.mizuhobank.com

Abilities

A List of Skillsets


Skills

  • Adobe Premier Pro
  • Excel VBA
  • TIBCO Spotfire
  • ZEMA Database
  • MySQL
  • Python
  • HTML
  • CSS
  • R Programming
  • Django

Languages

  • English (Native)
  • Mandarin (Native)
  • MinNan (Elementary)
  • Traditional Chinese

Projects

A List of Completed Projects and Courses


Courses

Paint A Home

Bloomberg Market Concept

Online Course by Bloomberg

Tags:
Bloomberg

View more
Oranjebitter Rotterdam

CFA Exam Level 1

Passed Level 1 of the CFA Program

Tags:
Udemy

View more
Oranjebitter Rotterdam

R Programming

Online Course by Udemy

Tags:
Udemy

View more
Oranjebitter Rotterdam

SQL

Online Course by Udemy

Tags:
Udemy

View more

Static Webpages

IT1001

IT1001 - Individual

Built a static website to review a software

Tags:
Development, Bootstrap, Review

View more
VirtualReality

IT1001 - Project

Built a static website to explain Virtual Reality

Tags:
Design, Development, Bootstrap

View more
Django

CP3108B - Orbital

Built a web application using Django

Tags:
Design, Development, Bootstrap, Django

View more

Community Projects

Paint A Home

Paint-A-Home XVIII

Oversaw procurement and transportation of logistics

Tags:
NUS, CSC, PAH

View more
Oranjebitter Rotterdam

MINDSville Major Outing 2016

Oversaw the programs for the events

Tags:
NUS, CSC, MINDSville

View more

Contact

Let's Keep In Touch!