Block or report ivanshamaev
Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.
You must be logged in to block users.
Contact GitHub support about this user’s behavior. Learn more about reporting abuse.
Report abuse
15+ years in IT · Data Engineering · DWH · AI Agent Engineering · BI · Moscow
I design and build data platforms, warehouse pipelines, and AI-powered tooling that turn raw data into trusted decisions. My path started in enterprise BI consulting — Oracle Hyperion, QlikView, financial planning systems — then evolved through modern data stacks into DWH architecture and, most recently, into production AI agents that understand warehouse metadata and generate SQL from natural language.
|
Data Engineering Batch pipelines, multi-layer DWH modeling, ETL/ELT orchestration with Airflow and dbt, query optimization, data quality, and reliable data products for finance, product, and operations. |
AI Agent Engineering RAG-based agents for DWH: metadata indexing, table relationship graphs, natural language to SQL, LLM integration with Claude and open-source models, vector DB pipelines. |
Analytics Enablement Bridging platform and business: data marts, BI tooling (Superset, DataLens, Qlik, Grafana), observability dashboards, C-level reporting, and cross-functional collaboration. |
At Ozon Tech (Nov 2024 – present) as Senior DWH Developer:
- Designing batch pipelines on Vertica and Trino; building DDS and data mart layers with attention to data quality and query performance
- Building a RAG-based AI agent for DWH — metadata-aware, capable of SQL auto-generation from natural language
- ETL monitoring dashboards in Grafana with 100% domain failure coverage
- Migrating workloads from Vertica to Trino; mentoring colleagues on AI tooling
sources → ingestion → orchestration → DWH / lakehouse → marts → BI / AI agents
| Period | Company | Role |
|---|---|---|
| Nov 2024 – present | Ozon Tech | Senior DWH Developer |
| Dec 2023 – Nov 2024 | eapteka.ru | TeamLead BI & Acting DWH TeamLead |
| Aug 2020 – Nov 2023 | TheSoul Publishing (Cyprus) | Senior BI Developer |
| May 2017 – Jul 2020 | Luding | Leading Business Analyst – QlikView |
| Nov 2014 – May 2017 | Dixy | Oracle Hyperion & QlikView Consultant |
| Sep 2013 – Nov 2014 | АльфаСтрахование | Systems Analyst – Hyperion Planning |
| Oct 2011 – Aug 2013 | Glowbyte Consulting | Financial Solutions Consultant |
Ozon Tech — Developed a RAG-based AI agent integrating DWH metadata and automatic SQL generation; built Grafana ETL monitoring with full domain coverage; optimized and migrated Vertica → Trino.
еАптека — Led BigQuery → Yandex Cloud migration, rebuilt pipelines with ClickHouse + Airflow + dbt; C-level dashboards for sales and product analytics; hired and onboarded new team members.
TheSoul Publishing — Deployed Apache Superset as a Qlik replacement (significant licence cost reduction); built plan-vs-fact automation saving 90% of reporting time; 3-layer Facebook API ETL pipeline; custom Superset plugins in React/TypeScript.
Luding — Sales funnel analysis, multi-API PHP extractors, C# Windows Service for NPrinting; awarded Best Employee Q4 2019.
Data Engineering & Orchestration
Databases & DWH
AI & LLM
BI & Visualization
Infrastructure
DWH Modeling
Data Vault 2.0 · Anchor Modeling · Kimball
|
AI Agent for DWH (RAG) Ozon Tech, 2025 RAG system integrating DWH metadata, table relationships, and automatic SQL generation from natural language. Stack: Python, LLM (Claude), VectorDB, Trino. |
ETL Monitoring Dashboard Ozon Tech, 2025 Grafana dashboards providing 100% coverage of DWH domain failure points and pipeline status across all batch workflows. |
|
BigQuery → Yandex Cloud Migration еАптека, 2024 End-to-end cloud migration with pipeline rebuild on ClickHouse + Airflow + dbt. Included team training and DataLens performance fixes. |
Plan-vs-Fact Automation TheSoul Publishing, 2021 Reporting automation that reduced preparation time by 90%. Integrated with multiple data sources. |
|
Apache Superset Implementation TheSoul Publishing, 2021 Selected and deployed Superset as a Qlik replacement. Built custom React/TypeScript plugins, GitLab CI/CD automation, and team onboarding. |
Facebook API ETL Pipeline TheSoul Publishing, 2020 3-layer DataLake architecture (raw → staging → marts) with daily updates for social media analytics. |
Bauman Moscow State Technical University (2006–2012)
Engineer — Automation of Technological Processes and Production
2025 (in progress)
- ClickHouse for Analysts — Stepik
- Python Generation: OOP — Stepik
2024
- Apache Airflow for Analysts — Stepik
- dbt Fundamentals — getdbt.com
- A/B Testing — Stepik
- Statistics Fundamentals — Stepik
- PySpark — Stepik
- Python for Professionals — Stepik
- Data Engineer Professional Course — Stepik
2023
- SQL for Data Analysis — Stepik
- SQL Window Functions — Stepik
- Python Programming & Advanced Python — Stepik
- Data Science — Stepik
2018
- qRUG Conference Speaker on Qlik — ATK Consulting
- Personal blog with practical articles on data engineering, DWH, and analytics: ivan-shamaev.ru
- Co-author at datatalks.ru — data engineering and analytics community
- Telegram channel @data_engineer_path — DWH, SQL, Airflow, open-source tooling, notes from production
- Speaker at qRUG 2018 conference on Qlik
Pinned Loading
If the problem persists, check the GitHub status page or contact support.