Looking for a job

Prasanna Bhat

@prasannabhat1

Principal Data Engineer at Lloyds Bank who modernized a banking warehouse into an Azure Lakehouse using Medallion Architecture.

United Kingdom

Message

At Lloyds Bank, I led the modernization of a banking data warehouse from on-premise platforms to Azure and Oracle DBaaS. I designed an Azure Lakehouse and Warehouse using Medallion Architecture, ADLS Gen2, Azure Data Factory, Databricks, Synapse Analytics, and dbt.

I developed metadata-driven ETL/ELT pipelines and reusable dbt models, adding incremental processing, data quality checks, and automated lineage. I also designed Data Vault 2.0 models across customer, accounts, transactions, and risk domains.

At Epsilon, I designed analytical data marts with Azure Synapse Analytics and Azure SQL, and built Databricks pipelines for web logs and semi-structured data. I also modernized legacy analytics platforms by migrating data from Netezza to Azure Synapse.

Earlier, at Accenture Limited, I worked on PeopleSoft HCM data migration to Oracle HCM Cloud, including transformation, validation, and reconciliation. Across roles at Dell International, HCL Technologies, TCS, and Ovation Infotech, I delivered database, data modeling, migration, and software development work.

Experience

Work history, roles, and key accomplishments

Current

Data Engineer

Current

Lloyds Bank

Jun 2019 - Present (7 years 5 months)

Led modernization of a large banking data warehouse, migrating from on-premise platforms to Azure and Oracle DBaaS. Designed an Azure Lakehouse/Warehouse platform using Medallion Architecture with ADLS Gen2, Azure Data Factory, Databricks, Synapse Analytics, and dbt.

Azure ADLS Gen2 Azure Data Factory Databricks PySpark Synapse Analytics DBT DataVault 2.0 Oracle SQL Server REST APIs Data Governance Data Quality Lineage Microsoft Fabric

Principal Database Architect

Epsilon

Mar 2017 - Jan 2019 (1 year 10 months)

Designed and delivered high-performance analytical data marts using Azure Synapse Analytics and Azure SQL. Built large-scale data processing pipelines with Azure Databricks and architected end-to-end data ingestion with Azure Data Factory.

Azure Synapse Azure SQL Azure Databricks PySpark Azure Data Factory ADLS Gen2 Netezza PostgreSQL PL Python Pandas Psycopg2 Data Migration Data Lake

Associate Manager

Accenture Limited

Jun 2010 - Mar 2017 (6 years 9 months)

Installed and configured OBIA 11x, OBIEE 11x, and ODI 12C, integrating with Oracle Fusion HCM. Designed and implemented ETL processes using ODI 12c, Python, and PL/SQL for PeopleSoft to Oracle HCM Cloud migration.

OBIEE ODI Oracle Fusion HCM PeopleSoft HCM ETL Python Pandas Oracle Pl SQL Data Migration Data Integration

Sr. Technical Lead

Dell International

Nov 2009 - May 2010 (6 months)

Delivered enterprise data migration solutions, consolidating service master data from Oracle, Tandem, Sybase, and SQL Server into a unified Oracle environment. Developed PL/SQL-based data loading, reconciliation, and exception-handling frameworks.

Oracle Tandem Sybase SQL Server ETL Pl SQL Data Migration Data Quality Data Mapping

Associate Project Manager

HCL Technologies

Sep 2004 - Oct 2009 (5 years 1 month)

Served as a Technical Consultant for the EaglePACE platform, providing technical leadership and solution design. Designed and implemented enterprise data models using Data Vault, 3NF, and Star/Snowflake schemas.

Eagle PACE Data Vault 3NF Star Schemas Dimensional Modeling (Star And Snowflake Schemas)Oracle Pl SQL Performance Optimization Query Optimization

Database Developer

TCS

Nov 2003 - Sep 2004 (10 months)

Designed, developed, and optimized enterprise SQL and PL/SQL solutions, focusing on performance, scalability, and efficient data processing. Performed database performance tuning through execution plan analysis and indexing strategies.

SQL Pl SQL Performance Optimization Indexing Query Optimization Erwin Data Modeler Data Modeling

Software Engineer

Ovation Infotech

Jun 2001 - Nov 2003 (2 years 5 months)

Developed software applications, reusable libraries, and reporting engines using Visual Basic 6.0, integrating with Oracle databases. Designed and implemented user interfaces for touch-screen monitors using Adobe Photoshop.

Visual Basic 6.0 Oracle Photoshop Software Development UI Design