Patrick McDermott
Senior EDW Consultant at The Data Vault Shop- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
German Professional working proficiency
-
French Limited working proficiency
-
Bokmål, Norwegian Elementary proficiency
Topline Score
Bio
Credentials
-
Certified Data Vault 2.0 Practitioner
Dan Linstedt, LearnDataVault.comDec, 2017- Nov, 2024
Experience
-
The Data Vault Shop
-
United States
-
Software Development
-
1 - 100 Employee
-
Senior EDW Consultant
-
Mar 2021 - Present
I help organizations build data warehouses, specializing in Data Vault 2.0 methodology and working primarily with Wherescape 3D and Wherescape RED for design of the data model and automation of the data load. I help organizations build data warehouses, specializing in Data Vault 2.0 methodology and working primarily with Wherescape 3D and Wherescape RED for design of the data model and automation of the data load.
-
-
-
Central California Alliance for Health
-
United States
-
Hospitals and Health Care
-
300 - 400 Employee
-
Enterprise Data Warehouse Architect (Manager-EDW)
-
Aug 2017 - Mar 2021
Responsible for the full cycle corporate enterprise data warehouse including maintenance and support of software applications and database systems. Architect and design Data Vault 2.0 objects, ODS, ETL applications, reporting cubes and dimensional modeling. Lead software development projects, new feature implementations, architecture analysis and testing. Design data mart and create reporting templates and reporting and BI architecture. Manage team of 4 EDW developers through all aspects of software development life-cycle. Show less
-
-
-
Seattle University
-
United States
-
Higher Education
-
700 & Above Employee
-
Senior Data Warehouse and BI Architect
-
Jun 2015 - Aug 2017
Architected and built new enterprise data warehouse with SQL Server 2016. Developed and maintained data integration systems with SQL Server Integration Services and Wherescape Red. Built out SalesForce integration. Integrating transactional data into the data warehouse. Used new BI Mark-up Language (BIML) tools to develop metadata-driven integration. Designed and built analytical and reporting tools with SSRS, Power BI, SSAS, and R. Worked with departmental business leaders at the university to help deliver data-driven management techniques. Show less
-
-
-
Metria
-
Bellevue, Washington
-
Co-Founder and Director of Learning Systems (Data Systems)
-
Jul 2011 - May 2015
Co-Founded and grew entrepreneurial startup business through customer development and sales. Designed and developed SQL Server/SQL Azure Cloud-based data infrastructure for new data-centric product. Analyzed business requirements and domain best practices to develop product and corresponding database design relevant to customer and business needs. Led team to innovate how data is used to bring organizational change to our clients. Co-Founded and grew entrepreneurial startup business through customer development and sales. Designed and developed SQL Server/SQL Azure Cloud-based data infrastructure for new data-centric product. Analyzed business requirements and domain best practices to develop product and corresponding database design relevant to customer and business needs. Led team to innovate how data is used to bring organizational change to our clients.
-
-
-
Indigo Slate
-
United States
-
Advertising Services
-
100 - 200 Employee
-
Director of Product Management (SQL Server)
-
Apr 2010 - May 2015
Database and BI development for Microsoft (various teams, including Office 365/Power BI and Windows Server team’s BI portal built on SQL Server Reporting Services). Worked on various SQL Server projects including database performance measurement, BI, and SSIS/SSRS applications, wrote whitepapers and training materials on SQL Server for Microsoft. Led development team of 10 full-time developers and project personnel utilizing agile development methodologies and customer-centric product development. Managed globally distributed development resources and offshore engineering efforts with extensive offshore work experience in India. Show less
-
-
-
San Juan School District
-
Education Administration Programs
-
100 - 200 Employee
-
IT Director and Data Systems Manager
-
Aug 1997 - Apr 2010
Designed and developed an enterprise data system using SQL Server for managing student achievement, enrollment, teacher effectiveness, and data relating to other critical business needs. Developed multiple data extraction, transformation, and load (ETL) packages using SQL Server Integration Services for integrating data from over 15 different systems and sources into our enterprise data warehouse. Managed geographical data assets and mapping with ArcGIS and integrated geographical data from many sources. Led a team of 11 IT professionals and organized efforts to better support the data and operational needs of 12 schools, serving 3,000 students. Show less
-
-
-
Hill Europa, AG
-
Luxembourg and Germany
-
European Distribution Manager
-
Aug 1993 - Jan 1996
Managed European operations for a small automotive aftermarket wholesaler based in Luxembourg and serving northern Europe. Managed European operations for a small automotive aftermarket wholesaler based in Luxembourg and serving northern Europe.
-
-
-
US Army
-
United States
-
Armed Forces
-
700 & Above Employee
-
Tank Officer (Top Secret Clearance)
-
Sep 1985 - Sep 1989
Tank platoon leader on Korea's De-Militarized Zone and tank battalion maintenance officer in Germany. Tank platoon leader on Korea's De-Militarized Zone and tank battalion maintenance officer in Germany.
-
-
Education
-
1990 - 1993
University of Utah S.J. Quinney College of Law
Juris Doctoris, Law -
1981 - 1985
Georgetown University
BA, International Relations -
1983 - 1984
Universität Tübingen
Year Abroad, Germany, International Relations -
1979 - 1981
Colorado Rocky Mountain School
