
George-Cristian Ilinca
Verified Expert in Engineering
Software Developer
Bucharest, Romania
Toptal member since June 18, 2020
George is a software engineer with 10+ years of experience and very passionate about the work he does. He has worked with many technologies in the past to build a variety of projects from websites for different companies to real-time applications used in factories. George's career path is strongly related to DBs for the last 8+ years. One of his achievements so far in that direction was an OCP certification.
Portfolio
Experience
- Oracle PL/SQL - 15 years
- SQL - 15 years
- Databases - 15 years
- Oracle - 15 years
- MySQL - 11 years
- Database Modeling - 10 years
- Python - 5 years
- Pentaho Data Integration (Kettle) - 3 years
Availability
Preferred Environment
Git, Subversion (SVN), PostgreSQL, MySQL, Oracle
The most amazing...
...project that I've worked was generating thousands of invoices (data from multiple sources) to XMLs and deliver them using different channels.
Work Experience
Senior Oracle Developer/Team Lead
OMV Petrom
- Took over an Oracle application used to maintain all OMV customers' cards and their transactions.
- Analyzed and developed new requirements related to these applications.
- Migrated the current application on new technologies for performance improvement.
- Coordinated the development and operational teams from Bucharest and created time-plans for bigger projects and change requests ensuring team availability and an appropriate workload.
Senior Oracle Developer
Pentalog
- Worked with Oracle 11g and Pentaho Data Integration (Kettle) as a tool for ETL part.
- Contributed to monitoring and the maintenance the local servers used in development, testing, and presentation environments including some DBA tasks.
Senior Developer
Sinoptix SA
- Led a team of 12 members responsible for developing and maintaining an ordering system (Service Order) for the main Romanian telecom operator. The application was initially developed using Oracle Forms and Oracle Database (database size ~4 TB) and was in a process of transition to a web-based Java application.
- Oversaw the development of other job-related applications (internal tools) for all the departments in the company (management, inventory, equipment monitoring, and administrative tools).
Software Developer
Vision Systems
- Utilized OLAP (Online Analytical Processing) cube and reports building using Pentaho BI (Business Intelligence).
- Contributed to the project TIPTOE, a European project where Vision Systems was partner.
Co-founder
CySoft Design
- Co-founded a software company (Cysoft Design) where the main activity and most of the projects were related to presentation websites.
Experience
Cards System of OMV Petrom
There are three interconnected main applications, all of them having the core in Oracle Database 12c. The interfaces for two applications are written in Oracle Forms and for the last one in Java (Oracle ADF).
OMV Petrom is part of ROUTEX - an international network alliance between ARAL, BP, Circle K Europe, ENI, and OMV making it one of the biggest fuelling networks in Europe, so Cards System applications are connected and communicate with systems for other companies as well.
Main functionalities of these applications are:
* management of OMV Petrom customers
* management of OMV Petrom cards (national and international) and their transactions
* invoice generation and distribution using different channels
* customer interface (Customer is able to check his transaction, order different products, change limits on his cards, etc)
* ensure communication between all systems (internal or external)
Service Order System of Telekom
Related to the application, the Service Order is a system that manages the internal service orders and their delivery to the subscribers of Telekom company (German telecommunications company). 3,000 people from all operational departments use the system, it runs on a 2 terabyte database and covers the following business areas: call center, stores, sales, billing, technical support, quality control, and marketing.
Financial Application
Right now, I'm offering support and I'm maintaining all required changes (most of them because of changing the structure of imported data).
Education
Master of Engineering Degree in IT and Communication Systems and Technologies
University "Transilvania" Brasov - Brasov, Romania
Bachelor of Engineering Degree in Systems and Computers Engineering
University "Transilvania" Brasov - Brasov, Romania
Certifications
ITIL 2011 Foundation
APMG International
Oracle Database 11g: Advanced PL/SQL
Oracle
Oracle Database 11g: Program with PL/SQL
Oracle
Oracle Database SQL Expert
Oracle
Skills
Libraries/APIs
jQuery, PySpark
Tools
Oracle SQL Data Modeler, Pentaho Data Integration (Kettle), Subversion (SVN), Git, Oracle Forms
Languages
SQL, Python, PHP, JavaScript, Java, C#
Paradigms
Database Design, Oracle Database Architecture, Functional Programming, ETL, OLAP
Platforms
Oracle, Databricks, Pentaho, Oracle Database
Storage
MySQL, Oracle PL/SQL, Oracle SQL, Databases, Database Modeling, Database Triggers, MySQL/MariaDB, PostgreSQL, SQL Server 2000, Oracle DBA, PostgreSQL 10, Microsoft SQL Server
Frameworks
Ext JS, ASP.NET
Other
Technical Leadership, ETL Tools, Data Architecture, Data Engineering
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