Dias Orazymbetov

Data Analyst

Wrote complex multi-step SQL-equivalent queries in 1C query language for operational analytics: multi-table JOINs, CTEs, conditional aggregations, subqueries, and window-function-equivalent logic on large transactional datasets. Built and automated service-level reporting in Power BI covering product availability, sales performance, and inventory status — used daily by commercial and operations teams. Developed Power Query transformations and advanced Excel models (INDEX/MATCH, array formulas, pivot tables) for ad-hoc business analysis and data reconciliation tasks. Maintained and improved data pipelines for stock forecasting: join-based logic across multiple registers, date-range calculations, and branch-level aggregations across a multi-city retail network. Handled multiple concurrent analytical workstreams independently; communicated results and recommendations directly to business stakeholders in a fast-paced, high-volume commercial environment. Owned the “Hit and Wow” assortment strategy data workflow — responsible for data accuracy and timely reporting in a process contributing ~7% of total company revenue.

• Owned the “Hit and Wow” assortment strategy data workflow — responsible for data accuracy and timely reporting in a process contributing ~7% of total company revenue.

Data Analyst Intern

Performed transactional data analysis using SQL and Excel to identify demand patterns and peak sales periods; built forecasting models that informed inventory decisions and contributed to a 7% increase in fuel sales. Prepared analytical reports and delivered recommendations to senior management under tight deadlines.

• Built forecasting models that informed inventory decisions and contributed to a 7% increase in fuel sales.