Cloud Data Engineer At Organon (07/2024 - current)

• Various  Snowflake data engineering projects at Organon

• E2E development of Snowflake data pipelines

• Data Mesh approach, data vault 2.0 methodology

• Stack: Snowflake, Informatica Intelligent Cloud Services, AWS S3, Coalesce for Data Vault modeling, Bitbucket for versioning

• Working primarily with SAP S4 & SAP IBP data sources.

Cloud Data Engineer At McKinsey & Company (05/2021 - 08/2024)
  • Migrated firm’s on-premise DWH to the cloud using Snowflake and AWS.
  • Rewrote on-premises data pipelines built in IBM DataStage, Snaplogic, and Informatica into AWS + Snowflake stack.
  • Acted as Snowflake Subject Matter Expert (SME).
  • Developed end-to-end ETL/DWH processes leveraging SQL and PySpark (AWS Glue).
  • Implemented Snowflake procedures for automation of ETL framework.
  • Presented deliverables to stakeholders at the end of each sprint.
  • Implemented various Snowflake and AWS PoCs.
  • Worked within an agile development lifecycle (SCRUM).
  • Snowflake, Python, PySpark, and AWS tools.
Cloud Data Engineer At McKinsey & Company (07/2020 - 05/2021)
  • Migrated firm’s on-premise DWH to the cloud using Snowflake and AWS.
  • Rewrote on-premises data pipelines built in IBM DataStage, Snaplogic, and Informatica into AWS + Snowflake stack.
  • Acted as Snowflake Subject Matter Expert (SME).
  • Developed end-to-end ETL/DWH processes leveraging SQL and PySpark (AWS Glue).
  • Implemented Snowflake procedures for automation of ETL framework.
  • Presented deliverables to stakeholders at the end of each sprint.
  • Implemented various Snowflake and AWS PoCs.
  • Worked within an agile development lifecycle (SCRUM).
  • Snowflake, Python, PySpark, and AWS tools.
BI/DWH Consultant At Raiffeisenbank (04/2019 - 07/2020)
  • Involved in BI/DWH analysis and development across various projects.
  • Analyzed business requirements and implemented them into the data warehouse (DWH).
  • Designed and developed ETL processes and handled the design and documentation of the DWH.
  • Developed Oracle SQL and PL/SQL scripts, and performed SQL query performance tuning and monitoring.
  • Responsible for data and process modeling using SAP PowerDesigner.
  • Conducted QA, regression, and functional testing.
  • Created mappings and workflows in ETL Informatica PowerCenter.
  • Worked on high-profile projects including IDD, MIFID, GDPR, and ApplePay.
  • ORACLE 11g/12c, SAP PowerDesigner, Informatica PowerCenter, SQL, PL/SQL, Perforce, and VBA.
BI/Data Analyst At Allianz Partners (08/2018 - 05/2019)
  • Responsible for data analysis, reporting, and data visualization in the insurance and assistance services sectors.
  • Performed T-SQL query performance tuning on SQL Server to ensure optimal database performance.
  • Implemented tools for profitability reporting and developed data warehouses (DWH) with a focus on data cleansing and ETL design.
  • Conducted thorough analysis and evaluation of the profitability of various business segments.
  • Carried out actuarial and statistical analyses according to company standards.
  • Provided data to different departments within the company.
  • Participated in the implementation of a new green field DWH.
  • T-SQL, MS SQL Server, MS PowerQuery, MS PowerMap, MS Excel 2016, MS SSRS, and MS SSIS.
BI Consultant at Adastra (06/2017 - 08/202018)
  • Participated in external projects focusing on data warehousing, reporting, business intelligence, and IT support.
  • Provided application support and monitoring at Česká spořitelna, ensuring smooth operation of various systems.
  • Gathered business requirements for dashboard design and implemented dashboards for performance analysis of applications and core information systems.
  • Performed requirement analysis and became well-oriented in the customer’s business processes.
  • ORACLE, Dynatrace Appmon & UEM for performance monitoring, SAP PowerDesigner, and MS Power-BI.