Mark Campbell Email & Phone Number

Andover

Assistant to the Account Manager, providing analysis and support.

Andover, United Kingdom

Keep records of expenditure and compile the Annual Accounts. Research possible funding options and complete application forms.

Trust and Corporate Fundraising.

Fundraising and Excel

The NPIA was formed from the merger of two government organisations CENTREX and PITO prior to the commencement of my employment. The company had migrated its legacy accounting systems into SAP and the Fixed Assets' data had been 'taken on' inaccurately, so initially I assisted with the recalculation and adjustment of the 'take on' values, so that they reconciled back to the two sets of Statutory Accounts for 2007. Also as the Financial Year End of March 2008 was still being reworked it was necessary for me to calculate and post adjustments so that an accurate position could be reported. I then was able to produce the Fixed Asset Note with reconciliations for March 2008.Once the year end was performed and we had a clean opening position my duties were:Consolidate and write a Fixed Asset and Capital Policy for the organisation.Post fixed asset journals and transfers as required by the business.Post disposals and write offs once confirmed and authorised.Monthly reconciliations and Fixed Asset Summary and Statutory Notes.Check the register for inaccurate or inconsistent data and post manual depreciation.Recruit and assistant and provide training.Write procedures for the day to day processes.Manage the Assets Under Construction (AuC) database, liaise with business unit heads and Finance Business Partners.Reconcile monthly management accounts back to the SAP capital reports by Directorate.Calculate indexation to comply with government indexation current cost accounting policy.Assist in the planned implementation of indexation within SAP.

Hook, Basingstoke, United Kingdom

The NPIA was formed from the merger of two government organisations CENTREX and PITO prior to the commencement of my employment. The company had migrated its legacy accounting systems into SAP and the Fixed Assets’ data had been ‘taken on’ inaccurately, so initially I assisted with the recalculation and adjustment of the ‘take on’ values, so that they reconciled back to the two sets of Statutory Accounts for 2007. Also as the Financial Year End of March 2008 was still being reworked it was necessary for me to calculate and post adjustments so that an accurate position could be reported. I then was able to produce the Fixed Asset Note with reconciliations for March 2008.Once the year end was performed and we had a clean opening position my duties were:• Consolidate and write a Fixed Asset and Capital Policy for the organisation.• Post fixed asset journals and transfers as required by the business.• Post disposals and write offs once confirmed and authorised.• Monthly reconciliations and Fixed Asset Summary and Statutory Notes.• Check the register for inaccurate or inconsistent data and post manual depreciation.• Recruit and assistant and provide training.• Write procedures for the day to day processes.• Manage the Assets Under Construction (AuC) database, liaise with business unit heads and Finance Business Partners.• Reconcile monthly management accounts back to the SAP capital reports by Directorate.• Calculate indexation to comply with government indexation current cost accounting policy.• Assist in the planned implementation of indexation within SAP.

As the Budget Manager for the Logistics Applications Integrated Project Team I was responsible for the monthly analysis and production of the forecast of future out-turn which involved the creation and consolidation of five delivery areas RDEL and CDEL operational cost statements. The position also required me to analyse and resolve several historical opening balances for capital expenditure which had not been properly capitalised to the single balance sheet owner. Also I was employed to set-up and update several spreadsheets which enable the LAIPT to complete the Planning Round and more effectively analyse the FOO (forecast of future out-turn) actual transactions and to produce more accurate forecasts.Timeout travelling to Bangkok and Rayong in Thailand as well as a holiday in Spain accompanying a retired friend.

As a financial analyst consultant to the partners. I was required to provide ad hoc analysis of various scenarios that were being considered by the senior management of several pharmaceutical companies whilst negotiations with landlords' agents and estate departments. This also involved two business trips to New York with a view to providing 'on the spot' analysis for the partners whilst they attended several meetings with the parties.

Help to do analysis of relative costs of London and New York estates under different utilisation plans.

As the accounts department was being out-sourced to India and the accounts being migrated to SAP my role within the department can be separated into two distinct phases.1) Initially I had responsibility of producing the monthly accounts within SUN and was required to:-prepare and post standard monthly journals including accruals and prepayments etc.Post cost centre accruals and amendments as advised by the departments within the group.Calculate inter-company and third-party interest payable and receivable accruals.Liaise closely with the Treasury department and ensure that loans were accounted for correctly.Code inter company invoices.Agree inter company balances with other Divisional Accountants.Produce monthly balance sheet reconciliations for review.Enter ETB accounts into Hyperion Enterprise and ensure that the figures were analysed correctly and to IFRS statutory requirements.Raise internal sales orders for inter company recharges of Salaries and other sundry costs.Help with data cleansing and prepare for Data Migration.2) As Group Plc and Ltd were within the first drop of companies to be migrated onto SAP and the responsibility for the production of the accounts passed to the Genpact staff, I was then involved in:-Training of the Genpact Staff on internal procedures and requirements.Checking and overseeing the TB data migration process onto SAP.Translating the scheduled and journals into the new SAP based formats.Solving processes problems not defined by the Formula 100 team.Passing journals to correct legacy items missed mapped.Helping to define new processes to get SAP outputs in old Divisional format for input into Hyperion.Producing SAP reconciliation's and investigate problems.Supporting the new teams in producing accounts for three months.Supporting budget holders with queries concerning the new processes and advice on how to make amendments within SAP.Identifying issues and learning

Cash flow monitoring, analysis and forecasting.Instigating fund drawdowns and investment of surplus funds as and when required.Ensure that all interest liabilities are paid on time.Calculate and post interest receivables and payable accruals.Purchase order production and processing.Contractor staged payment monitoring, authorising and posting.Processing of Staircasing and Homebuy grant applications.Processing and submission of Keyworker grant applications Interrogate and review Housing Corporation secure online system.Monitor/Reconcile the recycled funds from Housing Corporation. Liaising with Legal and Marketing Departments as required.

concurrent with other employment); As Owner/Finance Director for this small mail order company my duties included all accounting and administrative activities for the company.Production of Management Accounts & reports.Design and creation of various spreadsheets.Stock ordering and management.Assist in the Business Planning.Online and other marketing activities.Completion of Statutory Returns including VAT returnCash flow analysis and forecasting.Order processing and keeping customers informed, usually by e-mail.Resolve customer disputes/process customer refunds.Administer the business online activities.Payroll processing and reconciliation.Make payments to suppliers.

For the analysis and reconciliation of data extracted from their various live SQL databases.Extract data from live databases that held customer financial data.Perform extensive ah-hoc analysis with Excel.Production of Journals for upload into accounting systems.Monthly reconciliation of customer receipts.Report of the failing of administrative controls.Liaise with Credit Control and other internal departments.Recommend and report on tighter procedures to ensure data accuracy.Liaise with IT to understand database system and its weaknesses.Help in the upload of banking transactions into database systems.Isolate data errors and report to get database records updated.

Assist them with the formulation and development of the TRAC Model (Teaching, Research and Administration Costing) to enable the University to complete a new type of Statutory Return for Central Government which attributes all of the institution's costs to the academic and research activities of the University.Identify appropriate data sources for model Drivers by liaison with University Departments and the Head of Research Accounting.Extract data subsets from various data sources.Perform extensive ah-hoc analysis with Excel.Upload results into TRAC Model software.Completion of Research Grant Applications.Liaise with Academics and Accounting Staff.Help in the updating of Research Grant Accounting Spreadsheets.Reconciliation of reports to accounting records.Re-analyse the entire prior year accounting transactions.Document procedure and list assumptions made to assist future TRAC model development.

Posting of receipts to ESL Accounting System.Checking the validity of fist month's service charge apportionments

Collation and banking of all receipts from various depots.Handing of large sums of CASHPosting of receipts to Kerridge Accounting System.Reconciliation of receipts to postings made.

Writing-up of manual cashbook.Posting of receipts to Sage Accounting Systems.Adjust for Inter-company receipts.ME Reconciliation of Debtors Control.

Was brought in as their Accountant/Analyst to help to help the owners to assess the viability of this small and failing double glazing company. The hope was to be able to assist the owner in turning the company around. However it was decided that to phoenix the business and share overheads with a building company was the best approach to ensuring the continuation of the business.ResponsibilitiesReconcile Creditor Accounts.Pay Suppliers.Production and payment of payroll for 18 staff.Forecast and manage cash with insufficient working capital.Liaise with factoring company, concerning debtors.Reconcile control accounts.Present accounts to directors and bankers.Company correspondence.Meet with HP Finance Company.Produce various Business Forecasts.Deal with disputes with Customs & ExciseLiaise with Business Link

Was responsible for the smooth day-to-day running of the Finance Department whilst this company was considering relocating many of its production activities to overseas and duly downsizing both its administrative operations and its production within the UK. Was also involved in the analysis of logistics for the outsourcing process lead times, quality assurance and appropriate costing with liaison with the production managers.ResponsibilitiesPrepare and post monthly journals.Finalise Management Pack and supporting analysis.Analyse cash flows and prepare forecasts.Prepare a flexible budget model.Manage accounts system upgrade to Sage Enterprise.Import/Export data for further analysis.Control account reconciliations.VAT/ESL Returns.Liaise with consultant for the production of Belgium VAT Return.Prepare Statutory Accounts and supporting documentation.Liaise with Auditors.Review and resolve debtor queries.Authorize Debtor Write-offsLiaise with IT consultants.Negotiate Company Insurance savings.Payment of Wages/Suppliers and Foreign Exchange.

As their UK Management Accountant was responsible for smooth running of the finance department that consisted of nine staff. Merlin Entertainments are better known for the Sea Life & Dungeons Attractions situated throughout the UK and Europe.ResponsibilitiesResponsible for Accounting of 22 UK Sites and 5 Head Office Departments.Collation of site month end returns from the sites.Production & Input of Monthly Journals.Review site's of P&L accounts in detail and by variance analysis.Address all queries to site management staff and correct as necessary.Obtain and input information relating to central departments. (stock/accruals/prepayments)Management and preparation of Budgets for the UK Sites.Review/Post Journals for Central Overheads.Review and finalising of MA's Pack.Attend Management Meetings where site managers were present to justify overspends etc.Visit and Train new site managers with respect to head office procedures.Perform/oversee Control Account Reconciliations.Staff Appointment & Training and if necessary discipline.Review all payments - Cheque/BACS 2nd Signatory.Weekly Cash flow reporting and management.Annual Production of Statutory Accounts for three companies.Liaise with Auditors and provide further information as necessary.Oversee/cover VAT and other statutory returns.Oversee/cover weekly and monthly Payroll.Agree and Manage Cap Exp with site managers.Rework depreciation schedules due to backdated revelations and post adjust accounting journals.Import/Export data subsets of for further analysis.Manage Access Accounts Database, backup and integrity checking.Year End Accounting Systems.

For their three operating companies with form the UK fuel operations division of the Jones Group Plc and as Systems Administrator. ResponsibilitiesProduction of Management AccountsPreparation and posting of journals. Process weekly and monthly payrolls and make payments via BACS.Reconcile all control accounts monthly.Ensure assistant posted all invoices, or journal accruals.Help with budget preparation.Reconcile GP to that of the Sales Reports produced by MIS system.Install/Upgrade software for 20 PC's.Support users with IT difficulties.Liaise with IT consultants.Purchase IT equipment, peripherals, software, cables and consumables.Set-up modems and main system links to depot.Troubleshoot problems affecting the business. e.g. IT issues, timely posting of sales.Maintain Backup systems and storage off-site and in safe.Maintain IT communications equipment.Liaise with Company Directors, Operations and Sales Staff.Page 1 of 9

Bsc (Hons), Mathematics Computing & Statistics

Activities and Societies: Mature Student Society - Financial Officer Combined Honours Degree

Education record