Ashish Mohan

 Database creation DDL, DML, DCL, database tuning, SQL tuning, performance planning.
 Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
 Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
 Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
 Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
 Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
 Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
 Creating data blending in case of merging two different datasets using Tableau
 Created Datasets in T-SQL, stored procedures for SSRS.
 Developed Excel Pow