Pavel Vydra, Developer in Prague, Czech Republic
Pavel is available for hire
Hire Pavel

Pavel Vydra

Verified Expert  in Engineering

Product Management Developer

Location
Prague, Czech Republic
Toptal Member Since
August 31, 2018

Pavel has over a decade of experience in data science and product development, mainly focusing on product, project, and process management. With a strong data background, his focus has been on finding the right balance between the key value-add features and cost-effective solutions.

Portfolio

Toptal and Other Clients
Spark, Tableau, APIs, SQL, RStudio Shiny, R, Python
eBay, Inc.
CSS, Microsoft Power BI, Git, jQuery, HTML, JavaScript, PHP, APIs, SQL...
eBay, Inc.
CSS, ETL, SAS, APIs, jQuery, HTML, JavaScript, PHP, Teradata, Tableau, R, SQL

Experience

Availability

Part-time

Preferred Environment

Git, JavaScript, SQL, Python, R

The most amazing...

...project I've managed is an automated trading system for a stock broker.

Work Experience

Data Science Consulting

2015 - PRESENT
Toptal and Other Clients
  • Worked as a contractor with the Boston Consulting Group (R, Python).
  • Developed trading automation for a stockbroker using R.
  • Built advanced Tableau dashboards for the University of Colorado, provided support to various Tableau users from the University, wrote Python ETL scripts, and served as a mentor during the University hackathon.
  • Created a CRM data layer based on 1,000+ unstructured Excel and other data files using an automated parser in R for a client in Dubai.
  • Set up data visualization dashboards for Arduino.
  • Designed and developed a BI environment for a client in Brazil.
  • Designed and developed data architecture for a startup based in Silicon Valley and got involved in the early stages as the tech lead.
  • Developed reporting capabilities for Motorola Solutions.
  • Developed an insights layer for a client in the Czech Republic.
Technologies: Spark, Tableau, APIs, SQL, RStudio Shiny, R, Python

Product/Project Manager (Consultant)

2015 - 2018
eBay, Inc.
  • Took ownership of global growth marketing operations reporting tools (dashboards, visualizations, automated notification systems, etc.).
  • Helped manage the development of an internal global growth workflow management system; oversaw all data and reporting-related aspects, information security, and process improvement. Designed the data structure for reporting purposes.
  • Took ownership of GMO platform data, working with other product teams to align on data requirements and build data connections.
  • Led the development of an automated campaign alert system for automated detection and escalation of any marketing campaign that would be causing spikes in customer service calls.
  • Performed technical screening and interviews with new people in the GMO reporting team.
  • Consulted on data utilization in Six Sigma projects in GMO.
  • Delivered Six Sigma training for GMO teams. Mentored several Six Sigma projects.
  • Delivered R training for GMO analysts.
Technologies: CSS, Microsoft Power BI, Git, jQuery, HTML, JavaScript, PHP, APIs, SQL, Six Sigma, Jira, R, Scrum

Global Marketing Operations Reporting Analyst

2013 - 2015
eBay, Inc.
  • Managed all data aspects of marketing activities of eBay Australia as well as eBay seller marketing (DE/UK). Executed email and on-site campaigns as well as prioritized and defined exclusions, including triggered campaigns. Ensured that targeting meets all legal and global targeting requirements.
  • Maintained a SQL script library, took knowledge ownership of marketing data post-processing, and educated and trained new team members.
  • Worked closely with the marketing technology, infrastructure, and product teams to improve and automate as much from the operational team's work as possible. Negotiated business requirements for marketing product development. Initiated and owned several related projects.
  • Owned the GMO operating metrics (EU) for campaign reporting and data visualization. Provided advanced BI support for marketing operations teams and management. Created automated reports in Tableau for monitoring and planning purposes. Secured live report automation. Connected to external APIs.
  • Led a Six Sigma project (team of five people) to reduce defects in campaign operations (human-caused errors reduced by 70%). Provided extensive data support and consultations for other Six Sigma projects. Gained Six Sigma Green Belt certification.
Technologies: CSS, ETL, SAS, APIs, jQuery, HTML, JavaScript, PHP, Teradata, Tableau, R, SQL

Marketing Data Analyst for Microsoft

2010 - 2013
Wunderman
  • Performed data analysis on Microsoft sales and marketing databases, preparing list pulls for marketing campaigns and processing data uploads.
  • Built and optimized scripts, involved with the automation of data processes.
  • Collaborated with the Global Analytical V-Team for marketing analytical models.
  • Prepared, formatted in HTML, and executed email campaigns. Provided complete marketing support for subsidiaries.
  • Worked with a special high-performance team that catered to Russia and Ukraine subsidiaries.
Technologies: SharePoint, Exacttarget, Microsoft Excel, SSAS, SQL Server Integration Services (SSIS), SQL

Medal Engraving Automation: 6x Faster Processing

Helped a friend optimize the process related to Marathon races medals for his medal engraving company. In the beginning, he had to type down names and times of all people interested in having their medals with their names, which took him a lot of time and caused long lines, which discouraged a lot of customers. I helped him automate the entire process starting with retrieving the runner's full name and finish time from the vendor's server (based on their number) and sending it to the engraving machine with just two clicks. The entire process has improved his productivity sixfold.

E-learning System for Soft Skills

Built an online learning system for soft skills (communication skills, time management, presentation skills, non-verbal communication, etc.), which included learning chapters with videos, interactive exercises, and integrated functionality for communication with trained mentors.

Independent Web Development

I have worked on several web development projects as a contractor or independently pro bono. I started working with HTML/CSS, PHP, MySQL, and JavaScript in 2004 and it has been my hobby since then.

Languages

SQL, R, PHP, JavaScript, Python, HTML, SAS, CSS

Libraries/APIs

jQuery, Keras, TensorFlow

Tools

Microsoft Excel, Tableau, Git, Microsoft Power BI, Looker, SSAS, Jira, Apache

Paradigms

Six Sigma, ETL, BPMN, Business Intelligence (BI), Data Science, Design for Six Sigma, Database Design, Scrum

Storage

JSON, Amazon S3 (AWS S3), SQL Server Integration Services (SSIS), Exacttarget, Teradata

Industry Expertise

Project Management

Other

R Programming, Data Analytics, Process Design, Product Management, Data Analysis, Data Engineering, Growth, Lean Development, APIs, Certified Scrum Product Owner (CSPO), Machine Learning, Artificial Intelligence (AI)

Frameworks

RStudio Shiny, Spark

Platforms

SharePoint

2011 - 2014

Master's Degree in Information Management

University of Economics - Prague

2008 - 2011

Bachelor's Degree in International Area Studies

Charles University - Prague

OCTOBER 2015 - PRESENT

Six Sigma Green Belt Certification

eBay, Inc.

JULY 2015 - JULY 2017

Certified Scrum Product Owner

Scrum Alliance

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring