Lenar Afzaltdinov
Data Analyst
Summary
Data Analyst with hands-on experience in building scalable analytics solutions and driving business impact through data. Skilled in BI tools (Tableau, Power BI), data modeling with dbt, and advanced analysis in Python.
Overview
14
14
years of professional experience
2
2
Languages
Work History
Data Analyst
Oskelly
Santiago
01.2025 - Current
- Data Modeling in dbt & ClickHouse: Building robust data marts and transformation layers using dbt. Writing efficient SQL code on ClickHouse with optimization techniques like MergeTree, window functions, and incremental models.
- Dashboard Development in Tableau & Power BI: Creating interactive, user-friendly dashboards that support business users in decision-making. Employing DAX and custom measures for deep metric analysis.
- Ad-hoc Analytics: Executing on-demand analysis to answer urgent business questions, uncover trends, and support cross-functional initiatives.
- Performance Monitoring: Tracking key metrics (e.g., GMV, orders, returns) across business dimensions such as seller segments, brands, and buyer cohorts.
- Collaboration: Working closely with business stakeholders to translate domain knowledge into actionable reporting and analytical models.
- Decision Support: Driving product and operations improvements through structured insight delivery and hypothesis testing.
Data Analyst
UZUM
Toshkent
11.2023 - 01.2025
- Data Extraction and Retrieval: Proficient in extracting and retrieving data from SQL databases. Skilled in implementing efficient querying techniques to collect relevant and accurate information.
- Data Transformation: Utilizing advanced Power Query skills to transform raw data into structured and usable formats. Employing DAX (Data Analysis Expressions) for complex data manipulations and calculations.
- Report Development in Power BI: Experienced in designing and developing comprehensive reports in Power BI. Ensuring the creation of visually appealing, insightful, and user-friendly dashboards.
- Data Analysis: Conducting in-depth analysis of datasets to extract actionable insights. Identifying key performance indicators and uncovering business trends through meticulous examination.
Data Analyst
Lasselsberger Group
Larnaka
09.2022 - 11.2023
- Reporting and Visualization with Power BI: Skilled in creating informative reports, transforming complex data into visually appealing Power BI dashboards for managerial presentations.
- Identification of Sales Influencing Factors: Strong understanding of factors affecting sales outcomes, with expertise in analyzing dependencies between results and various business conditions.
- SQL Querying and Data Manipulation: Experienced in writing and optimizing SQL queries for data extraction, transformation, and analysis, supporting informed decision-making.
- Power BI Report Creation: Proficient in designing impactful Power BI reports, turning complex datasets into insightful outputs to support strategic decisions.
Data analyst
Oil Cargo Group
03.2020 - 09.2022
- Deviation Analysis and Reporting: Regularly conduct in-depth analysis of deviations from the sales plan, leveraging SQL for data extraction and transformation. Provide timely insights to adjust strategies aimed at achieving or surpassing sales targets. Utilize Power BI to deliver visually compelling reports for management review.
- Visual Report Compilation: Proficient in compiling comprehensive reports using SQL queries and presenting them to management in visually engaging formats. Expertise in Power BI enables impactful data visualizations that enhance decision-making.
- Multi-Company Accounting Management: Skilled in managing accounting processes across a group of companies, utilizing SQL for financial data analysis and reporting. Ensure accurate financial tracking and regulatory compliance across diverse business entities. Use Power BI to deliver clear and concise presentations of financial insights.
Senior economist to Head of Business Development
AkBarsBank
09.2012 - 03.2020
- Client Engagement and Information Collection: Proficient in visiting business premises to gather valuable client information firsthand, establishing strong rapport and gaining deep understanding of client needs.
- Financial and Economic Analysis: Conduct comprehensive financial and economic analyses by utilizing data collected from multiple sources, including departmental datasets, to provide insightful and actionable recommendations.
- Financial Modeling and Reporting: Skilled in constructing balance sheets, financial statements, and cash flow models using collected data. Prepare comprehensive reports for management, offering clear insights into financial performance and growth opportunities.
- Data Analysis and Interpretation: Analyze diverse datasets gathered from departments, applying advanced analytical skills to extract meaningful insights and identify trends for strategic decision-making.
The Auditor Intern
PricewaterhouseCoopers
01.2012 - 04.2012
- Audit Execution: Proficient in performing audit assignments, ensuring thorough examination of financial records and processes to guarantee accuracy, compliance, and financial integrity.
- Comprehensive Consulting: Provide expert tax, accounting, and legal consulting, delivering strategic guidance to clients for effective financial management and regulatory compliance.
- Data Analysis and Interpretation: Analyze extensive datasets collected from various departments, employing advanced analytical techniques to extract valuable insights, identify trends, and support data-driven decision-making.
Education
Communication and Business Skills
Bournemouth Business School International
01.2016
Financial and Credit
Kazan Federal University
01.2012
Foreign languages
Kazan Federal University
01.2010
Skills
SQL (ClickHouse, Oracle, MS SQL)
Websites
Accomplishments
Oskelly — Data Analyst
- Migrated the majority of reports from an outdated and inefficient BI system to Tableau, building a dashboard ecosystem that covered ~80% of business requests. This reduced the load on analysts from ad-hoc queries and accelerated decision-making.
- Designed the architecture of data marts and data marts layers (clean and aggregated data) using dbt, providing a robust analytical foundation for adjacent teams such as Machine Learning and Financial Analytics.
- Conducted user behavior analysis in Python, identifying significant correlations that helped increase the average order value and overall revenue
Uzum — Data Analyst
- Built and automated dashboards in Power BI, enabling real-time monitoring of key business processes and performance indicators.
- Developed data marts and analytics layers using dbt, ensuring reliable, clean, and scalable data pipelines.
- Designed and implemented custom metrics for Kapitalbank (part of the Uzum Group) to support strategic and regulatory needs.
- Provided dashboards and analytics that allowed Kapitalbank to successfully meet mandatory reporting requirements from the Central Bank of Uzbekistan.
Timeline
Data Analyst
Oskelly
01.2025 - Current
Data Analyst
UZUM
11.2023 - 01.2025
Data Analyst
Lasselsberger Group
09.2022 - 11.2023
Data analyst
Oil Cargo Group
03.2020 - 09.2022
Senior economist to Head of Business Development
AkBarsBank
09.2012 - 03.2020
The Auditor Intern
PricewaterhouseCoopers
01.2012 - 04.2012
Financial and Credit
Kazan Federal University
Foreign languages
Kazan Federal University
Communication and Business Skills
Bournemouth Business School International