Alexey Dmitriev
Data Analyst at X5 FoodTech- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
X5 Digital
-
Russian Federation
-
IT Services and IT Consulting
-
100 - 200 Employee
-
Data Analyst
-
Nov 2021 - Present
I'm working with data in the biggest retail group in Russian Federation. Our company has near 30 000 supermarkets in the country. - Writing business requirements for creating new data marts- Creating new data marts and making adjustments to the objects in DWH- Desining DWH objects to the Data Vault and Dimensional Modelling methodology- Writing pipelines in Airflow, Attacama- Ad-Hoc- Writing querries in Hive- Writing documentation I'm working with data in the biggest retail group in Russian Federation. Our company has near 30 000 supermarkets in the country. - Writing business requirements for creating new data marts- Creating new data marts and making adjustments to the objects in DWH- Desining DWH objects to the Data Vault and Dimensional Modelling methodology- Writing pipelines in Airflow, Attacama- Ad-Hoc- Writing querries in Hive- Writing documentation
-
-
-
Hoff
-
Russian Federation
-
Retail Groceries
-
100 - 200 Employee
-
Data Analyst
-
Mar 2021 - Nov 2021
• User behavior analysis, EDA, AB tests,• Ad-hoc • Python (API, Pandas, Seaborn, Mathplotlib) • Writing SQL reports in SPP and MPP DBMS• Bloomreach (Exponea) - developing comunication scenarios with clients• Preparing and presenting analytical reports in Excel and Python(Pandas, Seaborn) • Writing SLA and technical specifications• Communication with business customers • User behavior analysis, EDA, AB tests,• Ad-hoc • Python (API, Pandas, Seaborn, Mathplotlib) • Writing SQL reports in SPP and MPP DBMS• Bloomreach (Exponea) - developing comunication scenarios with clients• Preparing and presenting analytical reports in Excel and Python(Pandas, Seaborn) • Writing SLA and technical specifications• Communication with business customers
-
-
-
-
Student Data Analyst & Data Engineer
-
Jul 2020 - Apr 2021
I am inspired by the opportunities to use data in business decision-making.Tasks:-Hypothesis formation-Data preparation (sorting, filtering, grouping)-Data validation (without nulls in mandatory fields, duplicates check)-EDA analysys (Jupyter Notebook)-RFM anaysys -Sales funnel analysys-Correlational analysys - Insights research- Data visualisation (Mathplotlib, Seaborn, Tableau, Excel)- Dashboard visualisation (Tableau)- Writing conclusions and recommendations- Writing simple ML models Stack:SQL (Postges, Oracle) - select, join, where, having, group by, distinct, order by, limit, case, like, over, partition, explainPython (Jupyter Notebook, PyCharm IDE (pandas, numpy, scipy, matplotlib, seaborn, scikitlearn))BI (Tableau, Redash)Excel (VBA, Visualisation, Tables)
-
-
-
-
Analyst in sales
-
Jun 2020 - Feb 2021
Tasks:- Sales funel analysys- Automation of processes- Improving the sales script- Market analysys Tasks:- Sales funel analysys- Automation of processes- Improving the sales script- Market analysys
-
-
-
izburg
-
1 - 100 Employee
-
Sales and Business Development Manager
-
May 2018 - Jun 2020
-
-
Education
-
Московский Государственный Строительный Университет (МГСУ)
Barchelor, Engineering