Provide database support to two web apps that are currentyl in development phase Persivia and Carespace EHR(Electronic healthcare record) which are used for healthcare providers. Investigation and Validation of Clients issue related to Data(DWH) Monitor ETL Jobs and Dashborads Identify any issues related to database performance and provide corrective measures. Provide security Login at Database level. SQL Profiler. Creating SQL jobs. Taking Backups and Restoring data.
ata Integration. Worked on Technical Operational Issues. Imports Data for Different Offices acquired by MTBC. Query optimization. Creating Reports using SSRS and Power BI. Responsible of Data availability on Production server for end user. Designed SSIS Packages to extract data from various heterogeneous data sources such as Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS. Good knowledge of Data ware house(Dims,facts,star schema etc) Good knowledge of Transparent Data Encryption Good knowledge of Change Data Capture(CDC)