Stephen Barrett
Finance Systems Consultant specialising in NetSuite
Hire this person
Send a job offer directly to this candidate
About
Highly experienced Finance Systems Consultant now specialising in NetSuite with over 43 years' experience covering roles from 'hands on' project manager to MI / reporting analyst, IT consultant to SME's to systems accountant, covering a variety of finance / ERP systems including NetSuite, Dynamics NAV, Access Dimensions / Focalpoint, SAP Business One and R/3, CODA Dream, Baan, Multisoft and e-Financials. Strong analysis/communication skills and finance accounting processes knowledge gained from 43 years working with finance/ERP systems in various industries and roles.
Experience
Data Lead - Phenna Group
(2025-05)
Working as part of the project team implementing NetSuite across the entire group – 65 companies purchased in the past 5 years (based in UK, US, Australia and the Middle East)
- Responsible for oversight of legacy systems data extraction, data cleansing and 'hands on' import to NetSuite. Scope covers P2P, O2C, R2R, CRM and fixed assets.
- Development of SQL scripts to extract data from legacy systems – always building repeatable processes.
- Development of Excel VBA code for processing historic trial balances held in a variety of Excel management information packs, into the NetSuite CSV journal import format.
- Liaison with 3rd party for data extraction, finance data owners to guide on cleansing and Dun and Bradstreet who were engaged to assist with master data de-duplication and cleansing activities.
NetSuite Consultant - Aqualunq France
(2024-10 - 2024-12)
Working as part of the Tech Mahindra team implementing NetSuite for the US subsidiary of Aqualung as part of their 'Horizon' restructuring programme.
- Validating finance test scripts covering P2P, O2C and R2R
- Leading Data Migration covering various item types, sales orders, open purchase orders, open AP/AR transactions and opening trial balance. 'Hands on' with the successful go live during the 1st weekend in November.
- Included use of the JIRA project management / ticketing system and Confluence.
Data Migration Lead - Core Highways
(2023-12 - 2024-09)
Responsible for data migration moving data from legacy finance systems and spreadsheets to NetSuite. Scope included General ledger, accounts receivable and payable, fixed assets, leased assets, employee / payroll data and prepayments. Items for use in purchase requisitions / PO's and those 'service for sale' items for customer billing.
- Aiding users with testing / functionality of NetSuite when reviewing data loaded to sandbox and production environments.
- Assisting functional lead with some of the system tidy up work e.g. fields no longer required, fine tuning workflows, creating saved searches etc.
- Development of Excel import templates, Excel VBA code for data manipulation and SQL scripts to aid repeatable processes extracting data from legacy systems e.g. employee and payroll data.
SuiteQL Developer - Selbey Anderson
(2023-12 - 2024-01)
Development of SuiteQL scripts to extract Project related revenue estimates, Advanced revenue management plans, General Ledger posted actual revenue and GL costs.
Data Migration Lead - Learning Technologies Group Plc
(2022-09 - 2023-12)
Responsible for the data migration aspects of moving data from the legacy systems (Access Dimensions, Quickbooks, Xero) covering open transaction information for General ledger, Accounts payable & receivables, fixed assets and significant work around revenue recognition.
- Development of import templates, automated routines and documentation / user guidance materials to aid the data migrations.
- User training and user acceptance testing relating to data migration activities.
- On 1.11.22 went live with a UK subsidiary (Gomo Learning Ltd) and a US subsidiary (Watershed Systems Inc.)
- Subsequent migrations included various UK and US subsidiaries, 1 Australian and 1 Indian subsidiary with a total of 12 business successfully migrated during my contract.
Netsuite ERP Specialist - IM Group Limited
(2020-08 - 2022-08)
A £2 million project with 300 Netsuite users and a business operating in the UK, Nordics, China and Ireland. Netsuite was being implemented along with a specialist dealer management system (Advectus) to address the vehicle and parts requirements for this UK headquartered importer of Subaru and Isuzu vehicles.
- The role included acting as the solution lead for a 3rd party AP automation tool 'Kanbina'.
- Responsible for the data migration aspects of moving data from the legacy J D Edwards system covering master and open transaction information.
- User training, user acceptance testing and user support prior to and after go-live.
- Build of workflows, forms, roles, saved searches, reports and dashboards. Initiating selection of 3rd party add-on reporting tool (Spreadsheet server).
- Detailed project management assisting the programme manager and liaison with the Netsuite Partner (Sansa) and Advectus.
- A follow-on project to add a subsidiary for Mitsubishi UK after sales parts operation following their acquisition by IM Group – integrations, data migration, customisation, user training and on-going support.
NetSuite Consultant - IESO Digital Healthcare
(2020-03 - 2020-08)
Completion of Concur Expenses integration to NetSuite project – testing of NetSuite connectors and assisting with remote user training. Online training for Dell Boomi Essentials and Flow.
NetSuite Consultant - The Cotswold Company
(2020-03 - 2020-03)
Training finance and IT users in the use of NetSuite reporting tools – saved searches, report layout, financial report layouts and analytics workbooks.
- Development of reports e.g. an analytics workbook providing margin information by product groups by period
NetSuite Consultant - IESO Digital Healthcare
(2019-10 - 2020-03)
Development and implementation of a customised purchase order workflow. Report development – financial reports, analytic workbooks and saved searches. Various customisations to forms adding new fields, validation workflows etc. Concur Expenses and Salesforce to NetSuite integration projects – requirements analysis, setup, user training and implementation.
NetSuite Consultant - Roc Technologies
(2019-07 - 2019-12)
Process review, data migration from Sage 500, reporting requirements and delivery for a new subsidiary, Esteem Systems based in Wetherby. Key elements included full loads of all historic trial balance data (including intercompany aspects), master files, opening balances etc.
- Drop ship orders, super user / admin training, report development and simple workflows and field customisations particularly around sales orders.
NetSuite Consultant - Bidwells LLP
(2018-03 - 2019-05)
A wide ranging role covering various 'hands on' aspects of the implementation such as analysis and design as well as detailed project planning and management.
- Development of data migration strategy covering data migration Scope, data migration principles, assumptions and dependencies and high level data migration process.
- Data migration of Access accounts / Focalpoint finance data and CRM data from legacy CRM (Microsoft Dynamics CRM and Midas). Creation of NetSuite CSV import templates. Included hands on development of SQL scripts, co-ordination of staff cleansing data and use of tools such as an Excel 'fuzzy lookup' add-in.
- Responsible for analysis of reporting requirements and development within Netsuite using saved searches