Giorgi Dalakishvili

Talk Python Training Mobile Apps are mobile apps for Android and Apple for the Talk Python Training website. More information can be found at the following link:
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 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. Processed multiple gigabytes of data using SQLite.

Idencia is powerful yet simple to use. It is a quality control data collection system for the manufacturing industry 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 on Android to collect the information following the simple step-by-step process.

Work Done:
I built a cross-platform (Android and iOS) app using MvvmCross (an MVVM library for Xamarin) and integrated several Bluetooth scanner devices by building a Xamarin binding for the native libraries used by the devices. I also implemented direct-image uploads to a Microsoft Azure blob storage from the mobile app. The synchronization between mobile and web apps was optimized by removing extra data.

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

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

The application has almost 100,000 downloads and a 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 on 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 determine whether the exception is caused by a 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 over a million Australian businesses' names, addresses, and phone numbers (and much more).

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. Developed an installer, together with an uninstaller, using Windows Installer XML.

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

I built the application by creating an SQLite database based on a multi-gigabyte CSV file and optimized queries by adding indexes and denormalizing the data. I also developed an installer, together with an 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 the application is not public, so I had to search the Android source code to discover the API and find a way to use the API correctly.

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

The application automatically logs into a user account at Yahoo or ESPN and searches for players to add. After that, it designates a player on the current roster to drop and executes a transaction if the button states 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 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 that ships items from the 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 the shipping cost for the item based on shipping weight and item dimensions.

A website to visualize donations made in Georgia for fighting the COVID-19 virus and supporting the country overall. The front end was built with Highcharts, and data was loaded from Google Sheets.

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

Work Done:
Built pipelines for automatic builds in TeamCity on every commit in the Git repository. Used PowerShell with WebAdminstration and IISAdminstration PowerShell modules to automatically deploy web applications to IIS. Used PowerShell to manage and update local windows services to the latest version.

A demo web app showing how to integrate an online payment gateway.

Online payment gateway iPay.ge is the largest one in Georgia.

Built with ASP.NET Core and C#.

I built a system for SMS-based communication with patients, collecting their responses and tracking message deliveries.

I used Twilio for sending messages, processing incoming messages, and doing phone number lookups.

It's a Blazor-based dashboard for viewing your calendar events, automatically synced to a mobile app that results in an alarm or reminder.

I built custom billing logic for handling Twilio credits usage and mobile apps for iOS and Android with Xamarin and implemented push notifications for syncing new data.