If you are interested in this candidate, please contact cer Financial on 0207 626 665

00327466

PROFILE:

Highly experienced MI Automation Developer, Software Engineer, and Data Analyst with a strong background in the Microsoft Technology Stack and data analytics. Proven ability to design, build, enhance, and support enterprise systems while transforming complex data into clear, actionable insights that support strategic decision-making.

Ayo brings extensive hands-on experience across the full application development lifecycle, combining tactical automation with strategic MI and analytics delivery. He has worked across banking, government, healthcare, transport, telecoms, manufacturing, and construction, delivering robust solutions that streamline operations, improve reporting accuracy, and drive business performance.

SKILLS:

Technical

• MI Automation & Reporting
• Data Analysis & Analytics (Inspect, Clean, Model, Visualise)
• ETL & Data Integration (Alteryx, SQL, CSV, Excel)
• Dashboard Design (Power BI, Excel)
• Application Development & Support (BAU)
• System Integration & Modernisation

Technologies

• Microsoft SQL Server (T-SQL, Views, Stored Procedures, Triggers, Jobs)
• C# (Mid-Level), VB.NET, VB6, VBA (Excel & Access)
• Power BI, Power Query
• Alteryx (ETL)
• Microsoft Excel (Advanced), Access
• .NET Framework & .NET Standard

Professional

• Business Analysis & Requirements Elicitation
• Stakeholder Communication (Technical & Non-Technical)
• Process Automation & Optimisation
• Issue Resolution & Production Support
• Team Collaboration & Leadership

EDUCATION:

1991 – 1994: University

MSc Information Systems & Technology

CAREER HISTORY:

May 2023 – 2025

Banking

MI Automation Developer (Tactical & Strategic Systems)

• Designed and built automated MI dashboards and reports using Alteryx, SQL Server, Power BI, and Power Query.
• Streamlined manual processes, improving data accuracy, reporting timeliness, and operational efficiency.
• Supported both tactical automation initiatives and long-term strategic MI systems.
• Acted as a collaborative team player, contributing technical expertise while supporting shared delivery goals.
• Technologies: Alteryx, SQL Server, Power BI, Power Query, Excel, VBA

February 2022 – December 2022

Technical Company

Software Engineer – HMRC Account

• Supported and enhanced business-critical HMRC systems, ensuring stability and BAU continuity.
• Debugged and refactored C# custom UI code to resolve compilation and runtime issues.
• Upgraded legacy VB6/VB.NET/.NET Framework 2 components to .NET Standard, including COM Interop DLLs and EXEs.
• Contributed to the Electronic Collaborative Working (ECW) platform.
• Worked on COMPASS, a multi-user desktop system for inheritance tax assessment.
• Delivered upgrades of legacy VB5/VB6 front-end applications to integrate with a new Oracle back-end.
• Technologies: C#, VB.NET, VB6, SQL Server, .NET Framework, Oracle

March 2021 – November 2021

Engineering Consultant

Front-End Operational Forms & MI Reports Developer

• Developed and maintained GUI operational data entry forms and MI reports using VB6, VBA, Excel, Access, and SQL Server.
• Automated workflows to improve operational efficiency and data consistency.
• Designed and implemented ETL processes (BCP import/export) into SQL Server.
• Provided ongoing application support and enhancements in response to business change requests.
• Built analytical reporting tools supporting engineering and compliance operations.
• Technologies: VB6, VBA, SQL Server, Excel, Access, C#

Jun 2016 – Mar 2021

Engineering Company

Workflow Management System Developer & Data Analyst

• Lead developer for the company’s bespoke ERP/MIS platform (Time Application).
• Designed and developed VBA front-end applications (Excel & Access) integrated with a centralised SQL Server database.
• Built and maintained SQL Server stored procedures, views, triggers, functions, and scheduled jobs.
• Delivered ETL solutions for external data sources (CSV, XLS).
• Analysed and documented system workflows across finance, HR, project management, compliance, and H&S.
• Awarded Best IT Programmer of the Year (2020).
• Technologies: VBA, SQL Server, C#, VB.NET, Excel, Access

September 2015 – May 2016

Banking

VB & SQL Developer

• Developed real-time banking applications supporting retail credit processing.
• Built VB5/VB6 front-end forms and Excel reports used daily by 300+ users.
• Implemented SQL Server back-end objects supporting high-value credit workflows (€2.5bn).
• Contributed to centralised fulfilment and credit action systems.

July 2015 – September 2015

Personal care product company

Excel VBA Report Developer

• Developed industrial performance variance modelling tools using Excel VBA and SQL.
• Built cost and efficiency models integrating SAP production data.
• Delivered automated reporting tools supporting manufacturing performance analysis.

April 2015 – May 2015

Technical Company

Data Analyst / Report Developer

• Contributed to the Huawei Strategic Index (HSI) Tool.
• Automated KPI data extraction via web scraping and Excel VBA.
• Developed dashboards presenting regulatory and market performance data.

August 2014 – March 2015

Healthcare

MI Reports Analyst Developer

• Lead developer for Board-level and Divisional KPI dashboards.
• Built advanced VBA and SQL solutions for complex healthcare datasets.
• Delivered regulatory reporting for NHS England and CQC compliance.

Jul 2012 – Jul 2014

Oil & Gas Company

Application Data Support Engineer

• Supported and enhanced Access, VB6, and Excel VBA applications.
• Automated data manipulation and reporting processes.
• Delivered analytical and technical support across operations.

Nov 2011 – May 2012

Transport Company
MI Reports Analyst Developer

• Developed automated Director-level reporting tools for S-Stock train deployment.
• Integrated Excel data with Primavera P6 to generate executive reports and PDFs.
• Supported Mayor of London reporting requirements.
  

ADDITIONAL INFORMATION:

Award: Best IT Programmer of the Year – MLM Group (2020)

References Available Upon Request

If you are interested in this candidate, please contact cer Financial on 0207 626 665

To view other CV's please click here.