Automate. Integrate. Innovate.

Matthew Hays is a highly skilled Business Intelligence Analyst, Automation Specialist, and Low-Code Application Developer dedicated to delivering comprehensive analytics and automation solutions. With expertise in operations, finance, accounting, ERP systems, database management, automation (Microsoft automation tools, Python, Selenium, VBA), and low-code solutions (Power Apps), Matthew creates innovative, integrated solutions that significantly improve operational efficiency and decision-making.

Technical Proficiencies

A modern Data Analytics Infrastructure requires a complex set of core competencies. Baseline IT architecture, data acquisition techniques, core operational and financial data analysis and presentation, KPI tracking, internal/external threat management, QA/QC of data and data pipelines, and advanced AI concepts all play important roles in the orchestration of this infrastructure.

Navigating these waters in a cost-effective, secure, and reliable manner is where Hays Automation can help transform your data into Actionable Insights & Innovation.
IT Infrastructure & System Administration

Establishing and supporting foundational technology environments.

  • Windows Server Administration & Configuration
  • SQL Server Installation, Maintenance & Tuning
  • Active Directory (AD) Administration
  • Azure Cloud Infrastructure Administration
  • Power BI Gateway, SSRS, SSIS, SSAS Env Admin
  • Virtualization / Containerization
  • Microsoft Endpoint Manager (Intune)
  • Azure Monitor / Application Insights
  • Networking basics (DNS, DHCP, VPN, Firewall)
  • Backup and Disaster Recovery (Azure Backup)

Modernizing infrastructure, reducing cost, and decentralizing points of failure for critical technology assets.

  • Microsoft Azure Data Factory
  • Microsoft Azure Synapse Analytics
  • Microsoft Azure SQL
  • Microsoft Azure Data Lake
  • Microsoft 365 Power BI
  • Microsoft 365 SharePoint
  • Microsoft 365 Teams Integration
  • Amazon Web Services (AWS)
  • Google Cloud Platform (GCP)
  • Databricks Delta Lake
  • Databricks Unified Analytics Platform
  • Oracle Analytics
  • Zoho Analytics

QuickBooks, Microsoft Dynamics, Oracle Financials, SAP Financial Modules

Extracting, preparing, and loading data into analytics environments.

  • SQL Server Integration Services (SSIS)
  • Power Query (ETL/Data Prep)
  • Azure Data Factory (ADF)
  • Informatica PowerCenter / Cloud
  • Apache NiFi
  • AWS Glue

Structuring data for accuracy, efficiency, and scalability.

  • SQL Server Analysis Services (SSAS)
  • Azure Analysis Services (AAS)
  • Microsoft Dataverse (Common Data Service)
  • Azure Synapse Analytics
  • Snowflake Cloud Data Platform
  • Amazon Redshift
  • Google BigQuery
  • Oracle Exadata
  • Microsoft Power BI (Desktop, Service, Report Server)
  • SQL Server Reporting Services (SSRS)
  • Excel (Pivot Tables, Power Pivot, Power Query)
  • Tableau Desktop / Server / Cloud
  • Looker (Google Cloud)
  • SAP Analytics Cloud

Delivering accurate, actionable insights through reporting.

Communicating complex data insights clearly and effectively.

  • Power BI Interactive Dashboards & Reports
  • Power BI Paginated Reports
  • Spotfire Dashboards Development
  • SSRS Paginated Reports
  • Excel Interactive Dashboards
  • Tableau Advanced Visualizations
  • D3.js / Custom Web-based Visualization
  • Charticulator
  • Adobe Creative Suite (Illustrator, Photoshop)
  • PowerPoint ExecutivPresentations & Key Notes
  • Pro Presenter Live/Webcast Keynotes

Enabling deeper insight through predictive and advanced analytics.

  • DAX
  • M (Power Query)
  • SQL
  • R & Python Integration into BI Solutions
  • Azure Machine Learning
  • Databricks Notebooks
  • AI Builder (Power Platform)
  • Azure Cognitive Services (custom AI integration)
  • Jupyter Notebooks (Python & R)
  • Ollama (Local AI / LLM / Orchestration)

Driving strategic decisions through comprehensive financial insights.

  • Financial Modeling & Forecasting (Excel)
  • Budgeting & Planning
  • Variance Analysis & Management Reporting
  • Profitability & Cost Analysis
  • Financial KPIs and Dashboard Development
  • Adaptive Insights (Workday Adaptive Planning)
  • Oracle Hyperion Planning / Essbase
  • SAP BPC (Business Planning & Consolidation)
  • IBM Planning Analytics (TM1)
  • Anaplan (Financial Planning & Forecasting Platform)
  • QuickBooks, SAP ERP, Oracle Financials

Streamlining business processes, enhancing efficiency and productivity in a cost-effective, scalable, and democratized strategy.

  • Microsoft Power Apps Developer
  • Microsoft Power Automate (Flows, RPA)
  • Azure Logic Apps
  • UiPath (Robotic Process Automation)
  • Zapier / Workato (Workflow Automation)
  • OutSystems / Mendix (Low-code development)

Ensuring data quality, security, and regulatory compliance.

  • Power BI & Power Platform Governance
  • Azure Active Directory & RBAC
  • Row-level Security Implementation
  • Microsoft Purview (Data Governance & Compliance)
  • Okta / Azure Identity Management
  • Apache Syncope IAM
  • Data Loss Prevention (DLP) policies
  • GDPR / CCPA /HIPAA compliance strategies
  • oAuth / SSO Integration strategies

Optimizing collaboration, quality, and delivery speed for BI projects.

  • Agile/Scrum methodologies for BI projects
  • Power Platform ALM (Application Lifecycle Mgmt)
  • Azure DevOps (CI/CD, Boards, Repos)
  • Git/GitHub (Version Control, Actions)
  • Jenkins (CI/CD Automation)
  • Jira (Issue Tracking & Agile Project Management)
  • Confluence (Documentation)
  • JetBrains WriterSide (Documentation)