BI Analyst & Business Analyst

The candidate is a Senior Analyst/Engineer with 10 years of experience in Data/DWH and BI in Banking, Card payments, and Manufacturing industries. They hold degrees in European Business and Finance and System Engineering and Informatics. The candidate has full professional proficiency in English and native proficiency in Czech/Slovak. They have worked with technologies such as MS Power BI, Teradata Vantage, and MicroStrategy. In their free time, the candidate enjoys traveling, hiking, playing tennis, and biking.

• 11/2022 - Present
• Working in the manufacturing sector, focusing on commercial and financial data analysis
• Developing reports in MS Power BI using SSAS tabular data models and SQL Server/AWS datasets
• Enhancing SSAS Data models with new objects using DAX and SQL
• Developing datasets in T-SQL on Microsoft SQL Server using Data Vault architecture
• Administering Power BI Service environment and on-prem Reporting Services servers
• Working in an Agile environment with sprints and Jira Kanban
• 05/2019 - 09/2022
• Consulting customer requirements for BI reports and data sources in the payment processing industry
• Designing data models and technical specifications for DWH and BI reports
• Developing ETL processes for all layers in the Data Warehouse
• Analyzing data, designing, testing, and fixing data models
• Implementing Agile methodology, automatization, and DevOps principles
• Training business users in new processes and functionalities of DWH
• 02/2017 - 04/2019
• Creating technical specifications for DWH development in the banking sector
• Designing ETL transformations and business rules for the DWH's Output layer
• Providing data support for business users and consumers of DWH data
• Implementing data corrections and solving operational problems
• Executing technical and functional test scenarios for ETLs and data structures
• Following waterfall methodology for development
• 9/2013 - 12/2016
• Supporting IFS ERP system in a manufacturing company
• Providing solutions, workarounds, and fixes based on data analyses
• Administering IFS system permissions
• Training business users and testing new patches/releases
• Assisting with the implementation of the new IFS system
• Creating SQL reports and maintaining ServiceDesk support tool