09/25/2020 updated
100 % available
SSRS/BI/Power BI Consultant
Ahmadabad, India
India
Bachelor of Engineering (Information Technology)Application Integration ArchitectureMicrosoft Dynamics AXBusiness IntelligenceCustomer Relationship ManagementProfilingDatabasesData FilesCursor (Graphical User Interface Elements)Microsoft Dynamics CRMMicrosoft Dynamics GPEnterprise Resource PlanningFailover ClusteringInternet Information Services (IIS)Problem SolvingMicrosoft Lync
• 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
• 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
Languages
EnglishNative speakerHindiNative speaker