SERTUG SERKAN GUZEL
Istanbul
Summary
Data Engineer with strong mathematical, statistical background, and with experience in
machine learning algorithms, data processing, ETL / ELT pipeline building to solve
challenging business problems. Also, achieved a B.Sc. degree in Economics and M.Sc. Economics in University Jena.
Overview
4
4
years of professional experience
Work History
Data Engineer
DFDS
08.2023 - Current
- Creating ETL packages on on-prem servers in line with user demands and preparing
views that will constitute the sources of Tableau reports. - Maintenance and performance improvements of SQL Server jobs and SSIS packages.
- Migrated existing on-premises ETL solutions to the Amazon cloud environment and created new data solutions using Apache Airflow for orchestration, Amazon Redshift for data warehousing, and dbt for data transformation.
- Involved in a migration project from Tableau to Power BI, including transforming views and cubes to semantic models to enhance data visualization and reporting capabilities.
- Created Azure Logic Apps to monitor refresh records and refresh durations of Power BI semantic models.
DATA ENGINEER
BORUSAN ARAÇ İHALE
10.2022 - Current
- Developing Azure Datawarehouse for holding historical data
- Data migration from on-premise sources
- Developing ETL pipelines for batch and streaming processing using Azure Datafactory
- Using Azure Synapse to monitor Triggers, ETL pipelines and control remaining analytical services
- Building Power BI reports, dashboards to create business insight
DATA SCIENTIST
BORUSAN ARAÇ İHALE
04.2021 - 09.2022
- Developing a Machine Learning algorithm for car price estimation using Python
- Bringing in new attributes (Data) to the existing SQL database
- Daily/weekly/monthly analysis/reporting of price trends
- Daily/weekly/monthly analysis/reporting of advertisement and website traffic data using Google Analytics
- Automating the processes of obtaining data from the database, data processing and data visualization with Power BI, in line with the demands of various departments of the company
- Designing dashboards on Service and Mobile App screens
RESEARCH ASSISTANT
UNIVERSITY OF JENA
02.2021 - 07.2021
- Participated in a project which is funded by a private organization
- Within the scope of the project, data extraction from websites and raw data processing were carried out with the web scraping method
- An algorithm was written to extract and compile sentences containing certain keywords from more than 1000 academic articles within the scope of the data obtained
Education
Master of Science - Economics
Friedrich Schiller University of Jena
Jena, Germany03-2021
Bachelor of Science - Economics
Istanbul University
Istanbul, Turkey02-2018
Skills
- ETL development
- Data warehousing
- Data modeling
- Data migration
- Data Processing
- MS SQL
- Python
- Apache Airflow
- Amazon Redshift
- DBT (Data Build Tool)
- Azure Synapse
- Azure Data Factory
- Power BI
- SSIS
- Web Scraping
Languages
Turkish
Native language
German
Intermediate
B1
Timeline
Data Engineer
DFDS
08.2023 - Current
DATA ENGINEER
BORUSAN ARAÇ İHALE
10.2022 - Current
DATA SCIENTIST
BORUSAN ARAÇ İHALE
04.2021 - 09.2022
RESEARCH ASSISTANT
UNIVERSITY OF JENA
02.2021 - 07.2021
Master of Science - Economics
Friedrich Schiller University of Jena
Bachelor of Science - Economics
Istanbul University