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

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.

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.
• 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.

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.
• 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.
• 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.
• 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.
• 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.
• 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