I have been working on testing Holidays Act Remediation for the 3 DHBS. During this time, I customised my self-built automated testing tool to each of the DHBs. Automated with VBA and excel formulas, the model assists with output testing by collating the payroll data and presenting the expected remediation values on an employee line by line level, which had not been provided by the vendor. This tool is now used by 5 testers across the 3 projects. 2 of the projects are daily paid and 1 is a batch pay system.

I have been working on the MoE’s Holidays Act Remediation programme. My role in the team is focused on testing. Making sure the remediation tool outputs are compliant with the Holidays Act legislation using the logic and business decisions approved by MoE to meet this compliance. This involves a range of scenario and regression testing across current and former employees. All issues are raised and tracked with JIRA. Outputs are received as excel files so most testing has been completed manually with some VBA automation. Some of the tasks performed include:- Suggesting updates to config where current config is non-compliant or to get data to fit the rules of the tool- Suggesting updates to process flow rules to determine which calculations to use for Annual Leave (OWP8.1, OWP8.2, AWE), BAPS (RDP vs ADP) and determining an OWD where there is no fixed work pattern- Some data gathering from PSE SQL database with Microsoft Query- Checking remediation tool calculations, ensuring that each calculation is performed correctly. Raising any errors in JIRA to be fixed and testing fixes. - Individually checking employee calculations and logging any data cleansing needed with team. Working closely with data analysts who correct data and flag when calculations are ready to retest.

I am working on a multi-million $ Holidays Act Remediation project which is supported by Deloitte. My role within the team is focused on Data. Running reports from the payroll system, data cleansing and combining for the Deloitte model. Testing output files and feeding back errors in the model calculations to be fixed by the developer. Preparing remediated AL Balances and Gross Pay files as part of payroll system remediation.Work with payroll team to build excel model to manually calculate BAPs and AL for interim period until upgrades to Payroll system are complete.Write UiPath bot to save individual password protected payslips and email these to terminated employees after each payrun.

Run two fortnightly and 1 monthly NZ payrolls. Conduct a review of payroll and payroll processes. Action system MYOB exo with update release to make the system calculations compliant with the Holidays Act.

As an RPA programmer I design, test and implement business process automation. Predominantly we automate using UiPath (RPA / Robots), VBA, SQL. Working remotely, I spend one or more days a week in the office according to requirements. Last year I delivered; - around 50 live automations within GFS across all finance teams (c. 2.5 FTE)Alongside this I worked closely with the payroll team on various projects. Last year I delivered; - $1mil+ holidays act remediation project - calculations were checked and approved by EY- Automated Superannuation processExample Automations:-Multiple automated reconciliations between Windcave (previously Payment Express) and JDE automated bank postings using UiPath & excel templates. Bank rec team can now concentrate on unmatched transactions-Automated filing for multiple departments into document management (Acorde) software using Uipath & filename as naming conventions (Payroll/AP/Credit Control)-Automate daily transaction update process for 6 companies in JDE with Uipath. Previously this could take between 30 min to 90 mins per company and is sometimes run multiple times per day-**Demo only"** Build Power app for Recruitment Authorisations using MS Flow and Sharepoint and linked our payroll 'clever forms' module to this using RPA to demonstrate how to digitize the entire workflow

I was initially recruited for three months to cover for an interim period between the existing Manager leaving and a newly hired Manager starting. My contract was then extended for a further 3 months to carry out some data analysis projects, implement process improvements and support the transfer of occupational absence from the legacy payroll system. I managed a team of 3 Administrators in a company of 3500 employees in 30 regions nationwide.Example works;Pension configuration: On discovery of discrepancy on employee pension contributions I investigated the config of pension scheme and located area where updates had not been completed correctly at year end. Made necessary adjustments on schemes and wrote "how to" guide for next year. One paygroup had continuous queries with tax. I wrote to HMRC who held different earnings and tax info to us. Investigated discrepancy which was caused by duplication of a submission during a change of payroll system. Provided correct data to HMRC to enable them to correct employees records. Set up various new reports in Oracle BI. Identify data tables and sort / filter as required. Each region in HFT has a different occupational absence scheme. I tested two, configuring the Occupational Absence screens in our UAT environment. I then loaded the test interface from T&A system into UAT, wrote test scenarios and checked the system calculations. I was unable to fully complete this project (due to moving to NZ) which would require another 6+ months to complete. I wrote a full project plan showing each step including testing, parallel runs and finally implementation into live.

I was brought in to support the Payroll Manger with the monthly payroll as well as leading and assisting on several projects, some linked to the recent implementation of iHCM. Employee count circa 800 UK, Ireland 50, Inpat / Expat 40 • Responsible for end to end P11d process - Audit full car data from current, legacy and car hire schemes and assess for BIK. Work closely with tax team to assess all other BIK. Distribute drafts and amend for final submission• End of year tasks – basic earning assessments / NI Band checks / National Statistics Info• Create Payroll Manual – Including detailed ‘How to Guides’• Manual Alabaster calculations after maternity system failure• Online Payslip Launch – working with internal comms team • Work through outstanding queries including preparing previous year calculations to enter previous year updates• Monthly input & checking for UK & ROI

Ingram Micro is a fortune 100 company and the world’s largest distributor of IT products and services. As part of the HR Team reporting directly to HR director I was responsible for a monthly outsourced UK payroll as well as assisting a Project Manager with multiple projects and managing one Payroll Administrator. Projects included change of payroll provider, rolling out new payroll system, modifications to HR system - including rollout of Self-service. By the end of my contract I had become the HR systems specialist for both iHCM & Peoplesoft.Project goals1. Implementation of new payroll system ADP iHCM including;- Self Service roll out on payroll system via iHCM online portal- Switch to electronic payslips- Absence management module for all holiday / sickness & other absences connected to payrun- Employee able to change personal details through portal2. Create Interface between Peoplesoft & iHCM to automate upload of permanent payroll data e.g Starters / Leavers / Salary Changes3. Self Service roll out on Peoplesoft to employees and managers. This function allowed managers to view their team and request pay increases for their direct reports etc. 4. Creation of a Master Payroll Manual for department

Working within the payroll bureau I am assisting with the monthly payroll for a leading investment bank and with parallel runs for a new group of employees transferring in April.

Working for this busy temping agency based in the Accounts department I process a weekly timesheet based payroll for approximately 500 staff every week. This is a challenging role due to the high numbers of starters and leavers each week and the individual billing requirements of each company that we supply staff to. Managing a small team, we process the full pay and bill including client invoices and credit control.