SUNITHA SUBRAMANIAN

Project Name: SAS Migration to Azure (Nov 2025 — Present)

Client: Curry's

Technologies : ADF, Azure Databricks

• Migrated the Pricebook(DWH), Pricebook(Internal and Detailed) and Trading account tracker data from the Network drive input location to Azure Blob input location using ADF pipeline.
• SAS script was developed by the client side in the databricks notebook for transforming the blob input files and placing the transformed files in the Azure Blob output location and have attached this notebook in ADF pipeline.
• Migrated the transformed files using SAS Script from Azure Blob output location to Network drive output location using ADF pipeline.
• Created Web activity for pipeline failure alerts.
• Created Scheduled trigger for the pipeline runs on daily basis.

Project Name: Teradata BO Reports and Sales Transaction (Jan 2025 — Nov 2025)

Client: Curry's

Technologies : ADF, Azure Data Lake,Azure Logic Apps, Azure DevOps, Azure Databricks

• This project focus on migration and modernization of business objects(BO) reports used by the commercial team as a part of the teradata decommissioning.
• Migrated the teradata data which is in Oracle MIS2 database and performed the incremental data logic using Azure Data factory and load it to the Azure Blob Storage.
• Developed the YAML pipelines for loading the data from Blob Storage to Azure Databricks cleaned layer and executed the YAMLs in Azure Databricks notebook.
• Created redacted tables in sql server by redacting few columns for PII information.
• Implement the logic to automate the workflow of Quotes data to sharepoint using Azure Logic apps.
• Created Scheduled trigger for the pipeline runs on daily basis.

Project Name: Services Ingestion to Azure (Jan 2025 — Mar 2025)

Client: Curry's

Technologies : ADF, Azure Data Lake, Azure DevOps, Azure Databricks

• Migrated the data from the synapse to Azure Databricks.
• Developed the YAML to load the synapse data to cleaned delta lake table using incremental method.
• Migrated the 3rd party data source Live Drive from Azure Blob to Databricks Cleaned layer.
• Developed the YAML pipeline for loading the data from Azure Blob to Azure Databricks cleaned layer.

Project Name: Azure Data Migration (Jul 2023 — Jan 2025)

Client Name: Inbrace

Technologies: ADF, Azure Data Lake, Azure Logic Apps, Azure SQL DB, Funnel

• Migrated the Postgres tables to Azure SQL DB using Azure Data Factory.
• Connected various media data sources like GA4, Facebook, TikTok, Bing, YouTube, Instagram etc., in Funnel with dimensions and metrics.
• Created Data Warehouse for Azure Blob Storage with scheduled daily run for all the media data sources.
• Building the Pipelines to load the extracted data reside in the Azure Data Lake Gen2 to Azure SQL DB for Power BI reporting.
• Established the connection string for external data source – MARKETO using REST API and performed the incremental data load logic using data flow and load it to the Azure SQL DB.
• Implemented the logic to automate the workflow of Hulu and Twitch data sources in Azure Logic apps.
• Created Scheduled Trigger for the Pipeline runs on daily basis.

Project Name: Data Migration (Jun 2022 — Jul 2023)

Client Name: MickieSoft

Technologies: ADF, Azure Logic Apps

• Develop ETL processes to extract data from project databases using the connection string.
• Transformed and loaded the data into the centralized reporting database on a daily schedule.
• Creating an ADF pipeline for appending the 3,00,000 source tables from around 900 databases that have same table names into 350 tables.
• Development of SQL queries to append the source tables and copy into the destination databases and trigger the process daily in Azure Logic Apps.