George is available for hire
Hire GeorgeGeorge A. Georgopoulos
Verified Expert in Engineering
Full-stack Developer
Kalamaria, Greece
Toptal member since June 18, 2020
Bio
George brings 28 years in the full cycle of IT project development, predominantly in an entrepreneurial role. He has delivered projects covering a wide spectrum of industry sectors, either solo or managing small, Agile teams. His main focus has been designing, programming, and tuning database applications in Oracle PL/SQL and PostgreSQL. Complex algorithm design and optimization techniques are the core of many of his projects.
Portfolio
Pureprofile, Pty., Ltd.
Amazon Web Services (AWS), Flyway, PL/pgSQL, PostgreSQL
Swapdom., Inc.
PL/SQL, Oracle
EUtrek, Ltd.
PL/SQL, Oracle
Experience
- SQL Performance - 20 years
- PL/SQL - 20 years
- Database Design - 20 years
- Oracle RDBMS - 20 years
- Software Project Management - 20 years
- PostgreSQL - 7 years
- PL/pgSQL - 7 years
- ETL Implementation & Design - 5 years
Availability
Part-time
Preferred Environment
Oracle RDBMS, PL/pgSQL, PostgreSQL, Oracle PL/SQL
The most amazing...
...thing I've built is a near-optimal solution to the NP-hard problem of multi-way swapping.
Work Experience
Senior Database Developer
2015 - PRESENT
Pureprofile, Pty., Ltd.
- Developed a quota management system managing the distribution of campaign targeting.
- Developed the ETL strategy for coalescing data from multiple databases in a BI database. Developed the generation of campaigns' raw data.
- Developed the bulk aggregations needed to support the platform's operations.
- Developed database support for cilients' dashboards.
- Performed database programming, tuning, and optimization.
- Led an IT team of six developers.
Technologies: Amazon Web Services (AWS), Flyway, PL/pgSQL, PostgreSQL
Co-founder and CTO
2013 - 2015
Swapdom., Inc.
- Implemented the company's multi-way trade algorithm.
- Designed the company's databases and applications.
- Programmed all database procedures supporting the application.
- Programmed all APIs for communication with third parties (PayPal, Facebook, UPS, STEAM, etc.).
- Managed an IT team of two front-end programmers and a DevOps person.
Technologies: PL/SQL, Oracle
Co-founder and Principal Developer
2006 - 2013
EUtrek, Ltd.
- Designed and Implemented a technical analysis platform featuring automated pattern recognition.
- Managed the transfer of technology from a US company that provided the basis of the technical analysis application.
- Designed and implemented a reverse-auction SaaS for procurement departments.
- Designed and implemented an SMS dispatcher.
Technologies: PL/SQL, Oracle
Shareholder and Principal Developer
2001 - 2006
IQ Systems SA
- Designed and implemented a matching algorithm on CV/Job-posting that produced a ranked list of the best Jobs/CVs, indicating what aspects were under/over qualified and by how much.
- Consulted on Oracle and PL/SQL tuning and design.
Technologies: PL/SQL, Oracle
Shareholder and Head of S/W Department
1999 - 2001
PC Systems SA
- Designed and implemented a stock trading application, featuring SMS alerts and order submission.
- Designed and executed migrations of ERP systems.
- Designed and implemented the EU milk quota tracking system for the compliance of the Greek Milk Production Organization to EU standards.
Technologies: PL/SQL, Oracle
Co-founder and Principal Developer
1987 - 1999
APG Systems SA
- Undertook the computerization of the Thessaloniki Water Authority (500,000 meters), managing a team of two programmers. Designed the database and the application; coded all the stored procedures.
- Implemented a production scheduling system for Four Mill, encapsulating a mixed-integer programming solver.
- Re-engineered and migrated an insurance company from legacy COBOL/ISAM to Oracle/RDBS and Oracle Developer.
- Designed and Implemented a system ensuring consistency of results in a textile dyeing factory.
- Designed and implemented a system for tracking VCM gas exposure of personnel in a chemical plant.
- Designed and implemented a system that optimized air-cargo pricing suggesting the cheaper routes, as per IATA rules.
Technologies: PL/SQL, Oracle
Experience
Swapdom Multi-way Trade Algorithm
A multi-year effort of research and development leading to the near-optimal, scalable solution to the NP-hard problem of multi-party trading. Once the algorithm matured, the project received $2 million in VC funding and turned into Swapdom, Inc.
Technical Analysis Service
Developed a technical analysis service that was applied on the data feed of multiple exchanges and was presented in multiple languages. Its main differentiating feature was the automatic detection of technical analysis patterns in the data feed.
Reverse Auction Service
Develped eTender, a reverse auction service that allows procurement departments to include electronic auctions in their procurement cycle. From a business point of view, the project was designed to fit a niche not addressed by competing services in the Balkans.
CV/Job Matching
Developed initially under the eContent Multitrain project, the task consisted of the design and implementation of an algorithm that produced a ranked list of matches between CVs and job postings. The resulting service went commercial at the end of the eContent project.
Driver License Testing
Developed for the Pouliadis group of companies and aimed at the greater Balkan area, the product allowed the delivery of a multitude of driver’s license tests in the Balkan languages, based on a databank of questions maintained by the product and complying with the target countries’ testing standards.
Milk Quota Management System
The Greek Milk Production Organization contracted this project for managing the production quotas and the related secondary market for Greek milk producers according to EU regulations.
Online Trading
Developed one of the first services to offer online tracking of the ASE stock exchange sessions, coupled with with SMS alerts and online trades.
Insurance Company Re-engineering
The project was the transition of the Argonaftiki Insurance company from a COBOL/ISAM to an Oracle Developer/Oracle database environment. Prior to training the personnel and performing the migration, we undertook the redesign of the database and the application analysis to support enhanced functional requirements
Flour Mill Production Optimization
With the objective of minimizing the number of costly switches in the mill’s production runs, the project used mixed-integer programming methods to generate the commands that optimized the daily/weekly production schedules. Developed for the Allatini Mills.
Dye Industry Production Scheduling
The aim of Eliofin, the largest dyeing plant in Northern Greece, was to increase the consistency of results in its dyeing runs. The application had to consider the chemistry of the dyeing process, the recipes, the trackability of the materials used, etc., to produce the needed time-temperature charts fed to the dyeing machines.
VCM Gas Exposure Tracking
The aim of this project was to track the exposure of the Thessaloniki oil refinery chemical plant personnel to VCM gas. The final product integrated sensor and work-shift data as well as an exposure model to deliver the required personnel exposure histories.
Air Cargo Optimization
The alternative way to declare an air cargo shipment according to IATA rules is rather involved and can make a difference in the shipping cost. The project allowed the major air-cargo agent in Northern Greece to instantly determine the cheapest setup per airline/route among competing options.
Education
1984 - 1985
Master of Science Degree in Systems Engineering
Harvard University - Cambridge, MA, USA
1980 - 1984
Bachelor of Science Degree in Systems Engineering
Harvard College - Cambridge, MA, USA
Skills
Tools
Flyway
Languages
SQL, PL/pgSQL
Paradigms
ETL Implementation & Design, Database Design
Storage
SQL Performance, Oracle RDBMS, PostgreSQL, PL/SQL, Oracle PL/SQL
Platforms
Windows, Oracle, Amazon Web Services (AWS)
Other
Team Mentoring, PL/SQL Tuning, Software Project Management, Query Optimization, Performance Tuning, Oracle Performance Tuning, Amazon RDS, Mixed-integer Linear Programming
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