Olgierd is available for hire

Olgierd Michalak

Verified Expert in Engineering

Data Science and BI Developer

Location

Warsaw, Poland

Toptal Member Since

June 17, 2020

Olgierd specializes in data analytics, data science, and data engineering on Google Cloud using Python. He is well-versed in business and finance concepts and can build data processing and analytics solutions that fit well with the overall business and finance strategies. Faced with complexity, uncertainty, risk, volatility, and ambiguity, he turns to Agile. Recently, he worked on developing data processing pipelines for data warehouses, analytics, ML, and reporting.

Data Analysis Data Visualization Data Reporting Data Engineering Data Mining Linear Regression Machine Learning Statistics Time Series Analysis SQL Business Intelligence (BI)Python Scikit-learn Pandas ETL StatsModels

Portfolio

Self-employed

Management Accounting, Financial Data Analytics, Financial Market Data, Trading...

Accenture

Banking & Finance, Agile Business Analytics, Financial Markets, Finance

Goldman Sachs

Business Intelligence (BI), Data Analysis, Data Reporting, SQL...

Experience

Agile Business Analytics - 20 years Business Intelligence (BI) - 20 years Financial Data Analytics - 20 years Data Engineering - 20 years Python - 15 years Predictive Modeling - 10 years Data Science - 10 years Financial Markets - 5 years

Availability

Part-time

Preferred Environment

Financial Markets, Banking & Finance, Data Science, Google Cloud Platform (GCP), Machine Learning, Business Intelligence (BI), Analytics, Python, Finance, Google Cloud

The most amazing...

...project that I've worked on was using macro-economic and financial markets data to support my client's investment decisions.

Work Experience

Data Analytics, Science and Engineering Consultant

2018 - PRESENT

Self-employed

Performed data engineering tasks for BMW, Nestle, and H&M (with HCL and TCS).
Built end-to-end data pipelines, analytical models, and dashboards to help make better investment decisions (for a Family Office).
Performed financial data analyses, and designed and back-tested trading strategies (for a client via Toptal).
Analyzed market prices for electricity, and prepared trading strategies for the Kyoto Group.
Back-tested various hypotheses from quantitative research papers for the hedge fund, Two Sigma.
Worked on data analytics workflows for the real estate entity, JLL.
Prepared ML models for recommendations for the recruitment group, Censia.

Technologies: Management Accounting, Financial Data Analytics, Financial Market Data, Trading, Financial Reporting, Data Analysis, Data Reporting, SQL, Time Series Analysis, Quantitative Finance, Banking & Finance, Agile Business Analytics, Data Science, Google BigQuery, Predictive Modeling, Machine Learning, Gradient Boosted Trees, Pandas, Analytics, Python, NumPy, Data Visualization, Statistics, Scikit-learn, Financial Markets, SciPy, StatsModels, Matplotlib, Data Mining, PySpark, Quantitative Analysis, Plotly, Finance, Business Intelligence (BI), Linear Regression, Logistic Regression, Dimensional Modeling, ETL, Financial Analysis, Financial Modeling, Data Engineering, Google Cloud, Google AI Platform, Google Cloud ML, Looker

Consultant

2017 - 2017

Accenture

Prepared the business and technical design plans for the bank liquidity risk management and stress testing for Nordea (banking).
Analyzed alternative software solutions for the bank's financial stress testing for Nordea,.
Assisted in the analysis of proposed solution for the bank's IRRBB for Nordea.

Technologies: Banking & Finance, Agile Business Analytics, Financial Markets, Finance

Risk Analytics Associate

2015 - 2016

Goldman Sachs

Created visualizations in Tableau, specifically in the area of information security.
Processed data in PySpark, specifically in the area of information security.
Gave presentations on data science and machine learning with Python tools.

Technologies: Business Intelligence (BI), Data Analysis, Data Reporting, SQL, Banking & Finance, Data Science, Predictive Modeling, Machine Learning, Gradient Boosted Trees, Pandas, Analytics, Python, NumPy, Data Visualization, Statistics, Scikit-learn, SciPy, Matplotlib, Data Mining, PySpark, Quantitative Analysis, Agile Business Analytics, Finance, Logistic Regression, Dimensional Modeling, Financial Reporting, Data Engineering

Business Intelligence Consultant

2014 - 2015

Self-employed

Helped prepare the PoC Tableau-based analytical solution for Lloyds Banking Group with Capgemini Financial Services UK.
Gave presentations to Lloyds on the PoC solution and Tableau.
Delivered training sessions on Tableau to Capgemini consultants.

Technologies: Financial Data Analytics, Business Intelligence (BI), Financial Reporting, Data Analysis, Data Reporting, SQL, Banking & Finance, Agile Business Analytics, Management Accounting, Predictive Modeling, Machine Learning, Gradient Boosted Trees, Pandas, Analytics, NumPy, Data Visualization, Statistics, Scikit-learn, Financial Analysis, SciPy, StatsModels, Matplotlib, Linear Regression, Logistic Regression, Quantitative Analysis, Finance, Data Science, Financial Markets, Python, Dimensional Modeling, ETL, Financial Modeling, Financial Market Data, Data Engineering

Business Intelligence Architect

2011 - 2013

Soft Computer Consultants

Evaluated several BI technologies and recommended the ones that best fit in with the company strategy.
Designed data warehouse dimensional models and built data marts.
Prepared financial dashboards and analyses with Tableau.

Technologies: Business Intelligence (BI), Financial Reporting, Data Analysis, Data Reporting, ETL, SQL, Analytics, Python, Data Visualization, Statistics, Dimensional Modeling, Quantitative Analysis, Agile Business Analytics, Finance, Data Science, Financial Markets, Management Accounting, Predictive Modeling, Machine Learning, Logistic Regression, Financial Analysis, Financial Modeling, Data Engineering

Reporting and Data Warehouse Analyst

2008 - 2010

Toyota Bank Polska

Prepared over 200 management and operational reports for the bank departments, including accounting,. treasury, marketing, sales, and debt collection.
Designed and built data warehouse data models with management-oriented data marts for ad-hoc reporting. and analyses.
Helped coordinate continuous improvement (Kaizen) activities.

Technologies: Financial Data Analytics, Business Intelligence (BI), Financial Reporting, Data Analysis, Data Reporting, ETL, SQL, Banking & Finance, Management Accounting, Financial Modeling, Analytics, Python, Data Visualization, Statistics, Financial Analysis, Dimensional Modeling, Data Mining, Linear Regression, Logistic Regression, Quantitative Analysis, Agile Business Analytics, Finance, Data Science, Financial Markets, Predictive Modeling, Machine Learning, Financial Market Data, Data Engineering

Business Intelligence Consultant

2004 - 2007

Freelance

Performed business analysis and helped create a project plan for a. financial data warehouse for KBC (banking and insurance).
Helped build and test a data warehouse for TPSA (Telecommunications; now Orange), with Bull (now ATOS /IT Consulting).
Helped manage the development for eCommerce site to sell electronics and ship them from warehouses directly to customers (the site was later acquired by HP) for PageComputer (internet retailer).
Led the business analysis for the data warehouse to support the monitoring and control of state-wide electric grid for PSE (electricity transmission system operator), with InfoVide.
Helped performed business analysis for the client data warehouse for Vattenfall (Electricity), with InfoVide (IT consulting; now Asseco).

Technologies: Financial Data Analytics, Business Intelligence (BI), Financial Reporting, Data Analysis, Data Reporting, ETL, SQL, Banking & Finance, Agile Business Analytics, Management Accounting, Python, Financial Analysis, Dimensional Modeling, Quantitative Analysis, Finance, Data Science, Financial Markets, Statistics, Data Visualization, Financial Modeling, Analytics, Data Engineering

Programmer | Business Analyst

2000 - 2003

Soft Computer Consultants

Created a PoC solution of a BPM using dynamic HTML (Ajax did not existed them) and PHP.
Programmed parts of the system in JavaScript and Java.
Synchronized MS Projects with the company internal project management system.

Technologies: Business Intelligence (BI), Financial Reporting, Data Reporting, SQL, Quantitative Analysis, Agile Business Analytics, Data Analysis, Management Accounting, Python, Data Visualization, Dimensional Modeling, ETL, Financial Analysis, Financial Modeling, Analytics, Data Engineering

Programmer | Business Analyst

1997 - 1999

American Management Systems

Helped build a PoC solution for a new telecommunications system.
Programmed the Customer Relationship Management modules of the system.
Created ETL procedures to migrate the customer data.

Technologies: Business Intelligence (BI), Data Analysis, ETL, SQL, Quantitative Analysis, Analytics, Data Engineering

Programmer

1996 - 1997

SoftSystem

Documented business requirements for a new accounting application.
Programmed the modules for the new accounting application.
Automated the software integration and testing (now referred to as DevOps).

Technologies: Management Accounting, Financial Reporting, SQL, Data Analysis, Financial Analysis, Financial Modeling, Analytics, Data Engineering

Experience

Predicting Loan Defaults

https://github.com/olgierdmic/Predicting-Loan-Defaults

This repository is about a structured approach to building predictive models for binary classification.
Built a machine learning model that can predict a loan default. The most common data science process steps have been followed, from preparing the data, building a machine learning model, evaluating it, and reporting the results.

Option Pricing with Analytical Formulas and MC Simulations

https://github.com/olgierdmic/Quant-Finance

The notebook shows how to compute the derivative prices using both analytical and stochastic methods. Besides plain vanilla options, calculated with the Black-Scholes-Merton formula, the Asian options' prices are computed with MC simulations.

Financial Risks Management

https://github.com/olgierdmic/Quant-Finance

The notebooks show the valuations of Asian options using analytical and MC simulations and the computations of the probability-of-default metrics used for the regulatory credit risk management in banking, including the Merton structural model, the Black-Cox model, and the Monte Carlo simulation approach.

Education

1990 - 1995

Master of Science Degree in Applied Physics and Math

Warsaw University of Technology - Warsaw, Poland

Certifications

FEBRUARY 2023 - FEBRUARY 2025

Professional Data Engineer

Google Cloud

JANUARY 2020 - PRESENT

Scrum Product Owner Accredited Certification

Scrum Institute

JANUARY 2018 - PRESENT

Certificate in Quantitative Finance

CQF Institute

JULY 2007 - PRESENT

CIMA Diploma in Management Accounting

CIMA (ref. nr 1-1UVWVL)

JULY 2007 - JULY 2012

PMI Certified Associate in Project Management

PMI (CAPM Number 480759)

Skills

Libraries/APIs

Scikit-learn, Pandas, NumPy, SciPy, Matplotlib, PySpark

Tools

StatsModels, Plotly, Looker, Google AI Platform

Languages

SQL, Python

Industry Expertise

Banking & Finance

Paradigms

Data Science, Business Intelligence (BI), ETL, Dimensional Modeling

Storage

Google Cloud

Other

Machine Learning, Data Analysis, Financial Analysis, Financial Markets, Data Visualization, Data Reporting, Financial Reporting, Predictive Modeling, Statistics, Data Mining, Time Series Analysis, Linear Regression, Logistic Regression, Gradient Boosted Trees, Financial Market Data, Financial Data Analytics, Quantitative Analysis, Agile Business Analytics, Data Engineering, Trading, Financial Modeling, Management Accounting, Google BigQuery, Quantitative Finance, Finance, NeuralProphet, Google Cloud ML, Analytics

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.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

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