Related business partners:
Palma as., Sberbank, IBM, Linde group, Aliter, Ministry of interior of SR, Aspecta, HomeCreditInternational, Tipos, OTP, Telekom, EQ

Main projects description:

PALMA a.s.:
Analyze, implement and customize reporting and planning on whole company level including Sales,
Finance, Controlling and Supply Chain needs. Requirements analyses. Responsible for the whole BI solution.

DW: MS SQL Server 2008
ETL: MS SSIS
Framework: IBM Cognos Framework
OLAP: IBM Cognos TM1
Reporting: IBM Cognos Express

--------------------------
SBERBANK a.s.:
Leading the implementation of HR and Financial planning/budgeting solution from technical aspects.
Project developed on MS SQL and IBM TM1

--------------------------
MINISTRY of INTERIOR of SR, ALITER:
Business analyses, Consulting, log processing via Hadoop on IBM platforms.

--------------------------
LINDE:
Advisor on TM1 solution with main focus on process and data integration. Consolidation to Linde HQ at Munich.

---------------------------
HomeCreditInternational

Prepare and validating the POC of new data center. Performance and stress testing.
Solution implemented locally (China, Indonesia, India, Kazachstan, ...) and consolidate the data to HQ (Prague).

Used technologies:
Oracle 12c InMemory databased
SAP HANA/BW
Tableau, Oracle BI, MS BI

OTP Bank Slovakia
Credit proposal managemant.
Prepare an aplication for credit managemant.
VisualBasic, macros

Tipos a.s.
Reverse engineering of lost profit on card transactions.
MS SQL

Telekom a.s.
Full HR Controling solution (reporting and planning) in Power BI cloud, Power App, BlobStore and Azure MS SQL. Including festures SSO RLS, Visualization, Bookmarks, Filters, Power Query M Code and complex DAX measure & column calculation.

Energie Quader GmbH.
Gas and Electricity portfolio management reporting. Sales, Volume and Price reports in Power BI using PowerApp, Power Automate. Datasource used Azure MS SQL, SharePoint list and excel files

Manage the Group controlling consolidation at HQ in Vienna.

My responsibilities are planning and reporting integration and ensure the data quality.

The worldwide partial solutions is going to be centralized for OMV Group to ensure:

• One consolidated reporting and planning solution at Group level
• The data integrity and data quality
• Transparent and comparable financial reporting and planning on Group and country level
• Consolidated reporting and planning on country level
• Centralized maintenance of reporting and planning systems

TM1 planning and reporting solution is used at OMV worldwide. Vienna, Bucharest and in all branches as Wellington (New Zeeland), Yemen, Kazakhstan, Tunisia etc.

The TM1 solution is going to be both-way online connected with accounting systems of all countries (mainly SAP, SAP BW, Oracle...).

Building the new bank’s reporting infrastructure for HR department.

My responsibilities are reporting migration form SAP BO to Oracle Fusion cloud solution.

The part of RBS is going to be separated from RBS based on the EU regulator’s decision. The new bank will use the same reporting templates and outputs but different system. This project is about ensure the migration from RBS’s SAP BO reporting solution to W&G Oracle Fusion solution. The repot migration is separated to few groups as HR, Finance and Others. Our project is focusing on the HR reports migration.

Oracle Fusion could solution will be used in W&G as the core banking, ERP, CRM and reporting system.

The Oracle Fusion service-oriented platform and applications suite joins next-generation enterprise technologies, applications, and services, including Oracle Fusion Applications and Oracle Fusion Middleware, to change the dynamics in the applications marketplace and revolutionize business

Analyze the technical needs of IT projects.

Develop pilot/demo solution and lead project implementation. Including projects as Social media reporting, DCPortal migration, Pricing and Loyalty. Used technologies Microsoft DWH/BI, SharePoint.

Preparing feasibility studies, pre-sales activities.

Cooperating on Parallel data warehouse (PDW) start up. Participated on one week training.

Successfully passed exam MS SQL Server 2012 (Exam 70-461)

Working with remote manager and collaborate with a remote team members.

Business consulting in Activity-based costing.

Analyze implement and customize a planning-reporting solution for department of real estate, develop and engineering. Used technology Cognos Express.

Responsible for the IBM as the vendor and all IBM SW based project at S&T

Business consulting in HR controlling. Analyze the company’s BI solution in Oracle (Sales, Finance, SLA, Controlling) and migrate it to IBM Cognos BI.