Support the end-to-end process of TPA claim transfers, ensuring clean and accurate data integration into Arch鈥檚 systems.
Review and validate claim mappings, including Claim Numbers, Claimant Numbers, and other key identifiers, between old and new TPA systems.
Confirm consistency of critical operational fields such as Policy Number, Accident Date, Reported Date, and Loss Details, ensuring no unauthorized changes or inconsistencies exist in transferred data.
Conduct financial reconciliation by comparing financial amounts and balances between old and new TPAs, ensuring alignment with Arch鈥檚 reporting and operational requirements.
Define and document business rules and data mappings for reporting and reconciliation processes.
Perform detailed data analysis using Excel and basic SQL queries to validate and troubleshoot data discrepancies.
Create and maintain clear user stories, process documentation, and business requirements.
Collaborate with TPAs, business users, and technical teams to track issues, manage dependencies, and maintain project timelines.
Provide UAT planning, execution, and documentation support, and documenting reconciliation results.
Effectively communicate issues, risks, and status updates to stakeholders and leadership.