Learn Data Skills
Beta
Yee Tong Tan

Yee Tong Tan

Treasury Officer

-

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

Insightful strategist, envisioning new possibilities through data foresight.

My Work

Take a look at my latest work.

course

Introduction to SQL Server

course

Introduction to SQL

course

Introduction to R

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Microsoft Microsoft Certified: Power BI Data Analyst Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Gunvor Group Ltd | May 2022 - Present

Treasury Officer, APAC

• Daily cash management - developing and maintaining accurate cash flow forecasting with excel and treasury management system by ensuring completeness and accuracy of information. Reconciliation of actual against forecast. Investigation on deltas in data. And timely capture of all treasury transactions (FX, syndicated loan, interests, FD). • Optimised cash on treasury and all other accounts. Coordinated with trade finance to get visibility and understanding of their future cash flows needs. • Played active role in rolling out of TMS, including data validation, capture, documentation & testing, creation of reconciliation rules and training colleagues in APAC and Middle East. • Managed all bank accounts in APAC, facilitated bank account opening/ closure, ensured proper mandates are obtained, established SWIFT services for the accounts and onboarded accounts for e-banking platforms, where applicable and necessary. • Executed and coordinated deposits with banking partners (Initiation, placement, rollover, uplift and funding settlements) and ensure all details are captured on TMS. • Control & release of payments - Ensure accounts are well funded, verified that payments are properly approved according to approval flow and reviewed remittance information. Educated and ensured internal stakeholders adhered to payment policy. • Analysed and resolved SWIFT errors on TMS or payments, i.e. MT101 instruction and MT940 integration. Liaised with internal stakeholders or bankers to perform the necessary troubleshoot. • Executed FX fixing and monitored FX hedging settlements for various currencies in APAC with HQ/bankers. • Facilitated KYC for new bank onboarding and periodic renewals. • Prepared adhoc reports/analysis using excel and Power BI.
Show More

Gunvor Group Ltd | Jun 2019 - Apr 2022

Accounts Executive

• Daily payment processing - Timely processing to respective banks by internal cutoff time and banks’ cutoff time. Ensure accuracy of payment details sent via SWIFT. Summarisation of payment commitments for respective banks. Preparation of manual payment/loan letter, trade settlement instructions, bank forms and e-banking instructions to cater for different types of payment methods. Payment troubleshooting, such as adhoc handling of bank queries, preparation of letter/forms for cancellation or amendment in instructions. Ensured payments are complete. • Timely preparation of daily receipt/payments and expenditure vouchers • Daily registration of approx 100 invoices received each day into in-house system within same day meticulously [Internship] • Daily booking and updating cash flow of daily bank transactions and invoices into the accounting system (iScala) and cashbook (Excel) • Assisted in month-end closing process, bank reconciliation and timely filing of documents • Prepared monthly intercompany reconciliation • Prepared monthly AR aging report. (Investigated aged invoice and cross- checked against actual receipts. Reported to operating team, followed up and updated status of aged invoice.) • Quarterly preparation of GST Return - Sampling and reviewing of invoices - AP/AR. Requested revision to invoices that do not meet required tax invoice requirements, educated colleagues on the correct tax coding to ensure proper records. Calculated the GST payable and receivable, then submitted GST return report and samples to tax manager for final review. • Responded and prepared audit confirmation requested from third-parties/ auditors/bankers - Generating AP/AR reports and cross-checked against queries received. • Monthly staff expense report checking and reimbursement - Ensured expenses are made in accordance to internal policy and that proper approvals have been obtained. Ensured accurate booking. Prepared bulk GIRO file. Educated employees on expense policy.

IRAS | May 2018 - Jul 2018

Tax Officer

communicating and educating the tax rules that are required to file tax and for claiming of reliefs • Assisting individuals with assessment-related procedures (Payment waiver, checking of status, eligibility of reliefs) • Simplifying the website virtual assistant's answers and tax rules into infographics, using Canva and Photoshop, to better assist taxpayers in understanding the answers to their queries, 3 out of 5 designs made have been put to actual use on Ask Jamie @ IRAS in Y2018

My Education

Take a look at my formal education

Bachelor of Accountancy, AccountingSingapore Management University | 2020
Diploma in Retail Management, Retail ManagementTemasek Polytechnic | 2016
O Levels Junyuan Secondary School | 2012

About Me

Yee Tong Tan

Curious.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free