Bill Kapatsoulias

Over 6 years of professional experience in analytics.
MSc Business Analytics,
MSc Int’l Business & Management,
BSc Economics.
Dual nationality, Greek American.

9, Kanari St, Maroussi, Greece b.kapatsoulias@gmail.com

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.

Leave a Reply