Suresh Budanam

WORK HISTORY

EDUCATION

ABOUT SURESH BUDANAM

I am a dynamic, results-driven and innovative IT professional with 16 Years of experience in Data warehousing in Data Architecture, Design, Data Migration, Data Modeling, ETL Mapping, Development, Testing and Implementation of Data Warehouse, Big Data, Data Mart, Data Lake and Lakehouse solutions.• Designed and implemented Medallion Architecture (Bronze → Silver → Gold) on Databricks using Delta Lake with ACID, Time Travel, and schema evolution.• Built Raw Vault layers using Hubs, Links, and Satellites with metadata-driven ELT patterns and automated historization.• Led the architectural design and execution of the Azure Synapse → Databricks Unity Catalog migration.• Owned the full lifecycle of migrating data, pipelines, and security from Synapse to Databricks UC.• Design the target architecture in Unity Catalog (metastore, catalogs, schemas, lineage).• Developed Business Vault constructs (PIT tables, Bridge tables, Reference tables) to support downstream analytics and performance needs.• Modeled Information Vault and transformed Business Vault outputs into dimensional Gold-layer marts optimized for BI consumption.• Engineered scalable ingestion pipelines using Auto Loader to process high-volume streaming and batch data into the bronze layer.• Constructed declarative, quality-enforced ETL pipelines using Delta Live Tables (DLT) with expectations for validation and anomaly detection.• Leveraged Unity Catalog for enterprise-wide governance, lineage tracking, data classification, and fine-grained RBAC across all layers.• Designed dimensional models (Star/Snowflake) and curated Gold semantic layers for Power BI reports and enterprise analytics.• Integrated Databricks with Azure services (ADLS Gen2, ADF, Key Vault, Event Hub, DevOps) for secure, orchestrated, and automated data workflows.• Implemented CI/CD pipelines in Azure DevOps to version-control Databricks notebooks, SQL objects, and Power BI assets.• Applied data quality frameworks and DV 2.0 standards across all vault layers ensuring auditability, completeness, and traceability.• Created detailed lineage and business documentation using Unity Catalog, mapping source → Raw Vault → Business Vault → Information Vault → Gold data flows.• Designed and mapped source systems to Teradata FSLDM entities to ensure consistent integration across transactional and analytical layers.• Experience using ERwin Data Modeling tool to design and implement Data Vault 2.0 models (Hubs, Links, Satellites) for enterprise data warehousing projects.