- founding and managing consultation company focused on data analytics and automation of office work

- designing Business Intelligence team ready for European expansion from team structure and system architecture perspective- leading and developing 4 streams of BI with mission to help Rohlik Group with "Better, faster and automated decision-making". - the country BI team focusing on consulting and insight- data engineering team focusing on core BI infrastructure across the group- team of BI Analysts working in the Agile structure of the company- ML/AI stream focusing on personalisation of web/app or CRM, forecasting in various areas, automation in operations, pricing- technologies: AWS SageMaker, GCP Big Query, Keboola, Snowflake, Tableau, Tibco, SQL, python

- leading and developing 2 teams in Rohlik Group expanding across Countries in Central and Western Europe - the team of Business Intelligence Analysts in our individual markets across Central Europe serving in local managements and providing strategic reporting and insight- the team of group analysts sitting in the headquarter developing tools and reports for our country teams

- building end to end BI solutions primarily for commercial and marketing departments- building suppliers monetization platforms for data and trade marketing- using Keboola, Tableau Server, Google BigQuery with GA 360, coding SQL and python

- leading team of 20+ data analytics, reporting and insight professionals in commercial department managing nearly 1000 stores across Central Europe- replacing excel based reporting with server-based reporting consumed through web browser using Microstrategy Web Services and Tableau platform allowing business to have quick access to long-term trends and drilling capability from top-line view into product level detail- advocacy and participation on deployment of Hadoop/Spark to enable us to perform analytics on transactional level data using SQL and Python- optimizing promotional performance through strategic data acquisition and organizing data into unified data model allowing us to deploy machine learning techniques- using various forecasting methodologies to keep the business informed about the likelihood of meeting its targets

- datasapiens is a startup with a focus on retail analytics and CRM, where my responsibility was to define new business intelligence solutions and bridging clients' analytics requirements to technical teams - data science and software development- leading production of large-scale customer insight presentations based on all available data ( transactional sales, margin, marketing - loyalty card, shopping frequency, shopping basket analysis); defining customer segmentations, business opportunities and recommendations for customers strategies- responsibility for analytic and CRM projects for clients across industries (Marks & Spencer, Benu Pharmacies, Shell CEE or Rohlik.cz)- technologies used were SQL, AWS - Redshift, Tableau, in-house BI software, Python

- responsibility for two 4 members teams focusing on Core Data Team (focus on internal master data) and Market Data Team (focus on externally sourced data about market)- designing reporting and dashboarding on newly implemented Microstrategy BI platform benefiting from Microstrategy Excel Add-on, initiate the effort to align approach to data and data management across the company and initiate establishing company level Data Governance and as result limit amount of standards, duplications and time wasted on people having different numbers- consult with IT issues related to data engineering influencing data quality, data freshness, data availability, compatibility and integration- products range review, promo optimization, customers segmentations, market benchmarked performance evaluation, campaigns performance evaluation, planograms performance analytics

- in the new joint Central European Tesco (CZ, SK, HU, PL) management structure my role was to lead a team of 4 market data analysts with the goal to fuel data-driven decision making in marketing and commercial departments across all levels of management and four countries- using variety of business data sources : Nielsen, GfK, Mintel, dunnhumby combined with Tesco internal BI data- achieving 360-degree view of the market and customers, managing contracts and interactions with our external data partners including monetization of our internal Tesco sales data- our tools are MS Excel (including PowerPivot, VBA), MS Access, Microstrategy Developer, SQL, Sharepoint Online, Trello

- research technology to improve reporting (evaluating different BI platforms as Excel PowerPivot and Power BI by Microsoft, Microstrategy, Business Objects)- design business relevant KPIs- advocate and pursue realization of the idea of Data Warehouse to the leadership of Tesco- cooperation on Microstrategy BI Tool implementation on behalf of the commercial team and communicating the commercial team's needs, participating in Microstrategy testing

- on-site consultant and data analyst dedicated to Tesco Stores CR supporting market data-driven decisions across Tesco HQ departments (mainly Commercial Department) with consultations, training and data tools development (Excel/VBA)- presenting regular or ad hoc analysis on request, pro-active opportunities seeking- reflecting on-site experience with client's business into Nielsen services and products