Experience

Data Analytics Trainee, (07/2023 – 10/2023)

Generation UK and Ireland

• Experience with extracting, joining and cleaning multiple structured datasets through Microsoft Excel related functions.

• Conveyed all data insights through appropriate data tables, visualisations and application of statistical techniques i.e. variance, standard deviation, regression analysis, etc.

• Experience with SQL including querying data through SQL Server Management Studio against SQL databases, creating, and modifying SQL views, configuring user and group roles via SQL scripts for secure access and normalisation based on database schema requirements.

• Utilised Python and associated libraries like NumPy, Pandas and Seaborn to explore and manipulate data to produce insights and prepare visualisations for a stakeholder presentation.

• Proficiency using Microsoft Power BI to visualise data from multiple sources in an impactful way so that executive decisions can be made.

Accounts Administrator , (08/2022 – 12/2022)

ESMS (Europe) Ltd

• Accurately updated and reconciled key debtor, creditor and bank accounts in accordance with strict month end deadlines.

• Presented to senior management an overview of current outstanding payments/ receipts, and impacts to the company’s working capital using excel dashboards on a weekly basis. Proactively communicated all insights requiring action to relevant teams, helping avoid potential short term cash flow issues.

Accounts Clerk, (09/2019 – 06/2022)

Linehaul Express Ltd

• Managed 23 overseas intercompany debtor and creditor accounts; through sales and purchase source data review, monthly statement reconciliation and resolving relevant account queries on a succinct basis.

• Responsible for extracting and reviewing monthly sales, purchase data via excel pivottables and chart visualisations. To test and identify risk of misstatement and omission prior to reporting package submissions.

• Facilitated the successful launch of Dynamics 365 ERP (finance element); through undertaking systematic general ledger testing with colleagues, cleaning of transfer data, and timely liaison with head office regarding data requirements.

• Successfully led a 2-month project to introduce a signatory software, for improving the firm’s transaction audit trail. I was tasked with exploring and summarising potential options, organising a department implementation review. When finalised, I presented the project objectives and agreed procedures to affected managers. This project helped achieve consistent transaction documentation, and reduced average invoice approval time by 4 days. I received highly positive feedback from all stakeholders on completion.

Trainee Accounts Assistant, (10/2018 - 05/2019)

KBM Chartered Certified Accountants

• Managed the sales and purchase ledgers for 10 SME businesses via SAGE 50 and QuickBooks software.

• Responsible for maintaining the general ledger with accurate journal adjustment entries for the fixed asset register, wages, cash, and VAT control account.