Sergey Terekhin
Контакты
Обо мне
Responsible and insightful data analyst with 5+ years of experience of management and communication in the field of oil refining and pumping. Eager to leverage Python, SQL, big data interpreting and visualizing skills to drive growth and boost sales results of company. Participated in VkusVill`s anti-hackathon.
Навыки
Опыт работы
- Locko-BankСамараCRM AnalystДекабрь 2022 — По настоящее время (2 года и 2 месяца)
• Construction using SQL and analysis of conversion funnels for activities of contact center.
• Formation of updated reporting in Excel and fulfillment of ad hoc requests of customers.
• Clients segmentation for CRM activities and their analysis.
• Creation of mailings to clients through data marts. - Practicum Boot campМоскваData analyst (educational and project experience)Ноябрь 2021 — Июнь 2022 (8 месяцев)
- Preprocessed and visualized data.
- Identified dependencies and performed exploratory data analysis (EDA).
- Tested statistical hypotheses and prioritized hypotheses (RICE, ICE).
- Analyzed business indicators and worked with metrics (LTV, ROI, CAC, CR, RR).
- Built and analyzed product and marketing funnels.
- Performed statistical tests (Student, Mann-Whitney, Shapiro).
- Analyzed results of A/B testing.
- Created data pipelines and designed dashboards.
- Used machine learning to cluster users and predict event probabilities.
My projects can be viewed here: https://github.com/TerekhinSergey
SQL • Python • Анализ данных • Pandas • Математическая статистика • Tableau • Визуализация - Preprocessed and visualized data.
- LTD «Transneft – Pipeline Construction Directorate»Lead EngineerМай 2019 — Ноябрь 2021 (2 года и 7 месяцев)
- Performed functions of technical customer.
- Conducted business correspondence, coordinated and regulated activities of contractors, design and supervisory organizations for timely construction of pipeline.
- Controlled analysis of design, working and estimate documentation.
- Prepared work plan and wrote reports on construction of facilities.
- JSC «Novokuibyshev petrochemical company»Chief department (50 subordinate shift staff)Апрель 2017 — Март 2019 (2 года)
- Ensured stable operation of two departments of commodity park.
- Distributed shifts of subordinates by workplaces and resolved personnel issues.
- Developed and coordinated measures for repair of pipelines and equipment.
- Supervised pipeline inhibition and cleaning programs.
Высшее образование
- НефтетехнологическийСентябрь 2012 — Сентябрь 2018 (6 лет)
Магистр трубопроводного транспорта углеводородов
Дополнительное образование
Яндекс Практикум
Обучаем разработчиков, тестировщиков, аналитиков, дизайнеров, интернет-маркетологовМосква • 14443 выпускникаНоябрь 2021 — По настоящее время (3 года и 2 месяца)- Preprocessed and visualized data.
- Identified dependencies and performed exploratory data analysis (EDA).
- Tested statistical hypotheses and prioritized hypotheses (RICE, ICE).
- Analyzed business indicators and worked with metrics (LTV, ROI, CAC, CR, RR).
- Built and analyzed product and marketing funnels.
- Performed statistical tests (Student, Mann-Whitney, Shapiro).
- Analyzed results of A/B testing.
- Created data pipelines and designed dashboards.
- Used machine learning to cluster users and predict event probabilities.
My projects can be viewed here: https://github.com/TerekhinSergey
SQL • PostgreSQL • Python • Анализ данных • Pandas • Математическая статистика • Tableau • Визуализация- Preprocessed and visualized data.