Scroll To View More
Kirill Chilingarashvili, SQL Developer in Tbilisi, Georgia
Kirill Chilingarashvili

SQL Developer in Tbilisi, Georgia

Member since December 30, 2015
Kirill is full-stack developer with expert knowledge of C#, JavaScript, and TSQL languages. He has previously worked as a team leader, software architect, CTO, consultant, and developer on a number of projects for over 12 years. He cares about the projects he works on, and comes up with ideas and ways to achieve best possible outcome by communicating with domain experts and learning the project's domain himself.
Kirill is now available for hire

Portfolio

  • Investorpark
    C#, JavaScript, AngularJS, Node.js, MongoDB, RabbitMQ, Azure Service Bus...
  • MyGPS
    Silverlight, .NET, Micro .NET, WCF, REST, OData, SQL CLR, SOA, WPF...
  • Saatec
    JavaScript, C#, TSQL, ASP.NET, WPF, WCF, Silverlight

Experience

  • SQL, 14 years
  • C#, 14 years
  • JavaScript, 10 years
  • Windows Presentation Foundation (WPF), 8 years
  • REST, 4 years
  • Docker, 2 years
Tbilisi, Georgia

Availability

Part-time

Preferred Environment

Windows and Visual Studio

The most amazing...

...thing I've written is a framework for writing domain objects, communication workflows, and their read-side representations through event-driven architecture.

Employment

  • Software Architect

    2014 - 2016
    Investorpark
    • Created product architecture.
    Technologies: C#, JavaScript, AngularJS, Node.js, MongoDB, RabbitMQ, Azure Service Bus, NoSQL, Grunt, Karma, TeamCity, Octopus Deploy, CQRS, ES, DDD
  • IT Director

    2013 - 2014
    MyGPS
    • Created product architecture.
    Technologies: Silverlight, .NET, Micro .NET, WCF, REST, OData, SQL CLR, SOA, WPF, Objective-C, NoSQL, Event-driven Architecture, AngularJS, Spatial Data, Dijkstra Routing, Data Analytics, PostgreSQL
  • Senior Software Developer

    2006 - 2013
    Saatec
    • Worked on various products.
    Technologies: JavaScript, C#, TSQL, ASP.NET, WPF, WCF, Silverlight
  • Senior Software Developer/Consultant

    2009 - 2012
    MyGPS
    • Worked on various products.
    Technologies: Silverlight, .NET, Micro .NET, WCF, REST, OData, SQL CLR, SOA, WPF, Objective-C, NoSQL, Event Driven Architecture, AngularJS, Spatial Data, Dijkstra Routing, Data Analytics
  • Senior Software Developer/Consultant

    2009 - 2012
    Onyx Consulting
    • Worked on various products.
    Technologies: ASP.NET, Silverlight, CSLA
  • Software Developer

    2001 - 2006
    United Business Group
    • Worked on company product.
    Technologies: Delphi, DCOM, Paradox, VB, C#

Experience

  • Investorpark (Development)

    A large application designed and architected by me. An application was an asset of a fast moving startup in Georgia.
    The app’s mission was to collect and process huge amounts of financial data into market symbol financial indicators, composing the symbols into risk-based portfolios, and calculating portfolio financial indicators, allowing the client to "play" with portfolios and provide them with automated "robo" advice for investing in financial instruments. The application was implemented using event sourcing/CQRS and DDD patterns. Integrations with a number of cloud services were made - DocuSign, Salesforce, Google Drive, Azure, and Google.

  • Fundingpark (Development)

    This was a strategic product of a fast-moving startup based in Georgia with partners in the UK.

    The goal of the application was creating two front-end portals for users (one for bank representatives and another for clients investing in deposits) and a huge integration platform behind it. The platform is to be used to integrate East European bank deposit products and provide easy experience for West European citizens for investing in high-yield deposits and generating income from interest.

    The application used Angular on the front and .NET on the back. The event sourcing pattern was used throughout the application’s domain objects.

  • PRO-8 (Development)
    http://www.protech.co.uk/info/our-solutions/

    Designed and implemented front-end architecture using WPF technology. Used a modular approach to build this huge CRM application. Created a complete custom control suite, starting from input controls and ending with large composite controls like DataGrid, Ribbon, and Dynamic Forms. Wrote documentation for team members to build UI functionality based on the building blocks created in the core library.

  • M2 Real Estate (Development)
    http://m2.ge

    Created an enterprise-level software application for the largest real estate development company in Georgia. The application is serving three main business domains for a client - development, sales, and rentals. All domain logic is coded in the business layer using Active Record-based business objects. Entity Framework was used for persistence.

    Advanced T-SQL optimization techniques were used to create DB storage tables allowing the app to maintain the whole history of all the changes of all the data in the application. History was used to run reports, giving the client the ability to go back in time and see how things were looking like at particular time

  • GPS Tracker (Development)
    http://mygps.ge

    Designed and implemented a set of applications serving largest GPS tracker in Georgia.

    Vehicle trackers - Application written in .NET micro framework running in FEZ Domino devices which are installed on vehicles and are able to be configurable from a remote server, collect telemetry online and offline, and send to the server when online.

    Ingest server - A server able to collect thousands of telemetry events per second, storing it and delivering it to time series log after the ETL cycle.

    Client portal - Software written in Silverlight, allowing me to show vehicle positions on a map, configure alerting, notifications, and viewing reports.

    Back-end processing server - The server was running custom processing engine written by me to produce "dimensions" - transformed time series from input to output dimensions. Producing new insights like fuel consumption, fuel fill times, trip information, agricultural machinery efficiency, and other.

    C#/TSQL/Silverlight/JavaScript was used in the above services

  • My Implementation of Dijkstra's Routing Algorithm (Other amazing things)
    http://blog.devarchive.net/2013/03/fast-dijkstras-algorithm-inside-ms-sql.html

    Just a fraction of a second to go through very large collection – it is about 0.1-0.2 seconds per largest search in the country of Georgia.

  • Code Generation (Other amazing things)
    http://blog.devarchive.net/2010/10/code-generation-using-custom-item.html

    Code generation using custom item template, custom template wizard, and T4 engine.

  • Saga vs. Process Manager (Other amazing things)
    http://blog.devarchive.net/2015/11/saga-vs-process-manager.html

    My overview of the two patterns.

    I implemented the patterns on top of my event-driven framework.

  • Processing Events Exactly Once (Other amazing things)
    http://blog.devarchive.net/2015/11/how-to-process-sequence-of-events.html

    Implementation details about how my framework processes events exactly once.

Skills

  • Languages

    TypeScript 2, C#, T-SQL, SQL, JavaScript, Domain-specific Languages (DSLs), Python 3, HTML5, HTML, CSS
  • Frameworks

    Angular, Windows Presentation Foundation (WPF), Silverlight, ASP.NET, AngularJS, .NET, OAuth 2, JSON Web Tokens (JWT), ASP.NET MVC 6
  • Libraries/APIs

    JSONP, Node.js, Web API
  • Tools

    TeamCity, Microsoft Visual Studio, Packer, Terraform
  • Paradigms

    REST, Eventual Consistency, Event Sourcing, CQRS, Object-oriented Programming (OOP), Asynchronous Programming, Event-driven Programming, Continuous Integration (CI), Continuous Delivery (CD), Behavior-driven Development (BDD), Reactive Programming, Event-driven Architecture, Actor Model, Agile Software Development, Functional Programming, Test Automation, SOA, Unit Testing, Waterfall Development, Scrum, Cross-platform, Functional Reactive Programming, DevOps, On-demand Scaling, Event Storming, Model View Presenter (MVP), BEM, Incremental development, Design Patterns, Pair programming, ITIL, Microservices, Test-driven Development (TDD)
  • Platforms

    Windows, Amazon Web Services (AWS), Azure, Docker, Windows Phone, Android, iOS
  • Storage

    Google Cloud, JSON, SQL CLR, NoSQL, Azure Cloud Services, Azure Tables, Azure Blobs, Azure SQL Databases, EventStore, MongoDB, Database Replication, PostgreSQL, MySQL
  • Other

    Single-page Applications (SPA), Performance Optimization, Business Analysis, Version Control, Denormalized Read Model, Messaging patterns, Cryptography, Windows Services, Software Architecture, Octopus Deploy, Security, Memory profiling, OData, Ajax, Domain-driven Design (DDD), Algorithms, Chatbots, Data Structures, Bounded Context Map, Bounded Contexts Integration, API Backwards Compatibility, Data Versioning, Optimistic/Pessimistic Concurrency Check, Enterprise Integration, Identity Server, StateMachine, Infrastructure monitoring, Configuration Management, MSMQ, Integration Testing, Project Management, Task Scheduling, Sharding, Azure Service Bus, DocuSign, Multithreading, Workflow Modeling, Clustering, Banking & Finance

Education

  • Bachelor's degree in Information Technology
    1996 - 2000
    Georgian Technical University - Tbilisi, Georgia
Certifications
  • Google Certified Professional - Cloud Architect
    OCTOBER 2017 - OCTOBER 2019
    Google Cloud Certified
I really like this profile
Share it with others