Examples of Work

General 

• Working with small and medium sized organisations, helping to establish valid business systems and processes that provide effective management information. This may involve working with them over several months to enable supported, incremental change to be achieved. Also, providing IT support and troubleshooting on an ad hoc basis for those that do not have their own in-house IT expertise or resources.
• Collaboration with senior civil service executives and secretaries, examining their use of word processing and email systems, helping them to: develop standards for internal and external documents and their production, create templates and macros to automate the production of procedural manuals and streamline Parliamentary communications.

Database design and development

• Exam recording systems to track assignment results and calculate students’ end-of-year grades. (Sheffield Hallam University)
• Employment agency system to maintain employer and employee details, produce and record personalised contract documents between employer and employee and to calculate invoicing and payroll information. (Student Employment Services)
• Manuscript submissions system, for the tracking of research papers from around the world for review and publication in various medical journals. (European Respiratory Journals)
• Caravan stocking system for new and second-hand stock, which also maintains details of sales, customers, warranties, invoices, calculates stock values and produces letters for reminders and marketing mailshots. (Sheffield Caravans)

Financial analysis and control systems development 

• Budget vs actual spend, cost analysis and summaries by department, with all sheets linking into a profit & loss and balance sheet.
• Invoice automation using formulae to link between spreadsheets with different product details, in various currencies.
• Sales forecasting using previous year’s data, with comparison to current monthy actuals and year-to-date totals.
• Extraction of Sage accounting data via ODBC, to enable imports of financial data into alternative (overseas) accounting systems.