Business Data Analyst with transferable skills and extensive experience designing, scripting, testing, and supporting next-generation data solutions within multi-platform proprietary and open-source data environments, with a solid drive to build solutions that automate processes and create efficiency. Proficient in an assortment of technologies, data framework and analytical tools including but not restricted to MySQL, PostgreSQL, AWS RedShift, Python, Power Query, MS SQL Server, IBM DB2, Oracle, Apache Web Server, JavaScript, XML, XQuery, SSIS, Power BI, Tableau Desktop, Azure Data Factory, Azure Synapse, Databricks, Dataverse, Palantir Foundry, Apache Spark, PySpark, Dask, DuckDB, Pandas/Polars, Talend and Power Query. Recent delivery includes AI-driven purchase order confirmation automation in Palantir Foundry, spanning supplier email ingestion, PDF/spreadsheet extraction, deterministic reconciliation, human-in-the-loop exception handling, and ERP write-back integration.
Microsoft Dataverse, Model-Driven Apps, Power Apps, Power Automate (Enterprise app design, data modelling, workflow automation)
03 Certifications & Professional Affiliation
Professional Member, British Computing Society (BCS)
Cisco Certified Network Associate (CCNA)
Oracle Certified Database Administrator
Microsoft Certified Professional (MCPS)
Information Systems Security Professional (NSA)
Microsoft Certified: Azure Data Engineer Associate
Microsoft Certified: Fabric Analytics Engineer Associate (In view)
04 Work Experience
Terex – Purchase Order Confirmation Automation
12/2025 – 03/2026
Lead Data Engineer / Solution Designer
Designed and delivered an AI-driven order confirmation automation workflow in Palantir Foundry, taking supplier confirmation emails through attachment ingestion, structured extraction, reconciliation, exception handling, and ERP-ready output.
Evaluated multiple extraction approaches across LLM and VLM pipelines using reference-based accuracy testing, coverage analysis, character-error metrics, and processing-time trade-offs to support an evidence-based architecture decision.
Developed deterministic business rules to enforce header-level precedence, normalise supplier-specific document variations, and reconcile confirmed header and line-level data against originating purchase orders and shipment lines.
Built matching and validation logic for quantities, prices, delivery dates, release numbers, and multi-line purchase orders, with explicit exception routing and no silent correction of discrepancies.
Implemented human-in-the-loop review capability in Foundry Workshop to surface only high-risk or ambiguous confirmations, improving straight-through processing while preserving auditability and operational control.
Integrated the solution with downstream ERP/TMS write-back APIs, including payload preparation, audit logging, validation checks, and remediation handling for production-oriented operational workflows.
Produced architecture, extraction analysis, data quality, operational walkthrough, and stakeholder-facing documentation to support UAT, design assurance, and production-readiness discussions.
Health Improvement and Education Wales – Ph2 M365 Power Platform Support & Development
09/2025 – 12/2025
BI Reporting Consultant / Data Architect
Provided post-implementation support and enhancement for Power Platform and Power BI Embedded solutions within the HEIW TIS ecosystem.
Investigated and resolved Power BI Embedded access and security model issues, clarifying separation between Dataverse security roles and Power BI dataset/report permissions.
Reviewed and improved Row-Level Security (RLS) configurations to ensure correct data access behaviour in embedded reports.
Performed targeted fixes and incremental improvements to embedded reporting performance, usability, and reliability.
Contributed to documentation updates and knowledge transfer, particularly around Power BI Embedded architecture, security model usage, and operational support guidance.
Palantir Foundry – Population Health Management PoC
05/2025 – 08/2025
Data Engineer / Geospatial Analyst
Created ontology models for MSDS datasets, supporting KPIs across Ethnicity, Age, and Location, aligned to PHM equity and analytics initiatives.
Applied Polars and Pandas (GeoPandas) hybrid pipelines for memory-efficient joins, geospatial transformations (geohash encoding), and population-weighted IMD calculations. Delivered lightweight Python containerised transformation pipelines using Polars (Rust-based performance improvements) and GeoPandas for geospatial handling.
Built geo-enabled datasets incorporating NHS geographies (SubICB, ICB, NHS Regions, LSOA), population data, deprivation classifications, and spatial geometry in Parquet schema formats.
Developed map visualisations and static Workshop layers, configuring GeoJSON integration and layered geospatial insights for Population Health Management (PHM) use cases.
Implemented incremental and batch syncs leveraging PostgreSQL, with successful scheduled and unscheduled jobs. Documented file size optimisation when ingesting via SQL tables (e.g., reducing a 955 MB CSV to 112 MB through PostgreSQL ingestion).
Ensured data pipeline alignment with FHIR/HL7 standards for interoperability and data security.
Health Improvement and Education Wales – Single Platform Project
02/2024 – 05/2025
Data Architect
Designed and developed a robust Dataverse entity model for the Training Management system.
Spearheaded a successful data migration utilising Dataverse data flows and Power Query, showcasing their versatility in transforming data.
Championed a cost-effective bulk reporting solution using Azure Synapse Link, leveraging existing team expertise in SQL.
Performed comprehensive data architecture reviews, pinpointing optimisation opportunities and ensuring seamless alignment with established process flows and user journeys.
NHS Wales App Project, DHCW. Wales
09/2023 – 12/2023
Data Engineer
Engineered structured data architecture leveraging Azure analytics services – including Log Analytics, Data Factory, SQL Database and Power BI.
Drove platform buildout end-to-end, evaluating technologies for an ideal balance of governance, performance and agility based on use cases.
Identified high-value datasets and KPIs, working closely with stakeholders to prioritise MVP metrics across user engagement, conversions, and more.
Constructed enterprise data warehouse centralised on Azure SQL Database to enable governance and enterprise BI for the NHS Wales App.
Built interactive Power BI analytics dashboard providing actionable, real-time visibility into mobile and desktop app usage and digital health trends.
Conducted in-depth stakeholder interviews to gather valuable insights and perspectives, followed by meticulous analysis and scoring of the data against established domain and criteria for the sustainment phase.
Nova Scotia Province – Sustainment Planning. Canada
06/2023 – 08/2023
Business Analyst / Tech Expert
Collaborated with the EY team to develop framework to assess and prioritise solution and application transitions (upgrades, deprecations, etc.) and determine the risk-filtered requirements to continue to maintain/sustain expected and base services/functions.
NHS App Project, NHS Digital
07/2022 – 02/2023
Data Analyst
Collaborated with cross-functional CHT (Citizen Health Tech) teams to gather and analyze data from various health related sources.
Involved in the migration of data logs from Splunk to Azure Event Hub to eliminate data loss issues.
Facilitated Analytics function handover to IBM through knowledge transfer sessions, shadowing and reverse shadowing.
Orchestrating data movement and transformation leveraging ADF (Data Factory) in data integration processes.
Investigation into user account duplication issues, involving user list purge exercise, de-duplication of user base and removal of known deaths to have more representative data volumes for capacity planning, allocation and reporting needs.
NHS Leicestershire Health Informatics Service (LHIS). Leicester
03/2022 – 06/2022
Data Engineer
Developed a QOF framework data model, orchestration and ETL process to support LLR Trust's General Practice dashboard leveraging Python and PySpark technologies.
Data migration from proprietary systems to cloud storage.
Maintained and automated pipeline with reference data lookups via the NHS Spine service and other publicly accessible publications.
Engaged with system and tech teams to investigate Active Directory (AD) configurations to support role-based access (RBAC) and Row-level security (RLS) in reporting.
Implement data flows to connect operational systems, data for analytics and business intelligence (BI) systems.
Managed Quarantine Service (MQS), DHSC. London
12/2021 – 03/2022
Data Modeller / Analyst
Capacity and Demand modelling re border policies, Covid prevalence, Home/hotel quarantine whilst taking into consideration the upstream and downstream effects of policy changes on existing resource.
Performed a meticulous business impact analysis of applications to determine mission criticality, including end of life, upgrade pathways and future replacement potential with the OPOR (One patient one record) system.
Analysed the risks associated with maintaining existing solutions, including potential security vulnerabilities, outdated technology, limited vendor support, or compliance issues.
Presented comprehensive findings and reports, leveraging Python scripting for advanced data analysis and Power BI visuals to effectively communicate complex information in a clear and visually compelling manner.
NHS App Project, NHS Digital. Leeds
10/2018 – 12/2021
Performance Analyst
Uptake, usage, and performance analytics reporting for senior stakeholders using Power BI and Tableau for the presentation/visualisation layer.
Engagement, conversion, pathing analytics and A/B testing via digital analytics platforms and user feedbacks i.e., HotJar, Adobe Analytics and Qualtrics.
End to end process automation leveraging Power Automate and Databricks (Jupyter notebook). Sourcing dependent data from DfT, Home Office (HO), including the EDGE Analytics Platform and Azure SQL Servers.
Passenger Locator Form (PLF) analytics and reporting.
Workforce tracker reporting and visualisation leveraging Power BI, DAX and Python.
Quarantine service BAU reporting, prevalence and absconder reports for HO & Test and Trace stakeholders.
Covid models and research papers summarisation of critical inputs and outputs.
Consolidating App data across different channels and repositories. Responsible for publishing App data to NHS England EtP (Empower the Person) and the Citizen's Health Tech teams to support their analytics dashboard.
Covid vaccine status reporting to Secretary of State.
Insights analytics looking at interaction volumes and proportions Pre and Post Covid Pass.
Manage App's digital analytics environment in Adobe Analytics. Perform sentiment analytics on qualitative dataset from in-app polls, app stores and social media to assess engagement.
Leveraging NHS spine services API to resolve app-level identifiers (ODS Codes) to practice names and comparing digital uptake across multiple groupings (Region, STP, CCG).
Machine log analytics using Splunk's SPL (Search Programming Language).
Data reconciliation checks as part of wider data migration exercise from on-prem to cloud.
BBC (Design+Engineering), Perivale
06/2014 – 06/2018
Senior Data Engineer
Contributed considerably to the continued build of the client-side reporting user interface for the cloud reporting tool including parameterisation of reports, data visualisation based on pre-defined specifications. Designed test script for Operational Acceptance Testing for the new reporting portal.
Legacy Sound data architecture modelling and consolidation of legacy radio data (BBC Radio 1, Radio 2, and Radio 4) assets across disparate repositories. Data Wrangling, Mapping and Profiling using SQL Server DQS, SSIS, Pandas (Python) and Talend DQ. Rationalisation of headings and wholesale data cleanse. Extraction and loading of Broadcast Wave Format (BWF) files' metadata into tabular format for easy lookup and comparisons with stock audit data and other associated holdings.
Archive stock check data validation, transformation, and load. Scripting of client-side input validation on stock check forms using jQuery.
Text mining on free text field in Data Stores (ODS) and Keyword and Keyphrase extraction using n-grams. Work alongside the service design team in testing and assessing models, A/B Testing and on actionable cohort analytics. Advise on digital analytics data layer implementation.
Managed web, data and database administration assignments for diverse industry clients and functionalities. Enhanced database performance, performed restores, implemented recovery procedures, handled performance tuning, and conducted regular system backups.
Enterprise Data Warehouse logical and physical modelling based on Star schema (Kimball). Data warehouse ETL load designs with Change Data Capture (CDC) and Slowly Changing Dimension (SCD).
ETL build using SSIS, Python and Talend Data Profiling and Integration tools including Data Quality Analysis of disparate data sets across multi proprietary DB engines using Linked Server, ADO.NET, ODBC and JDBC connections.
Managing RedShift Data Warehouse instance on AWS alongside the Jasper Server reporting portal.
Design and maintained ETL processes using Python, scripting of programs in Python for basic administrative checks like database and web server uptime checks and auto restart on non-availability. Creation of data visualisations using Pandas, Numpy, Flask, Bokeh and Matplotlib modules in Python.
Regex, jaro-winkler, fuzzy lookups, Levenshtein, rake-nltk, full-text search and other similar models using Python and SQL. Predictive analytics using Neural Network, Logistic Regression, and similar classifier models.
Compilation of move and asset loan's reports for Audit Team from Accenture for annual assessment.
Generating Ad-hoc holdings reports leveraged on local instance IBM DB2 and SQL Server databases.
Championed the move from MySQL databases to PostgreSQL for project databases for improved analytics, performance, and a more robust query optimisation from a reporting point of view.
MI ComputSolutions, Brixton / Deptford
10/2011 – 06/2014
Web & Data Analyst
Ensure technical and functional designs of Databases and Data Systems meets changing business constraints especially with the SQL Server 2012 and MySQL database installations.
Created Web enabled annual leave and appointments scheduling system for the HR Department. Delivered solution on time, on spec and on budget.
Web data presentation through scripted SQL queries. Converted page embedded SQL queries to optimised Stored Procedure. Implemented web data analytics using Piwik and Google Analytics.
Assigning relevant server and database roles to employees and granting or revoking privileges or permissions on objects to domain users. Manage and administer SQL Server estate.
Solved database performance issues by indexing relevant views and modifying stored procedures logic.
Data Manipulation, Analysis and Reporting using in-house system Pellcomp PICS / SugarCRM, Managing the Funding Information System (FIS) and associated SQL Server Database instance.
Shredding and Refactoring XML documents into relational; and vice-versa. ETL.
Enhanced end users' understanding of database systems by conducting pre-implementation workshops, delivering training sessions and creating user-friendly training materials.
Developed a MS Access Based file indexing and archiving solution to meet current administrative needs. Generated Ad-hoc reports and data visualisations from relevant information systems.
Assisted in the development, documentation, and support of several ASP.NET and PHP scripted mission critical applications. Contributed over 80% of the source code for the corporation's web portal.
05 Education & Training
University of Greenwich, London
Master of Science — Merit in IT with E-Business | Graduated 2011
Key Modules: Internet and Web Technology · System Planning and Management · Human Computer Interaction Designs · Requirement Analysis · Audit and Security · Systems Architecture
MSc Dissertation: Investigating Performance issues for PHP and ASP.NET Data Driven Web Applications: A Comparative Test Analysis.