• Over 5+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, MSBI, Power BI and Azure services. • Expertise in SQL Server 2019/2016/2014/ Reporting Services (SSRS), SQL Server 2019/2014 Integration Services (SSIS) and in SQL Server 2019/2014 Analysis Services (SSAS) in Business Intelligence (BI). • Experience in OLTP/OLAP environment and Data Warehouse. • Experience in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS, SSAS, Power BI • Expert in creating multiple type of reports using tools like Power BI and SSRS. • Building and publishing POWER BI reports utilizing complex calculated fields, table calculations, filters, parameters. • Experienced in cloud-based data integration and analytics using Azure Data Factory (ADF) for orchestrating data pipelines, Azure SQL Database, Azure Synapse Analytics, and Azure Data Lake Storage (Gen2) for scalable data storage and transformation. • Designed and developed matrix and tabular reports with drill down, drill through using SSRS. • Experience in writing Complex SQL Queries involving multiple tables inner and outer joins. • Worked as MS SQL Server Developer on enterprise and performance critical applications. • Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in MS SQL Server. • Involved in migration of legacy data by creating various SSIS packages • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP • Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS. • Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger. • Expert in creating Power pivots, power query, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries. • Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of the Database using Erwin tool. • Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables. • Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages • Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.…• Over 5+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, MSBI, Power BI and Azure services. • Expertise in SQL Server 2019/2016/2014/ Reporting Services (SSRS), SQL Server 2019/2014 Integration Services (SSIS) and in SQL Server 2019/2014 Analysis Services (SSAS) in Business Intelligence (BI). • Experience in OLTP/OLAP environment and Data Warehouse. • Experience in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS, SSAS, Power BI • Expert in creating multiple type of reports using tools like Power BI and SSRS. • Building and publishing POWER BI reports utilizing complex calculated fields, table calculations, filters, parameters. • Experienced in cloud-based data integration and analytics using Azure Data Factory (ADF) for orchestrating data pipelines, Azure SQL Database, Azure Synapse Analytics, and Azure Data Lake Storage (Gen2) for scalable data storage and transformation. • Designed and developed matrix and tabular reports with drill down, drill through using SSRS. • Experience in writing Complex SQL Queries involving multiple tables inner and outer joins. • Worked as MS SQL Server Developer on enterprise and performance critical applications. • Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in MS SQL Server. • Involved in migration of legacy data by creating various SSIS packages • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP • Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS. • Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger. • Expert in creating Power pivots, power query, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries. • Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of the Database using Erwin tool. • Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables. • Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages • Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.WWWW…