• Interacting with business and as per requirements resolving the Issues& Bugs.• Responsible for Bug Fixing in the area of Identification.• Preparing metadata for PPG framework and load data using ADF.• Involved in designing, testing, deploying, scheduling for ADF pipelines• Respond to issues raised by business users within expected SLA • Creating ADB notebooks for transformation and run into ADF Pipeline.• Creating tabular cube and created measures using Dax… Show more • Interacting with business and as per requirements resolving the Issues& Bugs.• Responsible for Bug Fixing in the area of Identification.• Preparing metadata for PPG framework and load data using ADF.• Involved in designing, testing, deploying, scheduling for ADF pipelines• Respond to issues raised by business users within expected SLA • Creating ADB notebooks for transformation and run into ADF Pipeline.• Creating tabular cube and created measures using Dax queries.• Creating PowerBI reports and deploying and scheduling reports.• Creating Delta tables in Azure databricks using pyspark Show less

Responsibilities:• Created PowerBI and SSRS Reports.• Created the Smart Board Dashboards Using PowerBI Desktop With R.• Created Tables and Stored rocs, Views in Sqlserver 2016• Deploying and Scheduling the ETL Packages in Development Server• Involved in designing, testing, deploying, scheduling for SSIS Packages.• Involved in creating ADF Pipelines for data ingestion from Azure SQL Server and .CSV files to Azure SQL DWH.• Involved in moving files from SFTP to Blob… Show more Responsibilities:• Created PowerBI and SSRS Reports.• Created the Smart Board Dashboards Using PowerBI Desktop With R.• Created Tables and Stored rocs, Views in Sqlserver 2016• Deploying and Scheduling the ETL Packages in Development Server• Involved in designing, testing, deploying, scheduling for SSIS Packages.• Involved in creating ADF Pipelines for data ingestion from Azure SQL Server and .CSV files to Azure SQL DWH.• Involved in moving files from SFTP to Blob Storage and Blob to SQL DWH using Polybase scripts.• Involved in creating ADF Custom activity to validate different type format source files.• Involved in sending ADF alerts using C# code.• Involved in creating Azure Analysis tabular cube and DAX queries• Involved in creating Power BI reports and Analysis.• Involved in creating Usql scripts for validating data. Show less

• Designed SSIS packages using Neudesic ETL Framework in SQL Server 2016 Integration services.• Created Tables and Stored rocs, Views in Sqlserver 2016• Created Olap Cubes and Relations based on Client Requirement.• Created Row Level Security in Cube• Deploying and Scheduling the ETL Packages in Development Server• Involved in designing, testing, deploying, scheduling for SSIS Packages.• Loaded data between Different data Sources like Excel, Oracle and… Show more • Designed SSIS packages using Neudesic ETL Framework in SQL Server 2016 Integration services.• Created Tables and Stored rocs, Views in Sqlserver 2016• Created Olap Cubes and Relations based on Client Requirement.• Created Row Level Security in Cube• Deploying and Scheduling the ETL Packages in Development Server• Involved in designing, testing, deploying, scheduling for SSIS Packages.• Loaded data between Different data Sources like Excel, Oracle and Sqlserver.• Using Tabular Cubes, Created PowerBI Reports.• Created the Smart Board dashboards Using PowerBI Desktop With R.• Publishing and sharing reports in PowerBi server. Show less

• Extensively working in Data Extraction, Transformation and Loading from source to target system using SQL Server 2008 Integration Services.• Importing Source/Target tables from the respective databases by using Execute SQL Task using Control Tasks in SQL Server 2008 Integration services.• Created Transformations and Mappings using Data Flow Tasks. Also, created Event Handlers for the Packages Using Event Handler Tab.• Extensively used Derive Column, Data Conversion, Conditional… Show more • Extensively working in Data Extraction, Transformation and Loading from source to target system using SQL Server 2008 Integration Services.• Importing Source/Target tables from the respective databases by using Execute SQL Task using Control Tasks in SQL Server 2008 Integration services.• Created Transformations and Mappings using Data Flow Tasks. Also, created Event Handlers for the Packages Using Event Handler Tab.• Extensively used Derive Column, Data Conversion, Conditional Split and Aggregate Transformations.• Scheduled the ETL Package (Daily) Using SQL Server 2008 Management Studio.• Writing stored procedures which meet the requirements.• Understand Report Specification document and designing the reports based on Report Specification document which meets the client requirements.• Involving in designing, testing, deploying, scheduling for SSIS Packages.• Involving in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.Involved in creating groups and measures, KPIs. Show less