Experience- Most of my experience is related to trading and investments, where I received up to $10mln in management. I helped to run an online service for beginners, wrote in a corporate telegram channel with 1200 subscribers, worked as a personal manager in a brokerage company, invested own money;- Worked 2,5 years at Sberbank, where analyzed small business loan applications;- Then, I decided to change the direction of my career towards analytics. I've always loved working with numbers, charts and forecasts (stock market), but it would be interesting to work more with data, metrics, visualization, statistics, forecasts, so I singled out BI analytics, data analysis and data science for myself.- I have been working as an analyst for the last year and a half, first in the sales department, then in the marketing department;Skills- I'm studying “Data Analyst" program on karpov.courses. Now I'm learning Python/Pandas, then I'll learn Git, SQL/Clickhouse/Redash, probability theory, statistics, A/B tests, visualization in Tableu, product development and analtycs, Airflow.- Mathematics: I graduated from the Physics and mathematics Lyceum and got the maximum 10 points for admission to the university. According to the Yandex.Praktikum test my interest in working with numbers is 10 out of 10.- Career Guidance test on HeadHunter recommends analytics as a profession. Attentiveness and calculations are the most pronounced qualities. Test on Yandex.Praktikum also recommends Data analysis and programming as the most appropriate areas.- English: The EF SET test showed the result C1. I studied at a school with advanced level of English, and was selected to special group with advanced level at the university, regularly read articles in English while working on the stock marketP.S.- I have EU passport (Estonia) and ready for relocation
-
Marketing AnalystПивной Двор Oct 2022 - Aug 2023Kaliningrad, Russia- Created various reports for sales control, hypothesis testing and decision-making by management (how certain decisions affected sales, decisions on their continuation/cancellation, price changes, continuation/cancellation of promotions, changes in assortment, etc.);- Organized monitoring of competitors product ranges/prices to assess competitors activities and adjust pricing and assortment policies; - Organized and analyzed collected information, and created reports/presentations… Show more - Created various reports for sales control, hypothesis testing and decision-making by management (how certain decisions affected sales, decisions on their continuation/cancellation, price changes, continuation/cancellation of promotions, changes in assortment, etc.);- Organized monitoring of competitors product ranges/prices to assess competitors activities and adjust pricing and assortment policies; - Organized and analyzed collected information, and created reports/presentations for management and founders;- Worked with prices, assortment/matrix, colleagues’ requests for their change/correctness; - Set up promotions in 1C and the loyalty app. Interacted with developers in case of problems;- Administered the loyalty and mobile apps, interacted with colleagues and developers to troubleshoot problems and add new features, described requirements for improvements (to launch new types of promotions, etc.);- Segmented customers and set up push notifications/promotions or lists for conducting surveys (for example, stimulating the return of customers, promotions on the day of the local team football matches, or launching promotions at lagging stores);- Identified suspicious transactions in the mobile app for possible employee violations to avoid such losses;- Helped with Excel settings for faster and more efficient work of managers, automatic calculation of bonuses for employees taking into account various parameters, monitoring stores performance to identify problems, etc;- During my work, the share of customers using the app has increased by more than 6%, and the average frequency of purchases increased by 23%;- Worked mainly with Excel, 1C, the loyalty app from Robot-X, and Power BI. Show less
-
Sales AnalystБалтийская Ярмарка May 2022 - Oct 2022Kaliningrad, Russia- Created reports on sales, turnover, margins, performance of promotions, accounts receivable, etc.;- Generated reports to control the quality of agents' work;- Optimized reporting processes to improve the speed and convenience of report users- Optimized the algorithm of the auto-order and the recommended order to the points. Described the requirements for improvements- Calculated and set up promotions for the new period, communicated with suppliers- Calculated and filed… Show more - Created reports on sales, turnover, margins, performance of promotions, accounts receivable, etc.;- Generated reports to control the quality of agents' work;- Optimized reporting processes to improve the speed and convenience of report users- Optimized the algorithm of the auto-order and the recommended order to the points. Described the requirements for improvements- Calculated and set up promotions for the new period, communicated with suppliers- Calculated and filed documents with client bonuses Show less
Andrey Shubartsov Education Details
Frequently Asked Questions about Andrey Shubartsov
What is Andrey Shubartsov's role at the current company?
Andrey Shubartsov's current role is BI-Analyst/Data analyst.
What schools did Andrey Shubartsov attend?
Andrey Shubartsov attended Санкт-Петербургский Государственный Университет Экономики И Финансов.
Not the Andrey Shubartsov you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial