Otar Melia, Database/SRE Developer in Tbilisi, Georgia
Otar Melia

Database/SRE Developer in Tbilisi, Georgia

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.
Otar is now available for hire

Portfolio

Experience

Location

Tbilisi, Georgia

Availability

Part-time

Preferred Environment

Database Administration (DBA), Microsoft SQL Server, MySQL, Python, SQL, Hadoop, Tableau, Oracle, Linux

The most amazing...

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

Employment

  • Deputy CIO

    2018 - PRESENT
    Silknet, JSC
    • Swapped successfully core Telecom BSS&CRM system. The project included issuing and validating SRS, controlling quality assurance activities, babysitting of newly launched product.
    • Started IT transformation project, which involves upgrading of the full stack of BSS/OSS systems in the company; 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 finance, marketing, and government regulatory authorities.
    • Led a team.
    Technologies: BSS, Amazon Web Services (AWS)
  • 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#
  • 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
  • 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
  • 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)
  • 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
  • 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, Financial Experience, Business Intelligence (BI)

Experience

  • 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.

Skills

  • Languages

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

    REST APIs, Google Cloud API
  • Tools

    Microsoft Excel, Tableau
  • Paradigms

    Database Development, Database Design, ETL, Oracle Database Architecture, Business Intelligence (BI)
  • Platforms

    Amazon Web Services (AWS), Linux, Oracle, Pentaho, QlikView, Apache Kafka, Azure, Amazon EC2
  • Storage

    Microsoft SQL Server, MySQL, PL/SQL Developer, Relational Databases, Database Modeling, Azure SQL Databases, PostgreSQL, SQL Server DBA, Data Pipelines, Database Triggers, Oracle PL/SQL, MSSQLCE, Databases, Database Administration (DBA), Amazon S3 (AWS S3), MongoDB, NoSQL, Database Architecture, PL/SQL, Redshift, Azure SQL
  • Other

    APIs, Data Modeling, Data Engineering, Data Architecture, CSV File Processing, Database Schema Design, Reporting, Data Warehouse Design, Data Warehousing, Microsoft Azure, Data Analysis, IT Systems Architecture, Cloud, Data Analytics, Data Migration, Reports, Azure SQL Data Warehouse (SQL DW), Query Optimization, Partitioning, BSS, Cloud Computing, Data Visualization, Mathematics, Integration, HubSpot, CRM APIs, Tabl, Tableau Server, Data-driven Dashboards, Google Cloud Functions, Google BigQuery, AWS RDS, Financial Data, Financial Experience
  • Frameworks

    .NET, Hadoop, Angular

Education

  • Master's Degree in Mathematics
    1991 - 1996
    Tbilisi State Univerity - Tbilisi, Georgia

To view more profiles

Join Toptal
Share it with others