Vladimir Jednak
Verified Expert in Engineering
Software Developer
Vladimir在商业智能领域有超过十年的经验, databases, data warehouses, reporting solutions, development, architecture, and consultancy; including having worked on the complete lifecycle of BI/DWH solutions. Vladimir热衷于数据库优化和查询调优,并不断寻找改进流程的方法.
Portfolio
Experience
Availability
Preferred Environment
Cognos 10、QlikView、SQL Server集成服务(SSIS)、Microsoft SQL Server
The most amazing...
...我所做的项目是在SSIS中创建的CDC(更改数据捕获)解决方案.
Work Experience
Power BI Expert
财富100强北美建筑设备制造商(通过Toptal)
- 在Power BI中创建交互式仪表板和报告. Created advanced measures using DAX language.
- 使用Power Query进行数据操作. Created star schema as a reporting model.
- Power BI使用的数据源:Oracle数据库,Excel文件,谷歌Analytics.
Data Warehouse Architect
Spartan Race Inc (via Toptal)
- 使用Data Vault模型创建DWH模型.
- 创建了一个数据集市模型,用于使用星型模式进行报告.
- Wrote ETL/SQL scripts.
- 为配置创建元数据表,为数据加载和计算创建映射表.
- Developed visualizations with Looker.
Business Intelligence Consultant
DataClue GmbH (Freelance)
- 为财务报告创建了数据集市模型.
- Developed ETL/SQL procedures.
- 使用Power BI和DAX计算开发可视化.
- Implemented time comparison calculations, and calculations for quantity, product mix, 以及价格对收入和材料成本的影响.
Business Intelligence Solution Manager
SR Technics Services
- 使用QlikView和SAP Bex工具开发BI解决方案.
- 遵循和增强SAP BW和QlikView加载程序.
- 监控和维护SAP BW和QlikView流程中的数据质量.
Freelance Senior SQL Developer
Datasport, Ltd. (via An Online Freelance Agency)
- 编写了一个比赛中运动员的SQL排名计算算法.
- Optimized the database and query tuning.
- Provided SQL support for live events.
Freelance Senior BI Developer
Multibase (via An Online Freelance Agency)
- Developed and enhanced BI solutions.
- 使用Microsoft Reporting Services和Microsoft Excel编写报告.
- 使用数据库模型实现DWH系统.
Senior Officer | DWH and BI Architect
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自动化和优化.
Senior BI Developer
IT Excellence
- 优化ETL流程(SSIS),开发自动化SSIS软件包.
- 开发了一个CDC(变更数据捕获)系统和代理键体系结构.
- 改进了ETL和SQL计算的执行时间.
Independent Software Developer
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.
BI Software Developer
Asseco SEE
- 为塞尔维亚和马其顿的几家银行开发商业智能系统.
- 使用Microsoft Reporting Services (SSRS)和Microsoft Excel编写报告.
- 建模、设计和实现一个自动生成报告的系统.
- 测试报告与银行的业务部门.
- 为银行的IT和业务部门提供支持.
Experience
Skills
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
Education
信息技术(信息系统与技术)硕士学位
University of Belgrade - Belgrade, Serbia
信息技术(信息系统与技术)学士学位
University of Belgrade - Belgrade, Serbia
Certifications
微软认证:Azure数据基础
Microsoft
Microsoft Certified: Azure Fundamentals
Microsoft
Microsoft Certified: Data Analyst Associate
Microsoft
谷歌云认证-副云工程师
Google Cloud
自动化Anywhere认证高级RPA专业人员
Automation Anywhere
微软认证IT专业人员:数据库开发人员2008
Microsoft
微软认证IT专家:2008年商业智能开发人员
Microsoft
微软认证技术专家:SQL Server 2008,数据库开发
Microsoft
微软认证技术专家:SQL Server 2008, 商业智能开发和维护
Microsoft