Dmytro Manannykov

About Dmytro Manannykov

Highly-skilled IT professional with 25 years of IT experience including 17 years of Data Warehouse and Data Pipelines development. Excellent team player with the ability to work independently, without supervision. Also have strong communication and management skills.Work in the field of Big Data and Data Warehousing. Involved in all phases of the project – gathering requirements, performing analysis, communication and coordination, task distribution, development, testing, deployment, maintenance and support. Fast learner with a strong desire to explore new technologies and put them in use.Specializations: • ETL/DWH development - AWS (Glue/EMR/Lambda/Athena), Informatica (Power Center 9.x/Cloud), ChatGPT(OpenAI 3.5/4), Cursor 2.6, DataHub; • Databases - Snowflake, Amazon Redshift, DynamoDB, PostgreSQL, Oracle 11g/12c/ExaData; • Workload automation - AWS (Data Pipeline/CloudWatch/Step Functions), Airflow/Astronomer; • Programming Languages - Python, SQL, SparkSQL, • Scripting - Unix /Linux Shell; • Data modeling - MySQL Workbench 6.3, ERwin 7, Visio 2007, Power Designer 12; • API formats - JSON, YAML, XML; • Version control - GitHub.

Experience

1. Senior Data Engineer

   Chime

   Apr 2020 — Present · San Francisco, CA, US

   Collaborate with partner teams (Analytics, Risk, Data Scientists, Finance, etc.) to optimize current data pipelines and dashboards;• Improve current data warehouse in the following areas: logging and alerting, rerun strategy, job dependencies, data quality and availability;• Design and develop a new Data Warehouse from scratch: perform data source analysis, data profiling and data modeling, create naming convention and EDW standards, perform data migration, build staging and EDW core (Snowflake, AWS Glue, Python, Unix Shell);• Build data quality check framework (Unix Shell & Python);• Create data validation standards; • Improve performance and lower cost of data pipelines;• Perform different types of migrations, i.e. the migration of legacy data pipelines from Snowflake to AWS Glue/SparkSQL, etc;• Create data domain concepts and design EDW data domains according to partner teams\' needs;• Explore and integrate ChatGPT functionality into EDW data pipelines using OpenAI (GPT-3.5/GPT-4 LLM);• Write Project Architecture Documents (PAD) and Technical Design Documents (TDD).

Education

• Odessa Polytechnic National University

  Master's degree in Computer Systems and Networks, Computer Systems and Networks

  1995 — 2000

Skills

• Java
• Sql Tuning
• Python
• Oracle Sql
• Relational Databases
• Business Intelligence
• Extract, Transform, Load (Etl)
• Amazon Web Services (Aws)
• Databases
• Datastage
• Olap
• Sybase
• Performance Tuning
• Jira
• T-Sql
• C#
• .net
• Java Enterprise Edition
• Etl
• Tortoise Svn
• Pl/Sql
• Db2
• Xml
• Database Design
• Data Warehouse Architecture
• Microstrategy
• Erwin
• Hadoop
• Web Services
• Microsoft Sql Server
• Data Warehousing
• Mysql
• Sql
• Visio
• Asp.net
• Shell Scripting
• Visual Studio
• Architecture
• Unix
• Data Modeling