Teimuraz is available for hire

Teimuraz Magradze

Verified Expert in Engineering

Software Developer

Tbilisi, Georgia

Toptal member since June 21, 2022

Expertise

Excel Development Data Reporting Database Debugging Data Analysis Data Engineering Data Modeling Data Warehousing Visual Basic Oracle PL/SQL SQL Performance Relational Databases Microsoft Access Development SUN Development Monte Carlo Simulation PyCharm Delphi

Bio

Teimuraz is a software developer with more than five years of experience in Oracle database and database design, programming, and tuning. He is proficient in PL/SQL, SQL, reporting, analyzing data, Visual Basic Studio, Python, Delphi, Visual Basic for Applications (VBA), and Microsoft Access. Teimuraz will be a great addition to any team.

Portfolio

Silknet

Oracle, SQL, PL/SQL, Python 3, PL/SQL Developer, PyCharm, ETL, Database Design...

UTG

Oracle, PL/SQL, SQL, Delphi, PL/SQL Developer, Oracle PL/SQL, Microsoft Access...

UTG

VB, Delphi 7, Oracle, PL/SQL Developer, Microsoft Access, Microsoft Excel...

Experience

SQL - 10 years Microsoft Access - 10 years PL/SQL Developer - 10 years Oracle - 10 years PL/SQL - 10 years PyCharm - 5 years Python 3 - 5 years

Availability

Part-time

Preferred Environment

Oracle, PL/SQL, PyCharm, Python 3, VB, Visual Basic for Applications (VBA), SQL, Oracle PL/SQL, Databases, Data Reporting, Excel 365

The most amazing...

...things I've created are an OLAP database that covers business needs and government requests and a program for billing telephone services.

Work Experience

Billing Department Senior Engineer

2013 - PRESENT

Silknet

Created jobs and procedures for checking charges and sending notifications about problems to employees.
Developed the Oracle Database OLAP and developed procedures for moving data from the OLTD database to OLAP.
Created various Oracle procedures and packages for developing new products in the billing system.
Created various financial reports using SQL PL/SQL, Excel, and Excel VBA.

Technologies: Oracle, SQL, PL/SQL, Python 3, PL/SQL Developer, PyCharm, ETL, Database Design, Python, Pandas, Data Analysis, Databases, Microsoft Excel, Excel Macros, Data Reporting, Microsoft Power BI, Data Visualization, Data Warehouse Design, Data Warehousing, API Integration, APIs, Reports, Business Intelligence (BI), Data Architecture, Automated Data Flows, SQL DML, SQL Performance, Performance Tuning, Database, Debugging, Excel 2010, Excel 2016, Microsoft SQL Server, Data Science, MySQL, Excel 2013, SQL Stored Procedures, Stored Procedure, OLAP, Jupyter Notebook, Schemas, Star Schema, Data Modeling, Reporting, Data Cleansing, Data Transformation, Data Processing, Data Processing Automation, CSV, Scripting, Data Pipelines, Relational Database Design, Relational Databases, Database Architecture, BI Reports, XML, T-SQL (Transact-SQL), Amazon Web Services (AWS), Data Engineering, Data Profiling, Datasets, Oracle DBA, Excel 365, Data Structures, Data Integration, CSV Export, Data Extraction, Microsoft 365, Microsoft Access, Billing, ITIL 4

Senior Developer

2008 - 2013

UTG

Built an application for reading CDR files from switches.
Developed packages and procedures in PL/SQL for billing calls of 300,000 subscribers.
Developed packages and procedures in PL/SQL for one-time billing and periodical charges for 400,000 subscribers.
Participated in the migration of 500,000 subscribers to the CBOSS system.
Created financial reports using SQL PL/SQL, Excel, and Excel VBA.

Technologies: Oracle, PL/SQL, SQL, Delphi, PL/SQL Developer, Oracle PL/SQL, Microsoft Access, Databases, Microsoft Excel, Excel Macros, Data Reporting, Data Engineering, Data Analysis, Data Warehouse Design, Data Warehousing, API Integration, APIs, Reports, Data Architecture, Automated Data Flows, SQL DML, SQL Performance, Performance Tuning, Database, Debugging, Excel 2010, Microsoft SQL Server, Data Science, MySQL, T-SQL (Transact-SQL), SQL Stored Procedures, Stored Procedure, OLAP, Schemas, Star Schema, Data Modeling, Reporting, Data Cleansing, Data Transformation, Data Processing, Data Processing Automation, CSV, Scripting, Excel Development, Borland Database Engine (BDE), Data Pipelines, Relational Database Design, Relational Databases, Database Architecture, Data Profiling, Datasets, Oracle DBA, Excel 365, Data Structures, Data Integration, Data Extraction, Statistics, Monte Carlo Simulations, Billing

Delphi Senior Developer

2006 - 2008

UTG

Developed a front-end application and modules using Delphi.
Created views in Oracle for accessing from the Delphi app.
Participated in creating a database in Oracle and transferring data for interconnecting calls from DBF files to the Oracle database.
Created various reports using SQL and Excel, and Excel VBA.

Technologies: VB, Delphi 7, Oracle, PL/SQL Developer, Microsoft Access, Microsoft Excel, Excel Macros, Excel VBA, Visual Basic for Applications (VBA), Data Engineering, SQL, API Integration, APIs, Reports, Data Architecture, SQL DML, Debugging, SQL Stored Procedures, Stored Procedure, Reporting, Data Cleansing, Data Transformation, Data Processing, Data Processing Automation, CSV, Scripting, Excel Development, Borland Database Engine (BDE), Data Pipelines, Relational Database Design, Relational Databases, Database Architecture, Data Profiling, Datasets, Excel 365, Data Structures, Data Integration, Statistics, Visual Basic, Billing

Visual Basic Developer

2004 - 2006

United Telecom of Georgia

Created a front-end application for billing operators and cashier operators.
Created modules for fast development. These modules were used by other team developers.
Created a front-end application for sales managers with different access roles.

Technologies: Visual Basic for Applications (VBA), Visual Basic 6 (VB6), CSV, Scripting, Excel Development, Excel 365, Data Structures, Data Integration, Statistics, Visual Basic, Billing

Experience

Billing Program for a Telecommunication Company with 500,000 Subscribers

This billing program for post-pay subscribers allows them to make call charges, use one-time events and periodic fees, send notifications, receive payments, and make corrections. The program is designed for high performance.

OLAP Database

I created an OLAP database and procedures for moving data from the OLTP database. Database filling occurs every night, followed by data updates every week. This database is designed for business intelligence needs, but it also covers government reporting.

Loan Management Program

Contributed to the development of credit management software. The program accrues interest, and in case of non-payment, fines are charged. Loans are issued in different currencies. It is possible to get statistics on the main points and some financial reports.

An Accounting Program for Calculate Payroll

An accounting program written in Excel using macros and VBA to calculate payroll and taxes for an organization of 200 employees. The program takes rest days, sick days, holidays, and vacations into account.

Certifications

DECEMBER 2023 - DECEMBER 2026

ITIL 4 Foundation

PeopleCert

Skills

Libraries/APIs

Pandas

Tools

Microsoft Access, Microsoft Excel, Excel 2010, Excel 2016, Excel 2013, PyCharm, Microsoft Power BI

Languages

SQL, SQL DML, Stored Procedure, Visual Basic, Python 3, VB, Visual Basic for Applications (VBA), Delphi 7, Delphi, Python, Excel VBA, Visual Basic 6 (VB6), XML, T-SQL (Transact-SQL)

Platforms

Oracle, Jupyter Notebook, Amazon Web Services (AWS)

Storage

PL/SQL, PL/SQL Developer, Oracle PL/SQL, Databases, SQL Performance, SQL Stored Procedures, Relational Databases, Database Architecture, Microsoft SQL Server, MySQL, Data Pipelines, Data Integration, PostgreSQL, Oracle DBA

Paradigms

Database Design, ETL, Business Intelligence (BI), OLAP

Other

Data Analysis, Data Engineering, Excel Macros, Data Reporting, Data Warehousing, Reports, Data Architecture, Performance Tuning, Database, Debugging, Schemas, Data Modeling, Reporting, Data Transformation, Data Processing, CSV, Excel Development, Relational Database Design, Datasets, Excel 365, Data Structures, CSV Export, Data Extraction, Microsoft 365, Billing, Data Visualization, Data Warehouse Design, API Integration, APIs, Automated Data Flows, Data Science, Star Schema, Data Cleansing, Data Processing Automation, Scripting, Borland Database Engine (BDE), BI Reports, Data Profiling, Statistics, ITIL 4, Monte Carlo Simulations

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.

Share your needs

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

Choose your talent

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

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