• Around 7+ years of professional Experience in SQL Server database development and in testing. • Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server Databases, Azure databases and Power BI desktop. • Worked on all phases of business intelligence systems development lifecycle, from requirements gathering to training, implementation and support. • Experience in Creating and executing Complex Transact SQL (T-SQL) Constraints, Joins, Sub queries, Functions, Views and Store Procedures in SSMS. • Experience in developing, monitoring, extracting and transforming data using SSIS, Import Export Wizard, Bulk Insert, Merge and union all. • Experience in report creation using SSRS and created various types of reports like drill down, Parameters, Conditional, Table Calculations, Matrix, Chart and Sub Reports. • Experience in data modelling in creation of entity-relationships, constraints, hirearchies and dataflow of the data, creating and writing DAX, measures and calculated columns. • Experience in Creating Interactive Reports and dashboards using different Visualizations with Filters and Slicers using Power BI Desktop. • Experience in building and publishing, scheduling customized reports from Power BI desktop to Power BI Service. Knowledge with Tableau Desktop and Webfocus. • Demonstrated expertise using ETL tools such as SQL Server Integration Services (SSIS) and Data Transformation Services (DTS). • Good Knowledge of OLAP Cubes, SSAS, Snow Flake, Star schema and its Architecture. • Good Knowledge in MDX Queries, DAX Queries, Blob storages, Cosmos and Azure concepts of Azure Data Lake, Azure Data warehouse, Data bricks, Azure Data Factory. • Experience in creating dashboards in tableau, webfocus using various data sources. • Experience in Query Performance Tuning, debugging and troubleshooting the SQL Scripts in various databases using Indexes, SQL Profiler and Index Tuning Wizard. • Experienced in implementing Agile Scrum methodologies in SDLC and involved in all Scrum events. • Experience in connecting databases from MS SQL Server to Azure SQL Server. • Thorough knowledge on Software Development Life Cycle (SDLC) starting from requirement analysis, design, development, coding, testing and Production/Build. • Experience in Creating and Executing Test Cases, Test Procedures and Test Scenarios. • Experience in System Integration, GUI, UAT, Functional, E2E and Regression Testing. • Exposure to various stages of SDLC, STLC and Defect Life Cycle. • Experience in preparing Test Plan, Test summary and Bug summary Reports. • Experienced in leading offshore team and Onshore (QA/Dev Role). • Expert knowledge of MS office tools such as Word, Excel, PowerPoint, Visio and Outlook. • Having good knowledge in Java, Html5, Java script, UI/UX , XML interfaces languages. • Solid experience working with different disciplines (Dev, Test & PM) and bringing issues to closure. • Well organized, Quick learner and have good analytical, written an