← Back to list
Registration: 10.05.2023

Daurenzhan Zarpen

IT
senior
Specialization: Data Analyst

Portfolio

Zentist

- Developed and maintained reports and dashboards using Holistics.io, presenting data in a clear and actionable manner for stakeholders. - Performed regular quality assurance checks on data sources, optimizing SQL scripts and troubleshooting errors to ensure data accuracy. - Conducted in-depth research and analysis of data anomalies, identifying key issues to minimize risks and improve decision-making.

Philip Morris Kazakhstan

- Designed and implemented robust data systems, using MS SQL Server and Python to troubleshoot errors and ensure data accuracy. - Sourced and integrated data from primary and secondary sources, maintaining data integrity and supporting ongoing data-driven decision making. - Created comprehensive documentation and data dictionaries to enable easy replication of analyses and collaboration across teams. - Developed interactive dashboards and visualizations using Power BI, providing stakeholders with real-time insights to drive data-driven decision-making across the organization.

Philip Morris Kazakhstan

- Collecting and analyzing market and consumer information to support development of relevant business strategies. - Designing and leading agile research to inform key business decisions. - Optimizing existing reporting and dashboards to improve data insights. - Migrating reports and dashboards to Power BI service to reduce data usage and increase refresh rate.

Skills

Advanced Excel
BigQuery
DAX
GoogleAnalytics
MS SQL Server
MySQL
Pandas
PostgreSQL
Power BI
Python
SQL

Work experience

Data Analyst
since 05.2022 - Till the present day |NDA
SQL, Google BigQuery, Holistics, MySQL, Databases, Google Analytics, Python
- Developed and maintained reports and dashboards using Holistics.io, presenting data in a clear and actionable manner for stakeholders. - Performed regular quality assurance checks on data sources, optimizing SQL scripts and troubleshooting errors to ensure data accuracy. - Conducted in-depth research and analysis of data anomalies, identifying key issues to minimize risks and improve decision-making.
Data Analyst
05.2021 - 05.2022 |Philip Morris Kazakhstan
Data Modeling, Python, SQL, Microsoft Power BI, Microsoft SQL Server, Logistic Regression, PostgreSQL, Databases, BigQuery
- Designed and implemented robust data systems, using MS SQL Server and Python to troubleshoot errors and ensure data accuracy. - Sourced and integrated data from primary and secondary sources, maintaining data integrity and supporting ongoing data-driven decision making. - Created comprehensive documentation and data dictionaries to enable easy replication of analyses and collaboration across teams. - Developed interactive dashboards and visualizations using Power BI, providing stakeholders with real-time insights to drive data-driven decision-making across the organization.
Business Intelligence Analyst
08.2019 - 05.2021 |Philip Morris Kazakhstan
Power BI, SQL, MySQL
- Collecting and analyzing market and consumer information to support development of relevant business strategies. - Designing and leading agile research to inform key business decisions. - Optimizing existing reporting and dashboards to improve data insights. - Migrating reports and dashboards to Power BI service to reduce data usage and increase refresh rate.
Project Analyst
07.2018 - 07.2019 |Philip Morris Kazakhstan
Power BI, SQL, MySQL
- Conducting Market analysis and reports based on big data. Responsible for projects aimed at conducting industry research and overview. - Overview of 4 markets: Kazakhstan and Central Asian countries. Impact: Successfully completed project aimed at collecting and summarizing market research data in order to expose possible threats and improvement areas.

Educational background

Finance (Bachelor’s Degree)
2015 - 2019
Narxoz University

Languages

TurkishUpper IntermediateKazakhNativeEnglishUpper IntermediateRussianAdvanced