Skip navigation

David Piják

Angestellt, Senior Financial Analyst, Air Bank
Munich, Germany

Skills

Oracle SQL
PostgreSQL
Excel
Office
Visual Basic for Applications
google sheets
Power BI
Jira
ACCA Accountant in Business
ACCA Financial Accounting
Profitability Modeling
Financial Modeling
Financial Reporting
Data Analysis
English (Full Professional Proficiency)
German (Limited working proficiency)

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 – 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.

Browse over 21 million XING members