Otar Melia
Verified Expert in Engineering
Database/SRE Developer
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
Experience
- SQL - 17 years
- Database Design - 15 years
- Oracle - 15 years
- Database Architecture - 15 years
- Perl - 10 years
- MySQL - 8 years
- Microsoft SQL Server - 7 years
- Python - 5 years
Availability
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
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.
Business Intelligence Engineer
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.
Data Engineer
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.
Data Engineer
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.
HubSpot Developer
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.
Senior HubSpot Developer
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.
Integration Developer
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.
Head of IT
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.
SQL Lecturer
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.
Head of Billing Department, Deputy CIO
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.
Experience
Data Warehouse and BI System for Telecom
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
I integrated it with core network elements.
Design Software for Leasing Company
Migrate Data Warehouse from On-premises Microsoft SQL Server to Google Cloud
Education
Master's Degree in Mathematics
Tbilisi State Univerity - Tbilisi, Georgia
Certifications
Power BI Developer
FINA
Skills
Libraries/APIs
REST APIs, Google API, Google Cloud API, Node.js, Google Places API
Tools
Microsoft Excel, BigQuery, GitHub, Terraform, Microsoft Access, Zapier, 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, Azure SQL Data Warehouse, Google Cloud Platform (GCP), Dedicated SQL Pool (formerly SQL DW), Pentaho, HubSpot, QlikView, Apache Kafka, 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, Azure SQL, MSSQLCE, Oracle DBA, OLTP, Google Cloud, Amazon S3 (AWS S3), MongoDB, Redshift, 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, Enterprise Resource Planning (ERP), 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, Back-end Development
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring