Having 9 + years of IT professional experience in SQL/ MSBI (SSIS, SSAS, SSRS) data warehouse, Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments. Experience 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 multiple sources. Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS. Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling. Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, Perfmon and Spotlight. Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions. Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams. Working knowledge in web applications in ASP.NET, C# and web/window services/APIs.
©