Patryk Guenther

I'm

About

Data Analyst & Web Developer.

I have over 7 years of experience in Data Analysis and automation of data processing and analysis. I deliver solutions that provide the answers about your business whenever you need them. Additionally, I create websites - both simple sites and advanced webapps.

Skills

Excel 100%
Data Studio 95%
Python 90%
HTML & CSS80%
SQL 95%
JavaScript 55%

Resume

Sumary

Patryk Guenther

Innovative data professinal with 7+ years of experience designing and developing data analysis and automation solutions, dashboards and delivering insights.

Professional Experience

Freelance and Consulting

2022 - Present
  • Analytics in Python, SQL, BigQuery, DataStudio, Redash and Excel
  • Providing solutions in Excel (advanced formulas, complex logic and VBA programming)
  • Simple website development

Business Intelligence Team leader

2020 - 2022

RTB House, Warsaw, Poland

  • Managed a team of 5 data analysts.
  • Created of infrastructure (in Google Cloud Platform) that democratised the access to the data for non-technically oriented users
  • Designed and supervisied flask app with data automation (bigquery SQL, pandas) and powerpoint automation
  • Created and maintained internal Data Studio reports
  • Created and supervised data pipelines for various purposes using Python (pandas, bigquery api, requests, sqlalchemy) and Jenkins. Designed tools to extract data from APIs (REST and graphQL), bigquery databases of petabytes scale, SQL databases and other internal sources
  • Designed and implemented automated and customised mailing based on regular data analysis
  • Consulted in the area of incrementality testing
  • Delivered forecasts based on machine learning
  • Researched machine learning model that captures campaigns' dynamics
  • Coordinated analytical knowledge and data analysis experience exchange between markets and departments
  • Recruited 10 Data Analysts to various teams
  • Managed and responded to ad-hoc demand for data analysis
  • Consulted on new initiatives

Business Intelligence Specialist

2018 - 2020

RTB House, Warsaw, Poland

  • Automated ETL and reporting in Python, with Jenkins and Google BigQuery (pandas, requests, bigquery, sqlalchemy)
  • Created multiple dashboards in Google Data Studio

Sales Analyst

2017 - 2018

GSK, Warsaw, Poland

  • Implemented (project management and technical scopes) two large scale IT projects regarding collection of large volumes of market data - from over 10 wholesalers and ~300 pharmacy chains
  • Coordinated projects involving over 60 people and two external parnters and over 300 abovementioned entities
  • Automated data analysis (ETL & reporting) with Python (pandas, pyodbc, selenium, sqlalchemy, os) SQL, Windows Server and PowerBI

Market Research Analyst

2016 - 2017

Nielsen Innovation Practice (BASES), Warsaw, Poland

  • Forecasted sales for the innovative initiatives within OTC category on the European and the USA markets
  • Mentored junior employees
  • Designing and delivering departmentwide methodology and best practices trainings

Intern

2015

Nielsen, Warsaw, Poland

  • Analysed innovative initiatives on the worldwide markets
  • Conducted in-depth retail market research in Poland as part of Nielsen Graduate Programme

Education

Master of Psychology

2011 - 2016

University of Warsaw, Warsaw, Poland

  • As a member of University of Warsaw Psychology Students self-government, coordinated of international conference / project Warsaw Goes International - event involving 30 participants and over 15 project team members
  • Recieved the scholarship for academic achievements twice - Dean's List 2012/2013 and 2013/2014

Bachelor of Management

2012 - 2015

Warsaw School of Economics, Warsaw, Poland

Specialisation: Marketing

Services

I provide wide range of services from simple website creation, through webapp development, data analysis in Excel to data analysis automation and dashboarding in Python and DataStudio.

Data Analytics

I have over 7 years of experience in analysing data in Python, SQL, Excel, Google Sheets, Data Studio, PowerBI and other tools.

Dashboards

I have created numerous dashboards in Data Studio and PowerBI. I can also help you with your Tableau and Looker dashboards.

Websites and Webapps

I have created both simple websites and webapps with user login, content management, uploads, admin area and any other functionalities. I have used django and flask in the backend and html, css and javascript in the frontend.

Automation

I have automated data workflows in python, SQL, using Jenkins, Windows Server and GCP.

Excel and VBA

I will help you with excel programming. I have experience in Advanced Formulas, VBA and Visualisation.

Python

Projects I've delivered include webapps, data processing and analysis automation, webscraping, automatic emails with complex logic, data science models and dashboards in Dash and H2O Wave.

Contact