Profileimage by Kalpesh Dangar SSRS/BI/Power BI Consultant from Ahmadabad

Kalpesh Dangar

available

Last update: 25.09.2020

SSRS/BI/Power BI Consultant

Graduation: Bachelor of Engineering (Information Technology)
Hourly-/Daily rates: show
Languages: English (Native or Bilingual) | Hindi (Native or Bilingual)

Attachments

Profile.docx

Skills

• Currently, Migration and Upgrade of Microsoft Dynamics AX 2009(ERP), Microsoft Dynamics CRM 2011 database from Microsoft SQL Server 2008 R2 to Microsoft SQL Server 2012.
• Installation, Configure and Managing Microsoft SQL Server 2012 on Microsoft Windows Server 2012(Always High Availability Group and Failover Clustering ),Microsoft SQL Server 2008 R2 on Microsoft Windows Server 2008(Failover Clustering).
• Currently, Managing and handling Microsoft Dynamics AX 2009(ERP),Microsoft Dynamics CRM 2011 and Microsoft SharePoint 2010/2013 Database and Performance Tuning.
• Currently, Managing, Maintain, Performance Tuning and all related database activity of 35 database and 10 SQL server instance.
• Installation, Configuration and Upgrade Microsoft SQL Server 2005/2008 R2/2012 and Microsoft SQL Server Reporting Service.
• Currently, Create and Manage SSRS Report for Microsoft Dynamics CRM 2011,Pro fx Practice Management ,PaperSave, Microsoft Dynamics AX 2009(ERP), Microsoft SharePoint 2010/2013, Microsoft Dynamics GP 2010,Microsoft Lync 2010/2013.
• Create and execution of Stored Procedure, trigger, Schedule Job, Maintenance Plan Cursor and Function.
• Application Integration using of Microsoft SQL Server 2005/2008/2008 R2/2012 and Oracle.
• Backup and Restore Process.
• Database related Job Creation and Schedule Plan.
• Perform regular maintenance including index optimization, consistency checks, and data file and transaction log size monitoring using built-in tools, custom written T-SQL scripts, SQL Agent Jobs, and Database Mail.
• Troubleshoot problems by using SQL Server profiler, SQL Server Performance Dashboard Reports, Activity Monitor.
• Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
• Manage Microsoft SQL Server Report Manager.
• Create all type of Views, Chart ,Dashboards ,Tabular, Matrixes Report in SQL Server Report .Builder 2.0,3.0 and SQL Server Business intelligence Development Studio 2005/2008/2010

Project history

Ankit

Local Availability

Only available in these countries: India
Temporal
Profileimage by Kalpesh Dangar SSRS/BI/Power BI Consultant from Ahmadabad SSRS/BI/Power BI Consultant
Register