Printing tool Download PDF

Martin Kohout

=VLOOKUP(Challenge, Reporting:Analysis, Prague, TRUE)

A bit of myself


Data enthusiast and reports freak


Creating mind blowing reports  for business analysis. 

Strong finance background with focus on cost management.

Leading budgeting and forecasting process in ERP from Infor.

Work Experience

Oct 2017Now

Sales Operations Analyst EMEA



  •  monthly sales reporting for CEMA region (sales, marketing, CRM)
  • various ad-hoc projects across region (GoDirect, market models, therapies models, margin/mark-up analysis, contest evaluation, ...)

Main achievements:

  •  Monthly reporting package in MS - SQL + Tableau to streamline and ease reporting process. Package includes reporting for CEMA sales teams and also dashboards for marketing teams. It connects data from GSR, finance data from CMR (originally RPT) and CRM data from SFDC.
  •  Patients treated calculation - originally project only for SI portfolio done in cooperation with region marketing leads and global office. Due to its success, it is extended to other business units - RMS, GIH, RCS.
  • Go-direct projects across EM - close cooperation with Project Management team and local Business leaders. Mostly support with data analytics in Tableau.
  • DSM EMEA - development of tool together with SA Manager for disease state specialists and also for leadership to support VBH development especially in Western Europe
Sep 2016Oct 2017

Accounting Manager

Vienna House Diplomat Prague
  • Main goal was streamlining informational flow across all department and creating/improving reporting system.
  • Creation of PO management system to control expenses across all departments according budget/forecast
  • A/R management
  • Budgeting, planning and forecasting of expenses 
  • Keeping a track of all financial transactions in an organization (income audit and controlling)
Sep 2016Now

Reporting Analyst (part-time)

Vienna House Czech Republic
  • Maintenance of developed tools 
  • Ad hoc report according to actual needs
  • Processes automation (excel, VBA)
Nov 2015Sep 2016

Cluster E-Commerce Coordinator

Vienna House Czech Republic
  • Reporting & Data analysis:
    • Creating new tools for managing accounts
    • Preparation and delivery of key management reports and metrics providing comparable analysis of business performance and insight to business results
    • Creation and maintenance of so called BOB (business on the books) dynamics report
    • Improving current reporting tools across all departments
  • E-commerce: 
    • Define and execute a clear online distribution channels strategy
    • Identifying and keeping pace with new and evolving players in the market
    • Develop understanding of channel dynamics, client needs and key initiatives
    • Content Creating promotions and packages for all czech propertiesand quality check across all channels

    • Liase with the OTA’s market managers
    • Manage the RFP proces: eAuctions, Bid submission
    • Collaborate with marketing to optimize placement of marketing messages
    • Creating promotions and packages for all czech properties
May 2013Nov 2015

Night Auditor

angelo by Vienna House Prague
  • Summarize and report the results of daily operations to hotel management and corporate office
  • Responsibility for the hotel operation during the overnight shift
Sep 2011Apr 2013

Front Office Manager

MICHAEL Development, Hotel Ehrlich
  • Responsibility for all duties of the front desk operation
  • Staff training and shifts planning
Sep 2009Jul 2011

Front Office Agent

MICHAEL Development, Hotel Ehrlich
  • Responsibility for smooth run of the Front Desk
  • Concierge

Other current work related activities

Vienna House Easy Pilsen - leading budgeting process, setting controlling processes, consulting

Revolt.BI - data visualization, data management consulting, mostly ad hoc projects for various companies

Vienna House Czech Republic -  commercial reporting, revenue management consulting, process automation

My projects

What else?

Running a lot, practicing yoga, climbing mountains and much more...