Professional CV
Ivan Shamaev
Senior Data Solutions Architect
BI Developer
- qlik@ivan-shamaev.ru


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

ETL
Integration with various data sources, setting up data pipelines, data management, ETL monitoring

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

Open Source BI
Administration, plugin development, data load, dashboard development

Notifications
Sending notifications from Qlik Sense Script to Slack channels

Data Storage
Creating tables, loading with data, writing queries

Orchestration
ETL orchestration via Apache Airflow, setting up DAG

Web analysis
Several small mini projects for website analytics
Hello everyone!
Some word about me.
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.
BI Systems
todo
Business analysis
todo
Docker, Web Development
todo
My Experience (10+ years)
2020 - current time
Media company
Senior BI Developer (Qlik Sense, Superset, ClickHouse)
☑ Qlik Sense
☑ Apache Superset
☑ Clickhouse
☑ Docker
2017-2020
Luding LLC
Senior BI Developer (QlikView, NPrinting, Python)
☑ 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
My websites: ivan-shamaev.ru, qliksense.ivan-shamaev.ru, analytics.infozone.pro, python.ivan-shamaev.ru, powerbiblog.ru
My telegram channels: @qlik_insight, @python_powerbi