Scroll To View More
Vladimir Jednak, Query Optimization Developer in Belgrade, Serbia
Vladimir Jednak

Query Optimization Developer in Belgrade, Serbia

Member since December 28, 2018
Vladimir has over a decade of experience in business intelligence, databases, data warehouses, reporting solutions, development, architecture, and consultancy; including having worked on the complete lifecycle of BI/DWH solutions. Vladimir has a passion for database optimization and query tuning and is constantly searching for ways to improve processes.
Vladimir is now available for hire

Experience

  • Query Optimization, 12 years
  • Data Warehousing, 12 years
  • SQL Server Integration Services (SSIS), 12 years
  • SQL, 12 years
  • SQL Performance, 12 years
  • Cognos 10, 5 years
  • QlikView, 2 years
Belgrade, Serbia

Availability

Part-time

Preferred Environment

SQL Server, SSIS, Cognos, QlikView

The most amazing...

...project I've done is a CDC (change data capture) solution created in SSIS.

Employment

  • Freelance Senior SQL Developer

    2016 - PRESENT
    Datasport Ltd. (via An Online Freelance Agency)
    • Wrote an SQL ranking calculation of athletes in competitions.
    • Optimized the database and query tuning.
    • Provided SQL support for live events.
    Technologies: SQL Server
  • Business Intelligence Solution Manager

    2017 - 2019
    SR 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: QlikView, SAP BW, SAP Bex Tools
  • Freelance Senior BI Developer

    2016 - 2017
    Multibase (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: SQL Server, SSIS, SSRS
  • Senior Officer | DWH and BI Architect

    2012 - 2017
    Addiko 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: SQL Server, SSIS, Cognos, SSRS, DB2
  • Senior BI Developer

    2012 - 2012
    IT Excellence
    • Optimized ETL process (SSIS).
    • Developed a CDC (change data capture) system and surrogate key architecture.
    Technologies: SQL Server, SSIS
  • Independent Software Developer

    2010 - 2012
    Asseco 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: SQL Server, T-SQL
  • BI Software Developer

    2008 - 2010
    Asseco 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, SSIS

Experience

Skills

  • Languages

    SQL, T-SQL, Stored Procedure, Transact-SQL
  • Tools

    IBM Cognos, SQL Server BI, Microsoft Power BI, BEx Reporting
  • Paradigms

    Database Design, Business Intelligence (BI), Database Development, ETL, ETL Implementation & Design, OLAP
  • Platforms

    Microsoft BI Stack, QlikView
  • Storage

    SQL Server Integration Services (SSIS), ANSI SQL, SQL Performance, Databases, SQL Stored Procedures, SQL Views, SQL Functions, Database Modeling, SQL Server Reporting Services (SSRS), SQL Server DBA, OLTP, SQL Server Analysis Services (SSAS), IBM DB2
  • Other

    Cognos 10, PL/SQL Tuning, Stored Procedures, Query Optimization, Data Visualization, Data Warehousing, Data Warehouse Design, Requirements & Specifications, MCSE | Business Intelligence, ETL Development, BI Reports, Data Reporting, Reporting, Reports, Power BI, SAP BW, SAP Business Warehouse (BW), SAP Business Intelligence (BI)

Education

  • Master's degree in IT (Information Systems and Technology)
    2008 - 2010
    University of Belgrade - Belgrade, Serbia
  • Bachelor's degree in IT ( Information Systems and Technology)
    1997 - 2008
    University of Belgrade - Belgrade, Serbia
Certifications
  • Microsoft Certified IT Professional: Database Developer 2008
    DECEMBER 2011 - PRESENT
    Microsoft
  • Microsoft Certified IT Professional: Business Intelligence Developer 2008
    MARCH 2011 - PRESENT
    Microsoft
  • Microsoft Certified Technology Specialist: SQL Server 2008, Database Development
    JULY 2010 - PRESENT
    Microsoft
  • Microsoft Certified Technology Specialist: SQL Server 2008, Business Intelligence Development and Maintenance
    JULY 2010 - PRESENT
    Microsoft
I really like this profile
Share it with others