James Volkman
Poulsbo
Summary
Dynamic Software Developer and Business Analyst with extensive experience, specializing in process automation and data analysis. Proven track record in enhancing revenue cycle management systems and implementing innovative solutions. Proficient in SQL and skilled in stakeholder communication, driving impactful results in complex projects.
Overview
24
24
years of professional experience
Work History
SOFTWARE DEVELOPER
Sj Technologies
01.2024 - 12.2024
- Reviewed, modified, developed, and implemented software applications
- Monitored and corrected software defects
- Assisted in the requirements, design, developing, supporting, and maintaining the Finvi Artiva revenue cycle management system
- Artiva Workflow design, automation, and administration
- Artiva script language, SQL, and InterSystems DBMS Caché
- Artiva Webstation customization
- Short-term contract with Bureau of Fiscal Service as part of the Cross Servicing Next Generation program that collects delinquent nontax debt owed to federal agencies.
BUSINESS ANALYST/HCX ADMINISTRATOR
Meduit
01.2023 - 12.2023
- Finvi Artiva HCx debt collection software platform scripting and testing
- InterSystems Caché multi-modal database SQL
- Provided support, development, automation, quality control, SQL, IT, and other functions as needed
- Assisted in troubleshooting and correcting software defects
- Identified, championed, and implemented process improvements
- Programming of account, payment, remit, demographic, and reconciliation interfaces
- Meduit is one of the leading Revenue Cycle Management solution providers in the U.S., serving more than 1,100 hospitals and large physician practices in 48 states. This was a short-term contract.
SOFTWARE DEVELOPER/BUSINESS ANALYST III
USCB America
01.2020 - 12.2021
- Finvi Artiva RM accounts receivable management development
- Reviewed, modified, developed, and implemented software applications
- Monitored and corrected software defects
- Computer programming (VB-like language), InterSystems Caché SQL, SAP Crystal Reports, Power BI, and MS PowerShell
- Business Analysis, Design, Testing, Implementation, and Quality Assurance Testing
- Development & Testing of Reports Manage Help Desk Queue
- Establish priorities, setting deadlines, and monitoring to ensure timely completion
- New client implementations for hospital chains and physician groups
- Programming of account, payment, remit, demographic, activity, and reconciliation interfaces
- Interface Development, Workflow, Scripting, Segmentation Filters, UI development, SQL, Advanced Troubleshooting
- USCB America provides revenue cycle solutions to the largest health care systems, hospitals, physician groups, and teaching institutions across the country. I was a Software Developer/Business Analyst reporting to the Manager of Information Systems.
DATABASE REPORT WRITER
UCB, Inc.
01.2019 - 12.2020
- Managed Help Desk Queue
- Assisted in troubleshooting and correcting software defects
- Interacted with customers to understand their needs
- Business Analysis, Design, Testing, Implementation, and Quality Assurance Testing
- Creating custom financial and operational reports and dashboards using Finvi Bridgeworks reporting tool, Columbia Ultimate (CUBS) collections software, Rocket Software, Universe ODBC SQL, Pick/Basic, MS Excel, Python, Power BI, and MS PowerShell
- Database Configuration, Development, and Testing
- Responding to data calls or ad hoc requests for information
- Worked with 3rd party vendors to onboard new software
- Reviewed, modified, developed, and implement software applications
- Partnered with data owners and stakeholders to understand database schemas, relationships, and data integrity requirements
- Designed intuitive, interactive dashboards and visualizations that aligned with business goals
- United Collection Bureau, Inc. (UCB) assists in the accounts receivable process for healthcare facilities, financial services businesses and government entities. I was a member of the application support and development team who reported to the VP of Information Systems.
DATA ANALYST
Apex Systems (Walgreens Contract)
01.2018 - 12.2018
- Reviewed work products and provided feedback
- Identified and documented detailed business rules and use cases based on requirements analysis
- Researched and resolved issues regarding integrity of data flow into databases
- Utilized data visualization tools to effectively communicate business insights
- Developed tables, views and materialized views using SQL, Access VBA, and MS Excel
- Vendor Rate Audit
- Data Validation
- Used Planview Enterprise Software, MS PowerPoint, MS Excel ODBC, MS Access VBA, and MS Power BI for vendor rate project
- Created advanced DAX measures to support KPIs, calculations, and analytical logic
- Built dashboards, reports, and visualizations to track KPIs and business performance
- Walgreens Boots Alliance is an integrated healthcare, pharmacy and retail leader serving millions of customers and patients. I was a contract Data Analyst who reported to the Senior Director of Digital Product Management.
DATA ANALYST
Recovery Management Services
01.2016 - 12.2017
- Reviewed, modified, developed, and implemented software applications
- Identified and documented detailed business rules and use cases based on requirements analysis
- Researched and resolved issues regarding integrity of data flow into databases
- Utilized data visualization tools to effectively communicate business insights
- Developed tables, views, stored procedures, triggers, and materialized views using SQL
- Managed key department business intelligence applications and data warehouse acting as technical liaison for data warehouse / contact management system issues
- Worked closely with business stakeholders to further enhance data warehouse/business intelligence environments to meet operational objectives
- Maintained ETL Workflows resulting in systems integration and/or business intelligence source table from multiple data sources and vendors
- Provided second tier production support for clients, troubleshooting authentication, and aggregation issues with third-party vendor application, performing data and root cause analysis, as well as executing and writing Custom database queries
- Custom programming using Genesys Latitude accounts receivable management software, MS T-SQL, MS PowerShell, and/or MS VBA
- Automation of large-scale data preparation, cleansing, and validation processes
- RMS works exclusively in the area of higher education debt collections including Perkins Loans, Health Profession Loans, Institutional Loans and Student Receivables. I was a Data Analyst reporting to both the I.T. Director and Director of Operations.
IT BUSINESS ANALYST
Harris & Harris, LTD
01.2015 - 12.2015
- Defined/improved business processes
- Researched and determined root causes of problems
- Supported Business Strategies Work with internal and external Healthcare and Municipal clients during integration of client processes and procedures using Finvi CUBS (Columbia Ultimate) Receivables Management Software
- Data analysis, design, and testing on custom programming applications between client and host system
- Troubleshot reported application issues
- Responsible for timely management of ticket queue in ticketing system, documentation of troubleshooting and resolution within the tickets, and client communications
- Custom reports via PICK/BASIC and/or Accuterm scripting
- Test and implementation of real-time payment processing
- Support leadership team with reporting, analysis and business presentations to inform divisional strategies
- New client implementations for hospital chains, municipalities, and utilities
- Performed customer segmentation and probability analysis to support targeted collection strategies
- Communicated directly with internal and external customers to understand their data needs, resolve quality issues, and meet key deadlines
- Harris & Harris is one of the nation's largest accounts receivable law firms. I was a Business Analyst reporting to the Director of Application Support.
DATABASE ANALYST
Diaz Anselmo & Associates LLC
01.2014 - 12.2014
- Financial Report and Process Automation via CLS Collection-Master, Python, MS Access VBA, MS Access SQL, Excel, and DOS scripting
- Analyzed potential alternatives to issues and presented proposals for resolution
- Worked directly with managers and end users in designing application enhancements
- Data Aggregation and Analysis
- Performed daily, weekly, and monthly routine client procedures
- Application support of Collection-Master Commercial Legal Software Collection System
- Translated complex data into clear, actionable insights for non-technical stakeholders
- Diaz Anselmo & Associates P.A., is a certified minority owned Martindale Hubbell Preeminent A-V rated firm and has provided legal services to the banking and mortgage industry, with an emphasis in Judicial State practice, for over 30 years. I was a Database Analyst reporting to the Director of Operations.
DATA ANALYST/SOFTWARE DEVELOPER
Compusystems, Inc.
01.2013 - 12.2013
- Design, code and debug applications in various software languages
- Initiate and complete project activities and work products to meet competing deadlines
- Ingres DBMS SQL Programming and maintenance of trade show industry databases
- Import, clean, transform, validate, and model data via UNIX, Linux, Perl
- Perform daily, weekly, and monthly routine client processes
- New client implementation support and testing
- Participate in client meetings to define show objectives and hold primary responsibility for timely delivery of all show requests
- CompuSystems, Inc. is a full-service event registration contractor and provider of data analytics and lead management services for live events, serving trade, association, corporate, and government event markets. I was a Data Analyst reporting to the Manager of Data Analysts/Web Programmers.
DATABASE PROJECT LEADER
Harris & Harris, LTD
01.2011 - 12.2012
- Program Analysis, Quality Control,and Testing for Third-Party programming consultants
- Worked with multiple vendors instituting ETL data processesand payment programming
- Letter design, testing,and mailings for government, utility, healthcare, retail, financial services, and credit card collections
- Finvi CUBS (Columbia Ultimate) Collections software support
- New client implementations Work with Client Services on Custom reporting, balance reconciliations, and inventory discrepancies
- Daily Operational Activities using Linux and Pick/BASIC
- Data Aggregation and Analysis
- Defined, analyzed, and troubleshot both internal and external end-user issues of various applications
- Communicated with both internal and external stakeholders through ticketing systems (Such as Jira) and documented those results
DATA ANALYST
TrueNorth AR/EOS CCA
01.2010 - 12.2010
- Report and Process Automation using Pick/DataBasic, VBScript, Accuterm Script, and Excel VBA
- Finvi CUBS Collections applications support
- Developed, optimized, and maintained complex SQL queries to support reporting, analytics, and operational data needs
- Develop collection workflow strategies, scoring, and analytics
- Outgoing Letter Development and Mailings
- Custom and ad-hoc reporting requests
DATA ANALYST
Financial Credit Network, Inc.
01.2008 - 12.2008
- Company-wide process improvement projects
- Finvi CUBS Receivables Management application support
- Report and Process Automation using MS VBScript, MS VBA, Accuterm Script, Microsoft Excel, and Active Perl
- Analyzed complex data sources and developed source-to-target mapping documents, including business transformation rules
- Technical support to both internal and external customers
- Custom and ad-hoc reporting requests
- Collector performance measurement by automating queries from the Finvi CUBS (Columbia Ultimate) collection system
- Regulatory compliance
DATA ANALYST
The Best Service Company
01.2007 - 12.2007
- Authored and presented briefings to management
- Documented business processes and procedures
- Maintenance of account workflow strategy in Finvi CUBS Account Flow Manager
- Participated in the planning, design, development, testing, and delivery of reports
- Created specifications for database/reports to meet business requirements
- Incorporated process automation
- Provided daily production support and ongoing maintenance for the enterprise data warehouse
- Outbound/Dialer Campaign Management using IAT CT Center
DATA ANALYST
Linebarger, Goggan, Blair & Sampson
01.2006 - 12.2006
- Developed and implemented Finvi CUBS (Columbia Ultimate) collections strategies
- Provided data and operational analysis
- Custom and ad-hoc report requests using MS Access, MS Excel, and MS VBA
- Designed and developed collection/call center analytics
- Collected, organized, and analyzed data from multiple sources including marketing funnels, CRM systems, call center operations, and financial reporting tools
- Supported Operations by analyzing call center metrics such as response times, agent performance, customer satisfaction, and efficiency trends
- Assisted in meeting client compliance and due diligence requirements
- Supported call center managers and staff
DATA ANALYST
Thornton Capital Advisors
01.2005 - 12.2005
- Analyzed, recommended, and implemented business process improvements
- Created and maintained a variety of performance reports using SQL Server and SAP Crystal Reports
- Developed front-end applications using .asp
- Incorporated process automation using Finvi Artiva, MS VBScript, and ProComm Aspect scripting
- Processed incoming/outgoing payments (lockbox processing)
- Instituted workflow management within the Finvi Artiva collection system
- Collected, analyzed, and interpreted large datasets to provide actionable insights that drove business decisions
- Created and managed predictive dialer campaigns using CT Vision (Finvi) Predictive Dialer
DATA ANALYST
ARS National Services
01.2003 - 12.2004
- Business Requirements Definition and Gathering.
- Created and implemented Columbia Ultimate CUBS collection strategies using work flow management software
- Worked closely with outside letter vendor(s) to manage over 7 million annual mailings
- Developed process automation and various scripts to reduce and/or eliminate daily tasks
- Supported collections analytics by applying credit scoring methodologies to new and existing accounts
- Performed a variety of data, financial, statistical and operational analysis
- Worked on a variety of small projects within/across departments directed towards process integration
- Created source-to-target mappings for data migration and integration
- Maintained and enhanced the IVR
DATA ANALYST
Nicor Gas
01.2001 - 12.2001
- Worked through full life cycle of various short and long-term projects with goals of achieving process improvement, cost savings, and increased revenue. Projects included meter inventory and reconciliation, gas loss, supercompressibility, pressure regulation, rate adjustments, etc…
- Data, statistical, gap, and financial analysis using ACL, MS Excel, MS Access, and various statistical programs
- Facilitated analysis and documentation for design of new business processes
- Facilitated team meetings Work with project managers, architects, and other team members to define metrics and performance goals for solutions
- Developed several standalone applications for co-workers using Visual Basic with Microsoft Access as back-end
- Worked with business units in identification of opportunities to increase revenues, reduce expenses, improve operational efficiency, maximize performance, minimize risk, and enhance customer loyalty
Education
MASTER OF SCIENCE - MANAGEMENT INFORMATION SYSTEMS
Northern Illinois University
04.2002
BACHELOR OF SCIENCE - MANAGEMENT INFORMATION SYSTEMS
Northern Illinois University
06.1999
Skills
- Business analysis and data analysis
- Process automation
- Project management
- Compliance oversight
- Technical Skills
- Database Management
- Report Writing
- Programming
- Software Development
- Data Visualization
- Customer Service
- Business Intelligence
- ETL Processes
- Automation
- Application Development
- Software Testing
- Healthcare
- FDCPA
- Metro 2
- TCPA
- HIPAA
- HL7
- X12 EDI
- RCM
- EDI transaction sets
- Agile Methodology
- Business Processes
- Data Modeling
- Data Mining
- Data Profiling
- Analytical Skills
- Data Governance
- Process Mapping
- ETL
- Quantitative Analysis
- Statistics
- Data Mapping
- Vendor Management
- Workflow Automation
- Financial Modeling
- SQL
- MS Access VBA
- MS Excel VBA
- Python
- Powershell
- Perl
- Bash
- Crystal Reports
- ServiceNow
- JIRA
- APIs
- Multivalue
- MS Project
- MS Visio
- MS Sharepoint
- IVR
- Various Dialers
- Workflow Management
- Ontario Reports
- ODBC
- Power BI
- Artiva RM
- Artiva HCx
- Various Help Desk
- XML
- T-SQL
- JSON
- EPIC Mapping
- Text Editors
- DAX
- MS Excel
- PICK/Basic
- MS Powerpoint
- Ticketing Systems
- SFTP/FTPS
- SSMS
- Intersystems Cache
- SQL Server
- Rocket Universe
- MySQL
- MariaDB
- MongoDB
- Ingres
- U2 Universe
- JBase
- Access
- SQLite
- PICK
- MS Access
- Unix/Linux
- Windows Server
- ETL Tools
- BI Platforms
- Finvi Artiva
- Genesys Latitude
- Vertican Collection-Master
- Columbia Ultimate CUBS
Timeline
SOFTWARE DEVELOPER
Sj Technologies
01.2024 - 12.2024
BUSINESS ANALYST/HCX ADMINISTRATOR
Meduit
01.2023 - 12.2023
SOFTWARE DEVELOPER/BUSINESS ANALYST III
USCB America
01.2020 - 12.2021
DATABASE REPORT WRITER
UCB, Inc.
01.2019 - 12.2020
DATA ANALYST
Apex Systems (Walgreens Contract)
01.2018 - 12.2018
DATA ANALYST
Recovery Management Services
01.2016 - 12.2017
IT BUSINESS ANALYST
Harris & Harris, LTD
01.2015 - 12.2015
DATABASE ANALYST
Diaz Anselmo & Associates LLC
01.2014 - 12.2014
DATA ANALYST/SOFTWARE DEVELOPER
Compusystems, Inc.
01.2013 - 12.2013
DATABASE PROJECT LEADER
Harris & Harris, LTD
01.2011 - 12.2012
DATA ANALYST
TrueNorth AR/EOS CCA
01.2010 - 12.2010
DATA ANALYST
Financial Credit Network, Inc.
01.2008 - 12.2008
DATA ANALYST
The Best Service Company
01.2007 - 12.2007
DATA ANALYST
Linebarger, Goggan, Blair & Sampson
01.2006 - 12.2006
DATA ANALYST
Thornton Capital Advisors
01.2005 - 12.2005
DATA ANALYST
ARS National Services
01.2003 - 12.2004
DATA ANALYST
Nicor Gas
01.2001 - 12.2001
MASTER OF SCIENCE - MANAGEMENT INFORMATION SYSTEMS
Northern Illinois University
BACHELOR OF SCIENCE - MANAGEMENT INFORMATION SYSTEMS
Northern Illinois University