Deepesh Vyas

Background

About Deepesh Vyas

Overall 12 + years of experience in design, development and maintenance of Web based application using Microsoft SQL Server 2014 / 2012 / 2008 R2 / 2008 / 2005 / database versions. • Good hands on experience in defining the database design using normalization techniques, developed and prepared conceptual diagrams, defined data modeling for various complex systems. • Having 10+ years of experience in T-SQL queries using complex joins, views, user defined functions, stored procedures, table variables, CTEs and anchor queries. • Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins, Derived table, Cursors, CTE and Query Writing. • Having 8+ years of experience in design and development of ETL/SSIS packages. Understanding of different ETL transformations and source files data loading. • Having 4 + years of experience in design and development of Enterprise data warehouse applications (EDW) using Microsoft integrated development environment IDE software. • Hands on experience of Star and Snow-Flake schemas, Facts and Dimensions, Slowly changing Dimensions (SCDs) and their types. • Working experience of (ETL) in usage of SSIS Control flow elements, Data flow element and multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Lookup, Merge Join, Slowly changing Dimension, Derived Column. • Strong knowledge of Software Development Life Cycle (SDLC) using Agile and Waterfall methodologies. • 4+ year of experience in Insurance domain -Commercial Lines and different Line Of Business (Workers Compensation, Commercial Auto, Business Owners etc). • Good hands on experience in creating SSIS packages and project deployments using various transformation and extraction components to load data, defined XML Configuration to support various environment deployments and scheduling jobs using SQL Server Agent.