At Pygmalion AI, I lead all data processes and own the end-to-end analytics strategy. I design and implement analytics systems that empower the company with actionable insights for strategic decision-making.➢ Analytics System Architect: Built a comprehensive analytics infrastructure from scratch, enabling scalable insights into company performance, marketing analytics, and UTMs tracking.➢ Executive Reporting: Prepare detailed performance reports for leadership, highlighting key metrics across marketing, business growth, and operational efficiency.➢ Cross-Functional Collaboration: Partner with various teams to define data requirements, clarify business needs, and deliver data-driven recommendations.➢ Data Collection & ML Dataset Creation: Lead data parsing efforts and assemble datasets crucial for machine learning models, driving Pygmalion’s AI initiatives.➢ Advanced Tech Stack: Manage workflows and data orchestration with Apache Airflow, Dbt, Google Cloud, BigQuery, Kafka, Google Tag Manager, Stripe, Mixpanel, and GA 4. Experienced in building AI datamarts leveraging OpenAI’s API.

➢ Designed and scaled high-performance cloud data warehouses (BigQuery, S3, ClickHouse, Vertica, Greenplum) with optimized ETL/ELT pipelines using Apache Airflow, ensuring efficient data flows for client analytics.➢ Automated robust data quality checks, built transformations with dbt, and enhanced data reliability for fast, data-driven decisions.➢ Excelled in client communication, developing custom connectors and documenting processes extensively in Confluence, GitHub, and GitLab.

➢ Deploying, configuring and maintaining of infrastructure including Clickhouse, Blockchain nodes, Grafana and Airflow➢ Designing a data warehouse for various blockchains and open sources on the labelling of blockchain contracts➢ Calculation of custom analytical data marts and setting up processes for updating them in real time➢ Setting up ETL processes for loading data from blockchain nodes to a database using asynchronous and multi-threaded technologies➢ Getting data from open sources via API, ABI, REST-API, Web3 library. Connected more than 10 data sources

➢ Completed and handed over to support 13 data integrations. As a part of my integrations, about 1500 tables were created. Nowadays more than 250k of rows are loaded daily into database for my integrations ➢ Integrated data from corporate Jira API with asynchronous jobs that provides historical data of all the users. To date, this data is widely used to create timesheets for most of the users➢ Built tools to provide real-time data around customs statistics, reducing latency by 30%. ➢ Configured CI/CD in gitlab for building and deploying of my solution directly to the server➢ My biggest integration is loading data into 214 tables daily, incremental load functionality is also provided➢ Communicated with customers to understand needs, and translated their feedback into new custom data marts, saving 30 hours of manual work each month