Christopher Stookey Email & Phone Number

Greater Minneapolis-St. Paul Area

Data Architecture Research• Analyzed the Experimentation applications and the customer experiment data to create conceptual, logical, and physical data models• Documented the data flow between the Experimentation databases• Conducted data profiling on Experimentation transactional databases to document actively used tables/columns, valid values, and embedded JSON data structures• Analyzed application logs to identify data-related performance bottlenecksData Analysis• Conducted in-depth investigations into customer experiment data, results, and statistics questions using BigQuery• Coached customer support engineers on best practices for Snowflake SQL and provided model SQL queries for customer experiment data• Worked closely with the Principal Statistician to provide statistical guidance for customers• Created detailed documentation and explainers on the experiment results and statistics calculationsProject Leadership• Analyzed and documented architecture impact for Experimentation Analytics epics• Composed stories for the Experimentation and Analytics epics and led the grooming and refinement sessions

Greater Minneapolis-St. Paul Area

• Developed data solutions architecture for Wells Fargo Mortgage Servicing.• Designed and oversaw the design of the WFHL Common Model, the canonical data model for data in flight.• Designed the data models, XML schemas database table design, and/or data mapping for industry-wide projects such as TILA/RESPA Evidence of Compliance, Uniform Closing Dataset, and HMDA expansion.• Oversaw the data modeling and schema design for the next-generation Home Mortgage customer service application.• Rewrote the code to generate XML schemas from PowerDesigner data models, resulting in 4x faster performance and simpler code maintenance.• Developed the capability to generate JSON schemas and OpenAPI specifications from PowerDesigner data models to support the company's transition to microservice architecture.• Acted as primary Wells Fargo Technology liaison to MISMO, the mortgage industry standards body. Held leadership roles such as chair of the API Community of Practice and co-chair of the Architecture Workgroup.• Developed the canonical MISMO-based data model with Wells Fargo extensions and the accompanying JSON schema.• Acted as team leader, especially during an 8-month period where the team had no direct manager.• Helped guide the team through a transition to using Kanban methodology.• Was selected as one of 25 participants for the 2021 Everyday Leader program. Completed the program and was selected as a program advisor for 2022.

Greater Minneapolis-St. Paul Area

• Developed conceptual data architectures for the Wachovia data archive and retention strategy as well as other Home Mortgage efforts.• Designed the data model for the Vendor Product Services database, which enabled automated ordering of vendor products such as appraisals, flood determinations, verification of income, etc.• Designed the data model for the Settlement Agent Management database, which enabled automated settlement agent selection and funds and documents delivery.• Supported the data model for the Capital Markets Operational Data Store. Refactored the model to overcome limitations in the modeling tool due to the model's size.

Greater Minneapolis-St. Paul Area

• Acted as assistant business lead for the HCFG Customer Management Platform (CMP) project. Collected • and documented business data requirements for the project across approximately 25 source systems.and participated in the development of the conceptual data model.• Served as a business project lead for the CORE Data Integration project. Mapped official Home Lending data warehouse and data mart data elements to their CORE equivalents. Reviewed and directed the work of other data analysts. Developed processes to streamline the work and deliver the project requirements on time. Developed business implementation and contingency plans for Marketing’s use of CORE data within the various Marketing business intelligence environments. • Responsible for updating and improving business metadata for all data used by WFHM Marketing and Customer Insights and Analytics (CIA). Developed business names and definitions for source elements, mapped elements to the Enterprise Metadata Repository, and documented usage and transformation rules.

Greater Minneapolis-St. Paul Area

• Acted as data design technical lead for Home Mortgage business intelligence projects.• Designed the logical and physical data models for the Integrated Mortgage Information Platform (iMIP). Worked with the Home Mortgage data architect to develop HCFG data strategy recommendations for iMIP and the Central Online Data and Analytics (CODA) data mart. Continued to maintain and expand CODA.• Facilitated the PowerDesigner Standards Committee. This committee was responsible for developing standard practices for data modeling and database administration using the PowerDesigner tool across Lending Information.• Acted as technical consultant for the National Consumer Lending (NCL) data mart. Designed the dimensional data model for the Fulfillment Services Dashboard, a precursor to NCL. Performed data sourcing and developed ETL routines.• Designed data models for Retail applications, including: Version 3.0 of the Profiler FTE tracking system; the Subordination Portal; a work integration and tracking system; and a data process automation system.Gave guidance and direction regarding data design to other team members.• Acted as technical resource and business data expert on the Charter Consolidation and Charter Phase 2 (Revenue Management) projects.

Greater Minneapolis-St. Paul Area

• Managed a team of application engineers and database analysts. Gave guidance and direction on application and database design to staff. Directed work and prioritized work requests. Acted as project manager for team projects.• Oversaw the addition of several subject areas into CODA, including MCI call data, Repartee data, additional loan fields.• Developed business requirements and functional specifications for several WFHM Retail applications, including version 2.5 of the Profiler FTE tracking system, Campaign Management System 3.0, and Call Routing Manager 2.0.

Greater Minneapolis-St. Paul Area

• Designed and developed the first release of the CODA data mart. Designed data models, data cleansing rules, and integration rules for Retail call, loan, and forecast volume. Developed ETL routines for loading the source data. Led the implementation of CODA on the SQL Server platform.• Developed complex metrics and reports for CODA customers, including vintage reporting, scorecards, and forecast accuracy reporting.• Gave guidance on report design and the SQL language for departmental staff.• Developed a forecast engine based on the pioneering forecasting methodology for Mortgage call and loan volume. Produced weekly, monthly, and annual forecasts for management, Finance, Capacity Planning, and Marketing.• Designed and developed several applications for the Centralized Retail organization, including an incentive tracking, call routing plan tracking, and marketing campaign management.• Developed business rules for reporting call volume in order to take into account complex routing plans that could deliver calls to a phone agent multiple times.

• Developed a pioneering forecasting methodology for Mortgage call and loan volume that isolated and quantified the principal drivers of the business.• Produced weekly, monthly, and annual forecasts for management, Finance, Capacity Planning, and Marketing.

Bachelor Of Music, Music Composition

Activities and Societies: Phi Beta Kappa, Phi Mu Alpha Sinfonia

Doctoral Work (No Degree), Music Composition