Ryan Gober Email & Phone Number

United States

Development lead key business intelligence projects for the Asset Management data ecosystem.

Lead data professional responsible for Lakehouse design, ETL Engineering, data governance, business analytics and process automation for $170 billion in managed assets. Key Projects• Agile Data Lakehouse Design – Built and automated the integration architecture to consume data subscriptions of investor index benchmarks and Sustainalytics ESG data. Designed and implemented daily B2B business processes using cloud API, SSIS, and SFTP subscription to import and export xml, csv, and json data sets.• Distributed Lakehouse Reporting –Asset Management, CRM, Financial Advisory, and Operational data marts aligned by conformed dimensions to support several reporting tools. • Merger and Acquisition Support – Designed, built, and handed off all relevant components of the PFM database ecosystem into two separate companies.o PFM Financial Advisory – migrated 32 databases serving 13 applications. o PFM Asset Management - integrated $170 billion into U.S. Bank’s managed assets.

Philadelphia, Pa

Managed a team of off-shore DBAs supporting log-shipping, replication, Windows Server Failover Clustering (WSFC), and AlwaysOn Availability Groups (AOAG) for PFM's asset managers, financial advisors and consultants. * Designed and implemented robust redundant 3 Tier HADR database architecture to fulfill company RTO and RPO disaster recovery objectives reducing RTO for multi-site disaster recovery from 4 hours to 2 minutes. * Upgraded in-house database code from SQL2005 to full ANSI compliancy on SQL2016. * Provided expertise in T-SQL and stored procedure optimization, index tuning, memory optimization, storage tuning, and data type refactoring.

Horsham, Pennsylvania

Managed the database environment of a software development company that hosted over 10,000 customer databases. * Migrated 10,000 customer databases to the AWS Cloud. * Performed Agile performance tuning and designed enterprise refactoring strategies to optimize stored procedures, indexes, normalization, memory optimization, storage tuning, and data type refactoring. * Designed, implemented, and refined Data Marts aligned by conformed dimensions focused on specific business outcomes using a feature-driven Disciplined Agile Data Warehouse development methodology. * Designed ETL Processes that harvested structured and unstructured data to analyze use patterns of hosted applications, produce goal driven business insight to identify “at-risk” clients, quantify application feature adoption, identify patterns of code latency, and increase electronic processing revenues.

Philadelphia, Pennsylvania, United States

Architect of Urban’s first high availability clustered SQL Server and database mirroring solutions. Managed a team of remote DBAs to provide 24/7 Database Services support for end-to-end Retail Data Flow from Product Design, Supply Chain, Merchandise Planning and Allocation, Inventory Management, Item and Price Maintenance, Point-of-Sale Processing, Wholesale/Direct/Call Center Ordering, Customer Relationship Management, Distribution Center, to BI Reporting. * Database platforms include SQL Server, MongoDB, Oracle, DB2, AS/400, and MySQL. * Business Intelligence Platforms include Netezza, MicroStrategy, SSAS, and SSRS. * Performed Annual Security, PCI, and SOX audits of company data for annual certification.

Founding member of the Enterprise Database Services Department. Designed and implemented high availability clustered SQL Server and database mirroring solutions. Architected, implemented and provided 24/7 support for international environment of more than 300 databases using SQL 2000/2005/2008. * Consolidated a distributed SQL architecture of 18 servers in 23 offices to a 2 data center 4 SQL Server HADR architecture saving the firm over $100,000 annually in SQL and Windows license fees. * Designed and supported SQL Replication in a centralized distributor model employing 18 transactional publications and 25 subscriptions on 10 SQL instances. * Technical owner of the entire Microsoft BI stack including 4 multi-node SSRS farms, 4 clustered SSAS instances, and 3 stand-alone SSAS instances.

Plymouth Meeting, Pennsylvania, United States

Implemented the firm’s first SQL Servers administering six MS SQL 7.0 servers. Provided application DBA support for the circulation fulfillment system tracking sales and subscriptions of software, periodicals, and memberships.Key Projects and Achievements • Application DBA - Migrated circulation fulfillment database from non-relational ISAM to SQL Server 6.5. Managed SQL Server upgrade from 6.5 to 7.0.• Data Mining - Designed ETL process from internal and external flat file, SQL Server, Access, FoxPro and DB2 data sources analyzing customer demographics and behavior for future development of products and services. • Report Writing - Wrote management reports for sales, marketing, and web subscription content using Crystal Reports, Kedit, Excel, and Access.

Mfa

Ba

Activities and Societies: magna cum laude