• 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