Bluprintx, Salesforce consultancy, London
From spreadsheets to a single source of truth
Bluprintx Intelligence Platform
As Data Technical Lead at Bluprintx, I designed and built the internal intelligence platform for the new Data entity, from architecture standards to production pipelines and role-based access that gives every team curated, trusted datasets.
The starting point
Internal reporting relied on flat files and Excel spreadsheets. Finance, sales, and leadership each maintained their own versions of the truth. Reconciling numbers across teams was slow, error-prone, and often ended with conflicting KPIs. Nobody could confidently say which figure was correct.
A fragmented landscape after rapid growth
Years of acquisitions had left Bluprintx with a patchwork of systems and migrations. Each acquired entity brought its own tools, processes, and spreadsheets. Data lived in silos with no shared model, no lineage, and no single place to explore it.
Sage (Finance)
Core financial system for invoicing, revenue recognition, and accounting, migrated and consolidated across entities.
Kantata (Project management)
Delivery and resourcing data: projects, timesheets, utilization, and margin tracking across consulting teams.
Salesforce (Sales)
Pipeline, opportunities, accounts, and revenue forecasts, the commercial backbone of the business.
Marketo (Marketing)
Campaign performance, lead generation, and marketing attribution across channels and regions.
Spreadsheets & legacy systems
Ad-hoc Excel files and tools inherited from acquired entities, often the only source for local KPIs and manual reconciliations.
What I built
A cloud-native data platform designed to replace manual reporting with automated, governed pipelines.
End-to-end data architecture
Defined ingestion, storage, and harmonization standards across business units, a shared data model that bridges finance, delivery, sales, and marketing.
Prefect on Kubernetes
Deployed a Prefect orchestration layer on Kubernetes to schedule, monitor, and retry data pipelines with full observability and CI/CD integration.
Role-based intelligence platform
Built an internal intelligence platform from scratch with role-based access, teams explore curated datasets through APIs and self-service interfaces, without touching raw sources.
Scalable AWS pipelines & APIs
Designed automated ingestion and transformation pipelines on AWS, exposing reliable datasets to dashboards and downstream tools via APIs.
One platform, every team
The platform centralizes dashboards and curated datasets for each business function, replacing scattered spreadsheets with a single governed layer everyone can trust.
Sales
Pipeline tracking, win rates, and revenue forecasts grounded in Salesforce data.
Marketing
Campaign ROI, lead funnels, and attribution across Marketo and integrated sources.
Finance
Revenue recognition, P&L views, and reconciled figures aligned with Sage.
Delivery
Project margins, utilization, and resourcing insights from Kantata.
Executive
Cross-functional KPIs and board-level reporting with a single, reconciled view of the business.
Tech stack
AWS cloud-native architecture with Kubernetes orchestration and modern data engineering practices
AWS
Prefect
PostgreSQL
Python
FastAPI
React
Tableau
GitLab CI/CD
KubernetesBluprintx Intelligence Platform turned a patchwork of spreadsheets and siloed systems into a governed internal platform. Teams no longer debate which number is right: they explore the same curated data, through the same front door, with access tailored to their role.