I'm having 12 years of experience in AngularJS 7|MVC|.Net Core|C#|SQLServer|API|TypeScript|Material Design|WCF|Asp.Net|WebService|Javascript|Material Design|Bootstrap|Jquery|.
I can offer best services in the following fields
Web Development
Web Application development using Angular 7,Angular 6,Angular 2, Web API, TypeScript,Material Design C#
Web Application development using Asp.net,bootstrap,CSS, MVC, WCF,Web Service,JQuery, Knockout, JSON, HTML, Entity Framework & VB.Net Coding.
Provide real-time/Online IT Training on Angualar, .Net Core, MVC & ASP.Net.
SQL SERVER:
• Proficiency in Sql Server 2000 / 2005 / 2008 / 2012 / 2014 / 2019 .
• Experience in Database Development in SQL Server and ORACLE.
• Having good knowledge on writing complex queries, stored procedures, functions, view & triggers inSql Server.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables.
• Experience in Performance Tuning in Sql Server Queries.