BI Analyst & Data Analyst & Database Developer

Experienced BI specialist with expertise in analysis, development, and testing of BI, DWH, reporting, ETL, and integration solutions. Skilled in Oracle, MS SQL, Teradata, Power BI, and more. Strong analytical, modeling, and problem-solving abilities. Fluent in Czech and English.

1/2024 / 4/2024

• Role: Regulatory Reporting Analyst / Developer
• Analyzing regulatory reports and background data, developing reports in DWH
• Tasks include analyzing client and CNB requirements, data retrieval, basic modeling, and report development
• Used technologies: Oracle, Power Designer, Draw IO, Confluence, Jira, Git

9/2023 / 11/2023

• Role: IT Specialist
• Analyzing data and DWH, reengineering reports
• Tasks include designing a new DWH, reengineering reports, and client support on Oracle DB
• Used technologies: Oracle, Visio, ServiceNow

5/2023 / 8/2023

• Role: DB Specialist Senior
• Analyzing data, DB architecture, development
• Tasks include designing and managing DWH MS SQL 2022, importing company data, and reporting in Power BI
• Used technologies: Oracle, MS SQL, SSIS, Power BI

8/2021 / 02/2023

• Role: Analyst & Developer
• Participating in project analysis and development for corporate and retail sectors
• Tasks include analyzing client requirements, developing solutions, and data transformation
• Used technologies: Teradata, Oracle, MS SQL, Visio, Power BI

2/2021 / 6/2021

• Role: Senior Analyst & Developer
• Analyzing chapters within Legal Merge
• Tasks include business requirements, screening solutions, and detail design
• Used technologies: Oracle, Share Point, Visio, Power BI

8/2020 / 1/2021

• Role: Oracle Developer
• Data migration and transformation
• Tasks include data analysis, developing data transfer procedures, testing, and documentation creation
• Used technologies: Oracle

Description: Task analysis, development, and testing in Insurance DWH

• Tasks include analyzing and solving tasks based on initial requirements
• Used technologies: Teradata, Informatica Power Center, WhereScape, Power Designer

7/2017 / 9/2018

• Role: DB Oracle Engineer
• Implementing CEB migration process with detailed data analysis
• Tasks include implementing migration scripts and data analysis for migration issues
• Used technologies: Oracle, Enterprise Architect

10/2016 / 2/2017

• Role: MS SQL Developer
• Implementing IFRS9 processes in BI solution based on requirements
• Tasks include Provisioning module, impact analysis, and IFRS processes implementation
• Used technologies: MS BI technologies (SQL Server, SSIS, Visual Studio), Visio, SharePoint, GIT

5/2016 / 8/2016

• Role: BI Analyst & Developer
• Implementing reporting solution based on client needs and source systems
• Tasks include data & impact analysis, data preparation, and Cognos reports development
• Used technologies: Cognos, Teradata 14, Informatica, Power Designer