Experience

Netrika

• Russian Federation
• IT System Custom Software Development
• 1 - 100 Employee

• Lead Data Warehouse Developer

  • Jul 2019 - Present

  Responsibilities: - DWH development (DataVault) - Improve Query performance (Postgresql, ClickHouse) - ETL / ELT development (Airflow, python) Responsibilities: - DWH development (DataVault) - Improve Query performance (Postgresql, ClickHouse) - ETL / ELT development (Airflow, python)



Tieto

• Finland
• Information Technology & Services
• 700 & Above Employee

• Senior Database Developer (ETL, DWH)

  • Feb 2018 - Jun 2019

  Responsibilities: - DWH development (DataVault, Kimball) - Improve Query performance - ETL / ELT development (SSIS, biml) - SSRS reports - DB administrator Use: MSSQL, SSIS, biml, SSRS Took part in the international team to build a DWH for Storaenso (www.storaenso.com). Development ELT process and tsql procs, I created design and realized loading process into DataMart, that decreased database lock up to 1-2sec. Support DWH for MSC (Global Container Shipping Company www.msc.com). I investigated loading process, procedures and improved it, the changes reduced the total loading time from 90 to 30 minutes. Show less



Sletat.ru

• Russian Federation
• IT Services and IT Consulting
• 1 - 100 Employee

• Database Administrator

  • Apr 2017 - Feb 2018

  Responsibilities: - review t-sql code (used dbproject, gitflow, bitbacket, git) - support of 12 MSSQL servers, AlwaysOn clusters - monitoring and detection bottlenecks, MSSQL performance tunning, improve query performance - proposal to improve the client software working with database - reports development Use: MSSQL (2014/16), some experience with PostgreSql, SparkSql, HDFS I optimized structure of searching databases and index schema, that reduced the processor load by 25–30%. The search queries execution time in highload time (up to 1000rps) was reduced from 8 seconds to 2.5 seconds (95th percentile). Designed algorithm for screening out low prices for tours, calculation of median and minimal prices by differnt parameters (processing the database of 5 billion records). Show less



Gabbler, startup project

• Backend developer (part-time)

  • Oct 2016 - Jul 2017

  Development backend of web portal for studying English, design database and backend, administration and configuration of unix web server. Developed algorithms: - article/text classification (k-means) - selection of texts according to user's vocabulary Use: C#, ASP.Net, NetCore, Kendo, RabbitMQ, PostgreSql, Nginx Development backend of web portal for studying English, design database and backend, administration and configuration of unix web server. Developed algorithms: - article/text classification (k-means) - selection of texts according to user's vocabulary Use: C#, ASP.Net, NetCore, Kendo, RabbitMQ, PostgreSql, Nginx



Monolit-Info

• Software Development
• 1 - 100 Employee

• Senior SQL developer

  • Jul 2014 - Apr 2017

  Responsibilities: - Development and support modules of the ERP system (Carlsberg / Baltica); - Development business logic in T-SQL, improve query. - Report Development (MS Report) Use: MSSQL (OLTP database more than 2tb.), SSRS, C# The most interesting implemented tasks: - The system of deferred reporting and UI for creating dynamic-user reports. - Development algorithm for optimal placement of products on the shelf / showcase / refrigerator, taking into account more than 20 parameters (processing about 100 million records, analysis of sales by region, priorities, dimension, packaging, and other parameters) Show less



Bank BFA

• Senior Net developer

  • May 2013 - Jun 2014

  Responsibilities: - Development UI software for accounting of exchange transactions of the bank. - Development of services for loading and updating exchange data (MICEX, RTS, CBR, Quik, Reuters, Bloomberg) - Reports development - MSReport. - Support and administering MSSQL. Use: C# (WPF, BLToolkit), MSSQL, SSRS. Responsibilities: - Development UI software for accounting of exchange transactions of the bank. - Development of services for loading and updating exchange data (MICEX, RTS, CBR, Quik, Reuters, Bloomberg) - Reports development - MSReport. - Support and administering MSSQL. Use: C# (WPF, BLToolkit), MSSQL, SSRS.



Pervaya pomoshch, network of drugstores

• Senior Developer

  • Aug 2012 - May 2013

  Responsibilities: - Distribution tasks within the team (3 developers). - Support and development of cash register software - Administration of MSSQL servers - Development DWH, custom reports. Use: C#, Delphi, PHP, APEX(Оracle), MSSQL, OLAP(SSAS), SSRS. Realized integration the cash register software with “spaibo” loyalty program from Sberbank. Designed and created a data warehouse and OLAP cube. Developed interactive web reports on the APEX server (Oracle) Responsibilities: - Distribution tasks within the team (3 developers). - Support and development of cash register software - Administration of MSSQL servers - Development DWH, custom reports. Use: C#, Delphi, PHP, APEX(Оracle), MSSQL, OLAP(SSAS), SSRS. Realized integration the cash register software with “spaibo” loyalty program from Sberbank. Designed and created a data warehouse and OLAP cube. Developed interactive web reports on the APEX server (Oracle)



TKB Investment Partners

• Russian Federation
• Investment Management
• 1 - 100 Employee

• Senior Software Developer

  • Dec 2009 - Aug 2012

  Development and support of existing software (Front office) for the asset management company. Development client server applications, implementation loaders from various sources. Administering MSSQL 2008(mirroring), performance tunning. Use: Delphi, MSSQL, SSIS, SSRS Development and support of existing software (Front office) for the asset management company. Development client server applications, implementation loaders from various sources. Administering MSSQL 2008(mirroring), performance tunning. Use: Delphi, MSSQL, SSIS, SSRS



Geonavigator

• United States
• Maritime
• 1 - 100 Employee

• Senior SW developer / DB consultant(part-time)

  • Feb 2008 - Mar 2011

  Development geo-information systems, monitoring systems, client server applications, implementing server logic in stored procs. Support and development system "Yedinaya dezhurnaya sluzhba St. Petersburga", Administration MSSQL Server 2000. Development database for a regional forest management accounting system, implementation client application and took part in the implementation it in goverment of Irkutsk region. Use: Delphi, GIS (Zulu), WPS, UmnMapServer, MSSQL Development geo-information systems, monitoring systems, client server applications, implementing server logic in stored procs. Support and development system "Yedinaya dezhurnaya sluzhba St. Petersburga", Administration MSSQL Server 2000. Development database for a regional forest management accounting system, implementation client application and took part in the implementation it in goverment of Irkutsk region. Use: Delphi, GIS (Zulu), WPS, UmnMapServer, MSSQL



Bank SoftServices (BSS)

• Senior Developer

  • Mar 2009 - Nov 2009

  Development software for banks (web + backend, money transfer system). Support existing software. Use: BsScript/Delphi, Js, Html, MSSQL, Oracle, Sybase. Development software for banks (web + backend, money transfer system). Support existing software. Use: BsScript/Delphi, Js, Html, MSSQL, Oracle, Sybase.



Institute of Law and Economics FSIN Russia

• SW Developer

  • Aug 2003 - Feb 2008

  Development software, administration MS SQL Server Developed systems: - system "Kadry" - system "Uchet tekhnicheskikh sredstv i raskhodnykh materialov" Use: Delphi, PHP, MSSQL Development software, administration MS SQL Server Developed systems: - system "Kadry" - system "Uchet tekhnicheskikh sredstv i raskhodnykh materialov" Use: Delphi, PHP, MSSQL