>_ Konstantin Sh.

Portfolio // Delivery & Analysis

Curated Projects

Selected initiatives showing hands-on data engineering, pipeline building, database performance tuning, and Looker BI delivery.

2025-Present · Retail & Production Senior Data & AI Agent Engineer

Mid-Sized Production, Retail & Wholesale Enterprise

Spearheaded the greenfield modernization of the enterprise data and analytics architecture, transforming legacy data pipelines into a scalable, cloud-native ML and AI platform.

  • Architected and executed a greenfield migration to GCP (BigQuery), consolidating multi-channel retail and wholesale data into an automated, single source of truth DWH.
  • Developed predictive ML models on structured business data and built full-lifecycle MLOps wrappers (automated training pipelines, validation, and monitoring).
  • Designed and deployed autonomous AI agents to automate complex operational and business processes across retail units, significantly reducing manual effort.
  • Implemented workflow orchestration, agent frameworks (Pydantic AI / ADK), Python pipelines, Kestra, and automated CI/CD.
GCP / BigQuery Python & SQL MLOps AI Agents Pydantic AI / ADK Kestra CI/CD
2025 · Loyalty Migration Lead Data Engineer

Siebel → Mindbox loyalty platform, online + retail

Designed the target loyalty model and integration flows while migrating from legacy Siebel CRM to Mindbox across e-commerce and 200+ stores.

  • Mapped Siebel bonus accounts, tiers, coupons to Mindbox entities; defined id mappings and migration statuses.
  • Documented Hybris ↔ Mindbox order flows: auth, final write-off, cancellations/returns, and edge cases.
  • Specified APIs/payloads across Hybris, Mindbox, Siebel, DWH, middleware; outlined error scenarios.
  • Owned functional/integration specs for checkout with bonuses, balance inquiries, coupon redemption.
  • Worked with dev/QA on test scenarios (integration/regression) and data consistency checks.
  • Investigated defects (wrong balances, duplicate ops), ran RCA, and proposed fixes.
SAP Hybris Mindbox Siebel CRM API Design Data Migration
2023-2025 · Travel Senior Software Engineer / Data Engineer

Enterprise travel booking platform (on-prem & cloud)

Built core services and data pipelines for a B2B/B2E booking platform aggregating GDS/NDC, rail, and hotel providers with full order lifecycle and BI.

  • Built order, profile, and admin services; implemented validation, caching, and lifecycle rules.
  • Implemented provider adapters (GDS/NDC, rail, hotels, finance) with mappings, retries, and error handling.
  • Delivered sync/async workflows with idempotency, compensation logic, and message-driven flows.
  • Built BI data layer: ops schema → MariaDB/Snowflake, ETL jobs, KPIs, data contracts.
  • Optimized performance and reliability; debugged production incidents and data inconsistencies.
  • Automated CI/CD and observability with DevOps: env parity, logging, and monitoring.
API Design System Design Snowflake MariaDB NDC/GDS
2020-2023 · Aviation Lead Data Engineer / BI Developer

Aviation BI & finance aggregation for airlines

Built data products on top of CRS/PSS/DCS/RMS feeds: embedded BI for airline clients and internal finance aggregation.

  • Modelled end-to-end data flows from core aviation systems into DWH and marts.
  • Produced functional specs, interface contracts (APIs, batch, files), UML diagrams.
  • Defined KPIs and calculation logic for airline reporting and client dashboards.
  • Developed robust data pipelines and Looker data models for BI and finance platforms.
  • Investigated production incidents and data inconsistencies; fixed mappings/ETL.
  • Supported UAT: test scenarios, edge cases, rollout with airline users.
Data Modeling BI ETL UML KPIs
2018-2021 · B2E Comms Lead Systems Analyst

Scalable B2E communications platform

Built a federated communications solution for enterprise users, connecting multiple modules on a shared data backbone across regions.

  • Analyzed competitors and facilitated stakeholder workshops to shape scope and priorities.
  • Captured and documented system requirements, data models, and expected system behaviors.
  • Designed integration patterns and data flows for shared datasets at federal / cross-border scale.
  • Collaborated with UX to ensure usable interaction patterns and handover-ready specs.
  • Worked with QA on edge cases, clarifications, and coverage of complex scenarios.
  • Maintained system documentation to align product, engineering, and testing teams.
Systems Analysis Integrations ClickHouse PostgreSQL SQL ETL UML MongoDB
2018-2020 · Agriscience Data Engineer

Global R&D data platform for crop protection

Aggregated IoT, lab, and field data into cloud DWH, enabling research analytics and regulatory retention.

  • Ingested telemetry and lab data across regions with data quality checks.
  • Designed research data models, harmonization rules, lineage and metadata.
  • Implemented WORM-style archive with access controls for audits.
  • Partnered with analysts to deliver curated datasets for analytics/ML.
  • Built batch/near-real-time ETL/ELT pipelines with monitoring.
GCP/BigQuery ETL/ELT Data Modeling IoT Data Compliance
2015-2018 · Retail Senior Systems Analyst

Retail data platform & POS harmonization

Delivered operational and analytical data layers for a top-3 electronics retailer with 600+ stores and SAP landscape.

  • Requirements across pricing, inventory, orders, logistics; aligned retail MDM.
  • Designed ETL/ELT jobs (batch/near-real-time) with DQ rules and monitoring.
  • Integrated SAP ERP/BW/CRM and POS feeds; documented mappings and lineage.
  • Enabled analytics/BI for logistics, inventory, and e-commerce stakeholders.
  • Established canonical retail entities and data contracts.
SAP ETL Data Engineering Retail MDM
2012-2015 · Full Stack Engineer

Custom ERP & web apps for e-commerce/private estates

Built full-stack products on LAMP/Symfony/Laravel; led distributed outsourcing team; delivered a custom ERP from scratch.

  • End-to-end architecture, responsive UI, and secure backend services.
  • Consulted clients, translated requirements into specs and system designs.
  • Mentored devs across time zones; ensured on-time delivery and code quality.
  • Implemented ERP modules for operations and data management.
Symfony Laravel MySQL JavaScript Team Leadership