Michael O Toole

Senior Data Architect at Alvin
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Berlin, Berlin, Germany, DE

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • Estonia
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Senior Data Architect
      • Mar 2023 - Present

      - Build data lineage SaaS serving large client’s DWHs at scale - Redesign data loading and storage processes for performance and cost - Migrating of infrastructure from AWS to GCP - Support integrations: Snowflake/Biqquery/Looker etc - Fundamental redesign of Graph service and GraphDb for relational queries - Microservice architecture redesign - Distributed partitioned elastically scalable DWH design for efficiency with multiple client with variable scale concerns -… Show more - Build data lineage SaaS serving large client’s DWHs at scale - Redesign data loading and storage processes for performance and cost - Migrating of infrastructure from AWS to GCP - Support integrations: Snowflake/Biqquery/Looker etc - Fundamental redesign of Graph service and GraphDb for relational queries - Microservice architecture redesign - Distributed partitioned elastically scalable DWH design for efficiency with multiple client with variable scale concerns - DuckDb, Kuzu, Elastic scaling - Data contract and gRPC design for microservices and datamesh - Design of VirtualDWH with SQL parsing for CI/CD etc - Postgres/Redshift/Snowflake protocol/driver implementation - Relational integrity checking - CI/CD for distributed system - Across gRCP - Mutli-language: python, kotlin, js rust etc. Show less

    • Ireland
    • Technology, Information and Internet
    • Co-Founder
      • Feb 2019 - Present

      Dublin, County Dublin, Ireland

    • Freelance BI Consultant
      • Aug 2017 - Present

      County Dublin, Ireland Taking projects in Germany, Sweden, Ireland and UK. Data Engineering and Data Warehousing Design - Cost:Scale and Scalability Focused - Data design and Architecture - Specialising in Datawarehouse Set-up and Junior BI training - Start-Up and Enterprise Solutions - Budget Vs Scaling solution. Modular replaceable infrastructure designed for scale appropriate cost with design for industry standard solutions - Hiring and training of Junior Analysts for in-house reporting -… Show more Taking projects in Germany, Sweden, Ireland and UK. Data Engineering and Data Warehousing Design - Cost:Scale and Scalability Focused - Data design and Architecture - Specialising in Datawarehouse Set-up and Junior BI training - Start-Up and Enterprise Solutions - Budget Vs Scaling solution. Modular replaceable infrastructure designed for scale appropriate cost with design for industry standard solutions - Hiring and training of Junior Analysts for in-house reporting - TV and offline advertising tracking - Data-first company and technology advice --- Full stack and Dev ops (board selection of programming architectures) --- Operational Automation and Data integration (data normalisation for complex operational processes) - Flexi Consulting and 24/7 365 on call maintenance. Technical Skills - Redshift, BigQuery, Postgres & Hadoop etc - NodeJs, GoLang, ReactJS, PlotlyJS, ReCharts, Java, Scala, Python - AWS, GoogleCloud, Microsoft Azure - Plotly, D3, Power BI, Looker, Tableau etc. - Salesforce, Google Suite [GTM, GA, GAW, Drive & Sheets APIs etc], Facebook Marketing - All APIs - Snowplow, Adjust, Google Analytics , GTM, Pivik etc - Management and Integration softwares: GIT, JIRA - Data Protection and Governance theory and legislation - Operational, Finical and Marketing Automation Software Development Show less

    • Sweden
    • Hospitals and Health Care
    • 300 - 400 Employee
    • Senior Data Warehouse Architect
      • Sep 2020 - Oct 2023

      Berlin, Germany Responsible for design and maintenance of Enterprise DWH include Kimball modelling and pipeline infrastructure. Designing scalable solutions for international team working with complex business and medical data concerns. - Managing Enterprise Migration from AWS Redshift to Snowflake - Data Security and Access Management system design - Executing DWH mergers for acquired companies - Modeling & Data governance - Data security and data protection in the context of Medical data -… Show more Responsible for design and maintenance of Enterprise DWH include Kimball modelling and pipeline infrastructure. Designing scalable solutions for international team working with complex business and medical data concerns. - Managing Enterprise Migration from AWS Redshift to Snowflake - Data Security and Access Management system design - Executing DWH mergers for acquired companies - Modeling & Data governance - Data security and data protection in the context of Medical data - Training & Recruiting for an area of 60+ Analysts, Engineers and ML specialists Show less

    • Germany
    • Technology, Information and Internet
    • 1 - 100 Employee
    • Head of Business Intelligence
      • Mar 2017 - Jun 2019

      Berlin Area, Germany Leading a BI teams in forming a data infrastructure to meet the needs of a rapidly growing Berlin start up. Unifying data to provide meaningful insights to operations, sales and marketing teams. Allowing better workflow and pipeline management for large teams. Designing an in-house event tracking tool to replace Google Analytics, providing event level data in an affordable and scalable fashion. Creating a highly available source of queryable data on which to calculate demand and pricing data… Show more Leading a BI teams in forming a data infrastructure to meet the needs of a rapidly growing Berlin start up. Unifying data to provide meaningful insights to operations, sales and marketing teams. Allowing better workflow and pipeline management for large teams. Designing an in-house event tracking tool to replace Google Analytics, providing event level data in an affordable and scalable fashion. Creating a highly available source of queryable data on which to calculate demand and pricing data, with controlled api endpoints for programatic access. - Data-warehouse Design (Redshift, and AWS) - ETL design with in-house solution (NodeJS Application) - Near Realtime ETL at minimal cost (S3, Data streaming , NodeJS) - Team planning and management ( Scrum and Agile Methods ) - Data integration and unification across a multiplex of source types - Agile Transformation methods and DataWarehouse centred modelling - Continuous data integrity testing - In-house web event tracking with custom design ( AWS-ElasticBeanstalk Collector and onsite-pixel) - Flexible Visualisation and Dash-boarding ( Power-BI, ReactJS Charting, R, gSheets ) - Modular BI infrastructure allowing affordable scaling and easy of product interchange - Web tracking to business logic modelling - Webapp for collection and querying of data - Collecting pricing data Show less

    • Germany
    • E-Learning Providers
    • 1 - 100 Employee
    • Business Intelligence Developer
      • Oct 2016 - Mar 2017

      Berlin Area, Germany - Data-warehouse Design (Redshift, Big Query) - In-house web event tracking Implementation (Snowplow) - Facebook API automation (FB Ads and Organic) - Web Channel Grouping redesign and Company wide UTM tracking tool (Chrome extension) - Reporting UI and Report Automation - Dashboard design - Data Collection Solutions - Chrome Extension and Data Scraping - Cohort Analysis and Multi-Channel Attribution Design - Marketing Automation and Suggestion Tools

    • Business Intelligence
      • Jan 2016 - Mar 2017

      Berlin Area, Germany Data-warehouse Solution design Reporting UI development Report Automation and Realtime Dashboard Design Cohort Analysis and Modelling Business Data Collection and Modularization Chrome Extension and RESTful data collection application development Custom Attribution Modelling

    • Ireland
    • Business Consulting and Services
    • 700 & Above Employee
    • Business Analyst
      • Jul 2015 - Dec 2015

      Eastpoint Dublin Reporting structures and Automation for Accenture's Google client sites (Vendor operations) Data mining for KPI for Operational Management Targets Dashboards and UI creation Lead Reporting best Practices workshops Facilities and people management data structure creation Event Management, German Market Recruiting

Education

  • Trinity College Dublin
    Doctor of Medicine (M.D.), Medicine
    2011 - 2019
  • Trinity College Dublin
    Medicine
    2010 - 2015

Community

You need to have a working account to view this content. Click here to join now