Professional Summary: * Over 10.6 years of experience in Database Design, Data Modeling, Dashboard design and reporting along with T-SQL Development, Integration and Testing for Microsoft, Tesco and other healthcare clients. More than 8 years of experience working in Microsoft projects alone. * Designed and developed ETL and reporting solution independently on multiple projects. * Highly specialized in analyzing and writing complex queries, stored procedure and translating business logic using T- SQL. * Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, etc. involving multiple tables and exception handlers. Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables along with Performance Tuning and Query Optimization. * Expertise in building complex Extract-Transform-Load packages using varied and complex data sources and merging them into a single data model using SQL Server integration services (SSIS) * Extensive knowledge and hands-on experience on designing data warehouse consuming data from Cosmos (big data solution using scope) as well. * Proficient in designing and developing dimensional and tabular model cubes using SSAS * Expertise in designing complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports, Sub reports and AdHoc reports using SQL Server Reporting Services (SSRS). * Dashboard creation using PowerBI desktop and publishing reporting to the cloud.

Highlights:

• Data Quality
• Management
• Quality
• Quality Assurance
• SQL Server Reporting Services
• Applications
• Microsoft
• Ad Hoc Reports
• sheets
• Structured Query Language