I Have experience on Insurance domain from policy creation, process(with SSIS) and up to policy prints.
Working on Datawarehouse, SSAS to create Cube, Dimensions, Measures, Fact Tables and more.
Having experience to perform day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements, Database Mail, Database Configuration, Query Tuning and performance.
Having experience to install and configured SQL 2016 clustered environment with availability groups.
Configured and supported replication and log shipping in both SQL 2014 and 2016.
Documented processes for installations, clustering, availability group setup, and patching.
Developed data mapping documentation to establish relationships between source and target tables including transformation processes
Created complex SQL views and stored procedures to join multiple tables for contract data interface files.
Having experience in optimize the SQL Query and SSIS packages (2016), migrate SSIS version from lower to latest version.
Having experience to diagnosed job errors like deadlock and timeout issue.
Experience in SSIS for bulk uploading data into Database, File and other platform. Through SSIS, sending Email, Merge data, data copy.
Experience in SSRS, Reporting service, create drill through, drill down, matrix and parameterize reports with Dashboard including Charts.
Expertize for creating Dashboard, reporting in Power BI.