Jan has more than 10 years of consulting experience with the last years working for Teradata and Deutsche Telekom (English: German Telecom).
Nearly all that time he worked with Teradata database products and utilities. In last years he was involved more and more in implementing also Big Data solutions.
He has most experiences with ETL tools Informatica, IBM DataStage and Oracle Data Integrator, but also with BI tool IBM Cognos, Microstrategy, SAP Business Objects.
Last years he was also line manager of Data Integration team. Jan has big banking industry knowledge as most of his projects were for financial sector.
- Teradata database implementation and tuning
- ETL Design and Implementation
- Business Intelligence Report Development
- Big Data Architecture and Implementation
- Expert in Banking Industry
- Physical and Logical Data Modeling
- Team Leaded and Line Manager
Databases - Teradata, Sybase ASE, Oracle, IBM DB2, MS SQL Server, Hadoop
Modeling Tools - Sybase Power Designer, CA ERwin, MS Visio, Select Architect
ETL Tools - Informatica, IBM DataStage, Oracle Data Integrator
BI Tools - Cognos (BI, ReportNet, Framework Manager, Transformer, PowerPlay, Access Manager), SAP BusinessObjects, Microstrategy, MS SQL Server BI
Big Data - Cloudera, Hortonworks, Aster Data
Operating System - Windows, Linux, UNIX
Methodologies - PMP, ITIL, Agile, Scrum
SAP: Financial Accounting (FI), Bank Analyzer (FS-BA), BW, Business Objects (BO)
Teradata Tools - Administrator, SQL Assistant, BTEQ, PMON, Viewpoint, Priority Scheduler, ARC, Dynamic Query Manager (DQM), Index Wizard, Statistics Wizard.
- Teradata Certified Professional
- Teradata Certified SQL Specialists
- Teradata Certified Implementation Specialist
- Teradata Certified Design Architect
- Teradata Certified Database Administrator
- Teradata Application Development
- Teradata Certified Master
- Informatica Certified Administrator
- Informatica Certified Developer
- Informatica Certified Consultant
- IBM Certified Solution Developer Infosphere DataStage
- IBM Cognos 8 BI Modeler
- IBM Cognos 8 BI Author
- IBM Cognos 8 BI Administrator
- IBM Cognos 8 BI Professional
- Cognos Series 7 Product Professional Certification
- IBM Certified Solution Expert Cognos 8 BI
- IBM Certified Administrator - Cognos 10 BI
- IBM Certified Designer - Cognos 10 BI Reports
- SAS Certified Base Programmer for SAS 9