Brian Hyde Email & Phone Number

Layton, Ut, Us

Sandy, Ut

o Optimized problematic and long running queries through query tuning and adding missing indexeso Reduced the average database query response time by 70%o All but eliminated database spikes that caused application downtimeo Setup automated database maintenance planso Successfully integrated with Salesforce using DBAmpo Greatly reduced problems within process of providing 1099s to officials through automationo Responsible for monitoring the health of production and development/QA SQL servers, including health of Always On Availability Groupso Responsible for administration of database backup processo Responsible for supporting application development needso Responsible for database change script control through Beta and Production environments

West Valley City, Ut

o Completed Kimball University Training - Dimensional Modeling in Depth – 12/2014o Responsible for migration and testing of hundreds of SAP Data Services ETLs from version 3 to version 4o Responsible for maintenance and environment bugs of legacy data warehouse environment (SAP DataServices and Microsoft SQLServer)o Responsible for design and development of new data warehouse schema in Microsoft SQLServero Responsible for design and development of new data warehousing ETLs in Microsoft SSISo Responsible for design and development of Attributes and Facts and their relationships in MicroStategy

West Valley City, Ut

o Responsible for monitoring the health of 7 production and 4 development/QA SQL servers.o Responsible for upgrading SQL servers.o Responsible for logical/physical database design.o Responsible for local and offsite backup/recovery process design and periodic testing.o Responsible for designing and monitoring replication of transactional data as a source for reporting and data warehousing needs.o Responsible for supporting application development needs.o Responsible for index tuning and maintenance.o Responsible for designing and monitoring SSIS packages for purpose of client data migration.o Responsible for scheduling and monitoring SQL Server Agent Jobs.o Responsible for implement and maintaining security protocols.o Responsible for database change script control through QA, Beta, and Production environments.o Responsible for monitoring and following SAS70 controls.o Responsible for the creation, maintenance, access, and subscriptions of over a hundred reports using Reporting Services.

Sandy, Ut

o Responsible for the creation, maintenance, access, and subscriptions of hundreds of reports using Reporting Services and Crystal Reports.o Recreated hundreds of Crystal reports in Reporting Services reports.o Extensive T-SQL experience including complex ad-hoc queries, views, functions and stored procedures.o Constantly improve report performance by indexing tables, updating T-SQL queries, creating views and stored procedures.o Reduced peak hour server resource load by over 50% by creating data mart, streamlining Transact-SQL, and combining code on existing reports.o Experienced in creating reports and conducting analysis for Sales, Marketing, Customer Service, Accounting, Finance, Distribution, and Inventory Management.o Audited all corporate departments to determine reporting needs including efficiency tools, metrics, exceptions reports, etc. Focused on making reports to streamline processes and drive decision-making. o Project Lead on new Customer Reporting system – allows customer to access information while keeping other customers information confidential and provides multiple parameter selection that Reporting Services 2000 does not provide.o Recognized by colleagues as knowledgeable and self-motivated, with strong problem solving and troubleshooting skills.

Kaysville, Ut

o Helped create Pace Software using, Visual Studio.net, Microsoft SQL Server, Java Script, and Crystal Reports.o Solely responsible for the creation of reports for Pace Software produced in Crystal Reports.o Converted hundreds of doctor office forms to database filled printable Crystal Reports.o Increased physician’s profits 20-40% by installing Pace Software to make sure medical procedures are paid according to contract and help collect unrealized revenue.o Designed and Programmed Visual Basic 6 and Microsoft Access program to initiate pre-Pace Software installation rebilling procedures.o Designed and Programmed Visual Basic 6 and Microsoft Access program to produce initial analysis and estimation or doctor’s situation. Dramatically decreasing analysis time from 24-32 hours to 4-6 hours.