Candidate is a Business Intelligence Expert with approximately 9 years of experience with DW and ETL solutions, with 6 years working with Oracle databases. He is located in Zagreb and he prefers some hybrid regime of working, with 3 days a week working from home and 2 in the office. He is also able to be in the office during the onboarding period for several months. He can communicate in English and is open to working on both long-term and short-term projects, in both smaller and bigger teams. Standard employment is a strong preference of him. He is not looking for a new position actively, but he is open to speaking about opportunities, and in case of an interesting offer, he is able to switch the job. In his actual position, he has a notice period of 1 month.

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).