Data Architect &
Solution Designer
Hands-on Data Architect & Lead Data Engineer with 16+ years' experience across financial services, utilities, and automotive, turning complex business requirements into scalable, reusable data solutions across Snowflake, Databricks, Azure, and AWS.
Selected work
Every product has a system behind the screen. Hover a screen, or tap System, to see it.
Enterprise data platform across Snowflake, Azure Data Lake, Coalesce, FME & Kafka.
Cloud data platform on Snowflake & Databricks with automated ELT & Kafka.
Governed analytical pipelines across Azure Data Lake, Snowflake & Apache Spark.
On-premises to Azure Delta Lakehouse migration with Unity Catalog governance.
Multi-cloud real-time lakehouse on Delta Lake, Databricks & Snowflake.
High-throughput telemetry & financial events processing at scale with Kafka.
Automated zero-downtime migration of on-prem databases to Azure & AWS.
Governed self-service analytics powering cross-functional BI and enterprise KPIs.
Security hardening, access controls, and 30%+ cloud data cost optimization.
More platforms & systems
Core data infrastructure, governance frameworks, and mission-critical payment engines delivered across global enterprises.
6+ years delivering governed, accurate data extracts for risk and fraud analytics.
Centralized metadata management and fine-grained RBAC across multi-tenant lakehouses.
Decoupled streaming pipelines for IoT smart meters, vehicles, and operational telemetry.
Automated monitoring for pipeline failures, data freshness, schema drift, and SLAs.
Active-active event mesh processing millions of messages across APAC cloud zones.
Enterprise Kimball dimensional modeling cutting legacy query latency by 80%.
Journey
Delivered consistent, reusable data provisioning by leading the enterprise data platform build across Snowflake, Azure Data Lake/Blob, FME, dbt/Coalesce, Airflow, Fivetran, Python and SQL, with standard ingestion, ELT and orchestration patterns. Cut manual pipeline intervention by 35% by automating pipeline execution, dependency handling and operational checks through reusable ELT components. Enabled earlier issue detection and stronger trust in analytical data by implementing monitoring for pipeline failures, data freshness, data quality and operational health. Reduced release risk for data pipelines and Power BI by establishing CI/CD and release controls with Git and Azure DevOps. Improved movement of structured, IoT and operational data by applying Kafka event-driven integration and managed ingestion patterns.
Founded Vaan Consulting to deliver modern cloud data platform solutions, lakehouse implementations, automated zero-downtime data migrations, and enterprise data governance (NZISM & APRA compliance) for organizations across New Zealand and APAC.
Reduced data latency by 40% across multiple business domains by architecting and delivering a cloud data platform on Snowflake and Databricks with ELT, Airflow, Fivetran, Python and SQL. Cut platform cost by 30% by leading the migration of legacy ETL to cloud ELT with automated orchestration, retiring high-maintenance on-premises infrastructure. Improved reliable data movement by designing batch and streaming integration patterns with Kafka and event-driven dependencies. Increased trust in enterprise data by embedding data quality, metadata, lineage, freshness monitoring and operational support controls, while setting technical direction for a 15+ member data engineering team.
Improved operational efficiency by 20% through workflow automation, standardised pipeline patterns, reusable transformation components and structured production support. Improved governed data availability for downstream consumers by building analytical pipelines across Azure Data Lake, Snowflake and Apache Spark using Python, SQL and orchestrated ELT. Gave analytics and BI teams consistent data preparation by designing reusable integration and transformation components, and strengthened confidence in regulated financial data by supporting data quality, metadata management and accessibility controls.
Project: Data Repository for Royal Bank of Canada. Improved ingestion speed by 25% by supporting the migration from on-premises systems to an Azure Delta Lakehouse using Python automation and managed ingestion. Reduced SQL query runtime by 30% by optimising workloads that support reporting and analytics. Strengthened governance and access control by implementing Unity Catalog for metadata management and security-policy enforcement in a regulated banking environment.
Project: Payment Service for US Bank and Bank of New York Mellon. Enabled risk and fraud analytics teams with governed, accurate and timely data extracts across two US banking clients over 6+ years. Improved platform stability and delivery speed by migrating legacy ETL workflows to automated, cloud-oriented frameworks. Resolved complex data integration issues as the technical escalation point, coordinating with technical and business stakeholders.
Platform Architecture & Research
1 merged8 open
Architected enterprise lakehouses utilizing Delta Lake and Snowflake, delivering sub-second query performance for analytics across petabyte-scale workloads.
Illustration
Designed real-time distributed streaming pipelines on Apache Kafka with end-to-end schema validation, out-of-order event handling, and zero data loss.
Illustration
Designed enterprise multi-cloud data mesh topology with automated data lineage, column-level security, and NZISM / APRA CPS 234 regulatory auditing.
Stack
Architecting multi-cloud lakehouse topologies, ACID transactional storage on Delta Lake, zero-copy cloning, self-serve data marts, and automated ETL/ELT pipelines.
Enterprise data cloud infrastructure on Azure, AWS, and GCP. Real-time distributed event streaming clusters with Kafka, automated IaC with Terraform, and zero-downtime database migrations.
Governed semantic models and executive reporting in Power BI, enterprise FinOps cost policy engines (35% compute reduction), spatial utilities analytics with ArcGIS, and strict NZISM/APRA regulatory security.
Scalable distributed backends, high-throughput financial transaction processing, automated operational portals in Node.js/React Native, and robust enterprise banking settlement integrations.
Auckland, New Zealand · Working across New Zealand and APAC
Cloud Lakehouses, Real-Time Streaming, Enterprise Governance
Modern full-stack data engineering, robust cloud platforms, and rapid full-stack architectures.
A comprehensive, verified record of professional qualifications spanning cloud data platforms, multi-cloud architecture, software engineering, and agile program governance.
Got an enterprise data platform that needs to scale with zero downtime? Tell me about it.
Or just email vasanthvimal@gmail.com
Pick whichever way suits you.
It comes straight to me.
Your message is on its way.