Denis Semenov

 DENIS SEMENOV Date of Birth 29.Aug.1984 Contacts Phone. -, - E-Mail:- EDUCATION - Belarussian State Economic University. Finance and Marketing. Bachelor Degree - 2006 Business English courses «The London Skills Institute», London, UK 2007 Project Management. IPM Business school, Minsk, Belarus EXPERIENCE 05.2006 -06.2007 JLLC «CDC – central distribution company», (Official Colgate, Palmolive, Libresse, Libero, Bella distributor in Republic of Belarus) Leading Specialist of Analysis and Marketing Department - development and classification of distribution channels; - development of strategies for improving distribution channels; - development of a system for collecting information from the company's customers; - development of a reporting system for sales representatives; - dealing with data arrays; - trading activities analysis of the organization; - writing analytical notes, development of recommendations and forecasts; - JLLC “System Technologies”, (Software development in banking and financial sector) Leading Specialist of the Department of Analysis and Methodology of Business Systems - business processes analysis, setting goals and participation in the implementation of OLAP for Raiffeisen Bank - implementation of MS Project software within the organization 05.2010 - JLLC "BelInterProduct", (Food-retail chain “Rublevski”, Belarus) Head of Analytics and Financial Control Department - development and implementation of the automated reporting system; - budgeting; - short- and long-term forecasting and planning of key indicators of the Company's commercial activity; - commercial potential assessment of the implemented programs of demand stimulating and customer loyalty increase, technological innovations, etc.; - retail spaces effectiveness analysis; - commercial and marketing department business processes optimization; - commercial activities control and analysis of - product matrix development - – now Outsource Specialist Reporting and Analytics Systems Business processes automation. Analytics systems development and implementation Wholesale and retail consulting Outsource Specialist Skills: - Data modelling from scratch - Advanced Power Query user - Complicated DAX Queries generating - Designing report pages and dashboards with tables, visualizations, dynamic filters and measures - Multi-lingual and multi-currencies reports - Huge experience in data preparation and data gateways - More than 10 years’ experience in trade analytics, budgeting and accounting - Huge experience in Power BI analytics development and implementation for various business purposes (Wholesale and retail trading, Production, HoReCa, Logistics, GameDev and so on), as a consultant (business requirements research and analysis) and developer - Creating tools for forecasting and modelling Huge experience in: - development and implementation of automated reporting systems; - budgeting automation; - short- and long-term forecasting and planning of KPI; - all kinds of analysis support GMROI, ABC-XYZ, RFM, Compare analysis, Like-4-like Analysis and so on - correlation coefficient insights - coefficient of variation insights - new and returning customers analytics - customer base segmentation - dynamic rankings - basket analysis - customer lifetime analysis - commercial potential assessment of the implemented programs of demand stimulating and customer loyalty increase, technological innovations, etc.; - retail spaces effectiveness analysis; - commercial and marketing department business processes optimization; - product matrix development - trade and products movement analytics (turnover, revenue, sales) - Inventory analysis and Logistics (stocks, turnover, efficiency) - receipt and order analytics and qualitative indicators (average order, order frequency, customer segments) - modeling, planning and forecasting (price modeling, expected order modeling, cross selling) - product matrix development - increasing of the warehouse staff efficiency (staff workload and optimization) - customers delivery schedule optimization, increasing the efficiency of transport use - retail loyalty program analytics, personalization of customers according to their needs - automated system of recommendations for the rotation of the assortment in product matrix - the impact of changes to the overall financial performance modeling and forecasting - automation of the following processes: ordering goods for retail outlets, reassessing the assortment, moving goods between retail outlets ADDITIONAL Skills MS Excel, MS Access, Qlik Sense, Power BI, Power Query, DAX Studio English Level Intermediate