
Over 6 years of professional experience in analytics.
MSc Business Analytics,
MSc Int’l Business & Management,
BSc Economics.
Dual nationality, Greek American.
Skype: live:bill.kapatsoulias
Summary
Business oriented data scientist with experience in fast and highly dynamic environments. Experienced in consulting and hands-on implementation for analytics projects. Extensive data science coding for professional, university, and personal projects.
Currently a project manager and consultant for three products in my 5th year at ESW Capital, working with large clients in North America and the UK. Simultaneously, active as a sports analytics blogger, tool developer, and data scientist.
Technical Skills
Software: RStudio, PySpark, Tableau, QuickSight, Domo, MS Office, GSuite, Jira, NVivo, SPSS, Pentaho, OpenRefine, WEKA, SAS, Spotfire, and more.
Databases: MySQL, Microsoft SQL Server, MongoDB, Neo4j, Cassandra, and more.
Programming languages: Expert in R, advanced knowledge of Python, SQL; exposure to Java, Scala, CQL, C, Groovy, and more.
Web Analytics: Google Analytics, Google My Business Insights, Facebook/Instagram Analytics.
Profile & Competencies
- Data science expertise, business mindset
- Excellent use of analytics tools
- Experience across different industries and roles
- Energetic, motivated, agile, and flexible
- Creative problem solver
- Cooperative and interpersonal
Relevant Published Content
Professional Experience
(2020, Dec – Present): Founder/Data Scientist
at Sweep Sports Analytics
- Over 100 published visually-enriched articles and blog posts in 7 months.
- Creating publicly available written and video tutorials for sports analytics.
- Developed and distributing a predictive team planning tool for NBA, Premier League, and other fantasy sports.
- Achievements:
- Thousands of followers and subscribers on website and social media.
- Messages of appreciation from students and analytics enthusiasts.
- Tools: RStudio, PySpark, Spyder, MS Excel, MySQL, AWS Console, QuickSight, Bash.
(2017, Mar – Present): ESW Capital Group, Remote
(2021, Oct – Present): Project Manager & Services Consultant
at Aurea Software (ESW Capital)
- Implementing agile method of project management.
- Developing dashboards to assist client decision making.
- Achievements:
- Took over a red status large project and delivered within timeline.
- Designed scalable ready-to-market product applications.
- Products: Placeable, MyAlerts, SLI.
- Clients (indicative): Canadian Imperial Bank of Commerce, Western Union, JCPenney.
- Tools: RStudio, Bash, GSuite, MS Office, Tableau, QuickSight, Domo, Jira, Confluence.
(2020, Oct – 2021, Sep): Professional Services Consultant
at Avolin (ESW Capital)
- Leading and implementing project plans for location marketing.
- Project designer for retail business operations software.
- Developed email marketing reporting dashboards.
- Achievements: Decreased reporting costs by 60%.
- Products: Placeable, Prologic, MyAlerts.
- Clients (indicative): Western Union, Wingstop, Home Depot, Liverpool FC, and more.
- Tools: RStudio, Bash, GSuite, MS Office, Tableau, QuickSight, Domo, Jira, Confluence.
(2017, Sep – 2020, Sep): Analytical Services Consultant
at Ignite Technologies (ESW Capital)
- Led and implemented project plans as a manager and consultant.
- Managed a team of 8 analysts for SEO and location management of over 100,000 locations.
- Designed processes to enhance marketing mix optimization models.
- Developed activity-based time models and generated financial reports, delivering a full-year Activity-Based Costing project.
- Audited media intelligence software reports.
- Achievements:
- Maintained 100% client retention rate for 2 yearly renewal periods
- Contributed to multimillion-dollar savings for clients.
- Quarterly recognition for adaptability and client services during COVID-19 outbreak.
- Products: Acorn, Placeable, ThinkVine, Sococo, Synoptos, FirstRain.
- Clients (indicative): Johnson & Johnson LATAM, Western Union, IBM, Wingstop, Sherwin-Williams, Senate Appropriations.
- Tools: RStudio, SQL Server, GSuite, MS Office, Tableau, QuickSight, Jira, Confluence.
(2017, Mar – 2017, Sep): Marketing Analytics Specialist
at Ignite Technologies (ESW Capital)
- Marketing mix optimization modeling for monthly and yearly marketing plans.
- Lead analyst for cadence and ad hoc reports on marketing budgets of up to $30MM/year.
- Enhanced modeling parameters and forecasting ability, achieving 99% yearly forecasting accuracy.
- Achievements: Promoted in 6 months.
- Product: ThinkVine.
- Clients (indicative): Urban Outfitters, Anthropologie, Disney, US Bank, Cleveland Indians.
- Tools: RStudio, Databricks, GSuite, MS Office, Jira, Zendesk.
(2016, Sep – 2017, Mar): Business Analyst
at Korn Ferry Hay Group, Athens, Greece
- Consulting and compensation tools development
- Developed spreadsheet tools to assist in defining salary structure strategies and incentive scheme scenarios.
- Conducted multivariate analyses based on survey and market data, from regressions to clustering, to rank salary effectiveness, pinpoint key success factors, and identify areas for improvement in HR.
- Achievements: 2-times quarterly recognition.
- Clients (indicative): Agrokor, Alpha Bank, Piraeus Bank.
- Tools: RStudio, PySpark, Excel, PowerPoint, Tableau.
(2015, Sep – 2016, Sep): Data Analyst
at Krataion Consulting, Athens, Greece
- Developed scripts for visualization and descriptive/predictive analysis.
- Database management for a large NGO initiative on youth employment.
- Achievements: Greek HR Awards 2016, Gold for Most Innovative Use of Technology in HR.
- Clients (indicative): Google, World Economic Forum, The Coca-Cola Company.
- Tools: RStudio, MS Office, GSuite, Tableau
(2015, May – 2015, Aug): Market Analyst Intern
at Nestlé, Athens, Greece
- Developed an automated reporting system for business development.
- Conducted data mining and statistical analyses based on sales, budgets, and marketing expenses.
- Tools: Excel, PowerPoint, PowerPivot, Access
(2013, Dec – 2014, Aug): Insurance Advisor
at ING, Athens, Greece
- Provided broking and administrative services to clients; processed renewals and pre-renewal activity.
Education
(2015 – 2018): MSc Business Analytics
at Athens University of Economics and Business
GPA: 8.4/10
Thesis: Model-based clustering with clickstream data
Key Projects: Machine Learning, Mining Big Datasets, Large Scale Optimization
(2014 – 2015): MSc International Business and Management
at Alba Graduate Business School, The American College of Greece
GPA: 3.59/4 – Honors
Field Consulting Project: Employer Branding of Nestlé Hellas, Human Resources Department
(2008 – 2014): BSc Economics
at National and Kapodistrian University of Athens
Personal Interests
- Martial Arts: blue belt in Brazilian Jiu Jitsu; former member of the Hellenic Aikido Foundation and the Hellenic Judo Federation, taking part in international and national seminars and competitions, with distinctions.
- Fantasy sports: using data models for NBA, EURO, Champions League, and Premier League analyses, consistently finishing within top 7% globally in fantasy leagues.
- Sports: Played various sports since childhood (Futsal – Top Greek Division, Football/Soccer, Basketball, Swimming, Basketball).
- Music: Former lead guitarist/singer for rock bands, performing in concerts, having signed with an international label.