• Creating an end-to-end data architecture for the company based on Power Bi Service
  • Connecting various data sources to Dataflow (MySQL and PostgreSQL databases, Google Analytics, Google Adwords, 1C, Sharepoint)
  • Data processing using SQL queries and further transformation into Power QueryDevelopment of data models in Power BI Desktop, including different speed level models (weekly, monthly, quarterly, annual) and cross models (where several databases are linked, between which there is no complete match on the primary key ID)
  • Creating reports in Power BI and uploading them to Power BI Service.
  • Programming metrics using DAX.
  • Distribution of accesses of different levels to different team members.
  • Setting up notifications for different team members according to changes in the reports they are interested in.
• E-com analytics of the company's website along with advertising analytics and A/B tests
  • Analysis in Google Analytics of the effectiveness of launched advertising in terms of semantic core, ads, audiences, campaigns, landing pages, and other sections.
  • Recommendations for a testing and experimentation plan for contextual and targeted advertising served on the website.
  • Development of prototypes for A/B testing in FigmaDevelopment and control of the implementation of analytics codes on the website (we worked manually, not through GTM)
• Forecasting sales of future drugs in Power BI and Excel on a per-drug basis:
• Creation and filling of financial models for analyzing the return on investment of projects, taking into account all related operating and one-time costs and sales forecasts
• Evaluation of the investment attractiveness of B2B proposals from competing organizations that offered already marketed drugs at a piece rate.
• Development of various ad-hoc reports of various levels of complexity
• Consultations with team members on websites, advertising, technical specifications, UML diagrams, development of telegram bots, etc.

In the process, developed a Telegram bot for one of the company's departments on the SendPulse low-code platform. >500 different blocks, separate logic in UML diagrams, synchronization with a database based on Google Spreadsheets. It was more of a side project, not related to the core job responsibilities.

Dobrodiya (a manufacturer of oatmeal and related products):

• Analytical reports in Power BI based on competitors' sales data in supermarket chains. Price control of the company's products based on the analytics performed.
• General market analytics - prices, major players, trends, demand elasticity, clustering of SKUs into different price categories and highlighting the main trends.
• Setting up dashboards in Power Bi for the marketing and sales departments.

Ascania FMCG (a manufacturer of food and beverages of various profiles):

• Analytical reports in MS Excel and Power BI on competitors (based on sales data by networks)
• Analytical reports on sales of the company's products, mainly Meat, Mc.Corn, Askania Pack, Okki, Bravo. Slices by region, price, sales control against the plan, development of new sales forecasts based on current trends.
• Setting up dashboards in Power Bi for the marketing and sales departments. Automation of dashboards based on regular uploads of reports from the Sayrei database (based on StorSoft), processing of uploads in Power Query.

GGS Trans (an American logistics company for the express delivery of medium-sized cargo):

• Development of an improvised CRM system based on Google Spreadsheets for the company's operators.
• Automation of reports from the database on revenue, fuel costs, and maintenance
• Automation of weekly payments to drivers based on their routes.

Responsibilities:

• Visualization of website analytics through custom reports in Google Analytics and Power BI with connection to the CMS of sites and server with automated uploads from 1C. Analytics was mainly done for advertising by UTM tags, but if necessary, it was used for A/B tests and for analyzing ROI, sales funnel, bounce rate, and CR of websites in general (especially in the context of top SKUs and individual product categories)
• Managing PPC advertising for clients, mainly online stores (Google Ads, Google Shopping, Yandex Direct, static and dynamic remarketing).
• Control and selection of ads with the best CTR and CPA (depending on the number of purchases)
• Creation and management of targeted advertising on social networks (Facebook, Instagram).
• Setting up Google Analytics through GTM.A/B testing of individual pages on websites or design elements to increase CR.
• Recommendations on setting up CRM, email newsletters, and triggered emails.

Achievements:

• Increased sales for more than 20 online stores.
• Bringing customer's metrics to target ROI

Responsibilities:

• Manage PPC advertising for all keywords relevant to the company, its analytics and CPA optimization.
• Creating a company blog from scratch and a strategy for its maintenance based on client cases and feedback on the system. Video and text interviews with the company's clients.
• Creation of training videos for clients and integrator partners.
• Design and assistance in the integration of the trigger email system. The system was the main feature of retailCRM after the end-to-end analytics, which helped to attract new customers.
• Creation of a referral system for integrator partners and its marketing among the TOP 100 CRM integrators.
• Representing the company at offline events such as ECOM-expo

Achievements:

• The system of triggered emails was built, more than 25 integrators earned money on its implementation at the time of my leaving the company, 10% of the company's clients used it in one way or another.
• Blog articles, emails, and videos are still published according to the scheme I implemented while working for the company
• Despite the high CPC, contextual advertising provided the target CPA

Responsibilities:

• Thinking over, describing and implementing the work of the logistics part of the business (couriers, packaging, interaction between staff, reporting)
• Thinking, describing and implementing the work of the sales department (creating job descriptions, controlling the number of sales, implementing sales scripts)
• Designing, writing, and controlling the implementation of analytics terms of reference (monitoring events on the website, phone calls, creating reports.
• Control, creation and launch from scratch of mailing lists for regular customers of the store (once a week)
• Writing triggered emails and creating a workflow for them.
• Thinking over additional functionality on the website, describing it, setting a task for the programmer, and monitoring its implementation.
• Controlling the costs and payback of certain changes (if possible)
• Control of PPC advertising, moderation of complex topics

Achievements:

• I was able to organize the process so that the owner (who had been doing everything himself and the manager 24/7) simply came at the end of the month and took the earned profit.
• Was able to keep the store open at a time when ads were being blocked en masse (with an increase in the cost per click) and several suppliers of top products sharply raised their prices
• I made the site simple and clear functionality of gifts, promotions, discounts, discounts depending on the quantity of goods, delivery as a gift, etc.

Responsibilities:

• Writing emails for a weekly newsletter (more than 1,000,000 addresses, working through Unisender and Mailersoft).
• Sending control, tests, KPI measurements.
• Writing scripts for promotional videos and overseeing their creation by third-party specialists.
• Creation of triggered email campaigns and texts for them (taking into account all existing marketing campaigns, corporate rules, management wishes, etc.)
• Work with corporate analytics systems. Customizing such systems to meet the needs of triggered emails and newsletters.
• Writing text content for all content pages of the company's websites. Creating text for single-page websites.

Achievements:

• Successfully guided emails through all stages of approval (up to 5 stages + rechecks), while maintaining the schedule of sending.
• Identified patterns in the preferences of the audience with whom there was no contact at all (only online interaction)