Analyst with strong track record in delivering impactful business solutions. Adept at strategic planning, data analysis, and process improvement. Known for fostering team collaboration and adapting to evolving project needs. Brings expertise in client relations, problem-solving, and driving measurable results.
Overview
25
25
years of professional experience
Work History
CONSULTANT
Mapes LLC
Oviedo, Florida
01.2026 - 02.2026
Part-time consultant for the accounts receivable management industry
Analyze client needs to develop tailored consulting strategies.
SOFTWARE DEVELOPER
Sj Technologies
Sugar Hill, Georgia
01.2024 - 08.2024
Contributed to development, design, and maintenance of Finvi Artiva revenue cycle management system to ensure operational efficiency.
Reviewed, modified, developed, and implemented software applications to enhance functionality and user experience.
Monitored and resolved software defects to maintain system integrity and performance.
Designed and automated Artiva workflows to enhance efficiency.
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.
CAREER SABBATICAL
Myself
Poulsbo, Washington
07.2021 - 12.2023
Personal Sabbatical
BUSINESS ANALYST/HCx ADMINISTRATOR
Meduit RCM
Sartell, Minnesota
01.2023 - 06.2023
Provided Revenue Cycle Management (RCM) solutions to more than 1,100 hospitals and large physician practices in 48 states.
Developed and tested scripts for Finvi Artiva HCx debt collection software platform to enhance functionality.
Executed SQL queries to manage data effectively.
Troubleshot and resolved software defects, enhancing system reliability and user experience.
Delivered timely support by tracking issues and communicating resolutions to end users.
Collaborated with cross-functional teams to enhance operational workflows and efficiency.
Programmed interfaces for accounts, payments, remits, demographics, and reconciliations, streamlining data integration.
InterSystems Caché multi-model database
SOFTWARE DEVELOPER/BUSINESS ANALYST III
USCB America
Los Angeles, California
09.2020 - 07.2021
Provided revenue cycle management (RCM) solutions to the largest health care systems, hospitals, physician groups, and teaching institutions across the country.
Developed and implemented software applications, enhancing functionality and user experience
Monitored and resolved software defects, ensuring system reliability and performance
Computer programming (VBA-like language), InterSystems Caché SQL, SAP Crystal Reports, Power BI, and MS PowerShell
Business Analysis, Design, Testing, Implementation, and Quality Assurance Testing
Created and validated reports, ensuring accuracy and completeness for informed decision-making
New client implementations for hospital chains and physician groups
Programming of account, payment, remit, demographic, activity, and reconciliation interfaces
Finvi Artiva RM accounts receivable management development
DATABASE REPORT WRITER
UCB, Inc.
Toledo, Ohio
06.2018 - 09.2020
Assisted in the accounts receivable process for healthcare facilities, financial services businesses and government entities.
Developed custom financial and operational reports and dashboards using Finvi Bridgeworks, Columbia Ultimate (CUBS), Rocket Software, Universe ODBC SQL, Pick/Basic, MS Excel, Python, Power BI, and MS PowerShell to meet specific business needs.
Designed intuitive, interactive dashboards and visualizations that aligned with business goals
Business Analysis, Design, Testing, Implementation, and Quality Assurance Testing
Responded to data calls and ad hoc requests for information, providing accurate responses to stakeholders.
Partnered with data owners and stakeholders to understand database schemas, relationships, and data integrity requirements
Reviewed, modified, developed, and implemented software applications
Worked with 3rd party vendors to onboard new software
Assisted in troubleshooting and correcting software defects
Managed Help Desk Queue
DATA ANALYST
Apex Systems
Deerfield, Illinois
03.2018 - 06.2018
Facilitated the healthcare, pharmacy and retail of millions of customers and patients.
Leveraged data visualization tools to present actionable business insights
Built dashboards, reports, and visualizations to track KPIs and business performance
Developed advanced DAX measures to enhance KPI tracking and analytical accuracy
Developed tables, views, and materialized views using SQL, Access VBA, and MS Excel
Identified and documented detailed business rules and use cases based on requirements analysis
Researched and resolved issues regarding the integrity of data flow into databases
Used Planview Enterprise Software, MS PowerPoint, MS Excel ODBC, MS Access VBA, and MS Power BI for vendor rate project
Performed audit of vendor rates to ensure accuracy and compliance with standards
DATA ANALYST
Recovery Management Services
Warrenville, Illinois
05.2015 - 03.2018
Utilized data visualization tools to effectively communicate business insights
Identified and documented detailed business rules and use cases based on requirements analysis
Researched and resolved issues regarding the integrity of data flow into databases
Maintained ETL workflows for systems integration and business intelligence source tables from multiple data sources and vendors
Managed business intelligence applications and data warehouse, serving as technical liaison for data warehouse and contact management system issues
Worked closely with business stakeholders to further enhance data warehouse/business intelligence environments to meet operational objectives
Developed tables, views, stored procedures, triggers, and materialized views using SQL
Reviewed, modified, developed, and implemented software applications
Automated data preparation, cleansing, and validation processes to enhance data quality and accessibility
Provided second-tier production support for clients, troubleshooting authentication and aggregation issues with third-party vendor applications.
Performed custom programming using Genesys Latitude, MS T-SQL, MS PowerShell, and MS VBA
Worked exclusively in the area of higher education debt collections including Perkins Loans, Health Profession Loans, Institutional Loans and Student Receivables.
IT BUSINESS ANALYST
Harris & Harris, LTD
Chicago, Illinois
07.2014 - 05.2015
Collaborated with internal and external healthcare and municipal clients to integrate client processes and procedures using Finvi CUBS Receivables Management Software.
Data analysis, design, and testing of the custom programming applications between the client and host system
Defined/improved business processes
Researched root causes of issues to implement effective solutions
Troubleshot reported application issues
Managed ticket queue, documented troubleshooting and resolutions, and communicated with clients to ensure timely issue resolution
Developed custom reports using PICK/BASIC and Accuterm scripting to fulfill client requirements
Tested and implemented real-time payment processing
Supported leadership team with reporting, analysis and business presentations to inform divisional strategies
Performed custom segmentation and profitability 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
Worked with one of the nation's largest accounts receivable law firms specializing in healthcare, municipal, and energy receivables.
DATABASE ANALYST
Diaz Anselmo & Associates LLC
Naperville, Illinois
08.2013 - 07.2014
Financial Reporting and Process Automation via CLS Collection-Master, Python, MS Access VBA, MS Access SQL, Excel, and DOS scripting
Aggregated and analyzed data from multiple sources to support decision-making.
Converted complex data into actionable insights for non-technical stakeholders
Analyzed issues and proposed effective alternatives for resolution
Collaborated with managers and end users to design application enhancements and automate manual processes
Application support of Collection-Master Commercial Legal Software Collection System
Performed daily, weekly, and monthly routine client procedures
Provided legal services and collections to the banking and mortgage industries
DATA ANALYST/SOFTWARE DEVELOPER
Compusystems, Inc.
Lisle, Illinois
11.2012 - 08.2013
Designed, coded, and debugged applications in various software languages
Imported, cleaned, transformed, validated, and modeled data using UNIX, Linux, and Perl to ensure high-quality data for analysis
Managed large DBMS functionalities to optimize database performance. SQL Programming and maintenance of trade show industry databases
Initiated and completed project activities and work products to meet competing deadlines
Provided implementation support and testing for new clients to facilitate seamless onboarding
Executed routine client processes daily, weekly, and monthly to ensure consistent service delivery.
Facilitated client meetings to define show objectives and managed timely delivery of all show requests
Assisted with analytics and lead management services for live events, serving trade, association, corporate, and government event markets.
DATABASE PROJECT LEADER
Harris & Harris, LTD
Chicago, Illinois
09.2010 - 11.2012
Coordinated with multiple vendors to implement ETL data processes and enhance payment programming
Partnered with Client Services to develop custom reports, reconcile balances, and resolve inventory discrepancies
Diagnosed and resolved internal and external end-user issues across various applications
Program Analysis, Quality Control, and Testing for Third-Party programming consultants
Finvi CUBS (Columbia Ultimate) Collections software support
Managed letter design, testing, and mailings for government, utility, healthcare, retail, financial services, and credit card collections
Daily Operational Activities using Linux and Pick/BASIC
Utilized project management software tools to track project timelines, tasks, and deliverables.
Oversaw project lifecycle from initiation to closure, ensuring milestones and objectives were met.
DATA ANALYST
True North AR/EOS CCA
Novato, California
03.2010 - 09.2010
Developed, optimized, and maintained complex SQL queries to support reporting, analytics, and operational data needs
Maintained databases, ensuring accuracy and integrity of information used across departments.
Developed collection workflow strategies and analytics to enhance healthcare client outcomes
Automated reporting and processes using Pick/DataBasic, VBScript, Accuterm Script, and Excel VBA to improve operational efficiency
Finvi CUBS Collections applications support
Developed and mailed outgoing letters for client communications
DATA ANALYST
Financial Credit Network, Inc.
Visalia, California
02.2008 - 11.2008
Analyzed complex data sources and developed source-to-target mapping documents, including business transformation rules
Report and Process Automation using MS VBScript, MS VBA, Accuterm Script, Microsoft Excel, and Active Perl
Delivered custom and ad-hoc reports to meet specific stakeholder needs
Automated queries from Finvi CUBS collection system to enhance collector performance measurement
Instituted company-wide process improvement projects
Provided technical support for Finvi CUBS Receivables Management application to enhance user experience.
Technical support to both internal and external customers
Instituted processes to ensure regulatory compliance across operations
DATA ANALYST
The Best Service Company
Los Angeles, California
06.2007 - 11.2007
Led planning, design, development, testing, and delivery of reports to enhance data visibility
Collaborated with cross-functional teams to identify data requirements.
Delivered daily production support and maintained enterprise data warehouse to ensure data integrity
Implemented automation processes to improve efficiency
Analyzed large datasets to identify trends, patterns, and correlations for business insights.
Documented business processes and procedures
Performed maintenance of account workflow strategy in Finvi CUBS Account Flow Manager
Outbound/Dialer Campaign Management using IAT CT Center
DATA ANALYST
Linebarger, Goggan, Blair & Sampson
Austin, Texas
04.2006 - 04.2007
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
Delivered data analysis to inform operational decisions
Executed custom and ad-hoc report requests utilizing MS Access, MS Excel, and MS VBA
Developed and implemented Finvi CUBS (Columbia Ultimate) collections strategies
Assisted team in achieving client compliance and due diligence goals
DATA ANALYST
Thornton Capital Advisors
San Diego, California
11.2004 - 04.2006
Collected, analyzed, and interpreted large datasets to provide actionable insights that drove business decisions
Developed and maintained performance reports using SQL Server and SAP Crystal Reports to support data-driven decision-making
Collaborated with IT and business process owners to enhance system requirements for analytical purposes.
Automated processes with Finvi Artiva, MS VBScript, and ProComm Aspect scripting to enhance operational efficiency
Implemented workflow management processes to improve efficiency within the Finvi Artiva collection system
Managed predictive dialer campaigns using CT Vision (Finvi) Predictive Dialer to optimize outreach efforts
Conducted comprehensive data, financial, statistical, and operational analyses to inform decision-making
Applied credit scoring methodologies to optimize collections analytics for new and existing accounts
Created and implemented Columbia Ultimate CUBS collection strategies using workflow management software
Developed custom applications and various scripts to reduce and/or eliminate daily tasks
Created detailed source-to-target mappings for data integration projects, enhancing data migration and integration processes
Worked on a variety of small projects within/across departments, directed towards process integration
Worked closely with outside letter vendor(s) to manage over 7 million annual mailings
Managed and enhanced the IVR
DATA ANALYST
Nicor Gas
Naperville, Illinois
06.2001 - 02.2003
Conducted data analysis, including statistical, gap, and financial analysis, using ACL, MS Excel, MS Access, and various statistical programs to support data-driven decision-making.
Worked 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 a back-end
Managed full life cycle of short and long-term projects focused on process improvement and cost savings, including meter inventory reconciliation, gas loss analysis, and pressure regulation adjustments.
Facilitated analysis and documentation for design of new business processes
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 a back-end
Education
MASTER OF SCIENCE - MANAGEMENT INFORMATION SYSTEMS
Northern Illinois University
DeKalb, IL
04-2002
BACHELOR OF SCIENCE - OPERATIONS MANAGEMENT INFORMATION SYSTEMS
Northern Illinois University
DeKalb, IL
06-1999
Skills
Business Analysis
Data Analysis
Process Automation
Project Management
Compliance
Technical Skills
Database Management
Report Writing
Programming
Revenue Cycle Management
Accounting
Accounts Receivable Management
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
SDLC
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
SQLite
PICK
MS Access
D3/AIX
Unix/Linux
Windows Server
ETL Tools
BI Platforms
Finvi Artiva
Genesys Latitude
Vertican Collection-Master
Columbia Ultimate CUBS
ChatGPT/Claude
Julius AI
Problem-solving
Attention to detail
Team leadership & development
Client relationships
Timeline
CONSULTANT
Mapes LLC
01.2026 - 02.2026
SOFTWARE DEVELOPER
Sj Technologies
01.2024 - 08.2024
BUSINESS ANALYST/HCx ADMINISTRATOR
Meduit RCM
01.2023 - 06.2023
CAREER SABBATICAL
Myself
07.2021 - 12.2023
SOFTWARE DEVELOPER/BUSINESS ANALYST III
USCB America
09.2020 - 07.2021
DATABASE REPORT WRITER
UCB, Inc.
06.2018 - 09.2020
DATA ANALYST
Apex Systems
03.2018 - 06.2018
DATA ANALYST
Recovery Management Services
05.2015 - 03.2018
IT BUSINESS ANALYST
Harris & Harris, LTD
07.2014 - 05.2015
DATABASE ANALYST
Diaz Anselmo & Associates LLC
08.2013 - 07.2014
DATA ANALYST/SOFTWARE DEVELOPER
Compusystems, Inc.
11.2012 - 08.2013
DATABASE PROJECT LEADER
Harris & Harris, LTD
09.2010 - 11.2012
DATA ANALYST
True North AR/EOS CCA
03.2010 - 09.2010
DATA ANALYST
Financial Credit Network, Inc.
02.2008 - 11.2008
DATA ANALYST
The Best Service Company
06.2007 - 11.2007
DATA ANALYST
Linebarger, Goggan, Blair & Sampson
04.2006 - 04.2007
DATA ANALYST
Thornton Capital Advisors
11.2004 - 04.2006
DATA ANALYST
ARS National Services
02.2003 - 08.2004
DATA ANALYST
Nicor Gas
06.2001 - 02.2003
BACHELOR OF SCIENCE - OPERATIONS MANAGEMENT INFORMATION SYSTEMS
Northern Illinois University
MASTER OF SCIENCE - MANAGEMENT INFORMATION SYSTEMS