×
Dean Hattenhauer

Dean Hattenhauer

Data Analyst & QA

Greenwood, AR
479-255-8230

Background


About

About

Continuous Improvement and Data Analyst with 8+ years quality assurance, optimizing workflows, and delivering data-driven solutions that increase efficiency and reduce waste. Skilled in Lean Six Sigma, process mapping, and root cause analysis to drive sustainable improvements. Experienced in building automation tools, KPI dashboards, and cross-functional strategies that improve performance and service delivery.

Work Experience

Work Experience

  • Data Analyst, Foundation Risk Partners

    Oct, 2024 - Present

    Data analysis and automation across insurance operations.

    • Partner with cross-functional stakeholders to coordinate, plan, and deliver process improvement initiatives supporting compliance, audit readiness, and operational efficiency in an insurance and risk management environment.

    • Conduct root cause analysis on process gaps and compliance failures; implement standardized corrective workflows, reducing repeat audit issues by 35%.

    • Develop and maintain Power BI dashboards and Excel reports to track KPIs for audit performance, SLA adherence, and process compliance — enabling leadership to identify bottlenecks and prioritize solutions.

    • Lead change management for audit workflow updates by creating documentation, training materials, and adoption strategies across multiple departments.

    • Automate repetitive audit tasks using PowerShell scripts (data cleanup, report archiving, SLA alerts), cutting manual workload by 60% and improving consistency.

  • Lead Quality Analyst, Foundever

    Apr, 2022 - Sep, 20242 years 5 months

    Rejoined after a 1-year external Project Coordinator role (Apr 2021 – Apr 2022); returned to core QA leadership responsibilities with an expanded scope in performance oversight, automation, data-driven reporting, and cross-site continuous improvement.

    • Spearheaded continuous improvement projects across four operational sites, boosting evaluation efficiency by 15% through automation of call grading processes.

    • Facilitated RCPS (Root Cause Problem Solving) workshops, reducing defects by 50% and improving Six Sigma performance from 3.09 to 3.58.

    • Designed and implemented a centralized quality reporting system to monitor quality metrics, enabling rapid insights and more targeted coaching strategies.

    • Standardized claims QA documentation and escalation protocols, reducing onboarding time and ensuring consistency across teams.

  • Lead Quality Analyst, Foundever

    Feb, 2016 - Apr, 20215 years 2 months

    Led QA initiatives and reporting automation across financial operations.

    • Facilitated weekly, bi-weekly, and monthly business reviews with senior bank stakeholders, presenting KPI trends, audit outcomes, and performance improvement plans to drive alignment and accountability.

    • Developed executive-ready KPI dashboards and performance reports, ensuring clear visibility into dispute resolution accuracy, SLA adherence, and compliance results across multiple sites.

    • Partnered with directors and VPs to create corrective action plans for underperforming metrics, resulting in measurable improvements in accuracy, timeliness, and customer experience.

    • Influenced strategic decision-making by translating quality data into actionable insights, positioning QA as a driver of operational and financial performance.

Projects Experience

Projects Experience

  • Full Security Audit Process Revamp (Foundation Risk Partners)

    - Present

    Standardized and documented workflows for 18 security audits, improving efficiency, consistency, and onboarding speed.
    Enhanced audit consistency and reduced missed steps via detailed process mapping.
    Elevated leadership visibility and set the groundwork for future automation.

    • Internal Audit Docs, Power BI, SharePoint, PowerShell, Excel

  • RCPS Defect Reduction Initiative (Foundever)

    - Present

    Led Root Cause Problem Solving workshops to address systemic process flaws.
    Achieved a 50% reduction in defect rate and raised Six Sigma performance from 3.09 to 3.58.
    Standardized corrective action procedures across multiple sites for wider adoption.

    • RCA frameworks, Six Sigma DMAIC

  • Audit Workflow Automation (Foundation Risk Partners)

    - Present

    Automated repetitive audit-related tasks using PowerShell for data cleanup, archiving, and SLA alerts.
    Reduced manual workload by 60% and improved consistency and timeliness in compliance reporting.

    • PowerShell, Excel

  • Power BI Audit Tracker Dashboard (Foundation Risk Partners)

    - Present

    Built an interactive dashboard to monitor audit progress, SLA compliance, and key department KPIs.
    Enabled leadership to detect bottlenecks in real time.
    Boosted SLA-aligned audit task completion by 15%.

    • Power BI, DAX, Excel

  • AI Agent in Python (Boot.dev Project)

    - Present

    Developed an LLM-powered, agentic command-line tool in Python that can read, update, and execute code using the Google Gemini API.
    Implemented function calling and feedback loops to enable the AI agent to autonomously identify and fix bugs in real projects.
    Learned agent architecture and modern AI workflow design—demonstrating preparedness for AI-enabled automation in business environments.

    • Python, Google Gemini API, Functional Programming, Agentic LLM workflows

Skills

Skills

  • Languages

    Python

    JavaScript

    PowerShell

    SQL

    VBA

  • Tools

    Power BI (Data Visualization & DAX)

    Microsoft Office (Advanced Excel, Word, PowerPoint)

    Power Automate

    SharePoint

  • Concepts

    Lean Six Sigma (Black Belt)

    Process Automation & Optimization

    Root Cause Analysis (RCA, RCPS, DMAIC)

    Agile Methodologies

    KPI & Performance Metrics Tracking

    Performance Improvement

    Workflow Auditing & Compliance Monitoring

    Change Management

    Data Visualization

    Data Manipulation

    Data-Driven Decision Making

Certificates

Certificates

  • Lean Six Sigma - Black Belt, RPM Academy

    Issued on: Apr 22, 2024

  • Data Analysis, RPM Academy

    Issued on: Apr 15, 2024

  • Agile Project Management, RPM Academy

    Issued on: Apr 15, 2024

  • Power BI Essential Training (NASBA Certified), LinkedIn Learning

    Issued on: Aug 06, 2025

  • SQL Essential Training (NASBA Certified), LinkedIn Learning

    Issued on: Jul 31, 2025

  • MySQL Essential Training, LinkedIn Learning

    Issued on: Oct 17, 2023

  • Learn Functional Programming in Python, Boot.dev

    Issued on: Aug 26, 2025

  • Build an AI Agent in Python, Boot.dev

    Issued on: Sep 01, 2025

  • Cybersecurity, RPM Academy

    Issued on: Apr 17, 2024