Profile:---------A perceptive and result driven professional with 10+ years of IT experience on client analysis and independently handle ASP.net web application with MS SQL Server (database design and development with business intelligence suites).Knowledge, Skills and Abilities:---------------------------------------------* Good working knowledge on SDLC for designing, coding, testing, deploying, maintaining and supporting application software in dot net technology and… Show more Profile:---------A perceptive and result driven professional with 10+ years of IT experience on client analysis and independently handle ASP.net web application with MS SQL Server (database design and development with business intelligence suites).Knowledge, Skills and Abilities:---------------------------------------------* Good working knowledge on SDLC for designing, coding, testing, deploying, maintaining and supporting application software in dot net technology and sql server. Strong in Application Support and Production support roles.* Business process analysis and redesign.* Full life cycle planning, implementation and support systems in a complex environment.* Set and manage priorities and resources.* Demonstrated ability to relate to all levels of the user community – from end users, to senior Management.Areas of professional expertise:MS SQL Server (2000/2005/2008R2/2012):T-SQL coding and testing: Writing complex queries, complex stored procedure, index, views, user defined function, trigger, cursors, dynamic SQL, query optimization, creating and scheduling Job, Controlling the User Privileges, Monitoring the Security and Audit, Optimization, Data integrity and Statistics by using SQL Profiler, Solving real time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.SSRS: Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies, Roles and Permissions, Schedules, Subscriptions and delivery, History report, Cached report, Snapshot, Programming on ASP.NET & VB.NET/ C# for exporting report into pdf/word/excel from web application.SSIS:Designing, Developing and Testing of the ETL strategy to populate the data from various source systems feeds using SSIS. Building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models. Show less