Skip to content
DSML.KZ
MA

Miras Amirkhan

@myrusConnected with DSML. This person's Telegram account has been confirmed through DSML Kazakhstan.

BI Analyst

Data Analyst with experience building production BI dashboards and analytical tools at a PE holding.

About

Built a forensic accounting app with risk-scoring and Benford’s Law analysis for multi-company audit. Analyze budget execution, revenue centers, and loan portfolios using Power BI, Python, and SQL. Strong statistics foundation from a Physics-Informatics degree.

Career

Experience: 1 years

Experience

BI Analyst

Hayat Investment (Kazakhstan Hotel)

Mar 2026 — Present

Builds a budget execution dashboard and works with budget, loan portfolio, and revenue-center data; no quantified results stated.

• Building a Power BI dashboard for budget execution (plan vs. actual) with DAX measures and a multi-page structure. • Prepared Excel sources in long format and analyzed the loan portfolio. • Worked with multiple data sources: budget, portfolio, revenue centers. • Creating and developing web and Python apps with vibecoding.

Education

Bachelor’s Degree, Physics-Informatics

SDU University

2021 — 2025

Selected projects

SQL Academy — 200+ Analytical Queries

Solved test assignments from VK, Alfa-Bank, Sberbank, T-Bank, Amazon, Facebook, GlowByte, and 10+ other companies. Applied window functions, CTEs, complex JOINs, subqueries, and aggregations on sales, flights, and Airbnb datasets.

Tele2 eSIM — Product Analytics Case Study

Segmented customers by travel and roaming behavior to define target audiences for a new eSIM product. Designed a star-schema Data Warehouse with fact and dimension tables. Evaluated A/B test results by calculating CR, CPA, Profit, and ROI; recommended the profitable campaign variant.

1C Analytics — Forensic Accounting Tool

Built a standalone PWA analyzing 1C accounting exports with a risk-scoring engine (8 criteria) and Benford’s Law (MAD scoring vs. Nigrini’s thresholds) for forensic audit. Holding-company mode supports comparative analysis across multiple entities with period-over-period trend deltas on KPIs. Fully offline single-file app; exports to 6-sheet Excel and PDF.

Skills

SELECTJOINGROUP BYHAVINGwindow functionsCTEssubqueriesINSERT/UPDATE/DELETEVIEWVLOOKUP/XLOOKUPpivot tableschartslogical functionsdata cleaningdate functionspandasnumpymatplotlibJupyter NotebookEDA