Ivan Shamaev Email & Phone Number

Moscow, Moscow City, Russia

Москва, Россия

☑ Automated the update of data marts from MS SQL to ClickHouse (Airflow, Python, S3, Parquet). Two data update scenarios - full and incremental (exchange tables, partition manipulation).☑ Conducted an audit of the BI environment. As a result of the audit, performance issues with DataLens were resolved (converted tables to columnar format, eliminated views, formalized the table update process).☑ Oversaw the migration project from BigQuery to Yandex Cloud (ClickHouse, Airflow, dbt). Trained several teams on working with dbt, ClickHouse, and DataLens.☑ Built several data marts in ClickHouse for operational analytics and application and website data analysis (e-commerce).☑ Led projects to improve reporting on finance, operations, and marketing (key business metrics).☑ Actively participated in a cross-functional project to overhaul the company's main reporting, formulating requirements and setting tasks.☑ Developed several key dashboards in Yandex DataLens.Tech Stack: DataLens, SQL, Python, dbt-ClickHouse, Airflow, GreenPlum, ClickHouse, Superset, Jupyter Notebooks, Yandex Cloud, s3

Лимасол, Кипр

☑ Automated and visualized the company's main financial reports (PnL, Balance Statement) in Qlik Sense☑ Implemented Superset, which reduced Qlik licensing costs and expanded data operations within the company☑ Developed an ETL process for extracting data from the Facebook API (3 data layers)☑ Developed tools for plan-fact analysis, reducing the time required to prepare performance reports for departments by 90%My functions:☑ 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

Москва, Москва, Россия

☑ Developed sales funnel reporting for the online store☑ Created intra-group operations calculation in the PnL☑ Developed an application for evaluating the effectiveness of marketing campaigns, significantly increasing engagement with partners☑ Performed several system upgrades (QlikView 11 to 12, NPrinting 16 to 2020) with additional development of a Windows Service in C# for seamless integration via the NPrinting API☑ Recorded a video course for internal employee training on QlikView functionalityMy functions:☑ 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

Москва, Россия

☑ 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

Москва, Россия

☑ 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

Москва

☑ 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

Москва

☑ Support for business users on working with the ERP "Galaktika"☑ Designing business processes within the framework of ERP implementation and configuration☑ Working out the methodology for entering data into the system to automate the calculation of product margins (what to do where and what coefficients, etc.). ☑ Writing technical specifications for developers=== ADDITIONALLY ===☑ Subject domain: Accounting, Management accounting