Ivan Shamaev

Full Stack Data Developer

This website is my CV in English. Below you can read about my professional background, in the blog section you will find my articles in Russian.

Core competencies

Open Source BI​

Apache Superset: Administration, custom plugin development, preparing data marts in ClickHouse or PostgreSQL, dashboard development

Yandex DataLens (SaaS)

Experienced with full development cycle of a BI (building of dashboards, datamarts for DataLens)

ETL​, Data Pipelines

Integration with various data sources (DB, APIs, Google Spreadsheets, etc.). Setting up data pipelines, data management, ETL monitoring

Qlik Sense​

Full development cycle on the platform. Development of data models, visualization, integration with various data sources (from databases to API).

Programming

The main Python libraries I use in my work are: requests, pandas, json, sys, qvd, flask

Data Storage​

ClikHouse: Creating tables, loading with data, writing queries

Orchestration Tool

ETL orchestration via Apache Airflow, setting up DAG

Notifications​

Sending notifications to Telegram, Slack, Yandex Messenger using Qlik Sense, Python, AirFlow

PROFESSIONAL SUMMARY

☑ 12+ years experience in IT, business analysis and working with websites

☑ 8 years working with business intelligence and reporting systems

☑ Significant experience with advanced financial systems and financial reporting

☑ 2+ year experience with docker and open source systems

EDUCATION

Bauman Moscow State Technical University
2006 — 2012
Engineer
Faculty of robotics and integrated automation: Automation of technological processes and productions

MY EXPERIENCE (11+ YEARS)

Technical Skills

Qlik Sense
Qlik Scripting (Data processing)
Data visualization
Apache Superset
Yandex DataLens
SQL, Experience with API
Python
Html/CSS/Javascript
dbt
Docker
Linux Ubuntu

Soft Skills

Attention to detail
Critical thinking
Problem-solving skills
Communication skills

Business Analysis Skills

Diagramming (miro, draw.io)
Work with requirements
Writing documentation

Languages

Russian: Native
English: Working Professional (B1)
On the way to B2

2023 - current time

Eapteka

TeamLead BI (Yandex DataLens)

☑ Yandex DataLens
☑ Python: Pandas, Parquet, S3
☑ SQL, ClickHouse, GreenPlum, MS SQL
☑ dbt, dbt-clickhouse
☑ AirFlow
☑ Yandex Cloud
☑ DataHub

2020 - 2023

TheSoul Publishing (adme.ru, etc.)

Senior BI Developer

☑ Qlik Sense:
 ▸ ETL, Apps, Data Processing, GIT & .qvs
 ▸ Creating simple extensions
 ▸ Work with users and their requirements
 ▸ Support SSE Plugins
☑ Apache Superset:
 ▸ Choosing an additional BI tool from open-source
 ▸ Custom plugin development
 ▸ Building image with a custom plugin
 ▸ A full range of work on the development of visualization in the Superset
 ▸ Migration from 1.3.2 to 2.0.1
☑ Clickhouse
☑ OpenMetadata - select system from several options, installation and insert test data
☑ Docker, Dockerfile, Linux (Ubuntu), nginx
☑ GitLab: working with gitlab-ci.yml on 2 projects

🔎 ADDITIONALLY
☑ Subject domain: Social Media, Finance

2017-2020​

Luding LLC

Senior BI Developer

☑ Developing new analytical applications and supporting existing Apps QlikView
☑ NPrinting - creating and sending regular reports from QlikView
☑ C# - Developed Windows Server Services and custom utilities for working with the QlikView Server API and NPrinting API
☑ PHP - Developed an Data Extractor for Bitrix24 CRM, Yandex Metrika, Google Analytics and Mango Office APIs
☑ 1C ERP: developed an epf procedure for generating a sql query from DB for qlik
☑ GIT - Designed the .qvs Architecture and Configured the Workflow
☑ Qlik Corporate Training - recorded videos for internal training of company employees
☑ Mediawiki - Deployed and Configured the Knowledge Base for the reporting Department
☑ Migration project: QV11 -> QV12, NP16 ->NP2020
☑ PowerShell - development of scripts for automating various actions on windows (archiving, copying)

🔎 ADDITIONALLY
☑ Subject domain: Web Analytics, Sales, Logistics, Finance, Marketing Event Analysis

2014-2017

Dixy (Retail Group)

IT CONSULTANT (ORACLE HYPERION, QLIKVIEW)

☑ Project to implement a budgeting system based on Hyperion Planning
☑ Project to deploy a EPM solution QlikView (Analytical module for the ERP system GOLD)
☑ Optimization of integration solutions, post-project support and system development (budget, cost allocations)

🔎 ADDITIONALLY
☑ Subject domain: Budgeting, allocation of expenses

2013-2014

AlfaStrakhovanie Group

SYSTEMS ANALYST (HYPERION PLANNING, QLIKVIEW)

☑ Support and improvement of Oracle Hyperion Planning functionality
☑ Oracle HP Administration
☑ Development of Analytical Data Models, Data extracting, transformation scripts and model calculation scripts in QlikView

🔎 ADDITIONALLY
☑ Subject domain: Budgeting, allocation of expenses

2011-2013

Glowbyte Consulting

IT CONSULTANT (SAS, FINANCIAL SOLUTIONS)

☑ SAS Base, SAS FM, SAS ABM
☑ Consulting external customers, updating systems, participating in presales, collecting and processing primary requirements from customers
☑ Research of new systems, elaboration presentations of solutions for pre-sales: Oracle epm (Hyperion Planning & PCM), SAP BO Profitability and Cost Management (SAP PCM)

🔎 ADDITIONALLY
☑ Subject domain: Budgeting, allocation of expenses

Hello, I’m

Briefly about my path in IT

I participated in various projects that were somehow related to the analysis of different types of data.
I started working with financial analytical systems based on OLAP systems (SAS FM, Oracle Hyperion, SAP BO and SAS ABM).
Then I switched to QlikView and then switched to Qlik Sense. On each project, in addition to the main product I worked with, there were additional technologies that I had to use in my job: from VBA to Python, C# and JS. I always tried to find the most suitable tool for each specific task.

Recently, more and more often I pay attention to the open-source tools. For example, Apache Superset and Apache Airflow - good examples of open-source tools for work with data.

MY HOBBIES

I play the guitar.

Since 2012 I have created several of my blogs (and continue to develop some of them).

I spend most of my free time with children (walking, developing activities, etc.)

ADDITIONAL EDUCATION

PLAN FOR THE DEVELOPMENT OF MY COMPETENCIES