A

Altynay Ussembekova

About

Detail

Astana, Kazakhstan

Timeline


work
Job
school
Education
folder
Project

Résumé


Jobs verified_user 0% verified
  • S
    Data Analyst (Trainee)
    Simulative IT-Resume
    Jun 2025 - Current (1 year 1 month)
    Analyzed cohorts (D1/D7/D30) and churn drivers; delivered ~8–12 retention initiatives with KPIs. Wrote Metabase SQL models for retention reporting; cut ad-hoc analysis from ~1-2h to ~10-15m. Built a Power BI marketplace KPI report (orders, AOV, ads budget efficiency); enabled drill-down by category. Ran ABC segmentation on retail transactions in Python/pandas; summarized A/B/C segments for assortment focus. Tools/Skills: SQL, Metabase, Power BI (Power Query, DAX), Python (pandas), cohort analysis, KPI framework, ABC analysis.
  • Andersen Lab
    Business Analyst
    Andersen Lab
    Nov 2024 - Current (1 year 8 months)
    Produced user stories, AC, and use cases; reduced late requirement changes by ~25-35%. Mapped and improved content release workflow; reduced rework cycles from ~3 to ~1-2 per release. Standardized docs (templates, checklists) and supported QA/UAT; improved accuracy by ~15-25%. Delivered BPMN/decision tables and traceability (req → tests → release notes). Tools/Skills: Jira, Confluence, user stories & AC, BPMN/UML, UAT/test cases, traceability.
  • E
    Sales Business Analyst
    Exante - Fintech Brokerage Company
    Aug 2022 - Mar 2025 (2 years 8 months)
    Automated Sales reporting in Sheets/Power BI/Metabase; reduced updates from ~3h to ~30-45m. Migrated reporting to a new DB system (mappings, reconciliations); reached ~98-100% KPI consistency post-cutover. Rebuilt bonus dashboards (model + measures + refresh); increased updates to weekly/daily and cut maintenance by ~60-80%. Gathered requirements via interviews/workshops; produced KPI rules, process diagrams, and user stories. Tools/Skills: Power BI (DAX, modeling), Google Sheets / Appscript, SQL validation (Metabase), KPI design, requirements elicitation, process mapping.
  • C
    HR Data Analyst and freelance Data Analysis Support
    Compass Group ESS
    Jun 2021 - Mar 2023 (1 year 10 months)
    Integrated 1C with Power BI for HR reporting; defined entities, structures, and KPI logic. Standardized monthly/annual HR reporting pack; reduced prep lead time to ~1-2 days. Provided audit-ready datasets and calculation logic; supported annual HR audits. Tools/Skills: Power BI, 1C (HRM), Excel, data modeling, KPI definition, reconciliation, audit support.
Education verified_user 0% verified
  • S
    Data Analysis Traineeship
    Simulative
    Jun 2025 - Current (1 year 1 month)
    Astana, Kazakhstan
  • A
    Master of Science in Economics
    Albert-Ludwigs University of Freiburg
    Oct 2015 - Aug 2018 (2 years 11 months)
    Freiburg, Germany
  • Nazarbayev University
    Bachelor of Arts in Economics (Mathematics minor)
    Nazarbayev University
    Aug 2011 - Jun 2015 (3 years 11 months)
    Astana, Kazakhstan
Projects (professional or personal) verified_user 0% verified
  • R
    Retention Analytics & Improvement Plan (IT-Resume Platform)
    Jan 2025 - Dec 2025 (1 year)
    Objective: Identify churn points and define a measurable retention improvement backlog. Key Contributions: Developed a Metabase KPI dashboard (DAU/MAU, cohort analysis, rolling retention). Produced SQL-based cohort datasets and retention curves; added segmentation by cohort month / usage]. Analyzed correlation between retention and engagement "stimulation" signals (e.g., coin system) to generate testable hypotheses. Tools & Techniques: SQL, Metabase, cohort analysis, retention curves, funnel analysis, correlation analysis, metric definitions. Impact / Adoption: Used in weekly product review / experiment tracking.
  • B
    Bonus Tracking & Payout Modelling System
    Jan 2024 - Mar 2024 (3 months)
    Objective: Deliver a single source of truth for Sales bonus tracking and payout modelling with fast refresh and auditability. Key Contributions: Built an automated Power BI bonus dashboard (payout metrics, exceptions, drill-down by team/period). Implemented a Google Sheets operational tracker as a controlled fallback layer (validated inputs, change control). Automated data preparation and refresh via Google Apps Script (scheduled runs, cleansing, consistency checks). Tools & Techniques: Power BI (Power Query, DAX, data modeling), Google Sheets, Google Apps Script, KPI definitions, data validation. Impact / Adoption: Cut manual updates from ~3 hours to ~30 minutes; increased refresh cadence from monthly to weekly/daily; used by Sales Ops / S