Description
Around 2.5 years of experience as a Database Developer in Database Design, Development & Business Intelligence of Microsoft SQL Server 2008 R2 in development, test & production environments. Involved in successful enhancement and development of applications. Excellent experience in Extracting, Transforming & Loading (ETL) data from Excel, Flat File to MS SQL Server by using MSBI tools (SSIS service). Involved in creating & implementing business logic of database objects such as tables, views, functions, stored procedures, cursors to handle database automation task with high standards of data integrity, consistency & efficiency. Implementation & delivery of BI platform solutions to develop and deploy ETL and reporting Dashboard on SQL Server 2008 R2 using SSIS. SSIS: -Worked extensively on Data Extraction, Transformation & loading from different data sources using SSIS. -Experience in Designing & Deployment of SSIS packages for end-user using MS-Excel, Flat Files System. -Excellent knowledge of using Variables & Expressions in Packages SQL SERVER: -Worked on SQL Server 2005, 2008 R2. - Excellent knowledge in creating Views, Stored Procedures, SQL Jobs to facilitate efficient Data.