Ayo S

Business Analyst | Data | Agile | SAFe | Digital Transformation | CRM | AI

Salary / Daily rate

London, UK

Freelance, open to permanent contract

Skills

Power BIData AnalysisJiraConfluenceSQL QueriesPostgreSQLAzureRESTful APIsn8nMonday.comAirtableZapierScrumTesting & QACRM

About me

Intro

PROFESSIONAL PROFILEBPSS-cleared Senior Business Analyst with 10+ years' experience delivering digital platforms, CRM transformations, and data-driven solutions across public sector, finance, and higher education. Experienced in driving end-to-end analysis and solution design, translating complex business needs into scalable, user-centred outcomes aligned to GDS principles and Agile delivery, with a strong focus on regulatory compliance and audit-ready solutions. Proven track record in orchestrating system integration across Microsoft Dynamics 365, cloud (Azure), and data platforms (Power BI, SQL), improving operational efficiency, data visibility, and service delivery. Brings hands-on experience in AI-driven automation (LLMs, workflow orchestration), ensuring solutions are designed with data protection, GDPR compliance, and governance considerations embedded, while enhancing decision-making in fast-paced environments.

Links

Work experience

Business Analyst

Howard Lock Consulting Ltd

Oct 2025 - Mar 2026

6 months

London, UK

Project 1: AI-Powered Knowledge Automation (n8n & LLM) Summary: Delivered an AI-driven solution to improve access to fragmented knowledge through intelligent retrieval and automation. – Built AI-powered knowledge retrieval using n8n, OpenAI (LLMs, embeddings), and a vector database – Integrated multiple data sources into a centralised platform – Reduced manual workload by 15-20 hours per week – Improved access to information and response accuracy – Increased operational efficiency by ~35% Project 2: Data Migration & Knowledge Consolidation Summary: Migrated legacy knowledge into a structured, AI-ready environment to support automation and reporting. – Migrated knowledge assets into a unified data structure – Defined data models and transformation rules – Improved data quality through cleansing and validation – Built data pipelines to support AI and reporting Project 3: Continuous Improvement & Workflow Optimisation Summary: Improved operational workflows by identifying inefficiencies and implementing automation. – Led continuous improvement across key processes – Designed and implemented n8n automation – Aligned improvements with stakeholder priorities – Monitored and optimised performance for sustained gains Project 4: Customer Data Governance & FCA Compliance Summary: Strengthened data quality and regulatory compliance through improved governance and standardised data capture. – Led data governance to improve quality and FCA compliance – Analysed onboarding journeys across digital channels and Dynamics 365 – Defined data standards and business rules – Implemented validation rules and mandatory fields – Mapped CRM to reporting data (SQL, Power BI)

Senior Business Analyst

Education and Training Foundation

Aug 2024 - Oct 2025

1 year 3 months

London, UK

Project 1: Digital Transformation – Skills Scan Platform Summary: Delivered a user-centric platform to replace fragmented tools, improve data visibility, and enable consistent access through a single SSO-enabled ecosystem. – Led discovery and solution design, consolidating seven platforms into a single SSO (Azure AD B2C) – Analysed user journeys across web platforms and Microsoft Dynamics 365 to improve service delivery – Defined business processes and user stories for the Skills Scan platform – Integrated CRM, web platforms, and third-party systems to enable seamless data flow – Oversaw UAT planning (Azure DevOps), reducing testing turnaround by 20% – Designed future-state data flows across CRM and Power BI reporting Project 2: LMS Migration & Vendor Procurement Summary: Migrated from a legacy learning system to a scalable LMS, improving user experience and enabling future growth. – Led migration to an off-the-shelf LMS, improving scalability and performance – Defined requirements and evaluation criteria for vendor procurement and tendering – Facilitated stakeholder workshops to capture LMS needs and align priorities – Ensured integration between LMS and Dynamics 365 for unified user data – Improved content access and user journeys, supporting platform adoption Project 3: Payments & Finance Integration Summary: Implemented end-to-end payment and finance integration to improve billing accuracy, automation, and financial visibility. – Integrated payment platforms (e.g. Stripe) with Dynamics 365 Business Central – Automated finance workflows, improving reporting accuracy by ~25% – Defined data flows across CRM, LMS, and finance systems for consistency – Enhanced reporting and visibility using Power BI – Strengthened reconciliation and financial controls, reducing manual effort and risk

Business Analyst

Valuation Office Agency

Jun 2023 - Jun 2024

1 year 1 month

Greater London, United Kingdom

Project A: Appeals Process Transformation (SAFe Environment) Summary: The project focused on redesigning the end-to-end VOA Appeals process within a multi-vendor SAFe environment to address delays, bottlenecks, and a high volume of cases escalating to the High Courts, driving significant time and cost pressures. – Redesigned end-to-end VOA Appeals process to reduce delays and High Court escalations, improving operational efficiency – Mapped AS-IS and TO-BE processes using BPMN 2.0 by shadowing caseworkers, identifying inefficiencies and improving process visibility – Improved data exchange between taxpayers, agents, and local councils by defining integration requirements and supporting Azure-based automation – Managed and prioritised a Jira backlog of 500+ work items across multiple Agile teams, ensuring alignment with business priorities – Validated Power BI reports covering 300+ local authorities, improving reporting accuracy and supporting data-driven decisions – Supported sprint planning, reviews, and backlog refinement sessions, improving delivery consistency and stakeholder alignment – Contributed to automation initiatives that reduced contact centre calls by approximately 40% and improved service efficiency

Business Analyst

HMRC VOA Programme

Jan 2023 - Jun 2023

6 months

London, UK

Project B: Local Authority Data Portal & Reporting Transformation Summary: The project focused on delivering a new portal for local authorities across England and Wales to streamline the upload and assessment of council tax and business rates datasets, addressing delays in data processing and a high volume of queries caused by the legacy Oracle system. – Collaborated with stakeholders to gather and define detailed data requirements, aligning data outputs with statutory reporting needs and operational decision-making – Used SQL to query and extract data from legacy Oracle databases and multiple data sources, enabling detailed analysis of council tax and business rates datasets – Performed data transformation and cleansing in Excel, including structuring datasets, applying validation rules, and preparing data for reporting and visualisation – Loaded and modelled transformed data into Power BI to develop interactive dashboards, providing management with clear insights to support decision-making – Analysed existing data processes and identified governance and data quality gaps, recommending improvements to data standards and validation controls – Documented end-to-end data flows, including extraction, transformation, validation, and reporting layers, supporting migration into a Dynamics 365 target data model – Improved data accuracy by approximately 25% through implementation of validation rules and structured data cleansing processes – Reduced data processing turnaround time by 30%, enabling faster reporting cycles and more timely decision-making for stakeholders

Business Analyst

HMRC VOA Programme

Jul 2021 - Dec 2022

1 year 6 months

London, UK

Project C: Legacy Case Management Migration (Oracle to Dynamics 365) Summary: The project focused on redesigning and migrating a legacy case management system from Oracle CDB to Microsoft Dynamics 365 within a multi-vendor SAFe environment, addressing inefficiencies in handling check, challenge, and appeal processes for council tax banding. – Supported migration of legacy Oracle CDB system to Dynamics 365, improving efficiency of case management processes – Facilitated stakeholder workshops to capture requirements and map end-to-end processes using BPMN 2.0 in Visio – Identified bottlenecks and automation opportunities to streamline workflows and reduce manual interventions – Produced and refined over 500 user stories with acceptance criteria, enabling structured Agile delivery via Jira – Collaborated with Product Owners and vendors to prioritise backlog items, accelerating implementation timelines – Enabled smoother system migration and improved operational efficiency through clearer process design

BUSINESS ANALYST

University of Greenwich

Jul 2019 - Jul 2021

2 years 1 month

Greater London, United Kingdom

Project 1: Student Data & Regulatory Reporting Compliance Enhancement (Ellucian Banner) Summary: The project enhanced the Ellucian Banner Student Records system, integrated with the Student Portal and Oracle backend, to improve data accuracy, system reliability, and regulatory reporting compliance. It streamlined fragmented enrolment and assessment processes, strengthened system integration, and reduced audit risk, delivering a more stable and user-friendly platform for efficient student administration and reporting. – Led optimisation of the Ellucian Banner Student Records system (integrated with Student Portal and Oracle backend), supporting 10,000+ student records annually – Owned system upgrade requirements, ensuring 100% data integrity with zero data loss – Directed process and data flow analysis, delivering a 20% improvement in enrolment processing – Designed wireframes and prototypes, reducing user issues by ~25% – Oversaw UAT execution, achieving 95%+ test pass rates – Ensured audit and regulatory compliance, achieving 100% audit success – Resolved system issues across Banner and Oracle, reducing incidents by ~30% – Delivered stable releases with zero critical defects, reducing support queries by 20%

Business Analyst

University of Greenwich

May 2010 - Jun 2019

9 years 2 months

Greater London, United Kingdom

Project 2: Student Finance & Tuition Fee Management System Enhancement Summary: This project focused on improving tuition fee management and student payments across Ellucian Banner, payment platforms (e.g. Stripe / WPM Education), and finance systems such as Oracle Financials. The initiative streamlined billing, payment processing, and reconciliation by improving integration between student records, payment gateways, and finance systems, reducing errors and ensuring compliance with funding body and regulatory requirements. – Led analysis of tuition fee processes across Ellucian Banner and finance systems (e.g. Oracle Financials), identifying gaps in billing and payment tracking – Defined AS-IS and TO-BE processes and fee rules, improving calculation accuracy across home, EU, and international categories – Orchestrated integration improvements between Banner, payment platforms, and finance systems, enabling more accurate billing and reconciliation – Oversaw UAT and data validation, ensuring accuracy across thousands of student records – Delivered a 20-25% reduction in fee calculation errors, improving financial accuracy and efficiency – Strengthened reconciliation and regulatory compliance, meeting HEFCE and funding body requirements

Business Analyst/Scrum Master

Tritek Consulting Limited

Aug 2016 - Dec 2018

2 years 5 months

London, UK

– Improved team productivity and delivery timelines by facilitating clear communication between the development team, Product Owner, and key stakeholders. – Used Jira to support expectation management, track progress, and maintain alignment on delivery goals and priorities. – Coached the team on Agile principles and ways of working, reinforcing best practices to improve consistency and delivery confidence. – Strengthened team dynamics by embedding inspection, transparency, and adaptation practices, resulting in a 75% improvement in collaboration and effectiveness. – Facilitated core Scrum ceremonies, including sprint retrospectives, to drive continuous improvement. – Increased sprint productivity by optimising Jira metrics such as burndown charts, raising average sprint velocity from 40 to 50 story points.

Business Analyst/Product Owner - PAYMENT SERVICE PLATFORM

Ileero Consulting

Jun 2006 - Aug 2010

4 years 3 months

London, UK

– Supported delivery of a Payment Service Platform under SAFe, enabling structured planning, dependency management, and incremental release. – Produced end-to-end customer journey maps across web and mobile, improving clarity of user flows and reducing rework during delivery. – Elicited and documented high-level requirements and user stories, accelerating backlog readiness and sprint planning. – Managed and maintained a prioritised product backlog, improving stakeholder visibility and delivery alignment. – Identified and managed cross-team dependencies, reducing delivery risks and supporting on-time releases. – Facilitated workshops and sprint reviews, supporting regular demonstrations of shippable increments and faster stakeholder feedback cycles.


Education

University of Greenwich

MSc, Enterprise Systems and Data Warehousing, Information Technology

University of Greenwich

BSc, Information Systems, Information Technology

Obafemi Awolowo University

BSc, Demography and Social Statistics


Licenses & certifications

ITIL3F ITIL(R) V3 Foundation Certificate in IT Service Management

Issued: –

Introduction to Data Analysis using Microsoft Excel

Issued: –

Microsoft Certified: Azure Data Fundamentals

Issued: –

Certified by Microsoft

PROJECT REQUIREMENTS ANALYST

Issued: –

SCRUM MASTER

Issued: –

The best place to find your next move

© 2026. All Rights Reserved.