Kandidát je odborník na Business Intelligence s přibližně 9 lety zkušeností s řešeními DW a ETL, z toho 6 let s databázemi Oracle. Sídlí v Záhřebu a preferuje určitý hybridní režim práce, kdy 3 dny v týdnu pracuje z domova a 2 dny v kanceláři. Je také schopen být v kanceláři během onboardingového období po dobu několika měsíců. Domluví se anglicky a je otevřený práci na dlouhodobých i krátkodobých projektech, v menších i větších týmech. Standardní zaměstnání je jeho silnou preferencí. Novou pozici aktivně nehledá, ale je otevřen se o možnostech bavit a v případě zajímavé nabídky je schopen práci změnit. Na své aktuální pozici má výpovědní lhůtu 1 měsíc.

Work Experience:

1) Business Intelligence Expert:

• Created new dashboards in PowerBI.
• Maintained existing dashboards in PowerBI.
• Administered PowerBI reports (scheduling, permissions, single role groups).
• Created static (table-based) reports in Microsoft Reporting Services (MSRS).
• Maintained existing reports in MSRS.
• Administered MSRS reports (scheduling, permissions).
• Participated in activities and projects as part of a larger team.
• Maintained specific system and process components.
• Conducted training for new employees on database relations, source systems, ETL processes, and business logic.

2) Data Scientist:

• Defined data warehouse and ETL processes.
• Developed data warehouse (database, tables, indexes, relationships, constraints).
• Created ETL processes and scheduled them.
• Implemented comprehensive logging of processes.
• Modeled and improved algorithms for products.
• Modeled probabilities based on business cases.
• Evaluated model results and analyzed data.
• Built and interpreted probabilistic models for multidimensional datasets.
• Created and interpreted dynamic dashboard reports.
• Tested created models.

3) Data Warehouse Development Engineer (BI/DWH):

• Implemented DWH/BI system for Croatian Lottery.
• Created procedures and packages for data transfer.
• Optimized data transfer processes.
• Maintained and updated the existing system.
• Created and maintained Tableau dashboards and reports.
• Administered Tableau Server.
• Utilized Oracle SQL and Microsoft SQL Server for database maintenance.
• Optimized queries and created procedures.

4) Programmer Analyst:

• Created and maintained reports.
• Utilized Oracle SQL, Microsoft SQL Server, and Microsoft SSRS.
• Maintained databases and correlated data between three different systems.
• Optimized queries and created PL/SQL procedures.
• Provided user training.

5) Database Operator:

• Administered and maintained central database.
• Imported and processed raw data using ETL.
• Designed and developed new and existing databases.
• Created and updated tables, procedures, and functions.
• Optimized queries and exported data.
• Uploaded data to client server databases.
• Provided client support and application installation.

6) Mathematics Teacher:

• Taught mathematics at a primary school.
• Provided education and training.

Education:

• Master's degree in Mathematics, University of Zagreb, Faculty of Science, major in Mathematical Statistics (2010-2012).
• Bachelor's degree in Mathematics, University of Zagreb, Faculty of Science (2007-2010).
• High School Diploma, General Gymnasium, Srednja škola Dragutina Stražimira (2003-2007).

Digital Skills:

• Business Intelligence: PowerBI, Tableau, Microsoft Excel.
• Data Processing (ETL + SQL): Talend, Oracle SQL, Microsoft SQL Server, Microsoft SSIS, PostgreSQL.
• Certifications: Oracle Database 12c: SQL Fundamentals (1Z0-061).
• Other Skills: Apache Airflow, Cron Job, Unix (Basic).

Business Skills:

• Advanced knowledge of relational databases.
• Proficient in SQL for data retrieval and report creation (Oracle, MSSQL Server, PostgreSQL).
• PL/SQL, T-SQL.
• Project leader for Talend data warehouse project and data migration.
• Microsoft Integration Services (MSIS).