Thomas Chan

Experience

• 

  Forsyth Barr

  Jul 2005 - Sept 2007

  * Processed Corporate Actions * Set up new securities and instruments in Axys and IRESS Portfolio System (IPS). * Management and custodial fees reconciliation for private portfolio management clients. * Set up new accounts and processed income distributions for clients with the use of Microsoft Excel and macros.* Maintained a Microsoft Access database for in house reporting.

  • Custody & Corporate Actions Income Administrator

    Nov 2006 - Sept 2007

  • Private Portfolio Management Administrator

    Jul 2005 - Nov 2006
• 

  FNZ Group

  Oct 2007 - Apr 2020

  * Bulk data fixing with Transact SQL* Tracking, logging, and responding to support tickets. * User account maintenance, managed incidents, and provided resolutions for end-user’s technical challenges. * Tasks and order processing (FIX) monitoring * Application and reports maintenance* Website development. * Preventative measures implementations * Non-income corporate actions processing* Use of Microsoft Excel to create pivot tables and pivot reporting

  • Production Support Analyst

    May 2011 - Apr 2020

  • Software Developer

    Feb 2010 - May 2011

  • Corporate Actions Team Lead/Analyst

    Oct 2007 - Feb 2010
• 

  Institute of Data

  Apr 2020 - Jul 2020

  Student

  In this course of Data Science & Artificial Intelligence, I have learnt the following skills with Python:* Exploratory Data Analysis (EDA) and data wrangling* Data Visualisation with Seaborn, Matplotlib* Database access with SQL* Application Programming Interfaces (APIs)* Software engineering practices* Machine learning techniques* Machine learning libraries (scikit-learn, Tensorflow, Keras)* Machine learning algorithms (Linear/Logistic Regression, XGBoost, Decision Tree etc)* Deep Learning (Neural Network, CNN)* Natural Language Processing (NLP)* Cloud-based Machine Learning tools (AWS, Azure)Completed Projects: XGBoost/Catboost modelling on hand-written digits classificationLinear Regression on Diamond price predictionConvolutional Neural Network (CNN) and Transfer Learning on COVID-19 detection from Xray images (https://github.com/thomasck271/DataScience) Show less

• 

  EFTEX Pty Ltd

  May 2021 - May 2023

  Data Analyst Support Technician

  * Data reconciliation with Microsoft Excel* Creating new and maintaining existing reports with Crystal Reporting* Creating and maintaining ETL processes with Microsoft SQL Server, Server Agent Jobs and Powershell scripting

• 

  FNZ Group

  May 2023 - now

  Performance Engineer

  Microsoft SQL Servers* Stored Procedures, Views optimisations* Troubleshooting with SQL Profiler, reading SQL plans, IO stats* Monitoring with Foglight - Wait events, CPU/RAM usage* Indexing strategy* Effective use of temp table and table variables* TempDB troubleshooting* Peer code reviews