Implementation of a project management system

● Participated in two projects on the implementation of project management systems based on MS SharePoint, MS Project Server, SSAS, PowerBI, SSRS, Turbo Planner. ● In one I participated as a project manager, and in the other as a member of the implementation team.

Gazstroyprom

● MS SQL database administration: setting up backups, identifying sources of degradation of server performance and their localization, tuning server performance for a specific environment, query optimization. ● Configuring and maintaining fault tolerance of the DBMS using cluster technologies (AlwaysON, SQL Server Failover Cluster). ● Maintenance of all types of data replication. ● Setting up import and export of data from various sources through ETL systems (MS SQL Server Integration Services). ● Resource Governor setting. ● Administering the PowerBI Report Server, including setting up Kerberos authentication and scheduled report updates. ● Develop PowerBI Reports. ● Administration of MS SAS analytics servers and MS SharePoint farms. ● MS SQL database administration: setting up backups, identifying sources of degradation of server performance and their localization, tuning server performance for a specific environment, query optimization. ● Configuring and maintaining fault tolerance of the DBMS using cluster technologies (AlwaysON, SQL Server Failover Cluster). ● Maintenance of all types of data replication. ● Setting up the import and export of data from various sources through ETL systems (MS SQL Server Integration Services). ● Resource Governor setting. ● Administering the PowerBI Report Server, including setting up Kerberos authentication and scheduled report updates. ● Administration of MS SAS analytics servers and MS SharePoint farms. ● Various reports development.

Gazprom dobycha Noyabr'sk

● Front-End and Back-End support for Project Management Information System (PMIS) based on MS Project Server 2010/2013 (500 users). ● Configure, monitor and troubleshoot the global enterprise directory (Active Directory), MS Exchange Server 2010/2013 mail server (5 AD sites, 2200 users), Windows network services: DNS, DHCP. ● Monitoring and troubleshooting of database servers: MS SQL Server (SSIS, SSAS, SSRS) and Oracle (including search (using Profiler and Performance Monitor)), VMware virtual environment (ESXi, VSphere). ● Formation of recommendations to the developers of Dynamics Ax on the creation of optimal SQL queries. ● Support as a 3rd line of the following systems: Nordis, Infotech, Client-Bank (BSS), MS Dynamics Ax (300 users), etc. ● Configure and troubleshoot server operating systems of the Windows and Linux family (including MySQL database replication, LAMP configuration). ● Creating a portal based on MS SharePoint Server 2010.