Data Warehouse Architect2019 - PRESENTSpartan Race Inc (via Toptal)
Technologies: PostgreSQL 9.6, Looker
- Created a DWH model using the Data Vault model.
- Created a data mart model for reporting with the star schema.
- Wrote ETL/SQL scripts.
- Created metadata tables for configurations and mapping tables for data load and calculations.
- Developed visualizations with Looker.
Business Intelligence Consultant2019 - PRESENTDataClue GmbH (Freelance)
Technologies: SQL Server, Power BI
- Created a data mart model for financial reporting.
- Developed ETL/SQL procedures.
- Developed visualizations with Power BI and DAX calculations.
- Implemented time comparison calculations, and calculations for quantity, product mix, and price impact on revenue and material costs.
Business Intelligence Solution Manager2017 - 2019SR Technics Services
Technologies: QlikView, SAP BW, SAP Bex Tools
- Developed BI solutions with QlikView and SAP Bex Tools.
- Followed and enhanced SAP BW and QlikView load procedures.
- Monitored and upheld data quality in SAP BW and QlikView process.
Freelance Senior SQL Developer2016 - 2019Datasport, Ltd. (via An Online Freelance Agency)
Technologies: SQL Server
- Wrote an SQL ranking calculation algorithm of athletes in competitions.
- Optimized the database and query tuning.
- Provided SQL support for live events.
Freelance Senior BI Developer2016 - 2017Multibase (via An Online Freelance Agency)
Technologies: SQL Server, SSIS, SSRS
- Developed and enhanced BI solutions.
- Wrote reports using Microsoft Reporting Services and Microsoft Excel.
- Implemented a DWH system using the data vault model.
Senior Officer | DWH and BI Architect2012 - 2017Addiko Bank a.d. Beograd
Technologies: SQL Server, SSIS, Cognos, SSRS, DB2
- Implemented a banking data warehouse and reporting system (Temenos T24, ETL Informatica PowerCenter, Cognos).
- Credited and deposited a portfolio, and other analytics reports with a market interest method calculation for the financial controlling department.
- Managed and architected the infrastructure for the HBSE retail risk data; including the risk datamart and reporting.
- Developed the COGNOS planning tool, HBSE.
- Implemented dimensional and data (Erwin) modeling.
- Defined the models (data warehouse and data mart designs).
- Worked on ETL development (SSIS, Informatica PowerCenter); including reporting and ETL automation and optimization.
Senior BI Developer2012 - 2012IT Excellence
Technologies: SQL Server, SSIS
- Optimized ETL process (SSIS).
- Developed a CDC (change data capture) system and surrogate key architecture.
Independent Software Developer2010 - 2012Asseco SEE
Technologies: SQL Server, T-SQL
- Implemented a risk management application: IK Banka Zenica, Sinergija Banja Luka.
- Built an anti-money laundering module and a provision calculation application for Investiciono Komercijalna Bank Zenica, Bosnia and Herzegovina.
- Developed and implemented a past-due scoring category for Univerzal Banka Beograd, Procredit Banka.
- Wrote the reports for several domestic banks: Komercijalna Banka Beograd, Privredna Banka Beograd, Marfin Banka, Univerzal Banka, Agro Banka, and more.
BI Software Developer2008 - 2010Asseco SEE
Technologies: SQL Server, SSIS
- Developed a business intelligence system for several banks in Serbia and Macedonia.
- Wrote reports using Microsoft Reporting Services (SSRS) and Microsoft Excel.
- Modeled, designed, and implemented a system to automatically generate reports.
- Tested reports with the business part of the banks.
- Provided support to the IT and business parts of the banks.