Position 1 of 5
IS Technician
Strategic Fulfillment Group
Jul 2014–May 2016
New skills
DATABASE & DATA
- High-volume data extraction and delivery
- Data cleansing and normalization
- Data validation and reconciliation
- SQL Server / T-SQL query development
- CSV/file imports, exports and bulk data movement
- Campaign list selection, suppression, merge/purge and seeding
- USPS postal data cleansing and standardization
REPORTING & ANALYTICS
- Ad hoc SQL analysis, extracts and problem investigation
Programmer
Andrews Center Behavioral Health
May 2016–Nov 2016
New skills
DATABASE & DATA
- Complex SQL: joins, CASE, aggregations, CTEs and window functions
- Advanced T-SQL: dynamic SQL, temp tables, PIVOT/MERGE and procedural logic
- Stored procedures, functions, views and schemas
- Relational database/schema design and business-rule implementation
- ETL design, transformation and load processes
- SQL Agent scheduled jobs and database automation
- Database users, roles, permissions and junior DBA administration
REPORTING & ANALYTICS
- SSRS / paginated report design and development
- Complex report datasets, parameters, groups and drill-through
- Clinical data analysis and reporting
- Billing / financial data analysis and reporting
APPLICATIONS & INTEGRATIONS
- C# / .NET application development and maintenance
- ASP.NET / WebForms development and support
- JavaScript, HTML and CSS
- PHP development and maintenance
- WordPress website support
- Application troubleshooting, debugging and production support
- Testing, code review and release/hotfix validation
BUSINESS / SYSTEMS ANALYSIS & HEALTHCARE
- Translate business rules into SQL, reports, interfaces and application changes
- Behavioral-health EHR/application support and workflow improvement
- Clinical and billing data-model analysis
- User/vendor issue analysis and root-cause troubleshooting
Retained skills
DATABASE & DATA
- High-volume data extraction and delivery
- Data cleansing and normalization
- Data validation and reconciliation
- SQL Server / T-SQL query development
- CSV/file imports, exports and bulk data movement
REPORTING & ANALYTICS
- Ad hoc SQL analysis, extracts and problem investigation
Systems Analyst
Andrews Center Behavioral Health
Dec 2016–May 2021
New skills
DATABASE & DATA
- DB2-to-SQL Server EHR migration: mapping, transformation and validation
REPORTING & ANALYTICS
- Operational, KPI and performance-measure reporting
APPLICATIONS & INTEGRATIONS
- REST APIs, vendor interfaces and third-party integrations
- FTP/SFTP, file interfaces and automated data exchange
- Basic IIS / web-server configuration and support (junior familiarity)
BUSINESS / SYSTEMS ANALYSIS & HEALTHCARE
- Requirements gathering and stakeholder interviews
- Business process and workflow analysis
- Systems analysis and solution design
- UAT planning, test validation and acceptance support
- Technical documentation, runbooks and user/developer training
- Behavioral-health program reporting: 1115, DSRIP, CCBHC/TCCBHC, DPP & ARPA
DELIVERY & LEADERSHIP
- Project delivery across software, data, reporting and integration work
- Release/production support coordination and delivery reliability
- Vendor relationship and technical coordination
Retained skills
DATABASE & DATA
- High-volume data extraction and delivery
- Data cleansing and normalization
- Data validation and reconciliation
- SQL Server / T-SQL query development
- Complex SQL: joins, CASE, aggregations, CTEs and window functions
- Advanced T-SQL: dynamic SQL, temp tables, PIVOT/MERGE and procedural logic
- Stored procedures, functions, views and schemas
- Relational database/schema design and business-rule implementation
- ETL design, transformation and load processes
- CSV/file imports, exports and bulk data movement
- SQL Agent scheduled jobs and database automation
- Database users, roles, permissions and junior DBA administration
REPORTING & ANALYTICS
- SSRS / paginated report design and development
- Complex report datasets, parameters, groups and drill-through
- Clinical data analysis and reporting
- Billing / financial data analysis and reporting
- Ad hoc SQL analysis, extracts and problem investigation
APPLICATIONS & INTEGRATIONS
- C# / .NET application development and maintenance
- ASP.NET / WebForms development and support
- JavaScript, HTML and CSS
- PHP development and maintenance
- WordPress website support
- Application troubleshooting, debugging and production support
- Testing, code review and release/hotfix validation
BUSINESS / SYSTEMS ANALYSIS & HEALTHCARE
- Translate business rules into SQL, reports, interfaces and application changes
- Behavioral-health EHR/application support and workflow improvement
- Clinical and billing data-model analysis
- User/vendor issue analysis and root-cause troubleshooting
Developer & Support Analyst
Tejas Health Management Association
Jun 2021–Sep 2023
New skills
DATABASE & DATA
- Historical/audit data models, change logging and current-state views
- Batch/staging workflows with error handling, logging and history
REPORTING & ANALYTICS
- Power BI dashboard / report development
APPLICATIONS & INTEGRATIONS
- Blazor / DevExpress application development
- Basic PowerShell scripting (junior familiarity)
DELIVERY & LEADERSHIP
- Agile/Scrum delivery, backlog and priority management
- Azure DevOps boards, work items and delivery tracking
- Multi-client service delivery across behavioral-health organizations
- Client relationship and service ownership
Retained skills
DATABASE & DATA
- High-volume data extraction and delivery
- Data cleansing and normalization
- Data validation and reconciliation
- SQL Server / T-SQL query development
- Complex SQL: joins, CASE, aggregations, CTEs and window functions
- Advanced T-SQL: dynamic SQL, temp tables, PIVOT/MERGE and procedural logic
- Stored procedures, functions, views and schemas
- Relational database/schema design and business-rule implementation
- ETL design, transformation and load processes
- CSV/file imports, exports and bulk data movement
- SQL Agent scheduled jobs and database automation
- Database users, roles, permissions and junior DBA administration
REPORTING & ANALYTICS
- SSRS / paginated report design and development
- Complex report datasets, parameters, groups and drill-through
- Clinical data analysis and reporting
- Billing / financial data analysis and reporting
- Operational, KPI and performance-measure reporting
- Ad hoc SQL analysis, extracts and problem investigation
APPLICATIONS & INTEGRATIONS
- C# / .NET application development and maintenance
- ASP.NET / WebForms development and support
- JavaScript, HTML and CSS
- REST APIs, vendor interfaces and third-party integrations
- FTP/SFTP, file interfaces and automated data exchange
- Application troubleshooting, debugging and production support
- Testing, code review and release/hotfix validation
- Basic IIS / web-server configuration and support (junior familiarity)
BUSINESS / SYSTEMS ANALYSIS & HEALTHCARE
- Requirements gathering and stakeholder interviews
- Business process and workflow analysis
- Systems analysis and solution design
- Translate business rules into SQL, reports, interfaces and application changes
- UAT planning, test validation and acceptance support
- Behavioral-health EHR/application support and workflow improvement
- Clinical and billing data-model analysis
- User/vendor issue analysis and root-cause troubleshooting
- Technical documentation, runbooks and user/developer training
- Behavioral-health program reporting: 1115, DSRIP, CCBHC/TCCBHC, DPP & ARPA
DELIVERY & LEADERSHIP
- Project delivery across software, data, reporting and integration work
- Release/production support coordination and delivery reliability
- Vendor relationship and technical coordination
Manager, IT Services
Tejas Health Management Association
Oct 2023–Present
New skills
APPLICATIONS & INTEGRATIONS
- ChatGPT / Copilot for templating, scaffolding and debugging
DELIVERY & LEADERSHIP
- People management, performance oversight and coaching
- Staffing, scheduling, capacity planning and work allocation
- Cross-training, onboarding, standards and team process improvement
- Portfolio prioritization, governance and executive/operational reporting
- Shared-service program growth and client retention
Retained skills
DATABASE & DATA
- High-volume data extraction and delivery
- Data cleansing and normalization
- Data validation and reconciliation
- SQL Server / T-SQL query development
- Complex SQL: joins, CASE, aggregations, CTEs and window functions
- Advanced T-SQL: dynamic SQL, temp tables, PIVOT/MERGE and procedural logic
- Stored procedures, functions, views and schemas
- Relational database/schema design and business-rule implementation
- Historical/audit data models, change logging and current-state views
- ETL design, transformation and load processes
- Batch/staging workflows with error handling, logging and history
- CSV/file imports, exports and bulk data movement
- SQL Agent scheduled jobs and database automation
- Database users, roles, permissions and junior DBA administration
REPORTING & ANALYTICS
- SSRS / paginated report design and development
- Complex report datasets, parameters, groups and drill-through
- Clinical data analysis and reporting
- Billing / financial data analysis and reporting
- Operational, KPI and performance-measure reporting
- Ad hoc SQL analysis, extracts and problem investigation
- Power BI dashboard / report development
APPLICATIONS & INTEGRATIONS
- C# / .NET application development and maintenance
- ASP.NET / WebForms development and support
- Blazor / DevExpress application development
- JavaScript, HTML and CSS
- REST APIs, vendor interfaces and third-party integrations
- FTP/SFTP, file interfaces and automated data exchange
- Application troubleshooting, debugging and production support
- Testing, code review and release/hotfix validation
- Basic PowerShell scripting (junior familiarity)
- Basic IIS / web-server configuration and support (junior familiarity)
BUSINESS / SYSTEMS ANALYSIS & HEALTHCARE
- Requirements gathering and stakeholder interviews
- Business process and workflow analysis
- Systems analysis and solution design
- Translate business rules into SQL, reports, interfaces and application changes
- UAT planning, test validation and acceptance support
- Behavioral-health EHR/application support and workflow improvement
- Clinical and billing data-model analysis
- User/vendor issue analysis and root-cause troubleshooting
- Technical documentation, runbooks and user/developer training
- Behavioral-health program reporting: 1115, DSRIP, CCBHC/TCCBHC, DPP & ARPA
DELIVERY & LEADERSHIP
- Project delivery across software, data, reporting and integration work
- Agile/Scrum delivery, backlog and priority management
- Azure DevOps boards, work items and delivery tracking
- Release/production support coordination and delivery reliability
- Multi-client service delivery across behavioral-health organizations
- Client relationship and service ownership
- Vendor relationship and technical coordination
| Select a position | |||||
|---|---|---|---|---|---|
| New skills developed in this role | |||||
| DATABASE & DATA | |||||
| REPORTING & ANALYTICS | |||||
| APPLICATIONS & INTEGRATIONS | |||||
| BUSINESS / SYSTEMS ANALYSIS & HEALTHCARE | |||||
| DELIVERY & LEADERSHIP | |||||
| Retained skills | |||||
| DATABASE & DATA | |||||
| X | X | X | X | X | High-volume data extraction and delivery |
| X | X | X | X | X | Data cleansing and normalization |
| X | X | X | X | X | Data validation and reconciliation |
| X | X | X | X | X | SQL Server / T-SQL query development |
| X | X | X | X | Complex SQL: joins, CASE, aggregations, CTEs and window functions | |
| X | X | X | X | Advanced T-SQL: dynamic SQL, temp tables, PIVOT/MERGE and procedural logic | |
| X | X | X | X | Stored procedures, functions, views and schemas | |
| X | X | X | X | Relational database/schema design and business-rule implementation | |
| X | X | Historical/audit data models, change logging and current-state views | |||
| X | X | X | X | ETL design, transformation and load processes | |
| X | X | Batch/staging workflows with error handling, logging and history | |||
| X | X | X | X | X | CSV/file imports, exports and bulk data movement |
| X | X | X | X | SQL Agent scheduled jobs and database automation | |
| X | X | X | X | Database users, roles, permissions and junior DBA administration | |
| X | DB2-to-SQL Server EHR migration: mapping, transformation and validation | ||||
| X | Campaign list selection, suppression, merge/purge and seeding | ||||
| X | USPS postal data cleansing and standardization | ||||
| REPORTING & ANALYTICS | |||||
| X | X | X | X | SSRS / paginated report design and development | |
| X | X | X | X | Complex report datasets, parameters, groups and drill-through | |
| X | X | X | X | Clinical data analysis and reporting | |
| X | X | X | X | Billing / financial data analysis and reporting | |
| X | X | X | Operational, KPI and performance-measure reporting | ||
| X | X | X | X | X | Ad hoc SQL analysis, extracts and problem investigation |
| X | X | Power BI dashboard / report development | |||
| APPLICATIONS & INTEGRATIONS | |||||
| X | X | X | X | C# / .NET application development and maintenance | |
| X | X | X | X | ASP.NET / WebForms development and support | |
| X | X | Blazor / DevExpress application development | |||
| X | X | X | X | JavaScript, HTML and CSS | |
| X | X | PHP development and maintenance | |||
| X | X | WordPress website support | |||
| X | X | X | REST APIs, vendor interfaces and third-party integrations | ||
| X | X | X | FTP/SFTP, file interfaces and automated data exchange | ||
| X | X | X | X | Application troubleshooting, debugging and production support | |
| X | X | X | X | Testing, code review and release/hotfix validation | |
| X | X | Basic PowerShell scripting (junior familiarity) | |||
| X | X | X | Basic IIS / web-server configuration and support (junior familiarity) | ||
| X | ChatGPT / Copilot for templating, scaffolding and debugging | ||||
| BUSINESS / SYSTEMS ANALYSIS & HEALTHCARE | |||||
| X | X | X | Requirements gathering and stakeholder interviews | ||
| X | X | X | Business process and workflow analysis | ||
| X | X | X | Systems analysis and solution design | ||
| X | X | X | X | Translate business rules into SQL, reports, interfaces and application changes | |
| X | X | X | UAT planning, test validation and acceptance support | ||
| X | X | X | X | Behavioral-health EHR/application support and workflow improvement | |
| X | X | X | X | Clinical and billing data-model analysis | |
| X | X | X | X | User/vendor issue analysis and root-cause troubleshooting | |
| X | X | X | Technical documentation, runbooks and user/developer training | ||
| X | X | X | Behavioral-health program reporting: 1115, DSRIP, CCBHC/TCCBHC, DPP & ARPA | ||
| DELIVERY & LEADERSHIP | |||||
| X | X | X | Project delivery across software, data, reporting and integration work | ||
| X | X | Agile/Scrum delivery, backlog and priority management | |||
| X | X | Azure DevOps boards, work items and delivery tracking | |||
| X | X | X | Release/production support coordination and delivery reliability | ||
| X | X | Multi-client service delivery across behavioral-health organizations | |||
| X | X | Client relationship and service ownership | |||
| X | X | X | Vendor relationship and technical coordination | ||
| X | People management, performance oversight and coaching | ||||
| X | Staffing, scheduling, capacity planning and work allocation | ||||
| X | Cross-training, onboarding, standards and team process improvement | ||||
| X | Portfolio prioritization, governance and executive/operational reporting | ||||
| X | Shared-service program growth and client retention | ||||