Vladimir Jednak, Developer in Belgrade, Serbia
Vladimir is available for hire
Hire Vladimir

Vladimir Jednak

Verified Expert  in Engineering

Software Developer

Location
Belgrade, Serbia
Toptal Member Since
June 18, 2020

Vladimir在商业智能领域有超过十年的经验, databases, data warehouses, reporting solutions, development, architecture, and consultancy; including having worked on the complete lifecycle of BI/DWH solutions. Vladimir热衷于数据库优化和查询调优，并不断寻找改进流程的方法.

Data WarehousingData Warehouse DesignMCSE | Business IntelligenceData EngineeringCognos 10SQLT-SQL (Transact-SQL)SQL Server Integration Services (SSIS)ANSI SQLSQL PerformanceDatabasesSQL Stored ProceduresBusiness Intelligence (BI)SQL Server BIIBM CognosPower BIErwin DataPower QueryPL/SQLQlik

Availability

Full-time

Preferred Environment

Cognos 10、QlikView、SQL Server集成服务(SSIS)、Microsoft SQL Server

The most amazing...

...我所做的项目是在SSIS中创建的CDC(更改数据捕获)解决方案.

Work Experience

Power BI Expert

2020 - PRESENT
财富100强北美建筑设备制造商(通过Toptal)
  • 在Power BI中创建交互式仪表板和报告. Created advanced measures using DAX language.
  • Worked on data manipulation using Power Query. Created star schema as a reporting model.
  • Power BI使用的数据源:Oracle数据库，Excel文件，Google Analytics.
技术:数据建模、DAX、星型模式、功率查询M、功率查询、Microsoft Power BI

Data Warehouse Architect

2019 - PRESENT
Spartan Race Inc (via Toptal)
  • Created a DWH model using the Data Vault model.
  • 创建了一个数据集市模型，用于使用星型模式进行报告.
  • Wrote ETL/SQL scripts.
  • 为配置创建元数据表，为数据加载和计算创建映射表.
  • Developed visualizations with Looker.
Technologies: Looker, PostgreSQL

Business Intelligence Consultant

2019 - PRESENT
DataClue GmbH (Freelance)
  • Created a data mart model for financial reporting.
  • Developed ETL/SQL procedures.
  • 使用Power BI和DAX计算开发可视化.
  • Implemented time comparison calculations, and calculations for quantity, product mix, and price impact on revenue and material costs.
技术:Microsoft Power BI, Microsoft SQL Server

Business Intelligence Solution Manager

2017 - 2019
SR Technics Services
  • 使用QlikView和SAP Bex工具开发BI解决方案.
  • 遵循和增强SAP BW和QlikView加载程序.
  • 监控和维护SAP BW和QlikView流程中的数据质量.
技术:工具、SAP、SAP业务仓库(BW)、QlikView

Freelance Senior SQL Developer

2016 - 2019
Datasport, Ltd. (via An Online Freelance Agency)
  • 编写了一个比赛中运动员的SQL排名计算算法.
  • Optimized the database and query tuning.
  • Provided SQL support for live events.
Technologies: Microsoft SQL Server

Freelance Senior BI Developer

2016 - 2017
Multibase (via An Online Freelance Agency)
  • Developed and enhanced BI solutions.
  • 使用Microsoft Reporting Services和Microsoft Excel编写报告.
  • 使用数据库模型实现DWH系统.
技术:SQL Server报表服务(SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server

Senior Officer | DWH and BI Architect

2012 - 2017
Addiko Bank a.d. Beograd
  • 实现了银行数据仓库和报告系统(Temenos T24), Informatica PowerCenter ETL, and Cognos).
  • 将投资组合和其他分析报告用市场利率方法计算并存入财务控制部门.
  • 管理和架构HBSE零售风险数据基础架构, including the risk data mart and reporting.
  • 为风险部门开发COGNOS规划工具.
  • 实现了维度和数据(Erwin)建模.
  • 定义了模型(数据仓库和数据集市设计).
  • 参与ETL开发(SSIS和Informatica PowerCenter), 包括报告和ETL自动化和优化.
Technologies: IBM Db2, SQL Server Reporting Services (SSRS), IBM Cognos, Cognos 10, SQL Server Integration Services (SSIS), Microsoft SQL Server

Senior BI Developer

2012 - 2012
IT Excellence
  • 优化ETL流程(SSIS)，开发自动化SSIS软件包.
  • 开发了一个CDC(变更数据捕获)系统和代理键体系结构.
  • 改进了ETL和SQL计算的执行时间.
技术:SQL Server集成服务(SSIS)， Microsoft SQL Server

Independent Software Developer

2010 - 2012
Asseco SEE
  • 实现了一个风险管理应用程序:IK Banka Zenica, Sinergija Banja Luka.
  • 为捷克投资银行(Investiciono Komercijalna Bank Zenica)构建反洗钱模块和预提计算应用程序, Bosnia and Herzegovina.
  • 开发并实现了贝尔格莱德通用银行，Procredit银行的逾期评分类别.
  • 为国内几家银行撰写报告:Komercijalna Banka Beograd, Privredna Banka Beograd, Marfin Banka, Univerzal Banka, Agro Banka, and more.
技术:T-SQL (Transact-SQL)， Microsoft SQL Server

BI Software Developer

2008 - 2010
Asseco SEE
  • 为塞尔维亚和马其顿的几家银行开发商业智能系统.
  • 使用Microsoft Reporting Services (SSRS)和Microsoft Excel编写报告.
  • 建模、设计和实现一个自动生成报告的系统.
  • 测试报告与银行的业务部门.
  • 为银行的IT和业务部门提供支持.
技术:SQL Server集成服务(SSIS)， Microsoft SQL Server, T-SQL (Transact-SQL), SSAS, SQL Server Analysis Services (SSAS)

DWH/CDC Project

http://www.youtube.com/watch?v=ivr_u0wFMMo
在这里，我使用SSIS开发了一个CDC(变更数据捕获)系统和代理密钥体系结构.

Languages

SQL, T-SQL (Transact-SQL)，存储过程，功率查询

Tools

IBM Cognos, Microsoft Power BI, SQL Server BI, Power Query, Looker, BEx Reporting, SSAS

Paradigms

数据库设计，商业智能(BI)，数据库开发，ETL, ETL实施 & Design, OLAP

Platforms

Microsoft BI Stack, QlikView, Azure

Storage

PL/SQL, 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, Microsoft SQL Server, PostgreSQL, SQL Server Analysis Services (SSAS), IBM Db2, Azure SQL Databases, Azure SQL

Other

Cognos 10, PL/SQL Tuning, Query Optimization, Data Visualization, Data Warehousing, Data Warehouse Design, Requirements & Specifications, MCSE | Business Intelligence, ETL Development, BI Reports, Data Reporting, Reporting, Reports, Qlik, Data Engineering, Data Modeling, DAX, Star Schema, SAP Business Warehouse (BW), SAP, Tools, Azure Data Factory

2008 - 2010

信息技术(信息系统与技术)硕士学位

University of Belgrade - Belgrade, Serbia

1997 - 2008

信息技术(信息系统与技术)学士学位

University of Belgrade - Belgrade, Serbia

OCTOBER 2021 - PRESENT

Microsoft Certified: Azure Data Fundamentals

Microsoft

JULY 2020 - PRESENT

Microsoft Certified: Azure Fundamentals

Microsoft

MAY 2020 - MAY 2022

Microsoft Certified: Data Analyst Associate

Microsoft

DECEMBER 2019 - DECEMBER 2021

谷歌云认证-副云工程师

Google Cloud

NOVEMBER 2019 - PRESENT

自动化Anywhere认证高级RPA专业人员

Automation Anywhere

DECEMBER 2011 - PRESENT

微软认证IT专业人员:数据库开发人员2008

Microsoft

MARCH 2011 - PRESENT

微软认证IT专家:2008年商业智能开发人员

Microsoft

JULY 2010 - PRESENT

微软认证技术专家:SQL Server 2008，数据库开发

Microsoft

JULY 2010 - PRESENT

微软认证技术专家:SQL Server 2008, Business Intelligence Development and Maintenance

Microsoft

Collaboration That Works

How to Work with Toptal

在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.

1

Share your needs

在与Toptal领域专家的电话中讨论您的需求并细化您的范围.
2

Choose your talent

在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.
3

Start your risk-free talent trial

与你选择的人才一起工作，试用最多两周. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring