Dmitry is available for hire
Hire DmitryDmitry Yaroshenko
Verified Expert in Engineering
Data Warehousing Developer
Location
London, United Kingdom
Toptal Member Since
June 18, 2020
Dmitry帮助企业转型为数据驱动型组织, leveraging the best technology, cloud, and engineering practices. With expertise in data warehousing, analytics, and strategic consulting for the last 16 years, he has worked with major players in financial services, telco, insurance, technology, gaming, and utilities.
Portfolio
Perfsys Solutions
Amazon Web Services (AWS), Redshift, BigQuery, Tableau, Azure...
Planorama (AI, retail)
Python, Pentaho, Microsoft Power BI, Tableau, Redshift
CIB Deutsche Bank
Pentaho, Oracle Exadata, Tableau
Experience
Availability
Part-time
Preferred Environment
亚马逊网络服务(AWS)、Azure、谷歌云平台(GCP)、Tableau
The most amazing...
...我创建的项目是执行数字转换项目, 一个供50多位数据科学家探索750+ tb数据的分析平台.
Work Experience
Senior Solutions Architect
2019 - PRESENT
Perfsys Solutions
- 使用云技术设计并交付跨多个客户的端到端数据仓库解决方案.
- 参与架构、建模、ETL、DWH、数据虚拟化和BI开发.
- Migrated projects to cloud analytics.
- 使用DBT和Tableau创建自助服务分析和原型.
Technologies: Amazon Web Services (AWS), Redshift, BigQuery, Tableau, Azure, Google Cloud Platform (GCP)
Data Analytics Consultant
2018 - 2019
Planorama (AI, retail)
- 对现有的分析景观解决方案进行审计.
- 实现了向现代云分析/数据仓库的迁移.
- 为更好的SDLC和Agile数据仓库提升了当前的工程流程.
- 通过高级分析和数据货币化实现新的业务用例.
技术:Python, Pentaho, Microsoft Power BI, Tableau, Redshift
VP of Data Analytics
2018 - 2018
CIB Deutsche Bank
- 通过实现分析平台改进现有数据流程.
- 帮助和建议高级管理层做出更快更好的决策.
- 提供业务财务活动、其限制、kpi和约束的准确视图.
- 致力于实现敏捷数据仓库和自助式BI平台.
Technologies: Pentaho, Oracle Exadata, Tableau
Data Warehouse Architect
2017 - 2018
Mukra Entertainment (Gaming)
- 设计并实现了数据仓库/分析平台，用于自助数据发现和分析web用户的行为模式，以提高公司的kpi(流量转换), targeting, marketing campaigns, A/B testing etc).
- 使用Tableau、BigQuery和Hadoop创建了一个新的分析平台.
- Managed huge data volumes/throughput (4Tb/day, 120Tb+).
- Defined solution architecture and led the implementation.
- Developed data modeling, dashboard, and data visualization.
- Tested and tuned performance, capacity, and scalability.
Technologies: Python, QlikView, Tableau, BigQuery, Vertica
Head of Reporting and Analytics, Treasury
2012 - 2018
Deutsche Bank
- 管理财务报告和分析的整体战略和方向.
- Managed stakeholders demand. 通过技术交付为支持业务路线图提供解决方案.
- 设计并实现了一个多tb企业数据仓库的体系结构.
Technologies: Impala, SAP BusinessObjects (BO), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Tableau, Oracle Exadata
Data Warehouse Architect
2012 - 2014
Comscore (Telecom)
- 为包括Verizon在内的电信客户实现各种分析解决方案, Sprint, 以及为comScore建立内部分析.
- 解决了诸如重大数据量挑战(40+ Tb)和整合来自网络设备和移动设备的粒度数据等解决方案，以支持分析.
技术:Tableau, SQL Server集成服务(SSIS)， Pentaho, Oracle, Greenplum, Vertica
Experience
Risk Management Analytics for Investment Banking
Investment Banking is the industry where faster, 更好的数据驱动决策正在市场上形成一个关键的差异化因素.
Overcoming various challenges (data variety, quality, availability, complexity, 我设法设计并构建了一系列分析解决方案，以支持创收部门的一系列优化以及风险控制.
其中一个系统形成了战略基础数据仓库层，该层成为压力测试场景建模的解决方案，以了解对流动性缓冲和监管报告/负债的潜在影响.
Technically: a multi-terabyte data warehouse, 使用自助服务的Tableau/BOBJ门户运行MPP平台.
Overcoming various challenges (data variety, quality, availability, complexity, 我设法设计并构建了一系列分析解决方案，以支持创收部门的一系列优化以及风险控制.
其中一个系统形成了战略基础数据仓库层，该层成为压力测试场景建模的解决方案，以了解对流动性缓冲和监管报告/负债的潜在影响.
Technically: a multi-terabyte data warehouse, 使用自助服务的Tableau/BOBJ门户运行MPP平台.
Demand and Capacity Analytics for Telco
构建数据仓库，从大型电信服务提供商(Sprint)的网络设备中收集物联网数据, Mobilil, 以预测需求，并作出相应的行动，以确保客户将有良好的服务可用性.
- 250+ Tb of granular data
- started with 5 Tb/day of data ingestion
- cost-efficient analytics, bringing additional market data (weather, public events, campaigns) to make the insights robust
- 250+ Tb of granular data
- started with 5 Tb/day of data ingestion
- cost-efficient analytics, bringing additional market data (weather, public events, campaigns) to make the insights robust
Data Vault 2.0 Certified Practitioner
敏捷数据仓库实践的忠实信徒和倡导者，可以通过结合data Vault 2来建立.0 data modeling technique and CMMI aligned SDLC processes.
对于能够在大型企业规模上执行项目，而不会被数据模型不灵活性作为瓶颈所困扰，这是至关重要的
对于能够在大型企业规模上执行项目，而不会被数据模型不灵活性作为瓶颈所困扰，这是至关重要的
Training and Education Services
有为多个公司建立数据分析和仓库的内部实践社区的丰富经验吗.
Delivered a large number of trainings, best practices, and subject presentation to the diverse audiences, 从不太精通技术的人一直到架构师和数据工程师.
Delivered a large number of trainings, best practices, and subject presentation to the diverse audiences, 从不太精通技术的人一直到架构师和数据工程师.
Modernizing Data Analytics in IoT Manufacturer Company
从零开始创建一个全新的分析平台，将来自众多客户物联网设备的信息整合为有价值的业务见解.
Challenging: data volumes (Tbs a day), semi-structured data sources, solid analytical requirements, low latency, high concurrency.
技术:Stitch, Segment, Redshift, Snowflake, DBT, Tableau
Challenging: data volumes (Tbs a day), semi-structured data sources, solid analytical requirements, low latency, high concurrency.
技术:Stitch, Segment, Redshift, Snowflake, DBT, Tableau
Video Streaming Service, Data Analytics Platform
从头开始为大型视频流代理构建整个分析堆栈, 支持内部分析并与客户共享数据见解(新产品提供).
Tech: Tableau, BigQuery, Dbt
Tech: Tableau, BigQuery, Dbt
Skillset
Languages
SQL, Python
Tools
Tableau, Oracle Exadata, Microsoft Power BI, Matillion ETL for Redshift, Impala, BigQuery, Sisense, Oracle Business Intelligence Enterprise Edition 11g (OBIEE)
Paradigms
数据科学、ETL、维度建模、商业智能(BI)
Platforms
Azure、谷歌云平台(GCP)、甲骨文、QlikView、Pentaho、亚马逊网络服务(AWS)
Storage
IBM Db2、Vertica、Redshift、PL/SQL、Greenplum、SQL Server集成服务(SSIS)
Other
Data Warehousing, Data Vaults, Qlik, Data Build Tool (dbt), Data Warehouse Design, Data Analytics, Azure Data Factory, Google BigQuery, Performance Tuning, SAP BusinessObjects (BO), ETL Tools
Frameworks
TOGAF
Education
2002 - 2007
Master's Degree in Computer Science
National University of Ukraine - Ukraine
Certifications
JANUARY 2008 - JANUARY 2012
Oracle 10G OCP
Oracle
JANUARY 2007 - PRESENT
TOGAF
opengroup.org
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