Patrick Mcdermott Email and Phone Number
Patrick Mcdermott work email
- Valid
- Valid
Patrick Mcdermott personal email
Patrick Mcdermott phone numbers
I am a senior SQL Server/SQL Azure data warehouse developer, Data Vault 2.0 developer, experienced Wherescape RED and Wherescape 3D professional, SQL Server Integration Services developer, and BI developer, with extensive domain experience in several areas. I can build analytical enterprise data warehouses for mission critical applications with data modeling and automation of the data load. I can organize major projects into a manageable plan and can develop the full range of data systems from integration to storage to analysis. I have excellent written and oral communications and presentation skills. I am a team player with many years of experience managing development and support teams.Mastered Technologies: SQL Server 2019, T-SQL, Enterprise Data Warehouse, Data Vault 2,0 (certified), WhereScape RED, WhereScape 3D, Dimensional Modeling (Kimball method), SQL Server Integration Services (SSIS), ETL, BIML, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS-Tabular), SQL Server Machine Learning, Azure SQL Database, Power BI, C#, PowerShell, Visual Studio, Team Foundation Server, Agile Development, Cloud Platform.
-
Senior Edw ConsultantThe Data Vault Shop Mar 2021 - PresentI 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.
-
Enterprise Data Warehouse Architect (Manager-Edw)Central California Alliance For Health Aug 2017 - Mar 2021Santa Cruz, CaliforniaResponsible 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. -
Senior Data Warehouse And Bi ArchitectSeattle University Jun 2015 - Aug 2017Seattle, WaArchitected 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. -
Co-Founder And Director Of Learning Systems (Data Systems)Metria Jul 2011 - May 2015Bellevue, WashingtonCo-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.
-
Director Of Product Management (Sql Server)Indigo Slate Apr 2010 - May 2015Bellevue, WashingtonDatabase 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. -
It Director And Data Systems ManagerSan Juan School District Aug 1997 - Apr 2010Southeastern UtahDesigned 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. -
European Distribution ManagerHill Europa, Ag Aug 1993 - Jan 1996Luxembourg And GermanyManaged European operations for a small automotive aftermarket wholesaler based in Luxembourg and serving northern Europe.
-
Tank Officer (Top Secret Clearance)Us Army Sep 1985 - Sep 1989Korea And GermanyTank platoon leader on Korea's De-Militarized Zone and tank battalion maintenance officer in Germany.
Patrick Mcdermott Skills
Patrick Mcdermott Education Details
-
International Relations -
Universität TübingenInternational Relations -
Colorado Rocky Mountain School
Frequently Asked Questions about Patrick Mcdermott
What company does Patrick Mcdermott work for?
Patrick Mcdermott works for The Data Vault Shop
What is Patrick Mcdermott's role at the current company?
Patrick Mcdermott's current role is Senior EDW Consultant at the Data Vault Shop.
What is Patrick Mcdermott's email address?
Patrick Mcdermott's email address is pa****@****ing.org
What is Patrick Mcdermott's direct phone number?
Patrick Mcdermott's direct phone number is +142561*****
What schools did Patrick Mcdermott attend?
Patrick Mcdermott attended University Of Utah S.j. Quinney College Of Law, Georgetown University, Universität Tübingen, Colorado Rocky Mountain School.
What are some of Patrick Mcdermott's interests?
Patrick Mcdermott has interest in K 12 Education.
What skills is Patrick Mcdermott known for?
Patrick Mcdermott has skills like Microsoft Sql Server, C#, Start Ups, Cloud Computing, Software Development, Saas, Visual Studio, Integration, Business Intelligence, .net, Sql Azure, Technology Product Development.
Not the Patrick Mcdermott you were looking for?
-
Patrick McDermott
Los Angeles Metropolitan Area -
Patrick McDermott
Denver, Co -
4loringward.com, gmail.com, kstonepartners.com, segalrc.com1 +121225XXXXX
-
Patrick McDermott
International Advancement | Politics | Strategic Partnerships | EducationPhoenix, Az4dcu.ie, thunderbird.edu, thunderbird.asu, asufoundation.org -
1pointsbet.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial