2013 - Present
Lead migration consultant on a number of Oracle R12 functional areas for the migration of two companies within Balfour Beatty Group.
Developed a solution for de-duplicating over 50,000 supplier and supplier site records including validation of VAT registration numbers, company registration numbers and taxpayer references. Developed a tool for retrieving missing information from numerous websites including internal PDF reports.
Responsible for mapping and transform of 4 payrolls including element, payroll and balance information. Provided support to reconciliation teams by converting payslip files and generating summary reports to ensure maximum Oracle payroll accuracy.
Sole developer of general ledger transform code which allowed full reconciliation of 5 unique business entities for both prior year and year to date values after only 3 weeks.
Successfully migrated approximately 1,000,000 project roles from a number of different data sources, ensuring default employees were provided for those not present in the source data.
Developed supporting applications for use by the data migration team to allow analysis of load reports and changes in Oracle configuration.