• Maintain and evolve the internally built portfolio management reporting system which is a key insight and reporting tool for the investments team, traders and senior management.• Maintain and evolve the back-office system, a heavy-weight IT processing system that handles position keeping, clearance, settlement, etc• Develop reports using iReports, QlikView, SSRS• Develop databases/forms/reports using Microsoft Access 2007• Developed applications, Delphi 7 & SQL2000, Visual… Show more • Maintain and evolve the internally built portfolio management reporting system which is a key insight and reporting tool for the investments team, traders and senior management.• Maintain and evolve the back-office system, a heavy-weight IT processing system that handles position keeping, clearance, settlement, etc• Develop reports using iReports, QlikView, SSRS• Develop databases/forms/reports using Microsoft Access 2007• Developed applications, Delphi 7 & SQL2000, Visual Studio & SQL 2005-2012• Develop a bunch of internally built ASP. NET / MVC / C# applications• Data warehousing (SSIS) and Multidimensional Modelling (SSAS). • Writing and tuning SQL queries, stored procedures, functions, tables, views, etc.• Performance tuning (Database Engine Tuning Advisor, DMVs, SQL Server Profiler)• Monitoring and maintaining of data integrity and the management of all automated processes.• Load XML data into existing databases (SSIS).• Designing and writing ETL to load data from external systems (Moscow Exchange and National Depository Centre) into data warehouse (SSIS).• Data warehousing and Multidimensional Modelling (SSIS + SSAS).• Import data from online trading and news systems, i.e. Reuters• Excel Data Analysis: Sort, Filter, PivotTables, Formulas. Some VBA code.• Technical support for the company's end users and customers.• Troubleshoot, analyse and enhance existing computer systems.• Additional responsibilities: manage and monitor network services, recommend and acquire equipment replacements and upgrades, maintain an inventory of all network devices, integrate new technologies into the existing environment, perform routine audits of systems and software, troubleshoot any reported problems.Environment:MS SQL Server 2000/2005/2012, MS SQL Server Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), MS Excel, Business Intelligence Development Studio, Visual Studio 2012 Show less

Develop and maintain the company IT infrastructure: databases, servers and network equipment. Windows Servers 2003/2008 administration, SQL Server 2005/2008R2 maintenance and administration (DBA), report writing (SSRS, QlikView), OLAP cubes (SSAS), ASP.NET / MVC / C# development, XML data import (SSIS).

As a member of the team that created the first in Russia service providing for general public a realtime aviation timetable (the system known as “Polet-Sirena”)Main responsibilities: creation, development and maintenance of the internet projects polets.ru,backup and restore data on the main servers.

As a member of the team that created a precursor of automatic transport system supportingreal-time timetable service in Civil Aviation in Russia.