Gabriel Breahna, Developer in Bucharest, Romania
Gabriel is available for hire
Hire Gabriel

Gabriel Breahna

Verified Expert  in Engineering

Bio

Gabriel has 20 years of experience installing, managing, and using SQL, NoSQL (key-value, columnar, graph), time-series, spatial, in-memory, and cloud databases. He's worked with 10TB OLTP databases, 10TB data warehouses, tables with 10+ billion rows, and databases with 10,000+ tables. He's built greenfield and brownfield apps, managed acquisitions, mergers, and spin-offs, and is proficient in Oracle, PostgreSQL, MySQL, Snowflake, BigQuery, Redshift, Synapse, MongoDB, Cassandra, and DynamoDB.

Portfolio

Oracle
SQL, PL/SQL, Oracle Development, Oracle HCM Cloud...
Freelance Clients
SQL, PL/SQL, Oracle RDBMS, Oracle EBS, Oracle Application Express (APEX)...
Builders Ltd.
SQL, PostgreSQL, AWS, AWS CLI, BigQuery, Shell Scripting, Cloud Engineering...

Experience

Availability

Full-time

Preferred Environment

SQL, Data Warehousing, Data Analytics, Big Data, Databases, Data Engineering, SQL Performance, Data Integration, Business Intelligence (BI), Back-end

The most amazing...

...thing: built queries for funnels, journeys, retentions, insights, for tables with 300 billion records & execution times of 0.2 seconds for 80% of the queries.

Work Experience

Principal Software Developer

2019 - PRESENT
Oracle
  • Built an external candidate scheduling app and integrated it with Oracle HCM Cloud, Microsoft Graph RESTful APIs, Zoom RESTful APIs, and Slack RESTful APIs.
  • Managed, from the database side, the migration of four databases and over 100 apps from being on-premise to Oracle Cloud. Used Oracle Cloud, RDBMS, SQL, PL/SQL, Docker, Terraform, Ansible, Bash, and Linux.
  • Created new ETL pipelines and managed existing ETL pipelines to capture data from various external and internal systems into the OTA data warehouse. Used SQL, PL/SQL, Airflow, Kafka, Spark, Python, ADW, Oracle NoSQL Database Cloud, and Oracle Cloud.
  • Built RESTful APIs, which included exposing tables, procedures, functions, and schemas. Used Oracle REST Data Services (ORDS), OAuth2, SQL, PL/SQL, and cURL.
  • Collaborated with an enterprise ML team to develop multiple algorithms to classify candidate resumes.
  • Worked with the Java team to expose the endpoints for the front-end team. SQL and PL/SQL made up the primary tech stack.
  • Constructed green-field and brown-field Oracle APEX apps for the OTA organization. Used SQL, PL/SQL, HTML, CSS, JavaScript, OJET, and ORDS.
  • Performed SQL tuning for poorly performing apps. Used the explain plan, execution plan, and performance statistics and worked with DBAs, sysadmins, the product development team, and expert gurus.
  • Reviewed code and implemented pair programming, all within an Agile environment.
Technologies: SQL, PL/SQL, Oracle Development, Oracle HCM Cloud, Oracle Application Express (APEX), Data Warehouse, Back-end Developers, Microsoft Development, Slack API, Zoom Development, Agile Development, HTML, JavaScript, CSS, JSON, OAuth, System Security, Oracle REST Data Services (ORDS), Oracle Development, Docker, Docker Compose, Oracle Development, Terraform, Ansible, Jenkins, Git, Slack Development, Slack App, cURL Command Line Tool, Postman, Bash, Linux, DevOps, Column-oriented DBMS, Oracle Development, Migration Engineering, REST API, Data Lakes, Snowflake, RDBMS, Database, Database, Data Engineering, APIs, Azure, Oracle Development, Oracle Development, Oracle Development, Oracle SQL, SaaS, Oracle Database, Oracle Cloud Infrastructure (OCI), Oracle SOA Suite, SQL, Data Center Migration, Data Architecture, Data Modeling, Database, Star Schema, Data Processing Automation, Excel Development, Data Processing, CSV, Data Analysis, Scripting, ETL Tools, UX Development, UI Development, Data Science, Data Visualization, Design Consulting, Mobile Analytics, Data Science, Data Cleaning, Financial Modeling, Database Optimization, Dimensional Modeling, Oracle Development, Query Optimization, Performance Tuning, Query Composition, Back-end Developers, Analytics Development, Database, Relational Database Design, Stored Procedure, SQL, Database Schema Design, SaaS, Apache Kafka, Apache, Apache Airflow, Spark, Hadoop, Datasets, Data Science, Data Science, Dashboard, Data Science, BI Reporting, Robotic Process Automation (RPA), Oracle Development, Cloud Engineering, CI/CD Pipelines, ERP Development, Microsoft Power Automate, API, ODBC, Database Design, Database, Database, Transactions, Database, Big Data Architecture, Message Queues, Big Data Architecture, Data Transformation, Amazon EC2, Database Performance, Node.js, Networks, SQL, Oracle Development, Database, Data Integration, Streaming Data, Unix, Data, Solution Architecture, Data Auditing, Monitoring, Technical Architecture, Microsoft Power Apps, Database Modeling, ELT, Process Automation, Pipelines, Architecture, Automation, Algorithms, Interactive Dashboards, Reports, Microservices Development, Graph API, Integration, GitHub, RabbitMQ, Microsoft 365, Proof of Concept (POC), Database Migration, ETL Development, ETL Implementation & Design, ETL Testing, Oracle Fusion Applications, Oracle Security Server, Identity & Access Management (IAM), Backup & Recovery, Performance Optimization, Leadership, Database, ETL Pipelines, Database, Business to Business (B2B), Delta Lake, SSH, Data Migration, Cloud Migration, MQTT, API Integration, REST, Business Requirements, DB, Data Flows, Distributed Systems, Scalability, Git Repo, Static Analysis, Shell Scripting, Machine Learning, Data Classification, Excel 365, Technical Leadership

Software Engineer | Data Engineer

2016 - PRESENT
Freelance Clients
  • Created batch-and-streaming Google Cloud Dataflow pipelines/DAG to insert data from 4,000+ IoT devices into a 10TB Goole BigQuery data warehouse. Used GCP console and Python for the job and extracted data via BigQuery and SQL.
  • Refactored a GPS tracking application from Oracle RDBMS, Oracle APEX, and GlassFish to an open-source solution based on PostgreSQL, Python, Bootstrap, and OpenStreetMap tiles. Used SQL, Python, Flask, Bootstrap, HTML, CSS, JavaScript, and Leaflet.
  • Migrated a GPS tracking application hosting 2,000+ GPS devices from an Oracle RDBMS-based solution to an open-source solution based on Traccar Java-based application and PostgreSQL RDBMS.
  • Migrated a data center from on-premise to OVHcloud bare-metal servers, Linux, Apache Tomcat, GlassFish, NGINX, Oracle RDBMS, Oracle APEX, PostgreSQL, and Python. Provisioned Linux boxes. Installed and configurated Linux and Oracle RDBMS.
  • Architected the solution, created ETL pipelines, and developed SQL code for 10TB of data generated at a Euro 6 emission test time. Used GCP BigQuery, Dataflow, Apache Beam, streaming/batch pipeline, Pub/Sub, Cloud Functions, and Cloud Storage.
  • Developed a GPS tracking device, including the firmware using C and the integration into the Traccar app. It was manufactured at PCBWay.com at a very affordable price. Used STM32F4 microcontroller, STM32CubeMX, and KiCad.
  • Built a 6DOF robotic arm using mechanical parts from a Borunte robot and added new Inovance servo drivers. Used SOEM open source, extending it using real-time C programming. Created a ROS control driver and MoveIt trajectory control.
  • Localized the Odoo/OpenERP for the Romanian market, which included building modules, reports, and enhanced forms. Sold the service as a SaaS. Used Python, Selenium, PostgreSQL, SQL, Docker, and OVHcloud.
  • Developed a data warehouse for a Romanian holding to consolidate its operations from distribution, manufacturing, wholesale, and retail, from multiple ERPs inherited after multiple acquisitions, using Azure, Synapse, Data Factory, and PowerBI.
  • Conducted multiple one- to six-month-long freelance projects as a software and data engineer using a wide range of technologies such as AWS, Azure, GCP, Snowflake, Redshift, PostgreSQL, MySQL, Airflow, Python, Lambda, Kafka, CDC, dbt, EKS, and MKS.
Technologies: SQL, PL/SQL, Oracle RDBMS, Oracle EBS, Oracle Application Express (APEX), Docker, Jenkins, Google BigQuery, Cloud Dataflow, Apache Beam, Python, Flask, PostgreSQL, SQL, Leaflet, Mapbox GL, OpenStreetMap, Nominatim, Pandas, Plotly, C, Matplotlib, HTML, CSS, JavaScript, JSON, jQuery, OAuth, System Security, Terraform, Ansible, Docker Compose, Data Centers, Data Center Migration, Nginx, GlassFish, Apache Tomcat, Directed Acrylic Graphs (DAG), Oracle REST Data Services (ORDS), MySQL, SQLite, cURL Command Line Tool, Postman, EtherCAT, Arduino IDE, Arduino, STM32CubeMX, Robot Operating System (ROS), Selenium, Git, Slack Development, Jira, Confluence, Cloud Engineering, DevOps, Windows Development, MacOS, OVH, Cloud Engineering, RESTful Microservices, MongoDB, MariaDB, Column-oriented DBMS, Oracle Cloud Infrastructure (OCI), JSON Web Tokens (JWT), XPath, XQuery, XSLT, Oracle Development, Migration Engineering, REST API, Snowflake, RDBMS, Database, Database, BigQuery, Data Engineering, Cloud Engineering, OLAP, APIs, Tableau Development, Business Intelligence Development, Azure, Oracle Development, KiCad, PyCharm, Altium Designer (PCAD), RS485, RS-232, Modbus Protocol, Odoo, OpenERP, XML, Oracle Development, Oracle Development, Oracle SQL, SaaS, Oracle Database, Oracle SOA Suite, SQL, IT Project Management, Data Architecture, Data Modeling, SQL Server, Database, Relational Databases, Star Schema, Data Processing Automation, Excel Development, Data Processing, CSV, Data Analysis, Scripting, ETL Tools, Blockchain, UX Development, UI Development, Data Science, AWS, Data Visualization, Apache Airflow, Django, AWS RDS, Design Consulting, AWS Lambda, GraphQL, Mobile Analytics, Redshift, Firebase, Data Science, Data Cleaning, Financial Modeling, Database Optimization, Consumer Packaged Goods (CPG), Dimensional Modeling, Oracle Development, Oracle Development, Query Optimization, Performance Tuning, Query Composition, Back-end Developers, Analytics Development, Database, Relational Database Design, Data Build Tool (dbt), XML for Analysis (XMLA), Stored Procedure, SQL, Cron, Database Schema Design, SaaS, B2B Design, Datasets, Data Science, Data Science, Dashboard, Supply Chain, Data Science, BI Reporting, Business Services, Big Data Architecture, Oracle Development, Oracle Development, Kubernetes, Cloud Engineering, Data Science, CI/CD Pipelines, ERP Development, SAP, SAP S/4HANA, API, Power Query, DAX, ODBC, AWS Glue, Database Design, Database, Database, Transactions, Search, Geospatial Data, Database, Google Analytics, Big Data Architecture, Message Queues, Big Data Architecture, Data Transformation, AWS, Amazon EC2, Database Performance, Node.js, Networks, Google Cloud Functions, SQL, MySQL, Oracle Development, Database, Hadoop, Data Integration, Streaming Data, Unix, Database Administration (DBA), Data, Azure Data Factory, Solution Architecture, Data Auditing, Monitoring, Technical Architecture, Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, Microsoft Power Automate, Microsoft Power Apps, Sourcing & Procurement, Database Modeling, ELT, Process Automation, Pipelines, Architecture, Amazon S3, Data Lakes, Automation, Algorithms, Interactive Dashboards, Reports, Microservices Development, Graph API, Fivetran, LinkedIn API, Google API, Sage 300 SDK, QuickBooks Development, Stripe Development, Spotify API, API, Instagram API, X (formerly Twitter) API, Facebook API, YouTube API, Integration, GitHub, RabbitMQ, Microsoft 365, Proof of Concept (POC), Database Migration, ETL Development, ETL Implementation & Design, ETL Testing, T-SQL (Transact-SQL), Backup & Recovery, PostgreSQL, Performance Optimization, Leadership, Looker, Google Cloud Development, Google Analytics 4 (GA4), Accounting, Database, ETL Pipelines, Database, E-commerce marketing, Spotify Development, X (formerly Twitter) Development, TikTok, Business to Business (B2B), Delta Lake, Databricks, Spark, SSH, Data Migration, Cloud Migration, Mixpanel, Segment.io, Geospatial Analytics, User Journeys, Web Marketing, IoT Protocols, Artificial Intelligence, TCP/IP, MQTT, API Integration, WebSockets, AWS IoT, C#, Debian, REST, Business Requirements, Django, Django, Industry 4.0, Smart City Technology, Microcontrollers, J1939, Data Center Management, LoRaWAN, LoRa, CIM, Relux, Autodesk Fusion 360, SOLIDWORKS, MATLAB, Simulink, Sequelize, DB, Data Flows, Distributed Systems, Startup Development, Scalability, Git Repo, Static Analysis, Shell Scripting, Google Pub/Sub, Apache, PySpark, Machine Learning, Data Classification, Excel 365, Salesforce Design, Amazon Aurora, Technical Leadership, Microsoft Data Transformation Services (now SSIS), SSIS, SSAS

Database Engineer

2024 - 2024
Builders Ltd.
  • Fixed the AWS RDS PostgreSQL performance issue, lowering it from 100% to 30%, reducing execution time from minutes to under one second.
  • Enhanced the back-end app (Node.js/TypeScript) to deal with mint/burnt tokens.
  • Upgraded FTSO Flare/Songbird FTSO apps (Node.js/TypeScript) to the latest ccxt library and fixed miscellaneous bugs along the process. Streamed all recorded data into BigQuery for later ML processing.
Technologies: SQL, PostgreSQL, AWS, AWS CLI, BigQuery, Shell Scripting, Cloud Engineering, Machine Learning

Software Engineer | Data Engineer

1999 - 2016
Euro Bit SA
  • Implemented Oracle EBS 12.2 financials, order management, procurement, supply chain planning, and manufacturing.
  • Served as an app admin, DBA, and SQL developer, which included SQL performance/tuning and management, developing SQL and PL/SQL customizations and reports.
  • Built a vehicle spare parts webshop tightly integrated with Oracle EBS R12. Used Oracle RDBMS, Oracle APEX, ORDS, HTML, JavaScript, CSS, and jQuery. Integrated it also with TecDoc via RESTful API and OAuth2.
  • Led the build of a SaaS model GPS vehicle-tracking app and used Oracle RDBMS, Oracle APEX, HTML, CSS, JavaScript, LeafletJS, jqPlot, Apache Tomcat, and OpenStreetMap. It oversaw 10,000+ GPS units, 10TB of data, and 20 billion records at its peak.
  • Crafted a customized putaway and picking algorithm for the Oracle EBS WMS and MSCA module. Used SQL, PL/SQL, and Java. WMS was used to manage a 500,000-square-foot warehouse, and the algorithm increased overall efficiency by 10%.
  • Constructed a customized EDI integration module for Oracle EBS order management, shipping, and purchasing. Used SQL, PL/SQL, EDI, iDoc, XML, and JSON. At its peak, the system managed 5,000 orders/day and one million orders/year.
  • Developed a driver for Datecs ECR to integrate it with Odoo/OpenERP. Used Qt.
  • Made business intelligence dashboards and reports based on Oracle EBS data. Used SQL, Oracle OBIEE, and Weblogic.
  • Developed 20+ Oracle EBS extensions using Oracle APIs, interfaces, SOA, XML, a RESTful API, APEX, SQL, PL/SQL, SQL Loader, and SFTP.
Technologies: SQL, PL/SQL, Oracle RDBMS, Oracle EBS, Oracle Application Express (APEX), Java, Python, C++, C, Data Warehouse, Business Intelligence Development, Electronic Data Interchange (EDI), ETL, TecDoc, OAuth, Oracle Development, Oracle Development, Oracle REST Data Services (ORDS), Odoo, OpenERP, Qt Development, SAP IDoc, XML, JSON, Oracle Development, Oracle Development, Git, SQL Server, Solaris, Linux, Windows Development, Oracle SOA Suite, SFTP, SQL, Leaflet, jQuery, Oracle Development, Migration Engineering, REST API, Snowflake, RDBMS, Database, Database, Data Engineering, OLAP, APIs, Tableau Development, Business Intelligence Development, Relational Data Mapping, Oracle Development, RS485, RS-232, Modbus Protocol, jQuery, Oracle Development, Oracle Development, Oracle SQL, SaaS, Oracle Database, Data Center Migration, IT Project Management, Data Architecture, Data Modeling, SQL Server, Database, Relational Databases, Star Schema, Data Processing Automation, Excel Development, Data Processing, CSV, Data Analysis, Scripting, ETL Tools, UX Development, UI Development, Data Science, Data Visualization, Design Consulting, Mobile Analytics, Data Science, Data Cleaning, Borland Database Engine (BDE), Financial Modeling, Database Optimization, Consumer Packaged Goods (CPG), Query Optimization, Performance Tuning, Query Composition, Back-end Developers, Analytics Development, Database, Relational Database Design, XML for Analysis (XMLA), Stored Procedure, SQL, Cron, Database Schema Design, SaaS, Datasets, Data Science, Data Science, Dashboard, Supply Chain, Data Science, BI Reporting, Oracle Development, Oracle Development, Data Science, ERP Development, SAP, SAP S/4HANA, Digital Manufacturing, API, Power Query, DAX, ODBC, AWS Glue, Database Design, Database, Database, Transactions, Search, Real Estate, Geospatial Data, Database, Google Analytics, Big Data Architecture, Message Queues, Big Data Architecture, Data Transformation, AWS, Amazon Elastic MapReduce (EMR), Scala, Database Performance, Node.js, Networks, Google Cloud Functions, Microsoft Access Development, SQL, MySQL, Oracle Development, Database, Data Integration, Streaming Data, NoSQL, Oracle Development, Unix, Database Administration (DBA), VMware, Oracle Development, SQL Server, Data, Azure Data Factory, Solution Architecture, Data Auditing, Industrial Internet of Things (IIoT), Monitoring, Technical Architecture, Ajax, Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, Sourcing & Procurement, Database Modeling, ELT, Process Automation, Pipelines, Architecture, Amazon S3, AWS, Automation, OCR, Algorithms, Interactive Dashboards, Reports, Microservices Development, MySQL, Graph API, Fivetran, LinkedIn API, Google API, Sage 300 SDK, QuickBooks Development, Integration, GitHub, RabbitMQ, Microsoft 365, Proof of Concept (POC), Database Migration, ETL Development, ETL Implementation & Design, ETL Testing, T-SQL (Transact-SQL), Oracle Fusion Applications, Oracle Security Server, Identity & Access Management (IAM), Veeam, Backup & Recovery, VMware vSphere, Network Engineering, Software-defined WAN (SDWAN), Data Center Infrastructure, Networking, PostgreSQL, Performance Optimization, Leadership, Google Cloud Development, Google Analytics 4 (GA4), Accounting, Database, ETL Pipelines, Database, E-commerce marketing, Business to Business (B2B), Delta Lake, Databricks, Spark, SSH, Data Migration, Cloud Migration, Geospatial Analytics, Web Marketing, IoT Protocols, Artificial Intelligence, TCP/IP, MQTT, API Integration, WebSockets, AWS IoT, C#, Azure IoT Edge, ESP32, .NET, Raspberry Pi, Debian, Azure, REST, Business Requirements, Industry 4.0, Smart City Technology, Microcontrollers, J1939, Data Center Management, Autodesk Fusion 360, SOLIDWORKS, MATLAB, Simulink, JavaScript, Sequelize, DB, Data Flows, Distributed Systems, Startup Development, Scalability, Git Repo, Static Analysis, Shell Scripting, Google Pub/Sub, Cloud Engineering, Apache, PySpark, Oracle Apps, Technical Leadership, Microsoft Data Transformation Services (now SSIS), SSIS, SSAS

IT Manager | Project Manager | Developer

1996 - 1999
Euro Trade Invest SA
  • Developed a tailored application for an alcohol plant from scratch and integrated it with SCADA and other sensors; used Oracle RDBMS, Borland Delphi, and C.
  • Built an app for a chain of 16 duty-free shops using Orale Personal Edition and Borland Delphi.
  • Constructed a fiscal printer driver with bidirectional communication with the main POS; used C and C++.
Technologies: SQL, PL/SQL, Oracle RDBMS, C, C++, Pascal, SCADA, IT Project Management, Database, Database, Oracle Development, Oracle SQL, Data Architecture, Data Modeling, Excel Development, CSV, Design Consulting, Borland Database Engine (BDE), Financial Modeling, Database Optimization, Consumer Packaged Goods (CPG), Data Analysis, Query Composition, Oracle Development, Database Design, Database, Database, Transactions, Database, Networks, Data, Solution Architecture, Proof of Concept (POC), Performance Optimization, Leadership, Database, Data Migration, Business Requirements, DB, Distributed Systems

Software Engineer

1995 - 1996
TAROM SA
  • Created new ETL pipelines and maintained existing pipelines for data coming from 30+ agencies abroad; used Borland C++.
  • Integrated the Boeing Spare Parts electronic catalog with the airliner purchasing system using Borland C++.
  • Cleaned up OTP Airport passengers' onboarding data and reused that data to generate the annual TAROM airliner timetable; it was done using Borland Delphi.
Technologies: C++, ETL, PL/SQL, Oracle RDBMS, Pascal, Borland Database Engine (BDE), Database Optimization, Query Composition, Database Schema Design, Database Design, Database, Database, Transactions, Database, Data, Proof of Concept (POC), Performance Optimization, Database, Database, Data Migration, Business Requirements, DB, Distributed Systems

Software Engineer

1994 - 1995
ITC SA
  • Developed a custom dispatching app for a small taxi company based on Oracle 7.3 and Borland C++.
  • Oversaw and was responsible for software maintenance across the codebase. This required a wide understanding of the internals of the software and systems.
  • Developed a custom app for the accounting department based on their ongoing specs using Visual FoxPro.
Technologies: SQL, C++, PL/SQL, Oracle RDBMS, Borland Database Engine (BDE), Query Composition, Database Schema Design, Oracle Development, Database Design, Database, Database, Transactions, Database, Data, Proof of Concept (POC), Performance Optimization, Database, Data Migration, Business Requirements, DB

Amazon RDS PostgreSQL Optimization

https://xhaven.io
I optimized an Amazon RDS PostgreSQL database with a CPU load of 100% most of the time. My work also included fixing queries, creating missing indexes, changing database parameters, and changing the Sequelize Node.js code in the back end. I used CloudWatch, Performance Insights, the PostgreSQL PERF profiling utility, and EXPLAIN ANALYZE.

In the end, the average database load dropped to 10%, with no spikes.

Digital Analytics Tool Based on BigQuery and TypeScript

http://livedocs.com
As the lead back-end developer for a cutting-edge SaaS digital analytics app, I spearheaded the development of a dynamic platform capable of seamlessly integrating data from various sources using APIs and database connections. My role involved crafting intricate analytic queries tailored for BigQuery, leveraging TypeScript to develop custom plugins for Fivetran, and fine-tuning the performance of our PostgreSQL database hosted on the Google Cloud Platform (GCP). With a focus on efficiency and scalability, I played a pivotal role in enabling our users to generate insightful queries, reports, and data applications in a matter of seconds.

Digital Analytics Platform Based on Snowflake, BigQuery, and Redshift

I created SQLs for user and event segmentation, funnels, journeys, and retentions, using SQL and JavaScript UDTFs to deal with 300 million monthly records.

I used clustering, materialized views, and pre-aggregations to improve query execution time. A proprietary BQL language was created for easy interaction between the front and back ends. I made a BQL to SQL transpiler using Go, ANTLR4, AWS DynamoDB, AWS RDS Postgres, and AWS MSK, and a proprietary ingestion system using Go, Python, AWS Lambda, AWS EKS, Rudderstack, and Segment.

Compressed Natural Gas 12.4 Liter Heavy-duty Engine EURO VI Emission Certifications

I created a data warehouse that could manage ten TB of data generated in a couple of weeks under a very tight working schedule.
My process started by using an Oracle database configured as a data warehouse on-premise. I then used SQL and PL/SQL for the ETL and SQL for extracting the data.
Next, I performed a lot of SQL tuning for performance enhancement. Further improvements included implementing an Oracle Cloud-based data warehouse, along with cloud-specific tools. I also implemented Google Cloud and BigQuery and created Apache Beam DAG pipelines to increase the ETL speed.
We received two certifications for a 380 and 460 horse-power engine family.

Automotive Spare Parts Webshop

This project involved an Oracle APEX app that was tightly integrated with Oracle EBS R12. The app's purpose was to sell vehicle spare parts, deal with seeded and superseded spare parts, and expose 10 million parts.

My work included an integration via a RESTful API while using Express Carriers for shipping. I also integrated RESTful APIs with vehicle spare parts suppliers for quick replenishment and created RESTful microservices tailored for key customers.

My technology stack included Oracle RDBMS, APEX, Oracle REST Data Services (ORDS), SQL, PL/SQL, RESTful APIs, microservices, and Docker Compose.

Oracle EBS Implementation, Personalization, Customization, Extension, Workflow, and Analytics

I completed 10+ Oracle EBS implementations in financials, SCM, WMS, manufacturing, and services. I improved the system by making personalization and customizations. I also created extensions using APEX and introduced workflow changes.

I created a custom data warehouse, custom mobile data warehouse apps, EDI integrations with key accounts, B2B and B2C apps, integrations with express delivery companies, integration with POS and weighting scales, conveyors using CANopen, integrations with packaging and bottling lines, dock management, yard management, and fleet management. I implemented Power BI and Tableau analytics on Snowflake, BigQuery, RedShift, and Oracle ADW.

Database Migration for a Fintech Company

I performed MS SQL Server to Oracle migration for multiple database instances, which the customer inherited after multiple acquisitions. I also conducted database analysis, and application code, performed data types mapping, and modified stored procedures, triggers, and queries.

I worked on ensuring data integrity and compatibility, performed query optimization, and evaluated online and offline data migration to minimize downtime. With all of this, I also performed tests and validations. The customer preferred a SQL script approach and manually assisted.

Vehicle GPS Tracking SaaS Application

This project involved a Python Flask and PostgreSQL-based SaaS application meant for tracking vehicles via GPS. At the time, it managed over 10,000 vehicles, 10TB of data, and 20 billion records.

Initially, the app was built using Oracle APEX and Oracle RDBMS on-premise. Still, later on, we migrated it to OVH Cloud and, after a while, refactored it using only open source technologies such as OpenStreetMap for map tiles, geocoding, reverse geocoding, Traccar.org for GPS tracking, PostgreSQL, and Python.

It was a real challenge to make it run fast because of the huge amount of data, but we accomplished it via various SQL techniques.

We launched the app in 2008, and it is still working today.

External Candidate Database Scheduling Engine

I built a 100% PL/SQL scheduling engine integrated with the organization's Microsoft Exchange 365 Calendar Service.

I used PL/SQL, UTL_HTTP, wallets, Cloud Vault, and Microsoft Graph RESTful APIs for the calendar, mail, and attachments, along with Zoom and Slack APIs, OAuth2, and pre-authentication. I also solved performance issues for a 100,000+ users organization and an undisclosed number of booked meetings per day.

Custom Algorithms for an Oracle EBS 3PL Data Warehouse

I created pure SQL and PL/SQL algorithms as an extension for the Oracle EBS Warehouse module, which was meant for a 3PL implementation. It was a 500,000-square-foot warehouse with a wide variety of products (electronic appliances, food, beverages, cigarettes, raw materials, and meat) and several custom specs for receiving and shipping along with 20,000+ SKUs, 5,000+ orders per day, and 25,000+ order lines per day.

The successful implementation made the end users happy, and the client could get contracts signed with all prominent players from the local market.

Open-source ERP and Odoo Romanian Localization

I created 20+ Odoo apps/modules and ensured that they complied with Romanian regulations.

My work included creating a bill printer, XML receipts, VAT customization, currency rate updates, Romanian invoices, MRP costs, key accounts' SKUs, POS debranding, printer ZPL 2, stock analyses, stock expiration dates, and Romanian stock reports.

I used Python, XPath with QWeb, PostgreSQL, and SQL.
1989 - 1994

Master of Science Degree in Industrial Engineering and Robotics

University Politehnica of Bucharest - Bucharest, Romania

OCTOBER 2023 - PRESENT

Cyber Security Auditor

Romanian Directorate for Cyber Security

MARCH 2021 - SEPTEMBER 2022

Oracle Cloud Infrastructure Foundations 2020 Certified Associate

Oracle

JUNE 2018 - MAY 2021

PRINCE2 Practitioner

AXELOS

Libraries/APIs

REST API, ODBC, Graph API, Segment.io, PySpark, Leaflet, Mapbox GL, Slack API, Node.js, QuickBooks Development, Stripe Development, Spotify API, API, Instagram API, X (formerly Twitter) API, Facebook API, YouTube API, LinkedIn API, Google API, Django, SQL, Pandas, Matplotlib, jQuery, jQuery

Tools

AutoCAD Design, Oracle Application Express (APEX), Oracle Development, Git, Jira, Slack Development, Confluence, Zoom Development, Oracle Development, Oracle Development, BigQuery, Tableau Development, Business Intelligence Development, Excel Development, Apache Airflow, Cron, ANTLR 4, AWS IAM, AWS CLI, AWS Key Management Service (KMS), AWS Glue, Microsoft Access Development, GitHub, RabbitMQ, PostgreSQL, Looker, Spark, MQTT, Sequelize, SSAS, PyCharm, Apache Tomcat, Docker Compose, TecDoc, Odoo, Oracle SOA Suite, Apache, Power Query, Google Analytics, AWS, Amazon Elastic MapReduce (EMR), VMware, Oracle Development, Microsoft Power Apps, Sage 300 SDK, VMware vSphere, Azure, Autodesk Fusion 360, MATLAB, Apache, Jenkins, Cloud Dataflow, Apache Beam, Plotly, EtherCAT, Altium Designer (PCAD), KiCad, Terraform, Ansible, Nginx, cURL Command Line Tool, Postman, Amazon EKS, SAP S/4HANA, AWS, Relux, SOLIDWORKS

Languages

SQL, Python, JavaScript, Snowflake, Stored Procedure, T-SQL (Transact-SQL), C, C++, Java, Bash, Go, C#, .NET, Simulink, Pascal, HTML, CSS, XML, XPath, XQuery, XSLT, GraphQL, Scala

Frameworks

OAuth, Flask, JSON Web Tokens (JWT), Django, Big Data Architecture, Django, Oracle Development, Qt Development, Selenium, QWeb, Spark, Hadoop

Paradigms

ETL, Business Intelligence Development, Dimensional Modeling, B2B Design, Oracle Development, Database Design, Database, Automation, Microservices Development, ETL Implementation & Design, REST, OLAP, Agile Development, DevOps

Platforms

Docker, Linux, Oracle Database, Oracle Development, Cloud Engineering, Azure, AWS, AWS Lambda, Unix, Databricks, Mixpanel, AWS IoT, Debian, Solaris, OpenERP, Windows Development, MacOS, Oracle Cloud Infrastructure (OCI), Apache Kafka, Kubernetes, Microsoft Power Automate, Amazon EC2, Azure SQL Data Warehouse, X (formerly Twitter) Development, Raspberry Pi, Dedicated SQL Pool (formerly SQL DW), Arduino, Blockchain, Firebase, Salesforce Design

Storage

PL/SQL, Oracle RDBMS, PostgreSQL, SQL, JSON, MySQL, Oracle SQL, Oracle Development, SQL, RDBMS, Database, Database, SQL Server, Database, Relational Databases, Database, SQL, Amazon S3, Oracle Development, Database, Database, Database, Database Performance, SQL, MySQL, Oracle Development, Data Integration, Oracle Development, Database Administration (DBA), Database Modeling, Database Migration, Google Cloud Development, Database, Database, DB, Amazon Aurora, SSIS, Oracle Development, Data Centers, SQLite, Cloud Engineering, SQL Server, OVH, MariaDB, Column-oriented DBMS, Data Lakes, Cloud Engineering, NoSQL, SQL Server, MongoDB, Redshift, Hadoop, AWS, Elasticsearch

Industry Expertise

Accounting

Other

Data Warehouse, Oracle EBS, Oracle Development, IT Project Management, Data Warehouse, Electronic Data Interchange (EDI), Back-end Developers, Google BigQuery, Oracle Development, Microsoft Development, Data Center Migration, Oracle Development, Oracle REST Data Services (ORDS), Cloud Engineering, SaaS, Migration Engineering, Data Engineering, APIs, Data Architecture, Data Modeling, Star Schema, Data Processing Automation, Data Processing, CSV, Data Analysis, Scripting, ETL Tools, Data Visualization, AWS RDS, Design Consulting, Data Science, Data Cleaning, Borland Database Engine (BDE), Financial Modeling, Database Optimization, Consumer Packaged Goods (CPG), Query Optimization, Performance Tuning, Query Composition, Back-end Developers, Analytics Development, Relational Database Design, XML for Analysis (XMLA), Database Schema Design, SaaS, Datasets, Data Science, Data Science, Dashboard, Supply Chain, Data Science, Data Migration, BI Reporting, Business Services, ERP Development, API, Transactions, Geospatial Data, Big Data Architecture, Message Queues, Big Data Architecture, Data Transformation, Google Cloud Functions, Data, Azure Data Factory, Solution Architecture, Data Auditing, Industrial Internet of Things (IIoT), Monitoring, Technical Architecture, Ajax, Sourcing & Procurement, ELT, Process Automation, Pipelines, Architecture, OCR, Algorithms, Interactive Dashboards, Reports, Fivetran, MySQL, Integration, Microsoft 365, Proof of Concept (POC), ETL Development, ETL Testing, Oracle Fusion Applications, Oracle Security Server, Identity & Access Management (IAM), Veeam, Backup & Recovery, Network Engineering, Software-defined WAN (SDWAN), Data Center Infrastructure, Networking, Performance Optimization, Leadership, ETL Pipelines, E-commerce marketing, Business to Business (B2B), Delta Lake, SSH, Cloud Migration, Geospatial Analytics, User Journeys, Web Marketing, IoT Protocols, Artificial Intelligence, TCP/IP, API Integration, WebSockets, Business Requirements, Data Center Management, J1939, Data Flows, Distributed Systems, Startup Development, Scalability, Git Repo, Static Analysis, Shell Scripting, Google Pub/Sub, Machine Learning, Oracle Apps, Data Classification, Technical Leadership, Microsoft Data Transformation Services (now SSIS), Oracle HCM Cloud, OpenStreetMap, GlassFish, System Security, Slack App, Oracle Development, SFTP, Relational Data Mapping, UX Development, Mobile Analytics, Financial Data, Robotic Process Automation (RPA), Data Science, CI/CD Pipelines, DAX, Search, Networks, Streaming Data, Google Analytics 4 (GA4), Spotify Development, TikTok, Azure IoT Edge, ESP32, CIM, LoRa, LoRaWAN, Microcontrollers, Excel 365, SCADA, Nominatim, Modbus Protocol, RS-232, RS485, Directed Acrylic Graphs (DAG), Arduino IDE, STM32CubeMX, Robot Operating System (ROS), SAP IDoc, RESTful Microservices, EDIFACT, UI Development, Data Science, Data Build Tool (dbt), Amazon Marketing Services (AMS), Customer Data Platform (CDP), Change Data Capture, Segment, SAP, Digital Manufacturing, Real Estate, IT Audits, Audits, Profiling, Smart City Technology, Industry 4.0, HadoopXML

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