Späť na profesionálov

BI Analyst & DWH Developer & Data Analyst & Oracle Developer

Prehľad


Krátke zhrnutie

Kandidát je odborník na Business Intelligence s približne 9-ročnými skúsenosťami s DW a ETL riešeniami, pričom 6 rokov pracuje s databázami Oracle. Nachádza sa v Záhrebe a uprednostňuje určitý hybridný režim práce, pričom 3 dni v týždni pracuje z domu a 2 dni v kancelárii. V kancelárii môže byť aj počas onboardingového obdobia niekoľko mesiacov. Dokáže komunikovať v angličtine a je otvorený práci na dlhodobých aj krátkodobých projektoch, v menších aj väčších tímoch. Štandardné zamestnanie je jeho silnou preferenciou. Novú pozíciu aktívne nehľadá, ale je otvorený hovoriť o možnostiach a v prípade zaujímavej ponuky je schopný zmeniť prácu. Na svojej aktuálnej pozícii má výpovednú lehotu 1 mesiac.

Pracovné skúsenosti

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).
Author
BI Analyst & DWH Developer +2
62f4b8af43071a00115661b7
Zamestnanec3350  / Mesačne
ÚroveňSENIOR
Role
BI Analyst DWH Developer Data Analyst Oracle Developer
Jazyky
English
Zručnosti
Business InteligenceContainer Engine SoftwareContainerization SoftwareDatabaseDevOpsDockerMicrosoft Power BIMicrosoft SQL ServerOperation SystemsOraclePL/SQLPandasPostgreSQLPythonSQLT-SQLTableauUnix
Lokality
ZagrebRemote