
David Piják
Skills
Timeline
Professional experience for David Piják
- Current 8 years and 11 months, since Aug 2016
Senior Financial Analyst
Air Bank
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.
- 1 year and 5 months, Mar 2015 - Jul 2016
Financial Analyst
KBC Bank
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.
- 1 year and 7 months, Aug 2013 - Feb 2015
Middle Office Financial Markets Analyst
KBC Bank
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.
Educational background for David Piják
- 2 months, Aug 2012 - Sep 2012
Deutsch als Fremdsprache
Heinrich Heine University Düsseldorf
- 6 months, Jan 2012 - Jun 2012
School of Accounting and Finance, Erasmus programme
University of Vaasa
- 4 years and 10 months, Sep 2008 - Jun 2013
Government Finance, Master's degree
Masaryk University, Faculty of Economics and Administration
Languages
English
Fluent
German
Intermediate
XING members with similar profiles
XING – The jobs network
Over 1 million jobs
Find just the right job for you on XING.
Job offers just for you
Get found by employers and over 20,000 recruiters.
22 million members
Connect with new people and gather inspiration to boost your working life.
Free membership
Basic membership is free, but the opportunities are priceless.