Description
Summary * Over 8 years of IT Industry experience in analysis, design, development, implementation, Test, deployment and documentation of database applications. * Five years of strong data design, data administration and development in SQL Server 7.0/2000, MS SQL Server 2005, MS SQL Server 2008, MS SQL Server 2012 and MS SQL Server 2014. * Extensive experience working in Both OLTP and OLAP Environment of SQL Server. * Extensive experience in database activities like data modeling, database design, development, database creation and maintenance, performance monitoring and tuning, troubleshooting, data transfer, documentation and Data configuration. * Extensively worked on installations, configuration of SQL Server 2000, SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and Visual Studio Team Foundation Server. * Experience in data warehouse (DW) tools like DTS (Data Transformation Services), SSIS Packages, BULK_INSERT, and BCP. * Expertise in Transact-SQL (DDL, DML), views, stored procedures and database triggers. * Extensive knowledge of normalization, relational database management systems. * Skilled in data architecture and data modeling using Erwin. * Skilled in Data modeling and Reverse Engineering using MS Visio. * Experience working on SQL Server 2005 and 2008 Business Intelligence (BI) and used SSIS packages to Extract, Transfer and Populate the Staging Database and populate DW fact tables after cleaning the Staging data. * Experience working on SQL Server 2005 and SQL Server 2008 Business Intelligence BI tool SSRS for reporting and created Report using Data Warehouse (DW). * Good Experience in Writing Test cases, Test Database Application by written query and Stored Procedures. Also created automated test cases to test the database applications. * Good Experience working in development Cycle to Plan, Design, Develop, Test and Deployment of Database Code and Objects.