Richard Bond

• Responsible for management, buildout and administration of Two Hundred Seventy Five (275) “On-Premise” SQL Server (2016-2025) Instances and over six thousand (6,000) databases at four international data centers (France, Singapore, California and Texas) in support of 1,100 attorneys and support staff; • Work with the e-discovery team on current litigation data procurement or production; this involves ETL and data manipulation (data masking) in compliance with Federal and State laws; • Development of GDC Azure technology stack in current efforts to migrate SQL databases (I-Manage, Relativity, Aderrant) to Azure. • SME on Always On and International Geographic Clustering of production data • Cross Duties include VM Maintenance, OS Patching and SQL Patching

• Responsible for designing and buildout execution of all database systems consumed by the various organizations within the Risk Management Department; • Reporting to Manager of Business Intelligence, works with vendors, contractors and institutional trading partners as well as key stakeholders for fluid data exchange between LLU and seventy (70) external data services; • Development and implementation of Multi Node On Premise Data Center with over Two Hundred (100) VM Servers, workstations and file drop locations; • Review and Approval of Development Scripts for production rollouts as well as feedback including Peer Reviews; • Work with development staff on best practices, including schema binding and naming conventions;

• Responsible for providing detailed direction to the design, development, implementation and maintenance of data repositories populated by clinical information and administrative systems; • Reporting to Executive Director of Data Governance, works with Project Managers as Analytics Liaison in meetings with key stakeholders for projects; • Coordinate and Collaborate with HR on recruiting, interviewing hiring and retention of Data Analytics Team personnel • Review and Approval of Development Scripts for production rollouts as well as feedback including Peer Reviews; • Design and Implement Enterprise Data Security Model for Data Virtualization Tools; Production support of DW reporting tools; • Work with development staff on best practices, including schema binding and naming conventions;

• Responsible for team leadership of contractors/temp labor), including interviewing, coaching and mentoring of technical team members. • Provided tier 2 and 3 database development support for all customer-facing database systems (Exhibitor Management Systems. Theatrical Distribution System) and services to meet or exceed service level agreements. • Played a “hands-on” role, in developing, installing, maintaining and monitoring company databases in a high-performance environment while supporting enterprise projects. Provided database support and liaison with application development; batch processing, reporting, security, warehouse and technical services. • Managed and oversaw database architecture, service reliability, and performed root cause analysis of software, process and service failures.

• Reporting to Director of Data Services, interviewed, hired and managed staff of 17 database engineers and developers. Recommended hiring and termination of staff; planning of the staff 's work, training Evoke creative and innovative thinking from team members while helping them bring their ideas and career plans to fruition. • Ensured SQL Server/ UNIX/ Oracle data platforms are scalable to meet anticipated future business requirements. • Responsible for the communication of daily cross-functional, departmental processes with the development staff, to ensure delivery of a consistent level of infrastructure service provision to different business units, 6,000 service providers, the State of California and the Federal Medicare programs. • Ensured resourcing and development strategies and plans are in place to be able to meet business demand. • Developed Service Level Agreements (SLAs) that meet current and future business requirements. • Developed and managed the EDW (Enterprise Data Warehouse) project which had been stalled for two years. • Managed vendor relationships, acquisitions, and ensures timely escalation during problems and moments of need.

• Reporting to Director-Application Development, managed team of 6 database developers and administrators. • Supported, developed and architected database solutions for the order inventory, billing and global SAP accounting system • Stood as liaison to multiple and diverse business groups, security and enterprise architecture, PMO, development teams and others to ensure that the enterprise data infrastructure programs are aligned to the business objectives and continue to mature over time; • Sponsored technology refresh projects and ensured consistent business focus and alignment across the Delivery and Support teams. • Provided “hands on” technical leadership to the engineering and operations of the database team. • Collaborated and sought input from development staff to integrate our business applications within the infrastructure framework. This included working closely with Server, Security, Network, Storage, and Application Architecture in developing a multi-year strategy.

• Responsible for team leadership of contractors/temp labor), including interviewing, coaching and mentoring of technical team members. • Provided tier 2 and 3 database development support for all customer-facing database systems (Exhibitor Management Systems. Theatrical Distribution System) and services to meet or exceed service level agreements. • Played a “hands-on” role, in developing, installing, maintaining and monitoring company databases in a high-performance environment while supporting enterprise projects. Provided database support and liaison with application development; batch processing, reporting, security, warehouse and technical services. • Managed and oversaw database architecture, service reliability, and performed root cause analysis of software, process and service failures.

• Developed a strategy focused on business goals while capitalizing on technology insights to improve the value of analytical data, improve effectiveness of collected data and streamline the flow of and integration of data for the national restaurant chain. • Collaborated with the internal business teams and external vendors/partners to ensure that data management decisions aligned with overall business strategies, tactical needs and plans. • Identified, selected, and deployed analytics technology platforms to capture, integrate, and analyze data from many sources. • Lead the use of technologies to enable data-driven decisions applied to all guest interactions, pricing and product decisions. • Derived insights from data mining, modeling, and applied analytics on top of large data sets. • Applied broad data domain knowledge and in-depth hands on experience with enterprise data architecture, data governance, data management, data modeling, business intelligence, advanced analytics, data warehousing and integration technologies.

• Responsible for the database development and support for Next Generation Combined DNA Indexing System (CODIS) (Genome) for the Federal Bureau of Investigation. Database architecture at Local, State and Federal levels; National database of 50 million (50,000,000) DNA specimens (over 360,000,000 rows in larger tables) with greater than 22 search points. • Authored Data Design Specification (FBI-sstC8B9) and co-authored Database Default Data Document (FBI-06201) for Helix/Genome. • Responsible for SQL Database with Over 1,250 Sp’s and 85 tables and snapshot replication capacity to replicate ten million (10,000,000) specimens in event of catastrophic incident; high capacity planning, table partitioning (NDIS) multiple file groups, index optimization and tuning. • Designed uniform database, capable of supporting small labs (100 specimen/Month) all the way to 50 million NDIS (Federal) database. • Supported developers in the application’s features. Member of design review and peer reviews.

• Architected SQL Server Farm build out featuring 128GB virtualized database environment for hot replication standby facility. • Developed the standardization of security models and single point of login permissions for 2,500 employees nationally using the datacenter applications, including SharePoint services. Surveyed/Documented MS-SQL architectures and schemas, (logins, roles and policies). • Responsible for multiple client installation management (SQL 2008) -up time to 99.99%, 24x7 high availability. • Architected Transactional Replication strategies for Microsoft Dynamics (aka “Solomon”). • Architected SQL Reporting Services platform for over 800 reports using and 2,500 users.