David Piják

Bank products life-time profitability calculations, loan portfolio modeling, retail debtors’ behavior modeling . Reporting of financial, sales and business data. Providing calculations and presenting results to higher management. Responsibility for smooth data transfers to Headquarter through reporting tools such as Oracle Hyperion or SQL. Analysis of large business data sets through SQL and Excel. Reports automation with VBA and Excel SQL database connections, SQL queries automation.

Cost controlling and reporting for various departments of KBC. Creation of budgets and forecasts. Using costs models to determine the correct value of internal services that departments provide to each other. Ensuring compliance with the Group transfer pricing policy. Creation of monthly costs reports showing spending and available funds of departments of KBC Group. Regular communication with managers and supporting them with analyses. Development of costs reporting tools and internal databases using VBA.

Supervision of the dealing room activities. Checking of prices of KBC derivative products. Processing of daily pricing feed, uploading price data into the database and investigation of price movements. Creation and distribution of valuation reports, including daily reports. Communication and cooperation with institutional counterparties, traders and Back Office administrators. Later, having responsibility for the whole three-headed team. Achieving significant process automation using VBA in Excel, Outlook.