Bob Doucette

adw7a7@r.postjobfree.com ** Hardy Road

mobile: 617-***-**** Swampscott, MA 01907

Executive Profile and Technical Summary

• A creative and seasoned solutions architect and technical manager – with over twenty years experience driving data-focused, strategic business intelligence initiatives within the financial services, banking, brokerage/securities, healthcare, and retail sectors, for multiple Fortune 500 and large institutional clients throughout the U.S. and Europe. Key architect on the successful design and implementation of many complex data warehousing, CRM/ERM, and other database solutions, and related ETL/data migration.

• Expertise in data architecture, systems integration, and hybrid system design (on-prem, cloud-based), data management methodology and best practices (agile scrum and kanban, and other SDLC delivery methodologies), business process analysis and modeling, data analytics, data quality analysis, data governance, data security, and database modeling (relational and dimensional).

• Extensive hands-on development experience in various programming languages (C/C++, Perl, and others) along with complex SQL development and tuning under Teradata, Oracle, DB2, SQL Server, and other relational systems. Vast experience with most major ETL tool suites, with many years of ‘enterprise level’ Informatica installation, administration, design, and development experience. Professional Experience

Affusion, Inc., Philadelphia, PA 5/2014 to 1/2023

Senior Solutions Architect/Senior Technical Manager/Senior Consultant A primary/principal senior solutions architect/technical manager for multiple large, institutional clients on design and delivery of analytics, business intelligence, and reporting systems. Clients include Wells Fargo Bank, Truist Bank, and Aramark (for Boeing). Client engagements detailed below.

• Aramark, Inc., Philadelphia, PA 6/2022 to 1/2023 Solutions Architect/Systems Analyst

Aramark Information Technology, Pricing Group: Enterprise Pricing System Assessment (12/22 to1/23) Personally authored a 40+ page, detailed architectural system design review of an internally grown Aramark pricing system, used to analyze and recommend pricing adjustments across Aramark’s extensive food service and other retail POS systems. Focused the assessment on reducing operational risks. Provided specific recommendations for major system improvements, including system re-platforming (from SQL Server on-prem to a cloud-based Snowflake solution) and substantial changes to the development and testing procedures, while taking into account existing platforms, database technology and licensing constraints, and support staff limitations. Assessment critical to Aramark budget allocation/justification and project forecasting/planning. Solutions Architect/Systems Analyst

Aramark Information Technology, Facilities Management Division: Boeing IFM Project: (6/22 to 12/22) WFE and Performance Metrics Reporting Dashboard

Key architect/analyst on the successful, on-time delivery of phase one of a QLIK-based, performance metrics reporting dashboard, and related backend systems design and data handling, related to a multi-year,

$154MM+/year facilities management engagement for Boeing (initially eight, eventually to be expanded to twenty-five Boeing facilities). Worked extensively with Boeing and Aramark staff in personally detailing, refining, and documenting the performance metrics requirements, critical and key performance indicators, backend data requirements, and clarified and confirmed all metrics calculations and required data elements. Drove the successful delivery of high quality daily comprehensive analytics/metrics to both Boeing and Aramark, positioning the dashboard as a critical tool to assess ongoing Aramark performance relative to specific performance targets and potential penalties, along with assisting on the design of a related web-based front-end

(WFE) to provide Boeing input into Aramark systems for work order creation and tracking. Bob Doucette

Page 2

• Truist Bank, Atlanta, GA 1/2022 to 6/2022

Solutions Architect/Technical Manager: Warranty-Transition Team/Systems Analyst Truist BICP:TERM-MOE7: Transition Management and Delay Impact/Root Cause Assessment Personally directed remedial actions to jump start transition efforts. In 2019, Infosys started a multi-phase, multi-year effort to consolidate 5,000 reports onto a new platform, BICP:TERM, in connection with merger of two banks which created Truist - labeled a “merger of equals” (MOE). In late 2021, Infosys retained Affusion Inc. to perform an independent assessment of root causation and allocation of substantial cost overruns and mounting delivery delays within BICP:TERM-MOE7.

Sole Affusion consultant on the project. Took over day-to-day management of the Infosys operations/Warranty- Transition team. Within this integration work, Infosys remained responsible for daily operation of Infosys work moved into production, pending formal acceptance by Truist. By end of 2021, no Infosys development had transitioned to Truist operations. Immediately implemented operational reporting to assess Infosys development and transition progress. Coordinated with Truist and Infosys staff to define a clear transition process with specific approval criteria. Realigned business process flows for customer testing, approval, and turnover. Engaged technical staff across multiple Infosys, Truist, and vendor technical teams. Personally drove ongoing production incident investigation and detailed technical reviews, in many instances down to reviewing network and system-level packet traces. Generated and presented weekly operational metrics and post-mortem analytic reporting to demonstrate causation to Truist and Infosys upper management.

• Wells Fargo Bank, New Brunswick, NJ 5/2014 to 12/2021 Solutions Architect/ETL-Data Migration Architect/Technical Manager/ Development Team Lead/Data Management and Analytics Team Lead Key technical resource on data analytics, relational database design and implementation, data migration design and delivery, and technical planning and estimating, within multiple Wells Fargo mission-critical, enterprise- level, data management and business intelligence reporting initiatives, including: Solutions Architect/Technical Manager/Requirements-Analytics Team Technical Lead COO-CAO Organization: Data Management and Insights Group: Consumer Data Enterprise Platform Project (CDEP): Marketing Trait Library Track: 9/2021 to 12/2021 Marketing Data Environment Project (MDE): Foundation Tables-Marketing Execution Track: 8/2019 to 9/2021 Defined and continually refined the Requirements-Analytics team process, and direction. Drove the migration of marketing data and related transformation logic from heavily siloed legacy sub-systems across the organization -- conforming that data and logic (structured as marketing campaign traits), across multiple lines of business -- into a unified, enterprise marketing library. Coordinated extensively with other Wells Fargo technical teams to clarify legacy logic, and drive definition of future state logic and a comprehensive, consolidated target database model. Interviewed, trained, coordinated, and provided ongoing supervision and support for Requirements-Analytics team members. Personally reviewed and finalized all deliverables (SQL code and metadata documentation) across the team.

Solutions Architect/Technical Manager/Development Team Lead Consumer Retail Services Division: Analytics (CRS): Jabbari Project: 9/2017 to 8/2019 Consumer Credit Solutions Division: Analytics (CCS): Card Settlement Project: 10/2016 to 9/2017 Sole CCS solutions architect on the Card Settlement Project (CSP). Directed extensive cross-system/cross-team architectural design and analysis, source data analysis, and managed a development team, in connection with design and implementation of the CSP data mart. Supported internal analysis and reporting on the highly media-visible issues within Wells Fargo involving ‘potentially unauthorized accounts’. Key architect/designer of a cross-enterprise data mart, and related design and implementation of an ETL system (150+ processes) for the consumer credit line of business to source extensive historical data in order to assess potential damage to customers. This work transitioned into a related CRS project, ‘Jabbari’, assessing claims from customers pursuing Wells Fargo in a related class action.

Bob Doucette

Page 3

Technical Manager/Solutions Architect/RaAP Development Track Lead Consumer Credit Solutions Division: Analytics: Reporting and Analytic Platform (RaAP): 5/2014 to 9/2016 Solutions architect initially tasked with assessing existing infrastructure and defining transitional and target architecture for a major re-platforming of the Reporting and Analytic Platform (RaAP) -- a 10+TB dimensional data warehouse for marketing analytics, with core development in Oracle SQL and PL/SQL. Responsible for numerous aspects of RaAP system re-design including providing an infrastructure roadmap for hardware re- platforming; forecasting database capacity/growth; and implementing ETL, database, and automation design improvements. Transitioned into development team track lead on several RaAP subject area expansion phases

(‘Account Management’ and ‘Digital’ tracks). Supervised several development teams while personally performing extensive source system data analysis and hands-on design and implementation of database and ETL improvements in key product areas (credit cards, personal lines of credit, and student loans, and others). Conquest Data Solutions, LLC, Swampscott, MA 8/2006 to 5/2014 President and Principal Solutions Architect

Co-founder and principal solutions architect at Conquest Data Solutions, LLC -- an IT architectural design and delivery consultancy operating within the Boston area, specializing in large scale data warehousing, database design and delivery, infrastructure sizing/assessment, and ETL/data migration design, implementation, and automation for various large institutional clients, including EMC Corporation, Merkle Inc., Fidelity Investments and Fresenius Medical Care – North America. Client engagements detailed below.

• EMC

2

Corporation, Southboro, MA (full-time) 8/2011 to 4/2014 Solutions Architect/Enterprise Informatica Administrator (part-time) 12/2010 to 8/2011 EMC IT Business Intelligence Team: Enterprise Resource Group, Technology Over the course of more than three years, drove multiple major Informatica enterprise installations and upgrades, along with extensive ETL systems-level environment redesigns and expansions. (Environment: over ten INFA domains on forty+ virtual linux servers). Responsible for exploring and implementing new features and functionality of the Informatica tool suite (Data Services, Data Quality, PowerExchange) for the EMC Global Data Warehouse and related EMC systems. Regularly involved in driving ETL and Informatica methodology/best practices and ongoing ETL performance tuning efforts, as well as providing general database and ETL design support for a large community of 75+ Informatica developers.

• Merkle Incorporated, Marlboro, MA (part-time) 8/2011 to 11/2011 Solutions Architect/Enterprise Informatica Administrator (full-time) 3/2010 to 8/2011 Enterprise Technology Group

Solutions Architect within the database marketing division of an international advertising agency. Designed and built out Merkle's ETL and Informatica environments from the ground up, to support the roll out of an extensive, high speed, common data service platform for more than thirty-five parallel client projects. Personally designed the data infrastructure and implemented tightly segregated, OS-level system security within the common service platform, to support seamless, parallel client project ETL execution and database loads. Migrated more than thirty-five client data projects to this new shared production processing platform. Responsible for all Informatica tool administration including server software installation, configuration, and maintenance and related HP-UX system administration. Individually provided ETL and database code design and performance tuning guidance support, company-wide, for an organization of more than 1,000 with approximately 160+ Informatica and SQL developers. Bob Doucette

Page 4

• Fidelity Investments, Boston, MA 5/2007 to 12/2009 Solutions Architect/Technical Project Manager/ETL-Data Migration Architect 9/2004 to 9/2006 Brokerage Company - Technology

Fidelity Institutional Technology Database Architecture Group Initially engaged with Fidelity Brokerage as a senior consultant/senior solutions architect from Axis Technology. Left Axis to become one of the founders of Conquest Data Solutions, LLC. Subsequently returned to Fidelity Brokerage as a Conquest solutions architect. Solutions Architect/ETL-Data Migration Architect (Through Conquest): (4/2008 to 12/2009): One of the core architects integral in replatforming and upgrading an enormous legacy data warehouse, the Fidelity Brokerage Warehouse, supporting more than a dozen key systems and business groups. Migrated and redesigned a legacy warehouse in excess of 38+ terabytes, while upgrading to faster AIX hardware along with Oracle and Informatica upgrades. In addition to database development, also redesigned the UNIX environment structure, ETL, and system scheduling to support the new data warehouse, while also supporting the legacy system processing.

Technical Project Manager (Through Conquest): (5/2007 to 4/2008): Actively managed a large software infrastructure upgrade effort and numerous web-based reporting enhancement projects throughout the full SDLC within the Fidelity Brokerage data warehouse group. This included project technical review and supervision, project estimation/sizing and fiscal management, staff and resource supervision, and scheduling and project timeline management on 8-10 projects in parallel. Solutions Architect/ETL-Data Migration Architect (Through Axis Technology): (9/2004 to 9/2006) Principal architect driving the design of a fully automated, meta-data driven, Informatica code generation system for masking customer sensitive information in non-production database systems. That code generation and execution system was used to mask billions of rows of customer sensitive data in 300+ distinct, non- production environments on the mid-tier as well as multiple environments on the mainframe.

• Fresenius Medical Care – North America, Lexington, MA 9/2006 to 5/2007 Integrations Lead Architect/Technical Manager

Lead architect on creation of a centralized technology Integrations department within a multi-billion dollar medical firm, the largest provider of out-patient kidney dialysis treatment in North America. As lead architect managed and greatly expanded a central Integrations database and data migration group focused on a

$300MM+, multi-year, multi-phase, conversion/migration project called ABACUS, targeted at moving the central IT support and processing for all of Fresenius’ core dialysis treatment clinics onto a centralized, more manageable and scaleable platform. (Oracle/Informatica/Alpha/Unix) Drove a number of critical software and hardware changes including ETL technology selection and substantial hardware infrastructure scaling to meet anticipated development and testing needs. Introduced a sound SDLC including simplified templates for functional and technical specifications, a meaningful change management process, and sweeping environmental changes to improve Informatica, UNIX and database development and testing quality, process auditing, and data and code control.

Putnam Investments, Boston, MA 12/2001 to 9/2004

Solutions Architect/Technical Project Manager/Enterprise Informatica Administrator Information Systems Division

Solutions architect and database and ETL designer and developer, managing a data migration team within the enterprise database administration group. Responsibilities included providing database design, data migration, and process automation design and development support to numerous Putnam projects. Redesigned more than 80% of the existing ETL code for Putnam’s Defined Contribution Retirement data warehouse. Eliminated numerous slow and obsolete ETL processes and stabilized the production, development, and testing environments. Also responsible, as the sole enterprise Informatica Administrator, for company-wide Informatica administration and support.

Bob Doucette

Page 5

Tessera Enterprise Systems/iXL/Scient, Wakefield, MA 8/1996 to 11/2001 Solutions Architect/ETL-Data Migration Architect/Lead Software Engineer Solutions architect/engineer at an international systems integration/internet development firm. Many years experience in a key technical leadership role as a solutions architect and lead software engineer on various ERM/CRM data warehouse projects for many Fortune 500 and large European clients including Columbia House; Eddie Bauer; Charles Schwab; Fleet Bank; the Virgin Companies (UK); and UniCredito Italiano (Italy). Epsilon Data Management, Burlington, MA 8/1993 to 8/1996 UNIX Systems Programmer/ETL-Data Migration Developer Senior software engineer within the High Performance Computing Division, involved in all phases of design, implementation, maintenance, and enhancement of the American Express CRM QUANTUM marketing system -- the largest commercial marketing data warehouse in existence up to that time – a propriety data warehouse implemented as a massive set of hierarchical flat files, managed entirely in C/C++. Education

Northeastern University School of Law (Juris Doctor) Boston College (B.A. in Political Science and Psychology - double major) Professional Memberships & Associations

Member of the Massachusetts Bar since 1988; Federal District Court of Massachusetts since 1989

Contact this candidate