Chee Liu Email & Phone Number

Sidcup, Gb

London Area, United Kingdom

Career Break to recharge and then seek new opportunities

London, United Kingdom

Role Achievements and Skills:• Project work – developing and improving the reconciliation process and workflow for the new US region of the business. Being the chief point of contact, developing and improving the reconciliation and settlement process for our card transaction provider Worldpay. My work resulting in long term efficiencies for both these areas. • Revenue Settlements – analysing data from databases to provide key information for the treasury team to make the necessary cash movements. Ensuring accurate cash-backing of company funds. • Oracle SQL, Redshift SQL, Looker and Alteryx – basic knowledge of running database code scripts and manipulating end product output to aid with daily tasks. • Trust model – the UK and Ireland business operate on a trust model meaning we must hold the equivalent funds in balance to the total of all customer gambling wallets at any given time. • Jurisdictional Gambling License reporting – crucial task of reporting figures to the Maltese Gaming authority. My accuracy and attention to detail was essential, in order to retain our license to run gambling business in Malta and various European regions• Month end reconciliations – to assist wider accounting month end process and provide key information to related teams. Assist with the year end audit by saving down external bank statements monthly. Keeping an audit record of the reported figures for our business.• KPI’s - ensuring reconciliation work consistently meets internal and external auditing standardsRole Overview: Daily Reconciliations of Banks, cards and E-Wallets. Working with both on and off-balance sheet model reconciliations for multiple business regions. Handling large amounts of transactional traffic and datasets. Investigating, raising and solving variances arising from these reconciliations in a timely, effective manner. Keeping management informed via key daily reporting processes.

Beckenham

- Implementing the migration to the reconciliation program Accurate for the Regulated Reconciliations Team. From testing to procedures to training of others upon completion. After trial commencing in early 2016, the program finally went live in April 2017. Replacing previous reconciliations performed on Microsoft Excel.- Experience of performing regulated and non-regulated cash and CREST account reconciliations. - For regulated client money ensuring segregation of client money and identification of discrepancies- Responsible for end of day reporting, and soon to be trained on management information reporting such as CMAR- Processing of transfers via SharePoint, logging discrepancies as Queries, assigning to business areas and contacting them for resolutions- Writing of Incident Report where FCA breaches have occurred, liaising with compliance to ensure correct reporting has been adhered to.

Beckenham

Treasury Department, Investigations Team:• Investigating queries contained in the regulated business reconciliations and correcting them.• Updating regulated business reconciliations with PRISM control account balances. PRISM is a new program that will look to takeover from Sharemaster and MSL and I helped out in the migration process of converting the current reconciliations to be ready for PRISM use.• I have also managed to improve my Excel skills here through learning and implementing IFAND and IFOR formulas and nested IF formulas. Treasury Department, Non-Regulated Business: • Using the Accurate program to reconcile items and MSL to lookup, modify and pay off cheques in order to complete reunification processes for client companies and generate fees revenue for Capita. Finance department, Management Accountants: • Through SAP I have gained an understanding of how a company needs to maintain accruals and prepayments schedules and backup. Without the necessary backup these amounts cannot be left on the balance sheet and must be placed back onto the profit and loss account, otherwise the accounts are not showing a true and fair view of the company. • I have also improved my Excel skills considerably, improving my knowledge of the VLOOKUP and SUMIF function and learning about how to use Pivot Tables to sort and display data easier. • Using Axiom forecasting program to complete an Intercompany Spreadsheet, making sure both charging and receiving centres have the same figures on both sides. • Generating intercompany invoices and emailing them to the relevant people.• Preparing a prepayments and accruals schedule with relevant backup for a member of the Capita Group to check. • Filling out Business Surveys for the UK Government National Statistics regarding employee numbers and gender, global and UK Assets and Liabilities and Income and Expenses

Beckenham

• Preparing a December Prepayments schedule for the auditor to check. Using SAP to look for invoice/spreadsheet backups for the prepayments and making sure the figures on the spreadsheet match the backup. This ensures that the auditor can go through the schedule smoothly and won’t need to query any figures because my efforts have hopefully stopped this need arising.

Beckenham

• Using SAP accounting program to complete balance sheet and bank reconciliations, perform journal postings, attach PDF backups and complete cash sheet spreadsheets.• Learning about terms such as WIP, Accruals, Intercompany Debtors and Creditors, Deferred Income and Sundry Creditors. • Using Axiom forecasting program to complete an Intercompany Spreadsheet, making sure both charging and receiving centres have the same figures on both sides. • Generating intercompany invoices and emailing them to the relevant people.

Beckenham

Treasury Department, Non-Regulated Business: • Using the Accurate program to reconcile items and MSL to lookup, modify and pay off cheques. Treasury Department, Regulated Business: • Updating reconciliation files and balances on MSL, correcting query logs and printing reconciliations. • Updating an Excel control sheet with the latest completed reconciliations. • Using Sharemaster program to lookup and print balances for share plans and also scanning and bookmarking reconciliations before checking them off against a list sheet.

Beckenham

• Writing cheques for residual funds, filling in cheque control sheets, completing withdrawal payment log spreadsheets, typing letters to accompany cheques.• Using the MSL program to look up dates of share transactions and dividend values. • Completing managerial control spreadsheets and conducting audits on them to check for errors.

Dartford, United Kingdom

Responsibilities included helping out to perform and learn: bookkeeping, payroll, tax forms, income statements and trial balance for customers.

Sidcup

Responsibilities included cleaning and preparing the store for display, taggingand steaming clothes, working at the till/customer service and paperwork.

Sidcup

Responsibilities included teaching and helping in various classes, one to one help with children, setting up the pitch for sports day and then leading and motivating a team of children for sports day competitions.

Ba (Hons), Accounting And Finance, 2:2 (High - 58.5%)

Activities and Societies: Investment Society Abacus Society1st Honours Result In First Year 2.1 Result in 3rd Year

Education record

3 A-Levels Economics - B Business Studies - B Mathematics - B 1 AS Level Biology - B 13 A*- B GCSE's in subjects: Triple Science, French.