Craig Patnode Email & Phone Number

• Participated in the KPWA EDW Architecture team by proposing standards, providing prescriptive guidance and performing proof of concepts to increase the consistency and efficiency of development in the EDW organization.
• Implemented backward compatibility process for EDW to help control impact to end users.
• Contributed as the technical lead for a team of 4-5 people driving the EDW solution with high data quality while being accountable for following EDW Architecture standards.
• Gathered requirements and performed story sizing/complexity to enable project managers with estimating project delivery dates.
• Developed code and unit tested to ensure business requirements were met. Performed peer code reviews to simplify maintenance and ensure EDW Architecture standards were met.
• Coordinated cross team migrations for conformed dimensions and many versions of multiple solutions to production.

Greater Seattle Area

Modified DAX and MDX Queries to meet the latest requirements.Help migrate an enterprise solution from Test to Production.Provided daily production support monitoring and notification.

Greater Seattle Area

As a consultant for PAML, defined Business Intelligence datamart scope, hosted business requirements gathering workshops, created business requirements document and created functional specifications document.

• Cross-functional team project manager working with business owners, development, test, onboarding team, user support and production support.
• Created, maintained, and communicated project documents and status reports following internal standards.
• Created Integration functional design to support Onboarding Applications with a custom solution in the MDM Privacy platform. Performed data analysis across multiple systems in a large ecosystem of applications.
• Created Reporting functional design to support business users consuming MDM Privacy data. Activities involved gathering business requirements and identifying business need for our project to implement an off-the-shelf.
• Created Database functional design to support an internal solution for a highly available and highly scalable solution using Webstore in the MDM Privacy platform. Activities involved understanding the business.
• Assisted in Disaster Recovery functional design in the MDM Privacy platform. Activities included driving business requirements of acceptable data loss and service availability for the platform, understanding points of.

• Procured 4 external vendors and managed the delivery of a custom solution used world-wide by almost 10,000 users.
• Created Account Management functional design to assign Segmentation taxonomy and Sales Geography Hierarchy to Microsoft customers and integrate this data into downstream systems that published as a part of Reference.
• Assisted in integration development using SQL Server Integration Services (SSIS). Provided code reviews with external vendors and established best practices.
• Tested and approved ACE application to ensure all business features worked properly. Helped with User Acceptance Testing and validation with Solution Delivery team.
• Deployed the ACE application into production and assisted in support.

• Performed Meta-Data Modeling for Reference/Domain Data.
• Tested, reviewed, released and communicated Logical Data Model using Erwin, PDF and Excel.
• Developed and tested Logical Data Model for Microsoft Consulting Services and Customer Support Services.
• Performed engagement management, provided architecture guidance and data mapping for systems implementing the Logical Data Model.

• Integrated Invoicing data to Microsoft’s SAP billing system using MS SQL Server 2000.
• Developed and tested multi-subsidiary invoice printing using C#.
• Modified and tested ETL integration using C#.

• Assisted in development the Broker Management Center (BMC) application using Visual Basic middle-tier components including presentation layer and business layer.
• Tested the Broker Management Center (BMC) application including Netscape, SOAP interfaces, presentation layer, business logical layer and data access layer using SQL Server 2000Integrated Invoicing data to Microsoft’s.

B.S., Computer Science

High School Diploma