laallthings.blogg.se - Master database corruption in sql server

Assisted wif automation of manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.Proficient in Performance Tuning/Query optimization using indexes.

Writing heavy stored procedures, Audit triggers views, creating SQL scripts for data loads and Upgrades for data migrations and data validations.

Programming in SQL Server - Using teh stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs) Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.Using Normalization and De-Normalization techniques.Expert in data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principals.Extensive experience in Using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading.7+ years of experience in Data modeling, database design, Programming, Development and Implementation of Client - Server Applications & Database systems using MS SQL Server 2012/2008/2005.