BI Analyst & Data Analyst & Database Developer

Erfahrener BI-Spezialist mit Fachwissen in den Bereichen Analyse, Entwicklung und Testen von BI-, DWH-, Berichts-, ETL- und Integrationslösungen. Kenntnisse in Oracle, MS SQL, Teradata, Power BI und mehr. Ausgeprägte analytische, modellierende und problemlösende Fähigkeiten. Fließend in Tschechisch und Englisch.

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