Dmitry Kozlov, Big Data Architect and Developer in Toronto, ON, Canada
Dmitry Kozlov

Big Data Architect and Developer in Toronto, ON, Canada

Member since February 5, 2021
Dmitry is a senior big data architect with 16+ years of experience in data warehousing, BI, ETL, analytics, and the cloud. He's led teams in the delivery of 24 projects in the industries of finance, insurance, telecommunications, government, education, mining, manufacturing, and retail. Dmitry thrives in high-paced environments, has demonstrated the ability to lead effectively, manage, and support teams, and has consulted on several projects as a BI, data warehouse, and big data expert.
Dmitry is now available for hire

Portfolio

  • Daisy Intelligence
    SQL, Apache Hive, Hadoop, erwin Data Modeler, IBM Db2, ETL, Big Data...
  • Bayer Canada
    Tableau, Oracle, PL/SQL, Microsoft SQL Server, ETL...
  • TD Bank Group
    Oracle 12c, PL/SQL, Erwin, Business Analysis, Solution Design, Data Architecture

Experience

Location

Toronto, ON, Canada

Availability

Part-time

Preferred Environment

SQL, ETL, Data Architecture, Big Data, Business Intelligence (BI), Data Warehousing, Data Warehouse Design, Hadoop, Tableau, erwin Data Modeler, Team Leadership

The most amazing...

...and challenging project was building an ETL framework for a small startup that was crucial to the company's growth.

Employment

  • Data and ETL Architect

    2016 - 2021
    Daisy Intelligence
    • Developed a fully functioned ETL framework that was used by ten developers.
    • Designed the corporate data architecture for companies in the retail and insurance domains.
    • Led a team in the onboarding of 17 retail and five insurance data warehouses for clients.
    • Designed a set of Tableau dashboards to monitor the ETL framework.
    • Extensively developed an ETL package and implemented performance tuning.
    • Led the prototype development for the migration of an on-premise solution to Google Cloud.
    Technologies: SQL, Apache Hive, Hadoop, erwin Data Modeler, IBM Db2, ETL, Big Data, Data Warehousing, Data Warehouse Design, Tableau, PL/SQL, SQL Stored Procedures, Data Architecture, Databases, PostgreSQL, Google Cloud
  • BI and Data Architect

    2014 - 2016
    Bayer Canada
    • Designed numerous data marts for Tableau dashboards for executives, account managers, and sales reps.
    • Led a team of onshore and offshore ETL and BI developers.
    • Addressed database and dashboard performance issues.
    Technologies: Tableau, Oracle, PL/SQL, Microsoft SQL Server, ETL, Business Intelligence (BI), PostgreSQL, Databases
  • Senior FATCA Data Architect

    2014 - 2016
    TD Bank Group
    • Designed, from end to end, a solution for different source systems.
    • Implemented comprehensive data modeling for a data warehouse and data marts.
    • Served as the go-to performance tuning guy and optimized complex queries and stored procedures.
    • Reviewed the data architecture, architectural blueprint, and business requirement documents.
    Technologies: Oracle 12c, PL/SQL, Erwin, Business Analysis, Solution Design, Data Architecture
  • BI Architect

    2014 - 2015
    Innovapost
    • Created BI semantic layer, metadata, and report definitions for RDP and BOBJ Universes.
    • Implemented extensive performance tuning of Oracle data mart queries.
    • Transformed a local MS Access solution for unaddressed emails to enterprise architecture based on Oracle and the Business Objects Server.
    Technologies: Business Intelligence (BI), SAP BusinessObjects (BO), Tableau, SQL, erwin Data Modeler, Oracle, Data Marts
  • Senior Data Architect

    2012 - 2014
    Intact Financial
    • Designed all layers in an enterprise data warehouse (EDW) to acquire a data feed from Guidewire ClaimCenter.
    • Designed all layers in the enterprise data warehouse (EDW) to acquire a data feed from Detica NetReveal.
    • Participated in a data warehouse enhancement initiative that replaced multiple data hubs with a data vault.
    Technologies: Oracle, SQL, Oracle PL/SQL, Erwin, Data Architecture, Data Vaults, Power Designer, Informatica ETL, ETL, Business Analysis
  • Senior Data Warehouse and BI Solution Designer

    2011 - 2013
    Rogers Communications
    • Took the business/data requirements from the business/data analysts and translated these requirements into information delivery logical designs and technical specifications needed by the BI designers/developers.
    • Led the strategy, design, and implementation of solutions in the area of business intelligence and data warehousing.
    • Designed project-based data Models and added them to BI tools.
    Technologies: Oracle, Teradata, Oracle PL/SQL, MicroStrategy, erwin Data Modeler, SQL Stored Procedures
  • Senior ETL Develper

    2008 - 2010
    Bristol West
    • Performed a comprehensive data warehouse assessment.
    • Designed logical and physical data models for enterprise data warehouses (EDW) and numerous data marts.
    • Developed complex mappings and performed extensive SQL tuning and optimization on queries and PL/SQL stored procedures.
    • Led and mentored a team; created and utilized best practices documents to elicit the best team performance.
    Technologies: Oracle, Data Architecture, SQL, Oracle PL/SQL, Oracle Warehouse Builder (OWB), Oracle Data Integrator (ODI), erwin Data Modeler
  • Senior Data Warehouse Architect

    2008 - 2008
    Vale Canada
    • Reviewed existing documentation about Vale Canada data warehouse process, development methodologies, data models, ETL, and so on.
    • Conducted interviews with the Value Canada technical staff to understand current data warehouse capabilities and to collect future methodology and architecture requirements.
    • Participated in workshops to gather information about current data warehouse capabilities, future methodology, and architecture requirements and to validate project findings and recommendations.
    • Assisted the project manager by making recommendations for methodology, architecture, and other improvements required to close internal audit recommendations.
    Technologies: erwin Data Modeler, Microsoft SQL Server, Microsoft Visio, Data Warehouse Design, Data Warehousing
  • Senior ETL Develper

    2006 - 2008
    Colleges
    • Led a team of ETL developers in the development of an increment 1 data warehouse. Scheduled, assigned, managed and tracked work. Coordinated resources and task dependencies. Set the technical direction for team members.
    • Managed the development, quality assurance, deployment, initial and daily load processes.
    • Developed complex mappings and performed extensive SQL tuning and optimization on queries and PL/SQL stored procedures.
    • Performed business analysis, designed data warehouse, and created mapping specifications.
    Technologies: Data Warehouse Design, Data Warehousing, ETL, Oracle PL/SQL, Oracle Warehouse Builder (OWB), Oracle Designer, Data Architecture, SQL Stored Procedures
  • Senior Business Analyst

    2006 - 2006
    Brit
    • Designed an overall solution requirements for Claims and Aggregate Exposures subject areas as part of overall BI project.
    • Gathered requirements through documentation and customer interviews and analyzed source system data.
    • Performed a logical and physical design for the data model for the data warehouse and the data marts.
    • Created numerous mapping specifications for ETL processes and composed report specifications.
    Technologies: Business Analysis, SQL, erwin Data Modeler, Data Architecture, ETL Specifications
  • Senior ETL Developer

    2005 - 2006
    TELUS
    • Led a team of ETL developers in a project-based camp. Scheduled, assigned, managed, and tracked work. Coordinated resources and task dependencies. Set the technical direction for team members.
    • Collaborated with a BI team and an architect to develop high-level process designs and entity models; also provided training for the support team.
    • Designed the ETL solution architecture and data architecture.
    • Developed complex mappings and performed extensive SQL tuning and optimization on queries and PL/SQL stored procedures.
    Technologies: SQL, Oracle PL/SQL, erwin Data Modeler, Data Architecture, ETL, Unix Shell Scripting, Oracle Warehouse Builder (OWB)
  • Senior ETL Developer

    2005 - 2005
    CIBC
    • Developed and documented numerous ETL (extract, transform, load) PL/SQL packages for different data feeds for the Basel II project, a wholesale credit data warehouse.
    • Performed extensive SQL tuning and optimization on queries and PL/SQL stored procedures.
    • Effectively collaborated with other team members responsible for other subject areas.
    Technologies: SQL, Oracle, Oracle PL/SQL, Stored Procedures, ETL, Data Warehouse Design, Data Warehousing
  • Senior ETL Developer

    2004 - 2004
    Dynamic Funds
    • Developed ETL (extract, transform, load) routines for several data marts.
    • Consulted with a team of developers regarding the development of supporting Oracle tables, indexes, views, triggers, packages, procedures, in-line functions, and SQL queries.
    • Performed extensive SQL tuning and optimization on views, queries, and PL/SQL stored procedures.
    Technologies: SQL, Oracle PL/SQL, Oracle, ETL, SQL Stored Procedures, Unix Shell Scripting, Data Warehouse Design, Data Warehousing
  • Senior Data Application Developer

    2000 - 2004
    PdMAIN
    • Led and trained a team of developers, solution analysts, and support specialists for the new edition of the sequencing process for numerous implementations on different sites of TDS Automotive.
    • Created numerous PL/SQL stored program units (packages, procedures, functions, and triggers) as well as Oracle Forms and Oracle Reports for different modules of the PdMAIN’s ERP system.
    • Developed the complete OLTP data architecture's logical and physical design.
    Technologies: SQL, ERP, Oracle PL/SQL, Oracle, Stored Procedures, erwin Data Modeler, Data Architecture, Oracle Forms & Reports

Experience

  • ETL Framework

    One of my most challenging but successful projects was with a small startup with ambitious goals but not the ETL tool budget.

    Their prototype solution stored procedures on IBM Db2. Their data intake was about to grow exponentially. Therefore, they had decided to migrate to a Hive/Hadoop cluster. To satisfy their evolving needs and to utilize their development team skillset, I designed and developed an end-to-end ETL framework that ran stored procedure-like ETL processes in a Hive/Hadoop environment, kept all metadata on a Db2 server, and had Tableau dashboards for operational support.

    This framework was able to serve a team of up to ten developers and three support operators. We used it for ETL development for 17 retail and five insurance data warehouses. Later on, we migrated it to a GCP cloud.

    The ETL framework was crucial to company growth. It allowed the company to expand development and support operations for at least five years.

Skills

  • Languages

    SQL
  • Frameworks

    Hadoop
  • Tools

    Erwin, Oracle Warehouse Builder (OWB), Tableau, Informatica ETL, Microsoft Visio, Oracle Designer
  • Paradigms

    ETL, Business Intelligence (BI)
  • Platforms

    Oracle, Oracle Data Integrator (ODI)
  • Storage

    PL/SQL, Apache Hive, IBM Db2, SQL Stored Procedures, Oracle 12c, Oracle PL/SQL, PostgreSQL, Databases, Microsoft SQL Server, Teradata, Google Cloud
  • Other

    Data Architecture, Big Data, Data Warehousing, erwin Data Modeler, Team Leadership, Business Analysis, Solution Design, Data Marts, ETL Specifications, Stored Procedures, Data Warehouse Design, Mathematics, Computer Science, SAP BusinessObjects (BO), Data Vaults, Power Designer, Unix Shell Scripting, ERP, Oracle Forms & Reports, MicroStrategy

Education

  • Master's Degree in Mathematics and Computer Science
    1990 - 1996
    Dnipro National University - Dnipro, Ukraine

Certifications

  • Oracle Certified Professional
    JULY 2005 - PRESENT
    Oracle

To view more profiles

Join Toptal
Share it with others