Cloud Data Engineer

• May 2021 - Present

• Client: McKinsey & Company (Project Cloud Data Platform)• Migration of firm's on-premise DWH fully into Cloud leveraging Snowflake and AWS Tools/technologies (namely Lambda, Glue jobs & Snowflake stored procedures for ETL development, WhereScape 3D for modeling, DocumentDB as NoSQL DB for API consumption, ElasticSearch, AirFlow for job orchestration, S3 as firm's data lake)• Rewriting on-premises data pipelines written in IBM DataStage, Snaplogic, and Informatica utilizing a completely different tech stack• E2E ETL/DWH development utilizing Snowflake stored procedures and ETL scripts written in AWS Glue (PySpark)• Implementing various SF Javascript procedures for automation of ETL and migration jobs.• Showing deliverables to the stakeholders after the end of each sprint• Implementing various PoCs on the AWS databases (Aurora ..) and AWS tools to design the best possible solution based on the firm's enterprise needs and requirements.• Agile development lifecycle (SCRUM)• AWS tools: Glue, S3, ElasticSearch, DocumentDB, Lambda, MSK• Other technologies/tools/languages used: Snowflake, WhereScape 3D, WhereScape RED, Python, PySpark, SQL. Show less

Data Engineer

• Jul 2020 - Jun 2021

• Client: McKinsey & Company (Project Modern Analytics Platform)• Agile development of the new firm's IT Data Mart in Snowflake on AWS• Data Integration of various RDBMs & RESTful services• Data Vault 2.0 DWH architecture model• ETL development in WhereScape RED & JetBrains DataGrip• ELT development in SnapLogic (Landing data in firm's data lake on AWS S3)• Data modeling in WhereScape 3D• Engineering Snaplogic pipelines for data extraction from various REST API and RDBM sources into firm's Data Lake on AWS S3 • Integrating data from ServiceNow, JIRA, SonarQube, GoCD, Qualtrics, Miro, Box, MobileIron, and other sources• Tableau & MS Power-BI for reporting,• Agile development lifecycle (SCRUM)• Showing deliverables to the stakeholders after end of each sprint• Technical support to DWH end-users Show less

BI Consultant

• Apr 2019 - Jul 2020

• BI/DWH analysis and development on projects in Raiffeisenbank • Analysis of business requirements and implementation in DWH • ETL design and development • DWH design and documentation • ORACLE SQL and PL/SQL development • SQL query performance tuning and monitoring • Data and process modeling in SAP PowerDesigner • QA, regression and functional testing • Creation of mappings and workflows in ETL Informatica PowerCenter • Alocation on projects like IDD (Insurance Distribution Directive), MIFID (The Markets in Financial Instruments Directive), GDPR, ApplePay and more • Technologies: ORACLE 11g/12c, SAP PowerDesigner, Informatica PowerCenter, SQL, PL/SQL, Perforce, VBA Show less

BI / Data Analyst

• Aug 2018 - Jun 2019

• Data analysis, reporting and data visualization in the areas of insurance and assistance services • T-SQL query performance tuning on SQL Server • Implementation of the tool for profitability reporting • DWH development (Data cleansing, ETL design) • Analysis and evaluation of the profitability of business segments • Realization of actuarial and statistical analyzes according to company standards • Providing data to various departments within the company • Participation in internal green field DWH implementation • Technologies: T-SQL, MS SQL Server, MS PowerQuery, MS PowerMap, MS Excel 2016, MS SSRS, MS SSIS Show less

BI Consultant

• Jun 2017 - Aug 2018

• Participation in external projects for the companies mainly in the field of data warehousing, reporting, business intelligence and IT Support • Application support and monitoring in Česká spořitelna (IT Support team) • Gathering business requirements for dashboard design • Implementing dashboards for the performance analysis of various applications and core information systems in ČS • Requirement analysis • Orientation in the customer's business processes • Technology: ORACLE, software Dynatrace Appmon & UEM - performance monitoring, SAP PowerDesigner, MS Power-BI. Show less

IT Technician

• Dec 2014 - May 2015