Martin Svoboda Email & Phone Number

Hedge accounting tool - The aim of the project was to replace the existing way of managing hedge accounting data and create a new tool that allows automatic export of data to DWH and then to the parent company.My role: analysis of business user requirements, creating a specification for the web application developer, definition and development of the database procedure for exporting data from the new application's database to DWH, specifying data transformation and input requirements for ETL mapping in DWH, definition of data quality checks, user testing (application, data)Cooperation with five teams: two business teams, accounting, DWH, and web development.Used databases: MS SQL, Oracle

Design, analysis and SQL development of data layers used to generate FINREP, COREP, Liquidity and MKT reports that are sent to the CNB/SDAT system. Responsible for coordinating the work of the team.

Implementation of new requests in ALM datamart and preparing adhoc reports for analytical team.

Data model design, analysis and implementation of ETL processes for Cognos reports

Development of ETL processes in Oracle Warehouse Builder and in PL/SQL. Design and realization of migration for FAT/UAT tests.

Analysis of two source system (Insurance) used for datawarehouse.

Cooperation in development of TTS (Trouble Ticketing System) for Telefonica O2 Czech Republic. System is based on J2EE platform. Application logic is stored in the Oracle database

Cooperation in data warehouse development. Analysis of the impact of broadening the existing ETL processing inclucing development of plus load of new dimensions and facts for the project of receivables sale. Analysis of the impact on datawarehouse and upload of historical data to the table of facts including development.

Development of the application for price management. Application contains workflow for proposing and approving prices, which are then migrated to the main system Gold. Application logic stored in Oracle database PL/SQL. Presentation layer programmed in J2EE.

Development of new ETL loads or extension of existing ones, release management, datawarehouse support and monitoring realization. Reporting in Oracle discoverer or Buisness objects

Design and realization of migration for Datawarehouse. Migration support in the production environment placement

Creating financial reports in Oracle OLAP