Adithya Oresam Veetil

Project 1 : Yale Health Datamart

February 2025 - May 2025

• Privately secured Azure resources to access the PHI-related data from private endpoints only.
• Ingested Databricks into the client's private VNet.
• SCIM configuration for Databricks to access AD groups.
• Design ADF ETL pipelines to access on-prem data and move delta bronze and silver layer tables.
• Set up the Unity catalog to collaborate on data with other projects.
• Design SCD Type 1 Notebooks.

Project 2: Schindler SSOT (Single Source of Truth)

Oct 2022- Dec 2024

• Designed and developed frameworks for data ingestion, data processing, and data transformation.
• Conducted business analysis and developed ETL code and scripts to meet technical specifications and business requirements.
• Built an ETL framework in Microsoft Fabric, including the creation of the Fabric Warehouse, Lakehouse, and shortcuts for streamlined access.
• Created indexes, stored procedures, common table expressions (CTEs), and external tables to efficiently solve complex requirements.
• Developed Azure Databricks (ADB) notebooks using PySpark and Spark SQL for data transformation and aggregation from multiple sources.
• Created and managed Delta Lake tables, and implemented data loading processes using PySpark notebooks.
• Designed Azure Data Factory (ADF) pipelines to extract data from OData and SharePoint into the Azure Cloud environment.
• I wrote PySpark scripts to transform and load data from the staging layer to the curated layer.
• Delivered curated tables to the Power BI Reporting Team, ensuring alignment with business requirements.
• Developed a generic and reusable framework to handle Slowly Changing Dimensions (SCD Types 1 and 2), and fact tables.
• Developed polling-based dataset refresh ADF pipelines that trigger API refresh once the dependent tables of that report are loaded.
• Successfully resolved performance issues by identifying and addressing root causes.
• Good Experience in Agile Methodology.
• Assisted developers in analysing code and resolving issues effectively and promptly.

Project 3: Citi Bank: Heat Map Survey and Accounting standardization (POC)

July 2021- Sep 2022

• Gathering requirements from business analysts and analyzing requirements.
• Conducting surveys to gather accounting rules and data sources of respective apps and hand it over to DWA to designing standardized data models
• Built POC pipelines to extract and ingest data to ADLS, transform in synapse procedure and load to synapse warehouse following Mendelian Architecture.
• Preparing business insight visuals in Power BI desktop