Used log shipping for synchronization of databases.Monitored & modified Performance using execution plans and Index tuning.Expertise in SQL server reporting Services (SSRS) & SSAS (Building OLAP cubes). Rebuilding indexes at regular intervals for better performance.Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).Created the SSIS /DTS packages and scheduled them using SQL Server Agent.Worked on SQL Server Reporting Services (SSRS), Created Tabular, Matrix, Drill Down, Bar Chart, Pie Chart reports to analyze critical data in SSRS. Migration of databases from SQL Server 2008 R2 to SQL Server 2012for various environments.Produced custom, on demand BI reports for the Business Development and Content Acquisitions Team.Used advanced calculations, Custom Visuals and Groups Creation using MS Power BI Desktop.Creating calculated measures and columns with DAX in MS Power BI Desktop.Developing Power BI reports & effective dashboards after gathering and translating end user.Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.Extensively created visualization dashboards for the claims.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |