
Tomislav Delas
Verified Expert in Engineering
Database Developer
Vinkovci, Croatia
Toptal member since July 16, 2020
Tomislav is a seasoned IT expert in the software industry dating back to 1996. Most of his expertise is focused on data engineering, including the development of DWH and BI solutions, database and SQL optimization, and database administration. Tomislav has deep knowledge of SQL programming, database administration, Big Data technologies, cloud databases and services across AWS, Azure, and Google Cloud, as well as ETL pipeline development using Python, REST APIs, Informatica, and DataStage.
Portfolio
Experience
- Database Architecture - 20 years
- SQL - 20 years
- Data Modeling - 20 years
- ETL - 20 years
- PostgreSQL - 10 years
- Python - 7 years
- Big Data - 4 years
- Pandas - 2 years
Preferred Environment
Amazon Web Services (AWS), Google Cloud Platform (GCP), ETL, Python, Databases, Big Data, SQL, Data Engineering, Data Warehousing, Informatica
The most amazing...
...thing I've built with a core team was a telecom company's first in-house data warehouse 30 years ago, along with their first big data environment later.
Work Experience
Senior Oracle DBA (via Toptal)
Kepler Cheuvreux SA
- Conducted health checks on Oracle production databases in a standby Data Guard configuration, recommending optimizations with a focus on storage management.
- Configured Oracle log listener file retention policies, specifically using adrci and listener.ora.
- Moved production tables to archive tablespaces and resized datafiles and undo tablespaces.
- Analyzed RMAN backups, optimized backup storage, and fixed RMAN backup scripts.
Data Engineer
Pioneer Works, Inc.
- Monitored data pipelines in a data warehouse ecosystem as part of a weekly on-call rotation, covering Airflow DAGs, dbt jobs, AWS Databricks, Redshift, and Spark, and resolved issues by fixing and optimizing code.
- Developed new features by delivering Jira-assigned data engineering tickets, working with Airflow, Python, Databricks (SQL and Python notebooks), Spark, Redshift, and dbt (models, tests, and Jinja scripts).
- Worked as a data engineer and solved many operational tickets (inquiries) from business and data science users, regarding data in the data warehouse and data pipelines.
- Migrated a number of Databricks server compute jobs to serverless compute mode jobs.
Senior Oracle Database Administrator
Kepler Cheuvreux SA
- Optimized storage usage in Oracle databases by reorganizing datafiles, archiving data, compressing, and recreating large objects (tables and indexes).
- Fixed Oracle backup (RMAN Utility) scripts to support backup, recovery, and standby database operations.
- Synchronized production databases with development databases using Oracle export/import utilities, along with custom SQL and Linux shell scripts (including the sed utility).
- Developed custom shell and SQL scripts for database health monitoring and notifications.
- Audited failed connections to databases that were locking user accounts and resolved the issue.
Oracle Database Administrator (DBA)
SIG Susquehanna
- Optimized the performance of many SQL-driven jobs in the Oracle database.
- Worked on ETL pipelines for Oracle, Big Data (Hive), and Apache Druid.
- Developed many new features for business users' change requests.
- Reorganized big tables and objects, saving storage.
BigQuery Specialist
ABS Media Limited
- Developed integration for Nexudus and Zapier application systems with Google Big Query.
- Developed DWH layers and models on top of Google Big Query.
- Developed and loaded Google Big Query layer with business rules and transformations, ready for reporting and BI dashboards.
Data Engineer
BCG - Gamma
- Developed ETL pipelines (Python, Airflow) for feeding churn management and retention campaigns.
- Conducted many data engineering tasks regarding data ingestion, data quality, and data fixes on source and target systems.
- Accomplished MySQL and PostgreSQL DB administration and optimization tasks.
- Configured Docker infrastructure for the solution landscape.
- Onboarded many new team members on the project in the data engineering area and conducted lots of technical workshops.
- Developed SQL pipelines for data management and data fixing procedures.
Data Architect
Squeem, LLC
- Developed data model on Google BigQuery for marketing analysis of Sales.
- Completed ETL pipelines (Stitch ETL SW) from Shopify, Drip, Netsuite, and Google Analytics to BigQuery developed Datawarehouse model.
- Developed complex Tableau reports for Sale tracking.
- Stored procedures in Google BigQuery for data transformation.
IT Solution Architect
Croatian Telekom
- Launched the 1st real-time data collection from customer-premises or customer-provided equipment (CPE) to Cloudera Big Data services.
- Tuned Informatica PowerCenter ETL for data warehousing, tuning, and optimizing Spark streaming real-time processes for predictive and proactive fault resolution.
- Extended the data warehouse environment to Cloudera Big Data for data archiving and ETL processes on the Spark engine in Cloudera.
Head of IT Data Warehousing and Business Intelligence Section
Hrvatski Telekom
- Led big data integration into the data warehouse (new data warehouse architecture).
- Took over the development and operations of the mobile stack of the data warehouse environment.
- Tuned IBM DataStage ETL processes and Oracle data warehouse (DWH) databases.
- Developed alert processes on mobile devices using visualization tools (Power BI).
Head of Database Administration, Apps, & Service Support Work Unit in Information Systems Operations
Hrvatski Telekom
- Led the development of a web portal for IT operations that monitored and end-to-end (E2E) message communication between OSS/BSS telecom systems.
- Tuned many OLTP operational Oracle databases in the company, which resulted in quicker and smoother applications.
- Served as the core team member of the revenue assurance project and was in charge of interfaces, overall architecture solution, and development of some parts of the solution.
Head of T-HT IT Business Intelligence (BI) Development and Operations Team
Hrvatski Telekom
- Introduced a new data-warehousing solution in the company while also working as a lead solution architect and developer.
- Developed ETL processes and many custom interfaces.
- Made many OLAP cubes (Microsoft Analysis tools), reports (ad-hoc SQL and Microsoft Reporting Services).
Head of the IT Department in a Regional Telecommunications Center (Vukovar)
Hrvatski Telekom
- Developed the 1st company-wide data warehousing environment.
- Led a development-and-operational IT team, handling all IT regional processes and solutions.
- Oversaw and monitored all operational processes in IT.
Experience
Smart Churn Retention Solution
As a member of an international team and a Toptal member, I participated in the retention stream of DEEP.AI. I was tasked with various data engineering and other tasks: data pipeline, ETL creation, database data modeling, database, and query optimizations, CI/CD deployment, and pipeline orchestration.
Customer Data Platform Project on Cloud Warehouse Database
http://www.squeem.comMy Project Tasks:
• Analyzed Cloud ETL tools for data pipelines (Skyvia, Stitch, Hevo, and so on) as well as cloud data warehouse solutions (Google Big Query, Snowflake, Amazon Redshift, etc.) in the selection process.
• Implemented the creation of data pipelines (ETL) with Stitch Cloud ETL from source applications (Shopify, Drip, Oracle NetSuite, Google Ads, Google Analytics, and Facebook Ads) to Cloud Google BigQuery Data Lake and Data Warehouse.
• Transformed data on BigQuery (SQL and ETL procedures).
• Visualized with Tableau on top of BigQuery datasets.
• Handled data enrichment with segment software (events and personas).
Data Warehousing Project with Big Data
Revenue Assurance Project
Proactive Care
I was a core team developer on this project and was charged with interfaces and solution tuning. The project was used for proactive fault repair in the telco company and integrated into OSS daily processes.
Data Warehousing Solution for a Big Telco Provider
Data Warehousing Solution (for Mobile Services) in a Big Telco provider
Google Big Query Integrations and Reporting
Data Warehouse ETL and SQL Optimization
Data Reporting Layer on Top of MS SQL Database
Education
Master's Degree in Computer Science
University of Zagreb - Zagreb, Croatia
Engineer's Degree in Electrotechnics
University of Zagreb - Zagreb, Croatia
Certifications
AWS Certified Cloud Practitioner
Amazon Web Services
Training: Spark and Python for Big Data with PySpark
Udemy
Training: Informatica Cloud Data Integration
Udemy
Training: Apache Spark
Croz d.o.o. Croatia
Training: Apache Kafka Security
Udemy
Training: Apache Kafka Series — Kafka Security
Udemy
Training: IBM DataStage Development
Poslovna Inteligencija d.o.o. Zagreb
Training: Microsoft Reporting and Analysis Services
Croatian Telekom (Internal)
Training: PowerCenter 8.5 New Features for Administrator Training
Informatica
Training: PowerCenter 8 Developer Training
Informatica
Training: Cost-based Optimization, Indexing Strategies, and Explain Plans
Oracle
Oracle Certified Professional
Oracle
Training: ITIL Foundation for IT Service Management
HP Education Services
Training: 6 Sigma — Project Management Advanced
Next Level Consulting
Training : 6 Sigma — Project Management Leadership
Next Level Consulting
Training: 6 Sigma — Project Management Basics
Next Level Consulting
Training: Executive Management Qualifier
Graduate School of Business Administration Zurich
Training: General Management Qualifier
Graduate School of Business Administration Zurich
Training: Oracle SQL and PL/SQL
Oracle
Skills
Libraries/APIs
Segment.io, PySpark, Pandas, NumPy, Shopify API
Tools
IBM InfoSphere (DataStage), Microsoft Report Builder, Cloudera, Oozie, Impala, Flume, Informatica PowerCenter, Tableau, Informatica ETL, BigQuery, Stitch Data, Apache Impala, Microsoft Excel, Excel 2016, Microsoft Power BI, Apache Airflow, Google Analytics, Zapier, Spark SQL, Ansible, Looker, Shell
Languages
SQL, Python, Stored Procedure, Transact-SQL (T-SQL), Python 3, Snowflake, Excel VBA
Frameworks
Hadoop, Apache Spark, Spark
Paradigms
ETL, Business Intelligence (BI), ETL Implementation & Design, Database Design, Oracle Database Architecture, Database Development, Management, ITIL
Platforms
Apache Kafka, Linux, Oracle, Windows, Google Cloud Platform (GCP), Amazon Web Services (AWS), Amazon EC2, Azure, Databricks, Microsoft, Shopify, Docker, Debezium
Storage
Oracle Database Tuning, Oracle PL/SQL, Database Architecture, Oracle DBA, Apache Hive, Data Lakes, Database Modeling, Databases, SQL Stored Procedures, Oracle SQL, Oracle 12c, PostgreSQL, PL/SQL, Datastage, Google Cloud SQL, HDFS, PostgreSQL 10, Data Pipelines, Oracle 10g, Amazon S3 (AWS S3), Data Integration, Database Administration (DBA), SQL Functions, SQL Triggers, Database Replication, SQL Server Integration Services (SSIS), MySQL, Microsoft SQL Server, Neo4j, Oracle Cloud, SQL Server Reporting Services (SSRS), Relational Databases, Redshift, Druid.io, JSON
Industry Expertise
Project Management
Other
ETL Development, Big Data, Informatica, MSAS, Data Engineering, Scripting, Data Warehousing, Big Data Architecture, Data Reporting, Database Optimization, Query Optimization, Google BigQuery, Reporting, Informatica Cloud, Segment, ETL Tools, Drip Email, Data Modeling, Data Architecture, Data, Data Warehouse Design, Data Analytics, Amazon RDS, Data Transformation, Message Queues, APIs, Customer Data Platform (CDP), ELT, Data Analysis, Data Processing, Data Visualization, Performance Tuning, Dashboards, ETL Pipelines, Data Build Tool (dbt), Tableau Server, Administration, Looker Studio, GraphDB, eCommerce, Apache Flume, NetSuite, CI/CD Pipelines, Amazon API Gateway, Oracle R, Oracle Backups, Import/Export, Shell Scripting, Optimization, Oracle Data Guard, Oracle RMAN
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