Robert Hyatt Email & Phone Number

Chattanooga, TN, US

• Consulted on a large data warehousing project, assisting with data engineering, SQL coding and optimization, and data architecture on Snowflake platform
• Optimized data processing resulting in 99% run time reduction with projected 1M USD operating cost savings over 1 year
• Took ownership of Snowflake development, managing existing database code and schema, troubleshooting, and improving as needed
• Ensured maintenance and integrity of production and development environments
• Responsible for all aspects of database design, development, and deployment, including producing ER data models
• Advised on enhancing data integrity and availability, continuously improving the Snowflake environment and processes

Chattanooga, Tennessee, United States

• Built and operated Microsoft SQL Server fleets in private cloud and AWS for databases, SSIS, and SSRS
• Designed Business Intelligence solutions for data marts, data warehouses, analytics, and reporting using systems including SQL Server, Power BI, Tableau, and Excel
• Managed integrations between systems including Microsoft Azure, Amazon AWS, SQL Server, MySQL, PostgreSQL, Snowflake, Microsoft O365 Dynamics CRM, Salesforce CRM, and financial partners
• Supervised Enterprise data integrity processes including data security, access control, data modeling, data profiling, data quality, data analysis, data cleansing, data hygiene, data sanitizing, and data retention
• Provided guidance and training for database design, data architectures, SQL queries, testing, automation, monitoring, performance tuning, and release cycles

Knoxville, Tennessee, United States

• Short-term contract for Enterprise Data Warehouse data architecture and modeling at one of largest hospital staffing companies in the US
• Coordinated and executed technical discovery, data model rationalization, source to target definition, and ETL offshoring for two data EDW data marts

Chattanooga, Tennessee

• Matured and supported the IT Enterprise Architecture and Standards practice at the largest Federal electric power utility
• Provided IT alignment to business unit strategic goals through Solutions Architectures focused on the Information Domain
• Created and refined IT Enterprise Architecture strategies and roadmaps, principles, governance practices, and processes
• Led stakeholder teams to rationalize and document IT project system architectures and requirements
• Developed workflow for evaluating Emerging Technology trends and technologies supporting business unit goals
• Evaluated new software requests to reduce functional duplication and improve architectural consistency

Chattanooga, TN

• Stabilized and enhanced ERP integrations, automations, and reporting, eliminating time-consuming data flow interruptions
• Designed resource reporting across VMware cloud, server farms, and client PCs
• Implemented Data Quality matching and cleansing for major customers, enabling efficient data exchanges
• Designed web service platform integrating service calls with major customer ServiceNow platform, recovering staff data entry time and reducing call service times
• Tested and deployed best practice configurations and monitoring for SQL Server, VMware, DR, SAN, networks, Windows servers and desktops, backups, and applications, increasing processing efficiency and reducing capacity.

Chattanooga, TN

• Managed IT services during rapid growth from 20 to 130 employees, introducing modern network infrastructure, VPN data and phone system access for remote offices, corporate office relocation allowing future growth, and.
• Directed and trained staff in EDI integration and configuration, opening new markets and clients
• Managed physical and data security, eliminating data entry errors and broker commission issues
• Upgraded and expanded transportation management system, correcting issues and expanding capabilities
• Negotiated vendor contracts, pricing, and stocking levels, stabilizing costs and supply chains, reducing yearly spend by $200k

Chattanooga, Tennessee Area

• Directed transportation management system vendor development and integration, recovering over 200 staff hours weekly and reducing invoicing time with major clients by two weeks
• Performed data quality analysis and cleansing, allowing accurate business analytics and increasing data confidence
• Produced BI reporting for profitability and service levels, driving reallocation of staff and satellite offices

Chattanooga, Tennessee Area

• Designed strategies, standards, policies, and processes for Master Data Management, Data Governance and Stewardship, SQL Server HA/DR, DBA roles and SOPs, data architectures, data access and security
• Consulted, trained, and mentored with IT, Business Units, and Legal on Business Intelligence, Data Warehousing, data processing, SQL and data access programming, data security, complex systems diagnostics, and special.
• Implemented ITIL frameworks in network management systems and SQL Server applications for Enterprise application data flow monitoring and alerting
• Chartered and managed Data Management group, delivering Enterprise Data Warehouse with PSA and ODS, data catalogs and dictionaries for MDM subject areas, BI platforms and data marts, integration with legacy iSeries and.
• Hired, trained, and mentored junior DBA staff, allowing on-call rotation and increased support capabilities
• Designed, implemented, and trained staff on SQL Server BI solutions allowing replacement of other BI reporting platforms and revealing actionable intelligence for operational changes resulting in $1M saving over.