Colin Fry Ba(Hons) Acma Cgma Email & Phone Number

Derby

* Picsolve - a market leading worldwide digital\print business that provides retail solutions to the tourist and leisure industries* Reporting on a system called QlikView – a business intelligence platform – most data sourced from AccPac\ Sage 300 ERP* Contract due to end on 4 October 2015 based at Derby* Success in developing QlikView to consolidate, report and analyse - Management Accounts, Balance Sheets, Cash Flow Statements, Stock Management and Cost Centre reporting* Developed QlikView applications to analyse Debtors, Creditors, Purchase Orders, CapEx, Goods Received, Stock and Foreign Exchange* Safe Pair of Hands performing Accounting Tasks including Stock Analysis, Balance Sheet Reconciliations

Cheshire, Derbys, London, Manchester, Merseyside, Notts, Yorks

• Working with a couple of charities to build their Administration Database Systems I will take this opportunity to highlight some of my technical skills • First Rate experience to ensure proper Financial Control within a Systems Migration• Expert producer of Management Accounts with a high standard of Financial Analysis• Thoughtful in Planning and Forecasting process - Always looking for Improvement• Experience to ensure proper Financial Control within the General Ledger• Significant and successful project work experience – recently qualified as Prince2 Practitioner • Notable experience in Overhead Accounting and Activity Based Costing• Exceptional MS Access skills• MS Excel - very knowledgeable• Recently Completed an Excel Modelling Course• Authority on Oracle and Discoverer• Report Writing – skilful user of EssbaseOther Relevant Skills include:• Design Skills – designed many successful MS Access applications• Coaching skills – coached colleagues to develop accounting and IT skills• Report Writing – thorough preparation to ensure understanding• Problem solving – tenacious to reach a satisfactory outcome• Self-motivated – able to motivate myself and others• Work equally well as part of a team or on my own using my initiative• Logical thinking – able to analyse accurately and make decisions• Enjoy providing Quality Financial Information to Finance and Non-Financial Colleagues• Proven Hard Worker - received the rare “Strong Performer” mark in my final full year review

Cheshire

• Successfully passed Prince2• Developed my MS Access 2010 skills• Investigated the SQL Language

Chester

• Improved Financial Control and Explanation of a Commission system within ledger• This solved what was described as a “too difficult to do” projects with successful outcome• Provided my Expertise to fully test New Debt System• Highlighted and solved residual issues• Cleared outstanding Debt balances and trained remaining staff to deal with subsequent issues

Chester Also Travelled To Cockfosters & Cardiff

• Transferred agreements from Legacy System to other systems which ultimately caused my redundancy. However the professionalism and dignity by myself and the team ensured this high profile project was rated by the LBG management as the Best Ever• Managed out-bound migration for the Financial Department and ensured these agreed with in-bound agreements • Liaised closely with IT and Operations departments to ensure successful Migration• Corrected legacy systems debt ledger balances in preparation for migration• Trained colleagues to use Integration Databases• Analysed, Documented and Communicated different accounting policies within the varying Debt systems• Improved Variable Rate interest calculation processes• Supplied detailed information to other finance departments• Improved Financial Control of debt within balance sheet

Chester, United Kingdom

• Produced Management Accounts and provided an improved detailed Variance Analysis for a Business with Debtor Assets of over £1bn• Developed a more Logical Planning approach - Providing more Reliable and Accurate Plan and Forecast Information• Challenged and Provided Well Received Suggestions for a new Overhead Allocation process• Created New Bad Debt Analysis at Customer Level for the Business - Also adopted and used by Credit Risk Management• For the whole of Commercial Banking - Created a Basel Database to Improve Analysis• Writing a Report that gave an Understanding of Corporate Asset Finance to Interested Parties

Chester, United Kingdom

• Successfully transferred agreements from the Legacy System to the New Debt System.• Managed Accounting Parameters• Developed User Acceptance Test Scripts• Developed my Business Objects skills by providing quality MI from the new system• Developed a more transparent and accurate mapping procedure

London, United Kingdom

• Significantly improved the process• Reduced reporting time from 10 days to 6 days by introducing a new database and automating the Accounts Production.• Significantly improved Management Accounts underlying analysis – both numbers and explanations• Seized the opportunity to write an Investment Appraisal Document which successfully automated the system postings that reduced time taken to produce Management Accounts to 4 days

Chester, United Kingdom Also Edinburgh

• Masterminded an administration database that improved the management of the department’s projects• Examined potential new and existing interfaces which improved posting accuracy • Built templates that automated Accounts Production which enabled more timely Management Accounts.• Compiled a report to give a snapshot of Corporate Finance Department which was well received and published on department’s website

Chester

• Reported the divisional costs totalling £660m to divisional board.• Also provided a variance analysis of those costs to the Business Banking Board.• Successfully Managed and Improved the Cost Allocation Process.

Chester, United Kingdom

• Produce a variety of Bank of England Returns including the LE Return.• Produce Statutory Accounts for leasing companies.• Assist in the production of the consolidated accounts.

Liverpool, United Kingdom

• Part of a team that used Activity Based Costing to help reduce the administration costs within the Life Business.• Managed an Activity Based Costing project to enable a more Equitably method of transferring Facilities Management costs

Redhill, United Kingdom

• Developed Cost Allocation Models• Researched Activity Based Costing theory• Developed an ABC Model

Redhill, United Kingdom

• Consolidation Accounting• System Accounting - Project Work• Cost Allocation

Redhill, United Kingdom

• Consolidation Accounting• General Ledger Work• Budgeting

Bachelor Of Arts (B.A.), Accounting, 2:1

4 A-Levels

7 O-Levels