← Selected work
CASE FILE 01 / Enterprise platform architectureEnterprise data platform

A foundation that serves more than one business.

An enterprise data platform supporting multiple business domains through shared architecture.

MY ROLE
Primary solution architect
ENGAGEMENT
Enterprise client engagement through TCS
STATUS
Established platform · ongoing evolution
01 / CONTEXT & OWNERSHIP

The challenge behind the platform.

Teams across several business domains needed a common data foundation spanning ingestion, warehousing, and downstream analytics.

My contribution

Primary solution architect, from initial design through platform evolution and delivery.

02 / ARCHITECTURE & DECISIONS

Inside the system.

01
Business sourcesMultiple enterprise domains
02
Ingest & orchestrateMetadata-driven ETL · Airflow · Python / PySpark
03
Model & governRedshift · PostgreSQL · Dimensional models · MDM
04
Distribute & analyseGoverned analytics layer · Downstream consumers
Conceptual flow · Simplified from documented project scope
01

Designed reusable, restartable, metadata-driven ETL patterns to support scalable onboarding.

02

Architected AWS pipelines orchestrated through Airflow, with Redshift and PostgreSQL warehouse models.

03

Integrated source-to-target testing with issue-tracking evidence and established CI/CD and regression processes.

04

Replaced access-key-based access with IAM role-based authentication and optimised EMR configurations for workload needs.

AWS · Airflow · Redshift · PostgreSQL · Python / PySpark

03 / EXECUTION

From design to delivery.

Collaborated with business stakeholders on platform and supply-chain solution design. Translated requirements into delivery backlogs, Agile/Scrum execution, data-quality controls, and SLA governance.

04 / OUTCOME & EVIDENCE
1shared enterprise data foundation across multiple business areas

Established a shared enterprise data foundation and reusable ingestion and modelling patterns across multiple business domains; workload optimisation improved infrastructure utilisation.

CONTINUE EXPLORINGPlatform modernisation↗