Evgeny Ronchinsky Email & Phone Number

Moscow, Russia

Designed the entire analytical part of the bank ⦿ Implemented data gathering tools: Bloomreach (ex Exponea)/Google Analytics/AppsFlyer/ Yandex.Metrika ⦿ Organised PostgreSQL Data Warehouse and PowerBI reports⦿ Developed financial, sales, customer acquisition KPI management dashboards⦿ Cohort analysis, financial KPI dynamics monitoring (incl. ARPPU, LT, revenue)⦿ Gathered and managed analytics team (5 subordinates)

Moscow, Russia

As an SQL Analyst, built detailed sales and marketing funnel ⦿ Delivered sales reports based on marketing data obtained from multiple sources using Microsoft SQL Server ⦿ Reduced data refreshing timing lag to 15 minutes for PowerBI reports by optimizng SQL queries and Python-based clicker ⦿ Participated in the project to build 4 data models (first touch, last touch, last non-organic touch, last non-direct touch) for marketing department: ensured data cleanliness and quality, overviewed SQL queries optimization, assesed re-weighted data ⦿ Collaborated with upper management on data visualization and insights

Москва, Россия

Started web analytics process in a rapidly growing bank ⦿ Manage, track, analyze data across marketing channels (web, advertising, social, PR, email marketing) ⦿ Led and delivered project to build automated end-to-end customer funnel tracking to reach sales and marketing objectives and KPIs ⦿ Helped improve marketing leads by 10% through responsive shift of marketing activities

Москва, Россия

Multi-role product analyst in a analytical startup ⦿ Prepared hierarchy-driven comparative analysis that explained dynamics of kpi changes for key clients ⦿ Held weekly meetings with 4 key clients, presenting results of comparative analysis ⦿ Saved 1.000.000 RUR for dom.ru, a Russian national internet provider, by shifting their marketing spendings between performance channels ⦿ Calculated unit economics models for multiply clients helping them estimate LTV-to-CAC ratio ⦿ Overviewed techincal requirements for implemeting web and mobile tracking through Google Analytics, Google Tag Manager and Adjust ⦿ Served as assistant product manager hepling improve our core analytics product: troubleshoot bugs and worked continuously with customers to understand the problem and improve the solution while documenting the requirements

Москва, Россия

Technical web specialist in a marketing agency ⦿ Provided advanced Google Analytics implementation, inc. Javascript and JQuery events ⦿ Provided advanced GTM implementation, inc. HTML5/YouTube video tracking, scroll-tracking, CSS-listeners etc. ⦿ Created technical requirements for clients' dev teams ⦿ Created Excel dashboards and ad hoc analytic reports using various on- and offline sources with actionable insights ⦿ Helped performance and media teams to reduce manual weekly/monthly reports using Excel, Google Analytics API, Google Spreadsheets, Power Query and Power Pivot

Москва, Россия

Business and team development ⦿ Managed a team of 4 PPC managers ⦿ Supervised contracting processes with international clients ⦿ Created pitch presentations (PPC and search parts)PPC management: ⦿ Yandex.Direct, Google.Adwords, VK, Target.Mail management: planning, keyword selection and clustering, ad copy creation, campaign uploading using Yandex.Commander and Adwords.Editor ⦿ Bidding: • manual bid management on KWs level using Excel modeling • automated and semi-automated bid management гusing several Yandex.Direct automated strategies, conversion optimisers and automatic rules in Google.Adwords ⦿ Provided weekly/monthly reports from Direct, Adwords, Google Analytics and CRM data with recommendations and actionable steps ⦿ Day-to-day and weekly communication with clients, inc. conference calls (English and Russian languages)

Москва, Россия