Gábor (Herbert) Zottmann

Analyst / Consultant

Larnaca, Cyprus

Experience

Jul 2023 - Present
2 years 1 month

Analyst / Consultant

Freelancer

  • Development of Cognos Analytics Data Modules, Datasets and Reports.
  • Business: Banking.
  • Development of Cognos Analytics Data Modules, Datasets and Reports.
  • Analysis and implementation of Reporting Data Modules and Datasets.
  • System environment: Cognos Analytics, Oracle, Toad, Azure, Confluence.
Apr 2023 - Present
2 years 4 months

Analyst / Consultant

Freelancer

  • Migration of Cognos Powercubes to Cognos Dynamic Cubes.
  • Business: Public Sector.
  • Migration of Cognos Powercubes to Cognos Dynamic Cubes.
  • Data Analysis.
  • Cube Administration with Rest-API.
  • System environment: Cognos Analytics, Oracle, Jira, Confluence.
Feb 2023 - Jul 2023
6 months

Analyst / Consultant

Freelancer

  • Migration of Cognos Analytics & Planning Analytics Environment.
  • Business: Automotive.
  • Installation, Migration, Patching, Deployment.
  • Set up interconnectivity for (and between) Cognos Analytics incl. Dynamic Cubes with multiple dispatcher and environment, Planning Analytics and DB2.
  • System environment: Cognos Analytics, DB2, Planning Analytics, Jira, Confluence.
Apr 2022 - Nov 2022
8 months

Analyst / Consultant

Freelancer

  • Implementing a DataVault 2.0 DWH for an international Reporting environment for Health data.
  • Business: Public Sector.
  • Business Analysis and coordination with Business.
  • Modelling of DataVaults and Information DataMart’s.
  • Implementing ETL Packages (PL/SQL) and SAP Data Services.
  • System environment: Oracle, PL/SQL, SAP Data Services, Confluence, Jira, GIT.
Aug 2021 - Dec 2021
5 months

Analyst / Consultant

Freelancer

  • Supporting Go-Live DWH and Reporting Environment.
  • Business: Information Technology / Industry.
  • Supporting the Go-Lives of a DWH and BI Environment, which are rolled out as an add-on to an ERP Software.
  • Adjust and harmonize the DWH and Reporting Environment to meet requirements and roll out to clients.
  • System environment: SQL Server, IBM Cognos Analytics.
Jul 2021 - Present
4 years 1 month

Analyst / Consultant

Freelancer

  • Administration of Risk Reporting Environment.
  • Business: Banking.
  • Monitoring.
  • Service Reliability.
  • Work on Incidents.
  • Patching.
  • System environment: Cognos Analytics, Oracle, Service Now, Linux.
Jul 2021 - Sep 2022
1 year 3 months

Analyst / Consultant

Freelancer

  • Implementing Risk Reporting Modell.
  • Business: Banking.
  • Implementing Reporting Model (Cognos Framework Manager).
  • Business and technical Requirement-Analysis and coordination with Business.
  • System environment: Cognos Analytics, Oracle, Jira.
Jun 2021 - Mar 2022
10 months

Analyst / Consultant

Freelancer

  • Implementing a DataVault 2.0 DWH, Raw and Information Data Marts, creating PowerBI Reports.
  • Business: Industry.
  • Business Requirements analysis and coordination with Business.
  • Modelling DataVault, Raw and Information Marts.
  • Implementing ETL Packages in Visual Studio (Stored Procedures, Tables, Views, Jobs).
  • Creating PowerBI Datasets (incl. DAX) and Reports.
  • System environment: SQL Server, Visual Studio, GIT, PowerBI.
Apr 2021 - Jul 2021
4 months

Analyst / Consultant

Freelancer

  • Implementing Market Analysis Tool.
  • Business: Fintech.
  • Loading Data into Snowflake-DB via Python and automated Data-analysis.
  • System environment: Python, Snowflake, AWS.
Mar 2021 - Aug 2021
6 months

Analyst / Consultant

Freelancer

  • Implementing a management-reporting-systems.
  • Business: Information Technology.
  • Implementing a reporting DataMart (Postgre) and a reporting environment (PowerBI).
  • Enablement of the client.
  • Business and technical requirement analysis.
  • System environment: PowerBI, Postgre, Jira.
Nov 2020 - Mar 2021
5 months

Analyst / Consultant

Freelancer

  • Implementing a reporting DataMart and a reporting model.
  • Business: Banking.
  • Implementing a reporting DataMart (sql etl).
  • Source and target analysis.
  • Implementing a reporting model (Cognos Framework Manager).
  • Performance tuning on both ETL and reporting.
  • Enablement of client.
  • System environment: IBM Cognos Analytics, Oracle.
Jun 2019 - Feb 2021
1 year 9 months

Analyst / Consultant

Freelancer

  • Migration of Cognos 10 Reporting Application to Cognos Analytics.
  • Business: Insurance.
  • Migration of Cognos 10 Reporting Application to Cognos Analytics due to Migration of underlying DWH (Data Sources and Data structure, incl. Migration of TM1 Reporting Cubes and Sources to Planning Analyics).
  • Implementing Cubes according to new Datasource.
  • System environment: IBM Cognos Analytics, Cognos TM1, Planning Analytics, Planning Analytics Architect, Planning Analytics Perspectives, Oracle, ALM Octane, IBM Cognos 10, SAP Insurance Analyzer.
Jan 2019 - Jun 2019
6 months

Analyst / Consultant

Freelancer

  • DataVault 2.0 DWH, Cognos TM1 Olap Source, Cognos Analytics Reports and Dashboards.
  • Business: Public Sector.
  • Implementing DataStage ETL Jobs for DataVault 2.0 DWH.
  • Modelling DataVault Datamart and Cognos-Framework Manager (Rolap, Relational).
  • Planning Environment (TM1 Planning Workflows).
  • Analysis.
  • Developing Cognos Analytics Reports and Dashboards.
  • System environment: IBM Cognos Analytics, Cognos TM1, IBM DataStage, Oracle, MSSQL Server.
Dec 2016 - Present
8 years 8 months

Analyst / Consultant

Freelancer

  • Implementing a Datawarehouse for controlling with various DataMart’s, reporting and ad-hoc reporting interfaces, training for clients.
  • Business: Mechanics, Industry.
  • Analysis and implementation of SSIS-ETL-Jobs DWH-Load.
  • Analysis and implementation of controlling-reports and dashboards.
  • Performance tuning of SSIS packages and reports.
  • Modelling of DataMart’s and Cognos-Rolap-Layer.
  • System environment: IBM Cognos BI, SSIS, MSSQL Server, Navision.
Sep 2016 - Nov 2016
3 months

Analyst / Consultant

Freelancer

  • Analysis and implementation of management-reports and dashboards.
  • Business: Banking.
  • Analysis implementation of management-reports and dashboards.
  • Modelling of DataMart’s and Cognos-Rolap-Layer.
  • Enablement / training.
  • System environment: IBM Cognos BI, Cloudera Impala.
May 2016 - Aug 2016
4 months

Analyst / Consultant

Freelancer

  • Implementing a planning and reporting environment, modelling DWH, loading data from SAP to Oracle DWH with DataStage and loading into TM1-Cubes.
  • Business: Public sector.
  • Analysis and development of TM1-cubes and reports.
  • Modelling DWH.
  • Development of DataStage-jobs.
  • Business Analysis.
  • Requirements Engineering.
  • Create authorization concept.
  • Training.
  • Prepare testing plans and detailed test cases incl. generation of test data to depict business requirements.
  • System environment: SAP-BW, IBM DataStage, Oracle DB, IBM Cognos TM1, IBM Cognos BI.
Oct 2014 - Mar 2016
1 year 6 months
Vienna, Austria

Inhouse Analyst / Consultant

Allgemeine Unfallversicherungsveranstalt

  • Business Intelligence and Datawarehouse.
  • Reporting.
  • Olap.
  • DWH and DB modelling.
  • ETL.
  • DataMarts for Self-Service-Reporting.
  • Performance tuning of Reports and Databases.
  • Business Analysis.
  • Requirements Engineering.
  • Training and user-enablement.
Oct 2013 - Aug 2014
11 months
Vienna, Austria

Analyst / Consultant

Imposult Gmbh & Co Kg

  • Implementing mapping and ETL from operational database to DWH, build DataMarts, cubes and reports.
  • Business: Transporting, Supply Chain.
  • Analysis and developing the mappings from the data sources of the client to DWH.
  • Customizing DataMarts.
  • Implementing Dynamic Cubes via Cube Designer.
  • Implement and schedule Reports for Cache-generation.
  • Developing controlling-reports.
  • System environment: AS400, DB2, IBM Cognos, IBM Cognos Dynamic Cubes, IBM Infosphere Warehouse.
Sep 2013 - May 2014
9 months
Vienna, Austria

Analyst / Consultant

Imposult Gmbh & Co Kg

  • Implementing a reporting environment of information of sales division of clients, contacting’s, dialogues, etc.
  • Business: Banking.
  • Developing the reporting DataMart’s.
  • Report Implementation.
  • Business Analysis.
  • Requirements Engineering.
  • Enablement of the Client.
  • System environment: Oracle DB, IBM Cognos TM1, IBM Cognos BI.
Sep 2013 - Mar 2014
7 months
Vienna, Austria

Analyst / Consultant

Imposult Gmbh & Co Kg

  • Implementing a Data-Quality-Management-Engine for monitoring daily loads of the CRM-DWH and visualize results of the engine.
  • Business: Banking.
  • Business Analysis.
  • Implementing pixel-perfect reports and burst the results of the data-quality-checks.
  • System environment: Oracle DB, IBM Cognos BI.
Nov 2012 - Aug 2013
10 months
Vienna, Austria

Analyst / Consultant

Imposult Gmbh & Co Kg

  • Implementing a traceability-reporting-engine and DWH.
  • Business: Industry.
  • Business Analysis.
  • Requirements Engineering.
  • Development the DataMart’s corresponding traceability 2 and 4 standards.
  • Analysis and implementing user-reporting-portal, including dashboards and UI-enhancements.
  • System environment: MS SQL-Server, SSIS, SSAS, IBM Cognos BI, IBM WebSphere Portal Services.
May 2012 - Aug 2012
4 months
Vienna, Austria

Analyst / Consultant

Imposult Gmbh & Co Kg

  • Implementing the ETL-interface between MS-SQL-Server and ORACLE-DWH.
  • Business: Transporting.
  • Analysis and development of ETL-jobs and scheduling’s.
  • System environment: MS-SQL-Server, ORACLE-DB, IBM DataStage.
Nov 2010 - Apr 2012
1 year 6 months
Vienna, Austria

Analyst / Consultant

Imposult Gmbh & Co Kg

  • Implementing a finance-Datawarehouse and loading into DataMart’s and reporting interfaces.
  • Business: Banking.
  • Business Analysis.
  • Development of DataStage and SQL-script-jobs for loading the DWH and the DataMart’s.
  • Implementing and analysis of change-requests.
  • Prepare testing plans and detailed test cases incl. generation of test data to depict business requirements.
  • System environment: Teradata DB, IBM DataStage, HP Quality Center, Tortoise SVN.
Feb 2010 - May 2010
4 months
Vienna, Austria

Analyst / Consultant

Imposult Gmbh & Co Kg

  • Implementing a Cognos TM1 Budget Planning Application PoT.
  • Business: Industry.
  • Set up a TM1 Budget Planning Application including Workflows, Actual vs. Budget Comparison, TM1 Cubes, Rules, Planning Calculations.
  • System environment: MS SQL Server, Cognos TM1.
May 2009 - Sep 2014
5 years 5 months
Vienna, Austria

Analyst / Consultant

Imposult Gmbh & Co Kg

  • Implementing a Business-Intelligence reporting-tool and DWH, loaded with XML-data-extracts of the association members.
  • Business: Insurance.
  • Creation of XML-interface to the DWH including business analysis.
  • Creation of source-to-target-mappings.
  • Design of a relational-OLAP-data source.
  • Creation of standard-reports including calculated measures and members, corporate identity and performance enhancement.
  • System environment: AIX, MS Windows 2003 Server, IBM DB2, Cognos BI 10.
Nov 2008 - Apr 2009
6 months
Vienna, Austria

Analyst / Consultant

Imposult Gmbh & Co Kg

  • Migration of present DWH-solution to IBM DWE 9.5 replacing Perl-ETL-scripts with SQW for DB2 Warehouse.
  • Business: Trading.
  • Analysis, creation and developing ETL jobs and packages.
  • System environment: IBM AIX, DWE 9.5.
Jun 2006 - Aug 2008
2 years 3 months
Pressbaum, Austria

IT Systems and Database Responsible / Project Manager

Brajlovic GmbH

  • IT-infrastructure und database.
  • Responsible for IT-Systems and databases.
  • Backing of controlling.
  • Reporting Intrastat.
  • Project manager: implementing a system for the goods movement in the warehouse.
  • Project manager: implementing a mobile Point-of-Sale application.

Summary

  • Technical overview: MS SQL Server, DB2, Oracle, Postgre, Cloudera Impala, Oracle Exadata, Teradata, MS Access
  • OLAP-Database-systems MS SQL Server Analysis Services, IBM Cognos TM1, IBM Planning Analytics, IBM Cognos Dynamic Cubes, IBM Cognos Powercubes, Cognos DMR
  • Business experience: Health-Care, Insurance, Trade, Information Technology, Banking, Transportation, Public Sector, Mechanics, Industry, Automotive
  • BI / DWH Tools: IBM Cognos Analytics, IBM Cognos BI, IBM Planning Analytics, IBM Cognos TM1, IBM DataStage, IBM DB2 Warehouse, Power BI, MS SQL Analysis Services, MS SQL Integration Services, Confluence, Jira, Oracle BI, Oracle Data Integrator, Tortoise SVN, HP Quality Center, Bugzilla, GIT
  • New Technologies: Snowflake, Cognos Mobile, Cloudera Impala, Big Data, Google Analytics, Google Looker

Languages

German
Native
Hungarian
Native
English
Advanced

Certifications & licenses

BI0-112 IBM Cognos 8 BI Author

IBM

COG-300 IBM Cognos TM1 Analyst

IBM

COG-310 IBM Cognos TM1 Developer

IBM

COG-612 IBM Cognos 10 BI Author

IBM

COG-622 IBM Cognos 10 BI Administrator

IBM

COG-625 IBM Cognos 10 BI Data Warehouse Developer

IBM

P2090-032 IBM Big Data Fundamentals Technical Master

IBM