Taylor Bragg Email and Phone Number

Database Upgrades/Migrations- Architected and implemented a migration to a replicated “Production Reporting” host, enabling batch processing scheduling without production delays.- Initiated, monitored, and managed a highly available, circular replication database environment, allowing for zero-downtime upgrades, strategic load-balancing, and possible disaster recovery in our production environment.- Migrated from racked MySQL database servers to hosted AWS RDS MySQL instances.-… Show more Database Upgrades/Migrations- Architected and implemented a migration to a replicated “Production Reporting” host, enabling batch processing scheduling without production delays.- Initiated, monitored, and managed a highly available, circular replication database environment, allowing for zero-downtime upgrades, strategic load-balancing, and possible disaster recovery in our production environment.- Migrated from racked MySQL database servers to hosted AWS RDS MySQL instances.- Migrated to hosted AWS RDS Aurora clusters.Data Pipelining- Architected and implemented a Python ETL framework for data warehousing and scalable historic data storage in S3 data lake.- Transitioned from a custom data pipeline framework to a managed Airflow framework.- Implemented monitoring for the framework to allow for error handling and retry logic.Data Warehousing- Architected transactional production data into actionable data warehousing dimensions, enabling business intelligence integrations with Looker and third-party data extensions.- Migrated Amazon Redshift data warehouse engine to a Snowflake multi-cluster environment, allowing for flexible resource auto-scaling and incremental data pre-processing.- Implemented Immutable Data Lake architecture, leveraging S3 framework and columnar Parquet data format for efficient data storage and processing.Business Intelligence and Analytics- Implemented Looker on top of a Redshift (later Snowflake) Data Warehouse (and S3 Data Lake) infrastructure to support self-service and scheduled business processes and visualizations.- Designed a suite of Looker Explores to enable self-service business insights and visualizations.Data Engineering- Managed a team of data engineers who maintained and iterated upon existing data infrastructure (database, data warehouse, business intelligence models, web analytics framework).- Delegated projects to improve the efficiency and reliability of our data pipeline. Show less

Install and configure SQL Server Upgrades, Patches, Stored Procedures, and Diagnostic Software to monitor performance on multiple SQL server instances in a clustered environment.Create and deploy SSIS packages, SQL Reports, Custom PowerShell scripts to import, groom and maintain terabytes of sales data.Perform Query Optimization in SQL Reports to maximize performance.

Produce short, animated videos for the company's website.

Organizing walker schedulesMeeting with new and prospective clientsDeveloping marketing campaigns to grow our client base

Designing and maintaining multiple SQL databasesImplemented Queries to effectively scan, sort and display relevant files and documentsCompiled thousands of government documents released by the Food and Drug Administration

Performed administrative functions around the officeHelped maintain multiple databases of Stanford alumniManaged multiple databases of client information in Microsoft Excel

Contracted by National Institutes of Health to renovate the main hospital on campus – Building 10Drafted designs in AutoCAD and Managed design information in Archibus