Martin Matejka

Senior Business Intelligence engineer in DHL

Bonn, North Rhine-Westphalia, Germany

About

IT Professional in Data Warehouse and reporting area with perfect sense for data. It means data structures, quality, data products, data transformations and vizualization. I am used to work in large enterprise architecture with hundreds of various data sources. I have perfect analytical skills and ability to see consequences and to evaluate a lot of steps in advance. I am also flexible, agile and I use prototyping to get first results very soon. I like learning and I am excited about new challenges. I am familiar with the whole process of development in DWH and BI area from analysis, dealing with requestors, estimations through development to testing and production support. I can also create stunning, self explaining and visually attractive dashboards. My sense for visual design hopefully prove awards from Czech Press Photo.

Experience

  • Senior Business Intelligence Engineer at DHL
    May 2021 - Present · 5 yrs 3 mos

    ► Remote work for Deutsche Post division in german language ► Maintenance and development of core Deutsche Post data warehouse ► Technologies: Teradata, Tableau, Informatica, Github, Wherescape, Python, Azure, Snowflake ► Developing and maintenance of BI system and core algorithms for delivery predictions ► Analysis, development and maintenance of algorithms providing regulary various delivery statictics ► Developing system for package fraud and theft detection to identify patterns ► Tableau Development and advisory for various Tableau tasks ► Performance tuning of existing Tableau dashboards ► Data delivery statistics and impact analysis

  • Business Intelligence lead engineer in Erste Bank (Group) at Erste Group IT
    Sep 2015 - Apr 2021 · 5 yrs 8 mos

    ► Responsible for BI architecture and Report development on Erste group level ► Master in technologies: Oracle, Tableau, Hadoop (Hive, Impala) and Python ► Member of winning team in internal heckaton focused on sales prediction ► Lead developer for these Dashboards and analysis: #Customer usage of retail channels for board of directors #Covid19 impact for board of directors #Erste group complaint management #Data warehouse migration match #Customer network and customer acquisition for large corporate clients #Project Controlling #Financial reconciliation for standard and Stock exchange deals #Release planning #and many others ► Working with hundreds of various data sources from all subsidiaries across Europe with different formats, update periods and dependencies ► Cooperation with colleagues across the Europe ► Design and execution of Test scenarios for Data warehouse migration ► Definition of data model, data structures and data products for reporting and BI ► ETL design and ETL performance tuning for reporting ► Working in agile environment with prototyping and fast delivery time ► Lecturer of Tableau and BI self service (English and German language)

  • Česká spořitelna (9 yrs 5 mos)
    • Data Warehouse and reporting senior specialist
      Jun 2011 - Aug 2015 · 4 yrs 3 mos

      ► Full stack reporting development including analysis, design with business, advisory, Database implementation, graphical design and IBM Cognos implementation ► Focused on reporting area of data warehouse, Mastering Cognos and Oracle ► Transforming data lake and warehouse data into reporting data marts ► Business analysis of various requirements, dealing with customers ► Lecturer of IBM Cognos ► Team leader for data warehouse and reporting projects

    • Data Warehouse Senior specialist
      Apr 2006 - May 2011 · 5 yrs 2 mos

      ► Design and architecture of new DWH versions in the biggest Czech bank ► Building operational fast Data lake and DWH historical storage ► Technical leader for data warehouse projects (releases), dealing with customer ► Technologies: Oracle DB, Oracle workflow, OWB, ODI ► Member of special 24x7 support team with full DB rights ► ETL development and performance tunning

  • Senior Software Developer and Analyst at Vigour a.s.
    Aug 2001 - Mar 2006 · 4 yrs 8 mos

    ► Part time job in software company during my study at university ► Various roles from junior developer to test architect and project manager, but mostly senior developer ► Specialized on Oracle, Java, Power Builder ► Data knowledge and projects from various areas like energy, power plants, banking, social services