At RED ALERT, I support administration for a portfolio of 300 permanent clients, keeping client information and onboarding records up to date. I also coordinate information between clients, operational teams, suppliers and management.
I process creditor and debtor invoices, receipt incoming payments using bank-statement information, and prepare wage records for payroll processing. I capture quotations and compile month-to-month KPI reports to show quotation activity.
In an Excel and Power Query project, I cleaned, standardised and combined payroll extracts with inconsistent layouts. I developed leave-balance calculation logic based on the payroll rule of 17 paid hours worked per hour of leave earned, accounting for employee-specific leave cycles and running balances.
I’m developing SQL and PostgreSQL skills through a client and contract management database project. I’m planning its relational structure for clients, contracts, sites, users and permissions, alongside wage-rate and contract cost information.
