Software Developer

• Feb 2021 - Present

Teacher Assistant

• Sep 2019 - Dec 2020

Taught the following disciplines: - Database Principles. Topics covered: SQL, the internals of MS SQL Server, basics of queries' performance optimization. - Introduction to Computer Science on the example of the Python programming language. Topics covered: branching & iteration, string manipulation, decomposition, abstraction, functions, arrays & lists, testing & debugging, handling exceptions, input & output operations, an overview of OOP. - Introduction to iOS Application Development. Topics covered: Swift, Xcode IDE, UI (Storyboard, XIB, SwiftUI), UIViewController lifecycle, segues, MVC, multithreading, URLSession, serialization & deserialization of JSON, UITableView, persistence technologies (Core Data, UserDefaults), alerts, git & Github, Cocoapods. Show less

Software Developer

• Jun 2017 - Dec 2020

izipoint: Self-store purchase system- Designed and developed the core parts of a real-time system of smart vending machines that are controlled by a mobile application and connected to a central web server. Specifically, REST API, software that controls the hardware of a vending machine, iOS & Android mobile applications.- Implemented unit and integration tests for the core functionality.- Created UI tests for mobile applications.- Added Continuous Integration & Delivery pipelines for web and mobile applications.- Added support for Apple Pay & Google Pay.- Leveraged knowledge in full-stack web & Windows Services & mobile applications development, ASP.NET Core, Entity Framework Core, Web Socket, SignalR, C#, jQuery, Knockout, React, JavaScript, Bootstrap, HTML, CSS, Azure SQL Database, Java, Swift, Git, MS Visual Studio 2017, Xcode, Android Studio, MS Visual Studio Team Services (VSTS), Azure Cloud Computing Platform.TMS: Translation Management System- Decreased the CPU consumption by 40%, memory consumption by 30%, queries’ duration by 30% of a highly active primary database (more than 2 TB in size, millions of transactions per day, 32 vCores, 750 GB RAM) by designing and implementing the core parts of a reporting solution with near real-time updates (5 minutes delay).- Improved indexes and statistics maintenance strategies that reduced the duration of weekly maintenance by 50%, lessened the overall fragmentation rate of indexes.- Optimized a lot of long-running stored procedures up to 10000 times.- Leveraged knowledge in relational database design & optimization, MS SQL Server 2016, Azure SQL Database, MS SQL Server’s Change Data Capture & Query Store, SQL (T-SQL), SSIS, Git, MS Visual Studio 2017-2019, Azure DevOps. Show less

Software Developer

• Sep 2016 - May 2017

OpenSport: A system for facilitating the search for sports and recreational establishments, as well as obtaining information on the additional services provided and the rating.- Implemented a management view of establishments where a user can add, edit or remove information about various services (description, working hours, instructors availability, GPS coordinates, pictures, etc.), assign roles such as a moderator or a company representative, publish news via a web interface.- Created a REST API for mobile applications that allows receiving all necessary information about facilities in a convenient format, performing complex filtration (by working hours, provided services, categories, price, description, name, etc.)- Added a possibility to select and add multiple photos of a sports establishment via iOS mobile application.- Leveraged knowledge in full-stack web development, ASP.NET Core, Entity Framework Core, C#, jQuery, JavaScript, Bootstrap, HTML, CSS, MS SQL Server 2014, PostgreSQL, Swift, Git, MS Visual Studio 2015, Xcode.Participated in 5+ short-term projects as a Full-Stack .NET Developer.- Leveraged knowledge in full-stack web development, ASP.NET MVC 5/Core, WCF, Entity Framework, C#, jQuery, Knockout, JavaScript, Bootstrap, HTML, CSS, MS SQL Server 2014, SSIS, SSRS, Umbraco, Git, MS Visual Studio 2015. Show less

Junior Software Developer

• May 2016 - Aug 2016

A module of material balance and tracking flows for the Ignition platform.- Implemented graphical components and algorithms for detecting errors in tracking flows and restoring missing measured masses of flows. - Leveraged knowledge in Java SE, Maven, IntelliJ IDEA.Payminator: Electronic Payment System.- Optimized stored procedures and database calls related to notifications' service. - Leveraged knowledge in C#, WCF, MS SQL Server 2014, MS Visual Studio 2015.