2023 - today: Development of database structures

Role: Business Consultant / BI/DB Consultant

Customer: on request

Tasks:

Development of database structures for regulatory reporting, analysis of business reuqirements.

?

Skills:

Oracle SQL, git

2022 - today: Financial data systems

Role: Data Engineer

Customer: BNP Paribas Consors Finanz

Tasks:

• Focused on enhancing financial data systems from source systems to datamarts, ensuring scalability and consistency. Responsibilities included developing long-term data strategies, performing system analysis, and designing data maps, source systems, data vaults, and warehouses. Actively worked with the WhereScape platform to implement and optimize integration processes.
• Led specialized projects such as datamart creation and securing data models, while collaborating with a broad internal team to deliver robust BI architecture solutions.

Skills:

WhereScape, Data Vault, SQL, Jira, Git

2021 - 2021: EPM/BI Platform

Role: Analyst

Customer: Nexthink SA

Tasks:

• Led the implementation of Oracle PBCS as part of an enterprise performance management (EPM) initiative.
• Responsibilities included designing the solution architecture, providing business consultancy, and managing the development process to ensure successful deployment.
• Delivered a robust BI architecture aligned with organizational planning and reporting needs.

Skills:

Oracle PBCS

2020 - 2021: Implementation of a Know Your Customer

Role: Business Consultant / BI/DB Consultant

Customer: ING Bank

Tasks:

• Supported the implementation of a Know Your Customer (KYC) project by integrating customer data from multiple source systems into a central platform.
• Responsibilities included data modeling, designing ETL processes, and managing development activities to ensure accurate and secure data flow.
• Delivered robust systems architecture and database solutions to meet compliance and operational requirements.

Skills:

Oracle SQL

2019 - 2020: Implemented merger of DWH and BI and reporting platform

Role: Business Consultant / BI/DB Consultant

Customer: Internet Mall

Tasks:

• Implemented merger of DWH and BI and reporting platform of an acquired subsidiary, led a team of developers.
• Responsibilities included business and data analysis, data modelling, ETL design, development and performance optimization.

Skills:

MS SQL, Keboola, Snowflake

2018 - 2019: Regulatory Reporting Datamart

Role: Solution Architect

Customer: on request

Tasks:

• Delivered a regulatory reporting solution for the Anacredit project, requiring the creation of a new datamart due to significant differences from previous reporting standards.
• Responsibilities included data modeling, ETL design, and managing development activities.
• Focused on BI architecture, database development, and process optimization to ensure compliance and accuracy in reporting.

Skills:

Oracle SQL

2018 - 2018: Datamart solution

Role: Solution Architect

Customer: Prague Airport

Tasks:

Led a a team of developers tasked with creating a comprehensive datamart solution for internal and external reporting purposes of the client.

?

Skills:

Oracle SQL

2017 - 2018: Planning, controlling, and regulatory reporting

Role: BI Analyst / Developer

Customer: on request

Tasks:

• Delivered multiple projects focused on planning, controlling, and regulatory reporting.
• Responsibilities included developing a planning application, creating datamarts for controlling and planning, and building a datamart for regulatory compliance.
• Activities involved data modeling, ETL design, BI analysis, and development, ensuring robust database architecture and efficient data flows to support business processes.

?

Skills:

Oracle EPM (Hyperion)

2014 - 2017: Business analysis and solution architecture across multiple projects

Role: IT Consultant

Customer: Neit Consulting

Skills:

Oracle SQL, EPM

2006 - 2014: Reporting and BI projects

Role: Data Analyst

Customer: Accenture

?

Skills:

Qlik, SAP, MSSQL

2005 - 2009: Implemented the Helios accounting system

Role: IT Specialist

Customer: on request

Tasks:

Managed IT infrastructure

Skills:

Helios