Karol Tarcak, Developer in Zürich, Switzerland
Karol is available for hire
Hire Karol

Karol Tarcak

Verified Expert  in Engineering

Software Developer

Location
Zürich, Switzerland
Toptal Member Since
July 6, 2017

With a master's degree in mathematics and several years of professional experience as a software developer, Karol combines the insight of a data scientist with the skills of a pragmatic engineer. Where Karol excels is on projects requiring expertise in databases, Teradata, SQL, and Python. Karol is the type of person who constantly seeks out new and diverse working environments to solve new data puzzles.

Portfolio

Snowflake
Snowflake
Freelance
Apache Airflow, API Integration, Architecture, Azure, NumPy, SciPy...
Teradata
RStudio Shiny, SciPy, Pandas, R, Teradata Aster, Linux, Bash, Python, Teradata...

Experience

Availability

Part-time

Preferred Environment

Git, Vim Text Editor, Linux, Jupyter

The most amazing...

...thing was when I created few scripts which are still running as the core scheduling scripts in one of the most advanced finance data warehouses.

Work Experience

Solutions Architect

2022 - PRESENT
Snowflake
  • Helped clients build up their ML Ops on Snowflake, from the first ML use case to building up their team.
  • Supported clients on their whole Snowflake journey from onboarding to data mesh.
  • Migrated clients onto new Snowflake accounts and regions.
Technologies: Snowflake

Analytics Consultant

2017 - 2022
Freelance
  • Performed a migration to a new big data platform. Implemented a new what-if scenario engine for FMCG, reviewed and guided automatization of whole data and DQ pipeline.
  • Analyzed IoT sensor data. Did an exploration analysis of water pump operation data and developed and tested the machine learning model.
  • Created a crawling infrastructure and designed the whole architecture of the solution as infrastructure as code on AWS.
Technologies: Apache Airflow, API Integration, Architecture, Azure, NumPy, SciPy, You Only Look Once (YOLO), Keras, TensorFlow, Amazon Web Services (AWS), Google Cloud Platform (GCP), PySpark, SQL, Selenium, PostgreSQL, Shell, Python, Cloud, Git, CI/CD Pipelines, R, REST, Flask, Data Engineering, Big Data, Databricks, ETL, Good Clinical Practice (GCP), Data Science

Consultant

2014 - 2017
Teradata
  • Implemented loading frameworks and crawlers to scrap multiple sources, data models, extensions, and tools used on projects.
  • Answered analytical questions about customer data in logistics, utility, retail, and insurance sectors.
  • Managed and led the offshore team and a mixed client and Teradata team.
  • Worked for customers in CH, DE, DK, and PL (EMEA-based).
  • Received the Teradata Consulting Excellence Award in 2016.
Technologies: RStudio Shiny, SciPy, Pandas, R, Teradata Aster, Linux, Bash, Python, Teradata, SQL, Amazon Web Services (AWS), Flask, Integration, Cloud, APIs, Scraping, Web Scraping, Data Engineering, PySpark, Big Data, ETL, Data Science

Consultant

2010 - 2014
Profinit
  • Implemented scheduling solutions, integration layers, automated testing suites, metadata replication tools, and security marts.
  • Prepared architecture analyses and data quality reports.
  • Managed and led a mixed client and Profinit team.
  • Prepared technology training sessions and interviewed candidates for vacant positions.
  • Worked as an external analyst and developer at Komercni banks.
  • Acted as an external analyst and developer at Telefonica O2 CZ.
  • Led the team and worked as an analyst at ING Pojistovna.
  • Acted as an external data warehouse consultant at Ceska Pojistovna.
Technologies: Informatica PowerExchange, Informatica PowerCenter, Oracle, Microsoft SQL Server, Windows PowerShell, Python, Teradata, SQL, Integration, APIs, Scraping, Web Scraping, Data Engineering, Big Data, ETL

Freelance Developer

2010 - 2010
Freelance Work
  • Developed an extended app to track insolvency claims from government websites.
  • Wrote web-crawler scripts to mimic user behavior and maximizes throughput.
  • Developed small apps for Symbian phones.
  • Wrote dialer scripts for a VoIP solution.
Technologies: PostgreSQL, Python, Amazon Web Services (AWS), API Integration, Flask, Azure, Integration, Cloud, APIs, Scraping, Web Scraping

Scientific Student Assistant

2009 - 2009
Scientific Computing Centre Ulm (UZWR)
  • Modified a tool for computing inverse dynamics bio-mechanical systems.
Technologies: Python

Developer

2008 - 2008
StringData
  • Improved the BINF (banking information system) aimed to replace/simplify the communication between financial institutions and the government.
  • Ported eVypisy (eStatements) from MS SQL to Oracle and to Linux.
Technologies: Oracle, Microsoft SQL Server, PHP, Python, APIs

Student Developer

2007 - 2007
Google Summer of Code
  • Implemented an object/dictionary-oriented session management for web.py.
Technologies: Python

Major Logistics Company

As the technical team lead, I analyzed parcel-tracking data and machine logs and implemented machine strain reports (of parcel sorters) for predictive maintenance. Later, I implemented a parcel recognition system to distinguish soft from hard parcels using deep learning.

Process Analysis and Data Quality for Solvency II for ING CZ

This project's goal was to make the insurance business comply with the EU's Solvency II directive.

As part of a team, I gathered input from different business units, I documented current modeling business processes and prepared a methodology for DQ processes. Later presented reports to the C-level suite and coordinated the effort from the DQ perspective in a multi-company team.

DWH/BI Consulting for Ceska Pojistovna

During a team engagement, I executed a security audit of the current Teradata DWH and subsequently prepared recommendations for improvements.

I created environment duplication scripts (in BTEQ) to replicate the users, databases, and permissions structure from one Teradata system to another.

Pension Fund in Denmark

As part of a team, I analyzed the drivers behind work invalidity events. I created a few models and reports on to illustrate influences of geo-location on the occurrences.

Languages

Python, SQL, Bash, PHP, Fortran, XML, Visual Basic, C, R, Snowflake

Tools

Informatica PowerCenter, Jupyter, Apache Airflow, Teradata Aster, Vagrant, Shell, Vim Text Editor, Informatica PowerExchange, Git, Mercurial, Sybase PowerDesigner, Graphviz, Microsoft Visio, You Only Look Once (YOLO)

Paradigms

ETL, Database Design, Business Intelligence (BI), REST, Good Clinical Practice (GCP), Data Science

Storage

Databases, Teradata, Teradata Databases, Database Migration, PostgreSQL, PL/SQL, JSON, SQLite, Google Cloud, MySQL, Data Lakes, SUSE, Microsoft SQL Server

Other

Data Engineering, Web Crawlers, Data Loading, Scraping, Web Scraping, Big Data, Architecture, Data Modeling, Data Warehouse Design, Requirements & Specifications, Data Analysis, Data Warehousing, Web Services, Data Analytics, Modeling, API Integration, Integration, Cloud, APIs, Logistics, Large-scale Web Crawlers, Data Visualization, SOAP, Bazaar, CI/CD Pipelines

Frameworks

Flask, RStudio Shiny, Windows PowerShell, Selenium

Libraries/APIs

SQLAlchemy, REST APIs, SciPy, Pandas, PySpark, Flask-RESTful, NumPy, Keras, TensorFlow

Platforms

Amazon Web Services (AWS), Linux, Debian Linux, Databricks, Docker, Red Hat Linux, Oracle, Azure, Google Cloud Platform (GCP)

Industry Expertise

Healthcare, Banking & Finance, Insurance

2007 - 2012

Master of Science Equivalent in Numerical Analysis

Charles University in Prague, Faculty of Mathematics and Physics - Prague, Czech Republic

2008 - 2009

Participated in an Erasmus Exchange in Mathematics

University Ulm, Faculty of Mathematics and Economics - Ulm, Germany

2004 - 2007

Bachelor of Science in General Mathematics

Charles University in Prague, Faculty of Mathematics and Physics - Prague, Czech Republic

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