David Richard Email & Phone Number

Chicago, Illinois, US

• Defines the high-level architecture vision and value stream of our data from acquisition through customer usage, and guidance on structuring the data efficiently.
• Identifies opportunities and influences other parts of the enterprise to build with a data mindset.
• Collaborates with Enterprise Architects and Portfolio Leads to understand the existing applications and strategy to develop technical solutions that meet scalability, security, and performance, and technical agility.
• Works alongside System Architects to create a roadmap of the architecture runway, and partners with Product Management and RTE (Release Train Engineer) to ensure we are incorporating the enablements appropriately.
• Coaches and mentors System Architects and team members to become the architects of the future.
• Plays the System Architect role as needed on a team.

Hampton, New Hampshire, US

• Club coach for U10 to U21 teams
• DPL level teams (Development Premier League)
• NPL level teams (National Premier League)
• US Soccer Federation D Level License (2010)
• US Soccer Federation C Level License (2014)
• Coached teams attending:

Boston, MA, US

• Lead Architect in the largest Data Migration Liberty Mutual has undertaken. -Migrating 260TB from two on-prem Teradata environments to Snowflake and Aurora PostgreSQL -Migrated thousands of Workflows from three on-prem.
• Establishes and leads the technology strategy and technology road maps that provides the business self service capabilities and business results.
• Partners with the Product Owners to align the roadmap with the technical design and strategy.
• Designs and develops IT architecture scalable solutions to business problems in alignment with the enterprise architecture direction and standards.
• Assisted with introducing Snowflake and SnapLogic cloud technologies into the Development teams.
• Provides consultation and collaborates with Market CIO, business partners and peer groups regarding long and short-range product features.

Boston, MA, US

• Designed a Type-2, End-of-Day, Current Row and Point-in-Time ODS-like look in AWS Aurora/MySQL environment.
• Experience with AWS’s Aurora MySQL, PostgreSQL, S3, RedShift. RedShift Spectrum.
• Designed a Data Provisioning flow in AWS for the EDW developers to adopt.
• Designed data patterns and data flows from application systems to EDW systems, leveraging IBM WebSphere MQ, Informatica PowerCenter 10.1.1, PowerExchange for MQ, Informatica DT Studios, and Golden Gate replication.
• Created a Software Portal to be the centralized area for Development teams to reference for CODE QUALITY, CODE ACCURACY, CODE PERFORMANCE and TRAINING and PRODUCTIVITY.
• Created a bi-weekly meeting for the Development Community to assemble and share in reviewing new technologies, ground breaking business initiatives, and have an open dialog of the Development Practice.

Boston, MA, US

• Provide technical leadership for the Life, Products, Marketing, Actuarial and Finance portfolios.
• Maintain ongoing knowledge of Informatica (9.1+) software and hardware environments, including future releases.
• Perform problem assessment, resolution, estimation and documentation.
• Performance and data quality validation on new and existing Informatica mappings and workflows.
• Performance and data quality for Teradata Macros and Views.
• Participate in requirements gathering and design for ongoing development projects.

Nashua, NH, US

• Develop Student Athletes to excel in Soccer and Academics
• Recruiting for future Student Athletes attending Rivier University
• Developed Goalkeepers
• Run training sessions
• Advocated for Student-Athletes
• Competed in the Great Northeast Athletic Conference

Nashua, NH, US

• Assisted Head Coach with training sessions
• Assisted Head Coach with recruiting
• Developed Goalkeepers
• Run training sessions
• Advocated for Student-Athletes
• Competed in the Great Northeast Athletic Conference

Manchester, NH, US

• Assisted Head Coach with Training Sessions
• Assisted Head Coach with recruiting

Amsterdam, Noord-Holland, NL

• Integrated Informatica (8.5+) into six separate SAP environments and a BW environment.
• Coordinated the conductivity from the Informatica servers to the source system servers.
• Architected the extraction design and Oracle Data Hub for over six hundred SAP tables extracted daily; and another four hundred SAP tables extracted per request.
• Designed, implemented and managed a multi DB conversion from FoxPro to SalesForce.com using Informatica Cloud Services.
• Managed five resources for workload distribution. One locally and four in India.
• Designed an Oracle Data Hub to provide data at the enterprise level for Data Governance.

San Francisco, CA, US

• Developed a dynamic partitioning prototype that was widely accepted as a company standard.
• Upgraded the entire Enterprise Data Warehouse to become Unicode compliant.
• Modified Informatica generated ABAP programs.
• Participated in the design and implementation of a star schema organized Enterprise Data Warehouse.
• Designed and implemented an operational data store (ODS) for over one hundred tables.
• Created UNIX scripts that are called from Informatica sessions to perform housecleaning task on the ODS.

Basking Ridge, NJ, US

• Successfully lead the design and implementation of a cross-platform data warehouse between Unix-Oracle and MVS-DB2 using UNIX scripts, COBOL and JCL
• Effectively managed five team members during implementation of the warehouse.
• Developed an audit process to maintain 100% data integrity.
• Successfully coded UNIX scripts that were remotely executed from MVS and were responsible for unloading changed data from the source systems.
• Designed and implemented a multi-DBMS measurement system to provide key performance measures to the executives.
• Designed a Powerbuilder client server application that leveraged dynamic SQL.

Bachelor'S Degree, Computer Information Systems

Associates, Computer Information Systems