Pavel Vydra
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.
Pavel is available for hire
Hire PavelPortfolio
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
Data Science - 7 yearsBusiness Intelligence (BI) - 7 yearsProject Management - 7 yearsR - 6 yearsProduct Management - 4 yearsSix Sigma - 4 yearsPython - 3 yearsMachine Learning - 1 yearLocation
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
2015 - PRESENT
Data Science Consulting
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
2015 - 2018
Product/Project Manager (Consultant)
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
2013 - 2015
Global Marketing Operations Reporting Analyst
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
2010 - 2013
Marketing Data Analyst for Microsoft
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
Experience
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.
Skills
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
Education
2011 - 2014
Master's Degree in Information Management
University of Economics - Prague
2008 - 2011
Bachelor's Degree in International Area Studies
Charles University - Prague
Certifications
OCTOBER 2015 - PRESENT
Six Sigma Green Belt Certification
eBay, Inc.
JULY 2015 - JULY 2017
Certified Scrum Product Owner
Scrum Alliance