Sreekar B S

• Migration of on premise data (Oracle) to Azure Synapse using Azure Data Factory(ADF V2 )
• Having experience in writing simple and complex queries using CTE and ranking unction.
• Experience in setting up a Git code repository for azure data factory development.
• Good knowledge bitbucket, creating feature branches, pull requests to merge implemented changes with the collaboration branch.
• Worked with API and build a automated pipelines which does not involve any manual interventions.
• Worked on Varicent SPM tool,created tables and wrote
• the import queries.

• Been a crucial part in the Consumption layer, which is the same for all the different products of the project.
• Hands on experience implementing Azure data services solutions in support of the analytics services solution, including SQL Database, Azure Synapse (Data Warehouse),Data Factory, Data Lake, Logic Apps. Hand on expert in visualization and Power BI platform.
• Ingesting data from different sources into EDL and applying hive/hadoop queries on the data ingested to get appropriate data and load it into Azure blob storage using Talend ETL tool.
• Migrating the transformed data placed in Azure storage account into the Azure SQL Data warehouse, Azure Database and Azure Data Lake Storage.
• Created the ADF generic template to handle multiple products data processing into the respective tables and folders.
• Written Views,Stored Procedures and Dynamic expressions wherever it is required.
• Configured an event trigger to avoid manual intervention, considering Blob created as an event.
• Involved in writing Technical Specification Documents.
• Involved in gathering, understanding and validating the project specifications.

Project Name: End to End Reconciliation Dashboard

Responsibilities

• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generate computed columns in Power BI.
• Involved in writing Technical Specification Documents, gathering, understanding and validating the project specifications.