Matej Bištiak

• Audit Transformation

Gathering business requirements, understanding of complex logic of 4 different internal systems, preparation of dashboards design, data transformation in TSQL, creation of reports in Power BI, validation of presented data

• ESG reporting

Designed client forms and developed PBI reports based on established logic

• Utility Company

Analyzing AS-IS processes of reporting - data sources, data transformations and data validation. Working with management to identify KPIs. Cooperation with business users and report owners to understand the logic and methodology behind the reports. Creating documentation as AS-IS analysis together with flowchart and TO-BE report

• Lease company

Analysis of robust reporting dashboard, gathering information from business,creating new logic, and implementing this logic into Alteryx Designer to streamline the process for saving time for the business. Creating documentation and guidelines for Alteryx data transformation

• HR Reporting

Created HR reports such as demographic and salary band analysis. Conducted AS-IS and TO-BE analyses, and led meetings with HR stakeholders and CFO

• SSC Audit Reporting

Developed comprehensive audit reporting solutions for a major IT corporation using Power BI. Designed visuals to represent audit progress across 30+ countries, highlighting pending client requests. Collaborated with business owners to gather requirements, formulate solution logic, perform data transformations, and create interactive visualizations in Power BI

• UI Path to MS Power Automate

Transitioned two automation projects from UI Path to Microsoft Power Automate. The first project involved downloading files from a web application and performing minor data transformations. The second project automated the download of completed templates from auditors, dynamically checked Excel tables, and populated a web application with the extracted details.

• HR Reporting

Developed an end-to-end Power BI report, including data transformation, to monitor doctor leave, paid vacations, and related metrics. This report provided management with comprehensive insights to effectively control team utilization and personnel management.

Served on the Staff Advisory Board, representing colleagues at the same level to top management and advocating for their ideas and suggestions.

Worked as a Subject Matter Expert for the input process to the OOXP tool. Responsibilities included:

• Gathering data from multiple sources
• Communicating with various teams to ensure data quality
• Liaising with the vendor to discuss changes, objectives, and future plans for global tool expansion

In addition to these primary tasks, I also:

• Created data flows in Alteryx
• Developed various financial automations using Automation Anywhere and MS PowerApps
• Conducted financial analysis and generated reports using Power BI, DAX, and Excel
• Supported the Finance Internship Program Buddy initiative

As a Tax Analyst, I worked on a project focused on automating regional and global transfer pricing calculations (OOXP), where I owned the entire input process. This included:

• Checking and adjusting input data
• Managing offline inputs
• Creating regular and irregular analyses
• Measuring differences between input and output data
• Developing end-to-end RPA to streamline the process
• Conducting UAT

On a daily basis, I utilized Alteryx, Automation Anywhere, Power BI, Excel, and VBA.

• Intern at Financial Accounting Advisory Services (FAAS)

As an intern at Dell, I worked on several projects, primarily focusing on RPA tasks that included VBA. I developed an automation solution for comparing two different data cubes, which my team used during testing.