Profileimage by Anonymous profile, BI AND DATA WAREHOUSE  CONSULTANT
available

Last update: 26.09.2022

BI AND DATA WAREHOUSE CONSULTANT

Graduation: BSc Organization and Management of Information Systems
Hourly-/Daily rates: show
Languages: German (Elementary) | English (Full Professional) | Croatian (Full Professional)

Attachments

blazjudnic.pdf

Skills

data warehouse, ETL framework, PL/SQL, Oracle, database, Google Big Query platform, Google Data Studio, Jira, Confluence, Crystal Reports, data integration, ERP, data migration, MS SQL, programming, T-SQL procedures, SSIS packages, Sharepoint development, Database administration, SAP ERP, backend, data mapping, DWH, ETL, Oracle 12c, data quality, data manipulation, versioning, SVN, OLAP, MS SQL Server, Oracle database, MDM, master data managment, Oracle E-Business Suite, functional specifications, Apex 4.0, Suite, Java, database optimization, SQL, query optimization, Oracle Forms, Reports, automated tests, Microsoft, Excel, Word, Oracle Reports Builder, Microsoft Reports Builder, RDLC, PL\\SQL SQL Management Studio, Microsoft SQL, Oracle SQL Advanced SQL, Jira Tableu

Project history

01/2019 - 02/2022
BUSINESS&DATA ANALYST
Brestanica; DS SMITH D.O.O.

* preparation of reports for the for different departments (sales, controlling, production), reports are
created with the Crystal Reports tool,
* managing daily reporting - more than 100 automatic reports per day,
* managing monthly reporting - preparing and checking data, gathering data from other colleges,
prepare physical monthly book for management,
* data integration from different ERP systems - Kiwi and Baan (Infor),
* designed and developed ETL framework for data migration from Pervasive database to MS SQL -
approximately 150 tables are transferred to the final database daily with minimal additional
programming.

11/2018 - 04/2019
BI AND DATABASE DEVELOPER
ADD D.O.O.

* technical project management,
* support and development of ongoing tasks on Microsoft environment (T-SQL procedures, SSIS
packages, Sharepoint development, Database administration)
* technical project management,
* source analysis (SAP ERP).

01/2014 - 11/2018
ACTUARY ANALYST, IT PROJECT MANAGER, DATA WAREHOUSE SPECIALIST
GENERALI D.D.

* analysis of different application sources,
* data preparation for non life insurance from IVVR insurance backend application,
* data mapping from source to DWH model,
* writing ETL procedures for mapped data using PL/SQL using Oracle 12c version of database,
* preparing and implementing test scenarios for data quality,
* automatization of actuary reports,
* procedure standardization for data manipulation,
* setup and implementation of versioning control system - SVN,
* best practice design and implementation in ETL procedures,
* process setup and implementation for loading DWH ,




* implementation of loading Data Mart and Fact tables,
* designing OLAP Cubes in MS SQL Server,
* database administrator for MS SQL Server (no designated person in company, had to learn along)
* monitor Oracle database performance,
* optimizing loading procedures,
* managing MDM (master data managment),
* addin
* mentoring co-workers.
Address Ljubljana, Slovenia

01/2011 - 12/2013
BUSSINES ANALYST - APPLICATION SPECIALIST
OSIR D.O.O.

Development of additional functionalities in Oracle E-Business Suite and creation of independent
applications for specific needs in nuclear power plant.

* preparing functional specifications with end users,
* application development in Oracle Apex 4.0,
* advanced customization of functionalities in Oracle E-Business Suite using Java .


Address Ljubljana, Slovenia

01/2007 - 01/2011
DEVELOPER
HRC D.O.O.

Development and customizing of module Basel II.

* analysis, development and independent implementation of user requirements in PL/SQL on different
version of Oracle database - from 8.0 to 11,
* database optimization (SQL query optimization, help with database setup),
* front end user entry interfaces and custom reports using Oracle Forms and Reports,
* writing manuals for end users,
* writing and executing automated tests,
* preparing installation scripts.

Local Availability

Only available in these countries: Slovenia
Occasionally I can travel to locations if needed.  

Other

In my profesional history I have worked with two most widely used databases - Oracle and Microsoft SQL.

Most working experiences comes from Oracle, but I have succesfuley mixed Oracle know how on Microsoft SQL. My most powerful skill is SQL and
I love using analytical functions. They are really a great way to simple and effective solve a lot of different "loop" tasks. I'm also proficient in PL/SQL and
T-SQL. But PL/SQL is on my strong side. On Microsoft I can do also some minor DBA tasks, mostly because Microsoft is simpler to maintain. If you are working
on Oracle database the DBA does not allow you to mess with the database. In one of my job I have also learned to code in Java, but I havent maintain my Java knowledge. 
But that helped me that I can read all the Java and .net code. On vendor specific tools I have done development in Oracle Apex - 4.0 and a lot of ETL specific tasks
in Sql Integration Services (SSIS). I hvae used some DAX and MDX in couple of Excel Power pivot files and in Analytical cube. 

In my spare time I started to learn Python and I am very  mpressed how quickly you can get a meaningful result. I have tried also how to make dashboard 
Power BI and Tableu. That part interest me, but havent had the opportunity to used it professionaly. 

Beside technical skills I know how to model a database tables, can relate to bussines users and translate their demands into working result.
Profileimage by Anonymous profile, BI AND DATA WAREHOUSE  CONSULTANT BI AND DATA WAREHOUSE CONSULTANT
Register