Available to hire
I am a VBA developer and technical writer with over 20 years automating complex Excel, Word, Access, PowerPoint and Project solutions. I specialise in performance optimisation, ETL, modelling, and cross-application automation, building maintainable VBA libraries and automated reporting solutions.
I’ve collaborated with prestigious organisations across the UK and beyond, authored “Make Excel Faster Taster Edition”, and lead large-scale data and reporting initiatives using Excel, VBA, Power BI, Python and SQL. I value clean data, robust documentation, and scalable automation.
Skills
Experience Level
Language
English
Fluent
Work Experience
VBA Developer [and Technical Writer] at Safran GB Seats
October 1, 2025 - October 27, 2025Dissected two massive Excel workbooks with minimal documentation and produced two comprehensive technical guides to assist IT in maintenance and updates, focusing on structure, dependencies, and upgrade paths.
VBA Consultant (Access, Word and Excel) at NatWest Bank
June 1, 2024 - October 27, 2025RAD creation and development of an MS-Access application with heavy MS-Word, MS-Excel and MS-Outlook programmatic interaction. Application secured for audit purposes with strict security and traceability.
Senior Engineer at BP
June 1, 2022 - October 27, 2025Remote support and coordination for problem resolution across multiple operational products; built documentation and advised on process improvements; implemented VBA, PowerShell, Python, Power BI and REST/API integrations.
PowerPoint/Excel VBA Consultant at Walnut Unlimited/Crimson Limited
October 1, 2021 - October 27, 2025Created Excel Batch Jobs with a simple instruction set to bulk populate PowerPoint presentations, orchestrating slide edits and data population from multiple sources.
Excel VBA Developer at BP
March 1, 2021 - October 27, 2025Improved performance of CPU-intensive, data-bound workbooks, supported migration to 64-bit Excel on Windows 10, and helped create REST API links between Excel and Treasury databases.
Excel VBA Consultant at Energy Check Company/Crimson Limited
February 1, 2019 - October 27, 2025Remediated a large Excel application for generating sales commissions; added functionality under tight deadlines with a focus on reliability and maintainability.
Excel VBA Consultant at CapGemini/NDA-Retail Project
July 1, 2018 - October 27, 2025Developed a VBA module enabling language translation across workbooks, including ranges, shapes, controls and code; references to SAP systems.
Excel VBA Solutions Specialist at Sky Bet
April 1, 2018 - October 27, 2025Automated processes using VBA in workbooks to create WorkFront projects and reports.
Interface Development Management Reporting Consultant at AirSwift
January 1, 2018 - October 27, 2025Created a new application generating Dynamics 365 formatted files from Sage 200 and Tempest data; integrated Power Query, Power BI and T-SQL stored procedures for data transformation and reporting.
VBA Developer/Consultant at WaterPlus Limited/Crimson Limited
May 1, 2017 - October 27, 2025Built an Excel VBA billing tool (and associated Word templates) to produce corporate bills and validate invoices for a joint venture; live production with thousands of bills monthly.
Technical Author at VBA World 247365
December 1, 2016 - October 27, 2025Authored the book Make Excel Faster; produced technical writing and tutorials to support VBA optimization and large workbook management.
Excel Expert at NIKE (European HQ)
January 1, 2016 - October 27, 2025Improved highly complex Excel applications using OLAP and large PivotTables; authored reports and system guides; enhanced performance and reliability.
Excel VBA Modeller/Consultant at EA Technology
April 1, 2015 - October 27, 2025Enhanced TRANSFORM model GUI and performance for a 100MB+ Excel file; optimized data processing and user experience.
Excel VBA/Macro Developer at Farmcare/Co-op/Wellcome Trust
November 1, 2014 - October 27, 2025Speed up and hardening spreadsheets; improved robustness and documentation; contributed to post-migration readiness.
Word VBA/Macro Analyst/Developer at Advanced Computer Software
October 1, 2014 - October 27, 2025Delivered Word templates integrated into a LaserForm DMS; supported Agile/Scrum workflows; scope extended but project cancelled after 6 weeks.
Data Modeller/Developer at Morrisons/Kiddicare
August 1, 2014 - October 27, 2025Optimised 20+ linked spreadsheets to improve data integrity and performance; worked with NAVISION/SQL-Server integration.
Data Analyst/Data Modeller at National Grid
May 1, 2014 - October 27, 2025Created Excel-based models forecasting energy technology uptake and gas shortages; migrated key workbooks from Excel 2003 to 2010.
VBA/Macro Modeller/Developer at Matalan
August 1, 2013 - October 27, 2025Built a spreadsheet model to assist UK Merchandisers with planning and cost allocation across distribution centres and stores.
VBA/Macro Analyst/Developer at British Council
June 1, 2013 - October 27, 2025Supported migration of Office 2003 to 2010; developed Word templates and a global template-driven system; liaised with many stakeholders.
VBA Developer Consultant at Barclays Capital
November 1, 2012 - October 27, 2025Migrated Office 2003 files to Office 2007; created tools to identify migration blockers and formalized support documentation.
VBA Lead MS Office 2010 Migration Engineer at Credit Suisse
June 1, 2012 - October 27, 2025Led bulk Office 2003 to 2010 conversions; controlled servers using bulk conversion software; authored remediation notes and internal guidance.
MS-Office Migration Troubleshooter at Microsoft
April 1, 2011 - October 27, 2025Resolved migration problems onsite (London, New York) focusing on Excel, Access and Word; produced daily problem/solution log.
Excel VBA Developer Consultant at Lloyds
March 1, 2011 - October 27, 2025Created large pension/asset management VBA-based spreadsheets; developed Excel/SAS interfaces and distribution of reports.
Access VBA/Macro Consultant at BT/O2
February 1, 2010 - October 27, 2025Supported large Access 2003 databases; migrated to Access 2007; built ADODB-linked Excel workbooks and KPI dashboards.
Technical Manager at Metronetrail/TFL
October 1, 2009 - October 27, 2025Converted thousands of Word documents via Word VBA; sped up report generation and created team toolbar for rapid document production.
Excel Analyst/Developer at National Air Traffic Services
October 1, 2008 - October 27, 2025Developed safety-critical Excel models; validated data via multiple checks; built SQL Server-backed data access via ADODB.
Excel VBA/Macro/SQL Server Analyst/Developer at Vodafone
July 1, 2007 - October 27, 2025Constructed speculative SQL Server queries feeding KPI reports via KPI dashboards; integrated with Excel dashboards.
Excel VBA/Macro and Access VBA Developer at Peel Holdings/Mersey Docks & Harbour Co
April 1, 2007 - October 27, 2025Automated data entry, data migration and data integration; data cleansing for upgrade to SQL Server and templated mail merges into Word.
Excel VBA/Macro and Access VBA Developer at State Street Bank
December 1, 2006 - October 27, 2025RAD development for an asset management reporting system; front-end in Excel VBA, back-end in Access 2003; business-facing reports.
VBA/Macro Analyst/Developer at RWE Trading
October 1, 2006 - October 27, 2025Amended and troubleshot energy trading spreadsheets; created bespoke curve models; integrated with BO, Access and SQL Server.
VBA/Macro Analyst/Developer at UBS
October 1, 2005 - October 27, 2025Maintained and created Excel spreadsheets for Risk; connected to Oracle/Access; produced automated VaR related outputs and reports.
VBA/Macro Analyst/Developer at Centrica
March 1, 2005 - October 27, 2025Enhanced trader spreadsheets; created a 3-tier VB DLL to access an Oracle risk DB and present data in Excel.
Excel VBA/Macro Analyst/Developer at Blackwell Publishing
September 1, 2004 - October 27, 2025Automated consolidation of ~700 journal spreadsheets; produced validated roll-forward outputs and QA utilities.
Excel VBA/Macro Analyst/Developer at GSK Greenford
May 1, 2004 - October 27, 2025Web services-enabled portfolio evaluation; generated XML payloads for upload; created software metrics and dynamic code generation tools.
VBA/Macro Developer at KPMG Birmingham
March 1, 2003 - October 27, 2025Supported Word VBA templates; created tools to dynamically generate Word VBA code and analyse interdependencies.
VBA/Macro Developer at Halifax Equitable Clerical Medical
January 1, 2003 - October 27, 2025Created Excel-based pension calculation engines; interfaced with SQL Server; converted to T-SQL for performance and auditability.
Excel VBA/Macro Support Developer at Credit Suisse First Boston
June 1, 2001 - October 27, 2025Developed and supported Excel spreadsheets for index arbitrage; extracted Reuters data for live updates; built DLLs for Web and IE usage.
Word VBA/Macro Developer at First National (Abbey National)
May 1, 2000 - October 27, 2025Upgraded Word templates from WordBasic to Word VBA; translated templates; supported multi-institution deployment.
Word VBA Lead Developer at NPI
December 1, 1999 - October 27, 2025Led a team translating thousands of WordPerfect templates to Word 97 VBA; created automation utilities for QA and accelerated development.
Excel Trainer/Consultant Developer at SHL
August 1, 1998 - October 27, 2025Delivered training and VBA development in support of client projects; built QA utilities for code quality assessment.
Programmer/Consultant Developer at S.T. & C.
August 1, 1998 - October 27, 2025Translated and developed VBA/VB solutions; provided offshore support and PM reporting.
Programmer/Consultant Developer at Southport S.C.U.F.
November 1, 1996 - October 27, 2025Provided development and support across projects; data integration and automation work.
Computer Officer at Liverpool John Moores University
October 1, 1990 - October 27, 2025Administrative and technical support for university computer systems; contributed to teaching and labs.
Lecturer at Edge Hill University / Liverpool Hope University / Skelmersdale College / Southport College / Hugh Baird College / St Helens College
June 1, 1998 - October 27, 2025Taught courses in VB, Turbo Pascal, Z80 Assembler/Machine Code; delivered guest lectures and contributed to curriculum development.
Education
MSc Artificial Intelligence (Pending) at London Institute of Business & Finance (TBC)
January 11, 2030 - October 27, 2025MBA at Oklahoma City University
January 1, 1997 - October 27, 2025PG Dip Information Systems Engineering at Manchester University
January 1, 2010 - October 27, 2025BSc (Hons) Computer Science at Lancaster University
January 1, 1985 - October 27, 2025Cert. Ed Certificate of Education (Post-Compulsory) at Central Lancashire University
January 1, 1994 - October 27, 2025Qualifications
MSc Artificial Intelligence (Pending)
January 11, 2030 - October 27, 2025MBA
January 11, 2030 - October 27, 2025PG Dip Information Systems Engineering
January 11, 2030 - October 27, 2025BSc (Hons) Computer Science
January 11, 2030 - October 27, 2025Cert. Ed Certificate of Education (Post-Compulsory)
January 11, 2030 - October 27, 2025Industry Experience
Software & Internet, Professional Services, Energy & Utilities, Financial Services, Media & Entertainment, Education, Telecommunications
Skills
Experience Level
Hire a Full Stack Developer
We have the best full stack developer experts on Twine. Hire a full stack developer in Liverpool today.