IT/Management consultancy. Analysis, development, implementation and enhancement of systems, particularly in Investment Banking and Digital Marketing.Work is typically directly for clients on an ad hoc basis, so there is little client overhead. Projects have ranged from system strategy through auditing of systems to large database development projects, web development, and interfacing and integrating systems. Where developed, systems have been supported and maintained indefinitely, with my longest running database still in operation after 28 years. Clients include major corporates such as Deutsche Bank, Chase, and Sika AG, to institutes such as The Royal Academy and small entrepreneurial businesses including marketing agencies and data solution companies.Tools used include: HTML, CSS, PHP, Javascript, jQuery, Clipper, dBase, xBase++, C, MS Access, Excel, VB, VBA, ASP, various scripting and macro languages, MySQL, Sybase and MS SQL Server, SFDC (Salesforce) and Data Loader, Hubspot, Zoho (including Deluge script language), Dotmailer, Mailchimp, Klipfolio, Google Apps.

IT strategy and security advice.Replacement of SalesForce used as a web database application with a custom Excel solution seamlessly linking to a PHP API and MySQL database in the cloud.HubspotCRM implementation, including customised reporting to Excel using Hubspot API.

Data and business process audit for a number of clients including a large household insurer.Repair of data corrupted by well known email marketing service.Consolidation of international data, data quality analysis, and guidance on ETL.Review of existing data quality and scope prior to systems replacement project.Spreadsheet audit, proof and reconciliation.Consolidation of CRM and Marketing Automation data sources into Excel. Data cleansing and application of validation. File import, export and queries from VBA using Microsoft’s SQL.Web interface applications.Creating custom functions and extracting data from the web in Excel.Database building, re-format and reconciliation.

Development of SWELL, product database and international sales order processing application (PHP to SAP Advantage Database Server, SQL via ODBC), extending the life of the original Clipper database. Long term continuity of support, including to London, New York, Chicago, Singapore and Sydney.

Business analysis and systems strategy. Deployment of SaaS applications, customisation, extension and integration to support business and create new products and potential revenue streams. Development and implementation of in-house web database application.Customisation of Zoho CRM to support service business: creation of new modules (tables), function writing, automated emails and API calls (PHP) to provide external landing pages for partners.

Business analysis, systems specification, documentation, testing, and troubleshooting as part of small Management Services team. Analysis, specification and testing updates to central accounting system. Period supervising international equity operations.

Investment Banking Operations: Trouble-shooter, including supervisor of Foreign Exchange settlements, and tracking, analysis and resolution of unsettled international equity trades. New York and London through the “Big Bang”.

Royal Signals. Six months in Cyprus as Troop Commander and Training Officer as a 19 year old before Cambridge. West Germany (Celle) after university, Sandhurst and School of Signals as Troop Commander in Electronic Warfare role. Operations officer during deployment, combining understanding of soldiering and the attributes of the kit. Demonstrating and explaining the equipment to audiences of senior officers and dignitaries. Promoted to Captain at 24, retired at 25 after outbreak of peace.