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
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.
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.