Dmitry Yaroshenko, Data Warehousing Developer in London, United Kingdom
Dmitry Yaroshenko

Data Warehousing Developer in London, United Kingdom

Member since November 20, 2018
Dmitry helps businesses transform into data-driven organizations, 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.
Dmitry is now available for hire

Portfolio

Experience

Location

London, United Kingdom

Availability

Part-time

Preferred Environment

Azure, Google Cloud Platform (GCP), Tableau, AWS, Snowflake

The most amazing...

...program I've created was the Performing Digital Transformation program, an analytical platform for 50+ data scientists exploring 750+ terabytes of data.

Employment

  • Senior Solutions Architect

    2019 - PRESENT
    Perfsys Solutions
    • Designed and delivered the end-to-end data warehousing solutions using cloud technologies across many customers.
    • Contributed to architecture, modeling, ETL, DWH, data virtualization, and BI development.
    • Migrated projects to cloud analytics.
    • Created self-service analytics and prototyping using DBT and Tableau.
    Technologies: Redshift, BigQuery, Tableau, Azure, Google Cloud Platform (GCP), AWS, Snowflake
  • Data Analytics Consultant

    2018 - 2019
    Planorama (AI, retail)
    • Worked as an audit of the existing analytical landscape solutions.
    • Implemented the migration to modern cloud analytics/data warehousing.
    • Boosted current engineering processes for better SDLC and Agile data warehousing.
    • Implemented new business use cases with advanced analytics and data monetization.
    Technologies: Python, Pentaho, Microsoft Power BI, Tableau, Snowflake, Redshift
  • Senior Solutions Architect

    2018 - 2019
    Snowflake Computing
    • Worked with clients and companies, helping them become data-driven by providing data warehouse solutions in the cloud.
    • Involved in building solutions and its architecture, building technical strategies, and providing business/tech advisory.
    • Managed client requirements and task organization.
    • Managed and provided Snowflake Professional Services.
    • Managed a role of a technical evangelist.
    Technologies: Matillion ETL for Redshift, Tableau, Azure, Google Cloud Platform (GCP), AWS, Snowflake
  • VP of Data Analytics

    2018 - 2018
    CIB Deutsche Bank
    • Improved existing data processes by implementing an analytics platform.
    • Helped and advised senior management to make faster and better decisions.
    • Provided an accurate view of business financial activities, their limits, KPIs, and constraints.
    • Worked on implementing agile data warehouse and a self-service BI platform.
    Technologies: Pentaho, Oracle Exadata, Tableau
  • Data Warehouse Architect

    2017 - 2018
    Mukra Entertainment (Gaming)
    • Designed and implemented the data warehouse/analytical platform for self-service data discovery and analyzing web users' behavioral patterns to improve firm KPIs (traffic conversion, targeting, marketing campaigns, A/B testing etc).
    • Created a new analytical platform using Tableau with BigQuery and 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 the overall strategy and direction of treasury reporting and analytics.
    • Managed stakeholders demand. Offered solutions for supporting business roadmap by technical delivery.
    • Designed and implemented the architecture of a multi-terabyte enterprise data warehouse.
    Technologies: Impala, SAP BusinessObjects (BO), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Tableau, Oracle Exadata
  • Data Warehouse Architect

    2012 - 2014
    Comscore (Telecom)
    • Implemented a variety of analytical solutions for Telecom clients including Verizon, Sprint, and Mobinil as well as building internal analytics for comScore.
    • Addressed solutions such as significant data volume challenges (40+ Tb) and consolidating granular data from the network equipment and mobile devices in order to support the analysis.
    Technologies: Tableau, SQL Server Integration Services (SSIS), Pentaho, Oracle, Greenplum, Vertica

Experience

  • Gaming Analytics Platform (Other amazing things)

    My client was struggling to integrate siloed information flows to drive marketing and product analytics.

    I proposed the design and created from scratch the modern data analytics architecture for the company utilizing cloud services.

    This enabling their data science teams to have access to the common data lake and leverage scalability of the cloud to drive better business decisions.

    Technically:
    - Data Warehouse, evolving from Redshift to Snowflake
    - 120+ Tb of data
    - 2 Tb daily ingress
    - 40+ concurrent data scientists and BI analysts
    - tableau/looker self-service portals

  • Risk Management Analytics for Investment Banking (Development)

    Investment Banking is the industry where faster, better data-driven decisions are forming a key differentiation factor on the market.

    Overcoming various challenges (data variety, quality, availability, complexity, volume) I managed to design and build a range of analytical solutions that supported a range of optimizations in revenue-generating departments as well as risk control.

    One of the systems formed the strategic fundamental data warehouse layer that becomes a solution for stress test scenario modeling to understand the potential impact on liquidity buffers and regulatory reporting/liabilities.

    Technically: a multi-terabyte data warehouse, running the MPP platform with self-service Tableau/BOBJ portal.

  • Demand and Capacity Analytics for Telco (Development)

    Build a data warehouse that collects IoT data from the network equipment of large telecom service providers (Sprint, Mobilil, Verizon) in order to predict the demand and make corresponding actions to ensure clients will have the good service availability.

    - 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 (Other amazing things)

    A big believer and advocate of Agile data warehousing practices that could be established by a combination of Data Vault 2.0 data modeling technique and CMMI aligned SDLC processes.

    Critical to being able to execute projects on a large enterprise-scale and not get stuck with the data model inflexibility as a bottleneck

  • Training and Education Services (Development)

    Had a great experience establishing internal communities of practices for data analytics and warehousing for multiple companies.

    Delivered a large number of trainings, best practices, and subject presentation to the diverse audiences, starting from less technically savvy all the way down to architects and data engineers.

  • Digital Transformations with Modern Cloud Analytics (Other amazing things)

    Consulting with Snowflake I managed to help more than 15 FTSE100 customers to:
    - turn their data silos in data assets
    - build new, Modern Analytical Platforms leveraging best Cloud Technologies
    - enable agile data warehousing (Data Vault 2.0)
    - integrate all data. All workloads. Cost-effectively with limitless scalability (workload, volume)

  • Modernizing Data Analytics in IoT Manufacturer Company (Development)

    Creating a completely new analytical platform from scratch bringing together information from numerous customer IoT devices into valuable business insights.

    Challenging: data volumes (Tbs a day), semi-structured data sources, solid analytical requirements, low latency, high concurrency.

    Technologies: Stitch, Segment, Redshift, Snowflake, DBT, Tableau

  • Video Streaming Service, Data Analytics Platform (Development)

    Build from scratch the entire analytical stack for the large video streaming brokers, enabling internal analytics and share data insights with their customers (new product offering).

    Tech: Tableau, BigQuery, Dbt

Skills

  • Languages

    Snowflake, 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, Dimensional Modeling, Business Intelligence (BI)
  • Platforms

    Azure, Google Cloud Platform (GCP), Oracle, QlikView, Pentaho
  • Storage

    IBM DB2, Vertica, Redshift, PL/SQL, Greenplum, SQL Server Integration Services (SSIS)
  • Other

    Data Scientist, Data Warehousing, Data Vaults, Qlik, Power BI, dbt, Data Warehouse Design, Data Analytics, Azure Data Factory, TOGAF, Google BigQuery, Performance Tuning, AWS, SAP BusinessObjects (BO), ETL Tools
  • Frameworks

    The Open Group Architecture Framework (TOGAF)

Education

  • Master's degree in Computer Science
    2002 - 2007
    National University of Ukraine - Ukraine

Certifications

  • Showflake Architect
    NOVEMBER 2018 - PRESENT
    Snowflake
  • Oracle 10G OCP
    JANUARY 2008 - JANUARY 2012
    Oracle
  • TOGAF
    JANUARY 2007 - PRESENT
    opengroup.org

To view more profiles

Join Toptal
Share it with others