Enterprise File Validator

[aiman-mumtaz]

Hello Everyone,

I built a data validation solution to support the migration of a claims reporting platform from a legacy system to a modernised application, where ensuring output equivalence between systems was a critical requirement.

Live Demo: https://amumtaz-file-validator.streamlit.app/
Git Hub repo: https://github.com/aiman-mumtaz/file-validator

Tech Stack:
⁠Python,⁠ ⁠Streamlit, OpenPyXL

Features:

• ⁠Fixed-width file parsing driven by a mapping document
  • ⁠Field-level comparison using a base file as reference
  • ⁠Excel validation report with:
    1. Summary sheet
    2. Field-specific worksheets highlighting mismatches

I would love feedback, suggestions, or ideas to improve this project. I would love to explore how AI can be integrated to this project to improve functionality.

Also open to collaboration!

Thanks,
Aiman

[Rehheh011]

Nice work! This solves a very real problem that many migration projects face.

One feature that could add a lot of value would be anomaly detection. Instead of only comparing fields, the tool could learn the normal distribution of values from historical files and flag suspicious changes that technically match the mapping but look statistically unusual.

That could help catch migration issues that traditional field-by-field validation might miss.