We believe that experienced, communicative and reliable people are the key factors to make projects successful.
Our principal consultant ensures that activities are executed both effectively and efficiently.
Karol Hajdu – Principal Consultant
Master of Computer Science (1995)
Personal strengths
- strong analytical thinking
- deep technology background in DB systems and DWH/BI technology
- very experienced in designing architectures for business intelligence & data warehousing solutions
- experienced communicator / moderator in different perspectives: technology, business, management
Publications & public speeches
- author and lector of public training courses
- public technical presentations at German Oracle User Group (DOAG) and Swiss Oracle User Group (SOUG)
- author of technical articles for DOAG / SOUG newsletter
- more details
Conceptual skills
- Initialize, structure, manage and implement Business Intelligence / DWH projects
- Analyze and consolidate business requirements for DWH and BI applications
- Design and implement relational and multidimensional datamarts / cubes
- Design and develop complex and/or high throughput ETL applications for DWH environments
- Design and tuning for performance of DWH applications based on relational and multidimensional technology
Languages
- German: excellent spoken and written
- 20 years IT consulting in this language (Switzerland, Austria, Germany)
- Certificates: Das kleine deutsche Sprachdiplom (Goethe Institut), Staatliche Prüfung der Slowakischen Republik
- English: active daily usage (both spoken and written), in international projects
Social skills
- Account management of middle-sized customer site (6-8 developers)
- Technical project management of middle-sized software development projects
- Technical lead (including effort estimation) in offering process
- Project management in middle-sized fix-price projects
- Sales & business development for IT services (solutions in BI/DWH)
Business intelligence experience
- Business area: telecommunication, banking, government, transportation, insurance
- Business focus: marketing (analytical/operative CRM), controlling, corporate performance management, product management, predictive analytics
Technology expertise
- Oracle DBMS
- 24 years experience with Oracle server products
- In-depth knowledge of latest data warehousing features, including Oracle Data Integrator
- Microsoft Analysis Services
- 14 years experience with multi-dimensional technology
- Teradata DBMS
- 4 years experience with Teradata database
| Title | Type / Function |
|---|---|
| Oracle Data Integrator Workshop | Trivadis Standard Public Course (3 days) Author and Lecturer |
| Data Warehousing with Oracle | Trivadis Standard Public Course (2 days) Author and Lecturer |
| Oracle Optimizer Workshop | Trivadis Standard Public Course (3 days) Co-author |
| Oracle 8i: Architecture, Internals & Administration | Public onsite course of Trivadis (7 days) Lecturer |
| Effizientes und einfaches Staging in near real-time Data Warehouses | Technical White Paper Lecture at TDWI Roundtable Berlin Lecture at DOAG BI Munich Co-Author & Co-Lecturer |
| Oracle Data Integrator: Elegante und effiziente Umsetzung der Best Practice leicht gemacht! | Article in SOUG & DOAG newsletter magazine awarded with “the best article” of the SOUG issue |
| Scalability of Oracle Real Application Clusters 10gR2 for Data Warehouse Applications | Technical White Paper Presentations on Sun and Oracle Events in Switzerland, Germany & Austria Co-Author & Lecturer |
| Oracle11g Datenbank macht den FULL OUTER JOIN tauglich für Data Warehousing | Article in “SOUG newsletter” magazine |
| Solid-State Disks and database technologies | Lecture at internal Trivadis Event |
| Lange Antwortzeiten bei grossen Datamarts? Dies muss nicht so sein! | Lecture at 17th annual conference of DOAG (Deutsche Oracle Anwender Gruppe) |
| Lange Antwortzeiten bei grossen Datamarts? Dies muss nicht so sein! | Article in “SOUG newsletter” magazine awarded with “the best article” of this issue |
| Der Weg zu richtigen Kennzahlen | Lecture at public event of Oracle Switzerland Lecturer |
| Table functions in Oracle 9i | Article in “SOUG newsletter” magazine awarded with “the best article” of this issue |
Karol Hajdu: Detailed list of technology knowledge
| Legend: | ||
| Knowledge depth: | : concepts | : in depth – expert level |
| Availability of knowledge: | : knowledge was available, now needs refresh | : knowledge available now |
| Field | Depth | Availability |
|---|---|---|
| Database servers | ||
| Oracle server (V7, 8i, 9i, 10g, 11g, 12c) | ||
| Oracle Optimizer (CBO) features | ||
| Microsoft Analysis Services | ||
| Microsoft SQL-Server | ||
| Teradata | ||
| HP Neoview MMP database | ||
| Languages | ||
| SQL, PL/SQL | ||
| MDX (incl. server side calculation script) | ||
| PowerShell | ||
| Assembler, C++ | ||
| Java | ||
| Unix shells (ksh), tcl | ||
| HTML, JavaScript, ASP | ||
| Visual Basic | ||
| Smalltalk, Progress 4GL | ||
| Tools & Frameworks | ||
| Oracle Warehouse Builder | ||
| Oracle Data Integrator (Sunopsis) | ||
| Informatica Powercenter | ||
| Cronacle | ||
| Microsoft Integration Services | ||
| Modeling methodologies | ||
| Data Vault Modeling | ||
| Dimensional Modeling for OLAP | ||
| UML | ||
| Structured analysis/ structured design | ||
| Object-oriented pre-UML methodologies (Rumbaugh, Booch, etc.) | ||