About me (EN) | Обо мне (RU)
Portfolio Data Analyst (EN) | Портфолио Аналитика Данных (RU)
Portfolio Data Scientist (EN) | Портфолио Дата-сайентиста (RU)
CV (Resume)
| BI Analyst | Data Analyst | Data Engineer | Data Scientist | 7+ years in IT |
The author of a Telegram channel @Null++ for those who want to grow as a Data Analyst, Data Engineer, BI Analyst or Data Scientist
Contacts
- Location: Arkhangelsk, Russia (Remote / Relocate)
- Email: kolcharma@gmail.com
- Phone: +7-999-250-9045
- Telegram: @hexmikhail
- CV: PDF
Summary
Over 7.5 years in IT, including 6 years as a System Administrator in the government sector, where my primary focus was automating reporting using SQL. In 2025, I decided to transition this expertise into a dedicated analytics role and completed intensive retraining.
I help businesses understand their data by building ETL pipelines (Airflow, Python), designing data marts, and creating dashboards. I enjoy uncovering hidden patterns and have hands-on experience in metric standardization and resolving data discrepancies. I effectively bridge the gap between business goals and technical requirements, designing data architecture from the ground up to final visualization.
Work Experience
Excite Kit — Middle Data Analyst
06.2026 — Present · 3 months
Tech Stack: SQL · ClickHouse · DataLens · Python · A/B-tests
Provide clients with data analytics and BI reporting to support management decisions. SQL (window functions, CTEs, optimization), DataLens (developing dashboards, creating data marts, calculated fields), A/B testing
- Migrating a large Russian company’s analytics to Russian solutions: Created analytical dashboards (DataLens) for transaction analysis, fraud detection, and loyalty program effectiveness → More than 50 reports were redesigned and updated.
Main responsibilities:
- Developing and supporting interactive BI reports (using UXrocket + DataLens).
- A/B experiments with subsequent visualization of results in dashboards for quick demonstration (using UXrocket platform).
Denvik Analytics — BI Analyst
07.2025 — 06.2026 · 11 months
Tech Stack: SQL · ClickHouse · PostgreSQL · Visiology · DataLens · 1C · Power BI · DAX · Python · DVT
Key Achievements:
- Client-facing dashboard redesign: Redesigned dashboard layout and functionality in DataLens → Positive client feedback and 15% increase in leads.
- Manual report automation: Built a data mart from scratch using SQL window functions (running totals, group aggregates) → Data updates automatically when dashboard is opened.
- Purchase planning optimization: Developed a parameterized dashboard in DataLens with demand forecast using seasonal coefficients → Drastically reduced planning time, eliminated manual errors.
- Financial report optimization: Analyzed SQL query, replaced nested subqueries with window functions, optimized indexes → Report execution time reduced from 2+ minutes to 3 seconds.
- HR dashboard enhancement: Added metric dynamics (YoY growth/decline) and employee category filters → HR gained trend analysis capabilities instead of just recording facts.
Internship (Part-time) — Data Analytics
01.2025 — 10.2025 · 10 months
Projects:
| Project | Description |
|---|---|
| Marketplace Sales Analysis | Analytical queries and exploratory data analysis |
| Pharmacy Network Analytics | ABC/XYZ analysis, invoice processing from 1C, ETL pipeline for receipts (PostgreSQL), KPI dashboards (Superset) |
| Education Portal Analytics | MAU/WAU/DAU, retention metrics, user activity by day/week/referral, correlation with performance, API data extraction to PostgreSQL |
| IT-Resume Analytics | ETL pipelines for corporate client sales data |
| Retail Network Analysis | Exploratory data analysis, Power BI dashboard for analysts |
Portfolio: github.com/mishandri/Data-Analysis
District Court — System Administrator
03.2019 — 07.2025 · 6 years 5 months
Tech Stack: SQL · Oracle SQL · MySQL · FirebirdSQL · Windows Server
Responsibilities:
- Developed and optimized 50+ complex SQL queries for ad-hoc reporting
- Administered Windows Server (2003/2008/2012R2): Active Directory, Group Policy
- Managed backups (software, scripts), configured mini-ATS systems
- Conducted training sessions, prepared quarterly/annual reports
GeekBrains — Expert
08.2022 — 11.2023 · 1 year 4 months
Tech Stack: Python · NumPy · Matplotlib · Scikit-learn · Windows Server · WMI · PowerShell
Responsibilities:
- Taught courses on Windows Server, WMI, and PowerShell (webinars, consultations)
- Reviewed homework for Python Data Science libraries (NumPy, Matplotlib, Scikit-learn)
Education & Certifications
| Program | Institution | Period |
|---|---|---|
| Deep Learning Engineer (in progress) | Simulative | 2026 |
| Machine Learning Engineer (in progress) | Simulative | 2026 |
| Data Engineer (Diploma) | Simulative | 2026 |
| Data Analyst (Diploma) | Simulative | 2025 |
| BI Analyst (Diploma) | Simulative | 2025 |
| Postgraduate Studies — Geometry and Topology | NArFU, Arkhangelsk | 2013-2016 |
| Master’s Degree — Applied Mathematics and CS | NArFU, Arkhangelsk | 2010-2012 |
| Specialist Degree — Mathematics (CS specialization) | Pomor State University | 2005-2010 |
Technical Skills
Core Competencies
- SQL: PostgreSQL, ClickHouse, Oracle SQL, MySQL, FirebirdSQL
- BI & Visualization: Power BI (DAX), DataLens, Superset, Metabase, Visiology
- ETL & Data Engineering: Python, Airflow, Docker, Linux, Hadoop, Hive, Spark/pySpark
- Data Science & ML: Scikit-learn, NumPy, Matplotlib, PyTorch (learning), NLP, CV
- Product Analytics: A/B Testing, Product Metrics, Retention (MAU/WAU/DAU), Cohort Analysis
- Other: Git, 1C, Excel, Windows Server Administration
Featured Projects
Last updated: 08/12/2026