Otar Melia, Developer in Tbilisi, Georgia
Otar is available for hire
Hire Otar

Otar Melia

Verified Expert  in Engineering

Database/SRE Developer

Location
Tbilisi, Georgia
Toptal Member Since
June 18, 2020

Otar started as a software developer and became deputy CIO in the biggest telecom operator in his country. He likes working with data, regardless of nature: sales, CRM, ERP, or any other. He's managed SQL databases (Oracle, Microsoft SQL, MySQL, and PostgreSQL) locally and in cloud environments (Azure and AWS). Otar enjoys creating dashboards, scoreboards, and business intelligence systems to make decisions based on data analysis.

Portfolio

Silknet, JSC
BSS, Amazon Web Services (AWS), Data-driven Design, Architecture, PL/SQL Tuning...
Datafabric Pty Ltd
Python, Business Intelligence (BI), Data Pipelines, Amazon QuickSight...
Enchanting Travels AG
Data Engineering, Python, Node.js, AWS CloudFormation, AWS Lambda, Redshift...

Experience

Availability

Part-time

Preferred Environment

Database Administration (DBA), Microsoft SQL Server, MySQL, Python, SQL, Hadoop, Tableau, Oracle, Linux, Apache Kafka, Amazon S3 (AWS S3), Data Modeling, Data Architecture, Database Modeling, Architecture

The most amazing...

...project I've designed is a complex billing, charging, and CRM system for the biggest mobile operator in my country.

Work Experience

Deputy CIO

2018 - PRESENT
Silknet, JSC
  • Swapped successfully core Telecom BSS&CRM system. The project included issuing and validating SRS, controlling quality assurance activities, and babysitting a newly launched product.
  • Started an IT transformation project, which involved upgrading the entire stack of BSS/OSS systems in the company and creating and optimizing business processes inside IT and between IT and other departments.
  • Analyzed project requirements and SRS documents.
  • Monitored and steered a process of report provisioning to financial, marketing, and government regulatory authorities.
  • Led a team.
Technologies: BSS, Amazon Web Services (AWS), Data-driven Design, Architecture, PL/SQL Tuning, Database Performance, Oracle 11g, Solution Architecture, OLTP, OLAP, Database Migration

Business Intelligence Engineer

2023 - 2024
Datafabric Pty Ltd
  • Created a Dagster/dbt pipeline for financial data collection and warehousing.
  • Optimized Python code and moved all logic into the database.
  • Created a visual dashboard with charts, tables, filters, etc., in Amazon QuickSight.
Technologies: Python, Business Intelligence (BI), Data Pipelines, Amazon QuickSight, Dashboards, Data Build Tool (dbt), Dagster, Financial Data, Databases, Cloud, Microsoft Excel

Data Engineer

2022 - 2023
Enchanting Travels AG
  • Built a data warehouse in Google BigQuery and set ingestion and transformation pipelines using Pub/Sub and DBT for a travel company.
  • Connected Amazon EventBridge to GCP Pub/Sub. Collected data from the invoices app and CRM.
  • Built a development pipeline in GitHub for KNIME workflows, DBT, GCF, and Docker image deployment.
Technologies: Data Engineering, Python, Node.js, AWS CloudFormation, AWS Lambda, Redshift, Data Analytics, BigQuery, Amazon S3 (AWS S3), Big Data, Data Pipelines, Amazon RDS, Data Modeling, Data Architecture, Database Modeling, Data-driven Design, Architecture, Datadog, Lambda Functions, JSON, GitHub, CI/CD Pipelines, DevOps, API Design, ELT, Database Architecture, Google Cloud Functions, Google Cloud Platform (GCP), MySQL DBA, Unix, Terraform, Infrastructure as Code (IaC), Data Build Tool (dbt), Data Analysis, MySQL Server, Database Migration, Databases, Cloud, Microsoft Excel, Google Pub/Sub

Data Engineer

2021 - 2021
Savings United
  • Migrated data warehouse from on-premises to cloud.
  • Created data warehouse in Google BigQuery fed by online and offline data.
  • Built a CI/CD pipeline using GitHub Actions to deploy software in GCP.
Technologies: BigQuery, ETL, SQL, Python 3, Data Pipelines, Data Modeling, Data Architecture, Database Modeling, Data-driven Design, Architecture, Database Optimization, Lambda Functions, Unix Shell Scripting, JSON, DevOps, ELT, Database Architecture, Google Cloud Functions, Google Cloud Platform (GCP), Unix, Azure, Entity Relationships, Data Analysis, MySQL Server, Performance Tuning, PostgreSQL, Cloud, Microsoft Excel

HubSpot Developer

2021 - 2021
Spa Space
  • Connected HubSpot with custom CRM and synchronized data between app and HubSpot.
  • Fixed bugs, reviewed code, and tracked work in Jira and TFS.
  • Created engine to synchronize data between applications.
Technologies: HubSpot, C#, JavaScript, NoSQL, Cloud, Full-stack

Senior HubSpot Developer

2021 - 2021
SpaSpace
  • Developed an application to connect the portal with HubSpot, propagating data from the app to HubSpot.
  • Created workflows in HubSpot for customer onboarding.
  • Built site-tracking scripts to track customers' activity in the portal.
Technologies: C#, HubSpot, Angular, APIs, Reporting, Amazon S3 (AWS S3), API Design, RESTful Microservices, JavaScript, Cloud, Full-stack

Integration Developer

2019 - 2021
BIMG.CA
  • Connected Hubspot to an eSign service and the Canada Revenue Agency API.
  • Crated a lead tracking engine with the ability to collect leads from various sources.
  • Integrated Unbounce pages with Salesforce, Google Sheets, and other CRM APIs. After that, we canceled Zapier integration.
Technologies: Amazon Web Services (AWS), PHP 7, Integration, HubSpot, CRM APIs, MongoDB, Data Migration, APIs, Amazon S3 (AWS S3), Data Pipelines, Amazon EC2, Database Modeling, NoSQL, Unix Shell Scripting, JSON, DevOps, API Design, Node.js, Amazon RDS, MySQL DBA, Unix, RESTful Microservices, MySQL Server, JavaScript, Cloud, Microsoft Excel, Full-stack

Head of IT

2016 - 2018
Alliance Group Holding
  • Headed team for the development of leasing, ERP, and intranet applications.
  • Discussed with customers project requirements.
  • Helped analyze task and requirements.
  • Devided tasks to subtasks.
  • Managed projects.
Technologies: Cloud Computing, Microsoft SQL Server, C#, Amazon Web Services (AWS), PostgreSQL, Database Modeling, Architecture, Node.js, Database Performance, Entity Relationships, RESTful Microservices, Microsoft Access, Microsoft Excel, Full-stack

SQL Lecturer

2015 - 2018
Free University of Georiga
  • Taught a relational databases course in the university for motivated students.
  • Created the course, syllabus, and learning materials for MySQL.
  • Evaluated students homework and exams.
Technologies: SQL, Database Design, Relational Databases, Database Modeling, MySQL Server, Databases

Head of Billing Department, Deputy CIO

2005 - 2016
Magticom, Ltd.
  • Designed and managed core telecom applications, billing, charging, and CRM.
  • Managed SQL databases. Made optimizations, query audit, recommendations of hints, indices, and optimal distribution of data across the storage.
  • Created a data warehouse and ETL pipelines from remote API, XML, JSON, and binary data, which ingested about 100 million records per day.
  • Created data visualization and analytic dashboards.
  • Managed and administered a Linux server. Performed installation of OS and packages configuration.
Technologies: Databases, Bash Script, Perl, Python, PL/SQL, SQL, Database Design, Relational Databases, Data Migration, Finance, Business Intelligence (BI), Data Analytics, Oracle Database, Oracle, Oracle PL/SQL, Data Architecture, Data-driven Design, Architecture, Database Optimization, PL/SQL Tuning, Unix Shell Scripting, JSON, DevOps, Database Architecture, Database Performance, Oracle 11g, Unix, Solution Architecture, Entity Relationships, OLTP, OLAP, Data Analysis, Performance Tuning, Microsoft Access, PostgreSQL, Database Migration

Data Warehouse and BI System for Telecom

I created a data warehouse and ingested data from the CRM, billing, sales, and network devices.
I also create a business intelligence system using QlikView to display charts, dashboards, and scoreboards for various departments in the company.

Billing and Charging System in Mobile Service Provider

We designed and created in-house billing and charging system for a mobile service provider.

I integrated it with core network elements.

Design Software for Leasing Company

I organized the project, planned workshops, collected retirements, and created the project requirements document (PRD) for leasing software.

Migrate Data Warehouse from On-premises Microsoft SQL Server to Google Cloud

Migrated database to BigQuery and ETL jobs to Cloud Functions, using Google Cloud Secret Manager, Google Workflows, scheduler, monitoring dashboards, and connected database to Looker. All important notifications were connected to Slack. Built CI/CD pipeline using GitHub Actions.
1991 - 1996

Master's Degree in Mathematics

Tbilisi State Univerity - Tbilisi, Georgia

MARCH 2023 - PRESENT

Power BI Developer

FINA

Libraries/APIs

REST APIs, Google Cloud API, Node.js

Tools

Microsoft Excel, BigQuery, GitHub, Terraform, Microsoft Access, Tableau, AWS CloudFormation, Microsoft Power BI, Amazon QuickSight

Languages

T-SQL (Transact-SQL), SQL, Python, C#, Visual Basic for Applications (VBA), JavaScript, Bash Script, PHP 7, Perl, Python 3

Paradigms

Database Development, Database Design, DevOps, ETL, Data-driven Design, OLAP, Oracle Database Architecture, Business Intelligence (BI)

Platforms

Oracle, Oracle Database, Unix, Amazon Web Services (AWS), Linux, Azure SQL Data Warehouse, Google Cloud Platform (GCP), Dedicated SQL Pool (formerly SQL DW), Pentaho, HubSpot, QlikView, Apache Kafka, Azure, Amazon EC2, AWS Lambda

Storage

Microsoft SQL Server, MySQL, Databases, Database Administration (DBA), PL/SQL Developer, Relational Databases, Oracle PL/SQL, Database Architecture, Database Modeling, Data Integration, JSON, Database Performance, Oracle 11g, MySQL Server, Database Migration, Azure SQL Databases, PostgreSQL, SQL Server DBA, Data Pipelines, NoSQL, Database Triggers, PL/SQL, MSSQLCE, Oracle DBA, OLTP, Amazon S3 (AWS S3), MongoDB, Redshift, Azure SQL, Datadog

Frameworks

.NET, Hadoop, Angular

Other

APIs, Data Modeling, Data Engineering, Data Architecture, CSV File Processing, Database Schema Design, Reporting, API Integration, PL/SQL Tuning, Unix Shell Scripting, API Design, Data Build Tool (dbt), Entity Relationships, Excel 365, Data Warehouse Design, Data Warehousing, Microsoft Azure, Data Analysis, IT Systems Architecture, Cloud, Data Analytics, Data Migration, Reports, Query Optimization, Partitioning, Server Migration, Architecture, Database Optimization, Lambda Functions, CI/CD Pipelines, ELT, MySQL DBA, Solution Architecture, RESTful Microservices, Performance Tuning, Full-stack, Google Pub/Sub, BSS, Cloud Computing, Data Visualization, Mathematics, Integration, CRM APIs, Tabl, Tableau Server, Data-driven Dashboards, Google Cloud Functions, Google BigQuery, Amazon RDS, Financial Data, Finance, DAX, Big Data, Infrastructure as Code (IaC), Dashboards, Dagster

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring