Description
PROFESSIONAL SUMMARY: Having 7+ years of extensive experience as a SQL Developer and BI Developer, Physical & Logical Database Design and SQL server suite of products SSIS, SSRS and SSAS across various Development and Staging Environments. * Experienced in programming tasks, Stored Procedures, Triggers and Cursors using SQL Server 2008 / 2012 with T-SQL. * Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, and E-R Diagrams. * Strong experience in MS SQL Server with Business Intelligence in SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS). * Experienced in writing T-SQL, working on DTS, SSIS, SSRS Data Cleansing, Data Scrubbing and Data Migration. * Experienced in defining Query for generating drill down reports in SSRS and designing stylish report layout. * Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). * Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. * Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets. * Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, DB2 and Oracle. * Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS. * 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.
Accomplishments
Highlights:
Keywords
