freiberufler Data engineering & DWH-BI Consulting services auf freelance.de

Data engineering & DWH-BI Consulting services

zuletzt online vor 4 Tagen
  • 30‐60€/Stunde
  • 10000 Zagreb
  • auf Anfrage
  • hr  |  en  |  de
  • 18.04.2024

Kurzvorstellung

Highly motivated and certified IT professional with diverse and extensive Data engineering, BI and DWH experience in enterprise systems architecture, design, analysis, and solutions. With more than 20 years of experience.

Qualifikationen

  • Datawarehouse / DWH
  • Oracle Database
  • PL/SQL
  • Apache
  • Microsoft Power BI
  • Microsoft SQL-Server (MS SQL)
  • Microsoft SQL Server Analysis Services (SSAS)
  • Microsoft SQL Server Integration Services (SSIS)
  • Microsoft SQL Server Reporting Services (SSRS)
  • Oracle Application Express (Oracle APEX)
  • Oracle Business Intelligence (BI)
  • Oracle Fusion Middleware (OMF)
  • PostgreSQL
  • Tableau
  • Transact-SQL (T-SQL)
  • Visual Studio

Projekt‐ & Berufserfahrung

Data Architect, Data Engineer, Data Analyst
DAB BNP Paribas S.A., Munich
7/2020 – offen (3 Jahre, 11 Monate)
Banken
Tätigkeitszeitraum

7/2020 – offen

Tätigkeitsbeschreibung

DWH MAINTAINANCE & UPGRADES (2021 - today)
An ongoing project that aims to improve ODI mapping implementation and overall data quality. In cooperation with internal DWH team, best practices for ETL development using ODI 12c are being established while developing model and mappings that meets new business requirements or changes to existing.

OWB TO ODI12 MIGRATION (2020 - 2021)
ETL platform migration project included 1500 mapping migrated from OWB to ODI12c using migration utility tool. Recurring migration errors were detected during testing and fixed in new environment using groovy scripts, while complex ODI mapping were redesigned and optimized. Extensive data testing was done for each target table using developed data test tool.

Eingesetzte Qualifikationen

Oracle Fusion Middleware (OMF), Apache, Datawarehouse / DWH, Oracle Database, PL/SQL

Data Architect, Data Engineer, Data Analyst, System Architect
Ministry of Justice and Public Administration, Zagreb
12/2019 – offen (4 Jahre, 6 Monate)
Öffentliche Verwaltung
Tätigkeitszeitraum

12/2019 – offen

Tätigkeitsbeschreibung

IMPROVEMENT OF THE REPORTING SYSTEM (ESPIS) WITHIN THE NATIONAL RESILIENCE PLAN (2023 - today)
The primary objective of this project is to enhance the efficiency, scalability, and reliability of the reporting infrastructure under the National Resilience Plan. This will be achieved through the migration of existing reporting, ETL (Extract, Transform, Load), and database systems into a purpose-built cloud service. Additionally, there will be a focus on developing new reports to meet evolving requirements.

BI AND REPORTING SYSTEM MAINTANANCE (ESPIS) (2020 - today)
Maintenance of a statistical reporting system for the Ministry of Justice encompassing approximately 300 reports and adequate ETL processes for populating the Data Warehouse (DWH).

BI AND REPORTING SYSTEM DEVELOPMENT (ESPIS) (2020)
Development and design of a statistical reporting system for the Ministry of Justice encompassing approximately 300 reports and adequate ETL processes for populating the Data Warehouse (DWH).

Eingesetzte Qualifikationen

Oracle Fusion Middleware (OMF), Oracle Business Intelligence (BI), Oracle Database, PL/SQL, Tableau

Data Architect, Data Engineer, Data Analyst, BI Engineer, System Architect, BI Engineer
Zagrebacka banka UniCredit Group, Zagreb
9/2019 – offen (4 Jahre, 9 Monate)
Banken
Tätigkeitszeitraum

9/2019 – offen

Tätigkeitsbeschreibung

EARLY WARNING SIGNALS & FORBEARANCE HARMONISATION (2024 - today)
Harmonization of early warning signals, forbearance modules and "unlikely to pay" events. Preparation of various input data for the EWS module (early warning signals), including LTV, DSCR, various
HROK and GFI data, data set from the underwriting process. Downloading the prepared data to the EWS module. Implementation of new events in the DOD process. Improvement of the forbearance module. A series
of reports in PBI for credit risk monitoring.

SIRON REPLACEMENT (2023 - today)
New replication processes of objects from the transaction system to the Staging Area as part of DWH on Exadata and expansion of existing replication processes, Data export with parameterization, Optimization of existing replication processes, Support in the testing process, Monitoring mechanism of creating and sending files, Automation mechanism with user interface and delivery of historical data.

GLOBAL PAYMENT SOLUTIONS (2023 - today)
Data integration from multiple core systems into the ISO 20022 Payment model - data is replicated from transaction systems to the DWH staging area and transferred to Payment data model. Project goal is to automate data flow and development of Data products according to the Data Mesh architecture on Google Cloud (SWIFT, SEPA, SEPA SDD, DOMESTIC, CARD ACQ, CARD ISS, CASH, Customer data).

MIGRATION TO MASTERCARD BRAND (2023 - today)
Migration of VISA to Mastercard there is need to create new products with doing commercial launch until end of April 2024 with support for production afterwards. Processing changes for new products, Migration of existing portfolio to new products, Changes in scripts for different file transfers.

KPI WORKOUT AND CREDIT RISK ENHANCEMENTS (2023 - 2023)
Improvement of NPE (non-performing) reporting by implementing new KPIs for WO (work-out) portfolio for better management of NPE clients and selection of the best strategy for WO clients.

DWH EURO CURRENCY ADOPTION - PLANNING & CONTROLLING UPGRADE / CREDIT RISK / CRYSTAL (2022 - 2023)
Planning, execution, and system modifications to facilitate integration of the EUR currency into financial reporting and operations within Eurozone regulations. Project activities included analysis of existing system, transition planning, preparation of new infrastructure, data model enhancements, data migration and modifications of the ETL/ELT procedures (business and technical adaptations).

CREDIT RISK DATA ARCHITECTURE PROJECT IT SUPPORT (2021 - 2022)
Credit Risk DWH development and enhancements. Implementation of KPIs for workout clients, module for economic connected clients, client IRB - SME classification, tracking of underwriting and credit exposure check for private and business subjects.

CROATIAN CREDIT OBLIGATIONS REGISTRY (HROK) DATA ENHANCEMENTS (2021)
Credit Risk DWH development and enhancements. Data consolidation, analysis, and reporting on all credit activities of legal and physical bank clients for the purpose of data exchange with other financial institutions. Consolidated data are being sent into HROK (Croatian Register of Loan Obligations). Implementation of module for tracking of underwriting and credit exposure check for private and business subjects.

ANTI-MONEY LAUNDERING ENHANCEMENTS (2020)
DWH enhancements at strengthening capabilities of Zagrebačka banka to deal with financial misconduct and comply with regulatory requirements. Activities are related with implementation of framework, data model and ETL for near-real-time DWH module focused on client's cash transactions. The data collected is utilized in applications to enhance client information and risk assessment.

CREDIT RISK - RETAIL UNDERWRITING MONITORING KPI (2019 - 2020)
Credit Risk Datamart enhancements are related to changes in the DWH data infrastructure, including data model an ETL procedures and reporting to enhance monitoring capabilities for Retail Underwriting processes. Project entails the implementation of standardized Key Performance Indicators (KPIs) to elevate risk assessment and decision-making processes.

ASSET QUALITY REVIEW (AQR 19) (2019)
Enhancing data infrastructure to support the comprehensive assessment of asset quality within the financial institution. Credit File Review Work Stream in the collateral area focuses on preparing, assessing and enhancing the quality of collateral data within financial institutions evaluating the adequacy and accuracy of collateral assets which directly impacts the overall risk assessment. The project is a crucial component of regulatory compliance and risk management, ensuring accurate reporting and analysis of asset quality metrics.

Eingesetzte Qualifikationen

Oracle Fusion Middleware (OMF), Microsoft Power BI, Oracle Application Express (Oracle APEX), Oracle Database, PL/SQL

Data Architect, Data Engineer, Data Analyst, Project Manager
Raiffeisenbank Austria, Zagreb
6/2019 – offen (5 Jahre)
Banken
Tätigkeitszeitraum

6/2019 – offen

Tätigkeitsbeschreibung

INTEGRATING GROUP PRODUCT INTO DWH (2024 - today)
Upgrading Data Warehouse (DWH) by integrating products from group members and seamlessly aligning it with CRM system. Key responsibilities include analysing business requirements and documentation, extending the existing data model to adapt new products, and implementation and redesign of ETL processes to ensure seamless integration.

INTEGRATING SME INTO OCRM (2023)
Integration project for incorporating small and medium legal entities customer segment into operational CRM system. The project encompassed multiple objectives: firstly, the migration of IBM DataStage jobs initially tailored for the retail customer segment to Oracle ODI 12c, ensuring a smooth transition. Secondly, to design and implement an ETL (Extract, Transform, Load) solution specifically meeting the needs of the small and medium legal entities customer segment. In all project phases the focus was to speed up operations, improve data integrity and streamline future maintenance efforts.

DWH EURO CURRENCY ADOPTION (2022 - 2023)
Planning, execution, and system modifications to facilitate integration of the EUR currency into financial reporting and operations within Eurozone regulations. Project activities included analysis of existing system, transition planning, preparation of new infrastructure, data model enhancements, data migration and modifications of the ETL/ELT procedures (business and technical adaptations).

MIGRATION TO NEW DATA ARCHITECTURE (2020 - 2022)
Migrating and transforming existing IBM DataStage infrastructure to Oracle ODI12c. Within the new data architecture, Oracle ODI12c leverages a Data Lake as a primary data source, where data from source systems is replicated on HDFS with the presentation layer hosted on a PostgreSQL database. Orchestration of all components that refresh data lake and execute Oracle ODI mappings was implemented using Apache Airflow.

DWH SYSTEM UPGRADE AND MAINTENANCE (2019 - 2020)
Upgrading and maintenance of the existing DWH system. Tasks include implementation of new and upgrading of existing functionalities of DWH. Additional tasks include upgrading and maintaining the system for integrating data from business (core) systems and DWH with the mobile banking system (near real time updating of data in the mobile application).

Eingesetzte Qualifikationen

Apache, Oracle Database, Oracle Fusion Middleware (OMF), PostgreSQL

Data Architect, Data Engineer, Data Analyst, BI Engineer, Project Manager, System Architect, Team Lead
Wiener Osiguranje Vienna Insurance Group, Zagreb
12/2018 – offen (5 Jahre, 6 Monate)
Versicherungen
Tätigkeitszeitraum

12/2018 – offen

Tätigkeitsbeschreibung

DATA WAREHOUSE & BUSINESS INTELLIGENCE PROJECT (2018 - today)
As part of the ongoing efforts to enhance and consolidate reporting systems and business processes, Wiener osiguranje Vienna Insurance Group d.d. has launched the Data Warehouse and Business Intelligence (BI) project. Given complexity of Client’s existing core systems and legacy systems (resulting from multiple mergers) during the analysis phase was clear that final solution will require tailored Data model to support all the business needs. New data architecture, built upon Microsoft stack, included all important layers: Staging and Operational Data Store, serving as a Data Lake to store and manage the complete history of all core applications and systems on daily basis, Enterprise Model, consolidating insurance data from multiple sources into a unified framework, Target Model, adopting a Star model design optimized for reporting and analytical purposes, Reporting layer, featuring 150+ standardized SSRS reports, as well as Ad Hoc reporting capabilities through SSAS (Tabular model) and Power BI. The daily and monthly data loading dynamics have been completely automated using DataShift's integration framework. Data integrity has been upheld through the implementation of a Data Quality Module, having more than 200 checks and rules that notify users of any inconsistencies detected within core systems or across various core systems, ensuring the quality of the company's data. Over time, the new Data Warehouse (DWH) evolved into the client's core system, serving as the foundation for regulatory, group, and internal reporting. It is the consolidated data source for sales applications and various external systems, including CRM, Mobile App, Reinsurance App, Prophet, Res-Q…

CUSTOMER & AGENT 360 PROJECT (2022 - 2024)
Implementation of comprehensive view of customers and sales agents on daily basis. It involves data modelling, integrating and consolidating customer and agent data from multiple core systems and implementing analytics & KPI's to enhance service delivery, sales strategies, and operational efficiency. Insurance areas covered are Sales realization, Renewal rates, Expiration portfolio, Plan fulfilment, Commission overview, Claims, Open due premium...

IFRS17 STANDARD DWH IMPLEMENTATION (2022 - 2023)
Implementation of IFRS17 accounting standards in Wiener osiguranje Data Warehouse (DWH) system with objective to facilitate accurate and transparent financial reporting in accordance with standard's requirements while optimizing data management processes within the DWH. This process involves several key activities, including assessing data readiness, designing data models, developing calculation engines, integrating with actuarial calculations, ensuring data governance, and establishing ongoing monitoring and maintenance procedures. The main activities focus on enhancing the core Data Warehouse (DWH), extending the data model, and loading historical data to support necessary functionalities. New Data Mart has been established to facilitate the export of records prepared for processing in the VIG Group IFRS solution.

DWH EURO CURRENCY ADOPTION (2022 - 2023)
Planning, execution, and system modifications to facilitate integration of the EUR currency into financial reporting and operations within Eurozone regulations. Project activities included analysis of existing system, transition planning, preparation of new infrastructure, data model enhancements, data migration and modifications of the ETL/ELT procedures (business and technical adaptations).

COMMISSION MANAGEMENT SOLUTION (2020 - 2022)
Project is set to redesign, digitalize and automate commission management processes across multiple Departments within Company. During the first phase the project included: Consolidation of commission calculation data from all core systems into the DWH, Parameterization of commission calculation (interventions in the calculation process and commission payment), Implementation of additional algorithms on consolidated commission data, Fee and bonus commission allocation for the IFRS17 project, Implementation of an analytical reporting module, Standardized reports for monitoring and reporting, Integration with booking processes (incentives, salaries, external partner fees, automation of journal entries for SAP general ledger), Automation of processing in daily mode, Integrating data to external systems/applications, Data Quality module for data administration and synchronization among core systems. During the second phase, the decommissioning of the core system led to the implementation of the calculation algorithm as an upgrade to the existing module.

REO MODULE - RENSURANCE CALCULATION AND REPORTING (2018 - 2019)
Reinsurance Calculation and Reporting Module involves creating a specialized module connected to the Data Warehouse (DWH) to handle reinsurance-related calculations and reporting. This project includes the integration of reinsurance data sources, parametrizations, development of calculation algorithms, implementation of reporting and analytics functionalities and ensuring compliance with regulatory requirements. The project's objective is to provide a daily automated solution that streamlines the reinsurance calculation process, mitigates the risk of manual error and decreases the time needed for reinsurance calculations during the reporting period closure.

Eingesetzte Qualifikationen

Microsoft Power BI, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Transact-SQL (T-SQL), Visual Studio

Zertifikate

Oracle Cloud Data Management 2023 Certified Foundations Associate
Oracle
2023
Oracle Cloud Infrastructure 2023 AI Certified Foundations Associate
Oracle
2023
Oracle Cloud Infrastructure 2023 Certified Foundations Associate
Oracle
2023
Oracle Cloud Infrastructure 2023 Certified Multicloud Architect Associate
Oracle
2023
Oracle Data Integrator 12c Certified Implementation Specialist
Oracle
2017
Oracle Business Intelligence Foundation Suite
Oracle
2016
Oracle PL/SQL Developer Certified Professional
Oracle
2015
Tableau Desktop Qualified Associate
Tableau
2015
SAP Certified Application Associate – SAP BusinessObjects Business Intelligence Platform
SAP
2015
Oracle Database SQL Certified Expert
Oracle
2014
Oracle PL/SQL Developer Certified Associate
Oracle
2014

Ausbildung

Master of Mathematics/Master of Electrical Engineering/University Specialist in Actuarial Mathematic
University Graduate Study/University Post Graduate Study
University of Zagreb
2014
Zagreb

Über mich

Extensive expertise in designing and implementing enterprise data solutions, successfully delivered numerous complex projects with areas of expertise:
• Technical and Business Requirements Analysis & Documenting
• Database Design and Architecture
• Data Model Design and Implementation
• Data engineering – ETL/ELT Implementation and Optimization
• System integration
• Reporting/BI System Design, Implementation and Optimization
• System modernization, migration of outdated software solutions
• Optimization and performance enhancement of information systems
• Data Governance and Data Quality

Weitere Kenntnisse

ORACLE TECHNOLOGY STACK EXPERTISE:
Oracle Database EE, Oracle Database SE, Oracle Exadata, Oracle Exalytics, Oracle SQL/PLSQL, Oracle Warehouse Builder, Oracle Data Integrator 11g/12c, Oracle APEX, Oracle BI Publisher 10g, Oracle Forms & Reports 10/11g, Oracle Designer 10g, Oracle Business Intelligence EE 11g/12c

MICROSOFT TECHNOLOGY STACK EXPERTISE:
SQL Server, SQL/T-Sql, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microsoft Visual Studio, Microsoft Power BI


SAP Business Objects, IBM Datastage, IBM DB2, PostgreSQL, Apache Hadoop, Hive, Apache Airflow, Apache NiFi, Sqoop, Spark, Apache Groovy, R, Tableau, Pentaho, Talend, Jira, Confluence

Persönliche Daten

Sprache
  • Kroatisch (Muttersprache)
  • Englisch (Fließend)
  • Deutsch (Grundkenntnisse)
Reisebereitschaft
auf Anfrage
Arbeitserlaubnis
  • Europäische Union
  • Schweiz
  • Vereinigte Staaten von Amerika
Home-Office
bevorzugt
Profilaufrufe
119
Alter
51
Berufserfahrung
26 Jahre und 1 Monat (seit 04/1998)
Projektleitung
10 Jahre

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden