Vladimir Jednak available

Vladimir Jednak

Business Intelligence; DWH developer; T-SQL tuning

Profileimage by Vladimir Jednak Business Intelligence; DWH developer; T-SQL tuning from Belgrade
  • 11070 Belgrade Freelancer in
  • Graduation: Master of organizational sciences - IT
  • Hourly-/Daily rates:
  • Languages: English (Full Professional)
  • Last update: 01.10.2018
Profileimage by Vladimir Jednak Business Intelligence; DWH developer; T-SQL tuning from Belgrade

You need an account to view this information.

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.
Toptal (December 2018. - )
o Freelance Toptal Database Developer
SR Technics Services (April 2017. - )
o Business Intelligence Solution Manager
 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
 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
 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)
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).
 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
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
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
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.


My approach of creating DWH - CDC - Surrogate keys