Data Science Consulting
2015 - PRESENTToptal 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, PythonProduct/Project Manager (Consultant)
2015 - 2018eBay, 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, ScrumGlobal Marketing Operations Reporting Analyst
2013 - 2015eBay, 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, SQLMarketing Data Analyst for Microsoft
2010 - 2013Wunderman- 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
Pavel Vydra
Machine Learning Developer in Prague, Czech Republic
Member since August 31, 2018
Pavel has over a decade of experience in data science and product development, especially 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 now available for hire
Portfolio
- Toptal and Other ClientsSpark, 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 years
- Business Intelligence (BI) 7 years
- Project Management 7 years
- R 6 years
- Six Sigma 4 years
- Product Management 4 years
- Python 3 years
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.
Employment
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, CSSLibraries/APIs
jQuery, Keras, TensorFlowTools
Microsoft Excel, Tableau, Git, Microsoft Power BI, Looker, SSAS, Jira, ApacheParadigms
Six Sigma, ETL, BPMN, Business Intelligence (BI), Data Science, Design for Six Sigma, Database Design, ScrumStorage
JSON, Amazon S3 (AWS S3), SQL Server Integration Services (SSIS), Exacttarget, TeradataIndustry Expertise
Project ManagementOther
R Programming, Data Analytics, Process Design, Product Management, Data Analysis, Data Engineering, Growth Management, Lean Development, APIs, Certified Scrum Product Owner (CSPO), Machine Learning, Artificial Intelligence (AI)Frameworks
RStudio Shiny, SparkPlatforms
SharePoint
Education
- Master's Degree in Information Management2011 - 2014University of Economics - Prague
- Bachelor's Degree in International Area Studies2008 - 2011Charles University - Prague
Certifications
- Six Sigma Green Belt CertificationOCTOBER 2015 - PRESENTeBay, Inc.
- Certified Scrum Product OwnerJULY 2015 - JULY 2017Scrum Alliance
