← В ленту

Портфолио

Automated system of control and metering of energy resources

Design and implement analysis and reporting solution as part of an automated system of control and metering of energy resources. Design and implementation of DataWarehouse. Design and implementation of OLAP multidimensional cubes with server-side code in MDX.

EDMS Tessa-SAP ERP Integration

Development of application providing 2-way interation between SAP ERP and Tessa PostgreSQL database. Application implemented in C# (Visual Studio, SAP .NET Connector - NCo 3.0, ADO.NET Data Provider for PostgreSQL - npgsql).

Antenna test-bench data acquisition and analysis solution

Design and Implementation of ELT-solution: data acquisition from LabVIEW in XML, transform and load into target DWH. PostgreSQL source database data transfer and transform into target DWH. Design and implementation of DataWarehouse. Design and implementation of OLAP multidimensional cubes with server-side code in MDX.

Скиллы

Database design
DBMS server-side programming
DWH design
OLAP solutions design
Performance Tuning and Diagnostics

Опыт работы

Lead Database Developer
с 11.2021 - По настоящий момент |Investment Broker backend and frontend databases development
SQL Server, Visual Studio, SQL Server Data Tools, Transact-SQL, Service Broker
Design and implementation of server-side code and structures: tables, views, stored procs and functions, triggers, Service Broker objects, etc
Lead Developer
11.2015 - 11.2021 |Transceiver Antenna Test-bench data acquisition and analysis solution development
SQL Server, Visual Studio, SQL Server Data Tools, Transact-SQL, MDX, SQL Server database project, SQL Server Analysis Services project, XML, LabVIEW, PostgreSQL
Design and Implementation of ELT-solution: data acquisition from LabVIEW in XML, transform and load into target DWH. PostgreSQL source database data transfer and transform into target DWH. Design and implementation of DataWarehouse. Design and implementation of OLAP multidimensional cubes with server-side code in MDX.

Образование

Mathematical modeling, numerical methods and software solutions (PhD)
1997 - 2001
Ufa State Aviation Technical University
CAD/CAE (Магистр)
1995 - 1997
Ufa State Aviation Technical University
CAD/CAE (Бакалавр)
1991 - 1995
Ufa State Aviation Technical University

Языки

АнглийскийБазовыйРусскийРодной