Business 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: QlikView, SAP BW, SAP Bex ToolsFreelance 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: 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: SQL Server, SSIS, SSRSSenior 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: SQL Server, SSIS, Cognos, SSRS, DB2Senior BI Developer
2012 - 2012IT Excellence- Optimized ETL process (SSIS).
- Developed a CDC (change data capture) system and surrogate key architecture.
Technologies: SQL Server, SSISIndependent 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: SQL Server, T-SQLBI 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, SSIS
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 is passionate about database optimization and query tuning and is constantly searching for ways to improve processes.
Vladimir is now available for hire
Portfolio
- SR Technics ServicesQlikView, SAP BW, SAP Bex Tools
- Datasport, Ltd. (via An Online Freelance Agency)SQL Server
- Multibase (via An Online Freelance Agency)SQL Server, SSIS, SSRS
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
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
Experience
- DWH/CDC Project (Development)https://www.youtube.com/watch?v=ivr_u0wFMMo
Here, I developed a CDC (change data capture) system and surrogate key architecture using SSIS.
Skills
Languages
SQL, T-SQL, Stored Procedure, Transact-SQLTools
IBM Cognos, SQL Server BI, Microsoft Power BI, BEx ReportingParadigms
Database Design, Business Intelligence (BI), Database Development, ETL, ETL Implementation & Design, OLAPPlatforms
Microsoft BI Stack, QlikViewStorage
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 DB2Other
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, Qlik, SAP BW, SAP Business Warehouse (BW), SAP Business Intelligence (BI)
Education
- Master's degree in IT (Information Systems and Technology)2008 - 2010University of Belgrade - Belgrade, Serbia
- Bachelor's degree in IT ( Information Systems and Technology)1997 - 2008University of Belgrade - Belgrade, Serbia
Certifications
- Google Cloud Certified — Associate Cloud EngineerDECEMBER 2019 - DECEMBER 2021Google Cloud
- Automation Anywhere Certified Advanced RPA ProfessionalNOVEMBER 2019 - PRESENTAutomation Anywhere
- Microsoft Certified IT Professional: Database Developer 2008DECEMBER 2011 - PRESENTMicrosoft
- Microsoft Certified IT Professional: Business Intelligence Developer 2008MARCH 2011 - PRESENTMicrosoft
- Microsoft Certified Technology Specialist: SQL Server 2008, Database DevelopmentJULY 2010 - PRESENTMicrosoft
- Microsoft Certified Technology Specialist: SQL Server 2008, Business Intelligence Development and MaintenanceJULY 2010 - PRESENTMicrosoft
