Extensively worked with SQL Server and T-SQL in constructing DDL/DML triggers, tables, user defined functions, views, indexes, Stored Procedures, user profiles, relational database models, cursors, Common Table Expression CTE’s, data dictionaries, and data integrity.
Knowledge and expertise in Duck Creek Policy Author Manuscripts configuration, transforms XML data into database using Extract mapper and claims data using SSIS package.
Identify and resolve database performance issues, database capacity issues and other distributed data issues.
Knowledge and experience in Azure Data factory.
Experience with Agile Methodology for software and solutions development. (JIRA and Rally App)
Worked with several offshore and onsite teams in resolving the application issues.
Used GitHub is an increasingly popular programming resource used for code sharing.
Technology : - SQL Server 2016, SSIS, Duck Creek Data Insight and Azure Data Factory.