Alexander Vilkov Email & Phone Number

Москва, Россия

Moscow, Moscow City, Russia

• Разработка ETL пакетов, процедур обработки данных и витрин повышенной сложности в новом хранилище.
• Разработка единого подхода к реализации ETL пакетов с учетом необходимого уровня логирования выполнения и нотификаций ответственных подразделений. Был создан стартовый преднастроенный шаблон SSIS проекта.
• Совместно с архитектором участие в проектировании новой архитектуры хранилища, переход от архитектуры витрин к архитектуре Data Vault 2.0
• Консультирование линейных разработчиков

Moscow, Russian Federation

• Group`s area of responsibility is: in addition to support corporate DWH, took on support all internal company systems which have MS SQL Server as a backend. Additional team members were hired. Before the Group was.
• Total audit of all MS SQL Servers (2008\2012\2014\2014) was made. Set of recommendations and implementation roadmap was prepared;
• Maintenance plans were totally revised and unified;
• Designed and implemented new centralized monitoring system;
• Designed and implemented new universal and scalable system which provides deployment process for non-prod environments. The process includes transformations and data cleansing;
• Implemented code review process for releases regarded to databases;

Moscow, Russian Federation

• Team`s area of responsibility is: supporting existing data marts and developing new ones, developing new ETL packages, Tableau server administration. The main problems I faced into were:
• Data inconsistency thus DWH was discredited;
• It takes huge amount of time to refresh all key marts;
• Lack of monitoring of how full and consistent data marts are;
• General RDMS performance issues;
• Obsolete version of MS SQL Server (2008) did not allow to implement modern data warehousing approaches.Deep analysis and iterative changes to DWH and ETL architecture helped to achieve:

Moscow, Russian Federation

DWH&BI Architect Building DWH from scratch. Implement new strategy of corporate reporting using MS BI stack (SSIS, SSRS, SSAS, Power BI). Using new strategy helped all business units to get actual reports much more faster and easier.SSIS packages building for ETL, integration and reports distribution purposes.

Moscow, Russian Federation

Senior DBAAdministering 60+ SQL servers instances (2008R2, 2012) distributed geographicallyAdministration and optimization of merge replication (600+ subscriptions)Database design, database structure and SP code refactoring. Implement new index strategy from scratch. Locking and blocking management in 500+ concurrency connection environment. Query.