Tom Welgemoed, Data Warehouse Design Developer in Baarn, Netherlands
Tom Welgemoed

Data Warehouse Design Developer in Baarn, Netherlands

Member since October 1, 2020
Tom has been a data architect and visualization expert for 15 years, eight of which he spent working for Accenture, a Big 5 consultancy. His passion is to use data to help improve the way organizations perform, whether that be through coaching, consulting, or delivering the solution myself. Tom has a variety of skills that include data modeling, architecture, visualization, and team leadership.
Tom is now available for hire

Portfolio

  • Abn Amro
    Azure, Data Architecture, Solution Design
  • APG
    Qlik Sense, Alteryx
  • Philips
    Data Management, Team Mentoring, Database Modeling, Data Architecture...

Experience

Location

Baarn, Netherlands

Availability

Part-time

Preferred Environment

Snowflake, Microsoft Power BI, Database Modeling, Data Visualization, Database Design, SQL, Microsoft SQL Server, Qlik Sense, Alteryx

The most amazing...

...project I've worked on was to create a real-time sports analytics dashboard that could predict real-time win probability and evaluate player performance.

Employment

  • Data Solution Architect

    2021 - PRESENT
    Abn Amro
    • Created a data architecture roadmap to highlight the journey to a cloud-based platform and process.
    • Supported the creation of a future state architecture for all applications.
    • Built the solution design for a single customer view project.
    Technologies: Azure, Data Architecture, Solution Design
  • DevOps Specialist

    2021 - 2021
    APG
    • Developed a front-end dashboard to help track taxes due globally for APG.
    • Fostered a user community around Alteryx, hosting various workshops and community meetings and uploading content onto the SharePoint site.
    • Consulted projects as an Alteryx SME to ensure accurate delivery and success.
    Technologies: Qlik Sense, Alteryx
  • Data Architect and Visualization Expert

    2019 - 2021
    Philips
    • Developed a Qlik Sense dashboard that monitors and projects inventory volumes across all B2B products for the forthcoming year.
    • Created a data model in Microsoft Azure to support end-to-end sales and order management monitoring and performance tracking to ensure a better customer experience and revenue recognition.
    • Designed a dashboard in Qlik Sense to enable order management teams to easily identify priority order issues and root causes to expedite resolution and on-time delivery.
    • Led projects technically and directed the efforts of other developers to deliver the target architecture.
    • Liaised with senior stakeholders and represented the project at the steering committee level.
    Technologies: Data Management, Team Mentoring, Database Modeling, Data Architecture, Data Visualization, SQL, Qlik Sense, Azure Synapse
  • Data Visualization Team Lead

    2017 - 2019
    Accenture
    • Set up, led, and grew the data visualization team in the Netherlands by 100%. Effectively held responsibility for career coaching, role placement, and hitting key performance KPIs.
    • Led the technical team and data delivery aspects of a multi-year, multi-million pound B2B UK telecoms data warehouse and KPI reporting capability. Technologies included Netezza, Alteryx, Qlik Sense, and Informatica.
    • Designed very successful data and ETL architecture for a large data migration project using Alteryx and Microsoft technologies. The resulting solution saved approximately 50-75% in resource cost.
    • Built a KPI dashboard for a large hospitality-based firm based in the Netherlands. Created the solution in Qlik Sense in only one to two weeks.
    Technologies: Coaching, Stakeholder Management, Data Architecture, Project Management, Qlik Sense, Alteryx, Technical Leadership, Team Leadership, Data Vizualisation
  • Data Visualization Manager and Consultant

    2011 - 2017
    Accenture UKI
    • Led one of the most inventive projects for real-time sports analytics. Blended data ingestion, visualization in near real-time, storytelling, cloud hosting, predictive analytics, and feeding unique performance insights to over 1 million mobile users.
    • Designed, technically led, and built a complex B2B telecoms solution for a large B2B client to unify the customer journey. Delivered a single customer view that is the cornerstone of the client's analytics framework.
    • Spoke at various public engagements regarding solutions built, including the Alteryx conference, Twickenham rugby stadium, and multiple clients such as Vodafone, Virgin Media, and RBS.
    Technologies: Consulting, ETL, Database Management, Microsoft SQL Server, Alteryx, Qlik Sense
  • Business Intelligence Team Lead

    2009 - 2011
    Talk Talk
    • Led a team of 15 onshore and offshore developers to meet all our clients' reporting needs.
    • Delivered a major data migration project that would save the company 500,000 per month once delivered.
    • Created a new telco data warehouse that included customer base and movements reporting, call data record (CDR) reporting, and aged debt reporting.
    • Saved the company 18 million GBP (in regulatory fines) by creating a report that would help ensure the company did not wrongfully bill customers who indicated they wanted to disconnect.
    Technologies: Data Migration, Business Intelligence (BI), SQL, Database Modeling, Informatica, ETL, Team Leadership
  • Data Warehouse Architect and BI Expert

    2006 - 2009
    Carphone Warehouse
    • Designed and evolved the data warehouse globally for the Carphone Warehouse as one of six data architects.
    • Delivered a complex, cross-European customer and address matching solution. This single customer view enabled improved customer management and targeting (marketing) opportunities.
    • Coached and led a team of four external partner developers to grow the existing platform.
    Technologies: Team Leadership, Data Modeling, Informatica, Data Warehouse Design, Data Warehousing, Trillium, Oracle, Netezza

Experience

  • Real-time Sports Analytics
    http://www.guruinabottle.com/accenture-leverage-rbs-six-nations-sponsorship-by-showcasing-technology

    I created, designed, and led the RBS 6 Nations program's analytics delivery as part of the Accenture Technology sponsorship between 2013-2017. Our end product was a real-time dashboard shown exclusively to clients in our hospitality suite on match days. We also created a mobile app data feed viewed by more than 1 million global users on match days. My role was to innovate with the available data and then design, build, and lead the effort to bring the innovations to life for clients.

Skills

  • Tools

    Qlik Sense, Microsoft Power BI, Tableau
  • Paradigms

    ETL, Business Intelligence (BI), Database Design, Object-oriented Programming (OOP), Agile
  • Platforms

    Alteryx, QlikView, Oracle, Amazon Web Services (AWS), Azure
  • Storage

    Database Modeling, Microsoft SQL Server, Database Management, Netezza
  • Other

    Data Visualization, Data Architecture, Data Management, Data Profiling, Consulting, Data Warehouse Design, Data Engineering, Azure Synapse, Team Mentoring, Geospatial Analytics, Team Leadership, Technical Leadership, Stakeholder Management, Coaching, Economics, Econometrics, System Design, Decision Support Systems, Decision Analysis, Scrum Master, AWS, Informatica, Data Migration, Trillium, Data Warehousing, Data Modeling, Cloud Computing, Designing for Data, Solution Design
  • Languages

    SQL, Snowflake
  • Industry Expertise

    Project Management, Banking & Finance

Education

  • Bachelor's Degree in Information Technology and Economics
    1998 - 2002
    North West University - South Africa

Certifications

  • Microsoft Azure Data Engineer
    FEBRUARY 2021 - FEBRUARY 2023
    Microsoft
  • Alteryx Core Designer
    NOVEMBER 2020 - NOVEMBER 2022
    Alteryx
  • Qlik Sense Business Analyst
    OCTOBER 2019 - PRESENT
    Qlik
  • Alteryx Advanced
    OCTOBER 2018 - OCTOBER 2020
    Alteryx
  • Agile Scrum Master
    JUNE 2009 - PRESENT
    Scrum Alliance

To view more profiles

Join Toptal
Share it with others