Tomislav is available for hire

Tomislav Delas

Verified Expert in Engineering

Database Developer

Location

Vinkovci, Croatia

Toptal Member Since

July 16, 2020

Tomislav是一位经验丰富的IT专家，自1996年以来一直在计算机软件行业成功工作. Tomislav的主要专长在于使用Informatica和IBM DataStage ETL开发BI和数据仓库解决方案(包括管理和开发)。. Tomislav also knows his way around SQL and PL/SQL, Tableau visualizations, Oracle database administration (Oracle OCP), big data, cloud databases (Google BigQuery, AWS), and cloud eCommerce.

Portfolio

BCG - Gamma

ETL、数据工程、Python、亚马逊网络服务(AWS)、Apache气流...

Squeem, LLC

Big Data, Data Engineering, Data Lakes, Data Warehousing, ETL...

Croatian Telekom

Apache Spark, Apache Impala, HDFS, Apache Kafka, Apache Flume, Apache Hive...

Experience

ETL Development - 20 years Data Modeling - 20 years Database Architecture - 20 years SQL - 20 years Database Design - 20 years Oracle - 20 years PostgreSQL - 10 years Big Data - 4 years

Availability

Part-time

Preferred Environment

Amazon Web Services (AWS), Google Cloud Platform (GCP), ETL, Linux, Oracle, Python, Databases, Tableau, Big Data, SQL

The most amazing...

...20年前，我和一个核心团队建立了一家电信公司的第一个内部数据仓库，后来又建立了他们的第一个大数据环境.

Work Experience

Data Engineer

2020 - 2023

BCG - Gamma

开发ETL管道(Python，气流)喂养流失管理和保留活动.
Conducted many data engineering tasks regarding data ingestion, data quality, and data fixes on source and target systems.
完成MySQL和PostgreSQL数据库的管理和优化任务.
Configured Docker infrastructure for the solution landscape.
在数据工程领域为项目招募了许多新的团队成员，并组织了许多技术研讨会.
开发用于数据管理和数据修复过程的SQL管道.

Technologies: ETL、数据工程、Python、亚马逊网络服务(AWS)、Apache气流, Redshift, Snowflake, PostgreSQL, MySQL, Azure, Docker, Oracle, Data Warehousing, Business Intelligence (BI), Database Optimization, Database Architecture, Database Design, PySpark, Oracle 10g, Amazon S3 (AWS S3), Amazon RDS, Data Transformation, Database Development, Data Modeling, ELT, Data Analysis

Data Architect

2020 - 2020

Squeem, LLC

在Google BigQuery上开发数据模型，用于Sales的市场分析.
Completed ETL pipelines (Stitch ETL SW) from Shopify, Drip, Netsuite, 和Google Analytics对BigQuery开发的数据仓库模型.
Developed complex Tableau reports for Sale tracking.
Stored procedures in Google BigQuery for data transformation.

技术:大数据、数据工程、数据湖、数据仓库、ETL、ETL实施 & 设计，大数据架构，数据仓库设计，数据报告，数据分析，细分.io, Shopify API, Amazon API Gateway, NetSuite, Tableau, Google BigQuery, BigQuery, Business Intelligence (BI), Database Optimization, Google Analytics, Database Architecture, Database Design, Tableau Server, Shopify, Drip Email, Data Transformation, Database Development, Data Modeling, ELT, Data Analysis

IT Solution Architect

2018 - 2020

Croatian Telekom

推出了第一个从客户现场或客户提供的设备(CPE)到Cloudera大数据服务的实时数据收集.
Tuned Informatica PowerCenter ETL for data warehousing, tuning, 并优化Spark流实时流程，以实现预测和主动故障解决.
将数据仓库环境扩展到Cloudera Big data，在Cloudera的Spark引擎上进行数据归档和ETL处理.

Technologies: Apache Spark, Apache Impala, HDFS, Apache Kafka, Apache Flume, Apache Hive, Oracle, Datastage, Informatica, Big Data, Cloudera, Data Warehousing, Database Optimization, Oracle PL/SQL, Database Architecture, Database Design, Oracle SQL, Query Optimization, Oracle Database Architecture, Oracle 10g, Data Transformation, Database Development, Data Modeling, ELT, Data Analysis

Head of IT Data Warehousing and Business Intelligence Section

2016 - 2018

Hrvatski Telekom

引领大数据融入数据仓库(全新数据仓库架构).
接管了数据仓库环境移动栈的开发和运营.
调整了IBM DataStage ETL进程和Oracle数据仓库(DWH)数据库.
使用可视化工具(Power BI)在移动设备上开发警报流程.

Technologies: Windows, Linux, Datastage, Microsoft Power BI, Informatica PowerCenter, Microsoft, Oracle, Data Warehousing, ETL, Business Intelligence (BI), Database Optimization, Microsoft SQL Server, Oracle PL/SQL, Database Architecture, Database Design, Oracle SQL, Query Optimization, Oracle Database Architecture, Oracle 10g, Data Transformation, Database Development, Data Modeling, ELT, Data Analysis

Head of Database Administration, Apps, & Service Support Work Unit in Information Systems Operations

2010 - 2016

Hrvatski Telekom

领导开发用于监控OSS/BSS电信系统之间的端到端(E2E)消息通信的IT操作门户网站.
Tuned many OLTP operational Oracle databases in the company, which resulted in quicker and smoother applications.
作为收入保障项目的核心团队成员，负责接口工作, overall architecture solution, and development of some parts of the solution.

Technologies: Windows, Linux, Informatica, Microsoft, PL/SQL, SQL, PostgreSQL, Oracle, Database Optimization, Microsoft SQL Server, Oracle PL/SQL, Database Architecture, Database Design, Oracle SQL, Query Optimization, Oracle Database Architecture, Oracle 10g, Data Transformation, Database Development, Data Modeling, ELT, Data Analysis

T-HT IT商业智能(BI)开发和运营团队负责人

2003 - 2009

Hrvatski Telekom

在公司中引入了一个新的数据仓库解决方案，同时还担任了首席解决方案架构师和开发人员.
Developed ETL processes and many custom interfaces.
Made many OLAP cubes (Microsoft Analysis tools), reports (ad-hoc SQL and Microsoft Reporting Services).

Technologies: Windows, Linux, Informatica, Microsoft, PL/SQL, SQL, PostgreSQL, Oracle, Data Warehousing, ETL, Business Intelligence (BI), Database Optimization, Oracle PL/SQL, Database Architecture, Database Design, Oracle SQL, Oracle Database Architecture, Oracle 10g, Database Development, Data Modeling, ELT, Data Analysis

某地区电信中心(武科瓦尔)IT部部长

1996 - 2000

Hrvatski Telekom

Developed the 1st company-wide data warehousing environment.
领导开发和运营IT团队，处理所有IT区域流程和解决方案.
Oversaw and monitored all operational processes in IT.

Technologies: Reporting, Informatica PowerCenter, Linux, Oracle, Database Optimization, Database Design, Oracle SQL, Oracle Database Architecture, Oracle 10g

Experience

Smart Churn Retention Solution

http://www.bcg.com/en-hu/industries/technology-media-telecommunications/telecommunications-industry

A project charged with developing and deploying DEEP.AI, a B2C personalization tool for up-selling and cross-selling, retention, 以及波士顿咨询集团(BCG)的债务管理软件。, 针对波士顿咨询公司在电信和能源领域的客户.

As a member of an international team and a Toptal member, I participated in the retention stream of DEEP.AI. 我被分配了各种数据工程和其他任务:数据管道, 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.com

我为一家Squeem公司/品牌(作为Toptal客户)创建了解决方案，并开发了客户数据平台。, running an eCommerce business.

My Project Tasks:
• Analyzed Cloud ETL tools for data pipelines (Skyvia, Stitch, Hevo, 以及云数据仓库解决方案(Google Big Query), Snowflake, Amazon Redshift, etc.) in the selection process.
•实现数据管道(ETL)的创建与Stitch云ETL从源应用程序(Shopify), Drip, Oracle NetSuite, Google Ads, Google Analytics, 和Facebook广告)到云Google BigQuery数据湖和数据仓库.
• Transformed data on BigQuery (SQL and ETL procedures).
• Visualized with Tableau on top of BigQuery datasets.
•通过细分软件处理数据丰富(事件和人物角色).

Data Warehousing Project with Big Data

我在电信业务中开发了新一代的数据仓库，使用Cloudera服务(HDFS)合并了一个大数据湖, Hive, Impala, and Spark) for extract-transform-load (ETL) using Spark, utilizing the power of big data infrastructure.

Revenue Assurance Project

I built a revenue assurance solution for a telco business. 我是主要的IT解决方案架构师和解决方案某些部分的开发人员, 我开发了不同系统和监控过程之间的接口.

Proactive Care

一个实时数据驱动的项目，从DSL客户设备(CPE)收集数据并摄取到大数据(使用Kafka), Flume, Hive, Spark, and Oozie).

我是这个项目的核心团队开发人员，负责接口和解决方案调优. 该项目用于电信公司的主动故障修复，并集成到OSS的日常流程中.

Data Warehousing Solution for a Big Telco Provider

I handled the architecture, solution, development, and operation of a DWH solution for a Telco provider. I was responsible for relational databases (Oracle DBA), ETL processes (Informatica and PL/SQL), data quality, reporting (Microsoft tools and Power BI), etc.

大型电信供应商的数据仓库解决方案(移动服务)

I handled the architecture, solution, development, and operation of a DWH solution for a Telco provider. I was responsible for relational databases (Oracle DBA), ETL processes (IBM DataStage and PL/SQL), data quality, reporting (IBM tools and Power BI), etc.

Education

2001 - 2003

Master's Degree in Computer Science

University of Zagreb - Zagreb, Croatia

1990 - 1995

Engineer's Degree in Electrotechnics

University of Zagreb - Zagreb, Croatia

Certifications

DECEMBER 2021 - DECEMBER 2024

AWS Certified Cloud Practitioner

Amazon Web Services

JUNE 2020 - PRESENT

Training: Spark and Python for Big Data with PySpark

Udemy

JUNE 2020 - PRESENT

Training: Informatica Cloud Data Integration

Udemy

NOVEMBER 2019 - PRESENT

Training: Apache Spark

Croz d.o.o. Croatia

SEPTEMBER 2019 - PRESENT

Training: Apache Kafka Security

Udemy

SEPTEMBER 2019 - PRESENT

Training: Apache Kafka Series — Kafka Security

Udemy

AUGUST 2016 - PRESENT

Training: IBM DataStage Development

Poslovna Inteligencija d.o.o. Zagreb

APRIL 2009 - PRESENT

Training: Microsoft Reporting and Analysis Services

Croatian Telekom (Internal)

APRIL 2008 - PRESENT

Training: PowerCenter 8.5 New Features for Administrator Training

Informatica

OCTOBER 2007 - PRESENT

Training: PowerCenter 8 Developer Training

Informatica

MARCH 2007 - PRESENT

培训:基于成本的优化，索引策略和解释计划

Oracle

JUNE 2006 - PRESENT

Oracle Certified Professional

Oracle

APRIL 2006 - PRESENT

Training: ITIL Foundation for IT Service Management

HP Education Services

MARCH 2006 - PRESENT

Training: 6 Sigma — Project Management Advanced

Next Level Consulting

MARCH 2006 - PRESENT

Training : 6 Sigma — Project Management Leadership

Next Level Consulting

FEBRUARY 2006 - PRESENT

Training: 6 Sigma — Project Management Basics

Next Level Consulting

OCTOBER 2003 - PRESENT

Training: Executive Management Qualifier

Graduate School of Business Administration Zurich

JUNE 2002 - PRESENT

Training: General Management Qualifier

Graduate School of Business Administration Zurich

OCTOBER 1997 - PRESENT

Training: Oracle SQL and PL/SQL

Oracle

Skills

Libraries/APIs

Segment.io, PySpark, Pandas, Shopify API

Tools

IBM InfoSphere (DataStage), Microsoft Report Builder, Cloudera, Oozie, Impala, Flume, Informatica PowerCenter, Tableau, Informatica ETL, BigQuery, Stitch Data, Apache Impala, Microsoft Power BI, Apache Airflow, Google Analytics, Ansible

Frameworks

Hadoop, Apache Spark, Spark

Languages

SQL, C, Python, Stored Procedure, C++, Python 3, Snowflake

Paradigms

ETL, Business Intelligence (BI), ETL Implementation & 设计，数据库设计，Oracle数据库架构，数据库开发，管理，ITIL

Platforms

Apache Kafka, Linux, Oracle, Windows, Google Cloud Platform (GCP), Amazon Web Services (AWS), Amazon EC2, Microsoft, Shopify, Azure, Docker

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, SQL Server Integration Services (SSIS), MySQL, Microsoft SQL Server, NoSQL, Oracle Cloud, SQL Server Reporting Services (SSRS), Relational Databases, Redshift

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, Tableau Server, Administration, eCommerce, Apache Flume, NetSuite, CI/CD Pipelines, Amazon API Gateway

Collaboration That Works

How to Work with Toptal

在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.

Share your needs

在与Toptal领域专家的电话中讨论您的需求并细化您的范围.

Choose your talent

在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.

Start your risk-free talent trial

与你选择的人才一起工作，试用最多两周. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring