Description
Summary: * Over Twenty years of IT industry experience with MS SQL Server 97/2000/2005/2008, SSIS/SSRS/SSAS as SQL developer. * Expertise in scripting T-SQL queries, complex stored procedures, User Defined Functions (UDF), and Database Triggers. * Experience with complete SDLC, which includes requirement gathering, analysis, design, development, maintenance and implementation. Experience with Agile and Waterfall methodologies in approach to project development. * Extensive experience in Performance Monitoring and Tuning of SQL statements, Sub Queries, Joins, Cursors and Functions. Extensive experience in the development of backup and recovery process plans. * Experience in Data Modeling (Logical and Physical Design of Databases) using Visio/Erwin, Normalization and building Referential Integrity Constraints. * Experience in Data Modeling, Database Design, Programming and Implementation of Client-Server Applications and Database systems using MS SQL 97/2000/2005/2008 for both OLTP (Batch Processing, Online Processing) and Business Intelligence (SSIS, SSAS, SSRS) applications. * Expert in working with BIDS. * Experience using SQL Server DTS and SSIS for ETL process and constructing packages for deployment. * Expertise in developing reports using SQL Server Reporting Services and MS Excel Spreadsheets. Over twenty years of experience scripting and automation development.
Accomplishments
Highlights:
Job Skills
Keywords
