Power BI Expert
2020 - PRESENTClient via Toptal- Created interactive dashboards and reports in Power BI. Created advanced measures using DAX language.
- Data manipulation using Power Query. Created star schema as a reporting model.
- Data sources for Power BI: Oracle database, Excel files, Google Analytics.
Technologies: Data Modeling, DAX, Star Schema, Power Query M, Power Query, Microsoft Power BIData Warehouse Architect
2019 - PRESENTSpartan Race Inc (via Toptal)- 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.
Technologies: Looker, PostgreSQLBusiness Intelligence Consultant
2019 - PRESENTDataClue GmbH (Freelance)- 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.
Technologies: Microsoft Power BI, Microsoft SQL ServerBusiness Intelligence Solution Manager
2017 - 2019SR Technics Services- 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.
Technologies: Tools, SAP, SAP BW, QlikViewFreelance Senior SQL Developer
2016 - 2019Datasport, Ltd. (via An Online Freelance Agency)- Wrote an SQL ranking calculation algorithm of athletes in competitions.
- Optimized the database and query tuning.
- Provided SQL support for live events.
Technologies: Microsoft SQL ServerFreelance Senior BI Developer
2016 - 2017Multibase (via An Online Freelance Agency)- Developed and enhanced BI solutions.
- Wrote reports using Microsoft Reporting Services and Microsoft Excel.
- Implemented a DWH system using the data vault model.
Technologies: SSRS, SQL Server Integration Services (SSIS), Microsoft SQL ServerSenior Officer | DWH and BI Architect
2012 - 2017Addiko Bank a.d. Beograd- 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.
Technologies: IBM DB2, SSRS, IBM Cognos, Cognos 10, SQL Server Integration Services (SSIS), Microsoft SQL ServerSenior BI Developer
2012 - 2012IT Excellence- Optimized ETL process (SSIS).
- Developed a CDC (change data capture) system and surrogate key architecture.
Technologies: SQL Server Integration Services (SSIS), Microsoft SQL ServerIndependent Software Developer
2010 - 2012Asseco SEE- 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.
Technologies: T-SQL, Microsoft SQL ServerBI Software Developer
2008 - 2010Asseco SEE- 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.
Technologies: SQL Server Integration Services (SSIS), Microsoft SQL Server