Keywords
Business Intelligence
Microsoft SQL Servers
SQL Server Integration Services
Data Warehousing
IBM Cognos Business Intelligence
Transact-SQL
Algorithms
Architecture
Business Requirements
Make decisions
Skills
10+ years of Business Intelligence, Data Warehousing and Reporting Solutions, development, architecture and consultancy experience.
My skills are covering the complete life-cycle of BI/DWH solutions from business requirements, ETL development, Data Warehouse, OLAP, standard and custom reporting, testing and delivery.
Proficiency in Data Modeling, SQL Server development (T-SQL) and Business Intelligence (BI) and MS BI Stack (SSIS, SSAS, SSRS) and Cognos.
Ability to design & implement any logic/algorithm and solve any T-SQL and BI challenges.
* Creating new ideas, new ways of doing things.
* Strong decision making and problem solving skills.
* Able to handle challenges, with proven history of increased productivity.
* Constantly looking for ways to improve processes.
My skills are covering the complete life-cycle of BI/DWH solutions from business requirements, ETL development, Data Warehouse, OLAP, standard and custom reporting, testing and delivery.
Proficiency in Data Modeling, SQL Server development (T-SQL) and Business Intelligence (BI) and MS BI Stack (SSIS, SSAS, SSRS) and Cognos.
Ability to design & implement any logic/algorithm and solve any T-SQL and BI challenges.
* Creating new ideas, new ways of doing things.
* Strong decision making and problem solving skills.
* Able to handle challenges, with proven history of increased productivity.
* Constantly looking for ways to improve processes.
Project history
Toptal (December 2018. - )
o Freelance Toptal Database Developer
--------------------------------------------------------
SR Technics Services (April 2017. - )
o Business Intelligence Solution Manager
Duties:
Developing of BI solutions with QlikView and SAP Bex Tools
Following and enhancing SAP BW and QlikView load procedures
Monitoring of data quality in SAP BW and QlikView process
--------------------------------------------------------
Datasport AG (via Upwork) (August 2016. - )
o Freelance Senior SQL Developer
Duties:
Wrote an SQL ranking calculation of athletes in competitions.
Optimized the database and query tuning.
Provided SQL support for live events.
--------------------------------------------------------
MultiBase GmbH (via Upwork) (August 2016. – February 2018)
o Freelance Senior BI Developer
Duties:
Developed and enhanced BI solutions.
Wrote reports using Microsoft Reporting Services and Microsoft Excel.
Implemented a DWH system using the Data Vault model.
--------------------------------------------------------
Addiko Bank a.d. Beograd (May 2012. – April 2017)
o Senior Officer - DWH and BI Architect (Nov. 2014. – Apr. 2017)
o Officer for DWH & BI Development (May 2012. – Oct. 2014)
Projects:
o COGNOS Planning Tool HBSE
o HBSE Retail Risk Data-management & Infrastructure
o Credit and deposit portfolio, and other analytics reports with market interest method calculation for financial controlling department
o Implementation of Banking Data Warehouse and Reporting System (Temenos T24 - ETL Informatica PowerCenter - Cognos).
Duties:
Technical Lead for DWH/BI Team.
Analysis of business requirements. Working with Business Division on specification definition, test support, customization and parameterization.
Training new team members.
Dimensional modeling, Data modeling (Erwin), Data model definition (DW design and data mart design), ETL development (SSIS, Informatica PowerCenter).
Report implementation (SSRS, Cognos, Excel).
Reporting and ETL automation and optimization.
Organize and provide training for users.
--------------------------------------------------------
IT Excellence (February 2012. – April 2012)
o Senior BI Developer
Projects:
o Findomestic Banka Beograd
Optimization of ETL process.
Developing CDC (Change Data Capture) system and surrogate key architecture.
--------------------------------------------------------
Asseco SEE
* Business Intelligence department (June 2008. – June 2010.)
o BI Software developer
Projects:
o Credit Risk – Banca Intesa Beograd
o Market risk – Privredna Banka Beograd
o Developing of business intelligence system in following banks: Meridian banka - Novi Sad, Tutunska banka - Skoplje, IK banka - Skoplje, Stopanska banka - Bitolj, Ohridska banka - Ohrid, Stater banka – Skoplje, Komercijalna banka - Skoplje. IBM Banking and Financial Markets Data Warehouse model have been implemented.
* Reporting department (July 2010. – January 2012.)
o Independent Software developer
Projects:
o Developing of reports in several domestic banks: Komercijalna banka Beograd, Privredna banka Beograd, Marfin banka, Univerzal banka, Agro banka…
o Implementation of Risk Management application: IK Banka Zenica, Sinergija Banja Luka.
o Implementation of Anti Money Laundering module and Provision Calculation Application in Investiciono Komercijalna Bank Zenica, Bosnia and Herzegovina
o Developing and implementation days past due scoring category in Univerzal Banka Beograd, Procredit Banka.
o Freelance Toptal Database Developer
--------------------------------------------------------
SR Technics Services (April 2017. - )
o Business Intelligence Solution Manager
Duties:
Developing of BI solutions with QlikView and SAP Bex Tools
Following and enhancing SAP BW and QlikView load procedures
Monitoring of data quality in SAP BW and QlikView process
--------------------------------------------------------
Datasport AG (via Upwork) (August 2016. - )
o Freelance Senior SQL Developer
Duties:
Wrote an SQL ranking calculation of athletes in competitions.
Optimized the database and query tuning.
Provided SQL support for live events.
--------------------------------------------------------
MultiBase GmbH (via Upwork) (August 2016. – February 2018)
o Freelance Senior BI Developer
Duties:
Developed and enhanced BI solutions.
Wrote reports using Microsoft Reporting Services and Microsoft Excel.
Implemented a DWH system using the Data Vault model.
--------------------------------------------------------
Addiko Bank a.d. Beograd (May 2012. – April 2017)
o Senior Officer - DWH and BI Architect (Nov. 2014. – Apr. 2017)
o Officer for DWH & BI Development (May 2012. – Oct. 2014)
Projects:
o COGNOS Planning Tool HBSE
o HBSE Retail Risk Data-management & Infrastructure
o Credit and deposit portfolio, and other analytics reports with market interest method calculation for financial controlling department
o Implementation of Banking Data Warehouse and Reporting System (Temenos T24 - ETL Informatica PowerCenter - Cognos).
Duties:
Technical Lead for DWH/BI Team.
Analysis of business requirements. Working with Business Division on specification definition, test support, customization and parameterization.
Training new team members.
Dimensional modeling, Data modeling (Erwin), Data model definition (DW design and data mart design), ETL development (SSIS, Informatica PowerCenter).
Report implementation (SSRS, Cognos, Excel).
Reporting and ETL automation and optimization.
Organize and provide training for users.
--------------------------------------------------------
IT Excellence (February 2012. – April 2012)
o Senior BI Developer
Projects:
o Findomestic Banka Beograd
Optimization of ETL process.
Developing CDC (Change Data Capture) system and surrogate key architecture.
--------------------------------------------------------
Asseco SEE
* Business Intelligence department (June 2008. – June 2010.)
o BI Software developer
Projects:
o Credit Risk – Banca Intesa Beograd
o Market risk – Privredna Banka Beograd
o Developing of business intelligence system in following banks: Meridian banka - Novi Sad, Tutunska banka - Skoplje, IK banka - Skoplje, Stopanska banka - Bitolj, Ohridska banka - Ohrid, Stater banka – Skoplje, Komercijalna banka - Skoplje. IBM Banking and Financial Markets Data Warehouse model have been implemented.
* Reporting department (July 2010. – January 2012.)
o Independent Software developer
Projects:
o Developing of reports in several domestic banks: Komercijalna banka Beograd, Privredna banka Beograd, Marfin banka, Univerzal banka, Agro banka…
o Implementation of Risk Management application: IK Banka Zenica, Sinergija Banja Luka.
o Implementation of Anti Money Laundering module and Provision Calculation Application in Investiciono Komercijalna Bank Zenica, Bosnia and Herzegovina
o Developing and implementation days past due scoring category in Univerzal Banka Beograd, Procredit Banka.
Local Availability
Open to travel worldwide
Youtube - Video
My approach of creating DWH - CDC - Surrogate keys