BRIAN KEITH DUNCAN
Houston\Katy Area
Summary
Dynamic Business Systems Analyst with a strong background in healthcare analytics and data transformation. Proven track record in configuring Qualtrics XM Discover, achieving high data capture targets, and optimizing reporting efficiency. Expertise in developing custom dashboards and managing data workflows to support strategic business initiatives.
Overview
24
24
years of professional experience
Work History
Senior Business Systems Analyst / Senior Business Support Analyst
Edward Jones
Saint Louis
06.2022 - Current
- Engineered complex rule-based taxonomies and node hierarchies using Qualtrics syntax to categorize sentiment and effort metrics from unstructured customer feedback.
- Managed Qualtrics XM Discover configuration by establishing backend data pipelines and automated ingestion connectors for product reviews and support tickets.
- Validated text classification models using coverage matrices, precision testing on verbatim text samples, and recall tuning, contributing to 70–80% data capture targets.
- Facilitated migration from legacy 'rate this' platforms to modern Qualtrics feedback surveys, collaborating with digital product teams and documenting processes to streamline transition.
- Designed dashboards and managed operational data workflows to maintain consistent delivery of business-facing metrics supporting strategic alignment.
- Conducted validation testing to ensure accuracy and effectiveness of migrated processes during legacy system transitions.
- Optimized data transformation logic to format dates, text, and numeric scores for enhanced reporting efficiency.
- Oversaw environment security by organizing user project accounts, access controls, and role permissions, ensuring compliance for configuration analysts and dashboard viewers.
Business Intelligence Data Warehouse System Analyst
UT Health Science Center
Houston
11.2013 - 01.2022
- Served as primary developer for 'Third Next Available' metric reports and created custom ad-hoc dashboards integrating data from GE, Sunrise, and Allscripts databases, facilitating data-driven insights for stakeholders.
- Developed BI statistics, tree view documentation, KPI dashboards, drill-downs, and data mining metrics using Informatics (PBI) tools for GE Centricity Business Billing and Accounts Receivable (BAR) module, enhancing data visibility and decision-making.
- Analyzed revenue billing cycle discrepancies, invoice balances, batch errors, and month-end financial data points to ensure regulatory compliance, resulting in improved accuracy and reliability of financial reporting.
- Led system analysis and system implementation for the HCPC psychology clinic web reporting database structure; created fact/dimension tables, dictionaries, and automated ETL data files for AccuStream.
IDX Claims Programmer Analyst
AmeriPath Inc. (Quest Diagnostics)
Addison
03.2008 - 10.2013
- Directed Invoice Revenue Cycle Archive Project, reconciling historical zero-based claims from 2006 forward to ensure accuracy of invoice counts tied to financial reports.
- Programmed system variables and custom claims logic inside the GE/IDX BAR application environment utilizing MUMPS coding to generate HICFA paper bills and EDI 837 transaction formats.
- Executed data validation scripts and integrity checks to synchronize and maintain identical production and staging environments.
- Compiled table-to-cross maps and database interfaces to harmonize disparate enterprise data sources using Data Lever modeling software.
Systems Administrator / Systems Analyst
Perot Systems Corporation
Plano
11.2002 - 03.2008
- Administered and maintained MUMPS and Caché infrastructure on Alpha/VMS server platform for large-scale GE/IDX healthcare installations, ensuring system reliability and performance.
- Coded automated programs using Report Writer and Winbatch to streamline healthcare financial claims processing and system upgrades, enhancing disaster recovery plans and test environments.
- Formulated data-driven system enhancement strategies and presented findings to executive leadership at annual user conferences, influencing strategic decision-making.
Education
BS - Social Services and Social Work
Erskine College
Due West, SC 05-1982
Skills
- Qualtrics XM Discover
- Informatics (PBI)
- Tableau
- Data Integration
- SQL Queries
- ETL Modules
- SSIS
- Fact tables
- DBMS
- Excel Pivot Tables
- MS Access
- Automation Scripting
- Data Lever tool
- GE Centricity Business (BAR)
- Sunrise
- Allscripts
- Natural Language Processing
- Sentiment Calibration
- Coverage testing
- Node Hierarchies
- System Configurations
- Requirements Gathering
- Operational support
- Trend Analysis
- Enterprise System Architecture
- Cloud Infrastructure Management
Core Competencies
Qualtrics XM Discover, Tableau, Informatics (PBI), SSIS, ETL Modules, Fact/Dimension Tables, Excel Pivot Tables, MS Access, AI CoPilot testing and discovery, SQL Queries, MUMPS, Caché, DBMS, Data Lever (Enterprise Data Tool), Winbatch, GE Centricity Business (BAR), Sunrise, Allscripts, VMS Platform, Alpha/VMS, Linguistic Rule Crafting (AND/OR/NOT/NEAR Syntax), Node Hierarchies, Sentiment Calibration, Coverage & Precision Testing, System Configurations, Data Integration, Requirements Gathering, Operational Support, Trend Analysis, Disaster Recovery Planning
Timeline
Senior Business Systems Analyst / Senior Business Support Analyst
Edward Jones
06.2022 - Current
Business Intelligence Data Warehouse System Analyst
UT Health Science Center
11.2013 - 01.2022
IDX Claims Programmer Analyst
AmeriPath Inc. (Quest Diagnostics)
03.2008 - 10.2013
Systems Administrator / Systems Analyst
Perot Systems Corporation
11.2002 - 03.2008
BS - Social Services and Social Work
Erskine College