Matthew Hurt Email & Phone Number

Englewood, CO, US

Colorado, United States

• Responsible for maintaining and developing against 30+ databases in a high-transaction (200M/month) environment with some tables exceeding 2 billion rows
• Identified and resolved queries consuming roughly 40% of server CPU, saving company $32K in core licensing costs
• Created SSRS analytic reports for senior management resulting in $50K+/yr operational savings
• Analyzed and made recommendations to increase VMWare performance for SQL Server in a virtualized environment resulting in 30% increased IOP performance
• Provided oversight of database contracting resources during data center move and AOAG upgrade
• Worked with in-house developers to identify and remediate connection pooling and port exhaustion issues

Colorado, United States

• Developed and supported SSRS reports to aid the city's COVID-19 response for the CARES Grant program. Reports were used internally as well as presentation aids during City Council meetings.
• Developed T-SQL queries and SSRS reports to trend enterprise server disk space usage and proactively alert IT staff of potential issues
• Prototyped Power BI dashboards for city-wide KPM project
• Developed SSIS packages to import bulk scanned documents and T-SQL ETL processes to cleanse and classify the data to prepare it for ingestion into internal document storage system (OnBase)
• Performed Microsoft SQL Server migrations, version upgrades, monthly patching, and maintenance
• OnBase EP3 Certified System Administrator

• Utilized severance from plant closure to experience life from another angle by flipping homes and being and active caregiver for my family

• Primary point person for site-wide Quality department tasked with key corporate initiatives supporting process monitoring, process improvement, and FDA compliance
• Developed ETL processes, Queries, BI dashboards, and ad-hoc data pulls using MSSQL Server, T-SQL, SSRS, SSIS, Excel, and VBA
• Developed system of SSRS reports for risk-based analysis of complaint data which became the corporate gold-standard
• Won corporate recognition award for an Excel dashboard which, within first week of use, gave management information insight resulting in a large capacity increase
• Additionally, primary point person for site-wide manufacturing data collection system developing BI/KPI dashboards and real-time performance monitoring kiosks using MSSQL Server, T-SQL, SSRS, SSIS, KepWare, ICONICS.

Acquired by Baxter Corporation. Position re-mapped to Principle Engineer.

• Designed, developed, and maintained completely new corporate EDI system using BizTalk 2006 R2, T-SQL, and SSRS
• System handled approximately 50% of all yearly sales ($70M)
• System enjoyed 100% uptime for more than 4 years

Greater Denver Area

• Worked with client’s senior management to learn their costing structures and consolidate their data from disparate sources (ETL) using MSSQL Server, T-SQL, SSIS, Visual Manufacturing ERP
• Developed a simple intranet interface to support analysis and reporting of company sales
• All report totals tied to the General Ledger to the penny

Ba, Environmental Design (Architecture)

Professional Certifications (Please See Licenses & Certifications Section)