15+ years of experience as SQL/Business Intelligence Developer and Data Architect in Production, Development and Staging Environments.
Extensive experience in Installation, Configuration and Updates of SQL Server.
Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle.
Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and Spotlight.
Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.
Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage.
Experienced in programming tasks-Stored Procedures, Triggers, Cursors using SQL Server 2012/2014 with T-SQL.
Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
Extensive experience in Deploying and Consolidating Multiple Instances over Clustering Environment and Remote Installations.
Extensive experience in Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies.
Involved in migration of SSIS Packages 2012 SP1 CU5 and troubleshoot migration issues.
Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
Working knowledge of .Net Framework 3.5 (VB.NET), IIS Web Server.