Data & BI Analyst building dashboards, automation and decision-ready analytics.

Problem

Commercial and product teams needed consistent, scalable reporting across clearing members, derivatives products and liquidity trends. Static Excel reports created recurring ad-hoc requests and fragmented performance views.

Solution

Built self-service Power BI dashboards and KPI frameworks for derivatives performance across Equity Index, Fixed Income and 10+ product categories. Supported the migration from static reporting into a more scalable BI setup using centralized data models.

Problem

Collateral fee movements across institutional clearing members required faster anomaly detection and better visibility into the drivers behind unusual fee changes.

Solution

Developed a Python-based statistical outlier detection model using SciPy and Statsmodels on HDFS data. The model surfaces anomalous collateral fee patterns and supports driver analysis across the clearing member base.

Problem

Cash market operations involved recurring manual reconciliation, file processing and reporting workflows. These tasks created manual effort, inconsistent quality checks and avoidable operational risk.

Solution

Built automation workflows with Power Automate and AI Builder, reconciled large datasets with Power Query and VBA, and created repeatable controls for recurring operational reporting.

Problem

Compliance-related PDFs required repetitive manual checks for stamps, signatures and exceptions. Manual review was time-consuming and exposed the process to visual fatigue errors.

Solution

Developed a Python and OpenCV-based verification tool to process compliance PDFs and flag exceptions for manual review.

Problem

Large infrastructure teams needed reliable KPI visibility and resource tracking across multiple work packages in the UK HS2 rail programme.

Solution

Built Power BI dashboards, Power Apps solutions and automated data transformation pipelines for engineering and project management stakeholders.