Software Developer in Tbilisi, Georgia

Talk Python Training Mobile Apps are mobile apps for Android and Apple for Talk Python Training website. More information can be found at the link below.
• https://training.talkpython.fm/

The apps allow users to watch their courses online or download them for offline access. They were built with Xamarin.Forms so most of the code is shared between both platforms.

The apps can be downloaded from the links below.
• https://play.google.com/store/apps/details?id=fm.talkpython.training.player
• https://itunes.apple.com/us/app/talk-python-training/id1460583670

Scrubbly cleans a multi-column mailing list against an encrypted (or even non-encrypted/plain text) suppression list.

Work Done:
• Built a cross-platform application for Mac and Windows with Xamarin so that the business logic code was shared between platforms.
• Used SQLite for processing multiple gigabytes of data.

Idencia is a powerful, yet simple to use. It's a quality control data collection system for the manufacturing industry that works in the cloud.

Using the Idencia Management Portal web application, QC Managers define the data collection processes. Production workers then use the Idencia mobile application that runs on any Android device to collect the information following the simple step-by-step process.

Work Done:
• Built a cross-platform (Android and iOS) app by using MvvmCross (an MVVM library for Xamarin).
• Integrated several Bluetooth scanner devices by building Xamarin binding for the native libraries used by the devices.
• Implemented direct-image uploads to Microsoft Azure blob storage from the mobile app.
• Optimized synchronization between mobile and web apps by removing extra data.

With so many cool Android apps, Better Open With saves you the hassle of having to choose only one default app handler when you click a file type, and without having to choose between "only once" and "always"!

Work Done:
• Built the whole application from scratch after being inspired by a Reddit post.

The application has almost 100,000 downloads and 4.2 user rating.

An Android application for Reddit's Today I Learned subreddit.

An SQL Server query execution plan visualizer for LINQPad.

LINQPad allows the user to execute LINQ queries, but it has no way to display the query execution plan so I started an open-source plugin for LINQPad which shows the query execution plan.

The project was featured at the .NET blog in their weekly review of .NET projects.

EntityFramework.Exceptions is a C# library for the Entity Framework Core which makes handling exceptions easier. It allows developers to easily find out whether the exception is caused by unique key constraint violation, null constraint violation, and so on by processing the DbException.

It supports multiple database systems such as SQL Server, PostgreSQL, MySQL, and SQLite

Australia on Disc is an Australia-wide information database providing access to the names, addresses, and phone numbers (and much more!) over 1 million Australian businesses.

Work Done:
• Built the application by creating an SQLite database based on a multi-gigabyte CSV file.
• Optimized queries by adding indexes and denormalizing the data.
• Built an installer together with uninstaller using Windows Installer XML.

NZOD Business covers every corner of New Zealand and all Industries. More than 230,000 business records, and 850,000 residential records.

Work Done:
• Built the application by creating an SQLite database based on a multi-gigabyte CSV file.
• Optimized queries by adding indexes and denormalizing the data.
• Built an installer together with uninstaller using Windows Installer XML.

Notifications Off is an Android application for controlling application notifications in a centralized way. Instead of toggling notifications for applications individually from the settings screen you can turn off notifications for all applications from one place.

The API needed to disable the notification for application is not public so I had to search the Android source code to discover the API and to find a way to use the API correctly.

I developed a console application that scraped information from ESPN and Yahoo and automated process of doing a fantasy football waiver wire adds

The application automatically logs into a user account at Yahoo or ESPN and search for players to add. After that, it designates a player on the current roster to drop and executes a transaction if the button state defines the waiver period as open.

The application used Selenium and Chrome Web Drive to perform browser automation and scrape data.

At one of the companies that I worked for, the parking space was often crowded and it was common for someone to park a car so that it was blocking another car. I built an SQLite database of the car owners and wrote a bot so that you could send a message to it and it would reply with the owner's name and mobile phone.

USA2Georgia is a freight forwarder company which ships items from USA to my home country (which isn't supported by Amazon). They charge $8 per kilo so I decided to write a small extension for amazon.com which calculates shipping cost for the item based on shipping weight and item dimensions.

A website for visualizing donations made in Georgia for fighting the COVID-19 virus and supporting the country overall. It was built with Highcharts.js.

Implemented CI/CD for web applications and for windows services on Windows Servers.

Work Done:
• Built pipelines for automatic builds in Teamcity on every commit in Git repository.
• Used PowerShell together with WebAdminstration and IISAdminstration PowerShell modules for automatic deployment of web applications to IIS
• Used PowerShell for managing local windows services and updating them the latest version