12 years

12 years

12 years

8 years

7 years

1 year

7 years

8 years

6 years

Consultant for Universa Law and Severn Law, a partnership of law firms based in London and Bristol
Responsible for various projects:
• Writing, installing and implementing a Case Management package based on Solcase, as well as integrating the package with Office 2003 and SOS accounting software
• Developing client care tools and management modules, using VB, Excel and Access, to support fee earners and managers with handling and monitoring of cases
• Automation of legal statements, integrating Word, Excel and Access, to enable fee earners and other experts to capture client information quickly and accurately
• Development of software to automate updating of case details from external data sources

Consultant for Portner & Jaskel, a London PI law firm
Involved in a range of projects including:
• Development of Case Management software and accompanying reporting tools using a combination of Visual Basic, Access, SQL Server and Crystal Reports.
• Development of accounting and financial forecasting and cashflow software using Excel, Word and VBA
• Development of time recording system to automatically update billing and accounting databases
• Creation of software to integrate case management systems with external client systems to enable case tracking and financial transactions
Also responsible for training staff in the use of the software and helping them to undertake amendments and enhancements.

Consultant for Barclays Bank, Milan
Development, enhancement and support of interfacing tools for extracting data from financial databases using complex business rules. Extracts and reports are supplied in specific formats to meet requirements of the Bank of Italy. The software uses a combination of Visual Basic, Access and SQL Server.

Consultant for Rooks Rider, a City law firm.
Responsible for converting WordPerfect templates and macros to Word 97 and integrating them with iManage document management system. The work has included producing a technical specification as well as advising on best practice and integrating with their existing network.

Design and creation of Word 2000 templates and macros for Political Planning Services (see below). The design included automatic reporting and clause selection as well as invoicing and billing.

Consultant for Societe Generale, a major city Investment Bank
Involved in a range of projects including:
• Interfacing between a proprietary database and Excel and Word using VB and VBA
• Designing templates and macros in Excel and Word
• Writing add-ins for Excel to offer additional functionality for research and analysis
• Training staff in the use of Office applications and in writing VBA macros

IT Development Analyst for SJ Berwin, a legal firm in the City. Part of the development team responsible for maintaining, upgrading and enhancing existing software systems and also creating and developing new applications.
General responsibilities included:
• Writing applications using Visual Basic, SQL and ASP
• Writing macros in Word and Excel
• Designing and creating databases using Access
• Maintaining code using MS Visual SourceSafe
• Updating and troubleshooting existing applications
• Customising interfaces between different packages
• Investigating new packages and their compatibility with existing systems
• Training staff in use of new applications and packages
• Training staff in writing Word and Excel macros
• Training staff in programming techniques in VB
• Training staff to write databases in Access
• Writing user and technical documentation
Specific tasks carried out:
• Writing Word macros to automate document creation and updating, and to interface with Soft Solutions and PCDOCS document management systems using a variety of platforms ranging from Windows 3.11 through to Windows NT
• Conversion of templates and macros from Word 6 to Word 97 and conversion of document management from Soft Solutions to PCDOCS
• Automating conversion process for documents to be transmitted onto the firm’s intranet ready for indexing and searching. This involves the use of VB and HTML, as well as integration with the document management system.
• Writing a client contact database, using Access and Visual Basic, and customising interfaces to link with Word, Soft Solutions and Dragon Dictate voice dictation system
• Creating databases using Access and VB to manage and process orders and maintenance contracts for the IT department and also to manage the IT resource library
• Writing a Case Management package using Visual Basic, Access and Crystal Reports and integrating document output with Word
• Writing applications using VB to schedule the updating of databases distributed across several servers and involving FTP links with a Unix system.

Consultant for Sinclair Roche & Temperley, a legal firm in the City. Responsible for converting WordPerfect templates and macros to Word 97 for their overseas offices and also integrating them with iManage document management system. Part of the work involved training their in-house development team in VBA. Also responsible for producing a feasibility study of their London office templates to convert from WordPerfect to Office 2000 and drawing up a development plan and timetable to complete the conversion project.

Part of the IT Development Team at Simmons & Simmons, one of the top 5 UK legal firms, involved in converting their document production and management system from a Windows 3.11, WordPerfect and Soft Solutions platform to Windows 95, Office 97 and LiveLink document management.

Work undertaken involved:
• designing and setting up document templates
• writing macros in Office 97 using VBA
• integrating macros with Livelink document management and workflow systems
• writing programs with VB 5
• writing generic routines to automatically convert user interfaces between different languages for overseas offices
• maintaining code using MS Visual SourceSafe
• testing and implementing systems created
• writing technical documentation

Converting templates and macros from Word 7 to Word 97 for Political Planning Services (see below) as well as creating new templates and enhancing existing user interface for document creation.

Writing a drawings register database for Leonard Stace Construction Management using Visual Basic 5 and Access 97.

Writing an integrated software package for a software house, involving the use of Visual Basic and Access as well as incorporating OLE functionality to link with Word and Excel.

Writing Excel 97 macros for Hambrecht and Quist, a London-based stockbrokers.

Writing Word 7 macros for a document management system for Political Planning Services, a City-based company specialising in researching and preparing reports for political groups.

Word and Excel training for senior management at Carlton Communications.

Writing Excel macros in VBA for Advanced Computer Group, a software development company based in Wimbledon.

Access training and database development for Candle Services Ltd, a software development company based in Camberley, Surrey.

Access training course for Surrey University. Introducing staff to the use of tables, forms, queries and reports.

Intermediate level Visual Basic 4 training for a large City bank.
Introducing programming staff to VB coding structures and techniques.

Head of Computing and IT
Godalming College, Godalming
Responsible for the teaching of all computing courses up to and including A level as well as co-ordinating the use of IT across the College.